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

Line 124: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);

120:
121: l_descriptor := substrb(l_order_type_txt || ', ' ||
122: l_header_txt, 1, 240);
123:
124: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);
125:
126: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
127: l_oper_unit_name);
128: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');

Line 126: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',

122: l_header_txt, 1, 240);
123:
124: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);
125:
126: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
127: l_oper_unit_name);
128: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
129: fnd_message.set_token('VERSION_NUMBER', l_version_number);
130: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',

Line 130: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',

126: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
127: l_oper_unit_name);
128: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
129: fnd_message.set_token('VERSION_NUMBER', l_version_number);
130: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
131: FND_MESSAGE.GET);
132: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
133: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
134: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

Line 134: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

130: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
131: FND_MESSAGE.GET);
132: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
133: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
134: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
135: FND_MESSAGE.GET);
136:
137: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
138: l_header_id);

Line 137: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',

133: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
134: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
135: FND_MESSAGE.GET);
136:
137: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
138: l_header_id);
139:
140: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);
141:

Line 140: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);

136:
137: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
138: l_header_id);
139:
140: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);
141:
142: END Set_blanket_Descriptor;
143: /**************************/
144:

Line 177: wf_engine.abortprocess(itemtype => l_item_type,

173: exit when err_flow%NOTFOUND;
174: OE_Debug_PUB.Add('Purge Error Flow for: ' || p_item_type || '/' || p_item_key);
175:
176: /* Abort the process before it can be purged */
177: wf_engine.abortprocess(itemtype => l_item_type,
178: itemkey => l_item_key,
179: process => l_process_name);
180: /* Now purge the process */
181: wf_purge.items(itemtype => l_item_type,

Line 212: l_error_itemkey := WF_ENGINE.GetItemAttrText(

208: --
209: -- Get the type and the key of the process that errored out
210: -- these were set in the erroring out process by Execute_Error_Process
211: --
212: l_error_itemkey := WF_ENGINE.GetItemAttrText(
213: itemtype => itemtype,
214: itemkey => itemkey,
215: aname => 'ERROR_ITEM_KEY' );
216: l_error_itemtype := WF_ENGINE.GetItemAttrText(

Line 216: l_error_itemtype := WF_ENGINE.GetItemAttrText(

212: l_error_itemkey := WF_ENGINE.GetItemAttrText(
213: itemtype => itemtype,
214: itemkey => itemkey,
215: aname => 'ERROR_ITEM_KEY' );
216: l_error_itemtype := WF_ENGINE.GetItemAttrText(
217: itemtype => itemtype,
218: itemkey => itemkey,
219: aname => 'ERROR_ITEM_TYPE' );
220:

Line 228: l_administrator := WF_ENGINE.GetItemAttrText(

224: --
225:
226: begin
227: --if this item type doesnt exist an exception is raised.
228: l_administrator := WF_ENGINE.GetItemAttrText(
229: itemtype => l_error_itemtype,
230: itemkey => l_error_itemkey,
231: aname => 'WF_ADMINISTRATOR' );
232:

Line 234: wf_engine.AssignActivity(itemtype,itemkey,

230: itemkey => l_error_itemkey,
231: aname => 'WF_ADMINISTRATOR' );
232:
233: /*begin
234: wf_engine.AssignActivity(itemtype,itemkey,
235: 'OM_ERROR_RETRY_ONLY',
236: l_administrator);
237: exception
238: when OTHERS then

Line 242: wf_engine.AssignActivity(itemtype,itemkey,'R_ERROR_RETRY:NOTIFY',

238: when OTHERS then
239: null;
240: end;*/ -- Commented for Bug# 5251478
241:
242: wf_engine.AssignActivity(itemtype,itemkey,'R_ERROR_RETRY:NOTIFY',
243: l_administrator); -- Bug# 5251478
244:
245: exception
246: when others then null;

Line 249: result := wf_engine.eng_completed;

245: exception
246: when others then null;
247: end;
248:
249: result := wf_engine.eng_completed;
250: ELSIF (funcmode = 'CANCEL') THEN
251: result := wf_engine.eng_completed;
252: END IF;
253: EXCEPTION

Line 251: result := wf_engine.eng_completed;

247: end;
248:
249: result := wf_engine.eng_completed;
250: ELSIF (funcmode = 'CANCEL') THEN
251: result := wf_engine.eng_completed;
252: END IF;
253: EXCEPTION
254: WHEN OTHERS THEN
255: WF_CORE.Context('OE_ERROR_WF', 'Initialize_Errors',

Line 291: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,

287: l_sold_to_org_id NUMBER;
288: l_org_id NUMBER;
289: begin
290: if (funcmode = 'RUN' ) then
291: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
292: 'ERROR_ITEM_TYPE');
293: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
294: 'ERROR_ITEM_KEY');
295:

Line 293: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,

289: begin
290: if (funcmode = 'RUN' ) then
291: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
292: 'ERROR_ITEM_TYPE');
293: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
294: 'ERROR_ITEM_KEY');
295:
296: l_conc_req_id := WF_ENGINE.GetItemAttrNumber(
297: itemtype => itemtype,

Line 296: l_conc_req_id := WF_ENGINE.GetItemAttrNumber(

292: 'ERROR_ITEM_TYPE');
293: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
294: 'ERROR_ITEM_KEY');
295:
296: l_conc_req_id := WF_ENGINE.GetItemAttrNumber(
297: itemtype => itemtype,
298: itemkey => itemkey,
299: aname => 'CONC_REQ_ID' );
300: IF err_itemtype = 'OEOH' THEN

Line 319: l_activity_id := WF_ENGINE.GetItemAttrNumber(

315: x_change_sequence => l_change_sequence,
316: x_header_id => l_header_id,
317: x_org_id => l_org_id);
318: END IF;
319: l_activity_id := WF_ENGINE.GetItemAttrNumber(
320: itemtype => itemtype,
321: itemkey => itemkey,
322: aname => 'ERROR_ACTIVITY_ID');
323:

Line 355: wf_engine.SetItemAttrText(itemtype, itemkey, 'ENTITY_DESCRIPTOR_LINE1',

351:
352: fnd_message.set_name('ONT', 'ONT_CONC_MSG');
353: fnd_message.set_token('CONC_REQ_ID', l_conc_req_id);
354: l_conc_msg := fnd_message.get;
355: wf_engine.SetItemAttrText(itemtype, itemkey, 'ENTITY_DESCRIPTOR_LINE1',
356: l_conc_msg);
357:
358: -- l_gwyuid := fnd_utilities.getenv('GWYUID');
359: -- l_two_task := fnd_utilities.getenv('TWO_TASK');

Line 369: --wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',

365: -- expire_time => null,
366: -- req_log => l_conc_req_url,
367: -- mgr_log => l_mgr_log);
368:
369: --wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
370: -- l_conc_req_url);
371:
372: -- oe_debug_pub.add ('l_result:' || l_result);
373: -- oe_debug_pub.add ('URL:' || l_conc_req_url);

Line 459: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,

455: --FND_GLOBAL.Apps_Initialize(1318, 21623, 660);
456:
457:
458:
459: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
460: 'ERROR_ITEM_TYPE');
461: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
462: 'ERROR_ITEM_KEY');
463:

Line 461: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,

457:
458:
459: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
460: 'ERROR_ITEM_TYPE');
461: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
462: 'ERROR_ITEM_KEY');
463:
464: IF err_itemtype = 'OEBH' THEN
465: -- At this time we do not have the generate diagnostics for blankets.

Line 468: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG_NO_URL');

464: IF err_itemtype = 'OEBH' THEN
465: -- At this time we do not have the generate diagnostics for blankets.
466: l_result_code := 'BYPASS_REQUEST';
467: -- We use a different message for blankets.
468: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG_NO_URL');
469: ELSE
470: l_profile_val := FND_PROFILE.VALUE('ONT_GENERATE_DIAGNOSTICS');
471: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' AND G_BATCH_RETRY_FLAG = 'N' THEN
472: l_result_code := 'SUBMIT_REQUEST';

Line 476: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG');

472: l_result_code := 'SUBMIT_REQUEST';
473: ELSE
474: l_result_code := 'BYPASS_REQUEST';
475: END IF;
476: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG');
477: END IF;
478:
479:
480:

Line 550: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);

546: -- l_descriptor_line1 := l_oper_unit_name_text;
547: -- l_descriptor_line2 := l_salesrep_text;
548:
549:
550: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);
551:
552: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
553: l_oper_unit_name);
554: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');

Line 552: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',

548:
549:
550: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);
551:
552: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
553: l_oper_unit_name);
554: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
555: fnd_message.set_token('VERSION_NUMBER', l_version_number);
556: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',

Line 556: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',

552: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
553: l_oper_unit_name);
554: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
555: fnd_message.set_token('VERSION_NUMBER', l_version_number);
556: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
557: FND_MESSAGE.GET);
558: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
559: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
560: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

Line 560: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

556: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
557: FND_MESSAGE.GET);
558: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
559: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
560: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
561: FND_MESSAGE.GET);
562:
563: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
564: -- l_descriptor_line1);

Line 563: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',

559: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
560: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
561: FND_MESSAGE.GET);
562:
563: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
564: -- l_descriptor_line1);
565: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
566: -- l_descriptor_line2);
567:

Line 565: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',

561: FND_MESSAGE.GET);
562:
563: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
564: -- l_descriptor_line1);
565: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
566: -- l_descriptor_line2);
567:
568: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
569: l_header_id);

Line 568: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',

564: -- l_descriptor_line1);
565: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
566: -- l_descriptor_line2);
567:
568: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
569: l_header_id);
570:
571: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110506' THEN
572: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;

Line 573: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);

569: l_header_id);
570:
571: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110506' THEN
572: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;
573: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
574: END IF;
575:
576:
577: resultout := 'COMPLETE:' || l_result_code;

Line 668: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);

664: l_descriptor := substrb(l_order_type_txt || ', ' ||
665: l_line_txt, 1, 240);
666:
667:
668: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);
669:
670: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
671: l_oper_unit_name);
672:

Line 670: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',

666:
667:
668: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR', l_descriptor);
669:
670: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
671: l_oper_unit_name);
672:
673: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
674: fnd_message.set_token('VERSION_NUMBER', l_version_number);

Line 675: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',

671: l_oper_unit_name);
672:
673: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
674: fnd_message.set_token('VERSION_NUMBER', l_version_number);
675: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
676: FND_MESSAGE.GET);
677: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
678: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
679: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

Line 679: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

675: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
676: FND_MESSAGE.GET);
677: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
678: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
679: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
680: FND_MESSAGE.GET);
681:
682: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
683: -- l_descriptor_line1);

Line 682: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',

678: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
679: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
680: FND_MESSAGE.GET);
681:
682: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
683: -- l_descriptor_line1);
684: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
685: -- l_descriptor_line2);
686:

Line 684: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',

680: FND_MESSAGE.GET);
681:
682: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
683: -- l_descriptor_line1);
684: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
685: -- l_descriptor_line2);
686:
687: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
688: l_header_id);

Line 687: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',

683: -- l_descriptor_line1);
684: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
685: -- l_descriptor_line2);
686:
687: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
688: l_header_id);
689: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;
690: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
691: resultout := 'COMPLETE:' || l_result_code;

Line 690: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);

686:
687: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
688: l_header_id);
689: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;
690: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
691: resultout := 'COMPLETE:' || l_result_code;
692: return;
693:
694: elsif err_itemtype IN ('OESO','OEOI','OEOA','OEXWFEDI') THEN

Line 723: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR',

719: FND_MESSAGE.SET_TOKEN ('ORIG_SYS_DOCUMENT_REF', l_orig_sys_document_ref);
720: FND_MESSAGE.SET_TOKEN ('CUSTOMER', l_sold_to_org);
721: l_descriptor := FND_MESSAGE.GET;
722:
723: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_SHORT_DESCRIPTOR',
724: l_descriptor);
725:
726: IF l_org_id IS NOT NULL THEN
727: SELECT name

Line 734: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG');

730: WHERE ORGANIZATION_ID = l_org_id;
731: END IF;
732:
733: If (l_header_id IS NOT NULL) Then
734: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG');
735:
736: SELECT order_number, order_type_id, order_category_code,
737: SALESREP_ID, VERSION_NUMBER, FLOW_STATUS_CODE
738: into l_order_number, l_order_type_id, l_order_category_code,

Line 791: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2', l_descriptor_line2);

787: -- l_descriptor_line1 := l_oper_unit_name_text;
788: -- l_descriptor_line2 := l_salesrep_text;
789:
790:
791: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2', l_descriptor_line2);
792:
793: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
794: fnd_message.set_token('VERSION_NUMBER', l_version_number);
795: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',

Line 795: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',

791: wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2', l_descriptor_line2);
792:
793: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');
794: fnd_message.set_token('VERSION_NUMBER', l_version_number);
795: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
796: FND_MESSAGE.GET);
797: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
798: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
799: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

Line 799: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',

795: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
796: FND_MESSAGE.GET);
797: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');
798: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
799: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
800: FND_MESSAGE.GET);
801:
802: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
803: -- l_descriptor_line1);

Line 802: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',

798: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);
799: wf_engine.SetItemAttrText(itemtype,itemkey, 'FLOW_STATUS',
800: FND_MESSAGE.GET);
801:
802: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
803: -- l_descriptor_line1);
804: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
805: -- l_descriptor_line2);
806:

Line 804: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',

800: FND_MESSAGE.GET);
801:
802: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',
803: -- l_descriptor_line1);
804: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',
805: -- l_descriptor_line2);
806:
807: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110506' THEN
808: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;

Line 809: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);

805: -- l_descriptor_line2);
806:
807: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110506' THEN
808: l_url := rtrim(fnd_profile.Value('APPS_FRAMEWORK_AGENT'), '/')||'/OA_HTML/OA.jsp?akRegionCode=ORDER_DETAILS_PAGE' || '&' || 'akRegionApplicationId=660' || '&' || 'HeaderId=' || l_header_id;
809: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
810: END IF;
811: else -- l_header_id is null so don't submit the concurrent request
812: l_result_code := 'BYPASS_REQUEST';
813: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);

Line 813: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);

809: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', l_url);
810: END IF;
811: else -- l_header_id is null so don't submit the concurrent request
812: l_result_code := 'BYPASS_REQUEST';
813: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);
814: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG_NO_URL');
815:
816: end if;
817: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',

Line 814: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG_NO_URL');

810: END IF;
811: else -- l_header_id is null so don't submit the concurrent request
812: l_result_code := 'BYPASS_REQUEST';
813: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);
814: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG_NO_URL');
815:
816: end if;
817: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
818: l_oper_unit_name);

Line 817: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',

813: wf_engine.SetItemAttrText(itemtype,itemkey, 'TRANSACTION_DETAIL_URL', NULL);
814: wf_engine.SetItemAttrText(itemtype, itemkey, 'MESSAGE_NAME', 'OMERROR_MSG_NO_URL');
815:
816: end if;
817: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
818: l_oper_unit_name);
819: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
820: l_header_id);
821:

Line 819: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',

815:
816: end if;
817: wf_engine.SetItemAttrText(itemtype,itemkey, 'OPERATING_UNIT',
818: l_oper_unit_name);
819: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',
820: l_header_id);
821:
822: resultout := 'COMPLETE:' || l_result_code;
823: return;

Line 896: l_error_itemkey := WF_ENGINE.GetItemAttrText(

892: --
893: -- Get the type and the key of the process that errored out
894: -- these were set in the erroring out process by Execute_Error_Process
895: --
896: l_error_itemkey := WF_ENGINE.GetItemAttrText(
897: itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'ERROR_ITEM_KEY' );
900: l_error_itemtype := WF_ENGINE.GetItemAttrText(

Line 900: l_error_itemtype := WF_ENGINE.GetItemAttrText(

896: l_error_itemkey := WF_ENGINE.GetItemAttrText(
897: itemtype => itemtype,
898: itemkey => itemkey,
899: aname => 'ERROR_ITEM_KEY' );
900: l_error_itemtype := WF_ENGINE.GetItemAttrText(
901: itemtype => itemtype,
902: itemkey => itemkey,
903: aname => 'ERROR_ITEM_TYPE' );
904:

Line 905: l_error_actid := WF_ENGINE.GetItemAttrText(

901: itemtype => itemtype,
902: itemkey => itemkey,
903: aname => 'ERROR_ITEM_TYPE' );
904:
905: l_error_actid := WF_ENGINE.GetItemAttrText(
906: itemtype => itemtype,
907: itemkey => itemkey,
908: aname => 'ERROR_ACTIVITY_ID' );
909:

Line 962: if (funcmode <> wf_engine.eng_run) then

958: err_actname VARCHAR2(30);
959: err_actitemtype VARCHAR2(8);
960: begin
961: -- Do nothing in cancel or timeout mode
962: if (funcmode <> wf_engine.eng_run) then
963: resultout := wf_engine.eng_null;
964: return;
965: end if;
966:

Line 963: resultout := wf_engine.eng_null;

959: err_actitemtype VARCHAR2(8);
960: begin
961: -- Do nothing in cancel or timeout mode
962: if (funcmode <> wf_engine.eng_run) then
963: resultout := wf_engine.eng_null;
964: return;
965: end if;
966:
967: -- SYNCHMODE: Not allowed

Line 968: if (itemkey = wf_engine.eng_synch) then

964: return;
965: end if;
966:
967: -- SYNCHMODE: Not allowed
968: if (itemkey = wf_engine.eng_synch) then
969: Wf_Core.Token('OPERATION', 'Wf_Standard.ResetError');
970: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
971: end if;
972:

Line 974: cmd := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'COMMAND');

970: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
971: end if;
972:
973: -- Get RETRY or SKIP command
974: cmd := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'COMMAND');
975:
976: -- Get original errored activity info
977: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
978: 'ERROR_ITEM_TYPE');

Line 977: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,

973: -- Get RETRY or SKIP command
974: cmd := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'COMMAND');
975:
976: -- Get original errored activity info
977: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
978: 'ERROR_ITEM_TYPE');
979: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
980: 'ERROR_ITEM_KEY');
981: err_actlabel := Wf_Engine.GetItemAttrText(itemtype, itemkey,

Line 979: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,

975:
976: -- Get original errored activity info
977: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
978: 'ERROR_ITEM_TYPE');
979: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
980: 'ERROR_ITEM_KEY');
981: err_actlabel := Wf_Engine.GetItemAttrText(itemtype, itemkey,
982: 'ERROR_ACTIVITY_LABEL');
983: if (cmd = wf_engine.eng_retry) then

Line 981: err_actlabel := Wf_Engine.GetItemAttrText(itemtype, itemkey,

977: err_itemtype := Wf_Engine.GetItemAttrText(itemtype, itemkey,
978: 'ERROR_ITEM_TYPE');
979: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
980: 'ERROR_ITEM_KEY');
981: err_actlabel := Wf_Engine.GetItemAttrText(itemtype, itemkey,
982: 'ERROR_ACTIVITY_LABEL');
983: if (cmd = wf_engine.eng_retry) then
984: -- Rerun activity
985:

Line 983: if (cmd = wf_engine.eng_retry) then

979: err_itemkey := Wf_Engine.GetItemAttrText(itemtype, itemkey,
980: 'ERROR_ITEM_KEY');
981: err_actlabel := Wf_Engine.GetItemAttrText(itemtype, itemkey,
982: 'ERROR_ACTIVITY_LABEL');
983: if (cmd = wf_engine.eng_retry) then
984: -- Rerun activity
985:
986:
987: err_actid := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,

Line 987: err_actid := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,

983: if (cmd = wf_engine.eng_retry) then
984: -- Rerun activity
985:
986:
987: err_actid := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,
988: 'ERROR_ACTIVITY_ID');
989:
990: l_header_id := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,
991: 'HEADER_ID');

Line 990: l_header_id := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,

986:
987: err_actid := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,
988: 'ERROR_ACTIVITY_ID');
989:
990: l_header_id := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,
991: 'HEADER_ID');
992:
993: if err_itemtype = 'OEOH' THEN
994: OE_MSG_PUB.Update_Status_Code(

Line 1016: /* l_order_source_id := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,

1012: x_change_sequence => l_change_sequence,
1013: x_header_id => l_header_id,
1014: x_org_id => l_org_id);
1015:
1016: /* l_order_source_id := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,
1017: 'ORDER_SOURCE_ID');
1018: l_orig_sys_document_ref := Wf_Engine.GetItemAttrText(itemtype, itemkey,
1019: 'ORIG_SYS_DOCUMENT_REF');*/
1020: OE_MSG_PUB.Update_Status_Code(

Line 1018: l_orig_sys_document_ref := Wf_Engine.GetItemAttrText(itemtype, itemkey,

1014: x_org_id => l_org_id);
1015:
1016: /* l_order_source_id := Wf_Engine.GetItemAttrNumber(itemtype, itemkey,
1017: 'ORDER_SOURCE_ID');
1018: l_orig_sys_document_ref := Wf_Engine.GetItemAttrText(itemtype, itemkey,
1019: 'ORIG_SYS_DOCUMENT_REF');*/
1020: OE_MSG_PUB.Update_Status_Code(
1021: p_order_source_id => l_order_source_id,
1022: p_orig_sys_document_ref => l_orig_sys_document_ref,

Line 1040: Wf_Engine.HandleError(err_itemtype, err_itemkey, err_actlabel,

1036: END IF;
1037:
1038: IF NOT (err_itemtype = 'OEOL' AND err_actname IS NOT NULL AND err_actname = 'SHIP_LINE'
1039: AND Check_Closed_Delivery_Detail (err_itemkey, err_actid)) THEN
1040: Wf_Engine.HandleError(err_itemtype, err_itemkey, err_actlabel,
1041: cmd, '');
1042: END IF;
1043:
1044: /* Disallow skip mode because it is too difficult to

Line 1046: elsif (cmd = wf_engine.eng_skip) then

1042: END IF;
1043:
1044: /* Disallow skip mode because it is too difficult to
1045: assign and validate the RESULT value
1046: elsif (cmd = wf_engine.eng_skip) then
1047: -- Get result code
1048: result := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
1049: 'RESULT');
1050: -- Mark activity complete and continue processing

Line 1048: result := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,

1044: /* Disallow skip mode because it is too difficult to
1045: assign and validate the RESULT value
1046: elsif (cmd = wf_engine.eng_skip) then
1047: -- Get result code
1048: result := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
1049: 'RESULT');
1050: -- Mark activity complete and continue processing
1051: Wf_Engine.HandleError(err_itemtype, err_itemkey, err_actlabel,
1052: cmd, result);

Line 1051: Wf_Engine.HandleError(err_itemtype, err_itemkey, err_actlabel,

1047: -- Get result code
1048: result := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid,
1049: 'RESULT');
1050: -- Mark activity complete and continue processing
1051: Wf_Engine.HandleError(err_itemtype, err_itemkey, err_actlabel,
1052: cmd, result);
1053: */
1054: else
1055: raise wf_invalid_command;

Line 1058: resultout := wf_engine.eng_null;

1054: else
1055: raise wf_invalid_command;
1056: end if;
1057:
1058: resultout := wf_engine.eng_null;
1059: exception
1060: when wf_invalid_command then
1061: Wf_Core.Context('OE_STANDARD_WF', 'Reset_Error', itemtype,
1062: itemkey, to_char(actid), funcmode);

Line 1087: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');

1083:
1084: x_order_source_id := 20;
1085:
1086: if p_itemtype IN ('OESO','OEOA') then
1087: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1088: else
1089: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER2');
1090: end if;
1091:

Line 1089: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER2');

1085:
1086: if p_itemtype IN ('OESO','OEOA') then
1087: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1088: else
1089: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER2');
1090: end if;
1091:
1092: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'PARAMETER4');
1093:

Line 1092: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'PARAMETER4');

1088: else
1089: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER2');
1090: end if;
1091:
1092: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'PARAMETER4');
1093:
1094: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER7');
1095:
1096: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');

Line 1094: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER7');

1090: end if;
1091:
1092: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'PARAMETER4');
1093:
1094: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER7');
1095:
1096: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1097:
1098: if p_itemtype = 'OESO' then

Line 1096: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');

1092: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'PARAMETER4');
1093:
1094: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER7');
1095:
1096: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1097:
1098: if p_itemtype = 'OESO' then
1099: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');
1100: else

Line 1099: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');

1095:
1096: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1097:
1098: if p_itemtype = 'OESO' then
1099: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');
1100: else
1101: -- try to derive header id for OEOA and OEOI
1102: fnd_profile.get('ONT_INCLUDE_CUST_IN_OI_KEY', l_customer_key_profile);
1103: l_customer_key_profile := nvl(l_customer_key_profile, 'N');

Line 1121: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');

1117: x_header_id := NULL;
1118: End;
1119: end if;
1120: Elsif p_itemtype = 'OEXWFEDI' Then
1121: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1122:
1123: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1124: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'SOLD_TO_ORG_ID');
1125: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');

Line 1123: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');

1119: end if;
1120: Elsif p_itemtype = 'OEXWFEDI' Then
1121: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1122:
1123: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1124: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'SOLD_TO_ORG_ID');
1125: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1126: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'CHANGE_SEQUENCE');
1127: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');

Line 1124: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'SOLD_TO_ORG_ID');

1120: Elsif p_itemtype = 'OEXWFEDI' Then
1121: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1122:
1123: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1124: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'SOLD_TO_ORG_ID');
1125: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1126: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'CHANGE_SEQUENCE');
1127: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');
1128:

Line 1125: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');

1121: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1122:
1123: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1124: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'SOLD_TO_ORG_ID');
1125: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1126: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'CHANGE_SEQUENCE');
1127: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');
1128:
1129: End If;

Line 1126: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'CHANGE_SEQUENCE');

1122:
1123: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1124: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'SOLD_TO_ORG_ID');
1125: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1126: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'CHANGE_SEQUENCE');
1127: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');
1128:
1129: End If;
1130:

Line 1127: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');

1123: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1124: x_sold_to_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'SOLD_TO_ORG_ID');
1125: x_org_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORG_ID');
1126: x_change_sequence := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'CHANGE_SEQUENCE');
1127: x_header_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'HEADER_ID');
1128:
1129: End If;
1130:
1131:

Line 1152: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');

1148:
1149: x_order_source_id := 20;
1150:
1151: if p_itemtype IN ('OESO','OEOA') then
1152: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1153: else
1154: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER2');
1155: end if;
1156:

Line 1154: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER2');

1150:
1151: if p_itemtype IN ('OESO','OEOA') then
1152: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1153: else
1154: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARAMETER2');
1155: end if;
1156:
1157: ELSIF p_itemtype = 'OEXWFEDI' Then
1158:

Line 1159: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');

1155: end if;
1156:
1157: ELSIF p_itemtype = 'OEXWFEDI' Then
1158:
1159: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1160: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1161:
1162: ELSIF p_itemtype = 'OEEM' THEN
1163:

Line 1160: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');

1156:
1157: ELSIF p_itemtype = 'OEXWFEDI' Then
1158:
1159: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1160: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1161:
1162: ELSIF p_itemtype = 'OEEM' THEN
1163:
1164: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');

Line 1164: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');

1160: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'ORIG_SYS_DOCUMENT_REF');
1161:
1162: ELSIF p_itemtype = 'OEEM' THEN
1163:
1164: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1165: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARTNER_DOCUMENT_NO');
1166:
1167: END IF;
1168: IF l_debug_level > 0 THEN

Line 1165: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARTNER_DOCUMENT_NO');

1161:
1162: ELSIF p_itemtype = 'OEEM' THEN
1163:
1164: x_order_source_id := wf_engine.GetItemAttrNumber (p_itemtype, p_itemkey, 'ORDER_SOURCE_ID');
1165: x_orig_sys_document_ref := wf_engine.GetItemAttrText (p_itemtype, p_itemkey, 'PARTNER_DOCUMENT_NO');
1166:
1167: END IF;
1168: IF l_debug_level > 0 THEN
1169: oe_debug_pub.add('Exiting Get_EM_Key_Info with order_source_id: ' || x_order_source_id || ' and orig_sys_document_ref: ' || x_orig_sys_document_ref);

Line 1363: status => wf_engine.eng_notified,

1359: BEGIN
1360: Wf_Item_Activity_Status.Create_Status (itemtype => 'OEOL',
1361: itemkey => p_item_key,
1362: actid => p_process_activity,
1363: status => wf_engine.eng_notified,
1364: result => wf_engine.eng_null,
1365: beginning => SYSDATE,
1366: ending => null);
1367: EXCEPTION

Line 1364: result => wf_engine.eng_null,

1360: Wf_Item_Activity_Status.Create_Status (itemtype => 'OEOL',
1361: itemkey => p_item_key,
1362: actid => p_process_activity,
1363: status => wf_engine.eng_notified,
1364: result => wf_engine.eng_null,
1365: beginning => SYSDATE,
1366: ending => null);
1367: EXCEPTION
1368: WHEN OTHERS THEN

Line 1513: x_order_source_id := wf_engine.GetItemAttrText (p_item_type,

1509: l_pos := instr (p_user_key, ',');
1510: x_orig_sys_document_ref := substr(p_user_key, 1, l_pos-1);
1511:
1512: ELSIF p_item_type = 'OEXWFEDI' THEN
1513: x_order_source_id := wf_engine.GetItemAttrText (p_item_type,
1514: p_item_key,
1515: 'ORDER_SOURCE_ID'
1516: );
1517: l_pos := instr (p_user_key, ',');

Line 2250: WF_ENGINE.HandleError(p_item_type,

2246: ----------------------------------------------------------------------------
2247: -- Ready to retry the activity
2248: ----------------------------------------------------------------------------
2249:
2250: WF_ENGINE.HandleError(p_item_type,
2251: l_retry_rec.item_key(i),
2252: l_retry_rec.process_name(i)||':'||l_retry_rec.activity_label(i),
2253: 'RETRY',
2254: NULL);