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.AP_WEB_CREDIT_CARD_WF dependencies on AP_WEB_UTILITIES_PKG

Line 1528: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GenerateUnsubmittedList');

1524: l_temp_clob CLOB;
1525: l_colon NUMBER;
1526:
1527: BEGIN
1528: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GenerateUnsubmittedList');
1529:
1530: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1531: GenUnsubmittedClobList(document_id,
1532: display_type,

Line 1555: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end GenerateUnsubmittedList');

1551: document := document || '';
1552:
1553: end if;
1554:
1555: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end GenerateUnsubmittedList');
1556: EXCEPTION
1557: WHEN OTHERS THEN
1558: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'GenerateUnsubmittedList',
1559: document_id, l_debug_info);

Line 1590: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

1586: l_expense_report_number VARCHAR2(60);
1587: l_expense_report_status VARCHAR2(30);
1588: l_displayed_status VARCHAR2(60);
1589: l_chargeType VARCHAR2(60);
1590: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
1591: l_title AK_REGIONS_VL.name%TYPE;
1592: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1593: l_detail_header_prompt VARCHAR2(200);
1594: l_document long;

Line 1776: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');

1772: l_temp_clob CLOB;
1773: l_colon NUMBER;
1774: BEGIN
1775:
1776: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');
1777:
1778: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1779: GenerateDunningClobList(document_id,
1780: display_type,

Line 1801: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');

1797: document := document || '';
1798:
1799: end if;
1800:
1801: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');
1802:
1803: EXCEPTION
1804: WHEN OTHERS THEN
1805: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningList',

Line 1846: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

1842: l_max_bucket NUMBER;
1843: l_min_bucket1 VARCHAR2(30);
1844: l_max_bucket1 VARCHAR2(30);
1845: l_instructions VARCHAR2(200);
1846: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
1847: l_title AK_REGIONS_VL.name%TYPE;
1848:
1849: --Notification Project
1850: l_document long ;

Line 2448: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

2444: l_min_bucket NUMBER;
2445: l_max_bucket NUMBER;
2446: l_min_bucket1 VARCHAR2(30);
2447: l_max_bucket1 VARCHAR2(30);
2448: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
2449: l_title AK_REGIONS_VL.name%TYPE;
2450:
2451: l_document long ;
2452: l_document_max NUMBER := 25000;

Line 2699: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

2695: l_min_bucket NUMBER;
2696: l_max_bucket NUMBER;
2697: l_min_bucket1 VARCHAR2(30);
2698: l_max_bucket1 VARCHAR2(30);
2699: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
2700: l_title AK_REGIONS_VL.name%TYPE;
2701:
2702: l_document long ;
2703: l_document_max NUMBER := 25000;

Line 3184: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));

3180: EXCEPTION
3181:
3182: WHEN OTHERS THEN
3183: BEGIN
3184: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3185:
3186: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');

Line 3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);

3187: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3188: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3189: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3190: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3191: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3192: END;
3193: END GetHierarchialEmployeeCursor;
3194: -----------------------------------------------
3195:

Line 3290: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsNotificationRepeated');

3286: p_result OUT NOCOPY VARCHAR2) IS
3287: ----------------------------------------------------------------------
3288:
3289: BEGIN
3290: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsNotificationRepeated');
3291: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3292: p_item_key,
3293: 'MGR_ALREADY_NOTIFIED');
3294: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsNotificationRepeated');

Line 3294: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsNotificationRepeated');

3290: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsNotificationRepeated');
3291: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3292: p_item_key,
3293: 'MGR_ALREADY_NOTIFIED');
3294: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsNotificationRepeated');
3295:
3296: END IsNotificationRepeated;
3297:
3298: --------------------------------------------------------------------

Line 3314: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start SendNotifications');

3310: p_result OUT NOCOPY VARCHAR2) IS
3311: ----------------------------------------------------------------------
3312:
3313: BEGIN
3314: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start SendNotifications');
3315: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3316: p_item_key,
3317: 'SEND_NOTIFICATIONS_PARAM');
3318: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end SendNotifications');

Line 3318: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end SendNotifications');

3314: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start SendNotifications');
3315: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3316: p_item_key,
3317: 'SEND_NOTIFICATIONS_PARAM');
3318: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end SendNotifications');
3319: END SendNotifications;
3320:
3321: ---------------------------------------------------------------------
3322:

Line 3339: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsFirstDunning');

3335: p_result OUT NOCOPY VARCHAR2) IS
3336: ----------------------------------------------------------------------
3337:
3338: BEGIN
3339: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsFirstDunning');
3340: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3341: p_item_key,
3342: 'FIRST_DUNNING');
3343: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsFirstDunning');

Line 3343: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsFirstDunning');

3339: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsFirstDunning');
3340: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3341: p_item_key,
3342: 'FIRST_DUNNING');
3343: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsFirstDunning');
3344:
3345: END IsFirstDunning;
3346:
3347: --------------------------------------------------------------------

Line 3598: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

3594: l_min_bucket NUMBER;
3595: l_max_bucket NUMBER;
3596: l_min_bucket1 VARCHAR2(30);
3597: l_max_bucket1 VARCHAR2(30);
3598: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
3599: l_title AK_REGIONS_VL.name%TYPE;
3600:
3601: l_document long ;
3602: l_document_max NUMBER := 25000;

Line 3850: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start CallbackFunction');

3846: l_card_prog_id Number;
3847:
3848: BEGIN
3849:
3850: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start CallbackFunction');
3851:
3852: begin
3853: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3854: p_item_key,

Line 3953: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end CallbackFunction');

3949: return;
3950: end if;
3951: */
3952:
3953: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end CallbackFunction');
3954:
3955: EXCEPTION
3956: WHEN OTHERS THEN
3957: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'CallbackFunction',