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_CREDIT_CARD_WF

Line 1: PACKAGE BODY AP_WEB_CREDIT_CARD_WF AS

1: PACKAGE BODY AP_WEB_CREDIT_CARD_WF AS
2: /* $Header: apwccwfb.pls 120.61.12020000.2 2012/07/05 14:11:15 rveliche ship $ */
3:
4: /**** TEMP ***/
5: th_bgcolor varchar2(9) := '"#cccc99"';

Line 282: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendNotification',

278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: wf_engine.threshold := l_threshold;
282: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendNotification',
283: l_itemType, l_itemKey, to_char(0), l_debugInfo);
284: raise;
285: END;
286:

Line 482: 'plsql:AP_WEB_CREDIT_CARD_WF.getNumofUnsubmittedRecords/'||l_itemType||':'||l_itemKey);

478: --------------------------------------------------------------
479: WF_ENGINE.SetItemAttrText(l_itemType,
480: l_itemKey,
481: 'RECORDS_INSTR',
482: 'plsql:AP_WEB_CREDIT_CARD_WF.getNumofUnsubmittedRecords/'||l_itemType||':'||l_itemKey);
483:
484:
485: --------------------------------------------------------------
486: l_debugInfo := 'Set LIST value ';

Line 491: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.genUnsubmittedClobList/'||l_itemType||':'||l_itemKey);

487: --------------------------------------------------------------
488: WF_ENGINE.SetItemAttrText(l_itemType,
489: l_itemKey,
490: 'LIST',
491: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.genUnsubmittedClobList/'||l_itemType||':'||l_itemKey);
492:
493: WF_ENGINE.SetItemAttrText(l_itemType,
494: l_itemKey,
495: 'OIE_LIST',

Line 511: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendNotification',

507: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
508:
509: EXCEPTION
510: WHEN OTHERS THEN
511: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendNotification',
512: l_itemType, l_itemKey, to_char(0), l_debugInfo);
513: raise;
514: END;
515:

Line 1021: 'plsql:AP_WEB_CREDIT_CARD_WF.getNumofDunningRecords/'||l_itemType||':'||l_itemKey);

1017: --------------------------------------------------------------
1018: WF_ENGINE.SetItemAttrText(l_itemType,
1019: l_itemKey,
1020: 'RECORDS_INSTR',
1021: 'plsql:AP_WEB_CREDIT_CARD_WF.getNumofDunningRecords/'||l_itemType||':'||l_itemKey);
1022:
1023: --------------------------------------------------------------
1024: l_debugInfo := 'Set LIST value ';
1025: --------------------------------------------------------------

Line 1030: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateDunningClobList/'||l_itemType||':'||l_itemKey);

1026:
1027: WF_ENGINE.SetItemAttrText(l_itemType,
1028: l_itemKey,
1029: 'LIST',
1030: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateDunningClobList/'||l_itemType||':'||l_itemKey);
1031:
1032: WF_ENGINE.SetItemAttrText(l_itemType,
1033: l_itemKey,
1034: 'OIE_LIST',

Line 1052: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateDunningClobList/'||l_itemType||':'||l_itemKey);

1048:
1049: WF_ENGINE.SetItemAttrText(l_itemType,
1050: l_itemKey,
1051: 'LIST',
1052: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateDunningClobList/'||l_itemType||':'||l_itemKey);
1053:
1054: WF_ENGINE.SetItemAttrText(l_itemType,
1055: l_itemKey,
1056: 'OIE_LIST',

Line 1083: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateManagerDunningList/'||l_itemType||':'||l_itemKey);

1079:
1080: WF_ENGINE.SetItemAttrText(l_itemType,
1081: l_itemKey,
1082: 'LIST_ESC',
1083: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateManagerDunningList/'||l_itemType||':'||l_itemKey);
1084:
1085: WF_ENGINE.SetItemAttrText(l_itemType,
1086: l_itemKey,
1087: 'OIE_LIST_ESC',

Line 1110: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateNextManagerDunningList/'||l_itemType||':'||l_itemKey);

1106:
1107: WF_ENGINE.SetItemAttrText(l_itemType,
1108: l_itemKey,
1109: 'LIST_NEXT_ESC',
1110: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateNextManagerDunningList/'||l_itemType||':'||l_itemKey);
1111:
1112: WF_ENGINE.SetItemAttrText(l_itemType,
1113: l_itemKey,
1114: 'OIE_LIST_NEXT_ESC',

Line 1142: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'SendDunningNotifications',

1138: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
1139:
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'SendDunningNotifications',
1143: l_itemType, l_itemKey, to_char(0), l_debugInfo);
1144: raise;
1145: END;
1146: EXCEPTION

Line 1257: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendUnapprovedExpReportNote',

1253: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendUnapprovedExpReportNote',
1258: l_itemType, l_itemKey, to_char(0), l_debugInfo);
1259: raise;
1260: END;
1261:

Line 1400: 'plsql:AP_WEB_CREDIT_CARD_WF.generateList/'||l_itemType||':'||l_itemKey);

1396: --------------------------------------------------------------
1397: WF_ENGINE.SetItemAttrText(l_itemType,
1398: l_itemKey,
1399: 'LIST',
1400: 'plsql:AP_WEB_CREDIT_CARD_WF.generateList/'||l_itemType||':'||l_itemKey);
1401:
1402: WF_ENGINE.SetItemAttrText(l_itemType,
1403: l_itemKey,
1404: 'OIE_LIST',

Line 1415: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendDisputedChargesNote',

1411: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
1412:
1413: EXCEPTION
1414: WHEN OTHERS THEN
1415: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendDisputedChargesNote',
1416: l_itemType, l_itemKey, to_char(0), l_debugInfo);
1417: raise;
1418: END;
1419:

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 1632: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'GenerateUnsubmittedList',

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);
1634: raise;
1635:
1636: END GenerateUnsubmittedList;

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 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 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',

Line 4026: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'CallbackFunction',

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',
4027: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
4028: raise;
4029: END CallbackFunction;
4030:

Line 4032: END AP_WEB_CREDIT_CARD_WF;

4028: raise;
4029: END CallbackFunction;
4030:
4031:
4032: END AP_WEB_CREDIT_CARD_WF;