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.IGIDOSL dependencies on WF_ENGINE

Line 138: l_work_item_org_id := wf_engine.GetItemAttrNumber

134: -- the workflow safely
135:
136: fnd_profile.get (name=>'ORG_ID', val=> l_session_org_id);
137:
138: l_work_item_org_id := wf_engine.GetItemAttrNumber
139: (itemtype,
140: itemkey,
141: 'ORG_ID');
142:

Line 163: l_user_id := wf_engine.GetItemAttrNumber

159:
160: DEBUG_LOG_STRING (l_proc_level, 'Selector.Msg',
161: ' Getting apps context with userid, respid, applid ' );
162:
163: l_user_id := wf_engine.GetItemAttrNumber
164: (itemtype,
165: itemkey,
166: 'USER_ID');
167: l_resp_id := wf_engine.GetItemAttrNumber

Line 167: l_resp_id := wf_engine.GetItemAttrNumber

163: l_user_id := wf_engine.GetItemAttrNumber
164: (itemtype,
165: itemkey,
166: 'USER_ID');
167: l_resp_id := wf_engine.GetItemAttrNumber
168: (itemtype,
169: itemkey,
170: 'RESPONSIBILITY_ID');
171: l_appl_id := wf_engine.GetItemAttrNumber

Line 171: l_appl_id := wf_engine.GetItemAttrNumber

167: l_resp_id := wf_engine.GetItemAttrNumber
168: (itemtype,
169: itemkey,
170: 'RESPONSIBILITY_ID');
171: l_appl_id := wf_engine.GetItemAttrNumber
172: (itemtype,
173: itemkey,
174: 'RESP_APPL_ID');
175:

Line 323: Wf_Engine.CreateProcess ( itemtype => ItemType,

319: /* =============== END DEBUG LOG ================== */
320:
321: -- Workflow Initiation
322: --4124934 added Process parameter
323: Wf_Engine.CreateProcess ( itemtype => ItemType,
324: itemkey => ItemKey,
325: process => 'DOSFLOWE');
326:
327: /* =============== START DEBUG LOG ================ */

Line 338: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,

334: --
335: -- Assign workflow item attribute values
336: --
337:
338: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,
339: itemkey => ItemKey,
340: aname => 'DOSSIER_ID',
341: avalue => Dossier_Id);
342:

Line 348: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

344: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg10',
345: ' Dossier id --> ' || Dossier_id);
346: /* =============== END DEBUG LOG ================== */
347:
348: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
349: itemkey => ItemKey,
350: aname => 'DOSSIER_NUM',
351: avalue => Dossier_Num);
352:

Line 358: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

354: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg11',
355: ' Dossier Num --> ' || Dossier_num);
356: /* =============== END DEBUG LOG ================== */
357:
358: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
359: itemkey => ItemKey,
360: aname => 'INITIAL_ENTRY_FLAG',
361: avalue => 'TRUE');
362:

Line 368: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,

364: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg12',
365: ' Initial entry flag --> ' || 'TRUE');
366: /* =============== END DEBUG LOG ================== */
367:
368: Wf_Engine.SetItemAttrNumber ( itemtype => ItemType,
369: itemkey => ItemKey,
370: aname => 'PACKET_ID',
371: avalue => Packet_Id);
372:

Line 378: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

374: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg13',
375: ' Packet id --> ' || Packet_id);
376: /* =============== END DEBUG LOG ================== */
377:
378: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
379: itemkey => ItemKey,
380: aname => 'CREATOR_NAME',
381: avalue => User_Name);
382:

Line 388: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

384: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg14',
385: ' CREATOR_NAME --> ' || User_Name);
386: /* =============== END DEBUG LOG ================== */
387:
388: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
389: itemkey => ItemKey,
390: aname => 'DOSSIER_TRANSACTION_NAME',
391: avalue => Dossier_Transaction_Name);
392:

Line 398: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

394: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg15',
395: ' DOSSIER_TRANSACTION_NAME --> ' || Dossier_Transaction_Name);
396: /* =============== END DEBUG LOG ================== */
397:
398: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
399: itemkey => ItemKey,
400: aname => 'DOSSIER_DESCRIPTION',
401: avalue => Dossier_Description);
402:

Line 414: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

410: CLOSE c_source_total;
411: -- Bug 5138221 .. Start
412: l_formatted_total_amount := TO_CHAR(l_total_amount, FND_CURRENCY.Get_Format_Mask(g_currency_code,22));
413: -- Bug 5138221 .. End
414: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
415: itemkey => ItemKey,
416: aname => 'TOTAL',
417: avalue => l_formatted_total_amount);
418:

Line 425: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

421: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg16',
422: ' TOTAL_AMOUNT --> ' || l_formatted_total_amount);
423: /* =============== END DEBUG LOG ================== */
424:
425: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
426: itemkey => ItemKey,
427: aname => 'DOCUMENT_ID',
428: avalue => itemtype||':'||itemkey);
429:

Line 435: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

431: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg17',
432: ' DOCUMENT_ID --> ' || itemtype||':'||itemkey);
433: /* =============== END DEBUG LOG ================== */
434:
435: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
436: itemkey => ItemKey,
437: aname => 'DOSSIER_TRANSACTION_DETAIL',
438: avalue => 'plsqlclob:igidosl.dossier_transaction_detail/'||itemtype||':'||itemkey);
439:

Line 446: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

442: ' DOSSIER_TRANSACTION_DETAIL --> ' ||
443: 'plsqlclob:igidosl.dossier_transaction_detail/'||itemtype||':'||itemkey);
444: /* =============== END DEBUG LOG ================== */
445:
446: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
447: itemkey => ItemKey,
448: aname => 'USER_ID',
449: avalue => User_Id);
450:

Line 456: Wf_Engine.SetItemAttrText ( itemtype => ItemType,

452: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg19',
453: ' USER_ID --> ' || User_Id );
454: /* =============== END DEBUG LOG ================== */
455:
456: Wf_Engine.SetItemAttrText ( itemtype => ItemType,
457: itemkey => ItemKey,
458: aname => 'RESPONSIBILITY_ID',
459: avalue => Responsibility_Id);
460:

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

470: p_display_name => l_preparer_display_name );
471:
472:
473: -- Copy username to Workflow
474: wf_engine.SetItemAttrText( itemtype => itemtype,
475: itemkey => itemkey,
476: aname => 'PREPARER_NAME',
477: avalue => l_preparer_display_name );
478:

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

481: ' PREPARER_NAME --> ' || l_preparer_display_name );
482: /* =============== END DEBUG LOG ================== */
483:
484: -- Copy displayed username to Workflow
485: wf_engine.SetItemAttrText( itemtype => itemtype,
486: itemkey => itemkey,
487: aname => 'PREPARER_LOGIN_NAME',
488: avalue => l_preparer_name );
489:

Line 504: Wf_Engine.SetItemOwner ( itemtype => ItemType,

500: DEBUG_LOG_STRING (l_proc_level, 'startup.Msg23',
501: ' Setting process attributes ');
502: /* =============== END DEBUG LOG ================== */
503:
504: Wf_Engine.SetItemOwner ( itemtype => ItemType,
505: itemkey => ItemKey,
506: owner => User_name);
507:
508: Wf_Engine.SetItemUserKey ( itemtype => ItemType,

Line 508: Wf_Engine.SetItemUserKey ( itemtype => ItemType,

504: Wf_Engine.SetItemOwner ( itemtype => ItemType,
505: itemkey => ItemKey,
506: owner => User_name);
507:
508: Wf_Engine.SetItemUserKey ( itemtype => ItemType,
509: itemkey => ItemKey,
510: userkey => UserKey);
511:
512: /* =============== START DEBUG LOG ================ */

Line 519: wf_engine.SetItemAttrText ( itemtype => ItemType,

515: /* =============== END DEBUG LOG ================== */
516:
517: -- Set user id, responsibility id , org id and application id context values
518: -- Bug 4124934 , Start
519: wf_engine.SetItemAttrText ( itemtype => ItemType,
520: itemkey => ItemKey,
521: aname => 'ORG_ID',
522: avalue => FND_PROFILE.VALUE('ORG_ID'));
523:

Line 524: wf_engine.SetItemAttrText ( itemtype => ItemType,

520: itemkey => ItemKey,
521: aname => 'ORG_ID',
522: avalue => FND_PROFILE.VALUE('ORG_ID'));
523:
524: wf_engine.SetItemAttrText ( itemtype => ItemType,
525: itemkey => ItemKey,
526: aname => 'USER_ID',
527: avalue => FND_PROFILE.VALUE('USER_ID'));
528:

Line 529: wf_engine.SetItemAttrText ( itemtype => ItemType,

525: itemkey => ItemKey,
526: aname => 'USER_ID',
527: avalue => FND_PROFILE.VALUE('USER_ID'));
528:
529: wf_engine.SetItemAttrText ( itemtype => ItemType,
530: itemkey => ItemKey,
531: aname => 'RESPONSIBILITY_ID',
532: avalue => FND_PROFILE.VALUE('RESP_ID'));
533:

Line 534: wf_engine.SetItemAttrText ( itemtype => ItemType,

530: itemkey => ItemKey,
531: aname => 'RESPONSIBILITY_ID',
532: avalue => FND_PROFILE.VALUE('RESP_ID'));
533:
534: wf_engine.SetItemAttrText ( itemtype => ItemType,
535: itemkey => ItemKey,
536: aname => 'RESP_APPL_ID',
537: avalue => FND_PROFILE.VALUE('RESP_APPL_ID'));
538: -- Bug 4124934 End

Line 543: Wf_Engine.StartProcess ( itemtype => ItemType,

539:
540: --
541: -- Kick-off the workflow process instance
542: --
543: Wf_Engine.StartProcess ( itemtype => ItemType,
544: itemkey => ItemKey);
545:
546: COMMIT;
547:

Line 593: l_picked_role := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

589:
590: RETURN;
591: END IF;
592:
593: l_picked_role := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
594: itemkey => itemkey,
595: aname => 'PICKED_ROLE');
596:
597: /* =============== START DEBUG LOG ================ */

Line 602: Wf_Engine.SetItemAttrText ( itemtype => itemtype,

598: DEBUG_LOG_STRING (l_proc_level, 'setrole.Msg3',
599: ' l_picked_role --> '|| l_picked_role);
600: /* =============== END DEBUG LOG ================== */
601:
602: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
603: itemkey => itemkey,
604: aname => 'ROLE_NAME',
605: avalue => l_picked_role);
606:

Line 612: Wf_Engine.SetItemAttrText ( itemtype => itemtype,

608: DEBUG_LOG_STRING (l_proc_level, 'setrole.Msg4',
609: ' setting l_picked_role to ROLE_NAME ');
610: /* =============== END DEBUG LOG ================== */
611:
612: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
613: itemkey => itemkey,
614: aname => 'SELECTED_USER_NAME',
615: avalue => l_picked_role);
616:

Line 652: := Wf_Engine.GetItemAttrText (itemtype => itemtype,

648: result OUT NOCOPY VARCHAR2)
649: IS
650:
651: l_creator_name wf_notifications.responder%TYPE
652: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'CREATOR_NAME');
655:
656: l_initial_entry VARCHAR2(5)

Line 657: := Wf_Engine.GetItemAttrText (itemtype => itemtype,

653: itemkey => itemkey,
654: aname => 'CREATOR_NAME');
655:
656: l_initial_entry VARCHAR2(5)
657: := Wf_Engine.GetItemAttrText (itemtype => itemtype,
658: itemkey => itemkey,
659: aname => 'INITIAL_ENTRY_FLAG');
660:
661: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE

Line 662: := Wf_Engine.GetItemAttrNumber (itemtype => itemtype,

658: itemkey => itemkey,
659: aname => 'INITIAL_ENTRY_FLAG');
660:
661: l_pos_struct_element_id per_pos_structure_elements.pos_structure_element_id%TYPE
662: := Wf_Engine.GetItemAttrNumber (itemtype => itemtype,
663: itemkey => itemkey,
664: aname => 'POS_STRUCTURE_ELEMENT_ID');
665:
666: l_dossier_id igi_dos_doc_types.dossier_id%TYPE

Line 667: :=Wf_Engine.GetItemAttrNumber (itemtype => ItemType,

663: itemkey => itemkey,
664: aname => 'POS_STRUCTURE_ELEMENT_ID');
665:
666: l_dossier_id igi_dos_doc_types.dossier_id%TYPE
667: :=Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
668: itemkey => ItemKey,
669: aname => 'DOSSIER_ID');
670:
671: l_picked_role wf_notifications.responder%TYPE;

Line 856: Wf_Engine.SetItemAttrText (itemtype => ItemType,

852: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg6',
853: ' Setting attribute text ');
854: /* =============== END DEBUG LOG ================== */
855:
856: Wf_Engine.SetItemAttrText (itemtype => ItemType,
857: itemkey => ItemKey,
858: aname => 'CURRENT_POSITION_ID',
859: avalue => l_position_id);
860:

Line 867: Wf_Engine.SetItemAttrText (itemtype => ItemType,

863: ' l_position_id - CURRENT_POSITION_ID --> ' || l_position_id );
864: /* =============== END DEBUG LOG ================== */
865:
866:
867: Wf_Engine.SetItemAttrText (itemtype => ItemType,
868: itemkey => ItemKey,
869: aname => 'BUSINESS_GROUP_ID',
870: avalue => l_business_group_id);
871:

Line 877: Wf_Engine.SetItemAttrText (itemtype => ItemType,

873: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg8',
874: ' l_business_group_id - BUSINESS_GROUP_ID --> ' || l_business_group_id );
875: /* =============== END DEBUG LOG ================== */
876:
877: Wf_Engine.SetItemAttrText (itemtype => ItemType,
878: itemkey => ItemKey,
879: aname => 'ORGANIZATION_ID',
880: avalue => l_organization_id);
881:

Line 887: Wf_Engine.SetItemAttrText (itemtype => ItemType,

883: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg9',
884: ' l_organization_id - ORGANIZATION_ID --> ' || l_organization_id );
885: /* =============== END DEBUG LOG ================== */
886:
887: Wf_Engine.SetItemAttrText (itemtype => ItemType,
888: itemkey => ItemKey,
889: aname => 'CURRENT_USER_NAME',
890: avalue => l_current_user_name);
891:

Line 920: Wf_Engine.SetItemAttrText (itemtype => ItemType,

916: /* =============== END DEBUG LOG ================== */
917: RAISE pos_hier_not_found;
918: END;
919:
920: Wf_Engine.SetItemAttrText (itemtype => ItemType,
921: itemkey => ItemKey,
922: aname => 'POS_STRUCTURE_ID',
923: avalue => l_hierarchy_id);
924:

Line 954: Wf_Engine.SetItemAttrText (itemtype => ItemType,

950: /* =============== END DEBUG LOG ================== */
951: RAISE pos_hier_ver_not_found;
952: END;
953:
954: Wf_Engine.SetItemAttrText (itemtype => ItemType,
955: itemkey => ItemKey,
956: aname => 'POS_STRUCTURE_VERSION_ID',
957: avalue => l_hierarchy_version_id);
958:

Line 990: Wf_Engine.SetItemAttrText (itemtype => ItemType,

986: /* =============== END DEBUG LOG ================== */
987: RAISE top_pos_not_found;
988: END;
989:
990: Wf_Engine.SetItemAttrText (itemtype => ItemType,
991: itemkey => ItemKey,
992: aname => 'TOP_POSITION_ID',
993: avalue => l_top_position_id);
994:

Line 1011: Wf_Engine.SetItemAttrText (itemtype => ItemType,

1007: ' l_position_id --> ' || l_position_id || ' = ' ||
1008: ' l_top_position_id --> ' || l_top_position_id );
1009: /* =============== END DEBUG LOG ================== */
1010:
1011: Wf_Engine.SetItemAttrText (itemtype => ItemType,
1012: itemkey => ItemKey,
1013: aname => 'PARENT_POSITION_ID',
1014: avalue => l_position_id);
1015:

Line 1054: Wf_Engine.SetItemAttrText (itemtype => ItemType,

1050: /* =============== END DEBUG LOG ================== */
1051: RAISE par_pos_not_found;
1052: END;
1053:
1054: Wf_Engine.SetItemAttrText (itemtype => ItemType,
1055: itemkey => ItemKey,
1056: aname => 'PARENT_POSITION_ID',
1057: avalue => l_parent_position_id);
1058:

Line 1076: Wf_Engine.SetItemAttrText (itemtype => itemtype,

1072: /* =============== END DEBUG LOG ================== */
1073:
1074: -- Flip the initial entry flag as subsequent entries will not be initial
1075: l_initial_entry := 'FALSE';
1076: Wf_Engine.SetItemAttrText (itemtype => itemtype,
1077: itemkey => itemkey,
1078: aname => 'INITIAL_ENTRY_FLAG',
1079: avalue => l_initial_entry);
1080:

Line 1094: l_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,

1090: ' Not initial entry INTO GetParentPosition ');
1091: /* =============== END DEBUG LOG ================== */
1092:
1093: -- FETCH the parent position id as the current position id
1094: l_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1095: itemkey => ItemKey,
1096: aname => 'PARENT_POSITION_ID');
1097:
1098: /* =============== START DEBUG LOG ================ */

Line 1104: l_top_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,

1100: ' GetItemAttrText PARENT_POSITION_ID --> ' || l_position_id);
1101: /* =============== END DEBUG LOG ================== */
1102:
1103:
1104: l_top_position_id := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1105: itemkey => ItemKey,
1106: aname => 'TOP_POSITION_ID');
1107:
1108: /* =============== START DEBUG LOG ================ */

Line 1133: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,

1129: ' l_position_id --> ' || l_position_id);
1130: /* =============== END DEBUG LOG ================== */
1131:
1132: l_hierarchy_version_id :=
1133: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,
1134: itemkey => ItemKey,
1135: aname => 'POS_STRUCTURE_VERSION_ID');
1136:
1137: /* =============== START DEBUG LOG ================ */

Line 1143: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,

1139: ' GetItemAttrNumber - POS_STRUCTURE_VERSION_ID --> ' || TO_CHAR(l_hierarchy_version_id));
1140: /* =============== END DEBUG LOG ================== */
1141:
1142: l_business_group_id :=
1143: Wf_Engine.GetItemAttrNumber ( itemtype => ItemType,
1144: itemkey => ItemKey,
1145: aname => 'BUSINESS_GROUP_ID');
1146:
1147: /* =============== START DEBUG LOG ================ */

Line 1174: Wf_Engine.SetItemAttrText (itemtype => ItemType,

1170: /* =============== END DEBUG LOG ================== */
1171: RAISE par_pos_not_found;
1172: END;
1173:
1174: Wf_Engine.SetItemAttrText (itemtype => ItemType,
1175: itemkey => ItemKey,
1176: aname => 'PARENT_POSITION_ID',
1177: avalue => l_parent_position_id);
1178:

Line 1185: Wf_Engine.GetItemAttrText (itemtype => ItemType,

1181: ' l_parent_position_id - PARENT_POSITION_ID --> ' || TO_CHAR(l_parent_position_id));
1182: /* =============== END DEBUG LOG ================== */
1183:
1184: l_current_user_name :=
1185: Wf_Engine.GetItemAttrText (itemtype => ItemType,
1186: itemkey => ItemKey,
1187: aname => 'SELECTED_USER_NAME');
1188:
1189: /* =============== START DEBUG LOG ================ */

Line 1194: Wf_Engine.SetItemAttrText (itemtype => ItemType,

1190: DEBUG_LOG_STRING (l_proc_level, 'getparentposition.Msg32',
1191: ' GetItemAttrText SELECTED_USER_NAME --> ' || l_current_user_name);
1192: /* =============== END DEBUG LOG ================== */
1193:
1194: Wf_Engine.SetItemAttrText (itemtype => ItemType,
1195: itemkey => ItemKey,
1196: aname => 'CURRENT_USER_NAME',
1197: avalue => l_current_user_name);
1198:

Line 1300: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1296: --bug 9128478
1297: l_fatal_error VARCHAR2(100);
1298:
1299: l_trx_number VARCHAR2(30)
1300: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1301: itemkey => itemkey,
1302: aname => 'DOSSIER_NUM');
1303:
1304: l_dossier_num VARCHAR2(255)

Line 1305: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1301: itemkey => itemkey,
1302: aname => 'DOSSIER_NUM');
1303:
1304: l_dossier_num VARCHAR2(255)
1305: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1306: itemkey => itemkey,
1307: aname => 'DOSSIER_NUM');
1308:
1309: l_user_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667

Line 1310: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1306: itemkey => itemkey,
1307: aname => 'DOSSIER_NUM');
1308:
1309: l_user_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667
1310: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1311: itemkey => itemkey,
1312: aname => 'USER_ID');
1313:
1314: l_responsibility_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667

Line 1315: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1311: itemkey => itemkey,
1312: aname => 'USER_ID');
1313:
1314: l_responsibility_id VARCHAR2(30) -- Changed FROM NUM to TEXT by bug 1635667
1315: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1316: itemkey => itemkey,
1317: aname => 'RESPONSIBILITY_ID');
1318: encumbrance_error EXCEPTION;
1319:

Line 1403: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

1399: SET trx.trx_status = l_trx_status,
1400: trx.last_update_date= sysdate
1401: WHERE trx.trx_number = l_dossier_num;
1402: result := 'COMPLETE:T';
1403: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
1404: itemkey => Itemkey,
1405: aname => 'FATAL_ERROR',
1406: avalue => l_fatal_error);
1407: /* =============== START DEBUG LOG ================ */

Line 1427: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

1423: EXCEPTION
1424: WHEN OTHERS THEN
1425: l_fatal_error := '.This Dossier could not be approved earlier due to encumbrance error.';
1426: END;
1427: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
1428: itemkey => Itemkey,
1429: aname => 'FATAL_ERROR',
1430: avalue => l_fatal_error);
1431: /* =============== START DEBUG LOG ================ */

Line 1488: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1484: IS
1485: l_trx_status VARCHAR2(80);
1486:
1487: l_dossier_id VARCHAR2(255)
1488: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1489: itemkey => itemkey,
1490: aname => 'DOSSIER_NUM');
1491:
1492: l_creator_name wf_notifications.responder%TYPE

Line 1493: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1489: itemkey => itemkey,
1490: aname => 'DOSSIER_NUM');
1491:
1492: l_creator_name wf_notifications.responder%TYPE
1493: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1494: itemkey => itemkey,
1495: aname => 'CREATOR_NAME');
1496: BEGIN
1497:

Line 1565: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1561: result OUT NOCOPY VARCHAR2)
1562: IS
1563:
1564: l_creator_name wf_notifications.responder%TYPE
1565: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1566: itemkey => itemkey,
1567: aname => 'CREATOR_NAME');
1568:
1569: l_nid NUMBER ;

Line 1600: , 'WF_ENGINE.CB'

1596: l_creator_name
1597: , itemtype
1598: ,'ALL_APPROVED'
1599: , null
1600: , 'WF_ENGINE.CB'
1601: , itemtype||':'||itemkey||':'||to_char(actid)
1602: ,'Send The Dossier Approved Message To The Creator.'
1603: , null
1604: ) ;

Line 1663: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1659: result OUT NOCOPY VARCHAR2)
1660: IS
1661:
1662: l_creator_name wf_notifications.responder%TYPE
1663: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1664: itemkey => itemkey,
1665: aname => 'CREATOR_NAME');
1666:
1667: l_nid NUMBER ;

Line 1700: , 'WF_ENGINE.CB'

1696: l_creator_name
1697: , itemtype
1698: ,'AUTHORISER_REJECTION'
1699: , null
1700: , 'WF_ENGINE.CB'
1701: , itemtype||':'||itemkey||':'||to_char(actid)
1702: ,'Send The Dossier Rejection Message To The Creator.'
1703: , null
1704: ) ;

Line 1771: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1767:
1768: l_user_name fnd_user.user_name%TYPE;
1769:
1770: l_next_position per_positions.name%TYPE
1771: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1772: itemkey => itemkey,
1773: aname => 'NEXT_POSITION');
1774:
1775: l_parent_position_id per_positions.position_id%TYPE

Line 1776: := Wf_Engine.GetItemAttrText (itemtype => ItemType,

1772: itemkey => itemkey,
1773: aname => 'NEXT_POSITION');
1774:
1775: l_parent_position_id per_positions.position_id%TYPE
1776: := Wf_Engine.GetItemAttrText (itemtype => ItemType,
1777: itemkey => ItemKey,
1778: aname => 'PARENT_POSITION_ID');
1779:
1780: l_business_group_id hr_all_positions_f.business_group_id%TYPE

Line 1781: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1777: itemkey => ItemKey,
1778: aname => 'PARENT_POSITION_ID');
1779:
1780: l_business_group_id hr_all_positions_f.business_group_id%TYPE
1781: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1782: itemkey => itemkey,
1783: aname => 'BUSINESS_GROUP_ID');
1784:
1785: l_organization_id hr_all_positions_f.organization_id%TYPE

Line 1786: := Wf_Engine.GetItemAttrText( itemtype => itemtype,

1782: itemkey => itemkey,
1783: aname => 'BUSINESS_GROUP_ID');
1784:
1785: l_organization_id hr_all_positions_f.organization_id%TYPE
1786: := Wf_Engine.GetItemAttrText( itemtype => itemtype,
1787: itemkey => itemkey,
1788: aname => 'ORGANIZATION_ID');
1789:
1790: CURSOR c_user_list

Line 1885: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

1881: /* =============== END DEBUG LOG ================== */
1882: RAISE e_user_list_not_found;
1883: END;
1884:
1885: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
1886: itemkey => Itemkey,
1887: aname => 'USER_LIST',
1888: avalue => l_list);
1889:

Line 1906: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,

1902: DEBUG_LOG_STRING (l_proc_level, 'CreateList.Msg7',
1903: ' result --> ' || result);
1904: /* =============== END DEBUG LOG ================== */
1905:
1906: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,
1907: itemkey => Itemkey,
1908: aname => 'PICKED_ROLE',
1909: avalue => l_list) ;
1910:

Line 1949: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1945: IS
1946:
1947:
1948: l_user_list VARCHAR2(250)
1949: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1950: itemkey => itemkey,
1951: aname => 'USER_LIST');
1952:
1953: l_next_position per_positions.name%TYPE;

Line 1956: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1952:
1953: l_next_position per_positions.name%TYPE;
1954:
1955: l_parent_position_id hr_all_positions_f.position_id%TYPE
1956: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1957: itemkey => itemkey,
1958: aname => 'PARENT_POSITION_ID');
1959:
1960: l_next_authoriser wf_notifications.responder%TYPE ;

Line 1984: l_next_authoriser := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

1980:
1981: -- The returned value is held in item attribute which is the same name as
1982: -- the workflow message attribute with source 'Respond'.
1983:
1984: l_next_authoriser := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
1985: itemkey => itemkey,
1986: aname => 'NEXT_AUTHORISER');
1987:
1988: l_next_authoriser := UPPER(l_next_authoriser) ;

Line 2022: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,

2018: /* =============== END DEBUG LOG ================== */
2019:
2020: END IF ;
2021:
2022: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,
2023: itemkey => Itemkey,
2024: aname => 'PICKED_ROLE',
2025: avalue => l_next_authoriser) ;
2026:

Line 2032: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,

2028: DEBUG_LOG_STRING (l_proc_level, 'CheckList.Msg7',
2029: ' l_next_authoriser - PICKED_ROLE --> ' || l_next_authoriser);
2030: /* =============== END DEBUG LOG ================== */
2031:
2032: Wf_Engine.SetItemAttrText ( itemtype => Itemtype,
2033: itemkey => Itemkey,
2034: aname => 'SELECTED_USER_NAME',
2035: avalue => l_next_authoriser) ;
2036:

Line 2090: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2086: IS
2087: l_trx_status VARCHAR2(30);
2088: l_fatal_error VARCHAR2(100);
2089: l_trx_number VARCHAR2(30)
2090: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2091: itemkey => itemkey,
2092: aname => 'DOSSIER_NUM');
2093: l_user_id VARCHAR2(30)
2094: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

Line 2094: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2090: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2091: itemkey => itemkey,
2092: aname => 'DOSSIER_NUM');
2093: l_user_id VARCHAR2(30)
2094: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2095: itemkey => itemkey,
2096: aname => 'USER_ID');
2097:
2098: l_responsibility_id VARCHAR2(30)

Line 2099: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2095: itemkey => itemkey,
2096: aname => 'USER_ID');
2097:
2098: l_responsibility_id VARCHAR2(30)
2099: := Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2100: itemkey => itemkey,
2101: aname => 'RESPONSIBILITY_ID');
2102: l_sob_id number;
2103: unreserve_error EXCEPTION ;

Line 2170: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

2166: EXCEPTION
2167: WHEN OTHERS THEN
2168: l_fatal_error := '.This Dossier could not be rejected earlier due to encumbrance error.';
2169: END;
2170: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
2171: itemkey => Itemkey,
2172: aname => 'FATAL_ERROR',
2173: avalue => l_fatal_error);
2174: /* =============== START DEBUG LOG ================ */

Line 2208: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

2204: DEBUG_LOG_STRING (l_proc_level, 'UnreserveFunds.Msg6',
2205: ' updated igi_dos_trx_headers ');
2206: /* =============== END DEBUG LOG ================== */
2207: --bug 9128478
2208: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
2209: itemkey => Itemkey,
2210: aname => 'FATAL_ERROR',
2211: avalue => '');
2212: /* =============== START DEBUG LOG ================ */

Line 2515: := Wf_Engine.GetItemAttrText ( itemtype => l_itemtype,

2511: /* =============== END DEBUG LOG ================== */
2512:
2513:
2514: l_dossier_num
2515: := Wf_Engine.GetItemAttrText ( itemtype => l_itemtype,
2516: itemkey => l_itemkey,
2517: aname => 'DOSSIER_NUM');
2518:
2519: /* =============== START DEBUG LOG ================ */

Line 2525: := Wf_Engine.GetItemAttrNumber ( itemtype => l_itemtype,

2521: ' l_dossier_num --> ' || l_dossier_num);
2522: /* =============== END DEBUG LOG ================== */
2523:
2524: l_dossier_id
2525: := Wf_Engine.GetItemAttrNumber ( itemtype => l_itemtype,
2526: itemkey => l_itemkey,
2527: aname => 'DOSSIER_ID');
2528:
2529: /* =============== START DEBUG LOG ================ */

Line 2744: Wf_Engine.GetItemAttrText ( itemtype => itemtype,

2740: result OUT NOCOPY VARCHAR2 ) IS
2741:
2742: l_trx_status igi_lookups.meaning%TYPE;
2743: l_dossier_num igi_dos_trx_headers.trx_number%TYPE :=
2744: Wf_Engine.GetItemAttrText ( itemtype => itemtype,
2745: itemkey => itemkey,
2746: aname => 'DOSSIER_NUM');
2747:
2748: CURSOR c_meaning IS

Line 2819: l_user_id NUMBER(15) := Wf_Engine.GetItemAttrText

2815: result OUT NOCOPY VARCHAR2 ) IS
2816:
2817: l_emp_id NUMBER(15);
2818:
2819: l_user_id NUMBER(15) := Wf_Engine.GetItemAttrText
2820: ( itemtype => itemtype,
2821: itemkey => itemkey,
2822: aname => 'USER_ID');
2823:

Line 2862: Wf_Engine.SetItemAttrText ( itemtype => itemtype,

2858: result := 'COMPLETE:N';
2859:
2860: ELSE
2861: -- Save the employee id for subsequent validations
2862: Wf_Engine.SetItemAttrText ( itemtype => itemtype,
2863: itemkey => itemkey,
2864: aname => 'EMPLOYEE_ID',
2865: avalue => l_emp_id);
2866:

Line 2942: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText

2938: l_position_name hr_all_positions_f.name%TYPE;
2939: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
2940: l_organization_id hr_all_positions_f.organization_id%TYPE;
2941:
2942: l_emp_id NUMBER(15) := Wf_Engine.GetItemAttrText
2943: ( itemtype => itemtype,
2944: itemkey => itemkey,
2945: aname => 'EMPLOYEE_ID');
2946:

Line 2981: Wf_Engine.SetItemAttrText (itemtype => ItemType,

2977:
2978: result := 'COMPLETE:N';
2979: ELSE
2980:
2981: Wf_Engine.SetItemAttrText (itemtype => ItemType,
2982: itemkey => ItemKey,
2983: aname => 'CURRENT_POSITION_ID',
2984: avalue => l_position_id);
2985:

Line 2991: Wf_Engine.SetItemAttrText (itemtype => ItemType,

2987: DEBUG_LOG_STRING (l_proc_level, 'HasPosition.Msg4',
2988: ' SetItemAttrText CURRENT_POSITION_ID -> ' || l_position_id );
2989: /* =============== END DEBUG LOG ================== */
2990:
2991: Wf_Engine.SetItemAttrText (itemtype => ItemType,
2992: itemkey => ItemKey,
2993: aname => 'BUSINESS_GROUP_ID',
2994: avalue => l_business_group_id);
2995:

Line 3001: Wf_Engine.SetItemAttrText (itemtype => ItemType,

2997: DEBUG_LOG_STRING (l_proc_level, 'HasPosition.Msg5',
2998: ' SetItemAttrText BUSINESS_GROUP_ID -> ' || l_business_group_id);
2999: /* =============== END DEBUG LOG ================== */
3000:
3001: Wf_Engine.SetItemAttrText (itemtype => ItemType,
3002: itemkey => ItemKey,
3003: aname => 'ORGANIZATION_ID',
3004: avalue => l_organization_id);
3005:

Line 3051: Wf_Engine.GetItemAttrText (itemtype => ItemType,

3047: funcmode IN VARCHAR2,
3048: result OUT NOCOPY VARCHAR2 ) IS
3049:
3050: l_position_id hr_all_positions_f.position_id%TYPE :=
3051: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3052: itemkey => ItemKey,
3053: aname => 'CURRENT_POSITION_ID');
3054:
3055: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=

Line 3056: Wf_Engine.GetItemAttrText (itemtype => ItemType,

3052: itemkey => ItemKey,
3053: aname => 'CURRENT_POSITION_ID');
3054:
3055: l_business_group_id hr_all_positions_f.business_group_id%TYPE :=
3056: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3057: itemkey => ItemKey,
3058: aname => 'BUSINESS_GROUP_ID');
3059:
3060: l_organization_id hr_all_positions_f.organization_id%TYPE :=

Line 3061: Wf_Engine.GetItemAttrText (itemtype => ItemType,

3057: itemkey => ItemKey,
3058: aname => 'BUSINESS_GROUP_ID');
3059:
3060: l_organization_id hr_all_positions_f.organization_id%TYPE :=
3061: Wf_Engine.GetItemAttrText (itemtype => ItemType,
3062: itemkey => ItemKey,
3063: aname => 'ORGANIZATION_ID');
3064:
3065: l_dossier_id igi_dos_doc_types.dossier_id%TYPE :=

Line 3066: Wf_Engine.GetItemAttrNumber (itemtype => ItemType,

3062: itemkey => ItemKey,
3063: aname => 'ORGANIZATION_ID');
3064:
3065: l_dossier_id igi_dos_doc_types.dossier_id%TYPE :=
3066: Wf_Engine.GetItemAttrNumber (itemtype => ItemType,
3067: itemkey => ItemKey,
3068: aname => 'DOSSIER_ID');
3069:
3070: l_valid BOOLEAN := TRUE;

Line 3143: Wf_Engine.SetItemAttrText (itemtype => ItemType,

3139:
3140: IF (c_pos_hier%NOTFOUND) THEN
3141: l_valid := FALSE;
3142: ELSE
3143: Wf_Engine.SetItemAttrText (itemtype => ItemType,
3144: itemkey => ItemKey,
3145: aname => 'POS_STRUCTURE_ID',
3146: avalue => l_hierarchy_id);
3147:

Line 3193: Wf_Engine.SetItemAttrText (itemtype => ItemType,

3189: /* =============== END DEBUG LOG ================== */
3190:
3191: ELSE
3192:
3193: Wf_Engine.SetItemAttrText (itemtype => ItemType,
3194: itemkey => ItemKey,
3195: aname => 'POS_STRUCTURE_VERSION_ID',
3196: avalue => l_hierarchy_version_id);
3197:

Line 3309: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

3305: l_fatal_error := 'Select a valid responsibilty before approving or rejecting the dossier.';
3306: END;
3307:
3308: result := 'COMPLETE:N';
3309: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
3310: itemkey => Itemkey,
3311: aname => 'FATAL_ERROR',
3312: avalue => l_fatal_error);
3313: /* =============== START DEBUG LOG ================ */

Line 3320: l_fatal_error := wf_engine.GetItemAttrNumber

3316: /* =============== END DEBUG LOG ================== */
3317: ELSE
3318:
3319:
3320: l_fatal_error := wf_engine.GetItemAttrNumber
3321: (itemtype,
3322: itemkey,
3323: 'FATAL_ERROR');
3324: /* =============== START DEBUG LOG ================ */

Line 3329: l_user_id := wf_engine.GetItemAttrNumber

3325: DEBUG_LOG_STRING (l_proc_level, 'approve.Msg5.1',
3326: 'Setting the Fatal Error Attribute');
3327: /* =============== END DEBUG LOG ================== */
3328: if l_fatal_error is not null then
3329: l_user_id := wf_engine.GetItemAttrNumber
3330: (itemtype,
3331: itemkey,
3332: 'USER_ID');
3333: l_resp_id := wf_engine.GetItemAttrNumber

Line 3333: l_resp_id := wf_engine.GetItemAttrNumber

3329: l_user_id := wf_engine.GetItemAttrNumber
3330: (itemtype,
3331: itemkey,
3332: 'USER_ID');
3333: l_resp_id := wf_engine.GetItemAttrNumber
3334: (itemtype,
3335: itemkey,
3336: 'RESPONSIBILITY_ID');
3337: l_appl_id := wf_engine.GetItemAttrNumber

Line 3337: l_appl_id := wf_engine.GetItemAttrNumber

3333: l_resp_id := wf_engine.GetItemAttrNumber
3334: (itemtype,
3335: itemkey,
3336: 'RESPONSIBILITY_ID');
3337: l_appl_id := wf_engine.GetItemAttrNumber
3338: (itemtype,
3339: itemkey,
3340: 'RESP_APPL_ID');
3341:

Line 3350: Wf_Engine.SetItemAttrText (itemtype => Itemtype,

3346:
3347: FND_GLOBAL.apps_initialize(l_user_id,l_resp_id,l_appl_id);
3348:
3349: end if;
3350: Wf_Engine.SetItemAttrText (itemtype => Itemtype,
3351: itemkey => Itemkey,
3352: aname => 'FATAL_ERROR',
3353: avalue => NULL);
3354: result := 'COMPLETE:Y';