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 851: wf_engine.SetItemAttrText( itemtype,

847: l_budgetary_status <> 'P'
848: AND l_balance_type <> 'B') THEN /* added this condition for bug7531835 */
849: FND_MESSAGE.Set_Name('SQLGL', 'GL_WF_INVALID_RESERVE_FUNDS');
850: l_invalid_error := FND_MESSAGE.Get;
851: wf_engine.SetItemAttrText( itemtype,
852: itemkey,
853: 'INVALID_JE_ERROR',
854: l_invalid_error );
855: result := 'COMPLETE:N';

Line 872: wf_engine.SetItemAttrText( itemtype,

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

Line 908: l_je_batch_id := wf_engine.GetItemAttrNumber(

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

Line 952: l_je_batch_id := wf_engine.GetItemAttrNumber(

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

Line 994: l_je_batch_id := wf_engine.GetItemAttrNumber(

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

Line 1030: l_preparer_id := wf_engine.GetItemAttrNumber(

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

Line 1036: l_batch_id := wf_engine.GetItemAttrNumber(

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

Line 1080: l_preparer_id := wf_engine.GetItemAttrNumber(

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

Line 1084: l_preparer_name := wf_engine.GetItemAttrText(

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

Line 1088: l_preparer_display_name := wf_engine.GetItemAttrText(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1282: l_find_approver_counter := wf_engine.GetItemAttrNumber(

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

Line 1303: wf_engine.SetItemAttrText( item_type,

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

Line 1331: WF_ENGINE.SetItemAttrText( item_type,

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

Line 1343: WF_ENGINE.SetItemAttrNumber(item_type,

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

Line 1381: l_find_approver_counter := WF_ENGINE.GetItemAttrNumber(

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

Line 1387: WF_ENGINE.SetItemAttrText(item_type,

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

Line 1396: WF_ENGINE.SetItemAttrText(item_type,

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

Line 1402: l_preparer_name := WF_ENGINE.GetItemAttrText(

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

Line 1406: WF_ENGINE.SetItemAttrText(item_type,

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

Line 1414: l_forward_from_display_name := WF_ENGINE.GetItemAttrText(

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

Line 1423: WF_ENGINE.SetItemAttrText(item_type,

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

Line 1465: -- wf_engine.context_text = new responder

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

Line 1466: l_notification_id := wf_engine.context_nid;

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

Line 1473: l_Transferee := wf_engine.context_text;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1569: WF_ENGINE.SetItemAttrNumber(item_type,

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

Line 1575: WF_ENGINE.SetItemAttrNumber(item_type,

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

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

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

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

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

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

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

Line 1661: l_approver_display_name := WF_ENGINE.GetItemAttrText(

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

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

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

Line 1670: WF_ENGINE.SetItemAttrNumber(item_type,

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

Line 1675: WF_ENGINE.SetItemAttrText(item_type,

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

Line 1680: WF_ENGINE.SetItemAttrText(item_type,

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

Line 1686: WF_ENGINE.SetItemAttrText(item_type,

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

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

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

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

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

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

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

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

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