APPS.GL_WF_JE_APPROVAL_PKG dependencies on WF_ENGINE

Line 123: WF_ENGINE.SetItemAttrText(item_type,

119: diagn_msg('setpersonas: manager_name = ' || l_manager_name);
120: diagn_msg('setpersonas: manager_display_name = ' || l_manager_display_name);
121:
122: IF (manager_target = 'MANAGER') THEN
123: WF_ENGINE.SetItemAttrText(item_type,
124: item_key,
125: 'MANAGER_ID',
126: manager_id);
127:

Line 128: WF_ENGINE.SetItemAttrText(item_type,

124: item_key,
125: 'MANAGER_ID',
126: manager_id);
127:
128: WF_ENGINE.SetItemAttrText(item_type,
129: item_key,
130: 'MANAGER_NAME',
131: l_manager_name);
132:

Line 133: WF_ENGINE.SetItemAttrText(item_type,

129: item_key,
130: 'MANAGER_NAME',
131: l_manager_name);
132:
133: WF_ENGINE.SetItemAttrText(item_type,
134: item_key,
135: 'MANAGER_DISPLAY_NAME',
136: l_manager_display_name);
137:

Line 139: WF_ENGINE.SetItemAttrText(item_type,

135: 'MANAGER_DISPLAY_NAME',
136: l_manager_display_name);
137:
138: ELSE
139: WF_ENGINE.SetItemAttrText(item_type,
140: item_key,
141: 'APPROVER_ID',
142: manager_id);
143:

Line 144: WF_ENGINE.SetItemAttrText(item_type,

140: item_key,
141: 'APPROVER_ID',
142: manager_id);
143:
144: WF_ENGINE.SetItemAttrText(item_type,
145: item_key,
146: 'APPROVER_NAME',
147: l_manager_name);
148:

Line 149: WF_ENGINE.SetItemAttrText(item_type,

145: item_key,
146: 'APPROVER_NAME',
147: l_manager_name);
148:
149: WF_ENGINE.SetItemAttrText(item_type,
150: item_key,
151: 'APPROVER_DISPLAY_NAME',
152: l_manager_display_name);
153: END IF;

Line 215: l_batch_id := wf_engine.GetItemAttrNumber(

211: l_error_message VARCHAR2(2000);
212: l_batch_id NUMBER;
213: BEGIN
214: -- Get batch id
215: l_batch_id := wf_engine.GetItemAttrNumber(
216: itemtype => item_type,
217: itemkey => item_key,
218: aname => 'BATCH_ID');
219:

Line 253: wf_engine.SetItemAttrText(item_type,

249: ELSE
250: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_APPROVER_METHOD');
251: l_error_message := FND_MESSAGE.Get;
252:
253: wf_engine.SetItemAttrText(item_type,
254: item_key,
255: 'ERROR_MESSAGE',
256: l_error_message);
257: END IF;

Line 313: wf_engine.CreateProcess( itemtype => l_itemtype,

309:
310: diagn_msg('Generated Item Key = ' || l_itemkey);
311:
312: -- Kick Off workflow process
313: wf_engine.CreateProcess( itemtype => l_itemtype,
314: itemkey => l_itemkey,
315: process => 'GL_JE_APPROVAL_PROCESS' );
316: diagn_msg('Process for GL_JE_APPROVAL_PROCESS created');
317:

Line 319: wf_engine.SetItemUserKey( itemtype => l_itemtype,

315: process => 'GL_JE_APPROVAL_PROCESS' );
316: diagn_msg('Process for GL_JE_APPROVAL_PROCESS created');
317:
318: -- Set item user key
319: wf_engine.SetItemUserKey( itemtype => l_itemtype,
320: itemkey => l_itemkey,
321: userkey => p_je_batch_name );
322:
323: -- Set the process owner

Line 324: wf_engine.SetItemOwner( itemtype => l_itemtype,

320: itemkey => l_itemkey,
321: userkey => p_je_batch_name );
322:
323: -- Set the process owner
324: wf_engine.SetItemOwner( itemtype => l_itemtype,
325: itemkey => l_itemkey,
326: owner => l_fnd_user_name );
327:
328: -- Set the fnd user name

Line 329: wf_engine.SetItemAttrText( itemtype => l_itemtype,

325: itemkey => l_itemkey,
326: owner => l_fnd_user_name );
327:
328: -- Set the fnd user name
329: wf_engine.SetItemAttrText( itemtype => l_itemtype,
330: itemkey => l_itemkey,
331: aname => 'FND_USER_NAME',
332: avalue => l_fnd_user_name );
333:

Line 335: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

331: aname => 'FND_USER_NAME',
332: avalue => l_fnd_user_name );
333:
334: -- Set batch id (JE batch ID)
335: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
336: itemkey => l_itemkey,
337: aname => 'BATCH_ID',
338: avalue => p_je_batch_id );
339: diagn_msg('Attribute JE_BATCH_ID set to ' || to_char(p_je_batch_id));

Line 342: wf_engine.SetItemAttrText( itemtype => l_itemtype,

338: avalue => p_je_batch_id );
339: diagn_msg('Attribute JE_BATCH_ID set to ' || to_char(p_je_batch_id));
340:
341: -- Set the unique item key
342: wf_engine.SetItemAttrText( itemtype => l_itemtype,
343: itemkey => l_itemkey,
344: aname => 'UNIQUE_ITEMKEY',
345: avalue => l_itemkey );
346: diagn_msg('Set the unique item key: '|| l_itemkey);

Line 349: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

345: avalue => l_itemkey );
346: diagn_msg('Set the unique item key: '|| l_itemkey);
347:
348: -- Set PersonID attribute (HR personID from PER_PERSONS_F)
349: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
350: itemkey => l_itemkey,
351: aname => 'PREPARER_ID',
352: avalue => l_preparer_id );
353: diagn_msg('Attribute PREPARER_ID set to ' || l_preparer_id);

Line 356: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

352: avalue => l_preparer_id );
353: diagn_msg('Attribute PREPARER_ID set to ' || l_preparer_id);
354:
355: -- Set UserID attribute (AOL userID from FND_USER table).
356: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
357: itemkey => l_itemkey,
358: aname => 'PREPARER_FND_ID',
359: avalue => p_preparer_fnd_user_id );
360:

Line 362: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,

358: aname => 'PREPARER_FND_ID',
359: avalue => p_preparer_fnd_user_id );
360:
361: -- Set ResponsibilityID attribute
362: wf_engine.SetItemAttrNumber( itemtype => l_itemtype,
363: itemkey => l_itemkey,
364: aname => 'PREPARER_RESP_ID',
365: avalue => p_preparer_resp_id );
366: diagn_msg('Attribute PREPARER_RESP_ID set');

Line 371: wf_engine.SetItemAttrText( itemtype => l_itemtype,

367:
368: -- Get the monitor URL
369: l_monitor_url := wf_monitor.GetUrl(wf_core.translate('WF_WEB_AGENT'),
370: l_itemtype, l_itemkey, 'NO');
371: wf_engine.SetItemAttrText( itemtype => l_itemtype,
372: itemkey => l_itemkey,
373: aname => 'MONITOR_URL',
374: avalue => l_monitor_url );
375: diagn_msg('Attribute Monitor_URL set to ' || l_monitor_url);

Line 392: wf_engine.SetItemAttrText ( itemtype => l_itemtype,

388: WHERE name IN ('GL_JE_APPROVAL_REASSIGN_ROLE' || ' ' || l_business_group_id,
389: 'GL_JE_APPROVAL_REASSIGN_ROLE')
390: AND nvl(expiration_date, sysdate + 1) > sysdate;
391:
392: wf_engine.SetItemAttrText ( itemtype => l_itemtype,
393: itemkey => l_itemkey,
394: aname => 'REASSIGNMENT_ROLE',
395: avalue => l_reassign_role );
396:

Line 398: wf_engine.StartProcess( itemtype => l_itemtype,

394: aname => 'REASSIGNMENT_ROLE',
395: avalue => l_reassign_role );
396:
397: -- Finally, start the process
398: wf_engine.StartProcess( itemtype => l_itemtype,
399: itemkey => l_itemkey );
400:
401: diagn_msg('Process GL_JE_APPROVAL_PROCESS started');
402:

Line 428: l_preparer_id := wf_engine.GetItemAttrNumber(

424: BEGIN
425:
426: IF ( funcmode = 'RUN' ) THEN
427: -- Get PersonID attribute (already set when process started)
428: l_preparer_id := wf_engine.GetItemAttrNumber(
429: itemtype => itemtype,
430: itemkey => itemkey,
431: aname => 'PREPARER_ID' );
432:

Line 445: wf_engine.SetItemAttrText( itemtype => itemtype,

441: p_display_name => l_preparer_display_name );
442: diagn_msg('Retrieved user name: '|| l_preparer_name);
443:
444: -- Copy username to Workfow
445: wf_engine.SetItemAttrText( itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'PREPARER_NAME',
448: avalue => l_preparer_name );
449: diagn_msg('Attribute PREPARER_NAME set to' || l_preparer_name);

Line 452: wf_engine.SetItemAttrText( itemtype => itemtype,

448: avalue => l_preparer_name );
449: diagn_msg('Attribute PREPARER_NAME set to' || l_preparer_name);
450:
451: -- Copy displayed username to Workfow
452: wf_engine.SetItemAttrText( itemtype => itemtype,
453: itemkey => itemkey,
454: aname => 'PREPARER_DISPLAY_NAME',
455: avalue => l_preparer_display_name );
456: diagn_msg('Attribute PREPARER_DISPLAY_NAME set to '||l_preparer_display_name);

Line 511: l_je_batch_id := wf_engine.GetItemAttrNumber(

507: BEGIN
508:
509: IF ( funcmode = 'RUN' ) THEN
510: -- Get JE batch ID
511: l_je_batch_id := wf_engine.GetItemAttrNumber(
512: itemtype => itemtype,
513: itemkey => itemkey,
514: aname => 'BATCH_ID');
515:

Line 517: l_current_ledger_id := wf_engine.GetItemAttrNumber(

513: itemkey => itemkey,
514: aname => 'BATCH_ID');
515:
516: -- Get current ledger ID
517: l_current_ledger_id := wf_engine.GetItemAttrNumber(
518: itemtype => itemtype,
519: itemkey => itemkey,
520: aname => 'SET_OF_BOOKS_ID');
521:

Line 527: wf_engine.SetItemAttrText(itemtype => itemtype,

523: FETCH batch_ledgers INTO l_ledger_id;
524: IF (batch_ledgers%NOTFOUND) THEN
525: -- no more ledgers: reset Set of Books (Ledger) Attribute to -1
526: CLOSE batch_ledgers;
527: wf_engine.SetItemAttrText(itemtype => itemtype,
528: itemkey => itemkey,
529: aname => 'SET_OF_BOOKS_ID',
530: avalue => -1);
531: result := 'COMPLETE:FAIL';

Line 552: wf_engine.SetItemAttrText ( itemtype => itemtype,

548:
549: diagn_msg('Ledger Attributes retrieved from db');
550:
551: -- Set the corresponding attributes in workflow
552: wf_engine.SetItemAttrText ( itemtype => itemtype,
553: itemkey => itemkey,
554: aname => 'FUNC_CURRENCY',
555: avalue => l_func_currency );
556: diagn_msg('Get_SOB_Attributes: Func currency = '||l_func_currency);

Line 558: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

554: aname => 'FUNC_CURRENCY',
555: avalue => l_func_currency );
556: diagn_msg('Get_SOB_Attributes: Func currency = '||l_func_currency);
557:
558: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
559: itemkey => itemkey,
560: aname => 'SET_OF_BOOKS_ID',
561: avalue => l_ledger_id );
562: diagn_msg('Get_SOB_Attributes: Ledger id = ' ||to_char(l_ledger_id));

Line 564: wf_engine.SetItemAttrText ( itemtype => itemtype,

560: aname => 'SET_OF_BOOKS_ID',
561: avalue => l_ledger_id );
562: diagn_msg('Get_SOB_Attributes: Ledger id = ' ||to_char(l_ledger_id));
563:
564: wf_engine.SetItemAttrText ( itemtype => itemtype,
565: itemkey => itemkey,
566: aname => 'SUSPENSE_FLAG',
567: avalue => l_suspense_flag );
568: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 568: wf_engine.SetItemAttrText ( itemtype => itemtype,

564: wf_engine.SetItemAttrText ( itemtype => itemtype,
565: itemkey => itemkey,
566: aname => 'SUSPENSE_FLAG',
567: avalue => l_suspense_flag );
568: wf_engine.SetItemAttrText ( itemtype => itemtype,
569: itemkey => itemkey,
570: aname => 'AVERAGE_BALANCES_FLAG',
571: avalue => l_average_balances_flag );
572: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 572: wf_engine.SetItemAttrText ( itemtype => itemtype,

568: wf_engine.SetItemAttrText ( itemtype => itemtype,
569: itemkey => itemkey,
570: aname => 'AVERAGE_BALANCES_FLAG',
571: avalue => l_average_balances_flag );
572: wf_engine.SetItemAttrText ( itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'CONS_SOB_FLAG',
575: avalue => l_cons_sob_flag );
576: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 576: wf_engine.SetItemAttrText ( itemtype => itemtype,

572: wf_engine.SetItemAttrText ( itemtype => itemtype,
573: itemkey => itemkey,
574: aname => 'CONS_SOB_FLAG',
575: avalue => l_cons_sob_flag );
576: wf_engine.SetItemAttrText ( itemtype => itemtype,
577: itemkey => itemkey,
578: aname => 'BUDGETARY_CONTROL_FLAG',
579: avalue => l_budgetary_control_flag );
580: diagn_msg('Get_SOB_Attributes: budgetary control flag = '||l_budgetary_control_flag);

Line 582: wf_engine.SetItemAttrText ( itemtype => itemtype,

578: aname => 'BUDGETARY_CONTROL_FLAG',
579: avalue => l_budgetary_control_flag );
580: diagn_msg('Get_SOB_Attributes: budgetary control flag = '||l_budgetary_control_flag);
581:
582: wf_engine.SetItemAttrText ( itemtype => itemtype,
583: itemkey => itemkey,
584: aname => 'AUTOMATIC_TAX_FLAG',
585: avalue => l_enable_automatic_tax_flag );
586:

Line 587: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

583: itemkey => itemkey,
584: aname => 'AUTOMATIC_TAX_FLAG',
585: avalue => l_enable_automatic_tax_flag );
586:
587: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
588: itemkey => itemkey,
589: aname => 'LATEST_ENCUMBRANCE_YEAR',
590: avalue => l_latest_encumbrance_year );
591:

Line 601: wf_engine.SetItemAttrNumber( itemtype => itemtype,

597: AND jeh.currency_code <> 'STAT'
598: AND jel.je_header_id = jeh.je_header_id;
599:
600: -- Copy the corresponding item attribute in workflow
601: wf_engine.SetItemAttrNumber( itemtype => itemtype,
602: itemkey => itemkey,
603: aname => 'BATCH_TOTAL',
604: avalue => l_ledger_approval_amount );
605:

Line 643: l_je_batch_id := wf_engine.GetItemAttrNumber(

639:
640: IF ( funcmode = 'RUN' ) THEN
641:
642: -- Get JE batch ID (primary key)
643: l_je_batch_id := wf_engine.GetItemAttrNumber(
644: itemtype => itemtype,
645: itemkey => itemkey,
646: aname => 'BATCH_ID');
647:

Line 672: wf_engine.SetItemAttrText ( itemtype => itemtype,

668:
669: diagn_msg('JEB Attributes retrieved from db');
670:
671: -- Copy JE batch name to corresponding item attribute in workflow
672: wf_engine.SetItemAttrText ( itemtype => itemtype,
673: itemkey => itemkey,
674: aname => 'BATCH_NAME',
675: avalue => l_je_batch_name );
676: diagn_msg('get_jeb_attributes JEB name = ' || l_je_batch_name);

Line 679: wf_engine.SetItemAttrText ( itemtype => itemtype,

675: avalue => l_je_batch_name );
676: diagn_msg('get_jeb_attributes JEB name = ' || l_je_batch_name);
677:
678: -- Copy JE batch period name to corresponding item attribute in workflow
679: wf_engine.SetItemAttrText ( itemtype => itemtype,
680: itemkey => itemkey,
681: aname => 'PERIOD_NAME',
682: avalue => l_period_name );
683: diagn_msg('get_jeb_attributes JEB period name = ' ||l_period_name );

Line 686: wf_engine.SetItemAttrText ( itemtype => itemtype,

682: avalue => l_period_name );
683: diagn_msg('get_jeb_attributes JEB period name = ' ||l_period_name );
684:
685: -- Copy control total of the batch in workflow
686: wf_engine.SetItemAttrText ( itemtype => itemtype,
687: itemkey => itemkey,
688: aname => 'CONTROL_TOTAL',
689: avalue => l_control_total );
690:

Line 692: wf_engine.SetItemAttrText ( itemtype => itemtype,

688: aname => 'CONTROL_TOTAL',
689: avalue => l_control_total );
690:
691: -- Copy running totals of the batch in workflow
692: wf_engine.SetItemAttrText ( itemtype => itemtype,
693: itemkey => itemkey,
694: aname => 'RUNNING_TOTAL_DR',
695: avalue => l_running_total_dr );
696: wf_engine.SetItemAttrText ( itemtype => itemtype,

Line 696: wf_engine.SetItemAttrText ( itemtype => itemtype,

692: wf_engine.SetItemAttrText ( itemtype => itemtype,
693: itemkey => itemkey,
694: aname => 'RUNNING_TOTAL_DR',
695: avalue => l_running_total_dr );
696: wf_engine.SetItemAttrText ( itemtype => itemtype,
697: itemkey => itemkey,
698: aname => 'RUNNING_TOTAL_CR',
699: avalue => l_running_total_cr );
700:

Line 702: wf_engine.SetItemAttrText ( itemtype => itemtype,

698: aname => 'RUNNING_TOTAL_CR',
699: avalue => l_running_total_cr );
700:
701: -- Copy budgetary control status item attribute in workflow
702: wf_engine.SetItemAttrText ( itemtype => itemtype,
703: itemkey => itemkey,
704: aname => 'BUDGETARY_CONTROL_STATUS',
705: avalue => l_budgetary_status );
706: diagn_msg('get_jeb_attributes budgetary control status = ' || l_budgetary_status);

Line 709: wf_engine.SetItemAttrText ( itemtype => itemtype,

705: avalue => l_budgetary_status );
706: diagn_msg('get_jeb_attributes budgetary control status = ' || l_budgetary_status);
707:
708: -- Copy actual flag to corresponding item attribute in workflow
709: wf_engine.SetItemAttrText ( itemtype => itemtype,
710: itemkey => itemkey,
711: aname => 'BALANCE_TYPE',
712: avalue => l_balance_type );
713: diagn_msg('get_jeb_attributes: Balance Type = ' || l_balance_type);

Line 726: wf_engine.SetItemAttrText ( itemtype => itemtype,

722: 'autoquery_coordination=INITIAL ' ||
723: 'autoquery_criteria=' || to_char(l_je_batch_id);
724: END IF;
725:
726: wf_engine.SetItemAttrText ( itemtype => itemtype,
727: itemkey => itemkey,
728: aname => 'ENTER_JOURNALS_FORM',
729: avalue => l_enter_journals );
730:

Line 782: l_je_batch_id := wf_engine.GetItemAttrNumber(

778:
779: IF ( funcmode = 'RUN' ) THEN
780:
781: -- Get the batch id
782: l_je_batch_id := wf_engine.GetItemAttrNumber(
783: itemtype => itemtype,
784: itemkey => itemkey,
785: aname => 'BATCH_ID');
786: diagn_msg('Is JE Valid: Batch Id = ' || to_char(l_je_batch_id));

Line 789: l_control_total := wf_engine.GetItemAttrNumber(

785: aname => 'BATCH_ID');
786: diagn_msg('Is JE Valid: Batch Id = ' || to_char(l_je_batch_id));
787:
788: -- Get the control total and running totals for the batch.
789: l_control_total := wf_engine.GetItemAttrNumber(
790: itemtype => itemtype,
791: itemkey => itemkey,
792: aname => 'CONTROL_TOTAL');
793: diagn_msg('Is JE Valid: Control Total = ' ||to_char(l_control_total));

Line 794: l_running_total_dr := wf_engine.GetItemAttrNumber(

790: itemtype => itemtype,
791: itemkey => itemkey,
792: aname => 'CONTROL_TOTAL');
793: diagn_msg('Is JE Valid: Control Total = ' ||to_char(l_control_total));
794: l_running_total_dr := wf_engine.GetItemAttrNumber(
795: itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'RUNNING_TOTAL_DR');
798: diagn_msg('Is JE Valid: Running Total Debit = ' ||to_char(l_running_total_dr));

Line 799: l_running_total_cr := wf_engine.GetItemAttrNumber(

795: itemtype => itemtype,
796: itemkey => itemkey,
797: aname => 'RUNNING_TOTAL_DR');
798: diagn_msg('Is JE Valid: Running Total Debit = ' ||to_char(l_running_total_dr));
799: l_running_total_cr := wf_engine.GetItemAttrNumber(
800: itemtype => itemtype,
801: itemkey => itemkey,
802: aname => 'RUNNING_TOTAL_CR');
803: diagn_msg('Is JE Valid: Running Total Credit = ' ||to_char(l_running_total_cr));

Line 806: l_balance_type := wf_engine.GetItemAttrText(

802: aname => 'RUNNING_TOTAL_CR');
803: diagn_msg('Is JE Valid: Running Total Credit = ' ||to_char(l_running_total_cr));
804:
805: -- Get the actual flag
806: l_balance_type := wf_engine.GetItemAttrText(
807: itemtype => itemtype,
808: itemkey => itemkey,
809: aname => 'BALANCE_TYPE');
810: diagn_msg('Is JE Valid: Balance Type = ' ||l_balance_type);

Line 813: l_budgetary_status := wf_engine.GetItemAttrText(

809: aname => 'BALANCE_TYPE');
810: diagn_msg('Is JE Valid: Balance Type = ' ||l_balance_type);
811:
812: -- Get the budgetary control status
813: l_budgetary_status := wf_engine.GetItemAttrText(
814: itemtype => itemtype,
815: itemkey => itemkey,
816: aname => 'BUDGETARY_CONTROL_STATUS');
817: diagn_msg('Is JE Valid: Budgetary Control Status = ' ||l_budgetary_status);

Line 828: wf_engine.SetItemAttrText( itemtype,

824: IF check_untaxed%FOUND THEN
825: CLOSE check_untaxed;
826: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_UNTAXED');
827: l_invalid_error := FND_MESSAGE.Get;
828: wf_engine.SetItemAttrText( itemtype,
829: itemkey,
830: 'INVALID_JE_ERROR',
831: l_invalid_error );
832: result := 'COMPLETE:N';

Line 849: wf_engine.SetItemAttrText( itemtype,

845:
846: IF (l_budgetary_control_flag = 'Y' AND l_budgetary_status <> 'P') THEN
847: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_RESERVE_FUNDS');
848: l_invalid_error := FND_MESSAGE.Get;
849: wf_engine.SetItemAttrText( itemtype,
850: itemkey,
851: 'INVALID_JE_ERROR',
852: l_invalid_error );
853: result := 'COMPLETE:N';

Line 870: wf_engine.SetItemAttrText( itemtype,

866: null;
867: ELSE
868: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_CONTROL_TOTAL');
869: l_invalid_error := FND_MESSAGE.Get;
870: wf_engine.SetItemAttrText( itemtype,
871: itemkey,
872: 'INVALID_JE_ERROR',
873: l_invalid_error);
874: result := 'COMPLETE:N';

Line 906: l_je_batch_id := wf_engine.GetItemAttrNumber(

902: l_je_batch_id NUMBER;
903: BEGIN
904: IF ( funcmode = 'RUN' ) THEN
905: -- Get JE batch ID
906: l_je_batch_id := wf_engine.GetItemAttrNumber(
907: itemtype => itemtype,
908: itemkey => itemkey,
909: aname => 'BATCH_ID');
910:

Line 950: l_je_batch_id := wf_engine.GetItemAttrNumber(

946: AND currency_code <> 'STAT');
947: BEGIN
948: IF ( funcmode = 'RUN' ) THEN
949: -- Get JE batch ID (primary key)
950: l_je_batch_id := wf_engine.GetItemAttrNumber(
951: itemtype => itemtype,
952: itemkey => itemkey,
953: aname => 'BATCH_ID');
954:

Line 992: l_je_batch_id := wf_engine.GetItemAttrNumber(

988: l_je_batch_id NUMBER;
989: BEGIN
990: IF ( funcmode = 'RUN' ) THEN
991: -- Get JE batch ID
992: l_je_batch_id := wf_engine.GetItemAttrNumber(
993: itemtype => itemtype,
994: itemkey => itemkey,
995: aname => 'BATCH_ID');
996:

Line 1028: l_preparer_id := wf_engine.GetItemAttrNumber(

1024: l_profile_option_val fnd_profile_option_values.profile_option_value%TYPE;
1025: BEGIN
1026: IF ( funcmode = 'RUN' ) THEN
1027: -- Get the preparer_id
1028: l_preparer_id := wf_engine.GetItemAttrNumber(
1029: itemtype => itemtype,
1030: itemkey => itemkey,
1031: aname => 'PREPARER_ID');
1032:

Line 1034: l_batch_id := wf_engine.GetItemAttrNumber(

1030: itemkey => itemkey,
1031: aname => 'PREPARER_ID');
1032:
1033: -- Get batch id
1034: l_batch_id := wf_engine.GetItemAttrNumber(
1035: itemtype => itemtype,
1036: itemkey => itemkey,
1037: aname => 'BATCH_ID');
1038:

Line 1078: l_preparer_id := wf_engine.GetItemAttrNumber(

1074: l_preparer_name VARCHAR2(240);
1075: l_preparer_display_name VARCHAR2(240);
1076: BEGIN
1077: IF ( funcmode = 'RUN' ) THEN
1078: l_preparer_id := wf_engine.GetItemAttrNumber(
1079: itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'PREPARER_ID' );
1082: l_preparer_name := wf_engine.GetItemAttrText(

Line 1082: l_preparer_name := wf_engine.GetItemAttrText(

1078: l_preparer_id := wf_engine.GetItemAttrNumber(
1079: itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'PREPARER_ID' );
1082: l_preparer_name := wf_engine.GetItemAttrText(
1083: itemtype => itemtype,
1084: itemkey => itemkey,
1085: aname => 'PREPARER_NAME');
1086: l_preparer_display_name := wf_engine.GetItemAttrText(

Line 1086: l_preparer_display_name := wf_engine.GetItemAttrText(

1082: l_preparer_name := wf_engine.GetItemAttrText(
1083: itemtype => itemtype,
1084: itemkey => itemkey,
1085: aname => 'PREPARER_NAME');
1086: l_preparer_display_name := wf_engine.GetItemAttrText(
1087: itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => 'PREPARER_DISPLAY_NAME');
1090:

Line 1091: wf_engine.SetItemAttrNumber( itemtype => itemtype,

1087: itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => 'PREPARER_DISPLAY_NAME');
1090:
1091: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1092: itemkey => itemkey,
1093: aname => 'APPROVER_ID',
1094: avalue => l_preparer_id );
1095: wf_engine.SetItemAttrText( itemtype => itemtype,

Line 1095: wf_engine.SetItemAttrText( itemtype => itemtype,

1091: wf_engine.SetItemAttrNumber( itemtype => itemtype,
1092: itemkey => itemkey,
1093: aname => 'APPROVER_ID',
1094: avalue => l_preparer_id );
1095: wf_engine.SetItemAttrText( itemtype => itemtype,
1096: itemkey => itemkey,
1097: aname => 'APPROVER_NAME',
1098: avalue => l_preparer_name );
1099: wf_engine.SetItemAttrText( itemtype => itemtype,

Line 1099: wf_engine.SetItemAttrText( itemtype => itemtype,

1095: wf_engine.SetItemAttrText( itemtype => itemtype,
1096: itemkey => itemkey,
1097: aname => 'APPROVER_NAME',
1098: avalue => l_preparer_name );
1099: wf_engine.SetItemAttrText( itemtype => itemtype,
1100: itemkey => itemkey,
1101: aname => 'APPROVER_DISPLAY_NAME',
1102: avalue => l_preparer_display_name );
1103: diagn_msg('Approver name set for JE batch ');

Line 1130: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1126: l_je_batch_id NUMBER;
1127: l_approver_id NUMBER;
1128: BEGIN
1129: IF (funcmode = 'RUN') THEN
1130: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1131: itemkey => itemkey,
1132: aname => 'BATCH_ID' );
1133: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1134: itemkey => itemkey,

Line 1133: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1129: IF (funcmode = 'RUN') THEN
1130: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1131: itemkey => itemkey,
1132: aname => 'BATCH_ID' );
1133: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1134: itemkey => itemkey,
1135: aname => 'APPROVER_ID' );
1136:
1137: UPDATE GL_JE_BATCHES

Line 1167: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1163: l_param_list WF_PARAMETER_LIST_T := wf_parameter_list_t();
1164: BEGIN
1165: IF ( funcmode = 'RUN' ) THEN
1166: diagn_msg('Executing Approve_JE');
1167: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1168: itemkey => itemkey,
1169: aname => 'BATCH_ID' );
1170:
1171: UPDATE GL_JE_BATCHES

Line 1209: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1205: result OUT NOCOPY VARCHAR2) IS
1206: l_je_batch_id NUMBER;
1207: BEGIN
1208: IF ( funcmode = 'RUN' ) THEN
1209: l_je_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1210: itemkey => itemkey,
1211: aname => 'BATCH_ID' );
1212:
1213: UPDATE GL_JE_BATCHES

Line 1255: l_employee_id := wf_engine.GetItemAttrNumber(item_type,

1251:
1252: IF (funcmode = 'RUN') THEN
1253: diagn_msg('Entering Find_Approver activity');
1254:
1255: l_employee_id := wf_engine.GetItemAttrNumber(item_type,
1256: item_key,
1257: 'PREPARER_ID');
1258: l_curr_approver_id := wf_engine.GetItemAttrNumber(item_type,
1259: item_key,

Line 1258: l_curr_approver_id := wf_engine.GetItemAttrNumber(item_type,

1254:
1255: l_employee_id := wf_engine.GetItemAttrNumber(item_type,
1256: item_key,
1257: 'PREPARER_ID');
1258: l_curr_approver_id := wf_engine.GetItemAttrNumber(item_type,
1259: item_key,
1260: 'APPROVER_ID');
1261: l_resp_id := wf_engine.GetItemAttrNumber(item_type,
1262: item_key,

Line 1261: l_resp_id := wf_engine.GetItemAttrNumber(item_type,

1257: 'PREPARER_ID');
1258: l_curr_approver_id := wf_engine.GetItemAttrNumber(item_type,
1259: item_key,
1260: 'APPROVER_ID');
1261: l_resp_id := wf_engine.GetItemAttrNumber(item_type,
1262: item_key,
1263: 'PREPARER_RESP_ID');
1264: l_user_id := wf_engine.GetItemAttrNumber(item_type,
1265: item_key,

Line 1264: l_user_id := wf_engine.GetItemAttrNumber(item_type,

1260: 'APPROVER_ID');
1261: l_resp_id := wf_engine.GetItemAttrNumber(item_type,
1262: item_key,
1263: 'PREPARER_RESP_ID');
1264: l_user_id := wf_engine.GetItemAttrNumber(item_type,
1265: item_key,
1266: 'PREPARER_FND_ID');
1267:
1268: -- Get the profile option value for approver method

Line 1280: l_find_approver_counter := wf_engine.GetItemAttrNumber(

1276: IF (l_find_approver_method IS NULL) THEN
1277: l_find_approver_method := 'CHAIN';
1278: END IF;
1279:
1280: l_find_approver_counter := wf_engine.GetItemAttrNumber(
1281: item_type,
1282: item_key,
1283: 'FIND_APPROVER_COUNTER');
1284:

Line 1301: wf_engine.SetItemAttrText( item_type,

1297: ELSE
1298: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_MANAGER');
1299: l_error_message := FND_MESSAGE.Get;
1300:
1301: wf_engine.SetItemAttrText( item_type,
1302: item_key,
1303: 'ERROR_MESSAGE',
1304: l_error_message);
1305:

Line 1329: WF_ENGINE.SetItemAttrText( item_type,

1325: IF (l_next_approver_id IS NULL) THEN
1326: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_CANNOT_FIND_APPROVER');
1327: l_error_message := FND_MESSAGE.Get;
1328:
1329: WF_ENGINE.SetItemAttrText( item_type,
1330: item_key,
1331: 'ERROR_MESSAGE',
1332: l_error_message);
1333:

Line 1341: WF_ENGINE.SetItemAttrNumber(item_type,

1337: item_type,
1338: item_key,
1339: 'APPROVER');
1340:
1341: WF_ENGINE.SetItemAttrNumber(item_type,
1342: item_key,
1343: 'FIND_APPROVER_COUNTER',
1344: l_find_approver_counter + 1);
1345:

Line 1379: l_find_approver_counter := WF_ENGINE.GetItemAttrNumber(

1375: BEGIN
1376: IF (funcmode = 'RUN') THEN
1377: diagn_msg('First_Approver: Retrieving Find_Approver_Counter Item Attribute');
1378:
1379: l_find_approver_counter := WF_ENGINE.GetItemAttrNumber(
1380: item_type,
1381: item_key,
1382: 'FIND_APPROVER_COUNTER');
1383:

Line 1385: WF_ENGINE.SetItemAttrText(item_type,

1381: item_key,
1382: 'FIND_APPROVER_COUNTER');
1383:
1384: -- Set the approver comment attribute to null
1385: WF_ENGINE.SetItemAttrText(item_type,
1386: item_key,
1387: 'APPROVER_COMMENT',
1388: '');
1389:

Line 1394: WF_ENGINE.SetItemAttrText(item_type,

1390: IF (l_find_approver_counter = 1) THEN
1391: result := 'COMPLETE:Y';
1392:
1393: --bugfix 2926418
1394: WF_ENGINE.SetItemAttrText(item_type,
1395: item_key,
1396: 'COMMENT_FROM',
1397: '');
1398:

Line 1400: l_preparer_name := WF_ENGINE.GetItemAttrText(

1396: 'COMMENT_FROM',
1397: '');
1398:
1399: -- Put preparer name as the forward from name
1400: l_preparer_name := WF_ENGINE.GetItemAttrText(
1401: item_type,
1402: item_key,
1403: 'PREPARER_NAME');
1404: WF_ENGINE.SetItemAttrText(item_type,

Line 1404: WF_ENGINE.SetItemAttrText(item_type,

1400: l_preparer_name := WF_ENGINE.GetItemAttrText(
1401: item_type,
1402: item_key,
1403: 'PREPARER_NAME');
1404: WF_ENGINE.SetItemAttrText(item_type,
1405: item_key,
1406: 'FORWARD_FROM_NAME',
1407: l_preparer_name);
1408: ELSE

Line 1412: l_forward_from_display_name := WF_ENGINE.GetItemAttrText(

1408: ELSE
1409: result := 'COMPLETE:N';
1410:
1411: --bugfix 2926418
1412: l_forward_from_display_name := WF_ENGINE.GetItemAttrText(
1413: item_type,
1414: item_key,
1415: 'FORWARD_FROM_DISPLAY_NAME');
1416:

Line 1421: WF_ENGINE.SetItemAttrText(item_type,

1417: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_FORWARD_COMMENT_FROM');
1418: FND_MESSAGE.Set_Token('APPROVER_NAME', l_forward_from_display_name);
1419: l_forward_comment_from := FND_MESSAGE.Get;
1420:
1421: WF_ENGINE.SetItemAttrText(item_type,
1422: item_key,
1423: 'COMMENT_FROM',
1424: l_forward_comment_from);
1425: END IF;

Line 1463: -- wf_engine.context_text = new responder

1459:
1460: BEGIN
1461:
1462: IF (funcmode = 'RESPOND') THEN
1463: -- wf_engine.context_text = new responder
1464: l_notification_id := wf_engine.context_nid;
1465:
1466: SELECT original_recipient
1467: INTO l_role

Line 1464: l_notification_id := wf_engine.context_nid;

1460: BEGIN
1461:
1462: IF (funcmode = 'RESPOND') THEN
1463: -- wf_engine.context_text = new responder
1464: l_notification_id := wf_engine.context_nid;
1465:
1466: SELECT original_recipient
1467: INTO l_role
1468: FROM wf_notifications

Line 1471: l_Transferee := wf_engine.context_text;

1467: INTO l_role
1468: FROM wf_notifications
1469: WHERE notification_id = l_notification_id;
1470:
1471: l_Transferee := wf_engine.context_text;
1472:
1473: OPEN c_person_id;
1474: FETCH c_person_id into l_TransferToID;
1475:

Line 1477: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1473: OPEN c_person_id;
1474: FETCH c_person_id into l_TransferToID;
1475:
1476: IF c_person_id%NOTFOUND THEN
1477: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1478: Wf_Core.Raise(wf_core.translate('NO_ROLE_FOUND'));
1479: RETURN;
1480: ELSE
1481: IF l_TransferToID IS NULL THEN

Line 1482: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;

1478: Wf_Core.Raise(wf_core.translate('NO_ROLE_FOUND'));
1479: RETURN;
1480: ELSE
1481: IF l_TransferToID IS NULL THEN
1482: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1483: Wf_Core.Raise(wf_core.translate('PERSON_ID_NULL'));
1484: RETURN;
1485: END IF;
1486: END IF;

Line 1517: l_approver_id := WF_ENGINE.GetItemAttrNumber(item_type,

1513: l_approver_id NUMBER;
1514: l_manager_id NUMBER;
1515: BEGIN
1516: IF (funcmode = 'RUN') THEN
1517: l_approver_id := WF_ENGINE.GetItemAttrNumber(item_type,
1518: item_key,
1519: 'APPROVER_ID');
1520:
1521: l_manager_id := WF_ENGINE.GetItemAttrNumber(item_type,

Line 1521: l_manager_id := WF_ENGINE.GetItemAttrNumber(item_type,

1517: l_approver_id := WF_ENGINE.GetItemAttrNumber(item_type,
1518: item_key,
1519: 'APPROVER_ID');
1520:
1521: l_manager_id := WF_ENGINE.GetItemAttrNumber(item_type,
1522: item_key,
1523: 'MANAGER_ID');
1524:
1525: IF (l_approver_id <> l_manager_id) THEN

Line 1558: l_count := WF_ENGINE.GetItemAttrNumber(item_type,

1554: l_count NUMBER;
1555: l_limit NUMBER;
1556: BEGIN
1557: IF (funcmode = 'RUN') THEN
1558: l_count := WF_ENGINE.GetItemAttrNumber(item_type,
1559: item_key,
1560: 'MANAGER_APPROVAL_SEND_COUNT');
1561:
1562: l_limit := WF_ENGINE.GetActivityAttrNumber(item_type,

Line 1562: l_limit := WF_ENGINE.GetActivityAttrNumber(item_type,

1558: l_count := WF_ENGINE.GetItemAttrNumber(item_type,
1559: item_key,
1560: 'MANAGER_APPROVAL_SEND_COUNT');
1561:
1562: l_limit := WF_ENGINE.GetActivityAttrNumber(item_type,
1563: item_key,
1564: actid,
1565: 'MANAGER_SEND_LIMIT');
1566:

Line 1567: WF_ENGINE.SetItemAttrNumber(item_type,

1563: item_key,
1564: actid,
1565: 'MANAGER_SEND_LIMIT');
1566:
1567: WF_ENGINE.SetItemAttrNumber(item_type,
1568: item_key,
1569: 'MANAGER_APPROVAL_SEND_COUNT',
1570: l_count + 1);
1571:

Line 1573: WF_ENGINE.SetItemAttrNumber(item_type,

1569: 'MANAGER_APPROVAL_SEND_COUNT',
1570: l_count + 1);
1571:
1572: IF (l_count+1 >= l_limit) THEN
1573: WF_ENGINE.SetItemAttrNumber(item_type,
1574: item_key,
1575: 'MANAGER_APPROVAL_SEND_COUNT',
1576: 0);
1577: result := 'COMPLETE:Y';

Line 1608: l_approver_id := WF_ENGINE.GetItemAttrNumber( item_type,

1604: l_manager_id NUMBER;
1605: BEGIN
1606:
1607: IF ( funcmode = 'RUN' ) THEN
1608: l_approver_id := WF_ENGINE.GetItemAttrNumber( item_type,
1609: item_key,
1610: 'APPROVER_ID' );
1611:
1612: getmanager(l_approver_id, l_manager_id);

Line 1651: l_approver_id := WF_ENGINE.GetItemAttrNumber(item_type,

1647: l_approver_display_name VARCHAR2(240);
1648: l_approver_comment VARCHAR2(2000);
1649: BEGIN
1650: IF (funcmode = 'RUN') THEN
1651: l_approver_id := WF_ENGINE.GetItemAttrNumber(item_type,
1652: item_key,
1653: 'APPROVER_ID');
1654:
1655: l_approver_name := WF_ENGINE.GetItemAttrText(item_type,

Line 1655: l_approver_name := WF_ENGINE.GetItemAttrText(item_type,

1651: l_approver_id := WF_ENGINE.GetItemAttrNumber(item_type,
1652: item_key,
1653: 'APPROVER_ID');
1654:
1655: l_approver_name := WF_ENGINE.GetItemAttrText(item_type,
1656: item_key,
1657: 'APPROVER_NAME');
1658:
1659: l_approver_display_name := WF_ENGINE.GetItemAttrText(

Line 1659: l_approver_display_name := WF_ENGINE.GetItemAttrText(

1655: l_approver_name := WF_ENGINE.GetItemAttrText(item_type,
1656: item_key,
1657: 'APPROVER_NAME');
1658:
1659: l_approver_display_name := WF_ENGINE.GetItemAttrText(
1660: item_type,
1661: item_key,
1662: 'APPROVER_DISPLAY_NAME');
1663:

Line 1664: l_approver_comment := WF_ENGINE.GetItemAttrText(item_type,

1660: item_type,
1661: item_key,
1662: 'APPROVER_DISPLAY_NAME');
1663:
1664: l_approver_comment := WF_ENGINE.GetItemAttrText(item_type,
1665: item_key,
1666: 'APPROVER_COMMENT');
1667:
1668: WF_ENGINE.SetItemAttrNumber(item_type,

Line 1668: WF_ENGINE.SetItemAttrNumber(item_type,

1664: l_approver_comment := WF_ENGINE.GetItemAttrText(item_type,
1665: item_key,
1666: 'APPROVER_COMMENT');
1667:
1668: WF_ENGINE.SetItemAttrNumber(item_type,
1669: item_key,
1670: 'FORWARD_FROM_ID',
1671: l_approver_id);
1672:

Line 1673: WF_ENGINE.SetItemAttrText(item_type,

1669: item_key,
1670: 'FORWARD_FROM_ID',
1671: l_approver_id);
1672:
1673: WF_ENGINE.SetItemAttrText(item_type,
1674: item_key,
1675: 'FORWARD_FROM_NAME',
1676: l_approver_name);
1677:

Line 1678: WF_ENGINE.SetItemAttrText(item_type,

1674: item_key,
1675: 'FORWARD_FROM_NAME',
1676: l_approver_name);
1677:
1678: WF_ENGINE.SetItemAttrText(item_type,
1679: item_key,
1680: 'FORWARD_FROM_DISPLAY_NAME',
1681: l_approver_display_name);
1682:

Line 1684: WF_ENGINE.SetItemAttrText(item_type,

1680: 'FORWARD_FROM_DISPLAY_NAME',
1681: l_approver_display_name);
1682:
1683: -- bugfix 2926418
1684: WF_ENGINE.SetItemAttrText(item_type,
1685: item_key,
1686: 'FORWARD_APPROVER_COMMENT',
1687: l_approver_comment);
1688:

Line 1716: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1712: BEGIN
1713: IF ( funcmode = 'RUN' ) THEN
1714:
1715: diagn_msg('Executing Verify_Authority');
1716: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1717: itemkey => itemkey,
1718: aname => 'APPROVER_ID' );
1719: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1720: itemkey => itemkey,

Line 1719: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1715: diagn_msg('Executing Verify_Authority');
1716: l_approver_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1717: itemkey => itemkey,
1718: aname => 'APPROVER_ID' );
1719: l_batch_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1720: itemkey => itemkey,
1721: aname => 'BATCH_ID' );
1722:
1723: IF (check_authorization_limit(l_approver_id, l_batch_id)) THEN

Line 1754: l_je_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1750: l_je_batch_id NUMBER;
1751: BEGIN
1752: IF (funcmode = 'RUN') THEN
1753: -- reset approval status of JE batch back to 'Required'
1754: l_je_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1755: itemkey => itemkey,
1756: aname => 'BATCH_ID');
1757:
1758: UPDATE GL_JE_BATCHES

Line 1763: WF_ENGINE.AbortProcess(itemtype, itemkey, '', WF_ENGINE.eng_timeout);

1759: SET approval_status_code = 'R'
1760: WHERE je_batch_id = l_je_batch_id;
1761:
1762: -- then abort the process
1763: WF_ENGINE.AbortProcess(itemtype, itemkey, '', WF_ENGINE.eng_timeout);
1764:
1765: ELSIF (funcmode = 'CANCEL') THEN
1766: null;
1767: END IF;