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 202: fnd_message.set_name ('ONT', 'OE_MISS_FLOW');

198: END IF;
199: EXCEPTION
200: WHEN NO_DATA_FOUND
201: THEN
202: fnd_message.set_name ('ONT', 'OE_MISS_FLOW');
203: oe_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: WHEN OTHERS
206: THEN

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

316: FROM oe_transaction_types_tl t
317: WHERE t.LANGUAGE = USERENV ('LANG')
318: AND t.transaction_type_id = l_order_type_id;
319:
320: fnd_message.set_name ('ONT', 'OE_WF_ORDER_TYPE');
321: fnd_message.set_token ('ORDER_TYPE', l_order_type_name);
322: l_order_type_txt := fnd_message.get;
323:
324: IF l_order_category_code = 'RETURN'

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

317: WHERE t.LANGUAGE = USERENV ('LANG')
318: AND t.transaction_type_id = l_order_type_id;
319:
320: fnd_message.set_name ('ONT', 'OE_WF_ORDER_TYPE');
321: fnd_message.set_token ('ORDER_TYPE', l_order_type_name);
322: l_order_type_txt := fnd_message.get;
323:
324: IF l_order_category_code = 'RETURN'
325: THEN

Line 322: l_order_type_txt := fnd_message.get;

318: AND t.transaction_type_id = l_order_type_id;
319:
320: fnd_message.set_name ('ONT', 'OE_WF_ORDER_TYPE');
321: fnd_message.set_token ('ORDER_TYPE', l_order_type_name);
322: l_order_type_txt := fnd_message.get;
323:
324: IF l_order_category_code = 'RETURN'
325: THEN
326: fnd_message.set_name ('ONT', 'OE_WF_RETURN_ORDER');

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

322: l_order_type_txt := fnd_message.get;
323:
324: IF l_order_category_code = 'RETURN'
325: THEN
326: fnd_message.set_name ('ONT', 'OE_WF_RETURN_ORDER');
327: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
328: l_header_txt := fnd_message.get;
329: ELSE
330: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');

Line 327: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));

323:
324: IF l_order_category_code = 'RETURN'
325: THEN
326: fnd_message.set_name ('ONT', 'OE_WF_RETURN_ORDER');
327: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
328: l_header_txt := fnd_message.get;
329: ELSE
330: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
331: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));

Line 328: l_header_txt := fnd_message.get;

324: IF l_order_category_code = 'RETURN'
325: THEN
326: fnd_message.set_name ('ONT', 'OE_WF_RETURN_ORDER');
327: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
328: l_header_txt := fnd_message.get;
329: ELSE
330: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
331: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
332: l_header_txt := fnd_message.get;

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

326: fnd_message.set_name ('ONT', 'OE_WF_RETURN_ORDER');
327: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
328: l_header_txt := fnd_message.get;
329: ELSE
330: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
331: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
332: l_header_txt := fnd_message.get;
333: END IF;
334:

Line 331: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));

327: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
328: l_header_txt := fnd_message.get;
329: ELSE
330: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
331: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
332: l_header_txt := fnd_message.get;
333: END IF;
334:
335: document := SUBSTRB (l_order_type_txt || ', ' || l_header_txt, 1, 240);

Line 332: l_header_txt := fnd_message.get;

328: l_header_txt := fnd_message.get;
329: ELSE
330: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
331: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
332: l_header_txt := fnd_message.get;
333: END IF;
334:
335: document := SUBSTRB (l_order_type_txt || ', ' || l_header_txt, 1, 240);
336: EXCEPTION

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

412: FROM oe_transaction_types_tl t
413: WHERE t.LANGUAGE = USERENV ('LANG')
414: AND t.transaction_type_id = l_order_type_id;
415:
416: fnd_message.set_name ('ONT', 'OE_WF_ORDER_TYPE');
417: fnd_message.set_token ('ORDER_TYPE', l_order_type_name);
418: l_order_type_txt := fnd_message.get;
419:
420: IF l_order_category_code = 'RETURN'

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

413: WHERE t.LANGUAGE = USERENV ('LANG')
414: AND t.transaction_type_id = l_order_type_id;
415:
416: fnd_message.set_name ('ONT', 'OE_WF_ORDER_TYPE');
417: fnd_message.set_token ('ORDER_TYPE', l_order_type_name);
418: l_order_type_txt := fnd_message.get;
419:
420: IF l_order_category_code = 'RETURN'
421: THEN

Line 418: l_order_type_txt := fnd_message.get;

414: AND t.transaction_type_id = l_order_type_id;
415:
416: fnd_message.set_name ('ONT', 'OE_WF_ORDER_TYPE');
417: fnd_message.set_token ('ORDER_TYPE', l_order_type_name);
418: l_order_type_txt := fnd_message.get;
419:
420: IF l_order_category_code = 'RETURN'
421: THEN
422: fnd_message.set_name ('ONT', 'OE_WF_RETURN_LINE');

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

418: l_order_type_txt := fnd_message.get;
419:
420: IF l_order_category_code = 'RETURN'
421: THEN
422: fnd_message.set_name ('ONT', 'OE_WF_RETURN_LINE');
423: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
424: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
425: fnd_message.set_token ('SHIPMENT_NUMBER',
426: TO_CHAR (l_shipment_number)

Line 423: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));

419:
420: IF l_order_category_code = 'RETURN'
421: THEN
422: fnd_message.set_name ('ONT', 'OE_WF_RETURN_LINE');
423: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
424: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
425: fnd_message.set_token ('SHIPMENT_NUMBER',
426: TO_CHAR (l_shipment_number)
427: );

Line 424: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));

420: IF l_order_category_code = 'RETURN'
421: THEN
422: fnd_message.set_name ('ONT', 'OE_WF_RETURN_LINE');
423: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
424: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
425: fnd_message.set_token ('SHIPMENT_NUMBER',
426: TO_CHAR (l_shipment_number)
427: );
428: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));

Line 425: fnd_message.set_token ('SHIPMENT_NUMBER',

421: THEN
422: fnd_message.set_name ('ONT', 'OE_WF_RETURN_LINE');
423: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
424: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
425: fnd_message.set_token ('SHIPMENT_NUMBER',
426: TO_CHAR (l_shipment_number)
427: );
428: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
429: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));

Line 428: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));

424: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
425: fnd_message.set_token ('SHIPMENT_NUMBER',
426: TO_CHAR (l_shipment_number)
427: );
428: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
429: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
430: l_line_txt := fnd_message.get;
431: ELSE
432: fnd_message.set_name ('ONT', 'OE_WF_LINE');

Line 429: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));

425: fnd_message.set_token ('SHIPMENT_NUMBER',
426: TO_CHAR (l_shipment_number)
427: );
428: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
429: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
430: l_line_txt := fnd_message.get;
431: ELSE
432: fnd_message.set_name ('ONT', 'OE_WF_LINE');
433: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));

Line 430: l_line_txt := fnd_message.get;

426: TO_CHAR (l_shipment_number)
427: );
428: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
429: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
430: l_line_txt := fnd_message.get;
431: ELSE
432: fnd_message.set_name ('ONT', 'OE_WF_LINE');
433: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
434: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));

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

428: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
429: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
430: l_line_txt := fnd_message.get;
431: ELSE
432: fnd_message.set_name ('ONT', 'OE_WF_LINE');
433: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
434: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
435: fnd_message.set_token ('SHIPMENT_NUMBER',
436: TO_CHAR (l_shipment_number)

Line 433: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));

429: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
430: l_line_txt := fnd_message.get;
431: ELSE
432: fnd_message.set_name ('ONT', 'OE_WF_LINE');
433: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
434: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
435: fnd_message.set_token ('SHIPMENT_NUMBER',
436: TO_CHAR (l_shipment_number)
437: );

Line 434: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));

430: l_line_txt := fnd_message.get;
431: ELSE
432: fnd_message.set_name ('ONT', 'OE_WF_LINE');
433: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
434: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
435: fnd_message.set_token ('SHIPMENT_NUMBER',
436: TO_CHAR (l_shipment_number)
437: );
438: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));

Line 435: fnd_message.set_token ('SHIPMENT_NUMBER',

431: ELSE
432: fnd_message.set_name ('ONT', 'OE_WF_LINE');
433: fnd_message.set_token ('ORDER_NUMBER', TO_CHAR (l_order_number));
434: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
435: fnd_message.set_token ('SHIPMENT_NUMBER',
436: TO_CHAR (l_shipment_number)
437: );
438: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
439: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));

Line 438: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));

434: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (l_line_number));
435: fnd_message.set_token ('SHIPMENT_NUMBER',
436: TO_CHAR (l_shipment_number)
437: );
438: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
439: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
440: l_line_txt := fnd_message.get;
441: END IF;
442:

Line 439: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));

435: fnd_message.set_token ('SHIPMENT_NUMBER',
436: TO_CHAR (l_shipment_number)
437: );
438: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
439: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
440: l_line_txt := fnd_message.get;
441: END IF;
442:
443: document := SUBSTRB (l_order_type_txt || ', ' || l_line_txt, 1, 240);

Line 440: l_line_txt := fnd_message.get;

436: TO_CHAR (l_shipment_number)
437: );
438: fnd_message.set_token ('OPTION_NUMBER', TO_CHAR (l_option_number));
439: fnd_message.set_token ('SERVICE_NUMBER', TO_CHAR (l_service_number));
440: l_line_txt := fnd_message.get;
441: END IF;
442:
443: document := SUBSTRB (l_order_type_txt || ', ' || l_line_txt, 1, 240);
444: EXCEPTION

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

459: --
460: BEGIN
461: IF p_header_rec.order_category_code = 'RETURN'
462: THEN
463: fnd_message.set_name ('ONT', 'OE_WF_RETURN_ORDER');
464: ELSE
465: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
466: END IF;
467:

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

461: IF p_header_rec.order_category_code = 'RETURN'
462: THEN
463: fnd_message.set_name ('ONT', 'OE_WF_RETURN_ORDER');
464: ELSE
465: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
466: END IF;
467:
468: fnd_message.set_token ('ORDER_NUMBER',
469: TO_CHAR (p_header_rec.order_number)

Line 468: fnd_message.set_token ('ORDER_NUMBER',

464: ELSE
465: fnd_message.set_name ('ONT', 'OE_WF_SALES_ORDER');
466: END IF;
467:
468: fnd_message.set_token ('ORDER_NUMBER',
469: TO_CHAR (p_header_rec.order_number)
470: );
471: EXCEPTION
472: WHEN OTHERS

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

492: oe_order_cache.load_order_header (l_header_id);
493:
494: IF oe_order_cache.g_header_rec.order_category_code = 'RETURN'
495: THEN
496: fnd_message.set_name ('ONT', 'OE_WF_RETURN_LINE');
497: ELSE
498: fnd_message.set_name ('ONT', 'OE_WF_LINE');
499: END IF;
500:

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

494: IF oe_order_cache.g_header_rec.order_category_code = 'RETURN'
495: THEN
496: fnd_message.set_name ('ONT', 'OE_WF_RETURN_LINE');
497: ELSE
498: fnd_message.set_name ('ONT', 'OE_WF_LINE');
499: END IF;
500:
501: fnd_message.set_token ('ORDER_NUMBER',
502: TO_CHAR (oe_order_cache.g_header_rec.order_number)

Line 501: fnd_message.set_token ('ORDER_NUMBER',

497: ELSE
498: fnd_message.set_name ('ONT', 'OE_WF_LINE');
499: END IF;
500:
501: fnd_message.set_token ('ORDER_NUMBER',
502: TO_CHAR (oe_order_cache.g_header_rec.order_number)
503: );
504: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (p_line_rec.line_number));
505: fnd_message.set_token ('SHIPMENT_NUMBER',

Line 504: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (p_line_rec.line_number));

500:
501: fnd_message.set_token ('ORDER_NUMBER',
502: TO_CHAR (oe_order_cache.g_header_rec.order_number)
503: );
504: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (p_line_rec.line_number));
505: fnd_message.set_token ('SHIPMENT_NUMBER',
506: TO_CHAR (p_line_rec.shipment_number)
507: );
508: fnd_message.set_token ('OPTION_NUMBER',

Line 505: fnd_message.set_token ('SHIPMENT_NUMBER',

501: fnd_message.set_token ('ORDER_NUMBER',
502: TO_CHAR (oe_order_cache.g_header_rec.order_number)
503: );
504: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (p_line_rec.line_number));
505: fnd_message.set_token ('SHIPMENT_NUMBER',
506: TO_CHAR (p_line_rec.shipment_number)
507: );
508: fnd_message.set_token ('OPTION_NUMBER',
509: TO_CHAR (p_line_rec.option_number)

Line 508: fnd_message.set_token ('OPTION_NUMBER',

504: fnd_message.set_token ('LINE_NUMBER', TO_CHAR (p_line_rec.line_number));
505: fnd_message.set_token ('SHIPMENT_NUMBER',
506: TO_CHAR (p_line_rec.shipment_number)
507: );
508: fnd_message.set_token ('OPTION_NUMBER',
509: TO_CHAR (p_line_rec.option_number)
510: );
511: fnd_message.set_token ('SERVICE_NUMBER',
512: TO_CHAR (p_line_rec.service_number)

Line 511: fnd_message.set_token ('SERVICE_NUMBER',

507: );
508: fnd_message.set_token ('OPTION_NUMBER',
509: TO_CHAR (p_line_rec.option_number)
510: );
511: fnd_message.set_token ('SERVICE_NUMBER',
512: TO_CHAR (p_line_rec.service_number)
513: );
514: EXCEPTION
515: WHEN OTHERS

Line 576: fnd_message.set_name ('ONT', 'OE_WF_SPLIT_FORK_ERR');

572: WHEN OTHERS
573: THEN
574: IF wf_core.error_name = 'WFENG_NOFORK_ONERROR'
575: THEN
576: fnd_message.set_name ('ONT', 'OE_WF_SPLIT_FORK_ERR');
577: oe_msg_pub.ADD;
578: END IF;
579:
580: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)

Line 678: sales_order := SUBSTRB (fnd_message.get, 1, 240);

674: get_processname (p_itemtype => oe_globals.g_wfi_hdr,
675: p_itemkey => p_header_rec.header_id
676: );
677: set_header_user_key (p_header_rec);
678: sales_order := SUBSTRB (fnd_message.get, 1, 240);
679:
680: SELECT user_name
681: INTO l_owner_role
682: FROM fnd_user

Line 929: line := SUBSTRB (fnd_message.get, 1, 240);

925: p_wfasgn_item_type => l_item_type,
926: p_line_rec => p_line_rec
927: );
928: set_line_user_key (p_line_rec);
929: line := SUBSTRB (fnd_message.get, 1, 240);
930:
931: SELECT user_name
932: INTO l_owner_role
933: FROM fnd_user

Line 1012: line := SUBSTRB (fnd_message.get, 1, 240);

1008: oe_debug_pub.ADD ('IN CREATE_LINEFORK');
1009: END IF;
1010:
1011: set_line_user_key (p_line_rec);
1012: line := SUBSTRB (fnd_message.get, 1, 240);
1013: wf_engine.createforkprocess ('OEOL',
1014: p_line_rec.split_from_line_id,
1015: p_line_rec.line_id,
1016: TRUE,

Line 1031: fnd_message.set_name ('ONT', 'OE_WF_SPLIT_FORK_ERR');

1027: WHEN OTHERS
1028: THEN
1029: IF wf_core.error_name = 'WFENG_NOFORK_ONERROR'
1030: THEN
1031: fnd_message.set_name ('ONT', 'OE_WF_SPLIT_FORK_ERR');
1032: oe_msg_pub.ADD;
1033: END IF;
1034:
1035: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)

Line 1135: fnd_message.set_name ('ONT', 'OE_INVALID_WF_ITEM_TYPE');

1131: ELSIF (p_line_rec.item_type_code = oe_globals.g_item_service)
1132: THEN
1133: RETURN 'SERVICE';
1134: ELSE
1135: fnd_message.set_name ('ONT', 'OE_INVALID_WF_ITEM_TYPE');
1136: oe_msg_pub.ADD;
1137: RAISE fnd_api.g_exc_error;
1138: END IF;
1139: EXCEPTION

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

2700: x_return_status := fnd_api.g_ret_sts_error;
2701:
2702: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_error)
2703: THEN
2704: fnd_message.set_name ('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
2705: oe_msg_pub.ADD;
2706: END IF;
2707:
2708: IF p_line_id IS NOT NULL

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

3354: x_return_status := fnd_api.g_ret_sts_error;
3355:
3356: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_error)
3357: THEN
3358: fnd_message.set_name ('ONT', 'OE_LOCK_ROW_ALREADY_LOCKED');
3359: oe_msg_pub.ADD;
3360: END IF;
3361:
3362: IF l_header_id IS NOT NULL

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

3444: END IF;
3445:
3446: IF p_sales_document_type_code = 'O'
3447: THEN
3448: fnd_message.set_name ('ONT', 'OE_NTF_QUOTE');
3449: ELSIF p_sales_document_type_code = 'B'
3450: THEN
3451: fnd_message.set_name ('ONT', 'OE_NTF_BSA');
3452: END IF;

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

3447: THEN
3448: fnd_message.set_name ('ONT', 'OE_NTF_QUOTE');
3449: ELSIF p_sales_document_type_code = 'B'
3450: THEN
3451: fnd_message.set_name ('ONT', 'OE_NTF_BSA');
3452: END IF;
3453:
3454: user_key_string :=
3455: SUBSTRB (fnd_message.get, 1, 240)

Line 3455: SUBSTRB (fnd_message.get, 1, 240)

3451: fnd_message.set_name ('ONT', 'OE_NTF_BSA');
3452: END IF;
3453:
3454: user_key_string :=
3455: SUBSTRB (fnd_message.get, 1, 240)
3456: || ' '
3457: || TO_CHAR (p_transaction_number);
3458:
3459: SELECT user_name

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

3623:
3624: -- set user key
3625: IF p_sales_document_type_code = 'O'
3626: THEN
3627: fnd_message.set_name ('ONT', 'OE_NTF_QUOTE');
3628: ELSIF p_sales_document_type_code = 'B'
3629: THEN
3630: fnd_message.set_name ('ONT', 'OE_NTF_BSA');
3631: END IF;

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

3626: THEN
3627: fnd_message.set_name ('ONT', 'OE_NTF_QUOTE');
3628: ELSIF p_sales_document_type_code = 'B'
3629: THEN
3630: fnd_message.set_name ('ONT', 'OE_NTF_BSA');
3631: END IF;
3632:
3633: l_sales_document_type := SUBSTRB (fnd_message.get, 1, 240);
3634: user_key_string :=

Line 3633: l_sales_document_type := SUBSTRB (fnd_message.get, 1, 240);

3629: THEN
3630: fnd_message.set_name ('ONT', 'OE_NTF_BSA');
3631: END IF;
3632:
3633: l_sales_document_type := SUBSTRB (fnd_message.get, 1, 240);
3634: user_key_string :=
3635: l_sales_document_type || ' ' || TO_CHAR (p_transaction_number);
3636:
3637: SELECT user_name

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

3738: l_user_key VARCHAR2 (240);
3739: BEGIN
3740: IF p_sales_document_type_code = 'O'
3741: THEN
3742: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
3743: fnd_message.set_token ('QUOTE_NUMBER',
3744: TO_CHAR (p_transaction_number)
3745: );
3746: ELSIF p_sales_document_type_code = 'B'

Line 3743: fnd_message.set_token ('QUOTE_NUMBER',

3739: BEGIN
3740: IF p_sales_document_type_code = 'O'
3741: THEN
3742: fnd_message.set_name ('ONT', 'OE_WF_QUOTE_ORDER');
3743: fnd_message.set_token ('QUOTE_NUMBER',
3744: TO_CHAR (p_transaction_number)
3745: );
3746: ELSIF p_sales_document_type_code = 'B'
3747: THEN

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

3744: TO_CHAR (p_transaction_number)
3745: );
3746: ELSIF p_sales_document_type_code = 'B'
3747: THEN
3748: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
3749: fnd_message.set_token ('BLANKET_NUMBER',
3750: TO_CHAR (p_transaction_number)
3751: );
3752: END IF;

Line 3749: fnd_message.set_token ('BLANKET_NUMBER',

3745: );
3746: ELSIF p_sales_document_type_code = 'B'
3747: THEN
3748: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
3749: fnd_message.set_token ('BLANKET_NUMBER',
3750: TO_CHAR (p_transaction_number)
3751: );
3752: END IF;
3753:

Line 3754: l_user_key := SUBSTRB (fnd_message.get, 1, 240);

3750: TO_CHAR (p_transaction_number)
3751: );
3752: END IF;
3753:
3754: l_user_key := SUBSTRB (fnd_message.get, 1, 240);
3755: wf_engine.setitemuserkey (oe_globals.g_wfi_ngo, p_header_id, l_user_key);
3756: EXCEPTION
3757: WHEN OTHERS
3758: THEN

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

3769: )
3770: IS
3771: l_user_key VARCHAR2 (240);
3772: BEGIN
3773: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
3774: fnd_message.set_token ('BLANKET_NUMBER',
3775: TO_CHAR (p_transaction_number));
3776: l_user_key := SUBSTRB (fnd_message.get, 1, 240);
3777: wf_engine.setitemuserkey (oe_globals.g_wfi_bkt, p_header_id,

Line 3774: fnd_message.set_token ('BLANKET_NUMBER',

3770: IS
3771: l_user_key VARCHAR2 (240);
3772: BEGIN
3773: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
3774: fnd_message.set_token ('BLANKET_NUMBER',
3775: TO_CHAR (p_transaction_number));
3776: l_user_key := SUBSTRB (fnd_message.get, 1, 240);
3777: wf_engine.setitemuserkey (oe_globals.g_wfi_bkt, p_header_id,
3778: l_user_key);

Line 3776: l_user_key := SUBSTRB (fnd_message.get, 1, 240);

3772: BEGIN
3773: fnd_message.set_name ('ONT', 'OE_WF_BLANKET_ORDER');
3774: fnd_message.set_token ('BLANKET_NUMBER',
3775: TO_CHAR (p_transaction_number));
3776: l_user_key := SUBSTRB (fnd_message.get, 1, 240);
3777: wf_engine.setitemuserkey (oe_globals.g_wfi_bkt, p_header_id,
3778: l_user_key);
3779: EXCEPTION
3780: WHEN OTHERS

Line 3942: -- fnd messages

3938: nl VARCHAR2 (1) := '';
3939: i NUMBER := 0;
3940: -- New Line char.
3941: nlchar VARCHAR2 (2) := fnd_global.NEWLINE;
3942: -- fnd messages
3943: l_msg_bsa VARCHAR2 (240);
3944: l_msg_creation_date VARCHAR2 (240);
3945: l_msg_activation_date VARCHAR2 (240);
3946: l_msg_expiration_date VARCHAR2 (240);

Line 3959: -- set fnd message titles for tables

3955: l_msg_blanket_number VARCHAR2 (240);
3956: l_org_id number ; --16084377 ame bsa
3957: BEGIN
3958: l_transaction_id := TO_NUMBER (p_item_key);
3959: -- set fnd message titles for tables
3960: l_msg_bsa := fnd_message.get_string ('ONT', 'OE_NTF_BSA');
3961: l_msg_creation_date :=
3962: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
3963: l_msg_activation_date :=

Line 3960: l_msg_bsa := fnd_message.get_string ('ONT', 'OE_NTF_BSA');

3956: l_org_id number ; --16084377 ame bsa
3957: BEGIN
3958: l_transaction_id := TO_NUMBER (p_item_key);
3959: -- set fnd message titles for tables
3960: l_msg_bsa := fnd_message.get_string ('ONT', 'OE_NTF_BSA');
3961: l_msg_creation_date :=
3962: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
3963: l_msg_activation_date :=
3964: fnd_message.get_string ('ONT', 'OE_NTF_ACTIVATION_DATE');

Line 3962: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');

3958: l_transaction_id := TO_NUMBER (p_item_key);
3959: -- set fnd message titles for tables
3960: l_msg_bsa := fnd_message.get_string ('ONT', 'OE_NTF_BSA');
3961: l_msg_creation_date :=
3962: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
3963: l_msg_activation_date :=
3964: fnd_message.get_string ('ONT', 'OE_NTF_ACTIVATION_DATE');
3965: l_msg_expiration_date :=
3966: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');

Line 3964: fnd_message.get_string ('ONT', 'OE_NTF_ACTIVATION_DATE');

3960: l_msg_bsa := fnd_message.get_string ('ONT', 'OE_NTF_BSA');
3961: l_msg_creation_date :=
3962: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
3963: l_msg_activation_date :=
3964: fnd_message.get_string ('ONT', 'OE_NTF_ACTIVATION_DATE');
3965: l_msg_expiration_date :=
3966: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
3967: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
3968: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');

Line 3966: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');

3962: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
3963: l_msg_activation_date :=
3964: fnd_message.get_string ('ONT', 'OE_NTF_ACTIVATION_DATE');
3965: l_msg_expiration_date :=
3966: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
3967: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
3968: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
3969: l_msg_credit_holds :=
3970: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');

Line 3967: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');

3963: l_msg_activation_date :=
3964: fnd_message.get_string ('ONT', 'OE_NTF_ACTIVATION_DATE');
3965: l_msg_expiration_date :=
3966: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
3967: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
3968: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
3969: l_msg_credit_holds :=
3970: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
3971: l_msg_payment_term :=

Line 3968: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');

3964: fnd_message.get_string ('ONT', 'OE_NTF_ACTIVATION_DATE');
3965: l_msg_expiration_date :=
3966: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
3967: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
3968: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
3969: l_msg_credit_holds :=
3970: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
3971: l_msg_payment_term :=
3972: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');

Line 3970: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');

3966: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
3967: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
3968: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
3969: l_msg_credit_holds :=
3970: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
3971: l_msg_payment_term :=
3972: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
3973: l_msg_min_amt_agreed :=
3974: fnd_message.get_string ('ONT', 'OE_NTF_MIN_AMT_AGREED');

Line 3972: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');

3968: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
3969: l_msg_credit_holds :=
3970: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
3971: l_msg_payment_term :=
3972: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
3973: l_msg_min_amt_agreed :=
3974: fnd_message.get_string ('ONT', 'OE_NTF_MIN_AMT_AGREED');
3975: l_msg_max_amt_agreed :=
3976: fnd_message.get_string ('ONT', 'OE_NTF_MAX_AMT_AGREED');

Line 3974: fnd_message.get_string ('ONT', 'OE_NTF_MIN_AMT_AGREED');

3970: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
3971: l_msg_payment_term :=
3972: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
3973: l_msg_min_amt_agreed :=
3974: fnd_message.get_string ('ONT', 'OE_NTF_MIN_AMT_AGREED');
3975: l_msg_max_amt_agreed :=
3976: fnd_message.get_string ('ONT', 'OE_NTF_MAX_AMT_AGREED');
3977:
3978: -- set values

Line 3976: fnd_message.get_string ('ONT', 'OE_NTF_MAX_AMT_AGREED');

3972: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
3973: l_msg_min_amt_agreed :=
3974: fnd_message.get_string ('ONT', 'OE_NTF_MIN_AMT_AGREED');
3975: l_msg_max_amt_agreed :=
3976: fnd_message.get_string ('ONT', 'OE_NTF_MAX_AMT_AGREED');
3977:
3978: -- set values
3979: SELECT /* MOAC_SQL_CHANGE */ headers.order_number, headers.creation_date,
3980: shipto.LOCATION NAME, invoiceto.LOCATION NAME, terms.NAME,

Line 4047: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');

4043: IF l_wf_header_attr <> 'Y'
4044: THEN
4045: -- set fnd msg title
4046: l_msg_blanket_number :=
4047: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');
4048: l_msg_salesperson :=
4049: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4050: l_msg_customer :=
4051: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');

Line 4049: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');

4045: -- set fnd msg title
4046: l_msg_blanket_number :=
4047: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');
4048: l_msg_salesperson :=
4049: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4050: l_msg_customer :=
4051: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4052: l_document :=
4053: l_document

Line 4051: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');

4047: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');
4048: l_msg_salesperson :=
4049: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4050: l_msg_customer :=
4051: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4052: l_document :=
4053: l_document
4054: || ''
4055: || l_msg_blanket_number

Line 4215: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');

4211: l_sold_to :=
4212: wf_engine.getitemattrtext (p_item_type, p_item_key, 'SOLD_TO');
4213: -- set fnd msg title
4214: l_msg_blanket_number :=
4215: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');
4216: l_msg_salesperson :=
4217: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4218: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4219: l_document :=

Line 4217: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');

4213: -- set fnd msg title
4214: l_msg_blanket_number :=
4215: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');
4216: l_msg_salesperson :=
4217: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4218: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4219: l_document :=
4220: l_document
4221: || l_msg_blanket_number

Line 4218: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');

4214: l_msg_blanket_number :=
4215: fnd_message.get_string ('ONT', 'OE_NTF_BLANKET_NUMBER');
4216: l_msg_salesperson :=
4217: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4218: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4219: l_document :=
4220: l_document
4221: || l_msg_blanket_number
4222: || ': '

Line 4400: -- set fnd message titles for tables

4396: l_prec_inited :=
4397: oe_order_util.get_precision (p_header_id => l_transaction_id);
4398: END IF;
4399:
4400: -- set fnd message titles for tables
4401: l_msg_quote := fnd_message.get_string ('ONT', 'OE_NTF_QUOTE');
4402: l_msg_creation_date :=
4403: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
4404: l_msg_margin_percent :=

Line 4401: l_msg_quote := fnd_message.get_string ('ONT', 'OE_NTF_QUOTE');

4397: oe_order_util.get_precision (p_header_id => l_transaction_id);
4398: END IF;
4399:
4400: -- set fnd message titles for tables
4401: l_msg_quote := fnd_message.get_string ('ONT', 'OE_NTF_QUOTE');
4402: l_msg_creation_date :=
4403: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
4404: l_msg_margin_percent :=
4405: fnd_message.get_string ('ONT', 'OE_NTF_MARGIN_PERCENT');

Line 4403: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');

4399:
4400: -- set fnd message titles for tables
4401: l_msg_quote := fnd_message.get_string ('ONT', 'OE_NTF_QUOTE');
4402: l_msg_creation_date :=
4403: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
4404: l_msg_margin_percent :=
4405: fnd_message.get_string ('ONT', 'OE_NTF_MARGIN_PERCENT');
4406: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
4407: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');

Line 4405: fnd_message.get_string ('ONT', 'OE_NTF_MARGIN_PERCENT');

4401: l_msg_quote := fnd_message.get_string ('ONT', 'OE_NTF_QUOTE');
4402: l_msg_creation_date :=
4403: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
4404: l_msg_margin_percent :=
4405: fnd_message.get_string ('ONT', 'OE_NTF_MARGIN_PERCENT');
4406: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
4407: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
4408: l_msg_credit_holds :=
4409: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');

Line 4406: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');

4402: l_msg_creation_date :=
4403: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
4404: l_msg_margin_percent :=
4405: fnd_message.get_string ('ONT', 'OE_NTF_MARGIN_PERCENT');
4406: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
4407: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
4408: l_msg_credit_holds :=
4409: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
4410: l_msg_payment_term :=

Line 4407: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');

4403: fnd_message.get_string ('ONT', 'OE_NTF_CREATION_DATE');
4404: l_msg_margin_percent :=
4405: fnd_message.get_string ('ONT', 'OE_NTF_MARGIN_PERCENT');
4406: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
4407: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
4408: l_msg_credit_holds :=
4409: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
4410: l_msg_payment_term :=
4411: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');

Line 4409: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');

4405: fnd_message.get_string ('ONT', 'OE_NTF_MARGIN_PERCENT');
4406: l_msg_ship_to := fnd_message.get_string ('ONT', 'OE_NTF_SHIP_TO');
4407: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
4408: l_msg_credit_holds :=
4409: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
4410: l_msg_payment_term :=
4411: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
4412: l_msg_total := fnd_message.get_string ('ONT', 'OE_NTF_TOTAL');
4413: l_msg_line_details :=

Line 4411: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');

4407: l_msg_invoice_to := fnd_message.get_string ('ONT', 'OE_NTF_INVOICE_TO');
4408: l_msg_credit_holds :=
4409: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
4410: l_msg_payment_term :=
4411: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
4412: l_msg_total := fnd_message.get_string ('ONT', 'OE_NTF_TOTAL');
4413: l_msg_line_details :=
4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');
4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');

Line 4412: l_msg_total := fnd_message.get_string ('ONT', 'OE_NTF_TOTAL');

4408: l_msg_credit_holds :=
4409: fnd_message.get_string ('ONT', 'OE_NTF_CREDIT_HOLDS');
4410: l_msg_payment_term :=
4411: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
4412: l_msg_total := fnd_message.get_string ('ONT', 'OE_NTF_TOTAL');
4413: l_msg_line_details :=
4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');
4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');
4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');

Line 4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');

4410: l_msg_payment_term :=
4411: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
4412: l_msg_total := fnd_message.get_string ('ONT', 'OE_NTF_TOTAL');
4413: l_msg_line_details :=
4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');
4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');
4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');
4417: l_msg_quantity := fnd_message.get_string ('ONT', 'OE_NTF_QUANTITY');
4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');

Line 4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');

4411: fnd_message.get_string ('ONT', 'OE_NTF_PAYMENT_TERM');
4412: l_msg_total := fnd_message.get_string ('ONT', 'OE_NTF_TOTAL');
4413: l_msg_line_details :=
4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');
4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');
4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');
4417: l_msg_quantity := fnd_message.get_string ('ONT', 'OE_NTF_QUANTITY');
4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');
4419: l_msg_unit_selling_price :=

Line 4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');

4412: l_msg_total := fnd_message.get_string ('ONT', 'OE_NTF_TOTAL');
4413: l_msg_line_details :=
4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');
4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');
4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');
4417: l_msg_quantity := fnd_message.get_string ('ONT', 'OE_NTF_QUANTITY');
4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');
4419: l_msg_unit_selling_price :=
4420: fnd_message.get_string ('ONT', 'OE_NTF_UNIT_SELLING_PRICE');

Line 4417: l_msg_quantity := fnd_message.get_string ('ONT', 'OE_NTF_QUANTITY');

4413: l_msg_line_details :=
4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');
4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');
4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');
4417: l_msg_quantity := fnd_message.get_string ('ONT', 'OE_NTF_QUANTITY');
4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');
4419: l_msg_unit_selling_price :=
4420: fnd_message.get_string ('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
4421: l_msg_line_number :=

Line 4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');

4414: fnd_message.get_string ('ONT', 'OE_NTF_LINE_DETAILS');
4415: l_msg_item := fnd_message.get_string ('ONT', 'OE_NTF_ITEM');
4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');
4417: l_msg_quantity := fnd_message.get_string ('ONT', 'OE_NTF_QUANTITY');
4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');
4419: l_msg_unit_selling_price :=
4420: fnd_message.get_string ('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
4421: l_msg_line_number :=
4422: fnd_message.get_string ('ONT', 'OE_NTF_LINE_NUMBER');

Line 4420: fnd_message.get_string ('ONT', 'OE_NTF_UNIT_SELLING_PRICE');

4416: l_msg_uom := fnd_message.get_string ('ONT', 'OE_NTF_UOM');
4417: l_msg_quantity := fnd_message.get_string ('ONT', 'OE_NTF_QUANTITY');
4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');
4419: l_msg_unit_selling_price :=
4420: fnd_message.get_string ('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
4421: l_msg_line_number :=
4422: fnd_message.get_string ('ONT', 'OE_NTF_LINE_NUMBER');
4423: l_msg_quote_details :=
4424: fnd_message.get_string ('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');

Line 4422: fnd_message.get_string ('ONT', 'OE_NTF_LINE_NUMBER');

4418: l_msg_currency := fnd_message.get_string ('ONT', 'OE_NTF_CURRENCY');
4419: l_msg_unit_selling_price :=
4420: fnd_message.get_string ('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
4421: l_msg_line_number :=
4422: fnd_message.get_string ('ONT', 'OE_NTF_LINE_NUMBER');
4423: l_msg_quote_details :=
4424: fnd_message.get_string ('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
4425: l_msg_first_five_lines :=
4426: fnd_message.get_string ('ONT', 'OE_NTF_FIRST_FIVE_LINES');

Line 4424: fnd_message.get_string ('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');

4420: fnd_message.get_string ('ONT', 'OE_NTF_UNIT_SELLING_PRICE');
4421: l_msg_line_number :=
4422: fnd_message.get_string ('ONT', 'OE_NTF_LINE_NUMBER');
4423: l_msg_quote_details :=
4424: fnd_message.get_string ('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
4425: l_msg_first_five_lines :=
4426: fnd_message.get_string ('ONT', 'OE_NTF_FIRST_FIVE_LINES');
4427: -------------------------
4428:

Line 4426: fnd_message.get_string ('ONT', 'OE_NTF_FIRST_FIVE_LINES');

4422: fnd_message.get_string ('ONT', 'OE_NTF_LINE_NUMBER');
4423: l_msg_quote_details :=
4424: fnd_message.get_string ('ONT', 'OE_NTF_ADL_QUOTE_DETAILS');
4425: l_msg_first_five_lines :=
4426: fnd_message.get_string ('ONT', 'OE_NTF_FIRST_FIVE_LINES');
4427: -------------------------
4428:
4429: -- set value
4430: -- Build the header attribute values

Line 4497: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');

4493: IF l_wf_header_attr <> 'Y'
4494: THEN
4495: -- set FND msg title
4496: l_msg_quote_number :=
4497: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');
4498: l_msg_salesperson :=
4499: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4500: l_msg_customer :=
4501: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');

Line 4499: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');

4495: -- set FND msg title
4496: l_msg_quote_number :=
4497: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');
4498: l_msg_salesperson :=
4499: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4500: l_msg_customer :=
4501: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4502: l_msg_expiration_date :=
4503: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');

Line 4501: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');

4497: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');
4498: l_msg_salesperson :=
4499: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4500: l_msg_customer :=
4501: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4502: l_msg_expiration_date :=
4503: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
4504: l_document :=
4505: l_document

Line 4503: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');

4499: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4500: l_msg_customer :=
4501: fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4502: l_msg_expiration_date :=
4503: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
4504: l_document :=
4505: l_document
4506: || ''
4507: || l_msg_quote_number

Line 4821: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');

4817: ELSIF p_display_type = 'text/plain'
4818: THEN
4819: -- set FND msg title
4820: l_msg_quote_number :=
4821: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');
4822: l_msg_salesperson :=
4823: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4824: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4825: l_msg_expiration_date :=

Line 4823: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');

4819: -- set FND msg title
4820: l_msg_quote_number :=
4821: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');
4822: l_msg_salesperson :=
4823: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4824: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4825: l_msg_expiration_date :=
4826: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
4827: l_transaction_number :=

Line 4824: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');

4820: l_msg_quote_number :=
4821: fnd_message.get_string ('ONT', 'OE_NTF_QUOTE_NUMBER');
4822: l_msg_salesperson :=
4823: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4824: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4825: l_msg_expiration_date :=
4826: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
4827: l_transaction_number :=
4828: wf_engine.getitemattrnumber (p_item_type,

Line 4826: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');

4822: l_msg_salesperson :=
4823: fnd_message.get_string ('ONT', 'OE_NTF_SALESPERSON');
4824: l_msg_customer := fnd_message.get_string ('ONT', 'OE_NTF_CUSTOMER');
4825: l_msg_expiration_date :=
4826: fnd_message.get_string ('ONT', 'OE_NTF_EXPIRATION_DATE');
4827: l_transaction_number :=
4828: wf_engine.getitemattrnumber (p_item_type,
4829: p_item_key,
4830: 'TRANSACTION_NUMBER'

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

5034:
5035: IF c_eligible_activity%NOTFOUND
5036: THEN
5037: oe_debug_pub.ADD ('c_eligible_activity NOT FOUND');
5038: fnd_message.set_name ('ONT', 'OE_NO_ELIGIBLE_ACTIVITIES');
5039: oe_msg_pub.ADD;
5040: ELSE
5041: CLOSE c_eligible_activity;
5042:

Line 5101: fnd_message.set_name ('ONT', 'OE_ORDER_BOOK_DEFERRED');

5097: THEN
5098: oe_debug_pub.ADD ('BOOKING IS DEFERRED');
5099: END IF;
5100:
5101: fnd_message.set_name ('ONT', 'OE_ORDER_BOOK_DEFERRED');
5102: oe_msg_pub.ADD;
5103:
5104: CLOSE book_deferred;
5105: ELSE

Line 5115: fnd_message.set_name ('ONT', 'OE_QUOTE_NOT_BOOKED');

5111: AND enabled_flag = 'Y'
5112: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)
5113: AND NVL (end_date_active, SYSDATE);
5114:
5115: fnd_message.set_name ('ONT', 'OE_QUOTE_NOT_BOOKED');
5116: fnd_message.set_token ('FLOW_STATUS', l_flow_status);
5117: oe_msg_pub.ADD;
5118: END IF; -- book_deferred%FOUND
5119: ELSE -- book_eligible%NOTFOUND

Line 5116: fnd_message.set_token ('FLOW_STATUS', l_flow_status);

5112: AND SYSDATE BETWEEN NVL (start_date_active, SYSDATE)
5113: AND NVL (end_date_active, SYSDATE);
5114:
5115: fnd_message.set_name ('ONT', 'OE_QUOTE_NOT_BOOKED');
5116: fnd_message.set_token ('FLOW_STATUS', l_flow_status);
5117: oe_msg_pub.ADD;
5118: END IF; -- book_deferred%FOUND
5119: ELSE -- book_eligible%NOTFOUND
5120: IF l_debug_level > 0