Home » Applications » Oracle Fusion Apps & E-Business Suite » Unable to make Required for one of the fields in AdditionalpersonDetails DFF in HR thru Custom.pll
Unable to make Required for one of the fields in AdditionalpersonDetails DFF in HR thru Custom.pll [message #145815] Sun, 06 November 2005 23:49
gi_srinivas
Messages: 19
Registered: September 2005
Location: Hyderan
Junior Member

Hi,
I need some help on this custom.pll code.
We created some Attributes in Additional Person Details DFF in Human Resources PERSON Form.
Now the requirement is, When the person type is Contract,We need to make one of the fields(Contract End Date)of DFF as Mandatory OR need to give a message.

Here in this code I am displaying a message also. This message is working fine while querying for the employees only and here that field is not getting mandatory(Required). When i created a new contract employee, neither the message is firing nor converting to Required field. Just Its saving the record.

But it should not be.

I used the following code in Cutsom.pll

******************************
If (form_name = 'PERWSHRG')and (block_name = 'PERSON') then
if (event_name = 'WHEN-VALIDATE-RECORD') then
a := name_in('PERSON.D_PERSON_TYPE_ID');
b := name_in('PERSON.ATTRIBUTE8');
IF (a = 'Contract') THEN
app_item_property2.set_property('PERSON.ATTRIBUTE8',Required,Property_On);

If (b is null) Then
FND_MESSAGE.SET_NAME ('FND', ' PLEASE ENTER CONTRACT END DATE FOR THIS STAFF.');
FND_MESSAGE.SHOW;
Raise form_trigger_failure;
End If; ---End if for inner if
end if; --End if for Contract value checking
end if; -- End if for WHEN-VALIDATE-RECORD
END IF; --End if for Form name and Block name
**************************

Hope I explained my problem better.

would appreciate any body can help me on this issue.
Thanks in advance.

Regards,
Srinivas

Previous Topic: Queries flexfield segment values
Next Topic: Oracle GL - Budget and Budget Organisation Definitions
Goto Forum:
  


Current Time: Mon May 13 15:00:48 CDT 2024