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.14.12020000.3 2013/02/10 21:21:21 vegajula 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.14.12020000.3 2013/02/10 21:21:21 vegajula 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 1673: fnd_profile.get('RESP_ID', l_responsibility_id);

1669: IF (g_po_wf_debug = 'Y') THEN
1670: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1671: END IF;
1672:
1673: fnd_profile.get('RESP_ID', l_responsibility_id);
1674: fnd_profile.get('RESP_APPL_ID', l_application_id);
1675: wf_engine.createProcess ( ItemType => l_ItemType,
1676: ItemKey => l_ItemKey,
1677: process => 'PO_APPROVAL_REMINDER' );

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

1670: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(l_itemtype,l_itemkey,l_progress);
1671: END IF;
1672:
1673: fnd_profile.get('RESP_ID', l_responsibility_id);
1674: fnd_profile.get('RESP_APPL_ID', l_application_id);
1675: wf_engine.createProcess ( ItemType => l_ItemType,
1676: ItemKey => l_ItemKey,
1677: process => 'PO_APPROVAL_REMINDER' );
1678:

Line 3289: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;

3285: l_amount_threshold NUMBER;
3286: l_completion_threshold NUMBER;
3287: l_contractor_or_job VARCHAR2(500);
3288: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3289: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3290: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3291: BEGIN
3292: -- Retrieve the profile options for the Reminder thresholds.
3293: BEGIN

Line 3290: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;

3286: l_completion_threshold NUMBER;
3287: l_contractor_or_job VARCHAR2(500);
3288: l_requester_id PO_REQUISITION_LINES.to_person_id%TYPE;
3289: l_profile_name FND_PROFILE_OPTIONS_VL.profile_option_name%TYPE;
3290: l_user_profile_name FND_PROFILE_OPTIONS_VL.user_profile_option_name%TYPE;
3291: BEGIN
3292: -- Retrieve the profile options for the Reminder thresholds.
3293: BEGIN
3294: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';

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

3291: BEGIN
3292: -- Retrieve the profile options for the Reminder thresholds.
3293: BEGIN
3294: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';
3295: l_amount_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3296: l_profile_name := 'PO_SVC_COMPLETION_THRESHOLD';
3297: l_completion_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3298: EXCEPTION
3299: WHEN value_error THEN

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

3293: BEGIN
3294: l_profile_name := 'PO_SVC_AMOUNT_THRESHOLD';
3295: l_amount_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3296: l_profile_name := 'PO_SVC_COMPLETION_THRESHOLD';
3297: l_completion_threshold := TO_NUMBER(FND_PROFILE.value(l_profile_name));
3298: EXCEPTION
3299: WHEN value_error THEN
3300: SELECT user_profile_option_name
3301: INTO l_user_profile_name

Line 3302: FROM FND_PROFILE_OPTIONS_VL

3298: EXCEPTION
3299: WHEN value_error THEN
3300: SELECT user_profile_option_name
3301: INTO l_user_profile_name
3302: FROM FND_PROFILE_OPTIONS_VL
3303: WHERE profile_option_name = l_profile_name;
3304:
3305: FND_MESSAGE.set_name ('PO', 'PO_PROFILE_OPTION_NUMERIC');
3306: FND_MESSAGE.set_token ( 'PROFILE_OPTION', l_user_profile_name );