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 FND_MESSAGE

Line 114: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');

110: where LOOKUP_CODE = l_flow_status_code
111: AND LOOKUP_TYPE = 'FLOW_STATUS';
112: END IF;
113:
114: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
115: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
116: l_order_type_txt := fnd_message.get;
117: fnd_message.set_name('ONT', 'OE_BLKT_SALES_AGREEMENT');
118: fnd_message.set_token('BLANKET_NUMBER', to_char(l_order_number));

Line 115: fnd_message.set_token('ORDER_TYPE', l_order_type_name);

111: AND LOOKUP_TYPE = 'FLOW_STATUS';
112: END IF;
113:
114: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
115: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
116: l_order_type_txt := fnd_message.get;
117: fnd_message.set_name('ONT', 'OE_BLKT_SALES_AGREEMENT');
118: fnd_message.set_token('BLANKET_NUMBER', to_char(l_order_number));
119: l_header_txt := fnd_message.get;

Line 116: l_order_type_txt := fnd_message.get;

112: END IF;
113:
114: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
115: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
116: l_order_type_txt := fnd_message.get;
117: fnd_message.set_name('ONT', 'OE_BLKT_SALES_AGREEMENT');
118: fnd_message.set_token('BLANKET_NUMBER', to_char(l_order_number));
119: l_header_txt := fnd_message.get;
120:

Line 117: fnd_message.set_name('ONT', 'OE_BLKT_SALES_AGREEMENT');

113:
114: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
115: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
116: l_order_type_txt := fnd_message.get;
117: fnd_message.set_name('ONT', 'OE_BLKT_SALES_AGREEMENT');
118: fnd_message.set_token('BLANKET_NUMBER', to_char(l_order_number));
119: l_header_txt := fnd_message.get;
120:
121: l_descriptor := substrb(l_order_type_txt || ', ' ||

Line 118: fnd_message.set_token('BLANKET_NUMBER', to_char(l_order_number));

114: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
115: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
116: l_order_type_txt := fnd_message.get;
117: fnd_message.set_name('ONT', 'OE_BLKT_SALES_AGREEMENT');
118: fnd_message.set_token('BLANKET_NUMBER', to_char(l_order_number));
119: l_header_txt := fnd_message.get;
120:
121: l_descriptor := substrb(l_order_type_txt || ', ' ||
122: l_header_txt, 1, 240);

Line 119: l_header_txt := fnd_message.get;

115: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
116: l_order_type_txt := fnd_message.get;
117: fnd_message.set_name('ONT', 'OE_BLKT_SALES_AGREEMENT');
118: fnd_message.set_token('BLANKET_NUMBER', to_char(l_order_number));
119: l_header_txt := fnd_message.get;
120:
121: l_descriptor := substrb(l_order_type_txt || ', ' ||
122: l_header_txt, 1, 240);
123:

Line 128: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');

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',
131: FND_MESSAGE.GET);
132: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

Line 129: fnd_message.set_token('VERSION_NUMBER', l_version_number);

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',
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);

Line 131: FND_MESSAGE.GET);

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',
135: FND_MESSAGE.GET);

Line 132: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

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',
135: FND_MESSAGE.GET);
136:

Line 133: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);

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',
135: FND_MESSAGE.GET);
136:
137: wf_engine.SetItemAttrNumber(itemtype,itemkey, 'HEADER_ID',

Line 135: FND_MESSAGE.GET);

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);
139:

Line 346: fnd_message.set_name('ONT', 'ONT_CONC_MSG');

342: oe_msg_pub.set_msg_context(
343: p_header_id => l_header_id
344: ,p_line_id => l_line_id);
345: END IF;
346: fnd_message.set_name('ONT', 'ONT_CONC_MSG');
347: fnd_message.set_token('CONC_REQ_ID', l_conc_req_id);
348: OE_MSG_PUB.Add;
349: OE_STANDARD_WF.Save_Messages;
350: OE_STANDARD_WF.Clear_Msg_Context;

Line 347: fnd_message.set_token('CONC_REQ_ID', l_conc_req_id);

343: p_header_id => l_header_id
344: ,p_line_id => l_line_id);
345: END IF;
346: fnd_message.set_name('ONT', 'ONT_CONC_MSG');
347: fnd_message.set_token('CONC_REQ_ID', l_conc_req_id);
348: OE_MSG_PUB.Add;
349: OE_STANDARD_WF.Save_Messages;
350: OE_STANDARD_WF.Clear_Msg_Context;
351:

Line 352: fnd_message.set_name('ONT', 'ONT_CONC_MSG');

348: OE_MSG_PUB.Add;
349: OE_STANDARD_WF.Save_Messages;
350: OE_STANDARD_WF.Clear_Msg_Context;
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);

Line 353: fnd_message.set_token('CONC_REQ_ID', l_conc_req_id);

349: OE_STANDARD_WF.Save_Messages;
350: OE_STANDARD_WF.Clear_Msg_Context;
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:

Line 354: l_conc_msg := fnd_message.get;

350: OE_STANDARD_WF.Clear_Msg_Context;
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');

Line 517: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');

513: where LOOKUP_CODE = l_flow_status_code
514: AND LOOKUP_TYPE = 'FLOW_STATUS';
515: END IF;
516:
517: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
518: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
519: l_order_type_txt := fnd_message.get;
520: IF l_order_category_code = 'RETURN' THEN
521: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');

Line 518: fnd_message.set_token('ORDER_TYPE', l_order_type_name);

514: AND LOOKUP_TYPE = 'FLOW_STATUS';
515: END IF;
516:
517: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
518: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
519: l_order_type_txt := fnd_message.get;
520: IF l_order_category_code = 'RETURN' THEN
521: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
522: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 519: l_order_type_txt := fnd_message.get;

515: END IF;
516:
517: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
518: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
519: l_order_type_txt := fnd_message.get;
520: IF l_order_category_code = 'RETURN' THEN
521: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
522: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
523: l_header_txt := fnd_message.get;

Line 521: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');

517: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
518: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
519: l_order_type_txt := fnd_message.get;
520: IF l_order_category_code = 'RETURN' THEN
521: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
522: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
523: l_header_txt := fnd_message.get;
524: ELSE
525: if err_itemtype = 'OENH' THEN

Line 522: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

518: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
519: l_order_type_txt := fnd_message.get;
520: IF l_order_category_code = 'RETURN' THEN
521: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
522: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
523: l_header_txt := fnd_message.get;
524: ELSE
525: if err_itemtype = 'OENH' THEN
526: fnd_message.set_name('ONT', 'OE_NEGO_SALES_ORDER');

Line 523: l_header_txt := fnd_message.get;

519: l_order_type_txt := fnd_message.get;
520: IF l_order_category_code = 'RETURN' THEN
521: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
522: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
523: l_header_txt := fnd_message.get;
524: ELSE
525: if err_itemtype = 'OENH' THEN
526: fnd_message.set_name('ONT', 'OE_NEGO_SALES_ORDER');
527: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 526: fnd_message.set_name('ONT', 'OE_NEGO_SALES_ORDER');

522: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
523: l_header_txt := fnd_message.get;
524: ELSE
525: if err_itemtype = 'OENH' THEN
526: fnd_message.set_name('ONT', 'OE_NEGO_SALES_ORDER');
527: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
528: ELSE
529: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
530: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 527: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

523: l_header_txt := fnd_message.get;
524: ELSE
525: if err_itemtype = 'OENH' THEN
526: fnd_message.set_name('ONT', 'OE_NEGO_SALES_ORDER');
527: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
528: ELSE
529: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
530: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
531: END IF;

Line 529: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');

525: if err_itemtype = 'OENH' THEN
526: fnd_message.set_name('ONT', 'OE_NEGO_SALES_ORDER');
527: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
528: ELSE
529: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
530: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
531: END IF;
532: l_header_txt := fnd_message.get;
533: END IF;

Line 530: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

526: fnd_message.set_name('ONT', 'OE_NEGO_SALES_ORDER');
527: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
528: ELSE
529: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
530: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
531: END IF;
532: l_header_txt := fnd_message.get;
533: END IF;
534:

Line 532: l_header_txt := fnd_message.get;

528: ELSE
529: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
530: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
531: END IF;
532: l_header_txt := fnd_message.get;
533: END IF;
534:
535: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
536: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);

Line 535: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');

531: END IF;
532: l_header_txt := fnd_message.get;
533: END IF;
534:
535: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
536: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
537: -- l_oper_unit_name_text := fnd_message.get;
538:
539: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');

Line 536: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);

532: l_header_txt := fnd_message.get;
533: END IF;
534:
535: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
536: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
537: -- l_oper_unit_name_text := fnd_message.get;
538:
539: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
540: -- fnd_message.set_token('SALES_REP', l_salesrep);

Line 537: -- l_oper_unit_name_text := fnd_message.get;

533: END IF;
534:
535: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
536: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
537: -- l_oper_unit_name_text := fnd_message.get;
538:
539: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
540: -- fnd_message.set_token('SALES_REP', l_salesrep);
541: -- l_salesrep_text := fnd_message.get;

Line 539: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');

535: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
536: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
537: -- l_oper_unit_name_text := fnd_message.get;
538:
539: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
540: -- fnd_message.set_token('SALES_REP', l_salesrep);
541: -- l_salesrep_text := fnd_message.get;
542:
543:

Line 540: -- fnd_message.set_token('SALES_REP', l_salesrep);

536: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
537: -- l_oper_unit_name_text := fnd_message.get;
538:
539: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
540: -- fnd_message.set_token('SALES_REP', l_salesrep);
541: -- l_salesrep_text := fnd_message.get;
542:
543:
544: l_descriptor := substrb(l_order_type_txt || ', ' ||

Line 541: -- l_salesrep_text := fnd_message.get;

537: -- l_oper_unit_name_text := fnd_message.get;
538:
539: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
540: -- fnd_message.set_token('SALES_REP', l_salesrep);
541: -- l_salesrep_text := fnd_message.get;
542:
543:
544: l_descriptor := substrb(l_order_type_txt || ', ' ||
545: l_header_txt, 1, 240);

Line 554: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');

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',
557: FND_MESSAGE.GET);
558: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

Line 555: fnd_message.set_token('VERSION_NUMBER', l_version_number);

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',
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);

Line 557: FND_MESSAGE.GET);

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',
561: FND_MESSAGE.GET);

Line 558: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

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',
561: FND_MESSAGE.GET);
562:

Line 559: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);

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',
561: FND_MESSAGE.GET);
562:
563: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',

Line 561: FND_MESSAGE.GET);

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);
565: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',

Line 621: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');

617: AND LOOKUP_TYPE = 'LINE_FLOW_STATUS';
618: END IF;
619:
620: IF l_order_category_code = 'RETURN' THEN
621: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
622: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
623: l_header_txt := fnd_message.get;
624: ELSE
625: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');

Line 622: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

618: END IF;
619:
620: IF l_order_category_code = 'RETURN' THEN
621: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
622: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
623: l_header_txt := fnd_message.get;
624: ELSE
625: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
626: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 623: l_header_txt := fnd_message.get;

619:
620: IF l_order_category_code = 'RETURN' THEN
621: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
622: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
623: l_header_txt := fnd_message.get;
624: ELSE
625: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
626: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
627: l_header_txt := fnd_message.get;

Line 625: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');

621: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
622: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
623: l_header_txt := fnd_message.get;
624: ELSE
625: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
626: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
627: l_header_txt := fnd_message.get;
628: END IF;
629:

Line 626: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

622: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
623: l_header_txt := fnd_message.get;
624: ELSE
625: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
626: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
627: l_header_txt := fnd_message.get;
628: END IF;
629:
630: l_concat_line_num := OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(p_line_id => to_number(err_itemkey));

Line 627: l_header_txt := fnd_message.get;

623: l_header_txt := fnd_message.get;
624: ELSE
625: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
626: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
627: l_header_txt := fnd_message.get;
628: END IF;
629:
630: l_concat_line_num := OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(p_line_id => to_number(err_itemkey));
631:

Line 633: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');

629:
630: l_concat_line_num := OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(p_line_id => to_number(err_itemkey));
631:
632: -- Do we need this?? XXXXXX
633: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
634: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
635: l_order_type_txt := fnd_message.get;
636:
637: IF l_order_category_code = 'RETURN' THEN

Line 634: fnd_message.set_token('ORDER_TYPE', l_order_type_name);

630: l_concat_line_num := OE_ORDER_MISC_PUB.GET_CONCAT_LINE_NUMBER(p_line_id => to_number(err_itemkey));
631:
632: -- Do we need this?? XXXXXX
633: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
634: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
635: l_order_type_txt := fnd_message.get;
636:
637: IF l_order_category_code = 'RETURN' THEN
638: fnd_message.set_name('ONT', 'OE_WF_CONCAT_RETURN_LINE');

Line 635: l_order_type_txt := fnd_message.get;

631:
632: -- Do we need this?? XXXXXX
633: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
634: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
635: l_order_type_txt := fnd_message.get;
636:
637: IF l_order_category_code = 'RETURN' THEN
638: fnd_message.set_name('ONT', 'OE_WF_CONCAT_RETURN_LINE');
639: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 638: fnd_message.set_name('ONT', 'OE_WF_CONCAT_RETURN_LINE');

634: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
635: l_order_type_txt := fnd_message.get;
636:
637: IF l_order_category_code = 'RETURN' THEN
638: fnd_message.set_name('ONT', 'OE_WF_CONCAT_RETURN_LINE');
639: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
640: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
641:
642: l_line_txt := fnd_message.get;

Line 639: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

635: l_order_type_txt := fnd_message.get;
636:
637: IF l_order_category_code = 'RETURN' THEN
638: fnd_message.set_name('ONT', 'OE_WF_CONCAT_RETURN_LINE');
639: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
640: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
641:
642: l_line_txt := fnd_message.get;
643: ELSE

Line 640: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);

636:
637: IF l_order_category_code = 'RETURN' THEN
638: fnd_message.set_name('ONT', 'OE_WF_CONCAT_RETURN_LINE');
639: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
640: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
641:
642: l_line_txt := fnd_message.get;
643: ELSE
644: fnd_message.set_name('ONT', 'OE_WF_CONCAT_LINE');

Line 642: l_line_txt := fnd_message.get;

638: fnd_message.set_name('ONT', 'OE_WF_CONCAT_RETURN_LINE');
639: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
640: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
641:
642: l_line_txt := fnd_message.get;
643: ELSE
644: fnd_message.set_name('ONT', 'OE_WF_CONCAT_LINE');
645: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
646: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);

Line 644: fnd_message.set_name('ONT', 'OE_WF_CONCAT_LINE');

640: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
641:
642: l_line_txt := fnd_message.get;
643: ELSE
644: fnd_message.set_name('ONT', 'OE_WF_CONCAT_LINE');
645: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
646: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
647:
648: l_line_txt := fnd_message.get;

Line 645: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

641:
642: l_line_txt := fnd_message.get;
643: ELSE
644: fnd_message.set_name('ONT', 'OE_WF_CONCAT_LINE');
645: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
646: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
647:
648: l_line_txt := fnd_message.get;
649: END IF;

Line 646: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);

642: l_line_txt := fnd_message.get;
643: ELSE
644: fnd_message.set_name('ONT', 'OE_WF_CONCAT_LINE');
645: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
646: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
647:
648: l_line_txt := fnd_message.get;
649: END IF;
650:

Line 648: l_line_txt := fnd_message.get;

644: fnd_message.set_name('ONT', 'OE_WF_CONCAT_LINE');
645: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
646: fnd_message.set_token('CONCAT_LINE_NUMBER', l_concat_line_num);
647:
648: l_line_txt := fnd_message.get;
649: END IF;
650:
651: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
652: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);

Line 651: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');

647:
648: l_line_txt := fnd_message.get;
649: END IF;
650:
651: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
652: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
653: -- l_oper_unit_name_text := fnd_message.get;
654:
655: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');

Line 652: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);

648: l_line_txt := fnd_message.get;
649: END IF;
650:
651: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
652: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
653: -- l_oper_unit_name_text := fnd_message.get;
654:
655: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
656: -- fnd_message.set_token('SALES_REP', l_salesrep);

Line 653: -- l_oper_unit_name_text := fnd_message.get;

649: END IF;
650:
651: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
652: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
653: -- l_oper_unit_name_text := fnd_message.get;
654:
655: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
656: -- fnd_message.set_token('SALES_REP', l_salesrep);
657: -- l_salesrep_text := fnd_message.get;

Line 655: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');

651: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
652: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
653: -- l_oper_unit_name_text := fnd_message.get;
654:
655: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
656: -- fnd_message.set_token('SALES_REP', l_salesrep);
657: -- l_salesrep_text := fnd_message.get;
658:
659:

Line 656: -- fnd_message.set_token('SALES_REP', l_salesrep);

652: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
653: -- l_oper_unit_name_text := fnd_message.get;
654:
655: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
656: -- fnd_message.set_token('SALES_REP', l_salesrep);
657: -- l_salesrep_text := fnd_message.get;
658:
659:
660: -- l_descriptor_line1 := l_oper_unit_name_text;

Line 657: -- l_salesrep_text := fnd_message.get;

653: -- l_oper_unit_name_text := fnd_message.get;
654:
655: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
656: -- fnd_message.set_token('SALES_REP', l_salesrep);
657: -- l_salesrep_text := fnd_message.get;
658:
659:
660: -- l_descriptor_line1 := l_oper_unit_name_text;
661: -- l_descriptor_line2 := l_salesrep_text;

Line 673: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');

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);
675: wf_engine.SetItemAttrText(itemtype,itemkey, 'VERSION_NUMBER',
676: FND_MESSAGE.GET);
677: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

Line 674: fnd_message.set_token('VERSION_NUMBER', l_version_number);

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);
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);

Line 676: FND_MESSAGE.GET);

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',
680: FND_MESSAGE.GET);

Line 677: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

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',
680: FND_MESSAGE.GET);
681:

Line 678: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);

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',
680: FND_MESSAGE.GET);
681:
682: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',

Line 680: FND_MESSAGE.GET);

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);
684: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',

Line 717: FND_MESSAGE.SET_NAME ('ONT','OE_EM_KEY_INFO');

713: x_org => l_sold_to_org,
714: x_customer_number => l_cust_number);
715: END IF;
716:
717: FND_MESSAGE.SET_NAME ('ONT','OE_EM_KEY_INFO');
718: FND_MESSAGE.SET_TOKEN ('ORDER_SOURCE', l_order_source);
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;

Line 718: FND_MESSAGE.SET_TOKEN ('ORDER_SOURCE', l_order_source);

714: x_customer_number => l_cust_number);
715: END IF;
716:
717: FND_MESSAGE.SET_NAME ('ONT','OE_EM_KEY_INFO');
718: FND_MESSAGE.SET_TOKEN ('ORDER_SOURCE', l_order_source);
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:

Line 719: FND_MESSAGE.SET_TOKEN ('ORIG_SYS_DOCUMENT_REF', l_orig_sys_document_ref);

715: END IF;
716:
717: FND_MESSAGE.SET_NAME ('ONT','OE_EM_KEY_INFO');
718: FND_MESSAGE.SET_TOKEN ('ORDER_SOURCE', l_order_source);
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',

Line 720: FND_MESSAGE.SET_TOKEN ('CUSTOMER', l_sold_to_org);

716:
717: FND_MESSAGE.SET_NAME ('ONT','OE_EM_KEY_INFO');
718: FND_MESSAGE.SET_TOKEN ('ORDER_SOURCE', l_order_source);
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);

Line 721: l_descriptor := FND_MESSAGE.GET;

717: FND_MESSAGE.SET_NAME ('ONT','OE_EM_KEY_INFO');
718: FND_MESSAGE.SET_TOKEN ('ORDER_SOURCE', l_order_source);
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:

Line 763: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');

759: EXCEPTION WHEN OTHERS THEN
760: l_flow_status_code_meaning := NULL;
761: END;
762:
763: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
764: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
765: l_order_type_txt := fnd_message.get;
766: IF l_order_category_code = 'RETURN' THEN
767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');

Line 764: fnd_message.set_token('ORDER_TYPE', l_order_type_name);

760: l_flow_status_code_meaning := NULL;
761: END;
762:
763: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
764: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
765: l_order_type_txt := fnd_message.get;
766: IF l_order_category_code = 'RETURN' THEN
767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 765: l_order_type_txt := fnd_message.get;

761: END;
762:
763: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
764: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
765: l_order_type_txt := fnd_message.get;
766: IF l_order_category_code = 'RETURN' THEN
767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
769: l_header_txt := fnd_message.get;

Line 767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');

763: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
764: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
765: l_order_type_txt := fnd_message.get;
766: IF l_order_category_code = 'RETURN' THEN
767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
769: l_header_txt := fnd_message.get;
770: ELSE
771: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');

Line 768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

764: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
765: l_order_type_txt := fnd_message.get;
766: IF l_order_category_code = 'RETURN' THEN
767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
769: l_header_txt := fnd_message.get;
770: ELSE
771: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
772: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 769: l_header_txt := fnd_message.get;

765: l_order_type_txt := fnd_message.get;
766: IF l_order_category_code = 'RETURN' THEN
767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
769: l_header_txt := fnd_message.get;
770: ELSE
771: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
772: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
773: l_header_txt := fnd_message.get;

Line 771: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');

767: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
769: l_header_txt := fnd_message.get;
770: ELSE
771: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
772: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
773: l_header_txt := fnd_message.get;
774: END IF;
775:

Line 772: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

768: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
769: l_header_txt := fnd_message.get;
770: ELSE
771: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
772: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
773: l_header_txt := fnd_message.get;
774: END IF;
775:
776: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');

Line 773: l_header_txt := fnd_message.get;

769: l_header_txt := fnd_message.get;
770: ELSE
771: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
772: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
773: l_header_txt := fnd_message.get;
774: END IF;
775:
776: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
777: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);

Line 776: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');

772: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
773: l_header_txt := fnd_message.get;
774: END IF;
775:
776: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
777: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
778: -- l_oper_unit_name_text := fnd_message.get;
779:
780: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');

Line 777: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);

773: l_header_txt := fnd_message.get;
774: END IF;
775:
776: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
777: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
778: -- l_oper_unit_name_text := fnd_message.get;
779:
780: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
781: -- fnd_message.set_token('SALES_REP', l_salesrep);

Line 778: -- l_oper_unit_name_text := fnd_message.get;

774: END IF;
775:
776: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
777: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
778: -- l_oper_unit_name_text := fnd_message.get;
779:
780: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
781: -- fnd_message.set_token('SALES_REP', l_salesrep);
782: -- l_salesrep_text := fnd_message.get;

Line 780: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');

776: -- fnd_message.set_name('ONT', 'OE_WF_OPER_UNIT');
777: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
778: -- l_oper_unit_name_text := fnd_message.get;
779:
780: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
781: -- fnd_message.set_token('SALES_REP', l_salesrep);
782: -- l_salesrep_text := fnd_message.get;
783:
784:

Line 781: -- fnd_message.set_token('SALES_REP', l_salesrep);

777: -- fnd_message.set_token('OPER_UNIT', l_oper_unit_name);
778: -- l_oper_unit_name_text := fnd_message.get;
779:
780: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
781: -- fnd_message.set_token('SALES_REP', l_salesrep);
782: -- l_salesrep_text := fnd_message.get;
783:
784:
785: l_descriptor_line2 := substrb(l_order_type_txt || ', ' ||

Line 782: -- l_salesrep_text := fnd_message.get;

778: -- l_oper_unit_name_text := fnd_message.get;
779:
780: -- fnd_message.set_name('ONT', 'OE_WF_SALES_REP');
781: -- fnd_message.set_token('SALES_REP', l_salesrep);
782: -- l_salesrep_text := fnd_message.get;
783:
784:
785: l_descriptor_line2 := substrb(l_order_type_txt || ', ' ||
786: l_header_txt, 1, 240);

Line 793: fnd_message.set_name ('ONT', 'OE_WF_VERSION_NUMBER');

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',
796: FND_MESSAGE.GET);
797: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

Line 794: fnd_message.set_token('VERSION_NUMBER', l_version_number);

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',
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);

Line 796: FND_MESSAGE.GET);

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',
800: FND_MESSAGE.GET);

Line 797: fnd_message.set_name ('ONT', 'OE_WF_FLOW_STATUS');

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',
800: FND_MESSAGE.GET);
801:

Line 798: fnd_message.set_token('FLOW_STATUS', l_flow_status_code_meaning);

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',
800: FND_MESSAGE.GET);
801:
802: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE1',

Line 800: FND_MESSAGE.GET);

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);
804: -- wf_engine.SetItemAttrText(itemtype,itemkey, 'ENTITY_DESCRIPTOR_LINE2',

Line 2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');

2129: Put (p_item_type || l_retry_rec.activity_name(i),l_retry_rec.activity_item_type(i), l_retry_rec.activity_name(i),p_item_type,1, 0, l_activity_display_name);
2130:
2131: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
2132: FND_FILE.PUT_LINE(FND_FILE.LOG, l_retry_rec.user_key(i));
2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));
2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);
2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

Line 2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);

2130:
2131: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
2132: FND_FILE.PUT_LINE(FND_FILE.LOG, l_retry_rec.user_key(i));
2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));
2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);
2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2138:

Line 2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));

2131: FND_FILE.PUT_LINE(FND_FILE.LOG, '');
2132: FND_FILE.PUT_LINE(FND_FILE.LOG, l_retry_rec.user_key(i));
2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));
2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);
2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2138:
2139: ----------------------------------------------------------------------------

Line 2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);

2132: FND_FILE.PUT_LINE(FND_FILE.LOG, l_retry_rec.user_key(i));
2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));
2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);
2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2138:
2139: ----------------------------------------------------------------------------
2140: -- Initialize

Line 2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);

2133: FND_MESSAGE.SET_NAME ('ONT', 'ONT_WF_ITEM_INFO');
2134: FND_MESSAGE.SET_TOKEN ('ITEM_TYPE', p_item_type_display_name);
2135: FND_MESSAGE.SET_TOKEN ('ITEM_KEY', l_retry_rec.item_key(i));
2136: FND_MESSAGE.SET_TOKEN ('ACTIVITY_NAME', l_activity_display_name);
2137: FND_FILE.PUT_LINE(FND_FILE.LOG, FND_MESSAGE.GET);
2138:
2139: ----------------------------------------------------------------------------
2140: -- Initialize
2141: ----------------------------------------------------------------------------