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_ORDER_WF_UTIL dependencies on FND_MESSAGE

Line 167: fnd_message.set_name('ONT','OE_MISS_FLOW');

163:
164: EXCEPTION
165:
166: WHEN NO_DATA_FOUND THEN
167: fnd_message.set_name('ONT','OE_MISS_FLOW');
168: OE_MSG_PUB.Add;
169: RAISE FND_API.G_EXC_ERROR;
170:
171: WHEN OTHERS THEN

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

221: FROM OE_TRANSACTION_TYPES_TL T
222: WHERE T.LANGUAGE = userenv('LANG')
223: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
224:
225: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
226: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
227: l_order_type_txt := fnd_message.get;
228:
229: IF l_order_category_code = 'RETURN' THEN

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

222: WHERE T.LANGUAGE = userenv('LANG')
223: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
224:
225: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
226: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
227: l_order_type_txt := fnd_message.get;
228:
229: IF l_order_category_code = 'RETURN' THEN
230: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');

Line 227: l_order_type_txt := fnd_message.get;

223: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
224:
225: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
226: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
227: l_order_type_txt := fnd_message.get;
228:
229: IF l_order_category_code = 'RETURN' THEN
230: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
231: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

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

226: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
227: l_order_type_txt := fnd_message.get;
228:
229: IF l_order_category_code = 'RETURN' THEN
230: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
231: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
232: l_header_txt := fnd_message.get;
233: ELSE
234: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');

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

227: l_order_type_txt := fnd_message.get;
228:
229: IF l_order_category_code = 'RETURN' THEN
230: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
231: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
232: l_header_txt := fnd_message.get;
233: ELSE
234: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
235: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 232: l_header_txt := fnd_message.get;

228:
229: IF l_order_category_code = 'RETURN' THEN
230: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
231: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
232: l_header_txt := fnd_message.get;
233: ELSE
234: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
235: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
236: l_header_txt := fnd_message.get;

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

230: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
231: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
232: l_header_txt := fnd_message.get;
233: ELSE
234: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
235: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
236: l_header_txt := fnd_message.get;
237: END IF;
238: document := substrb(l_order_type_txt || ', ' || l_header_txt, 1, 240);

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

231: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
232: l_header_txt := fnd_message.get;
233: ELSE
234: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
235: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
236: l_header_txt := fnd_message.get;
237: END IF;
238: document := substrb(l_order_type_txt || ', ' || l_header_txt, 1, 240);
239:

Line 236: l_header_txt := fnd_message.get;

232: l_header_txt := fnd_message.get;
233: ELSE
234: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
235: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
236: l_header_txt := fnd_message.get;
237: END IF;
238: document := substrb(l_order_type_txt || ', ' || l_header_txt, 1, 240);
239:
240:

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

302: FROM OE_TRANSACTION_TYPES_TL T
303: WHERE T.LANGUAGE = userenv('LANG')
304: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
305:
306: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
307: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
308: l_order_type_txt := fnd_message.get;
309:
310: IF l_order_category_code = 'RETURN' THEN

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

303: WHERE T.LANGUAGE = userenv('LANG')
304: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
305:
306: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
307: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
308: l_order_type_txt := fnd_message.get;
309:
310: IF l_order_category_code = 'RETURN' THEN
311: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');

Line 308: l_order_type_txt := fnd_message.get;

304: AND T.TRANSACTION_TYPE_ID = l_order_type_id;
305:
306: fnd_message.set_name('ONT', 'OE_WF_ORDER_TYPE');
307: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
308: l_order_type_txt := fnd_message.get;
309:
310: IF l_order_category_code = 'RETURN' THEN
311: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
312: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

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

307: fnd_message.set_token('ORDER_TYPE', l_order_type_name);
308: l_order_type_txt := fnd_message.get;
309:
310: IF l_order_category_code = 'RETURN' THEN
311: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
312: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));

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

308: l_order_type_txt := fnd_message.get;
309:
310: IF l_order_category_code = 'RETURN' THEN
311: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
312: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));

Line 313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));

309:
310: IF l_order_category_code = 'RETURN' THEN
311: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
312: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
317: l_line_txt := fnd_message.get;

Line 314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));

310: IF l_order_category_code = 'RETURN' THEN
311: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
312: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
317: l_line_txt := fnd_message.get;
318: ELSE

Line 315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));

311: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
312: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
317: l_line_txt := fnd_message.get;
318: ELSE
319: fnd_message.set_name('ONT', 'OE_WF_LINE');

Line 316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));

312: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
317: l_line_txt := fnd_message.get;
318: ELSE
319: fnd_message.set_name('ONT', 'OE_WF_LINE');
320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));

Line 317: l_line_txt := fnd_message.get;

313: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
314: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
317: l_line_txt := fnd_message.get;
318: ELSE
319: fnd_message.set_name('ONT', 'OE_WF_LINE');
320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));

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

315: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
317: l_line_txt := fnd_message.get;
318: ELSE
319: fnd_message.set_name('ONT', 'OE_WF_LINE');
320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));

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

316: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
317: l_line_txt := fnd_message.get;
318: ELSE
319: fnd_message.set_name('ONT', 'OE_WF_LINE');
320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
324: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));

Line 321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));

317: l_line_txt := fnd_message.get;
318: ELSE
319: fnd_message.set_name('ONT', 'OE_WF_LINE');
320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
324: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
325: l_line_txt := fnd_message.get;

Line 322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));

318: ELSE
319: fnd_message.set_name('ONT', 'OE_WF_LINE');
320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
324: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
325: l_line_txt := fnd_message.get;
326: END IF;

Line 323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));

319: fnd_message.set_name('ONT', 'OE_WF_LINE');
320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
324: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
325: l_line_txt := fnd_message.get;
326: END IF;
327:

Line 324: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));

320: fnd_message.set_token('ORDER_NUMBER', to_char(l_order_number));
321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
324: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
325: l_line_txt := fnd_message.get;
326: END IF;
327:
328: document := substrb(l_order_type_txt || ', ' || l_line_txt, 1, 240);

Line 325: l_line_txt := fnd_message.get;

321: fnd_message.set_token('LINE_NUMBER', to_char(l_line_number));
322: fnd_message.set_token('SHIPMENT_NUMBER', to_char(l_shipment_number));
323: fnd_message.set_token('OPTION_NUMBER', to_char(l_option_number));
324: fnd_message.set_token('SERVICE_NUMBER', to_char(l_service_number));
325: l_line_txt := fnd_message.get;
326: END IF;
327:
328: document := substrb(l_order_type_txt || ', ' || l_line_txt, 1, 240);
329:

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

348: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
349: --
350: BEGIN
351: if p_header_rec.order_category_code = 'RETURN' then
352: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
353: else
354: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
355: end if;
356:

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

350: BEGIN
351: if p_header_rec.order_category_code = 'RETURN' then
352: fnd_message.set_name('ONT', 'OE_WF_RETURN_ORDER');
353: else
354: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
355: end if;
356:
357: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number));
358:

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

353: else
354: fnd_message.set_name('ONT', 'OE_WF_SALES_ORDER');
355: end if;
356:
357: fnd_message.set_token('ORDER_NUMBER', to_char(p_header_rec.order_number));
358:
359: EXCEPTION
360: WHEN OTHERS THEN
361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

384:
385: OE_Order_Cache.Load_Order_Header(l_header_id);
386:
387: if OE_Order_Cache.g_header_rec.order_category_code = 'RETURN' THEN
388: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
389: else
390: fnd_message.set_name('ONT', 'OE_WF_LINE');
391: end if;
392:

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

386:
387: if OE_Order_Cache.g_header_rec.order_category_code = 'RETURN' THEN
388: fnd_message.set_name('ONT', 'OE_WF_RETURN_LINE');
389: else
390: fnd_message.set_name('ONT', 'OE_WF_LINE');
391: end if;
392:
393: fnd_message.set_token('ORDER_NUMBER',
394: to_char(OE_Order_Cache.g_header_rec.order_number));

Line 393: fnd_message.set_token('ORDER_NUMBER',

389: else
390: fnd_message.set_name('ONT', 'OE_WF_LINE');
391: end if;
392:
393: fnd_message.set_token('ORDER_NUMBER',
394: to_char(OE_Order_Cache.g_header_rec.order_number));
395: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number));
396: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number));
397: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number));

Line 395: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number));

391: end if;
392:
393: fnd_message.set_token('ORDER_NUMBER',
394: to_char(OE_Order_Cache.g_header_rec.order_number));
395: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number));
396: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number));
397: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number));
398: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number));
399:

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

392:
393: fnd_message.set_token('ORDER_NUMBER',
394: to_char(OE_Order_Cache.g_header_rec.order_number));
395: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number));
396: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number));
397: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number));
398: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number));
399:
400:

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

393: fnd_message.set_token('ORDER_NUMBER',
394: to_char(OE_Order_Cache.g_header_rec.order_number));
395: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number));
396: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number));
397: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number));
398: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number));
399:
400:
401: EXCEPTION

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

394: to_char(OE_Order_Cache.g_header_rec.order_number));
395: fnd_message.set_token('LINE_NUMBER', to_char(p_line_rec.line_number));
396: fnd_message.set_token('SHIPMENT_NUMBER', to_char(p_line_rec.shipment_number));
397: fnd_message.set_token('OPTION_NUMBER', to_char(p_line_rec.option_number));
398: fnd_message.set_token('SERVICE_NUMBER', to_char(p_line_rec.service_number));
399:
400:
401: EXCEPTION
402: WHEN OTHERS THEN

Line 475: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');

471:
472:
473: WHEN OTHERS THEN
474: IF wf_core.error_name = 'WFENG_NOFORK_ONERROR' THEN
475: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');
476: OE_MSG_PUB.ADD;
477: END IF;
478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
479: THEN

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

581: END IF;
582: l_hdr_process_name := Get_ProcessName(p_itemtype => OE_GLOBALS.G_WFI_HDR, p_itemkey => p_header_rec.header_id);
583:
584: Set_Header_User_Key(p_header_rec);
585: sales_order := substrb(fnd_message.get, 1, 240);
586:
587: SELECT user_name
588: INTO l_owner_role
589: FROM FND_USER

Line 812: line := substrb(fnd_message.get, 1, 240);

808: END IF;
809: l_line_process_name := Get_ProcessName(p_itemtype => OE_GLOBALS.G_WFI_LIN, p_itemkey => p_Line_rec.line_id, p_wfasgn_item_type => l_item_type, p_line_rec => p_line_rec);
810:
811: Set_Line_User_Key(p_line_rec);
812: line := substrb(fnd_message.get, 1, 240);
813:
814: SELECT user_name
815: INTO l_owner_role
816: FROM FND_USER

Line 902: line := substrb(fnd_message.get, 1, 240);

898: oe_debug_pub.add( 'IN CREATE_LINEFORK' ) ;
899: END IF;
900:
901: Set_Line_User_Key(p_line_rec);
902: line := substrb(fnd_message.get, 1, 240);
903:
904: WF_ENGINE.CreateForkProcess('OEOL', p_line_rec.split_from_line_id,
905: p_line_rec.line_id,
906: true,

Line 920: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');

916:
917: EXCEPTION
918: WHEN OTHERS THEN
919: IF wf_core.error_name = 'WFENG_NOFORK_ONERROR' THEN
920: FND_MESSAGE.SET_NAME('ONT','OE_WF_SPLIT_FORK_ERR');
921: OE_MSG_PUB.ADD;
922: END IF;
923:
924: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

1023: RETURN 'SERVICE';
1024:
1025: ELSE
1026:
1027: FND_MESSAGE.SET_NAME('ONT','OE_INVALID_WF_ITEM_TYPE');
1028: OE_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031:

Line 2137: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');

2133: END IF;
2134: x_return_status := FND_API.G_RET_STS_ERROR;
2135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2136: THEN
2137: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2138: OE_MSG_PUB.Add;
2139: END IF;
2140: IF p_line_id IS NOT NULL THEN
2141: OE_MSG_PUB.Reset_Msg_Context('LINE');

Line 2612: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');

2608: END IF;
2609: x_return_status := FND_API.G_RET_STS_ERROR;
2610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2611: THEN
2612: fnd_message.set_name('ONT','OE_LOCK_ROW_ALREADY_LOCKED');
2613: OE_MSG_PUB.Add;
2614: END IF;
2615: IF l_header_id IS NOT NULL THEN
2616: OE_MSG_PUB.Reset_Msg_Context('HEADER');

Line 2692: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

2688: oe_debug_pub.add( 'process_name: ' || l_valid_process, 4);
2689: END IF;
2690:
2691: IF p_sales_document_type_code = 'O' THEN
2692: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
2693: ELSIF p_sales_document_type_code = 'B' THEN
2694: fnd_message.set_name('ONT', 'OE_NTF_BSA');
2695: END IF;
2696:

Line 2694: fnd_message.set_name('ONT', 'OE_NTF_BSA');

2690:
2691: IF p_sales_document_type_code = 'O' THEN
2692: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
2693: ELSIF p_sales_document_type_code = 'B' THEN
2694: fnd_message.set_name('ONT', 'OE_NTF_BSA');
2695: END IF;
2696:
2697: user_key_string := substrb(fnd_message.get, 1, 240) || ' ' || to_char(p_transaction_number);
2698:

Line 2697: user_key_string := substrb(fnd_message.get, 1, 240) || ' ' || to_char(p_transaction_number);

2693: ELSIF p_sales_document_type_code = 'B' THEN
2694: fnd_message.set_name('ONT', 'OE_NTF_BSA');
2695: END IF;
2696:
2697: user_key_string := substrb(fnd_message.get, 1, 240) || ' ' || to_char(p_transaction_number);
2698:
2699: SELECT user_name
2700: INTO l_owner_role
2701: FROM FND_USER

Line 2857: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');

2853: END IF;
2854:
2855: -- set user key
2856: IF p_sales_document_type_code = 'O' THEN
2857: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
2858: ELSIF p_sales_document_type_code = 'B' THEN
2859: fnd_message.set_name('ONT', 'OE_NTF_BSA');
2860: END IF;
2861:

Line 2859: fnd_message.set_name('ONT', 'OE_NTF_BSA');

2855: -- set user key
2856: IF p_sales_document_type_code = 'O' THEN
2857: fnd_message.set_name('ONT', 'OE_NTF_QUOTE');
2858: ELSIF p_sales_document_type_code = 'B' THEN
2859: fnd_message.set_name('ONT', 'OE_NTF_BSA');
2860: END IF;
2861:
2862: l_sales_document_type := substrb(fnd_message.get, 1, 240);
2863: user_key_string := l_sales_document_type || ' ' || to_char(p_transaction_number);

Line 2862: l_sales_document_type := substrb(fnd_message.get, 1, 240);

2858: ELSIF p_sales_document_type_code = 'B' THEN
2859: fnd_message.set_name('ONT', 'OE_NTF_BSA');
2860: END IF;
2861:
2862: l_sales_document_type := substrb(fnd_message.get, 1, 240);
2863: user_key_string := l_sales_document_type || ' ' || to_char(p_transaction_number);
2864:
2865: SELECT user_name
2866: INTO l_owner_role

Line 2970: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');

2966:
2967: BEGIN
2968:
2969: IF p_sales_document_type_code = 'O' THEN
2970: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
2971: fnd_message.set_token('QUOTE_NUMBER', to_char(p_transaction_number));
2972: ELSIF p_sales_document_type_code = 'B' THEN
2973: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));

Line 2971: fnd_message.set_token('QUOTE_NUMBER', to_char(p_transaction_number));

2967: BEGIN
2968:
2969: IF p_sales_document_type_code = 'O' THEN
2970: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
2971: fnd_message.set_token('QUOTE_NUMBER', to_char(p_transaction_number));
2972: ELSIF p_sales_document_type_code = 'B' THEN
2973: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
2975: END IF;

Line 2973: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');

2969: IF p_sales_document_type_code = 'O' THEN
2970: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
2971: fnd_message.set_token('QUOTE_NUMBER', to_char(p_transaction_number));
2972: ELSIF p_sales_document_type_code = 'B' THEN
2973: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
2975: END IF;
2976:
2977: l_user_key := substrb(fnd_message.get, 1, 240);

Line 2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));

2970: fnd_message.set_name('ONT', 'OE_WF_QUOTE_ORDER');
2971: fnd_message.set_token('QUOTE_NUMBER', to_char(p_transaction_number));
2972: ELSIF p_sales_document_type_code = 'B' THEN
2973: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
2975: END IF;
2976:
2977: l_user_key := substrb(fnd_message.get, 1, 240);
2978: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_NGO

Line 2977: l_user_key := substrb(fnd_message.get, 1, 240);

2973: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
2974: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
2975: END IF;
2976:
2977: l_user_key := substrb(fnd_message.get, 1, 240);
2978: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_NGO
2979: , p_header_id
2980: , l_user_key);
2981: EXCEPTION

Line 3001: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');

2997: l_user_key VARCHAR2(240);
2998:
2999: BEGIN
3000:
3001: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
3002: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
3003:
3004: l_user_key := substrb(fnd_message.get, 1, 240);
3005: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_BKT

Line 3002: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));

2998:
2999: BEGIN
3000:
3001: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
3002: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
3003:
3004: l_user_key := substrb(fnd_message.get, 1, 240);
3005: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_BKT
3006: , p_header_id

Line 3004: l_user_key := substrb(fnd_message.get, 1, 240);

3000:
3001: fnd_message.set_name('ONT', 'OE_WF_BLANKET_ORDER');
3002: fnd_message.set_token('BLANKET_NUMBER', to_char(p_transaction_number));
3003:
3004: l_user_key := substrb(fnd_message.get, 1, 240);
3005: wf_engine.SetItemUserKey( OE_GLOBALS.G_WFI_BKT
3006: , p_header_id
3007: , l_user_key);
3008: EXCEPTION

Line 3145: -- fnd messages

3141:
3142: -- New Line char.
3143: NLCHAR VARCHAR2(2) := FND_GLOBAL.Newline;
3144:
3145: -- fnd messages
3146: l_msg_BSA VARCHAR2(240);
3147: l_msg_creation_date VARCHAR2(240);
3148: l_msg_activation_date VARCHAR2(240);
3149: l_msg_expiration_date VARCHAR2(240);

Line 3164: -- set fnd message titles for tables

3160: BEGIN
3161:
3162: l_transaction_id := to_number(p_item_key);
3163:
3164: -- set fnd message titles for tables
3165: l_msg_BSA := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BSA');
3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');

Line 3165: l_msg_BSA := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BSA');

3161:
3162: l_transaction_id := to_number(p_item_key);
3163:
3164: -- set fnd message titles for tables
3165: l_msg_BSA := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BSA');
3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');

Line 3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');

3162: l_transaction_id := to_number(p_item_key);
3163:
3164: -- set fnd message titles for tables
3165: l_msg_BSA := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BSA');
3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');

Line 3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');

3163:
3164: -- set fnd message titles for tables
3165: l_msg_BSA := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BSA');
3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');

Line 3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');

3164: -- set fnd message titles for tables
3165: l_msg_BSA := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BSA');
3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');

Line 3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');

3165: l_msg_BSA := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BSA');
3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3173: l_msg_min_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MIN_AMT_AGREED');

Line 3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');

3166: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3173: l_msg_min_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MIN_AMT_AGREED');
3174: l_msg_max_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MAX_AMT_AGREED');

Line 3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');

3167: l_msg_activation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ACTIVATION_DATE');
3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3173: l_msg_min_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MIN_AMT_AGREED');
3174: l_msg_max_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MAX_AMT_AGREED');
3175:

Line 3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');

3168: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3173: l_msg_min_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MIN_AMT_AGREED');
3174: l_msg_max_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MAX_AMT_AGREED');
3175:
3176:

Line 3173: l_msg_min_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MIN_AMT_AGREED');

3169: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3173: l_msg_min_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MIN_AMT_AGREED');
3174: l_msg_max_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MAX_AMT_AGREED');
3175:
3176:
3177: -- set values

Line 3174: l_msg_max_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MAX_AMT_AGREED');

3170: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3171: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3172: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3173: l_msg_min_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MIN_AMT_AGREED');
3174: l_msg_max_amt_agreed := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MAX_AMT_AGREED');
3175:
3176:
3177: -- set values
3178: select /* MOAC_SQL_CHANGE */ headers.order_number, headers.CREATION_DATE,

Line 3234: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');

3230:
3231: IF l_wf_header_attr <> 'Y' THEN
3232:
3233: -- set fnd msg title
3234: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');
3235: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3236: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3237:
3238: l_document := l_document || '' || l_msg_blanket_number || '';

Line 3235: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');

3231: IF l_wf_header_attr <> 'Y' THEN
3232:
3233: -- set fnd msg title
3234: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');
3235: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3236: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3237:
3238: l_document := l_document || '' || l_msg_blanket_number || '';
3239: l_document := l_document || '' || l_msg_customer || '';

Line 3236: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');

3232:
3233: -- set fnd msg title
3234: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');
3235: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3236: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3237:
3238: l_document := l_document || '' || l_msg_blanket_number || '';
3239: l_document := l_document || '' || l_msg_customer || '';
3240: l_document := l_document || '' || l_msg_salesperson || '';

Line 3324: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');

3320: p_item_key,
3321: 'SOLD_TO');
3322:
3323: -- set fnd msg title
3324: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');
3325: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3326: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3327:
3328:

Line 3325: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');

3321: 'SOLD_TO');
3322:
3323: -- set fnd msg title
3324: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');
3325: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3326: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3327:
3328:
3329: l_document := l_document || l_msg_blanket_number || ': ' || TO_CHAR(l_transaction_number) || NLCHAR;

Line 3326: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');

3322:
3323: -- set fnd msg title
3324: l_msg_blanket_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_BLANKET_NUMBER');
3325: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3326: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3327:
3328:
3329: l_document := l_document || l_msg_blanket_number || ': ' || TO_CHAR(l_transaction_number) || NLCHAR;
3330: l_document := l_document || l_msg_salesperson || ': ' || l_salesrep || NLCHAR;

Line 3471: -- set fnd message titles for tables

3467: IF ( nvl(Oe_Order_Util.G_Precision,0) = 0 ) THEN
3468: l_prec_inited := Oe_Order_Util.Get_Precision (p_header_id => l_transaction_id);
3469: END IF;
3470:
3471: -- set fnd message titles for tables
3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');
3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');

Line 3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');

3468: l_prec_inited := Oe_Order_Util.Get_Precision (p_header_id => l_transaction_id);
3469: END IF;
3470:
3471: -- set fnd message titles for tables
3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');
3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');

Line 3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');

3469: END IF;
3470:
3471: -- set fnd message titles for tables
3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');
3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');

Line 3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');

3470:
3471: -- set fnd message titles for tables
3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');
3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');

Line 3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');

3471: -- set fnd message titles for tables
3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');
3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');

Line 3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');

3472: l_msg_quote := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE');
3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');

Line 3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');

3473: l_msg_creation_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREATION_DATE');
3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');

Line 3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');

3474: l_msg_margin_percent := FND_MESSAGE.Get_String('ONT', 'OE_NTF_MARGIN_PERCENT');
3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');

Line 3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');

3475: l_msg_ship_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SHIP_TO');
3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');

Line 3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');

3476: l_msg_invoice_to := FND_MESSAGE.Get_String('ONT', 'OE_NTF_INVOICE_TO');
3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');

Line 3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');

3477: l_msg_credit_holds := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CREDIT_HOLDS');
3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');

Line 3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');

3478: l_msg_payment_term := FND_MESSAGE.Get_String('ONT', 'OE_NTF_PAYMENT_TERM');
3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');

Line 3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');

3479: l_msg_total := FND_MESSAGE.Get_String('ONT', 'OE_NTF_TOTAL');
3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');
3487: l_msg_quote_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');

Line 3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');

3480: l_msg_line_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_DETAILS');
3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');
3487: l_msg_quote_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
3488: l_msg_first_five_lines := FND_MESSAGE.Get_String('ONT', 'OE_NTF_FIRST_FIVE_LINES');

Line 3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');

3481: l_msg_item := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ITEM');
3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');
3487: l_msg_quote_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
3488: l_msg_first_five_lines := FND_MESSAGE.Get_String('ONT', 'OE_NTF_FIRST_FIVE_LINES');
3489: -------------------------

Line 3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');

3482: l_msg_uom := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UOM');
3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');
3487: l_msg_quote_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
3488: l_msg_first_five_lines := FND_MESSAGE.Get_String('ONT', 'OE_NTF_FIRST_FIVE_LINES');
3489: -------------------------
3490:

Line 3487: l_msg_quote_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');

3483: l_msg_quantity := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUANTITY');
3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');
3487: l_msg_quote_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
3488: l_msg_first_five_lines := FND_MESSAGE.Get_String('ONT', 'OE_NTF_FIRST_FIVE_LINES');
3489: -------------------------
3490:
3491: -- set value

Line 3488: l_msg_first_five_lines := FND_MESSAGE.Get_String('ONT', 'OE_NTF_FIRST_FIVE_LINES');

3484: l_msg_currency := FND_MESSAGE.Get_STring('ONT', 'OE_NTF_CURRENCY');
3485: l_msg_unit_selling_price := FND_MESSAGE.Get_String('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
3486: l_msg_line_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_LINE_NUMBER');
3487: l_msg_quote_details := FND_MESSAGE.Get_String('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
3488: l_msg_first_five_lines := FND_MESSAGE.Get_String('ONT', 'OE_NTF_FIRST_FIVE_LINES');
3489: -------------------------
3490:
3491: -- set value
3492: -- Build the header attribute values

Line 3544: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');

3540:
3541: IF l_wf_header_attr <> 'Y' THEN
3542:
3543: -- set FND msg title
3544: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3545: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3546: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3547: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3548:

Line 3545: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');

3541: IF l_wf_header_attr <> 'Y' THEN
3542:
3543: -- set FND msg title
3544: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3545: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3546: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3547: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3548:
3549: l_document := l_document || '' || l_msg_quote_number || '';

Line 3546: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');

3542:
3543: -- set FND msg title
3544: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3545: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3546: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3547: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3548:
3549: l_document := l_document || '' || l_msg_quote_number || '';
3550: l_document := l_document || '' || l_msg_customer || '';

Line 3547: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');

3543: -- set FND msg title
3544: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3545: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3546: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3547: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3548:
3549: l_document := l_document || '' || l_msg_quote_number || '';
3550: l_document := l_document || '' || l_msg_customer || '';
3551: l_document := l_document || '' || l_msg_expiration_date || '';

Line 3694: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');

3690: -- DISPLAY_TYPE = TEXT --
3691: ELSIF p_display_type = 'text/plain' THEN
3692:
3693: -- set FND msg title
3694: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3695: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3696: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3697: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3698:

Line 3695: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');

3691: ELSIF p_display_type = 'text/plain' THEN
3692:
3693: -- set FND msg title
3694: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3695: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3696: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3697: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3698:
3699: l_transaction_number := wf_engine.GetItemAttrNumber(

Line 3696: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');

3692:
3693: -- set FND msg title
3694: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3695: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3696: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3697: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3698:
3699: l_transaction_number := wf_engine.GetItemAttrNumber(
3700: p_item_type,

Line 3697: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');

3693: -- set FND msg title
3694: l_msg_quote_number := FND_MESSAGE.Get_String('ONT', 'OE_NTF_QUOTE_NUMBER');
3695: l_msg_salesperson := FND_MESSAGE.Get_String('ONT', 'OE_NTF_SALESPERSON');
3696: l_msg_customer := FND_MESSAGE.Get_String('ONT', 'OE_NTF_CUSTOMER');
3697: l_msg_expiration_date := FND_MESSAGE.Get_String('ONT', 'OE_NTF_EXPIRATION_DATE');
3698:
3699: l_transaction_number := wf_engine.GetItemAttrNumber(
3700: p_item_type,
3701: p_item_key,

Line 3880: fnd_message.set_name('ONT','OE_NO_ELIGIBLE_ACTIVITIES');

3876: open c_eligible_activity;
3877: FETCH c_eligible_activity into l_activity;
3878: IF c_eligible_activity%NOTFOUND THEN
3879: oe_debug_pub.add('c_eligible_activity NOT FOUND');
3880: fnd_message.set_name('ONT','OE_NO_ELIGIBLE_ACTIVITIES');
3881: OE_MSG_PUB.ADD;
3882: ELSE
3883: close c_eligible_activity;
3884: IF l_debug_level > 0 THEN

Line 3914: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_DEFERRED');

3910: IF (book_deferred%FOUND) THEN
3911: IF l_debug_level > 0 THEN
3912: oe_debug_pub.add('BOOKING IS DEFERRED' );
3913: END IF;
3914: FND_MESSAGE.SET_NAME('ONT','OE_ORDER_BOOK_DEFERRED');
3915: OE_MSG_PUB.ADD;
3916: CLOSE book_deferred;
3917: ELSE
3918: select MEANING

Line 3927: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_NOT_BOOKED');

3923: AND enabled_flag = 'Y'
3924: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
3925: AND NVL(END_DATE_ACTIVE, SYSDATE);
3926:
3927: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_NOT_BOOKED');
3928: FND_MESSAGE.SET_TOKEN('FLOW_STATUS', l_flow_status);
3929: OE_MSG_PUB.ADD;
3930: END IF; -- book_deferred%FOUND
3931: ELSE -- book_eligible%NOTFOUND

Line 3928: FND_MESSAGE.SET_TOKEN('FLOW_STATUS', l_flow_status);

3924: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
3925: AND NVL(END_DATE_ACTIVE, SYSDATE);
3926:
3927: FND_MESSAGE.SET_NAME('ONT','OE_QUOTE_NOT_BOOKED');
3928: FND_MESSAGE.SET_TOKEN('FLOW_STATUS', l_flow_status);
3929: OE_MSG_PUB.ADD;
3930: END IF; -- book_deferred%FOUND
3931: ELSE -- book_eligible%NOTFOUND
3932: IF l_debug_level > 0 THEN