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 1602: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GenerateUnsubmittedList');

1598: l_temp_clob CLOB;
1599: l_colon NUMBER;
1600:
1601: BEGIN
1602: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GenerateUnsubmittedList');
1603:
1604: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1605: GenUnsubmittedClobList(document_id,
1606: display_type,

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

1625: document := document || '';
1626:
1627: end if;
1628:
1629: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end GenerateUnsubmittedList');
1630: EXCEPTION
1631: WHEN OTHERS THEN
1632: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'GenerateUnsubmittedList',
1633: document_id, l_debug_info);

Line 1664: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

1660: l_expense_report_number VARCHAR2(60);
1661: l_expense_report_status VARCHAR2(30);
1662: l_displayed_status VARCHAR2(60);
1663: l_chargeType VARCHAR2(60);
1664: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
1665: l_title AK_REGIONS_VL.name%TYPE;
1666: l_trxID AP_WEB_DB_CCARD_PKG.ccTrxn_trxID;
1667: l_detail_header_prompt VARCHAR2(200);
1668: l_document long;

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

1846: l_temp_clob CLOB;
1847: l_colon NUMBER;
1848: BEGIN
1849:
1850: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start GenerateDunningList');
1851:
1852: WF_NOTIFICATION.NewClob(l_temp_clob,document);
1853: GenerateDunningClobList(document_id,
1854: display_type,

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

1871: document := document || '';
1872:
1873: end if;
1874:
1875: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'end GenerateDunningList');
1876:
1877: EXCEPTION
1878: WHEN OTHERS THEN
1879: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GenerateDunningList',

Line 1920: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

1916: l_max_bucket NUMBER;
1917: l_min_bucket1 VARCHAR2(30);
1918: l_max_bucket1 VARCHAR2(30);
1919: l_instructions VARCHAR2(200);
1920: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
1921: l_title AK_REGIONS_VL.name%TYPE;
1922:
1923: --Notification Project
1924: l_document long ;

Line 2522: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

2518: l_min_bucket NUMBER;
2519: l_max_bucket NUMBER;
2520: l_min_bucket1 VARCHAR2(30);
2521: l_max_bucket1 VARCHAR2(30);
2522: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
2523: l_title AK_REGIONS_VL.name%TYPE;
2524:
2525: l_document long ;
2526: l_document_max NUMBER := 25000;

Line 2773: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

2769: l_min_bucket NUMBER;
2770: l_max_bucket NUMBER;
2771: l_min_bucket1 VARCHAR2(30);
2772: l_max_bucket1 VARCHAR2(30);
2773: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
2774: l_title AK_REGIONS_VL.name%TYPE;
2775:
2776: l_document long ;
2777: l_document_max NUMBER := 25000;

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

3253: EXCEPTION
3254:
3255: WHEN OTHERS THEN
3256: BEGIN
3257: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start GetHierarchialEmployeeCursor Exception p_supervisor_id='||to_char(p_supervisor_id));
3258:
3259: FND_MESSAGE.SET_NAME('SQLAP','AP_DEBUG');
3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');

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

3260: FND_MESSAGE.SET_TOKEN('ERROR',SQLERRM);
3261: FND_MESSAGE.SET_TOKEN('CALLING_SEQUENCE', 'GetHierarchialEmployeeCursor');
3262: FND_MESSAGE.SET_TOKEN('PARAMETERS','');
3263: FND_MESSAGE.SET_TOKEN('DEBUG_INFO',' ');
3264: AP_WEB_UTILITIES_PKG.DisplayException(fnd_message.get);
3265: END;
3266: END GetHierarchialEmployeeCursor;
3267: -----------------------------------------------
3268:

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

3359: p_result OUT NOCOPY VARCHAR2) IS
3360: ----------------------------------------------------------------------
3361:
3362: BEGIN
3363: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsNotificationRepeated');
3364: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3365: p_item_key,
3366: 'MGR_ALREADY_NOTIFIED');
3367: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsNotificationRepeated');

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

3363: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsNotificationRepeated');
3364: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3365: p_item_key,
3366: 'MGR_ALREADY_NOTIFIED');
3367: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsNotificationRepeated');
3368:
3369: END IsNotificationRepeated;
3370:
3371: --------------------------------------------------------------------

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

3383: p_result OUT NOCOPY VARCHAR2) IS
3384: ----------------------------------------------------------------------
3385:
3386: BEGIN
3387: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start SendNotifications');
3388: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3389: p_item_key,
3390: 'SEND_NOTIFICATIONS_PARAM');
3391: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end SendNotifications');

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

3387: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start SendNotifications');
3388: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3389: p_item_key,
3390: 'SEND_NOTIFICATIONS_PARAM');
3391: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end SendNotifications');
3392: END SendNotifications;
3393:
3394: ---------------------------------------------------------------------
3395:

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

3408: p_result OUT NOCOPY VARCHAR2) IS
3409: ----------------------------------------------------------------------
3410:
3411: BEGIN
3412: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsFirstDunning');
3413: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3414: p_item_key,
3415: 'FIRST_DUNNING');
3416: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsFirstDunning');

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

3412: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start IsFirstDunning');
3413: p_result := WF_ENGINE.GetItemAttrText(p_item_type,
3414: p_item_key,
3415: 'FIRST_DUNNING');
3416: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end IsFirstDunning');
3417:
3418: END IsFirstDunning;
3419:
3420: --------------------------------------------------------------------

Line 3667: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;

3663: l_min_bucket NUMBER;
3664: l_max_bucket NUMBER;
3665: l_min_bucket1 VARCHAR2(30);
3666: l_max_bucket1 VARCHAR2(30);
3667: l_prompts AP_WEB_UTILITIES_PKG.prompts_table;
3668: l_title AK_REGIONS_VL.name%TYPE;
3669:
3670: l_document long ;
3671: l_document_max NUMBER := 25000;

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

3915: l_card_prog_id Number;
3916:
3917: BEGIN
3918:
3919: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'start CallbackFunction');
3920:
3921: begin
3922: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3923: p_item_key,

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

4018: return;
4019: end if;
4020: */
4021:
4022: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_CREDIT_CARD_WF', 'end CallbackFunction');
4023:
4024: EXCEPTION
4025: WHEN OTHERS THEN
4026: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'CallbackFunction',