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