95: RETURN 'EDUCATION_ITEM';
96: syed */
97: ELSE
98:
99: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');
100: OE_BULK_MSG_PUB.ADD;
101: RAISE FND_API.G_EXC_ERROR;
102: END IF;
103:
137: END IF;
138:
139: -- Set Header User Key
140: if p_header_rec.order_category_code(p_index) = 'RETURN' then
141: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
142: else
143: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
144: end if;
145:
139: -- Set Header User Key
140: if p_header_rec.order_category_code(p_index) = 'RETURN' then
141: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
142: else
143: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
144: end if;
145:
146: fnd_message.set_token('ORDER_NUMBER'
147: , to_char(p_header_rec.order_number(p_index)));
142: else
143: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
144: end if;
145:
146: fnd_message.set_token('ORDER_NUMBER'
147: , to_char(p_header_rec.order_number(p_index)));
148: sales_order := substrb(fnd_message.get, 1, 240);
149:
150: -- Create Header Work item
144: end if;
145:
146: fnd_message.set_token('ORDER_NUMBER'
147: , to_char(p_header_rec.order_number(p_index)));
148: sales_order := substrb(fnd_message.get, 1, 240);
149:
150: -- Create Header Work item
151: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR
152: ,to_char(p_header_rec.header_id(p_index))
219: BEGIN
220:
221: -- Set Line User Key
222: if p_line_rec.line_category_code(p_line_index) = 'RETURN' THEN
223: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
224: else
225: fnd_message.set_name('ONT', 'OE_WF_LINE');
226: end if;
227:
221: -- Set Line User Key
222: if p_line_rec.line_category_code(p_line_index) = 'RETURN' THEN
223: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
224: else
225: fnd_message.set_name('ONT', 'OE_WF_LINE');
226: end if;
227:
228: fnd_message.set_token('ORDER_NUMBER',
229: to_char(p_header_rec.order_number(p_header_index)));
224: else
225: fnd_message.set_name('ONT', 'OE_WF_LINE');
226: end if;
227:
228: fnd_message.set_token('ORDER_NUMBER',
229: to_char(p_header_rec.order_number(p_header_index)));
230: fnd_message.set_token('LINE_NUMBER',
231: to_char(p_line_rec.line_number(p_line_index)));
232: fnd_message.set_token('SHIPMENT_NUMBER',
226: end if;
227:
228: fnd_message.set_token('ORDER_NUMBER',
229: to_char(p_header_rec.order_number(p_header_index)));
230: fnd_message.set_token('LINE_NUMBER',
231: to_char(p_line_rec.line_number(p_line_index)));
232: fnd_message.set_token('SHIPMENT_NUMBER',
233: to_char(p_line_rec.shipment_number(p_line_index)));
234: fnd_message.set_token('OPTION_NUMBER',
228: fnd_message.set_token('ORDER_NUMBER',
229: to_char(p_header_rec.order_number(p_header_index)));
230: fnd_message.set_token('LINE_NUMBER',
231: to_char(p_line_rec.line_number(p_line_index)));
232: fnd_message.set_token('SHIPMENT_NUMBER',
233: to_char(p_line_rec.shipment_number(p_line_index)));
234: fnd_message.set_token('OPTION_NUMBER',
235: to_char(p_line_rec.option_number(p_line_index)));
236: fnd_message.set_token('SERVICE_NUMBER',
230: fnd_message.set_token('LINE_NUMBER',
231: to_char(p_line_rec.line_number(p_line_index)));
232: fnd_message.set_token('SHIPMENT_NUMBER',
233: to_char(p_line_rec.shipment_number(p_line_index)));
234: fnd_message.set_token('OPTION_NUMBER',
235: to_char(p_line_rec.option_number(p_line_index)));
236: fnd_message.set_token('SERVICE_NUMBER',
237: to_char(p_line_rec.service_number(p_line_index)));
238:
232: fnd_message.set_token('SHIPMENT_NUMBER',
233: to_char(p_line_rec.shipment_number(p_line_index)));
234: fnd_message.set_token('OPTION_NUMBER',
235: to_char(p_line_rec.option_number(p_line_index)));
236: fnd_message.set_token('SERVICE_NUMBER',
237: to_char(p_line_rec.service_number(p_line_index)));
238:
239: line := substrb(fnd_message.get, 1, 240);
240:
235: to_char(p_line_rec.option_number(p_line_index)));
236: fnd_message.set_token('SERVICE_NUMBER',
237: to_char(p_line_rec.service_number(p_line_index)));
238:
239: line := substrb(fnd_message.get, 1, 240);
240:
241: -- Create Line Work item
242: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN
243: ,to_char(p_line_rec.line_id(p_line_index))
612: l_item_keys(p_line_rec.wf_process_name(j)||':'||l_line_to_key) := l_line_to_key;
613:
614: -- Setting Line User Key
615: if p_line_rec.line_category_code(j) = 'RETURN' THEN
616: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
617: else
618: fnd_message.set_name('ONT', 'OE_WF_LINE');
619: end if;
620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
614: -- Setting Line User Key
615: if p_line_rec.line_category_code(j) = 'RETURN' THEN
616: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
617: else
618: fnd_message.set_name('ONT', 'OE_WF_LINE');
619: end if;
620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(j)));
622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));
616: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
617: else
618: fnd_message.set_name('ONT', 'OE_WF_LINE');
619: end if;
620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(j)));
622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));
623: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(j)));
624: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(j)));
617: else
618: fnd_message.set_name('ONT', 'OE_WF_LINE');
619: end if;
620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(j)));
622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));
623: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(j)));
624: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(j)));
625: l_user_keys(p_line_rec.wf_process_name(j)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
618: fnd_message.set_name('ONT', 'OE_WF_LINE');
619: end if;
620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(j)));
622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));
623: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(j)));
624: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(j)));
625: l_user_keys(p_line_rec.wf_process_name(j)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
626:
619: end if;
620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(j)));
622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));
623: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(j)));
624: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(j)));
625: l_user_keys(p_line_rec.wf_process_name(j)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
626:
627: l_index_Attr_Num := l_index_Attr_Num + 1;
620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(j)));
622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));
623: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(j)));
624: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(j)));
625: l_user_keys(p_line_rec.wf_process_name(j)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
626:
627: l_index_Attr_Num := l_index_Attr_Num + 1;
628: l_itemkeys_4NAttr(l_index_Attr_Num) := to_char(p_line_rec.line_id(j));
621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(j)));
622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));
623: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(j)));
624: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(j)));
625: l_user_keys(p_line_rec.wf_process_name(j)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
626:
627: l_index_Attr_Num := l_index_Attr_Num + 1;
628: l_itemkeys_4NAttr(l_index_Attr_Num) := to_char(p_line_rec.line_id(j));
629: l_aname(l_index_Attr_Num) := 'USER_ID';
681: l_item_keys(p_line_rec.wf_process_name(l_ii_index)||':'||l_line_to_key) := l_line_to_key;
682:
683: -- Setting Line User Key
684: if p_line_rec.line_category_code(j) = 'RETURN' THEN
685: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
686: else
687: fnd_message.set_name('ONT', 'OE_WF_LINE');
688: end if;
689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
683: -- Setting Line User Key
684: if p_line_rec.line_category_code(j) = 'RETURN' THEN
685: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
686: else
687: fnd_message.set_name('ONT', 'OE_WF_LINE');
688: end if;
689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(l_ii_index)));
691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));
685: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
686: else
687: fnd_message.set_name('ONT', 'OE_WF_LINE');
688: end if;
689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(l_ii_index)));
691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));
692: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(l_ii_index)));
693: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(l_ii_index)));
686: else
687: fnd_message.set_name('ONT', 'OE_WF_LINE');
688: end if;
689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(l_ii_index)));
691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));
692: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(l_ii_index)));
693: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(l_ii_index)));
694: l_user_keys(p_line_rec.wf_process_name(l_ii_index)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
687: fnd_message.set_name('ONT', 'OE_WF_LINE');
688: end if;
689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(l_ii_index)));
691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));
692: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(l_ii_index)));
693: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(l_ii_index)));
694: l_user_keys(p_line_rec.wf_process_name(l_ii_index)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
695:
688: end if;
689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(l_ii_index)));
691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));
692: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(l_ii_index)));
693: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(l_ii_index)));
694: l_user_keys(p_line_rec.wf_process_name(l_ii_index)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
695:
696: l_index_Attr_Num := l_index_Attr_Num + 1;
689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));
690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(l_ii_index)));
691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));
692: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(l_ii_index)));
693: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(l_ii_index)));
694: l_user_keys(p_line_rec.wf_process_name(l_ii_index)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
695:
696: l_index_Attr_Num := l_index_Attr_Num + 1;
697: l_itemkeys_4NAttr(l_index_Attr_Num) := to_char(p_line_rec.line_id(l_ii_index));
690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number(l_ii_index)));
691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));
692: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(l_ii_index)));
693: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(l_ii_index)));
694: l_user_keys(p_line_rec.wf_process_name(l_ii_index)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);
695:
696: l_index_Attr_Num := l_index_Attr_Num + 1;
697: l_itemkeys_4NAttr(l_index_Attr_Num) := to_char(p_line_rec.line_id(l_ii_index));
698: l_aname(l_index_Attr_Num) := 'USER_ID';