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_APPROVAL_REMINDER_SV 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_APPROVAL_REMINDER_SV AS
2: /* $Header: POXWARMB.pls 120.12 2007/12/04 09:16:04 bisdas 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: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7:
8: -- Item Type for the Reminder Workflow:
9: g_reminder_item_type CONSTANT VARCHAR2(20) := 'APVRMDER';

Line 6: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

2: /* $Header: POXWARMB.pls 120.12 2007/12/04 09:16:04 bisdas 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: g_fnd_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
7:
8: -- Item Type for the Reminder Workflow:
9: g_reminder_item_type CONSTANT VARCHAR2(20) := 'APVRMDER';
10: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_APPROVAL_REMINDER_SV';

Line 1643: fnd_profile.get('RESP_ID', l_responsibility_id);

1639: IF (g_po_wf_debug = 'Y') THEN
1640: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1641: END IF;
1642:
1643: fnd_profile.get('RESP_ID', l_responsibility_id);
1644: fnd_profile.get('RESP_APPL_ID', l_application_id);
1645: wf_engine.createProcess ( ItemType => l_ItemType,
1646: ItemKey => l_ItemKey,
1647: process => 'PO_APPROVAL_REMINDER' );

Line 1644: fnd_profile.get('RESP_APPL_ID', l_application_id);

1640: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1641: END IF;
1642:
1643: fnd_profile.get('RESP_ID', l_responsibility_id);
1644: fnd_profile.get('RESP_APPL_ID', l_application_id);
1645: wf_engine.createProcess ( ItemType => l_ItemType,
1646: ItemKey => l_ItemKey,
1647: process => 'PO_APPROVAL_REMINDER' );
1648:

Line 3255: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;

3251: l_amount_threshold NUMBER;
3252: l_completion_threshold NUMBER;
3253: l_contractor_or_job VARCHAR2(500);
3254: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3255: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3256: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3257: BEGIN
3258: -- Retrieve the profile options for the Reminder thresholds.
3259: BEGIN

Line 3256: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;

3252: l_completion_threshold NUMBER;
3253: l_contractor_or_job VARCHAR2(500);
3254: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3255: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3256: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3257: BEGIN
3258: -- Retrieve the profile options for the Reminder thresholds.
3259: BEGIN
3260: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';

Line 3261: l_amount_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));

3257: BEGIN
3258: -- Retrieve the profile options for the Reminder thresholds.
3259: BEGIN
3260: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';
3261: l_amount_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3262: l_profile_name := 'PO_SVC_COMPLETION_THRESHOLD';
3263: l_completion_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3264: EXCEPTION
3265: WHEN value_error THEN

Line 3263: l_completion_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));

3259: BEGIN
3260: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';
3261: l_amount_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3262: l_profile_name := 'PO_SVC_COMPLETION_THRESHOLD';
3263: l_completion_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3264: EXCEPTION
3265: WHEN value_error THEN
3266: SELECT user_profile_option_name
3267: INTO l_user_profile_name

Line 3268: FROM FND_PROFILE_OPTIONS_VL

3264: EXCEPTION
3265: WHEN value_error THEN
3266: SELECT user_profile_option_name
3267: INTO l_user_profile_name
3268: FROM FND_PROFILE_OPTIONS_VL
3269: WHERE profile_option_name = l_profile_name;
3270:
3271: FND_MESSAGE.set_name ('PO', 'PO_PROFILE_OPTION_NUMERIC');
3272: FND_MESSAGE.set_token ( 'PROFILE_OPTION', l_user_profile_name );