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.55.12010000.3 2008/08/19 06:55:54 sodash ship $ */
3:
4: /**** TEMP ***/
5: th_bgcolor varchar2(9) := '"#cccc99"';

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

270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: wf_engine.threshold := l_threshold;
274: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendNotification',
275: l_itemType, l_itemKey, to_char(0), l_debugInfo);
276: raise;
277: END;
278:

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

462: --------------------------------------------------------------
463: WF_ENGINE.SetItemAttrText(l_itemType,
464: l_itemKey,
465: 'RECORDS_INSTR',
466: 'plsql:AP_WEB_CREDIT_CARD_WF.getNumofUnsubmittedRecords/'||l_itemType||':'||l_itemKey);
467:
468:
469: --------------------------------------------------------------
470: l_debugInfo := 'Set LIST value ';

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

471: --------------------------------------------------------------
472: WF_ENGINE.SetItemAttrText(l_itemType,
473: l_itemKey,
474: 'LIST',
475: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.genUnsubmittedClobList/'||l_itemType||':'||l_itemKey);
476:
477: WF_ENGINE.SetItemAttrText(l_itemType,
478: l_itemKey,
479: 'OIE_LIST',

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

491: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendNotification',
496: l_itemType, l_itemKey, to_char(0), l_debugInfo);
497: raise;
498: END;
499:

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

949: --------------------------------------------------------------
950: WF_ENGINE.SetItemAttrText(l_itemType,
951: l_itemKey,
952: 'RECORDS_INSTR',
953: 'plsql:AP_WEB_CREDIT_CARD_WF.getNumofDunningRecords/'||l_itemType||':'||l_itemKey);
954:
955: --------------------------------------------------------------
956: l_debugInfo := 'Set LIST value ';
957: --------------------------------------------------------------

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

958:
959: WF_ENGINE.SetItemAttrText(l_itemType,
960: l_itemKey,
961: 'LIST',
962: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateDunningClobList/'||l_itemType||':'||l_itemKey);
963:
964: WF_ENGINE.SetItemAttrText(l_itemType,
965: l_itemKey,
966: 'OIE_LIST',

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

980:
981: WF_ENGINE.SetItemAttrText(l_itemType,
982: l_itemKey,
983: 'LIST',
984: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateDunningClobList/'||l_itemType||':'||l_itemKey);
985:
986: WF_ENGINE.SetItemAttrText(l_itemType,
987: l_itemKey,
988: 'OIE_LIST',

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

1011:
1012: WF_ENGINE.SetItemAttrText(l_itemType,
1013: l_itemKey,
1014: 'LIST_ESC',
1015: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateManagerDunningList/'||l_itemType||':'||l_itemKey);
1016:
1017: WF_ENGINE.SetItemAttrText(l_itemType,
1018: l_itemKey,
1019: 'OIE_LIST_ESC',

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

1038:
1039: WF_ENGINE.SetItemAttrText(l_itemType,
1040: l_itemKey,
1041: 'LIST_NEXT_ESC',
1042: 'plsqlclob:AP_WEB_CREDIT_CARD_WF.generateNextManagerDunningList/'||l_itemType||':'||l_itemKey);
1043:
1044: WF_ENGINE.SetItemAttrText(l_itemType,
1045: l_itemKey,
1046: 'OIE_LIST_NEXT_ESC',

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

1070: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
1071:
1072: EXCEPTION
1073: WHEN OTHERS THEN
1074: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'SendDunningNotifications',
1075: l_itemType, l_itemKey, to_char(0), l_debugInfo);
1076: raise;
1077: END;
1078: EXCEPTION

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

1185: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
1186:
1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendUnapprovedExpReportNote',
1190: l_itemType, l_itemKey, to_char(0), l_debugInfo);
1191: raise;
1192: END;
1193:

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

1322: --------------------------------------------------------------
1323: WF_ENGINE.SetItemAttrText(l_itemType,
1324: l_itemKey,
1325: 'LIST',
1326: 'plsql:AP_WEB_CREDIT_CARD_WF.generateList/'||l_itemType||':'||l_itemKey);
1327:
1328: WF_ENGINE.SetItemAttrText(l_itemType,
1329: l_itemKey,
1330: 'OIE_LIST',

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

1337: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
1338:
1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: Wf_Core.Context('AP_WEB_CREDIT_CARD_WF', 'sendDisputedChargesNote',
1342: l_itemType, l_itemKey, to_char(0), l_debugInfo);
1343: raise;
1344: END;
1345:

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

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);
1560: raise;
1561:
1562: END GenerateUnsubmittedList;

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

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

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',
3958: p_item_type, p_item_key, to_char(p_actid), l_debug_info);
3959: raise;
3960: END CallbackFunction;
3961:

Line 3963: END AP_WEB_CREDIT_CARD_WF;

3959: raise;
3960: END CallbackFunction;
3961:
3962:
3963: END AP_WEB_CREDIT_CARD_WF;