eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_AUTOCREATE_DOC dependencies on FND_PROFILE

Line 5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');

1: PACKAGE BODY PO_AUTOCREATE_DOC AS
2: /* $Header: POXWATCB.pls 120.26 2008/02/19 03:49:27 adevadul ship $ */
3:
4: -- Read the profile option that enables/disables the debug log
5: g_po_wf_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('PO_SET_DEBUG_WORKFLOW_ON'),'N');
6:
7: /* Private Procedure/Function prototypes */
8:
9: FUNCTION valid_contact(p_vendor_site_id number, p_vendor_contact_id number) RETURN BOOLEAN;

Line 149: FND_PROFILE.get('USER_ID', l_user_id);

145:
146: --< Bug 3636669 Start >
147: -- Retrieve the current application context values. This assumes that
148: -- the application context has been set prior to calling this procedure.
149: FND_PROFILE.get('USER_ID', l_user_id);
150: FND_PROFILE.get('RESP_ID', l_responsibility_id);
151: FND_PROFILE.get('RESP_APPL_ID', l_application_id);
152:
153: -- Populate the application context workflow attributes

Line 150: FND_PROFILE.get('RESP_ID', l_responsibility_id);

146: --< Bug 3636669 Start >
147: -- Retrieve the current application context values. This assumes that
148: -- the application context has been set prior to calling this procedure.
149: FND_PROFILE.get('USER_ID', l_user_id);
150: FND_PROFILE.get('RESP_ID', l_responsibility_id);
151: FND_PROFILE.get('RESP_APPL_ID', l_application_id);
152:
153: -- Populate the application context workflow attributes
154: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype

Line 151: FND_PROFILE.get('RESP_APPL_ID', l_application_id);

147: -- Retrieve the current application context values. This assumes that
148: -- the application context has been set prior to calling this procedure.
149: FND_PROFILE.get('USER_ID', l_user_id);
150: FND_PROFILE.get('RESP_ID', l_responsibility_id);
151: FND_PROFILE.get('RESP_APPL_ID', l_application_id);
152:
153: -- Populate the application context workflow attributes
154: PO_WF_UTIL_PKG.SetItemAttrNumber( itemtype => itemtype
155: , itemkey => itemkey

Line 1004: fnd_profile.get('PO_AUTOCREATE_WARN_RFQ_REQUIRED', x_warn_rfq_required);

1000: * requestor (preparer) here and wait for a response that its ok
1001: * to go ahead, but for now we'll just fail the req line.
1002: */
1003:
1004: fnd_profile.get('PO_AUTOCREATE_WARN_RFQ_REQUIRED', x_warn_rfq_required);
1005:
1006: if ((x_warn_rfq_required = 'Y') AND
1007: (x_rfq_required_flag = 'Y') AND
1008: ((x_on_rfq_flag is NULL) OR (x_on_rfq_flag = 'N'))) then

Line 1449: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'

1445: AND POH.type_lookup_code = 'CONTRACT'
1446: /* R12 GCPA
1447: + If Profile ALLOW_REFERENCING_CPA_UNDER_AMENDMENT is Y, then we can refer any Contract Which is approved Once
1448: + Else Contract should be in APPROVED state */
1449: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'
1450: AND POH.Approved_Date Is Not Null
1451: )
1452: or ( POH.authorization_status = 'APPROVED' )
1453: )

Line 1481: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'

1477: /* R12 GCPA
1478: + If Profile ALLOW_REFERENCING_CPA_UNDER_AMENDMENT is Y, then we can refer any Contract Which is approved Once
1479: + Else Contract should be in APPROVED state
1480: */
1481: AND ( (NVL(FND_PROFILE.VALUE('ALLOW_REFERENCING_CPA_UNDER_AMENDMENT'),'N') = 'Y'
1482: AND POH.Approved_Date Is Not Null
1483: )
1484: or ( POH.authorization_status = 'APPROVED' )
1485: )

Line 3404: c1_deliver_to_location_code <> nvl(fnd_profile.value('POR_ONE_TIME_LOCATION'),-99) AND --bug 4449781 : added nvl

3400: OR
3401: ( /* (x_grouping_allowed = 'Y') AND Bug 2974129 */
3402: (x_group_one_time_address = 'Y' OR
3403: (x_group_one_time_address = 'N' AND
3404: c1_deliver_to_location_code <> nvl(fnd_profile.value('POR_ONE_TIME_LOCATION'),-99) AND --bug 4449781 : added nvl
3405: c2_deliver_to_location_code <> nvl(fnd_profile.value('POR_ONE_TIME_LOCATION'),-99))) AND
3406: (c1_suggested_buyer_id = c2_suggested_buyer_id) AND
3407: (c1_style_id = c2_style_id) AND --
3408: (c1_suggested_vendor_id = c2_suggested_vendor_id) AND

Line 3405: c2_deliver_to_location_code <> nvl(fnd_profile.value('POR_ONE_TIME_LOCATION'),-99))) AND

3401: ( /* (x_grouping_allowed = 'Y') AND Bug 2974129 */
3402: (x_group_one_time_address = 'Y' OR
3403: (x_group_one_time_address = 'N' AND
3404: c1_deliver_to_location_code <> nvl(fnd_profile.value('POR_ONE_TIME_LOCATION'),-99) AND --bug 4449781 : added nvl
3405: c2_deliver_to_location_code <> nvl(fnd_profile.value('POR_ONE_TIME_LOCATION'),-99))) AND
3406: (c1_suggested_buyer_id = c2_suggested_buyer_id) AND
3407: (c1_style_id = c2_style_id) AND --
3408: (c1_suggested_vendor_id = c2_suggested_vendor_id) AND
3409: (c1_suggested_vendor_site_id = c2_suggested_vendor_site_id) AND

Line 3810: x_created_by := to_number(FND_PROFILE.VALUE('user_id'));

3806: po_moac_utils_pvt.set_org_context(x_org_id); --
3807:
3808: /* Get user values */
3809:
3810: x_created_by := to_number(FND_PROFILE.VALUE('user_id'));
3811: x_last_updated_by := to_number(FND_PROFILE.VALUE('user_id'));
3812:
3813:
3814: /* Get the interface_header_id from the sequence */

Line 3811: x_last_updated_by := to_number(FND_PROFILE.VALUE('user_id'));

3807:
3808: /* Get user values */
3809:
3810: x_created_by := to_number(FND_PROFILE.VALUE('user_id'));
3811: x_last_updated_by := to_number(FND_PROFILE.VALUE('user_id'));
3812:
3813:
3814: /* Get the interface_header_id from the sequence */
3815:

Line 4273: x_created_by := to_number(FND_PROFILE.VALUE('user_id'));

4269: po_moac_utils_pvt.set_org_context(x_org_id); --
4270:
4271: /* Get user values */
4272:
4273: x_created_by := to_number(FND_PROFILE.VALUE('user_id'));
4274: x_last_updated_by := to_number(FND_PROFILE.VALUE('user_id'));
4275:
4276: /* FPI GA - If ga flag is Y then we create a standard PO */
4277:

Line 4274: x_last_updated_by := to_number(FND_PROFILE.VALUE('user_id'));

4270:
4271: /* Get user values */
4272:
4273: x_created_by := to_number(FND_PROFILE.VALUE('user_id'));
4274: x_last_updated_by := to_number(FND_PROFILE.VALUE('user_id'));
4275:
4276: /* FPI GA - If ga flag is Y then we create a standard PO */
4277:
4278: if x_source_doc_id is not null then