DBA Data[Home] [Help]

APPS.OE_VALIDATE_HEADER dependencies on FND_PROFILE

Line 655: l_check_duplicate :=nvl(FND_PROFILE.VALUE('ONT_ENFORCE_DUP_PO'),'Y');

651: l_duplicate_exists varchar2(1);
652: l_check_duplicate varchar2(1) :='Y'; --Added for 5053933
653: BEGIN
654: --Added for 5053933 start
655: l_check_duplicate :=nvl(FND_PROFILE.VALUE('ONT_ENFORCE_DUP_PO'),'Y');
656: if l_check_duplicate='Y' then
657: --Added for ER 4760436 end
658: SELECT /* MOAC_SQL_NO_CHANGE */ 'Y'
659: INTO l_duplicate_exists

Line 972: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');

968: BEGIN
969: oe_debug_pub.add('Enter OE_VALIDATE_HEADER.ENTITY',1);
970:
971: -- Check required attributes.
972: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
973: lcustomer_relations := OE_Sys_Parameters.VALUE('CUSTOMER_RELATIONSHIPS_FLAG');
974:
975: IF p_header_rec.header_id IS NULL
976: THEN

Line 1591: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');

1587: ('ship_to_org_id :'||to_char(p_header_rec.ship_to_org_id),2);
1588: oe_debug_pub.add
1589: ('Customer Relation :'||lcustomer_relations,2);
1590:
1591: --lcustomer_relations := FND_PROFILE.VALUE('ONT_CUSTOMER_RELATIONSHIPS');
1592:
1593: IF nvl(lcustomer_relations,'N') = 'N' THEN
1594: oe_debug_pub.add
1595: ('Cr: No',2);