94: RETURN 'EDUCATION_ITEM';
95: syed */
96: ELSE
97:
98: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');
99: OE_BULK_MSG_PUB.ADD;
100: RAISE FND_API.G_EXC_ERROR;
101: END IF;
102:
136: END IF;
137:
138: -- Set Header User Key
139: if p_header_rec.order_category_code(p_index) = 'RETURN' then
140: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
141: else
142: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
143: end if;
144:
138: -- Set Header User Key
139: if p_header_rec.order_category_code(p_index) = 'RETURN' then
140: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
141: else
142: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
143: end if;
144:
145: fnd_message.set_token('ORDER_NUMBER'
146: , to_char(p_header_rec.order_number(p_index)));
141: else
142: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
143: end if;
144:
145: fnd_message.set_token('ORDER_NUMBER'
146: , to_char(p_header_rec.order_number(p_index)));
147: sales_order := substrb(fnd_message.get, 1, 240);
148:
149: -- Create Header Work item
143: end if;
144:
145: fnd_message.set_token('ORDER_NUMBER'
146: , to_char(p_header_rec.order_number(p_index)));
147: sales_order := substrb(fnd_message.get, 1, 240);
148:
149: -- Create Header Work item
150: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_HDR
151: ,to_char(p_header_rec.header_id(p_index))
211: BEGIN
212:
213: -- Set Line User Key
214: if p_line_rec.line_category_code(p_line_index) = 'RETURN' THEN
215: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
216: else
217: fnd_message.set_name('ONT', 'OE_WF_LINE');
218: end if;
219:
213: -- Set Line User Key
214: if p_line_rec.line_category_code(p_line_index) = 'RETURN' THEN
215: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
216: else
217: fnd_message.set_name('ONT', 'OE_WF_LINE');
218: end if;
219:
220: fnd_message.set_token('ORDER_NUMBER',
221: to_char(p_header_rec.order_number(p_header_index)));
216: else
217: fnd_message.set_name('ONT', 'OE_WF_LINE');
218: end if;
219:
220: fnd_message.set_token('ORDER_NUMBER',
221: to_char(p_header_rec.order_number(p_header_index)));
222: fnd_message.set_token('LINE_NUMBER',
223: to_char(p_line_rec.line_number(p_line_index)));
224: fnd_message.set_token('SHIPMENT_NUMBER',
218: end if;
219:
220: fnd_message.set_token('ORDER_NUMBER',
221: to_char(p_header_rec.order_number(p_header_index)));
222: fnd_message.set_token('LINE_NUMBER',
223: to_char(p_line_rec.line_number(p_line_index)));
224: fnd_message.set_token('SHIPMENT_NUMBER',
225: to_char(p_line_rec.shipment_number(p_line_index)));
226: fnd_message.set_token('OPTION_NUMBER',
220: fnd_message.set_token('ORDER_NUMBER',
221: to_char(p_header_rec.order_number(p_header_index)));
222: fnd_message.set_token('LINE_NUMBER',
223: to_char(p_line_rec.line_number(p_line_index)));
224: fnd_message.set_token('SHIPMENT_NUMBER',
225: to_char(p_line_rec.shipment_number(p_line_index)));
226: fnd_message.set_token('OPTION_NUMBER',
227: to_char(p_line_rec.option_number(p_line_index)));
228: fnd_message.set_token('SERVICE_NUMBER',
222: fnd_message.set_token('LINE_NUMBER',
223: to_char(p_line_rec.line_number(p_line_index)));
224: fnd_message.set_token('SHIPMENT_NUMBER',
225: to_char(p_line_rec.shipment_number(p_line_index)));
226: fnd_message.set_token('OPTION_NUMBER',
227: to_char(p_line_rec.option_number(p_line_index)));
228: fnd_message.set_token('SERVICE_NUMBER',
229: to_char(p_line_rec.service_number(p_line_index)));
230:
224: fnd_message.set_token('SHIPMENT_NUMBER',
225: to_char(p_line_rec.shipment_number(p_line_index)));
226: fnd_message.set_token('OPTION_NUMBER',
227: to_char(p_line_rec.option_number(p_line_index)));
228: fnd_message.set_token('SERVICE_NUMBER',
229: to_char(p_line_rec.service_number(p_line_index)));
230:
231: line := substrb(fnd_message.get, 1, 240);
232:
227: to_char(p_line_rec.option_number(p_line_index)));
228: fnd_message.set_token('SERVICE_NUMBER',
229: to_char(p_line_rec.service_number(p_line_index)));
230:
231: line := substrb(fnd_message.get, 1, 240);
232:
233: -- Create Line Work item
234: WF_ENGINE.CreateProcess(OE_Globals.G_WFI_LIN
235: ,to_char(p_line_rec.line_id(p_line_index))