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

Line 216: wf_engine.createprocess ( itemtype => itemtype,

212: itemtype := item_type;
213: print_message(test);
214: SELECT TO_CHAR(AS_SALES_METHODOLOGY_WF_S.NEXTVAL) INTO itemkey FROM dual;
215: IF (itemtype IS NOT NULL) AND (itemkey IS NOT NULL) THEN
216: wf_engine.createprocess ( itemtype => itemtype,
217: itemkey => itemkey,
218: process => workflowprocess);
219: wf_engine.setitemattrnumber( itemtype => itemtype,
220: itemkey => itemkey,

Line 219: wf_engine.setitemattrnumber( itemtype => itemtype,

215: IF (itemtype IS NOT NULL) AND (itemkey IS NOT NULL) THEN
216: wf_engine.createprocess ( itemtype => itemtype,
217: itemkey => itemkey,
218: process => workflowprocess);
219: wf_engine.setitemattrnumber( itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'OWNER_ID',
222: avalue => p_owner_id);
223: wf_engine.setitemattrtext( itemtype => itemtype,

Line 223: wf_engine.setitemattrtext( itemtype => itemtype,

219: wf_engine.setitemattrnumber( itemtype => itemtype,
220: itemkey => itemkey,
221: aname => 'OWNER_ID',
222: avalue => p_owner_id);
223: wf_engine.setitemattrtext( itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'OWNER_TYPE_CODE',
226: avalue => l_category);
227: wf_engine.setitemattrnumber( itemtype => itemtype,

Line 227: wf_engine.setitemattrnumber( itemtype => itemtype,

223: wf_engine.setitemattrtext( itemtype => itemtype,
224: itemkey => itemkey,
225: aname => 'OWNER_TYPE_CODE',
226: avalue => l_category);
227: wf_engine.setitemattrnumber( itemtype => itemtype,
228: itemkey => itemkey,
229: aname => 'SOURCE_OBJECT_ID',
230: avalue => p_source_object_id);
231: wf_engine.setitemattrtext( itemtype => itemtype,

Line 231: wf_engine.setitemattrtext( itemtype => itemtype,

227: wf_engine.setitemattrnumber( itemtype => itemtype,
228: itemkey => itemkey,
229: aname => 'SOURCE_OBJECT_ID',
230: avalue => p_source_object_id);
231: wf_engine.setitemattrtext( itemtype => itemtype,
232: itemkey => itemkey,
233: aname => 'SOURCE_OBJECT_TYPE_CODE',
234: avalue => p_source_object_type_code);
235: wf_engine.setitemattrtext( itemtype => itemtype,

Line 235: wf_engine.setitemattrtext( itemtype => itemtype,

231: wf_engine.setitemattrtext( itemtype => itemtype,
232: itemkey => itemkey,
233: aname => 'SOURCE_OBJECT_TYPE_CODE',
234: avalue => p_source_object_type_code);
235: wf_engine.setitemattrtext( itemtype => itemtype,
236: itemkey => itemkey,
237: aname => 'SOURCE_OBJECT_NAME',
238: avalue => p_source_object_name);
239: wf_engine.setitemattrtext( itemtype => itemtype,

Line 239: wf_engine.setitemattrtext( itemtype => itemtype,

235: wf_engine.setitemattrtext( itemtype => itemtype,
236: itemkey => itemkey,
237: aname => 'SOURCE_OBJECT_NAME',
238: avalue => p_source_object_name);
239: wf_engine.setitemattrtext( itemtype => itemtype,
240: itemkey => itemkey,
241: aname => 'OBJECT_TYPE_CODE',
242: avalue => p_object_type_code);
243: wf_engine.setitemattrnumber( itemtype => itemtype,

Line 243: wf_engine.setitemattrnumber( itemtype => itemtype,

239: wf_engine.setitemattrtext( itemtype => itemtype,
240: itemkey => itemkey,
241: aname => 'OBJECT_TYPE_CODE',
242: avalue => p_object_type_code);
243: wf_engine.setitemattrnumber( itemtype => itemtype,
244: itemkey => itemkey,
245: aname => 'CURRENT_STAGE_ID',
246: avalue => p_current_stage_id);
247: wf_engine.setitemattrnumber( itemtype => itemtype,

Line 247: wf_engine.setitemattrnumber( itemtype => itemtype,

243: wf_engine.setitemattrnumber( itemtype => itemtype,
244: itemkey => itemkey,
245: aname => 'CURRENT_STAGE_ID',
246: avalue => p_current_stage_id);
247: wf_engine.setitemattrnumber( itemtype => itemtype,
248: itemkey => itemkey,
249: aname => 'NEXT_STAGE_ID',
250: avalue => p_next_stage_id);
251: wf_engine.setitemattrtext( itemtype => itemtype,

Line 251: wf_engine.setitemattrtext( itemtype => itemtype,

247: wf_engine.setitemattrnumber( itemtype => itemtype,
248: itemkey => itemkey,
249: aname => 'NEXT_STAGE_ID',
250: avalue => p_next_stage_id);
251: wf_engine.setitemattrtext( itemtype => itemtype,
252: itemkey => itemkey,
253: aname => 'TASK_TEMPLATE_GROUP_ID',
254: avalue => p_template_group_id);
255: --------------------------------------------------------------

Line 279: wf_engine.setitemattrnumber( itemtype => itemtype,

275: x_return_status := 'S' ;
276: ELSE
277: PRINT_MESSAGE('sales stage id in count=='||l_sales_stage_id);
278: PRINT_MESSAGE('Task template group id in count=='||l_template_group_id);
279: wf_engine.setitemattrnumber( itemtype => itemtype,
280: itemkey => itemkey,
281: aname => 'NEXT_STAGE_ID',
282: avalue => l_sales_stage_id);
283: wf_engine.setitemattrtext( itemtype => itemtype,

Line 283: wf_engine.setitemattrtext( itemtype => itemtype,

279: wf_engine.setitemattrnumber( itemtype => itemtype,
280: itemkey => itemkey,
281: aname => 'NEXT_STAGE_ID',
282: avalue => l_sales_stage_id);
283: wf_engine.setitemattrtext( itemtype => itemtype,
284: itemkey => itemkey,
285: aname => 'TASK_TEMPLATE_GROUP_ID',
286: avalue => l_template_group_id);
287: print_message('Inside task count<1');

Line 288: wf_engine.startprocess( itemtype => itemtype,

284: itemkey => itemkey,
285: aname => 'TASK_TEMPLATE_GROUP_ID',
286: avalue => l_template_group_id);
287: print_message('Inside task count<1');
288: wf_engine.startprocess( itemtype => itemtype,
289: itemkey => itemkey);
290: wf_engine.ItemStatus ( itemtype => ItemType,
291: itemkey => ItemKey,
292: status => l_return_status,

Line 290: wf_engine.ItemStatus ( itemtype => ItemType,

286: avalue => l_template_group_id);
287: print_message('Inside task count<1');
288: wf_engine.startprocess( itemtype => itemtype,
289: itemkey => itemkey);
290: wf_engine.ItemStatus ( itemtype => ItemType,
291: itemkey => ItemKey,
292: status => l_return_status,
293: result => l_result);
294: print_message('Result after workflow=in count else='||l_result);

Line 308: wf_engine.startprocess( itemtype => itemtype,

304: CLOSE c_stage;
305: ELSE
306: ----------------------------------------------------------
307: print_message('Meth flag is not equal to yes');
308: wf_engine.startprocess( itemtype => itemtype,
309: itemkey => itemkey);
310: wf_engine.ItemStatus ( itemtype => ItemType,
311: itemkey => ItemKey,
312: status => l_return_status,

Line 310: wf_engine.ItemStatus ( itemtype => ItemType,

306: ----------------------------------------------------------
307: print_message('Meth flag is not equal to yes');
308: wf_engine.startprocess( itemtype => itemtype,
309: itemkey => itemkey);
310: wf_engine.ItemStatus ( itemtype => ItemType,
311: itemkey => ItemKey,
312: status => l_return_status,
313: result => l_result);
314: IF l_result = 'SUCCESS' AND l_return_status ='COMPLETE' THEN

Line 338: x_warning_message := wf_engine.getitemattrtext( itemtype => itemtype,

334: fnd_msg_pub.add;
335: RAISE fnd_api.g_exc_unexpected_error;
336: x_return_status := 'U';
337: END IF;
338: x_warning_message := wf_engine.getitemattrtext( itemtype => itemtype,
339: itemkey => itemkey,
340: aname => 'WARNING_MESSAGE');
341:
342: print_message(' Item Status->'||' '||x_return_status||'item status result->'||' '||l_result);

Line 425: l_source_object_type_code := wf_engine.getitemattrtext(itemtype => itemtype,

421: -- initializing return status
422: l_return_status := 'U';
423: print_message('current func mode'||funcmode);
424: IF funcmode = 'RUN' THEN
425: l_source_object_type_code := wf_engine.getitemattrtext(itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'SOURCE_OBJECT_TYPE_CODE');
428: l_source_object_id := wf_engine.getitemattrnumber(itemtype => itemtype,
429: itemkey => itemkey,

Line 428: l_source_object_id := wf_engine.getitemattrnumber(itemtype => itemtype,

424: IF funcmode = 'RUN' THEN
425: l_source_object_type_code := wf_engine.getitemattrtext(itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'SOURCE_OBJECT_TYPE_CODE');
428: l_source_object_id := wf_engine.getitemattrnumber(itemtype => itemtype,
429: itemkey => itemkey,
430: aname => 'SOURCE_OBJECT_ID');
431: l_source_object_name := wf_engine.getitemattrtext (itemtype => itemtype,
432: itemkey => itemkey,

Line 431: l_source_object_name := wf_engine.getitemattrtext (itemtype => itemtype,

427: aname => 'SOURCE_OBJECT_TYPE_CODE');
428: l_source_object_id := wf_engine.getitemattrnumber(itemtype => itemtype,
429: itemkey => itemkey,
430: aname => 'SOURCE_OBJECT_ID');
431: l_source_object_name := wf_engine.getitemattrtext (itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'SOURCE_OBJECT_NAME');
434: l_object_type_code := wf_engine.getitemattrtext (itemtype => itemtype,
435: itemkey => itemkey,

Line 434: l_object_type_code := wf_engine.getitemattrtext (itemtype => itemtype,

430: aname => 'SOURCE_OBJECT_ID');
431: l_source_object_name := wf_engine.getitemattrtext (itemtype => itemtype,
432: itemkey => itemkey,
433: aname => 'SOURCE_OBJECT_NAME');
434: l_object_type_code := wf_engine.getitemattrtext (itemtype => itemtype,
435: itemkey => itemkey,
436: aname => 'OBJECT_TYPE_CODE');
437: l_object_id := wf_engine.getitemattrnumber(itemtype => itemtype,
438: itemkey => itemkey,

Line 437: l_object_id := wf_engine.getitemattrnumber(itemtype => itemtype,

433: aname => 'SOURCE_OBJECT_NAME');
434: l_object_type_code := wf_engine.getitemattrtext (itemtype => itemtype,
435: itemkey => itemkey,
436: aname => 'OBJECT_TYPE_CODE');
437: l_object_id := wf_engine.getitemattrnumber(itemtype => itemtype,
438: itemkey => itemkey,
439: aname => 'CURRENT_STAGE_ID');
440: print_message('--------------------------------------------------');
441: print_message('SOURCE_OBJECT_CODE ='||l_source_object_type_code);

Line 454: wf_engine.setitemattrtext ( itemtype => itemtype,

450: l_return_status:='Y';
451: -- create note comes here
452: END LOOP;
453: l_meth_note_type := 'CURRENT_STAGE';
454: wf_engine.setitemattrtext ( itemtype => itemtype,
455: itemkey => itemkey,
456: aname => 'METH_NOTE_TYPE',
457: avalue => l_meth_note_type);
458: IF l_return_status ='Y' THEN

Line 504: l_source_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,

500: c_next_stage_rec c_next_stage%ROWTYPE;
501: BEGIN
502: l_return_status:='U';
503: IF funcmode = 'RUN' THEN
504: l_source_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
505: itemkey => itemkey,
506: aname => 'SOURCE_OBJECT_TYPE_CODE');
507: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
508: itemkey => itemkey,

Line 507: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,

503: IF funcmode = 'RUN' THEN
504: l_source_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
505: itemkey => itemkey,
506: aname => 'SOURCE_OBJECT_TYPE_CODE');
507: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
508: itemkey => itemkey,
509: aname => 'SOURCE_OBJECT_ID');
510: l_source_object_name:= wf_engine.getitemattrtext( itemtype => itemtype,
511: itemkey => itemkey,

Line 510: l_source_object_name:= wf_engine.getitemattrtext( itemtype => itemtype,

506: aname => 'SOURCE_OBJECT_TYPE_CODE');
507: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
508: itemkey => itemkey,
509: aname => 'SOURCE_OBJECT_ID');
510: l_source_object_name:= wf_engine.getitemattrtext( itemtype => itemtype,
511: itemkey => itemkey,
512: aname => 'SOURCE_OBJECT_NAME');
513: l_object_type_code:= wf_engine.getitemattrtext( itemtype => itemtype,
514: itemkey => itemkey,

Line 513: l_object_type_code:= wf_engine.getitemattrtext( itemtype => itemtype,

509: aname => 'SOURCE_OBJECT_ID');
510: l_source_object_name:= wf_engine.getitemattrtext( itemtype => itemtype,
511: itemkey => itemkey,
512: aname => 'SOURCE_OBJECT_NAME');
513: l_object_type_code:= wf_engine.getitemattrtext( itemtype => itemtype,
514: itemkey => itemkey,
515: aname => 'OBJECT_TYPE_CODE');
516: l_object_id:=wf_engine.getitemattrnumber( itemtype => itemtype,
517: itemkey => itemkey,

Line 516: l_object_id:=wf_engine.getitemattrnumber( itemtype => itemtype,

512: aname => 'SOURCE_OBJECT_NAME');
513: l_object_type_code:= wf_engine.getitemattrtext( itemtype => itemtype,
514: itemkey => itemkey,
515: aname => 'OBJECT_TYPE_CODE');
516: l_object_id:=wf_engine.getitemattrnumber( itemtype => itemtype,
517: itemkey => itemkey,
518: aname => 'NEXT_STAGE_ID');
519: print_message('NEXT_STAGE_ID= '||l_object_id);
520: FOR c_next_stage_rec IN c_next_stage

Line 528: wf_engine.setitemattrtext( itemtype => itemtype,

524: g_task_tab(n) := c_next_stage_rec.task_id;
525: l_return_status:='Y';
526: END LOOP;
527: l_meth_note_type := 'NEXT_STAGE';
528: wf_engine.setitemattrtext( itemtype => itemtype,
529: itemkey => itemkey,
530: aname => 'METH_NOTE_TYPE',
531: avalue => l_meth_note_type);
532: IF l_return_status = 'Y' AND nvl(fnd_profile.value('AS_SM_RECREATE_TASKS'), 'N') <> 'Y' THEN

Line 633: l_source_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,

629:
630: BEGIN
631: l_return_status := 'U';
632: IF funcmode = 'RUN' THEN
633: l_source_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'SOURCE_OBJECT_TYPE_CODE');
636: print_message('current source type code = '||l_source_object_type_code);
637: l_source_object_id := wf_engine.getitemattrnumber( itemtype => itemtype,

Line 637: l_source_object_id := wf_engine.getitemattrnumber( itemtype => itemtype,

633: l_source_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
634: itemkey => itemkey,
635: aname => 'SOURCE_OBJECT_TYPE_CODE');
636: print_message('current source type code = '||l_source_object_type_code);
637: l_source_object_id := wf_engine.getitemattrnumber( itemtype => itemtype,
638: itemkey => itemkey,
639: aname => 'SOURCE_OBJECT_ID');
640: l_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
641: itemkey => itemkey,

Line 640: l_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,

636: print_message('current source type code = '||l_source_object_type_code);
637: l_source_object_id := wf_engine.getitemattrnumber( itemtype => itemtype,
638: itemkey => itemkey,
639: aname => 'SOURCE_OBJECT_ID');
640: l_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
641: itemkey => itemkey,
642: aname => 'OBJECT_TYPE_CODE');
643: l_object_id :=wf_engine.getitemattrnumber ( itemtype => itemtype,
644: itemkey => itemkey,

Line 643: l_object_id :=wf_engine.getitemattrnumber ( itemtype => itemtype,

639: aname => 'SOURCE_OBJECT_ID');
640: l_object_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
641: itemkey => itemkey,
642: aname => 'OBJECT_TYPE_CODE');
643: l_object_id :=wf_engine.getitemattrnumber ( itemtype => itemtype,
644: itemkey => itemkey,
645: aname => 'NEXT_STAGE_ID');
646: l_source_object_name := wf_engine.getitemattrtext ( itemtype => itemtype,
647: itemkey => itemkey,

Line 646: l_source_object_name := wf_engine.getitemattrtext ( itemtype => itemtype,

642: aname => 'OBJECT_TYPE_CODE');
643: l_object_id :=wf_engine.getitemattrnumber ( itemtype => itemtype,
644: itemkey => itemkey,
645: aname => 'NEXT_STAGE_ID');
646: l_source_object_name := wf_engine.getitemattrtext ( itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'SOURCE_OBJECT_NAME');
649: l_task_template_group_id:=wf_engine.getitemattrtext ( itemtype => itemtype,
650: itemkey => itemkey,

Line 649: l_task_template_group_id:=wf_engine.getitemattrtext ( itemtype => itemtype,

645: aname => 'NEXT_STAGE_ID');
646: l_source_object_name := wf_engine.getitemattrtext ( itemtype => itemtype,
647: itemkey => itemkey,
648: aname => 'SOURCE_OBJECT_NAME');
649: l_task_template_group_id:=wf_engine.getitemattrtext ( itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'TASK_TEMPLATE_GROUP_ID');
652: l_owner_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
653: itemkey => itemkey,

Line 652: l_owner_type_code := wf_engine.getitemattrtext( itemtype => itemtype,

648: aname => 'SOURCE_OBJECT_NAME');
649: l_task_template_group_id:=wf_engine.getitemattrtext ( itemtype => itemtype,
650: itemkey => itemkey,
651: aname => 'TASK_TEMPLATE_GROUP_ID');
652: l_owner_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'OWNER_TYPE_CODE');
655: l_owner_id := wf_engine.getitemattrnumber( itemtype => itemtype,
656: itemkey => itemkey,

Line 655: l_owner_id := wf_engine.getitemattrnumber( itemtype => itemtype,

651: aname => 'TASK_TEMPLATE_GROUP_ID');
652: l_owner_type_code := wf_engine.getitemattrtext( itemtype => itemtype,
653: itemkey => itemkey,
654: aname => 'OWNER_TYPE_CODE');
655: l_owner_id := wf_engine.getitemattrnumber( itemtype => itemtype,
656: itemkey => itemkey,
657: aname => 'OWNER_ID');
658: print_message('OWNER_ID = '||l_owner_id);
659: print_message('OWNER_TYPE_CODE = '||l_owner_type_code);

Line 752: wf_engine.setitemattrtext( itemtype => itemtype,

748: FETCH c_methodology INTO l_sales_methodology_id;
749: --dbms_output.put_line('Methodology_id = '||l_sales_methodology_id);
750: IF (c_methodology %NOTFOUND) THEN
751: g_notes:= fnd_message.get_string('AS','AS_INVALID_METH');
752: wf_engine.setitemattrtext( itemtype => itemtype,
753: itemkey => itemkey,
754: aname => 'WARNING_MESSAGE',
755: avalue => g_notes);
756: l_error_msg:='Methodology not found for lead_id';

Line 771: wf_engine.setitemattrtext( itemtype => itemtype,

767: IF (c_task %NOTFOUND) THEN
768: CLOSE c_task;
769: --------------
770: g_notes:=fnd_message.get_string('AS','AS_INVALID_TEMPLATE_DTL');
771: wf_engine.setitemattrtext( itemtype => itemtype,
772: itemkey => itemkey,
773: aname => 'WARNING_MESSAGE',
774: avalue => g_notes);
775: l_error_msg:='Template and Template group are not found for Task_id';

Line 814: wf_engine.setitemattrtext( itemtype => itemtype,

810: NULL;
811: ELSE
812: g_notes:=fnd_message.get_string('AS','AS_CREATE_TASK_MAP_FAIL');
813: g_notes:=g_notes||l_msg_data;
814: wf_engine.setitemattrtext( itemtype => itemtype,
815: itemkey => itemkey,
816: aname => 'WARNING_MESSAGE',
817: avalue => g_notes);
818: --g_notes:='Create map api in AS_SALES_METH_WF.CREATE_TASK failed with the following error **** '||l_msg_data;

Line 839: wf_engine.setitemattrtext( itemtype => itemtype,

835: END LOOP;
836: END IF;
837: g_notes:=fnd_message.get_string('AS','AS_CREATE_TASK_FAIL');
838: g_notes:=g_notes||l_msg_data;
839: wf_engine.setitemattrtext( itemtype => itemtype,
840: itemkey => itemkey,
841: aname => 'WARNING_MESSAGE',
842: avalue => g_notes);
843: END IF ;

Line 845: wf_engine.setitemattrtext( itemtype => itemtype,

841: aname => 'WARNING_MESSAGE',
842: avalue => g_notes);
843: END IF ;
844: l_meth_note_type := 'CREATE_TASKS';
845: wf_engine.setitemattrtext( itemtype => itemtype,
846: itemkey => itemkey,
847: aname => 'METH_NOTE_TYPE',
848: avalue => l_meth_note_type);
849: IF l_return_status = 'S' THEN

Line 985: wf_engine.setitemattrtext( itemtype => itemtype,

981: l_return_status:='S';
982: ELSIF l_update_status = 'S' AND l_notes_flag ='YES' THEN
983: l_return_status := 'U';
984: l_meth_note_type := 'CHECK_DURATION';
985: wf_engine.setitemattrtext( itemtype => itemtype,
986: itemkey => itemkey,
987: aname => 'METH_NOTE_TYPE',
988: avalue => l_meth_note_type);
989: g_notes:= fnd_message.get_string('AS','AS_INVALID_DURATION');

Line 990: wf_engine.setitemattrtext( itemtype => itemtype,

986: itemkey => itemkey,
987: aname => 'METH_NOTE_TYPE',
988: avalue => l_meth_note_type);
989: g_notes:= fnd_message.get_string('AS','AS_INVALID_DURATION');
990: wf_engine.setitemattrtext( itemtype => itemtype,
991: itemkey => itemkey,
992: aname => 'WARNING_MESSAGE',
993: avalue => g_notes);
994: ELSE

Line 996: wf_engine.setitemattrtext( itemtype => itemtype,

992: aname => 'WARNING_MESSAGE',
993: avalue => g_notes);
994: ELSE
995: g_notes:=fnd_message.get_string('AS','AS_DURATION_UPDATE_FAIL');
996: wf_engine.setitemattrtext( itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'WARNING_MESSAGE',
999: avalue => g_notes);
1000: l_return_status :='U';

Line 1002: wf_engine.setitemattrtext( itemtype => itemtype,

998: aname => 'WARNING_MESSAGE',
999: avalue => g_notes);
1000: l_return_status :='U';
1001: l_meth_note_type := 'CHECK_DURATION';
1002: wf_engine.setitemattrtext( itemtype => itemtype,
1003: itemkey => itemkey,
1004: aname => 'METH_NOTE_TYPE',
1005: avalue => l_meth_note_type);
1006: END IF;

Line 1051: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,

1047: BEGIN
1048: --l_return_status := 'U';
1049: l_org_id :=fnd_profile.value('ORG_ID');
1050: IF funcmode = 'RUN' THEN
1051: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1052: itemkey => itemkey,
1053: aname => 'SOURCE_OBJECT_TYPE_CODE');
1054: print_message('current source type code=>'||l_source_object_code);
1055: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,

Line 1055: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,

1051: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1052: itemkey => itemkey,
1053: aname => 'SOURCE_OBJECT_TYPE_CODE');
1054: print_message('current source type code=>'||l_source_object_code);
1055: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
1056: itemkey => itemkey,
1057: aname => 'SOURCE_OBJECT_ID');
1058: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,
1059: itemkey => itemkey,

Line 1058: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,

1054: print_message('current source type code=>'||l_source_object_code);
1055: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
1056: itemkey => itemkey,
1057: aname => 'SOURCE_OBJECT_ID');
1058: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,
1059: itemkey => itemkey,
1060: aname => 'METH_NOTE_TYPE');
1061: print_message('methodology note type = '||l_meth_note_type);
1062: IF l_meth_note_type = 'CHECK_DURATION' THEN

Line 1139: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,

1135: BEGIN
1136: l_return_status := 'S';
1137: l_org_id:= fnd_profile.value('ORG_ID');
1138: IF funcmode = 'RUN' THEN
1139: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1140: itemkey => itemkey,
1141: aname => 'SOURCE_OBJECT_TYPE_CODE');
1142: print_message('current source type code=>'||l_source_object_code);
1143: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,

Line 1143: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,

1139: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1140: itemkey => itemkey,
1141: aname => 'SOURCE_OBJECT_TYPE_CODE');
1142: print_message('current source type code=>'||l_source_object_code);
1143: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
1144: itemkey => itemkey,
1145: aname => 'SOURCE_OBJECT_ID');
1146: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,
1147: itemkey => itemkey,

Line 1146: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,

1142: print_message('current source type code=>'||l_source_object_code);
1143: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
1144: itemkey => itemkey,
1145: aname => 'SOURCE_OBJECT_ID');
1146: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'METH_NOTE_TYPE');
1149: print_message('methodology note type = '||l_meth_note_type);
1150: IF l_meth_note_type = 'CURRENT_STAGE' THEN

Line 1243: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,

1239: BEGIN
1240: l_return_status := 'U';
1241: l_org_id :=fnd_profile.value('ORG_ID');
1242: IF funcmode = 'RUN' THEN
1243: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1244: itemkey => itemkey,
1245: aname => 'SOURCE_OBJECT_TYPE_CODE');
1246: print_message('current source type code=>'||l_source_object_code);
1247: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,

Line 1247: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,

1243: l_source_object_code := wf_engine.getitemattrtext( itemtype => itemtype,
1244: itemkey => itemkey,
1245: aname => 'SOURCE_OBJECT_TYPE_CODE');
1246: print_message('current source type code=>'||l_source_object_code);
1247: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
1248: itemkey => itemkey,
1249: aname => 'SOURCE_OBJECT_ID');
1250: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,
1251: itemkey => itemkey,

Line 1250: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,

1246: print_message('current source type code=>'||l_source_object_code);
1247: l_source_object_id:= wf_engine.getitemattrnumber( itemtype => itemtype,
1248: itemkey => itemkey,
1249: aname => 'SOURCE_OBJECT_ID');
1250: l_meth_note_type := wf_engine.getitemattrtext( itemtype => itemtype,
1251: itemkey => itemkey,
1252: aname => 'METH_NOTE_TYPE');
1253: print_message('methodology note type = '||l_meth_note_type);
1254: IF l_meth_note_type = 'CREATE_TASKS' THEN