DBA Data[Home] [Help]

APPS.OE_BULK_WF_UTIL dependencies on FND_MESSAGE

Line 99: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');

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:

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

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:

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

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

Line 146: fnd_message.set_token('ORDER_NUMBER'

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

Line 148: sales_order := substrb(fnd_message.get, 1, 240);

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

Line 223: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');

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:

Line 225: fnd_message.set_name('ONT', 'OE_WF_LINE');

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

Line 228: fnd_message.set_token('ORDER_NUMBER',

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

Line 230: fnd_message.set_token('LINE_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',

Line 232: fnd_message.set_token('SHIPMENT_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',

Line 234: fnd_message.set_token('OPTION_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:

Line 236: fnd_message.set_token('SERVICE_NUMBER',

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:

Line 239: line := substrb(fnd_message.get, 1, 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))

Line 616: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');

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

Line 618: fnd_message.set_name('ONT', 'OE_WF_LINE');

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

Line 620: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));

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

Line 621: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_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);

Line 622: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(j)));

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:

Line 623: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(j)));

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;

Line 624: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(j)));

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

Line 625: l_user_keys(p_line_rec.wf_process_name(j)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);

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

Line 685: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');

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

Line 687: fnd_message.set_name('ONT', 'OE_WF_LINE');

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

Line 689: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number(i)));

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

Line 690: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_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);

Line 691: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number(l_ii_index)));

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:

Line 692: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number(l_ii_index)));

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;

Line 693: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number(l_ii_index)));

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

Line 694: l_user_keys(p_line_rec.wf_process_name(l_ii_index)||':'||l_line_to_key) := substrb(fnd_message.get, 1, 240);

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