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 WF_ENGINE

Line 103: l_threshold number := wf_engine.threshold;

99: l_itemType VARCHAR2(100) := 'APCCARD';
100: l_itemKey VARCHAR2(100);
101: l_employeeName wf_users.name%type;
102: l_employeeDisplayName wf_users.display_name%type;
103: l_threshold number := wf_engine.threshold;
104: l_debugInfo VARCHAR2(200);
105: l_account IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE := NULL;
106: l_invoiceNum AP_EXPENSE_REPORT_HEADERS_ALL.INVOICE_NUM%TYPE;
107: l_process_created VARCHAR2(1);

Line 115: wf_engine.threshold := -1;

111: ------------------------------------------------------------
112: l_debugInfo := 'Set WF threshold to defer this WF process';
113: ------------------------------------------------------------
114: if (p_deferred) then
115: wf_engine.threshold := -1;
116: end if;
117:
118: l_itemKey := GetNextCardNotificationID;
119:

Line 137: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_CARD_ISSUER');

133: --------------------------------------------------
134:
135: l_process_created := 'N';
136: if (p_paymentTo is not null AND p_paymentTo = c_paymentToCardIssuer) then
137: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_CARD_ISSUER');
138: l_process_created := 'Y';
139: elsif (p_paymentTo is not null AND p_paymentTo = c_voidPayment) then
140: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'VOID_PAYMENT_PROCESS');
141: l_process_created := 'Y';

Line 140: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'VOID_PAYMENT_PROCESS');

136: if (p_paymentTo is not null AND p_paymentTo = c_paymentToCardIssuer) then
137: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_CARD_ISSUER');
138: l_process_created := 'Y';
139: elsif (p_paymentTo is not null AND p_paymentTo = c_voidPayment) then
140: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'VOID_PAYMENT_PROCESS');
141: l_process_created := 'Y';
142: elsif (p_paymentMethod = c_directDeposit and p_paidAmount<>0) then
143: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_EMPLOYEE');
144: l_process_created := 'Y';

Line 143: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_EMPLOYEE');

139: elsif (p_paymentTo is not null AND p_paymentTo = c_voidPayment) then
140: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'VOID_PAYMENT_PROCESS');
141: l_process_created := 'Y';
142: elsif (p_paymentMethod = c_directDeposit and p_paidAmount<>0) then
143: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_EMPLOYEE');
144: l_process_created := 'Y';
145: elsif(p_paidAmount<>0) then
146: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_EMP_BY_CHECK');
147: l_process_created := 'Y';

Line 146: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_EMP_BY_CHECK');

142: elsif (p_paymentMethod = c_directDeposit and p_paidAmount<>0) then
143: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_EMPLOYEE');
144: l_process_created := 'Y';
145: elsif(p_paidAmount<>0) then
146: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'PAYMENT_TO_EMP_BY_CHECK');
147: l_process_created := 'Y';
148: end if;
149:
150: -- 8412820 : Attribute 'EXPENSE_REPORT_NUMBER' does not exist for item

Line 179: WF_ENGINE.SetItemAttrText(l_itemType,

175: l_invoiceNum := p_invoiceNumber;
176:
177: END IF;
178:
179: WF_ENGINE.SetItemAttrText(l_itemType,
180: l_itemKey,
181: 'EXPENSE_REPORT_NUMBER',
182: l_invoiceNum);
183: ----------------------------------------------------------

Line 186: WF_ENGINE.SetItemAttrText(l_itemType,

182: l_invoiceNum);
183: ----------------------------------------------------------
184: l_debugInfo := 'Set WF Amount Item Attribute';
185: ----------------------------------------------------------
186: WF_ENGINE.SetItemAttrText(l_itemType,
187: l_itemKey,
188: 'AMOUNT',
189: to_char(p_paidAmount, FND_CURRENCY.Get_Format_Mask(p_paymentCurrency,22)) || ' ' || p_paymentCurrency);
190:

Line 194: WF_ENGINE.SetItemAttrText(l_itemType,

190:
191: ----------------------------------------------------------
192: l_debugInfo := 'Set CURRENCY Item Attribute';
193: ----------------------------------------------------------
194: WF_ENGINE.SetItemAttrText(l_itemType,
195: l_itemKey,
196: 'CURRENCY',
197: p_paymentCurrency);
198:

Line 202: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);

198:
199: ----------------------------------------------------------
200: l_debugInfo := 'Set the Owner of Workflow Process.';
201: ----------------------------------------------------------
202: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);
203:
204: ------------------------------------------------------
205: l_debugInfo := 'Set WF EMPLOYEE_NAME Item Attribute';
206: ------------------------------------------------------

Line 207: WF_ENGINE.SetItemAttrText(l_itemType,

203:
204: ------------------------------------------------------
205: l_debugInfo := 'Set WF EMPLOYEE_NAME Item Attribute';
206: ------------------------------------------------------
207: WF_ENGINE.SetItemAttrText(l_itemType,
208: l_itemKey,
209: 'EMPLOYEE_NAME',
210: l_employeeName);
211:

Line 215: WF_ENGINE.SetItemAttrText(l_itemType,

211:
212: --------------------------------------------------------------
213: l_debugInfo := 'Set WF EMPLOYEE_DISPLAY_NAME Item Attribute';
214: --------------------------------------------------------------
215: WF_ENGINE.SetItemAttrText(l_itemType,
216: l_itemKey,
217: 'EMP_DISPLAY_NAME',
218: l_employeeDisplayName);
219:

Line 223: WF_ENGINE.SetItemAttrNumber(l_itemType,

219:
220: ------------------------------------------------------
221: l_debugInfo := 'Set WF Employee_ID Item Attribute';
222: ------------------------------------------------------
223: WF_ENGINE.SetItemAttrNumber(l_itemType,
224: l_itemKey,
225: 'EMPLOYEE_ID',
226: p_employeeId);
227: ------------------------------------------------------

Line 230: WF_ENGINE.SetItemAttrText(l_itemType,

226: p_employeeId);
227: ------------------------------------------------------
228: l_debugInfo := 'Set WF CHECK_NUMBER Item Attribute';
229: ------------------------------------------------------
230: WF_ENGINE.SetItemAttrText(l_itemType,
231: l_itemKey,
232: 'CHECK_NUMBER',
233: to_char(p_checkNumber));
234:

Line 240: WF_ENGINE.SetItemAttrText(l_itemType,

236: if (p_paymentTo is not null AND p_paymentTo = c_paymentToCardIssuer) then
237: ------------------------------------------------------
238: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
239: ------------------------------------------------------
240: WF_ENGINE.SetItemAttrText(l_itemType,
241: l_itemKey,
242: 'CREDIT_CARD_COMPANY',
243: p_cardIssuer);
244: ------------------------------------------------------

Line 247: WF_ENGINE.SetItemAttrText(l_itemType,

243: p_cardIssuer);
244: ------------------------------------------------------
245: l_debugInfo := 'Set WF PAYMENT_DATE Item Attribute';
246: ------------------------------------------------------
247: WF_ENGINE.SetItemAttrText(l_itemType,
248: l_itemKey,
249: 'PAYMENT_DATE',
250: p_paymentDate);
251: else -- payment to employee

Line 256: WF_ENGINE.SetItemAttrText(l_itemType,

252: if (p_paymentMethod = c_directDeposit) then
253: ------------------------------------------------------
254: l_debugInfo := 'Set WF BANK_ACCOUNT Item Attribute';
255: ------------------------------------------------------
256: WF_ENGINE.SetItemAttrText(l_itemType,
257: l_itemKey,
258: 'BANK_ACCOUNT',
259: l_account);
260:

Line 264: WF_ENGINE.SetItemAttrText(l_itemType,

260:
261: ------------------------------------------------------
262: l_debugInfo := 'Set WF BANK_NAME Item Attribute';
263: ------------------------------------------------------
264: WF_ENGINE.SetItemAttrText(l_itemType,
265: l_itemKey,
266: 'BANK_NAME',
267: p_bankName);
268: end if; -- p_paymentMethod = c_directDeposit

Line 276: WF_ENGINE.StartProcess(l_itemType,

272: BEGIN
273: ------------------------------------------------------------
274: l_debugInfo := 'Start the Expense Report Workflow Process';
275: ------------------------------------------------------------
276: WF_ENGINE.StartProcess(l_itemType,
277: l_itemKey);
278:
279: EXCEPTION
280: WHEN OTHERS THEN

Line 281: wf_engine.threshold := l_threshold;

277: l_itemKey);
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;

Line 287: wf_engine.threshold := l_threshold;

283: l_itemType, l_itemKey, to_char(0), l_debugInfo);
284: raise;
285: END;
286:
287: wf_engine.threshold := l_threshold;
288:
289: end if; -- nvl(l_process_created,'N') = 'Y'
290:
291: EXCEPTION

Line 374: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'UNSUBMITTED_CHARGES');

370:
371: --------------------------------------------------
372: l_debugInfo := 'Calling WorkFlow Create Process';
373: --------------------------------------------------
374: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'UNSUBMITTED_CHARGES');
375:
376: ----------------------------------------------------------
377: l_debugInfo := 'Set WF Amount Item Attribute';
378: ----------------------------------------------------------

Line 379: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',

375:
376: ----------------------------------------------------------
377: l_debugInfo := 'Set WF Amount Item Attribute';
378: ----------------------------------------------------------
379: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
380: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
381:
382: ----------------------------------------------------------
383: l_debugInfo := 'Set CURRENCY Item Attribute';

Line 385: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CURRENCY',p_currency);

381:
382: ----------------------------------------------------------
383: l_debugInfo := 'Set CURRENCY Item Attribute';
384: ----------------------------------------------------------
385: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CURRENCY',p_currency);
386:
387: ----------------------------------------------------------
388: l_debugInfo := 'Set the Owner of Workflow Process.';
389: ----------------------------------------------------------

Line 390: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);

386:
387: ----------------------------------------------------------
388: l_debugInfo := 'Set the Owner of Workflow Process.';
389: ----------------------------------------------------------
390: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);
391:
392: ------------------------------------------------------
393: l_debugInfo := 'Set WF EMPLOYEE_ID Item Attribute';
394: ------------------------------------------------------

Line 395: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID', p_employeeId);

391:
392: ------------------------------------------------------
393: l_debugInfo := 'Set WF EMPLOYEE_ID Item Attribute';
394: ------------------------------------------------------
395: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID', p_employeeId);
396:
397: ------------------------------------------------------
398: l_debugInfo := 'Set WF EMPLOYEE_NAME Item Attribute';
399: ------------------------------------------------------

Line 400: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMPLOYEE_NAME', l_employeeName);

396:
397: ------------------------------------------------------
398: l_debugInfo := 'Set WF EMPLOYEE_NAME Item Attribute';
399: ------------------------------------------------------
400: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMPLOYEE_NAME', l_employeeName);
401:
402: --------------------------------------------------------------
403: l_debugInfo := 'Set WF EMPLOYEE_DISPLAY_NAME Item Attribute';
404: --------------------------------------------------------------

Line 405: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);

401:
402: --------------------------------------------------------------
403: l_debugInfo := 'Set WF EMPLOYEE_DISPLAY_NAME Item Attribute';
404: --------------------------------------------------------------
405: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);
406:
407: ------------------------------------------------------
408: l_debugInfo := 'Set WF MANAGER_NAME Item Attribute';
409: ------------------------------------------------------

Line 410: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);

406:
407: ------------------------------------------------------
408: l_debugInfo := 'Set WF MANAGER_NAME Item Attribute';
409: ------------------------------------------------------
410: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);
411:
412: ------------------------------------------------------
413: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
414: ------------------------------------------------------

Line 415: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CREDIT_CARD_COMPANY', p_cardIssuer);

411:
412: ------------------------------------------------------
413: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
414: ------------------------------------------------------
415: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CREDIT_CARD_COMPANY', p_cardIssuer);
416:
417: --------------------------------------------------------------
418: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
419: --------------------------------------------------------------

Line 425: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID', l_cardProgramID);

421: l_cardProgramID ) ) THEN
422: NULL;
423: END IF;
424:
425: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID', l_cardProgramID);
426:
427: --------------------------------------------------------------
428: l_debugInfo := 'Get and Set ORG_ID attribute ';
429: --------------------------------------------------------------

Line 437: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'ORG_ID', l_orgId);

433: if l_orgId is null then
434: FND_PROFILE.GET('ORG_ID' , l_orgId );
435: end if;
436:
437: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'ORG_ID', l_orgId);
438:
439: ------------------------------------------------------
440: l_debugInfo := 'Set WF DATE1 Item Attribute';
441: ------------------------------------------------------

Line 442: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DATE1', p_date1);

438:
439: ------------------------------------------------------
440: l_debugInfo := 'Set WF DATE1 Item Attribute';
441: ------------------------------------------------------
442: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DATE1', p_date1);
443:
444: ------------------------------------------------------
445: l_debugInfo := 'Set WF DATE2 Item Attribute';
446: ------------------------------------------------------

Line 447: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DATE2', p_date2);

443:
444: ------------------------------------------------------
445: l_debugInfo := 'Set WF DATE2 Item Attribute';
446: ------------------------------------------------------
447: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DATE2', p_date2);
448:
449: ------------------------------------------------------
450: l_debugInfo := 'Set Charge Type Item Attribute';
451: ------------------------------------------------------

Line 452: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE', p_charge_type);

448:
449: ------------------------------------------------------
450: l_debugInfo := 'Set Charge Type Item Attribute';
451: ------------------------------------------------------
452: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE', p_charge_type);
453:
454: -- Bug 6886855 (sodash) setting the attribute MIN_AMOUNT
455: ------------------------------------------------------
456: l_debugInfo := 'Set WF MIN_AMOUNT Item Attribute';

Line 458: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT', p_min_amount);

454: -- Bug 6886855 (sodash) setting the attribute MIN_AMOUNT
455: ------------------------------------------------------
456: l_debugInfo := 'Set WF MIN_AMOUNT Item Attribute';
457: ------------------------------------------------------
458: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT', p_min_amount);
459:
460: ------------------------------------------------------
461: l_debugInfo := 'Set Send Notifications Item Attribute';
462: ------------------------------------------------------

Line 463: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications); -- Bug 6026927

459:
460: ------------------------------------------------------
461: l_debugInfo := 'Set Send Notifications Item Attribute';
462: ------------------------------------------------------
463: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications); -- Bug 6026927
464:
465:
466: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_FIRST_DUNNING');
467: l_instructions := FND_MESSAGE.GET;

Line 473: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);

469: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_FIRST_INSTR');
470: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
471: l_mgr_instructions := FND_MESSAGE.GET;
472:
473: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
474: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);
475:
476: --------------------------------------------------------------
477: l_debugInfo := 'Set NUM_RECORDS value ';

Line 474: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);

470: FND_MESSAGE.SET_TOKEN('EMPLOYEE_NAME', l_employeeDisplayName);
471: l_mgr_instructions := FND_MESSAGE.GET;
472:
473: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
474: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);
475:
476: --------------------------------------------------------------
477: l_debugInfo := 'Set NUM_RECORDS value ';
478: --------------------------------------------------------------

Line 479: WF_ENGINE.SetItemAttrText(l_itemType,

475:
476: --------------------------------------------------------------
477: l_debugInfo := 'Set NUM_RECORDS value ';
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:

Line 488: WF_ENGINE.SetItemAttrText(l_itemType,

484:
485: --------------------------------------------------------------
486: l_debugInfo := 'Set LIST value ';
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:

Line 493: 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',
496: 'JSP:/OA_HTML/OA.jsp?akRegionCode=UnSubmittedChargesRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&mgrList='||'N'||'&orgId='||l_orgId);
497:

Line 498: WF_ENGINE.SetItemAttrText(l_itemType,

494: l_itemKey,
495: 'OIE_LIST',
496: 'JSP:/OA_HTML/OA.jsp?akRegionCode=UnSubmittedChargesRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&mgrList='||'N'||'&orgId='||l_orgId);
497:
498: WF_ENGINE.SetItemAttrText(l_itemType,
499: l_itemKey,
500: 'MGR_LIST',
501: 'JSP:/OA_HTML/OA.jsp?akRegionCode=UnSubmittedChargesRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&mgrList='||'Y'||'&name='||l_employeeDisplayName||'&orgId='||l_orgId);
502:

Line 507: WF_ENGINE.StartProcess(l_itemType, l_itemKey);

503: BEGIN
504: ------------------------------------------------------------
505: l_debugInfo := 'Start the Expense Report Workflow Process';
506: ------------------------------------------------------------
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',

Line 682: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'DUNNING_NOTIFICATIONS');

678:
679: --------------------------------------------------
680: l_debugInfo := 'Calling WorkFlow Create Process';
681: --------------------------------------------------
682: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'DUNNING_NOTIFICATIONS');
683:
684: ----------------------------------------------------------
685: l_debugInfo := 'Set the Owner of Workflow Process.';
686: ----------------------------------------------------------

Line 687: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);

683:
684: ----------------------------------------------------------
685: l_debugInfo := 'Set the Owner of Workflow Process.';
686: ----------------------------------------------------------
687: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);
688:
689: ----------------------------------------------------------
690: l_debugInfo := 'Set the Subject';
691: ----------------------------------------------------------

Line 739: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);

735: l_mgr_esc_instructions := FND_MESSAGE.GET;
736:
737: end if;
738:
739: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
740: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);
741:
742: --Direct Report
743:

Line 740: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);

736:
737: end if;
738:
739: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'DUNNING_INSTR', l_instructions);
740: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_INSTR', l_mgr_instructions);
741:
742: --Direct Report
743:
744:

Line 746: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'Y');

742: --Direct Report
743:
744:
745: IF (p_dunning_number = 1 ) THEN
746: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'Y');
747: ELSE
748: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'N');
749: END IF;
750:

Line 748: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'N');

744:
745: IF (p_dunning_number = 1 ) THEN
746: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'Y');
747: ELSE
748: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'FIRST_DUNNING', 'N');
749: END IF;
750:
751: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_ADD_INSTR');
752: l_mgr_esc_add_instructions := FND_MESSAGE.GET;

Line 755: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);

751: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_ADD_INSTR');
752: l_mgr_esc_add_instructions := FND_MESSAGE.GET;
753:
754:
755: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);
756: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
757:
758:
759: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');

Line 756: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);

752: l_mgr_esc_add_instructions := FND_MESSAGE.GET;
753:
754:
755: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_INSTR', l_mgr_esc_instructions);
756: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
757:
758:
759: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');
760: l_next_mgr_esc_instr := FND_MESSAGE.GET;

Line 761: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_INSTR', l_next_mgr_esc_instr);

757:
758:
759: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');
760: l_next_mgr_esc_instr := FND_MESSAGE.GET;
761: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_INSTR', l_next_mgr_esc_instr);
762:
763: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
764:
765:

Line 763: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_ADD_INSTR', l_mgr_esc_add_instructions);

759: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_INSTR');
760: l_next_mgr_esc_instr := FND_MESSAGE.GET;
761: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_INSTR', l_next_mgr_esc_instr);
762:
763: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_ADD_INSTR', l_mgr_esc_add_instructions);
764:
765:
766: --Amulya Mishra : Notification Esc Project
767:

Line 771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);

767:
768: FND_MESSAGE.SET_NAME('SQLAP','OIE_ADD_INFO_DUNNING');
769: FND_MESSAGE.SET_TOKEN('days', nvl(p_grace_days,0));
770: l_add_instructions := FND_MESSAGE.GET;
771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
772:
773: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
774: l_notes := FND_MESSAGE.GET;
775: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NOTES', l_notes);

Line 775: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NOTES', l_notes);

771: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'ADD_INSTRUCTIONS', l_add_instructions);
772:
773: FND_MESSAGE.SET_NAME('SQLAP','OIE_NOTES_DUNNING');
774: l_notes := FND_MESSAGE.GET;
775: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NOTES', l_notes);
776:
777: --determining SUP1 and SUP2
778:
779:

Line 849: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);

845: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_NTF_DUNNING');
846: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
847: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
848: l_mgmt_instructions := FND_MESSAGE.GET;
849: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
850:
851: IF (p_dunning_number = 1) THEN
852:
853: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_NTF_DUNNING1');

Line 865: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);

861: FND_MESSAGE.SET_TOKEN('SUP2', l_sup2_manager_display_name);
862: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
863:
864: END IF;
865: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
866:
867: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
868: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
869: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;

Line 870: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);

866:
867: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_NTF');
868: FND_MESSAGE.SET_TOKEN('SUP1', l_sup2_manager_display_name);
869: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
870: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
871:
872:
873: ELSIF (p_dunning_number = 4 OR l_sup2_manager_display_name IS NULL OR l_managerDisplayName = l_sup2_manager_display_name) THEN
874:

Line 878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);

874:
875: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_LAST_MGR_NTF_DUNNING');
876: FND_MESSAGE.SET_TOKEN('SUP1', l_managerDisplayName);
877: l_mgmt_instructions := FND_MESSAGE.GET;
878: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_INSTR', l_mgmt_instructions);
879:
880: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
881: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;

Line 883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);

879:
880: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_MGR_ESC_LAST_NTF_DUNN');
881: FND_MESSAGE.SET_TOKEN('SUP2', l_managerDisplayName);
882: l_mgr_esc_mgmt_instructions := FND_MESSAGE.GET;
883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
884:
885: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
886: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
887: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);

Line 887: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);

883: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_ESC_INSTR', l_mgr_esc_mgmt_instructions);
884:
885: FND_MESSAGE.SET_NAME('SQLAP','OIE_CC_NEXT_MGR_ESC_LAST_NTF');
886: l_next_mgr_esc_mgmt_instr := FND_MESSAGE.GET;
887: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGMT_NEXT_ESC_INSTR', l_next_mgr_esc_mgmt_instr);
888:
889:
890: END IF;
891:

Line 899: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'TOTAL_OUTSTANDING',

895: l_total_amount ) ) THEN
896: NULL;
897: END IF;
898:
899: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'TOTAL_OUTSTANDING',
900: to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
901:
902:
903: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications);

Line 903: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications);

899: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'TOTAL_OUTSTANDING',
900: to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
901:
902:
903: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications);
904: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS',nvl(p_grace_days,0));
905:
906: --AMulya Mishra : Notification Esc Project
907:

Line 904: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS',nvl(p_grace_days,0));

900: to_char(l_total_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
901:
902:
903: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'SEND_NOTIFICATIONS_PARAM',p_send_notifications);
904: WF_ENGINE.setItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS',nvl(p_grace_days,0));
905:
906: --AMulya Mishra : Notification Esc Project
907:
908: ------------------------------------------------------

Line 911: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMPLOYEE_NAME', l_employeeName);

907:
908: ------------------------------------------------------
909: l_debugInfo := 'Set WF EMPLOYEE_NAME Item Attribute';
910: ------------------------------------------------------
911: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMPLOYEE_NAME', l_employeeName);
912:
913: --------------------------------------------------------------
914: l_debugInfo := 'Set WF EMP_DISPLAY_NAME Item Attribute';
915: --------------------------------------------------------------

Line 916: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);

912:
913: --------------------------------------------------------------
914: l_debugInfo := 'Set WF EMP_DISPLAY_NAME Item Attribute';
915: --------------------------------------------------------------
916: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);
917:
918: --------------------------------------------------------------
919: l_debugInfo := 'Set WF EMPLOYEE_ID Item Attribute';
920: --------------------------------------------------------------

Line 921: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID', p_employeeID);

917:
918: --------------------------------------------------------------
919: l_debugInfo := 'Set WF EMPLOYEE_ID Item Attribute';
920: --------------------------------------------------------------
921: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID', p_employeeID);
922:
923: ------------------------------------------------------
924: l_debugInfo := 'Set WF MANAGER_NAME Item Attribute';
925: ------------------------------------------------------

Line 930: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);

926: l_temp_mgr_name := l_managerName;
927: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_managerId, p_surrogate_mgr_id)) THEN
928: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);
929: END IF;
930: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);
931: --WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);
932:
933: --Amulya Mishra : Notification Esc Project
934:

Line 931: --WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);

927: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_managerId, p_surrogate_mgr_id)) THEN
928: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);
929: END IF;
930: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);
931: --WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);
932:
933: --Amulya Mishra : Notification Esc Project
934:
935: IF (P_send_notifications = 'ES') THEN

Line 937: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ALREADY_NOTIFIED', p_manager_notified);

933: --Amulya Mishra : Notification Esc Project
934:
935: IF (P_send_notifications = 'ES') THEN
936:
937: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ALREADY_NOTIFIED', p_manager_notified);
938: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NEXT_MANAGER_NAME', l_temp_mgr_name);
939: WF_DIRECTORY.GetUserName('PER', l_orig_manager_id, l_managerName, l_managerDisplayName);
940: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_orig_manager_id, p_surrogate_mgr_id)) THEN
941: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);

Line 938: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NEXT_MANAGER_NAME', l_temp_mgr_name);

934:
935: IF (P_send_notifications = 'ES') THEN
936:
937: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ALREADY_NOTIFIED', p_manager_notified);
938: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'NEXT_MANAGER_NAME', l_temp_mgr_name);
939: WF_DIRECTORY.GetUserName('PER', l_orig_manager_id, l_managerName, l_managerDisplayName);
940: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(p_employeeId, l_orig_manager_id, p_surrogate_mgr_id)) THEN
941: WF_DIRECTORY.GetUserName('PER', p_surrogate_mgr_id, l_temp_mgr_name, l_temp_mgr_dname);
942: ELSE

Line 946: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);

942: ELSE
943: l_temp_mgr_name := l_managerName;
944: END IF;
945:
946: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);
947:
948: ELSE
949:
950: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);

Line 950: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);

946: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);
947:
948: ELSE
949:
950: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_temp_mgr_name);
951:
952: END IF;
953: --store latest manager id to workflow so that later it can be used.
954:

Line 955: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'AGING_MANAGER_ID', l_managerId);

951:
952: END IF;
953: --store latest manager id to workflow so that later it can be used.
954:
955: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'AGING_MANAGER_ID', l_managerId);
956:
957: --Bug 3337388
958:
959: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER', p_dunning_number);

Line 959: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER', p_dunning_number);

955: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'AGING_MANAGER_ID', l_managerId);
956:
957: --Bug 3337388
958:
959: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER', p_dunning_number);
960:
961: --Amulya Mishra : Notification Esc project
962:
963: --------------------------------------------------------------

Line 966: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID', p_cardProgramID);

962:
963: --------------------------------------------------------------
964: l_debugInfo := 'Set WF CARD_PROG_ID Item Attribute';
965: --------------------------------------------------------------
966: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID', p_cardProgramID);
967:
968: --------------------------------------------------------------
969: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
970: --------------------------------------------------------------

Line 976: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CREDIT_CARD_COMPANY', l_cardProgramName);

972: l_cardProgramName ) ) THEN
973: NULL;
974: END IF;
975:
976: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CREDIT_CARD_COMPANY', l_cardProgramName);
977:
978:
979: ----------------------------------------------------------
980: l_debugInfo := 'Set CURRENCY Item Attribute';

Line 982: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CURRENCY',p_currency);

978:
979: ----------------------------------------------------------
980: l_debugInfo := 'Set CURRENCY Item Attribute';
981: ----------------------------------------------------------
982: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CURRENCY',p_currency);
983:
984: ------------------------------------------------------
985: l_debugInfo := 'Set Amount Item Attribute';
986: ------------------------------------------------------

Line 987: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',

983:
984: ------------------------------------------------------
985: l_debugInfo := 'Set Amount Item Attribute';
986: ------------------------------------------------------
987: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
988: to_char(p_Amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
989:
990:
991: ------------------------------------------------------

Line 994: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET1', to_char(p_min_bucket));

990:
991: ------------------------------------------------------
992: l_debugInfo := 'Set WF BUCKET1..2 Item Attribute';
993: ------------------------------------------------------
994: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET1', to_char(p_min_bucket));
995: if( p_max_bucket = 1000000) then
996: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', l_plus_sign);
997: else
998: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', '- '||to_char(p_max_bucket));

Line 996: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', l_plus_sign);

992: l_debugInfo := 'Set WF BUCKET1..2 Item Attribute';
993: ------------------------------------------------------
994: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET1', to_char(p_min_bucket));
995: if( p_max_bucket = 1000000) then
996: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', l_plus_sign);
997: else
998: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', '- '||to_char(p_max_bucket));
999: end if;
1000:

Line 998: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', '- '||to_char(p_max_bucket));

994: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET1', to_char(p_min_bucket));
995: if( p_max_bucket = 1000000) then
996: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', l_plus_sign);
997: else
998: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'BUCKET2', '- '||to_char(p_max_bucket));
999: end if;
1000:
1001:
1002:

Line 1013: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'ORG_ID', l_orgId);

1009: if l_orgId is null then
1010: FND_PROFILE.GET('ORG_ID' , l_orgId );
1011: end if;
1012:
1013: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'ORG_ID', l_orgId);
1014:
1015: --------------------------------------------------------------
1016: l_debugInfo := 'Set NUM_RECORDS value ';
1017: --------------------------------------------------------------

Line 1018: WF_ENGINE.SetItemAttrText(l_itemType,

1014:
1015: --------------------------------------------------------------
1016: l_debugInfo := 'Set NUM_RECORDS value ';
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:

Line 1027: WF_ENGINE.SetItemAttrText(l_itemType,

1023: --------------------------------------------------------------
1024: l_debugInfo := 'Set LIST value ';
1025: --------------------------------------------------------------
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:

Line 1032: 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',
1035: 'JSP:/OA_HTML/OA.jsp?akRegionCode=DunningRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&graceDays='||p_grace_days||'&escNotif='||'N'||'&mgrList='||'N'||'&orgId='||l_orgId);
1036:

Line 1040: WF_ENGINE.SetItemAttrText(l_itemType,

1036:
1037: --------------------------------------------------------------
1038: l_debugInfo := 'Set MGR_LIST value ';
1039: --------------------------------------------------------------
1040: WF_ENGINE.SetItemAttrText(l_itemType,
1041: l_itemKey,
1042: 'MGR_LIST',
1043: 'JSP:/OA_HTML/OA.jsp?akRegionCode=DunningRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&graceDays='||p_grace_days||'&escNotif='||'N'||'&mgrList='||'Y'||'&name='||l_employeeName||'&orgId='||l_orgId);
1044:

Line 1049: WF_ENGINE.SetItemAttrText(l_itemType,

1045: --Amulya Mishra : Notification Esc Project
1046:
1047: IF (P_send_notifications = 'ES') THEN
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:

Line 1054: 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',
1057: 'JSP:/OA_HTML/OA.jsp?akRegionCode=DunningRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&graceDays='||p_grace_days||'&escNotif='||'Y'||'&mgrList='||'N'||'&orgId='||l_orgId);
1058:

Line 1062: WF_ENGINE.SetItemAttrText(l_itemType,

1058:
1059: --------------------------------------------------------------
1060: l_debugInfo := 'Set MGR_LIST value ';
1061: --------------------------------------------------------------
1062: WF_ENGINE.SetItemAttrText(l_itemType,
1063: l_itemKey,
1064: 'MGR_LIST',
1065: 'JSP:/OA_HTML/OA.jsp?akRegionCode=DunningRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&graceDays='||p_grace_days||'&escNotif='||'Y'||'&mgrList='||'Y'||'&orgId='||l_orgId);
1066:

Line 1077: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT',

1073: l_mgr_esc_amount);
1074: ------------------------------------------------------
1075: l_debugInfo := 'Set Amount Item Attribute';
1076: ------------------------------------------------------
1077: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT',
1078: to_char(l_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
1079:
1080: WF_ENGINE.SetItemAttrText(l_itemType,
1081: l_itemKey,

Line 1080: WF_ENGINE.SetItemAttrText(l_itemType,

1076: ------------------------------------------------------
1077: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT',
1078: to_char(l_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
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:

Line 1085: 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',
1088: 'JSP:/OA_HTML/OA.jsp?akRegionCode=EscNotifMgrRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&managerId='||l_orig_manager_id||'&orgId='||l_orgId);
1089:

Line 1103: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_AMOUNT',

1099:
1100: ------------------------------------------------------
1101: l_debugInfo := 'Set Amount Item Attribute';
1102: ------------------------------------------------------
1103: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_AMOUNT',
1104: to_char(l_next_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
1105:
1106:
1107: WF_ENGINE.SetItemAttrText(l_itemType,

Line 1107: WF_ENGINE.SetItemAttrText(l_itemType,

1103: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_NEXT_ESC_AMOUNT',
1104: to_char(l_next_mgr_esc_amount, FND_CURRENCY.Get_Format_Mask(p_currency,22)) || ' ' || p_currency);
1105:
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:

Line 1112: 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',
1115: 'JSP:/OA_HTML/OA.jsp?akRegionCode=EscNotifNextMgrRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&agingManager='||l_managerId||'&orgId='||l_orgId);
1116:

Line 1122: WF_ENGINE.SetItemAttrText(l_itemType,

1118:
1119: --Amulya Mishra : Notification Esc project
1120:
1121: BEGIN
1122: WF_ENGINE.SetItemAttrText(l_itemType,
1123: l_itemKey,
1124: '#FROM_ROLE',
1125: WF_ENGINE.GetItemAttrText(l_itemType,
1126: l_itemKey,

Line 1125: WF_ENGINE.GetItemAttrText(l_itemType,

1121: BEGIN
1122: WF_ENGINE.SetItemAttrText(l_itemType,
1123: l_itemKey,
1124: '#FROM_ROLE',
1125: WF_ENGINE.GetItemAttrText(l_itemType,
1126: l_itemKey,
1127: 'WF_ADMINISTRATOR'));
1128: EXCEPTION
1129: WHEN OTHERS THEN

Line 1138: WF_ENGINE.StartProcess(l_itemType, l_itemKey);

1134: BEGIN
1135: ------------------------------------------------------------
1136: l_debugInfo := 'Start the Expense Report Workflow Process';
1137: ------------------------------------------------------------
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',

Line 1221: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'UNAPPROVED_REPORT');

1217:
1218: --------------------------------------------------
1219: l_debugInfo := 'Calling WorkFlow Create Process';
1220: --------------------------------------------------
1221: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'UNAPPROVED_REPORT');
1222:
1223: ----------------------------------------------------------
1224: l_debugInfo := 'Set WF Amount Item Attribute';
1225: ----------------------------------------------------------

Line 1226: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',

1222:
1223: ----------------------------------------------------------
1224: l_debugInfo := 'Set WF Amount Item Attribute';
1225: ----------------------------------------------------------
1226: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'AMOUNT',
1227: to_char(l_exp_info_rec.total, FND_CURRENCY.Get_Format_Mask(l_exp_info_rec.default_curr_code,22)) || ' ' || l_exp_info_rec.default_curr_code);
1228:
1229: ----------------------------------------------------------
1230: l_debugInfo := 'Set the Owner of Workflow Process.';

Line 1232: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);

1228:
1229: ----------------------------------------------------------
1230: l_debugInfo := 'Set the Owner of Workflow Process.';
1231: ----------------------------------------------------------
1232: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);
1233:
1234: --------------------------------------------------------------
1235: l_debugInfo := 'Set WF EMP_DISPLAY_NAME Item Attribute';
1236: --------------------------------------------------------------

Line 1237: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);

1233:
1234: --------------------------------------------------------------
1235: l_debugInfo := 'Set WF EMP_DISPLAY_NAME Item Attribute';
1236: --------------------------------------------------------------
1237: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);
1238:
1239: ------------------------------------------------------
1240: l_debugInfo := 'Set WF MANAGER_NAME Item Attribute';
1241: ------------------------------------------------------

Line 1242: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);

1238:
1239: ------------------------------------------------------
1240: l_debugInfo := 'Set WF MANAGER_NAME Item Attribute';
1241: ------------------------------------------------------
1242: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MANAGER_NAME', l_managerName);
1243:
1244: ----------------------------------------------------------
1245: l_debugInfo := 'Set WF EXPENSE_REPORT_NUMBER Item Attribute';
1246: ----------------------------------------------------------

Line 1247: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EXPENSE_REPORT_NUMBER', l_exp_info_rec.doc_num);

1243:
1244: ----------------------------------------------------------
1245: l_debugInfo := 'Set WF EXPENSE_REPORT_NUMBER Item Attribute';
1246: ----------------------------------------------------------
1247: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EXPENSE_REPORT_NUMBER', l_exp_info_rec.doc_num);
1248:
1249: BEGIN
1250: ------------------------------------------------------------
1251: l_debugInfo := 'Start the Expense Report Workflow Process';

Line 1253: WF_ENGINE.StartProcess(l_itemType, l_itemKey);

1249: BEGIN
1250: ------------------------------------------------------------
1251: l_debugInfo := 'Start the Expense Report Workflow Process';
1252: ------------------------------------------------------------
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',

Line 1320: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'DISPUTED_CHARGES');

1316:
1317: --------------------------------------------------
1318: l_debugInfo := 'Calling WorkFlow Create Process';
1319: --------------------------------------------------
1320: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'DISPUTED_CHARGES');
1321:
1322: ----------------------------------------------------------
1323: l_debugInfo := 'Set the Owner of Workflow Process.';
1324: ----------------------------------------------------------

Line 1325: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);

1321:
1322: ----------------------------------------------------------
1323: l_debugInfo := 'Set the Owner of Workflow Process.';
1324: ----------------------------------------------------------
1325: WF_ENGINE.SetItemOwner(l_itemType, l_itemKey, l_employeeName);
1326:
1327: ------------------------------------------------------
1328: l_debugInfo := 'Set WF EMPLOYEE_NAME Item Attribute';
1329: ------------------------------------------------------

Line 1330: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMPLOYEE_NAME', l_employeeName);

1326:
1327: ------------------------------------------------------
1328: l_debugInfo := 'Set WF EMPLOYEE_NAME Item Attribute';
1329: ------------------------------------------------------
1330: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMPLOYEE_NAME', l_employeeName);
1331:
1332: --------------------------------------------------------------
1333: l_debugInfo := 'Set WF EMP_DISPLAY_NAME Item Attribute';
1334: --------------------------------------------------------------

Line 1335: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);

1331:
1332: --------------------------------------------------------------
1333: l_debugInfo := 'Set WF EMP_DISPLAY_NAME Item Attribute';
1334: --------------------------------------------------------------
1335: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'EMP_DISPLAY_NAME', l_employeeDisplayName);
1336:
1337: --------------------------------------------------------------
1338: l_debugInfo := 'Set WF EMPLOYEE_ID Item Attribute';
1339: --------------------------------------------------------------

Line 1340: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID', p_employeeID);

1336:
1337: --------------------------------------------------------------
1338: l_debugInfo := 'Set WF EMPLOYEE_ID Item Attribute';
1339: --------------------------------------------------------------
1340: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID', p_employeeID);
1341:
1342: --------------------------------------------------------------
1343: l_debugInfo := 'Set WF CARD_PROG_ID Item Attribute';
1344: --------------------------------------------------------------

Line 1345: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID', p_cardProgramID);

1341:
1342: --------------------------------------------------------------
1343: l_debugInfo := 'Set WF CARD_PROG_ID Item Attribute';
1344: --------------------------------------------------------------
1345: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID', p_cardProgramID);
1346:
1347: --------------------------------------------------------------
1348: l_debugInfo := 'Set WF CREDIT_CARD_COMPANY Item Attribute';
1349: --------------------------------------------------------------

Line 1355: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CREDIT_CARD_COMPANY', l_cardProgramName);

1351: l_cardProgramName ) ) THEN
1352: NULL;
1353: END IF;
1354:
1355: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'CREDIT_CARD_COMPANY', l_cardProgramName);
1356:
1357: ------------------------------------------------------
1358: l_debugInfo := 'Set WF MIN_AMOUNT Item Attribute';
1359: ------------------------------------------------------

Line 1360: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT', p_minimumAmount);

1356:
1357: ------------------------------------------------------
1358: l_debugInfo := 'Set WF MIN_AMOUNT Item Attribute';
1359: ------------------------------------------------------
1360: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT', p_minimumAmount);
1361:
1362: ------------------------------------------------------
1363: l_debugInfo := 'Set WF DATE_OBJ1 Item Attribute';
1364: ------------------------------------------------------

Line 1365: WF_ENGINE.SetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ1', p_billedStartDate);

1361:
1362: ------------------------------------------------------
1363: l_debugInfo := 'Set WF DATE_OBJ1 Item Attribute';
1364: ------------------------------------------------------
1365: WF_ENGINE.SetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ1', p_billedStartDate);
1366:
1367: ------------------------------------------------------
1368: l_debugInfo := 'Set WF DATE_OBJ2 Item Attribute';
1369: ------------------------------------------------------

Line 1370: WF_ENGINE.SetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ2', p_billedEndDate);

1366:
1367: ------------------------------------------------------
1368: l_debugInfo := 'Set WF DATE_OBJ2 Item Attribute';
1369: ------------------------------------------------------
1370: WF_ENGINE.SetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ2', p_billedEndDate);
1371:
1372: ------------------------------------------------------
1373: l_debugInfo := 'Set WF NUMBER_OF_DAYS Item Attribute';
1374: ------------------------------------------------------

Line 1379: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'NUMBER_OF_DAYS', round(l_today - p_billedStartDate));

1375: IF (AP_WEB_DB_UTIL_PKG.GetSysDate(l_sysdate)) THEN
1376: l_today := to_date(l_sysdate,AP_WEB_INFRASTRUCTURE_PKG.getDateFormat);
1377: END IF;
1378:
1379: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'NUMBER_OF_DAYS', round(l_today - p_billedStartDate));
1380:
1381: l_days := round(l_today - p_billedStartDate);
1382: --------------------------------------------------------------
1383: l_debugInfo := 'Get and Set ORG_ID attribute ';

Line 1392: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'ORG_ID', l_orgId);

1388: if l_orgId is null then
1389: FND_PROFILE.GET('ORG_ID' , l_orgId );
1390: end if;
1391:
1392: WF_ENGINE.SetItemAttrNumber(l_itemType, l_itemKey, 'ORG_ID', l_orgId);
1393:
1394: --------------------------------------------------------------
1395: l_debugInfo := 'Set LIST value ';
1396: --------------------------------------------------------------

Line 1397: WF_ENGINE.SetItemAttrText(l_itemType,

1393:
1394: --------------------------------------------------------------
1395: l_debugInfo := 'Set LIST value ';
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:

Line 1402: 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',
1405: 'JSP:/OA_HTML/OA.jsp?akRegionCode=DisputedChargesRN&akRegionApplicationId=200&itemKey='||l_itemKey||'&cardCompany='||l_cardProgramName||'&days='||l_days||'&orgId='||l_orgId);
1406:

Line 1411: WF_ENGINE.StartProcess(l_itemType, l_itemKey);

1407: BEGIN
1408: ------------------------------------------------------------
1409: l_debugInfo := 'Start the Expense Report Workflow Process';
1410: ------------------------------------------------------------
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',

Line 1492: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

1488: l_itemtype := substrb(document_id, 1, l_colon - 1);
1489: l_itemkey := substrb(document_id, l_colon + 1);
1490:
1491: l_debugInfo := 'Get org_id';
1492: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
1493:
1494: -- MOAC UPTAKE --
1495: -- Have new call back function defined for Item to set org context.
1496: --

Line 1519: l_minimumAmount := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT');

1515:
1516: ------------------------------------------------------
1517: l_debugInfo := 'Get WF MIN_AMOUNT Item Attribute';
1518: ------------------------------------------------------
1519: l_minimumAmount := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT');
1520:
1521: ------------------------------------------------------
1522: l_debugInfo := 'Get WF DATE_OBJ1 Item Attribute';
1523: ------------------------------------------------------

Line 1524: --l_billedStartDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ1');

1520:
1521: ------------------------------------------------------
1522: l_debugInfo := 'Get WF DATE_OBJ1 Item Attribute';
1523: ------------------------------------------------------
1524: --l_billedStartDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ1');
1525:
1526: ------------------------------------------------------
1527: l_debugInfo := 'Get WF DATE_OBJ2 Item Attribute';
1528: ------------------------------------------------------

Line 1529: l_billedEndDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ2');

1525:
1526: ------------------------------------------------------
1527: l_debugInfo := 'Get WF DATE_OBJ2 Item Attribute';
1528: ------------------------------------------------------
1529: l_billedEndDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE_OBJ2');
1530:
1531: --------------------------------------------------------------
1532: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
1533: --------------------------------------------------------------

Line 1534: l_cardProgramID := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

1530:
1531: --------------------------------------------------------------
1532: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
1533: --------------------------------------------------------------
1534: l_cardProgramID := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
1535:
1536: --------------------------------------------------------------
1537: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
1538: --------------------------------------------------------------

Line 1539: l_employeeID := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

1535:
1536: --------------------------------------------------------------
1537: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
1538: --------------------------------------------------------------
1539: l_employeeID := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
1540:
1541: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1542:
1543: l_debugInfo := 'Loop over all the Disputed charges';

Line 1682: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

1678: l_itemtype := substrb(document_id, 1, l_colon - 1);
1679: l_itemkey := substrb(document_id, l_colon + 1);
1680:
1681: l_debugInfo := 'Get org_id';
1682: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
1683:
1684: -- MOAC UPTAKE --
1685: -- Have new call back function defined for Item to set org context.
1686: --

Line 1725: l_minimumAmount := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT');

1721:
1722: ------------------------------------------------------
1723: l_debugInfo := 'Get WF MIN_AMOUNT Item Attribute';
1724: ------------------------------------------------------
1725: l_minimumAmount := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT');
1726:
1727: ------------------------------------------------------
1728: l_debugInfo := 'Get WF DATE1 Item Attribute';
1729: ------------------------------------------------------

Line 1730: l_billedStartDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE1');

1726:
1727: ------------------------------------------------------
1728: l_debugInfo := 'Get WF DATE1 Item Attribute';
1729: ------------------------------------------------------
1730: l_billedStartDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE1');
1731:
1732: ------------------------------------------------------
1733: l_debugInfo := 'Get WF DATE2 Item Attribute';
1734: ------------------------------------------------------

Line 1735: l_billedEndDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE2');

1731:
1732: ------------------------------------------------------
1733: l_debugInfo := 'Get WF DATE2 Item Attribute';
1734: ------------------------------------------------------
1735: l_billedEndDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE2');
1736:
1737: --------------------------------------------------------------
1738: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
1739: --------------------------------------------------------------

Line 1740: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

1736:
1737: --------------------------------------------------------------
1738: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
1739: --------------------------------------------------------------
1740: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
1741:
1742: --------------------------------------------------------------
1743: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
1744: --------------------------------------------------------------

Line 1745: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

1741:
1742: --------------------------------------------------------------
1743: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
1744: --------------------------------------------------------------
1745: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
1746:
1747: --------------------------------------------------------------
1748: l_debugInfo := 'Get Charge Type Item Attribute';
1749: --------------------------------------------------------------

Line 1750: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');

1746:
1747: --------------------------------------------------------------
1748: l_debugInfo := 'Get Charge Type Item Attribute';
1749: --------------------------------------------------------------
1750: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
1751:
1752:
1753: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
1754:

Line 1955: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

1951: l_itemtype := substrb(document_id, 1, l_colon - 1);
1952: l_itemkey := substrb(document_id, l_colon + 1);
1953:
1954: l_debugInfo := 'Get org_id';
1955: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
1956:
1957: -- MOAC UPTAKE --
1958: -- Have new call back function defined for Item to set org context.
1959: --

Line 1974: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');

1970: l_document := '';--Notification Esc :Change all document to l_document
1971:
1972: --Notification esc : moved code to top..
1973:
1974: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
1975: --------------------------------------------------------------
1976: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
1977: --------------------------------------------------------------
1978: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

Line 1978: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

1974: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
1975: --------------------------------------------------------------
1976: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
1977: --------------------------------------------------------------
1978: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
1979: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
1980:
1981: l_min_bucket := to_number(l_min_bucket1);
1982: if(l_max_bucket1 = '+' ) then

Line 1979: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');

1975: --------------------------------------------------------------
1976: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
1977: --------------------------------------------------------------
1978: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
1979: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
1980:
1981: l_min_bucket := to_number(l_min_bucket1);
1982: if(l_max_bucket1 = '+' ) then
1983: l_max_bucket := 1000000;

Line 2022: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

2018:
2019: --------------------------------------------------------------
2020: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
2021: --------------------------------------------------------------
2022: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2023: --------------------------------------------------------------
2024: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2025: --------------------------------------------------------------
2026: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

Line 2026: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

2022: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2023: --------------------------------------------------------------
2024: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2025: --------------------------------------------------------------
2026: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2027: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2028:
2029: l_debugInfo := 'Loop over all the Dunning Charges ';
2030:

Line 2290: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

2286: l_itemtype := substrb(document_id, 1, l_colon - 1);
2287: l_itemkey := substrb(document_id, l_colon + 1);
2288:
2289: l_debugInfo := 'Get org_id';
2290: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
2291:
2292: -- MOAC UPTAKE --
2293: -- Have new call back function defined for Item to set org context.
2294: --

Line 2301: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

2297:
2298: --------------------------------------------------------------
2299: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
2300: --------------------------------------------------------------
2301: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2302:
2303: --------------------------------------------------------------
2304: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2305: --------------------------------------------------------------

Line 2306: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

2302:
2303: --------------------------------------------------------------
2304: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2305: --------------------------------------------------------------
2306: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2307:
2308: ------------------------------------------------------
2309: l_debugInfo := 'Get WF MIN_AMOUNT Item Attribute';
2310: ------------------------------------------------------

Line 2311: l_minimumAmount := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT');

2307:
2308: ------------------------------------------------------
2309: l_debugInfo := 'Get WF MIN_AMOUNT Item Attribute';
2310: ------------------------------------------------------
2311: l_minimumAmount := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'MIN_AMOUNT');
2312:
2313: ------------------------------------------------------
2314: l_debugInfo := 'Get WF DATE1 Item Attribute';
2315: ------------------------------------------------------

Line 2316: l_billedStartDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE1');

2312:
2313: ------------------------------------------------------
2314: l_debugInfo := 'Get WF DATE1 Item Attribute';
2315: ------------------------------------------------------
2316: l_billedStartDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE1');
2317:
2318: ------------------------------------------------------
2319: l_debugInfo := 'Get WF DATE2 Item Attribute';
2320: ------------------------------------------------------

Line 2321: l_billedEndDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE2');

2317:
2318: ------------------------------------------------------
2319: l_debugInfo := 'Get WF DATE2 Item Attribute';
2320: ------------------------------------------------------
2321: l_billedEndDate := WF_ENGINE.GetItemAttrDate(l_itemType, l_itemKey, 'DATE2');
2322:
2323: --------------------------------------------------------------
2324: l_debugInfo := 'Get Charge Type Item Attribute';
2325: --------------------------------------------------------------

Line 2326: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');

2322:
2323: --------------------------------------------------------------
2324: l_debugInfo := 'Get Charge Type Item Attribute';
2325: --------------------------------------------------------------
2326: l_chargeType := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CHARGE_TYPE');
2327:
2328: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2329:
2330: IF (NOT AP_WEB_DB_CCARD_PKG.GetTotalUnsubmittedCCCursor(l_cardProgramId,

Line 2416: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

2412: l_itemtype := substrb(document_id, 1, l_colon - 1);
2413: l_itemkey := substrb(document_id, l_colon + 1);
2414:
2415: l_debugInfo := 'Get org_id';
2416: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
2417:
2418: -- MOAC UPTAKE --
2419: -- Have new call back function defined for Item to set org context.
2420: --

Line 2427: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

2423:
2424: --------------------------------------------------------------
2425: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
2426: --------------------------------------------------------------
2427: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2428:
2429: --------------------------------------------------------------
2430: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2431: --------------------------------------------------------------

Line 2432: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

2428:
2429: --------------------------------------------------------------
2430: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2431: --------------------------------------------------------------
2432: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2433:
2434: --------------------------------------------------------------
2435: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2436: --------------------------------------------------------------

Line 2437: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

2433:
2434: --------------------------------------------------------------
2435: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2436: --------------------------------------------------------------
2437: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
2438: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
2439:
2440:
2441: l_min_bucket := to_number(l_min_bucket1);

Line 2438: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');

2434: --------------------------------------------------------------
2435: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2436: --------------------------------------------------------------
2437: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
2438: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
2439:
2440:
2441: l_min_bucket := to_number(l_min_bucket1);
2442: if(l_max_bucket1 = '+' ) then

Line 2560: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

2556: l_itemtype := substrb(document_id, 1, l_colon - 1);
2557: l_itemkey := substrb(document_id, l_colon + 1);
2558:
2559: l_debugInfo := 'Get org_id';
2560: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
2561:
2562: -- MOAC UPTAKE --
2563: -- Have new call back function defined for Item to set org context.
2564: --

Line 2577: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');

2573:
2574: l_debugInfo := 'Generate header';
2575: l_document := '';
2576:
2577: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
2578:
2579: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
2580: --------------------------------------------------------------
2581: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';

Line 2579: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');

2575: l_document := '';
2576:
2577: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
2578:
2579: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
2580: --------------------------------------------------------------
2581: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2582: --------------------------------------------------------------
2583: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

Line 2583: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

2579: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
2580: --------------------------------------------------------------
2581: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2582: --------------------------------------------------------------
2583: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
2584: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
2585:
2586: l_min_bucket := to_number(l_min_bucket1);
2587: if(l_max_bucket1 = '+' ) then

Line 2584: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');

2580: --------------------------------------------------------------
2581: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2582: --------------------------------------------------------------
2583: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
2584: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
2585:
2586: l_min_bucket := to_number(l_min_bucket1);
2587: if(l_max_bucket1 = '+' ) then
2588: l_max_bucket := 1000000;

Line 2620: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

2616:
2617: --------------------------------------------------------------
2618: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
2619: --------------------------------------------------------------
2620: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2621: --------------------------------------------------------------
2622: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2623: --------------------------------------------------------------
2624: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

Line 2624: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

2620: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2621: --------------------------------------------------------------
2622: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2623: --------------------------------------------------------------
2624: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2625: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2626:
2627: l_debugInfo := 'Loop over all the Dunning Charges ';
2628:

Line 2824: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

2820: l_itemtype := substrb(document_id, 1, l_colon - 1);
2821: l_itemkey := substrb(document_id, l_colon + 1);
2822:
2823: l_debugInfo := 'Get org_id';
2824: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
2825:
2826: l_supervisor_id := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'AGING_MANAGER_ID');
2827: l_final_manager_id := l_supervisor_id; --Bug 3337443
2828:

Line 2826: l_supervisor_id := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'AGING_MANAGER_ID');

2822:
2823: l_debugInfo := 'Get org_id';
2824: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
2825:
2826: l_supervisor_id := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'AGING_MANAGER_ID');
2827: l_final_manager_id := l_supervisor_id; --Bug 3337443
2828:
2829: -- MOAC UPTAKE --
2830: -- Have new call back function defined for Item to set org context.

Line 2843: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');

2839:
2840: l_debugInfo := 'Generate header';
2841: l_document := '';
2842:
2843: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
2844:
2845: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
2846: --------------------------------------------------------------
2847: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';

Line 2845: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');

2841: l_document := '';
2842:
2843: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
2844:
2845: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
2846: --------------------------------------------------------------
2847: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2848: --------------------------------------------------------------
2849: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

Line 2849: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

2845: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
2846: --------------------------------------------------------------
2847: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2848: --------------------------------------------------------------
2849: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
2850: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
2851:
2852: l_min_bucket := to_number(l_min_bucket1);
2853: if(l_max_bucket1 = '+' ) then

Line 2850: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');

2846: --------------------------------------------------------------
2847: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
2848: --------------------------------------------------------------
2849: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
2850: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
2851:
2852: l_min_bucket := to_number(l_min_bucket1);
2853: if(l_max_bucket1 = '+' ) then
2854: l_max_bucket := 1000000;

Line 2892: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

2888:
2889: --------------------------------------------------------------
2890: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
2891: --------------------------------------------------------------
2892: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2893: --------------------------------------------------------------
2894: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2895: --------------------------------------------------------------
2896: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

Line 2896: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

2892: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
2893: --------------------------------------------------------------
2894: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
2895: --------------------------------------------------------------
2896: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
2897: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2898:
2899: l_debugInfo := 'Loop over all the Dunning Charges ';
2900:

Line 2901: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER'); --Bug 3337388

2897: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
2898:
2899: l_debugInfo := 'Loop over all the Dunning Charges ';
2900:
2901: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER'); --Bug 3337388
2902:
2903: -- IF (NOT GetHierarchialEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN
2904: -- 5049215 -- Added the dunning number to the function level as only records of this dunning level are processed later.
2905: IF (NOT GetHierarchialEmployeeCursor(l_supervisor_id,l_employee_cursor, l_dunning_number)) THEN

Line 2999: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT', l_employee_name);

2995: END LOOP;
2996: close l_employee_cursor;
2997:
2998: --Set Outstanding total amount attribute.
2999: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT', l_employee_name);
3000:
3001: --------------------------------------------
3002: l_debugInfo := 'Generate Total Row';
3003: --------------------------------------------

Line 3364: p_result := WF_ENGINE.GetItemAttrText(p_item_type,

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');
3368:

Line 3388: p_result := WF_ENGINE.GetItemAttrText(p_item_type,

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');
3392: END SendNotifications;

Line 3413: p_result := WF_ENGINE.GetItemAttrText(p_item_type,

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');
3417:

Line 3523: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

3519: l_itemType := p_itemType;
3520: l_itemKey := p_itemKey;
3521:
3522: l_debugInfo := 'Get org_id';
3523: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
3524:
3525: l_supervisor_id := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'AGING_MANAGER_ID');
3526: l_final_manager_id := l_supervisor_id;
3527:

Line 3525: l_supervisor_id := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'AGING_MANAGER_ID');

3521:
3522: l_debugInfo := 'Get org_id';
3523: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
3524:
3525: l_supervisor_id := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'AGING_MANAGER_ID');
3526: l_final_manager_id := l_supervisor_id;
3527:
3528: -- MOAC UPTAKE --
3529: -- Have new call back function defined for Item to set org context.

Line 3534: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');

3530: --
3531: -- l_debugInfo := 'Set Org context';
3532: -- fnd_client_info.set_org_context(l_orgId);
3533:
3534: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
3535:
3536: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
3537: --------------------------------------------------------------
3538: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';

Line 3536: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');

3532: -- fnd_client_info.set_org_context(l_orgId);
3533:
3534: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
3535:
3536: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
3537: --------------------------------------------------------------
3538: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
3539: --------------------------------------------------------------
3540: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

Line 3540: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

3536: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
3537: --------------------------------------------------------------
3538: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
3539: --------------------------------------------------------------
3540: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
3541: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
3542:
3543: l_min_bucket := to_number(l_min_bucket1);
3544: if(l_max_bucket1 = '+' ) then

Line 3541: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');

3537: --------------------------------------------------------------
3538: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
3539: --------------------------------------------------------------
3540: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
3541: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
3542:
3543: l_min_bucket := to_number(l_min_bucket1);
3544: if(l_max_bucket1 = '+' ) then
3545: l_max_bucket := 1000000;

Line 3554: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

3550:
3551: --------------------------------------------------------------
3552: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
3553: --------------------------------------------------------------
3554: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
3555: --------------------------------------------------------------
3556: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3557: --------------------------------------------------------------
3558: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

Line 3558: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

3554: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
3555: --------------------------------------------------------------
3556: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3557: --------------------------------------------------------------
3558: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
3559: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3560:
3561: l_debugInfo := 'Loop over all the Dunning Charges ';
3562:

Line 3563: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER');

3559: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3560:
3561: l_debugInfo := 'Loop over all the Dunning Charges ';
3562:
3563: l_dunning_number := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'DUNNING_NUMBER');
3564:
3565: DELETE FROM ap_ccard_esc_next_gt;
3566:
3567: -- IF (NOT GetHierarchialEmployeeCursor(l_supervisor_id,l_employee_cursor)) THEN

Line 3638: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT', l_employee_name);

3634: END LOOP;
3635: close l_employee_cursor;
3636: commit;
3637: --Set Outstanding total amount attribute.
3638: WF_ENGINE.SetItemAttrText(l_itemType, l_itemKey, 'MGR_ESC_AMOUNT', l_employee_name);
3639:
3640: EXCEPTION
3641: WHEN OTHERS THEN
3642: Wf_Core.Context('AP_WEB_EXPENSE_WF', 'GetWebNextEscManager',

Line 3702: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');

3698: l_itemType := p_itemType;
3699: l_itemKey := p_itemKey;
3700:
3701: l_debugInfo := 'Get org_id';
3702: l_orgId := WF_ENGINE.GetItemAttrNumber(l_itemtype, l_itemKey, 'ORG_ID');
3703:
3704: -- MOAC UPTAKE --
3705: -- Have new call back function defined for Item to set org context.
3706: --

Line 3710: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');

3706: --
3707: -- l_debugInfo := 'Set Org context';
3708: -- fnd_client_info.set_org_context(l_orgId);
3709:
3710: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
3711:
3712:
3713: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
3714: --------------------------------------------------------------

Line 3713: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');

3709:
3710: l_grace_days := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'AGING_GRACE_DAYS');
3711:
3712:
3713: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
3714: --------------------------------------------------------------
3715: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
3716: --------------------------------------------------------------
3717: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

Line 3717: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');

3713: l_billed_currency_code := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'CURRENCY');
3714: --------------------------------------------------------------
3715: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
3716: --------------------------------------------------------------
3717: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
3718: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
3719:
3720: l_min_bucket := to_number(l_min_bucket1);
3721: if(l_max_bucket1 = '+' ) then

Line 3718: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');

3714: --------------------------------------------------------------
3715: l_debugInfo := 'Get WF BUCKET1..4 Item Attribute';
3716: --------------------------------------------------------------
3717: l_min_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET1');
3718: l_max_bucket1 := WF_ENGINE.GetItemAttrText(l_itemType, l_itemKey, 'BUCKET2');
3719:
3720: l_min_bucket := to_number(l_min_bucket1);
3721: if(l_max_bucket1 = '+' ) then
3722: l_max_bucket := 1000000;

Line 3730: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');

3726:
3727: --------------------------------------------------------------
3728: l_debugInfo := 'Get WF CARD_PROG_ID Item Attribute';
3729: --------------------------------------------------------------
3730: l_cardProgramId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'CARD_PROG_ID');
3731:
3732: --------------------------------------------------------------
3733: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3734: --------------------------------------------------------------

Line 3735: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');

3731:
3732: --------------------------------------------------------------
3733: l_debugInfo := 'Get WF EMPLOYEE_ID Item Attribute';
3734: --------------------------------------------------------------
3735: l_employeeId := WF_ENGINE.GetItemAttrNumber(l_itemType, l_itemKey, 'EMPLOYEE_ID');
3736: l_dateFormat := icx_sec.getID(icx_sec.PV_DATE_FORMAT);
3737:
3738: l_debugInfo := 'Loop over all the Dunning Charges ';
3739:

Line 3848: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'DEACTIVATED_TRXNS');

3844:
3845: --------------------------------------------------
3846: l_debugInfo := 'Calling WorkFlow Create Process';
3847: --------------------------------------------------
3848: WF_ENGINE.CreateProcess(l_itemType, l_itemKey, 'DEACTIVATED_TRXNS');
3849:
3850: ----------------------------------------------------------
3851: l_debugInfo := 'Set DATE2 Item Attribute';
3852: ----------------------------------------------------------

Line 3857: WF_ENGINE.SetItemAttrText( l_itemType,

3853: --
3854: -- Set the date in canonical format so that the web pages
3855: -- can convert this into appropriate user preference format.
3856: --
3857: WF_ENGINE.SetItemAttrText( l_itemType,
3858: l_itemKey,
3859: 'DATE2',
3860: FND_DATE.date_to_canonical(to_date(p_endDate,
3861: nvl(icx_sec.g_date_format,

Line 3871: WF_ENGINE.SetItemAttrText( l_itemType,

3867:
3868: ----------------------------------------------------------
3869: l_debugInfo := 'Set EMPLOYEE_NAME Item Attribute';
3870: ----------------------------------------------------------
3871: WF_ENGINE.SetItemAttrText( l_itemType,
3872: l_itemKey,
3873: 'EMPLOYEE_NAME',
3874: l_employeeName);
3875:

Line 3879: WF_ENGINE.SetItemAttrText( l_itemType,

3875:
3876: ----------------------------------------------------------
3877: l_debugInfo := 'Set EMPLOYEE_NAME Item Attribute';
3878: ----------------------------------------------------------
3879: WF_ENGINE.SetItemAttrText( l_itemType,
3880: l_itemKey,
3881: 'EMP_DISPLAY_NAME',
3882: l_employeeDisplayName);
3883:

Line 3892: WF_ENGINE.SetItemAttrText( l_itemType,

3888: l_cardProgramName ) ) THEN
3889: NULL;
3890: END IF;
3891:
3892: WF_ENGINE.SetItemAttrText( l_itemType,
3893: l_itemKey,
3894: 'CREDIT_CARD_COMPANY',
3895: l_cardProgramName);
3896:

Line 3897: WF_ENGINE.StartProcess(l_itemType, l_itemKey);

3893: l_itemKey,
3894: 'CREDIT_CARD_COMPANY',
3895: l_cardProgramName);
3896:
3897: WF_ENGINE.StartProcess(l_itemType, l_itemKey);
3898:
3899: END SendDeactivatedNotif;
3900: ---------------------------------------------------------------
3901:

Line 3922: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

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,
3924: 'ORG_ID');
3925: exception
3926: when others then

Line 3934: l_card_prog_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3930: -- hence remove the call GetOrgIdByReportHeaderId and instead
3931: -- get the org_id from card program(ap_card_programs).
3932: if (wf_core.error_name = 'WFENG_ITEM_ATTR') then
3933: begin
3934: l_card_prog_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3935: p_item_key,
3936: 'CARD_PROG_ID');
3937:
3938: exception

Line 3944: l_card_prog_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3940: null;
3941: end;
3942: if l_card_prog_id is null then
3943: begin
3944: l_card_prog_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3945: p_item_key,
3946: 'CARD_PROGRAM_ID');
3947: exception
3948: when others then

Line 3967: wf_engine.AddItemAttr(p_item_type, p_item_key, 'ORG_ID');

3963: l_org_id := NULL;
3964: end if;
3965:
3966: -- ORG_ID item attribute doesn't exist, need to add it
3967: wf_engine.AddItemAttr(p_item_type, p_item_key, 'ORG_ID');
3968: WF_ENGINE.SetItemAttrNumber(p_item_type,
3969: p_item_key,
3970: 'ORG_ID',
3971: l_org_id);

Line 3968: WF_ENGINE.SetItemAttrNumber(p_item_type,

3964: end if;
3965:
3966: -- ORG_ID item attribute doesn't exist, need to add it
3967: wf_engine.AddItemAttr(p_item_type, p_item_key, 'ORG_ID');
3968: WF_ENGINE.SetItemAttrNumber(p_item_type,
3969: p_item_key,
3970: 'ORG_ID',
3971: l_org_id);
3972: else