[Home] [Help]
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
207: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
203: oe_msg_pub.ADD;
204: RAISE fnd_api.g_exc_error;
205: WHEN OTHERS
206: THEN
207: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
208: THEN
209: oe_msg_pub.add_exc_msg (g_pkg_name, 'GET_ProcessName');
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
205: WHEN OTHERS
206: THEN
207: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
208: THEN
209: oe_msg_pub.add_exc_msg (g_pkg_name, 'GET_ProcessName');
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
212: END get_processname;
213:
335: document := SUBSTRB (l_order_type_txt || ', ' || l_header_txt, 1, 240);
336: EXCEPTION
337: WHEN OTHERS
338: THEN
339: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
340: THEN
341: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Header_Descriptor');
342: RAISE fnd_api.g_exc_unexpected_error;
343: END IF;
337: WHEN OTHERS
338: THEN
339: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
340: THEN
341: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Header_Descriptor');
342: RAISE fnd_api.g_exc_unexpected_error;
343: END IF;
344: END set_header_descriptor;
345:
443: document := SUBSTRB (l_order_type_txt || ', ' || l_line_txt, 1, 240);
444: EXCEPTION
445: WHEN OTHERS
446: THEN
447: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
448: THEN
449: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Line_Descriptor');
450: RAISE fnd_api.g_exc_unexpected_error;
451: END IF;
445: WHEN OTHERS
446: THEN
447: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
448: THEN
449: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Line_Descriptor');
450: RAISE fnd_api.g_exc_unexpected_error;
451: END IF;
452: END set_line_descriptor;
453:
470: );
471: EXCEPTION
472: WHEN OTHERS
473: THEN
474: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
475: THEN
476: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Header_User_Key');
477: RAISE fnd_api.g_exc_unexpected_error;
478: END IF;
472: WHEN OTHERS
473: THEN
474: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
475: THEN
476: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Header_User_Key');
477: RAISE fnd_api.g_exc_unexpected_error;
478: END IF;
479: END set_header_user_key;
480:
513: );
514: EXCEPTION
515: WHEN OTHERS
516: THEN
517: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
518: THEN
519: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Line_User_Key');
520: RAISE fnd_api.g_exc_unexpected_error;
521: END IF;
515: WHEN OTHERS
516: THEN
517: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
518: THEN
519: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Line_User_Key');
520: RAISE fnd_api.g_exc_unexpected_error;
521: END IF;
522: END set_line_user_key;
523:
542: END IF;
543: EXCEPTION
544: WHEN OTHERS
545: THEN
546: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
547: THEN
548: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_Flow');
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
544: WHEN OTHERS
545: THEN
546: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
547: THEN
548: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_Flow');
549: RAISE fnd_api.g_exc_unexpected_error;
550: END IF;
551: END start_flow;
552:
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)
581: 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)
581: THEN
582: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_LineFork');
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
578: END IF;
579:
580: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
581: THEN
582: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_LineFork');
583: RAISE fnd_api.g_exc_unexpected_error;
584: END IF;
585: END start_linefork;
586:
634: THEN -- 2590433
635: RAISE;
636: WHEN OTHERS
637: THEN
638: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
639: THEN
640: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_HdrProcess');
641: RAISE fnd_api.g_exc_unexpected_error;
642: END IF;
636: WHEN OTHERS
637: THEN
638: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
639: THEN
640: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_HdrProcess');
641: RAISE fnd_api.g_exc_unexpected_error;
642: END IF;
643: END createstart_hdrprocess;
644:
760: THEN -- 2590433
761: RAISE;
762: WHEN OTHERS
763: THEN
764: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
765: THEN
766: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_HdrWorkItem');
767: RAISE fnd_api.g_exc_unexpected_error;
768: END IF;
762: WHEN OTHERS
763: THEN
764: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
765: THEN
766: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_HdrWorkItem');
767: RAISE fnd_api.g_exc_unexpected_error;
768: END IF;
769: END create_hdrworkitem;
770:
850: THEN -- 2590433
851: RAISE;
852: WHEN OTHERS
853: THEN
854: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
855: THEN
856: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_LineProcess');
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;
852: WHEN OTHERS
853: THEN
854: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
855: THEN
856: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_LineProcess');
857: RAISE fnd_api.g_exc_unexpected_error;
858: END IF;
859: END createstart_lineprocess;
860:
878: END IF;
879: EXCEPTION
880: WHEN OTHERS
881: THEN
882: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
883: THEN
884: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_LineFork');
885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;
880: WHEN OTHERS
881: THEN
882: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
883: THEN
884: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_LineFork');
885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;
887: END createstart_linefork;
888:
986: THEN -- 2590433
987: RAISE;
988: WHEN OTHERS
989: THEN
990: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
991: THEN
992: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_LineWorkItem');
993: RAISE fnd_api.g_exc_unexpected_error;
994: END IF;
988: WHEN OTHERS
989: THEN
990: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
991: THEN
992: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_LineWorkItem');
993: RAISE fnd_api.g_exc_unexpected_error;
994: END IF;
995: END create_lineworkitem;
996:
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)
1036: 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)
1036: THEN
1037: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_LineFork');
1038: RAISE fnd_api.g_exc_unexpected_error;
1039: END IF;
1033: END IF;
1034:
1035: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1036: THEN
1037: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_LineFork');
1038: RAISE fnd_api.g_exc_unexpected_error;
1039: END IF;
1040: END create_linefork;
1041:
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
1140: WHEN OTHERS
1138: END IF;
1139: EXCEPTION
1140: WHEN OTHERS
1141: THEN
1142: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1143: THEN
1144: oe_msg_pub.add_exc_msg (g_pkg_name, 'Get_Wf_Item_Type');
1145: END IF;
1146:
1140: WHEN OTHERS
1141: THEN
1142: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1143: THEN
1144: oe_msg_pub.add_exc_msg (g_pkg_name, 'Get_Wf_Item_Type');
1145: END IF;
1146:
1147: RAISE fnd_api.g_exc_unexpected_error;
1148: END get_wf_item_type;
1425: END IF;
1426: EXCEPTION
1427: WHEN OTHERS
1428: THEN
1429: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1430: THEN
1431: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_All_Flows');
1432: -- Rollback to savepoint
1433: ROLLBACK TO start_all_flows;
1427: WHEN OTHERS
1428: THEN
1429: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1430: THEN
1431: oe_msg_pub.add_exc_msg (g_pkg_name, 'Start_All_Flows');
1432: -- Rollback to savepoint
1433: ROLLBACK TO start_all_flows;
1434: -- Clear Globals
1435: clear_flowstart_globals;
1655: ('OE_ORDER_WF_UTIL: DELETE TYPE NOT IN HEADER,LINE,NEGOTIATE,BLANKET'
1656: );
1657: END IF;
1658:
1659: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1660: THEN
1661: oe_msg_pub.add_exc_msg (g_pkg_name, 'Delete_Row');
1662: RAISE fnd_api.g_exc_unexpected_error;
1663: END IF;
1657: END IF;
1658:
1659: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
1660: THEN
1661: oe_msg_pub.add_exc_msg (g_pkg_name, 'Delete_Row');
1662: RAISE fnd_api.g_exc_unexpected_error;
1663: END IF;
1664: END IF;
1665:
1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;
1822:
1823: -- is entity HEADER correct?
1824: oe_msg_pub.set_msg_context
1825: (p_entity_code => 'HEADER',
1826: p_entity_id => l_header_rec.header_id,
1827: p_header_id => l_header_rec.header_id,
1828: p_line_id => NULL,
2006: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2007: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2008: END IF;
2009:
2010: OE_MSG_PUB.set_msg_context
2011: ( p_entity_code => 'BLANKET'
2012: ,p_entity_id => p_header_id
2013: ,p_header_id => p_header_id);
2014:
2099: THEN
2100: RAISE fnd_api.g_exc_unexpected_error;
2101: END IF;
2102:
2103: oe_msg_pub.set_msg_context
2104: (p_entity_code => 'LINE',
2105: p_entity_id => l_old_line_tbl (1).line_id,
2106: p_header_id => l_old_line_tbl (1).header_id,
2107: p_line_id => l_old_line_tbl (1).line_id,
2129: FROM oe_order_lines_all
2130: WHERE line_id = p_line_id
2131: FOR UPDATE NOWAIT;
2132:
2133: oe_msg_pub.set_msg_context
2134: (p_entity_code => 'LINE',
2135: p_entity_id => p_line_id,
2136: p_header_id => l_header_id,
2137: p_line_id => p_line_id,
2172: THEN
2173: RAISE fnd_api.g_exc_unexpected_error;
2174: END IF;
2175:
2176: oe_msg_pub.set_msg_context
2177: (p_entity_code => 'HEADER',
2178: p_entity_id => l_header_rec.header_id,
2179: p_header_id => l_header_rec.header_id,
2180: p_line_id => NULL,
2349: RAISE fnd_api.g_exc_unexpected_error;
2350: END IF; -- bug 4732614 ends
2351: END IF; /*ASO installed */
2352:
2353: oe_msg_pub.reset_msg_context ('LINE');
2354:
2355: /********************GENESIS********************************
2356: * Some statuses are not going through process order and *
2357: * the update_flow_status is getting called directly. So *
2664: END IF;
2665:
2666: IF p_line_id IS NOT NULL
2667: THEN
2668: oe_msg_pub.reset_msg_context ('LINE');
2669: ELSIF p_header_id IS NOT NULL
2670: THEN
2671: oe_msg_pub.reset_msg_context ('HEADER');
2672: END IF;
2667: THEN
2668: oe_msg_pub.reset_msg_context ('LINE');
2669: ELSIF p_header_id IS NOT NULL
2670: THEN
2671: oe_msg_pub.reset_msg_context ('HEADER');
2672: END IF;
2673: WHEN fnd_api.g_exc_error
2674: THEN
2675: ROLLBACK TO update_flow_status_code;
2682: x_return_status := fnd_api.g_ret_sts_error;
2683:
2684: IF p_line_id IS NOT NULL
2685: THEN
2686: oe_msg_pub.reset_msg_context ('LINE');
2687: ELSIF p_header_id IS NOT NULL
2688: THEN
2689: oe_msg_pub.reset_msg_context ('HEADER');
2690: END IF;
2685: THEN
2686: oe_msg_pub.reset_msg_context ('LINE');
2687: ELSIF p_header_id IS NOT NULL
2688: THEN
2689: oe_msg_pub.reset_msg_context ('HEADER');
2690: END IF;
2691: WHEN app_exceptions.record_lock_exception
2692: THEN
2693: ROLLBACK TO update_flow_status_code;
2698: END IF;
2699:
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;
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
2709: THEN
2706: END IF;
2707:
2708: IF p_line_id IS NOT NULL
2709: THEN
2710: oe_msg_pub.reset_msg_context ('LINE');
2711: ELSIF p_header_id IS NOT NULL
2712: THEN
2713: oe_msg_pub.reset_msg_context ('HEADER');
2714: END IF;
2709: THEN
2710: oe_msg_pub.reset_msg_context ('LINE');
2711: ELSIF p_header_id IS NOT NULL
2712: THEN
2713: oe_msg_pub.reset_msg_context ('HEADER');
2714: END IF;
2715: WHEN OTHERS
2716: THEN
2717: ROLLBACK TO update_flow_status_code;
2724: x_return_status := fnd_api.g_ret_sts_unexp_error;
2725:
2726: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2727: THEN
2728: oe_msg_pub.add_exc_msg (g_pkg_name, 'Update_Flow_Status_Code');
2729: END IF;
2730:
2731: IF p_line_id IS NOT NULL
2732: THEN
2729: END IF;
2730:
2731: IF p_line_id IS NOT NULL
2732: THEN
2733: oe_msg_pub.reset_msg_context ('LINE');
2734: ELSIF p_header_id IS NOT NULL
2735: THEN
2736: oe_msg_pub.reset_msg_context ('HEADER');
2737: END IF;
2732: THEN
2733: oe_msg_pub.reset_msg_context ('LINE');
2734: ELSIF p_header_id IS NOT NULL
2735: THEN
2736: oe_msg_pub.reset_msg_context ('HEADER');
2737: END IF;
2738: END update_flow_status_code;
2739:
2740: PROCEDURE set_notification_approver (
2977: RAISE fnd_api.g_exc_unexpected_error;
2978: END IF;
2979:
2980: -- is entity HEADER correct?
2981: oe_msg_pub.set_msg_context
2982: (p_entity_code => 'HEADER',
2983: p_entity_id => l_header_rec.header_id,
2984: p_header_id => l_header_rec.header_id,
2985: p_line_id => NULL,
3223: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3225: END IF;
3226:
3227: OE_MSG_PUB.set_msg_context
3228: ( p_entity_code => 'BLANKET'
3229: ,p_entity_id => p_header_id
3230: ,p_header_id => p_header_id);
3231:
3324: x_return_status := fnd_api.g_ret_sts_error;
3325:
3326: IF l_header_id IS NOT NULL
3327: THEN
3328: oe_msg_pub.reset_msg_context ('HEADER');
3329: END IF;
3330: WHEN fnd_api.g_exc_error
3331: THEN
3332: ROLLBACK TO update_quote_blanket;
3339: x_return_status := fnd_api.g_ret_sts_error;
3340:
3341: IF l_header_id IS NOT NULL
3342: THEN
3343: oe_msg_pub.reset_msg_context ('HEADER');
3344: END IF;
3345: WHEN app_exceptions.record_lock_exception
3346: THEN
3347: ROLLBACK TO update_quote_blanket;
3352: END IF;
3353:
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;
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
3363: THEN
3360: END IF;
3361:
3362: IF l_header_id IS NOT NULL
3363: THEN
3364: oe_msg_pub.reset_msg_context ('HEADER');
3365: END IF;
3366: WHEN OTHERS
3367: THEN
3368: ROLLBACK TO update_quote_blanket;
3375: x_return_status := fnd_api.g_ret_sts_unexp_error;
3376:
3377: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3378: THEN
3379: oe_msg_pub.add_exc_msg (g_pkg_name, 'Update_Quote_Blanket');
3380: END IF;
3381:
3382: IF l_header_id IS NOT NULL
3383: THEN
3380: END IF;
3381:
3382: IF l_header_id IS NOT NULL
3383: THEN
3384: oe_msg_pub.reset_msg_context ('HEADER');
3385: END IF;
3386: END update_quote_blanket;
3387:
3388: /* -------------------------------------------------
3497: END IF;
3498: EXCEPTION
3499: WHEN OTHERS
3500: THEN
3501: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3502: THEN
3503: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_WorkItem_Upgrade');
3504: RAISE fnd_api.g_exc_unexpected_error;
3505: END IF;
3499: WHEN OTHERS
3500: THEN
3501: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3502: THEN
3503: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_WorkItem_Upgrade');
3504: RAISE fnd_api.g_exc_unexpected_error;
3505: END IF;
3506: END create_workitem_upgrade;
3507:
3565: THEN
3566: RAISE;
3567: WHEN OTHERS
3568: THEN
3569: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3570: THEN
3571: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_HdrInternal');
3572: RAISE fnd_api.g_exc_unexpected_error;
3573: END IF;
3567: WHEN OTHERS
3568: THEN
3569: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3570: THEN
3571: oe_msg_pub.add_exc_msg (g_pkg_name, 'CreateStart_HdrInternal');
3572: RAISE fnd_api.g_exc_unexpected_error;
3573: END IF;
3574: END createstart_hdrinternal;
3575:
3721: THEN
3722: RAISE;
3723: WHEN OTHERS
3724: THEN
3725: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3726: THEN
3727: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_HdrWorkItemInternal');
3728: RAISE fnd_api.g_exc_unexpected_error;
3729: END IF;
3723: WHEN OTHERS
3724: THEN
3725: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3726: THEN
3727: oe_msg_pub.add_exc_msg (g_pkg_name, 'Create_HdrWorkItemInternal');
3728: RAISE fnd_api.g_exc_unexpected_error;
3729: END IF;
3730: END create_hdrworkiteminternal;
3731:
3755: wf_engine.setitemuserkey (oe_globals.g_wfi_ngo, p_header_id, l_user_key);
3756: EXCEPTION
3757: WHEN OTHERS
3758: THEN
3759: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3760: THEN
3761: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Negotiate_Hdr_User_Key');
3762: RAISE fnd_api.g_exc_unexpected_error;
3763: END IF;
3757: WHEN OTHERS
3758: THEN
3759: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3760: THEN
3761: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Negotiate_Hdr_User_Key');
3762: RAISE fnd_api.g_exc_unexpected_error;
3763: END IF;
3764: END set_negotiate_hdr_user_key;
3765:
3778: l_user_key);
3779: EXCEPTION
3780: WHEN OTHERS
3781: THEN
3782: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3783: THEN
3784: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Blanket_Hdr_User_Key');
3785: RAISE fnd_api.g_exc_unexpected_error;
3786: END IF;
3780: WHEN OTHERS
3781: THEN
3782: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
3783: THEN
3784: oe_msg_pub.add_exc_msg (g_pkg_name, 'Set_Blanket_Hdr_User_Key');
3785: RAISE fnd_api.g_exc_unexpected_error;
3786: END IF;
3787: END set_blanket_hdr_user_key;
3788:
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:
5043: IF l_debug_level > 0
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
5106: SELECT meaning
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
5121: THEN
5142: THEN
5143: CLOSE book_eligible;
5144: END IF;
5145:
5146: oe_msg_pub.count_and_get (p_count => x_msg_count,
5147: p_data => x_msg_data
5148: );
5149: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5150: WHEN fnd_api.g_exc_unexpected_error
5145:
5146: oe_msg_pub.count_and_get (p_count => x_msg_count,
5147: p_data => x_msg_data
5148: );
5149: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5150: WHEN fnd_api.g_exc_unexpected_error
5151: THEN
5152: x_return_status := fnd_api.g_ret_sts_unexp_error;
5153:
5155: THEN
5156: CLOSE book_eligible;
5157: END IF;
5158:
5159: oe_msg_pub.count_and_get (p_count => x_msg_count,
5160: p_data => x_msg_data
5161: );
5162: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5163: WHEN OTHERS
5158:
5159: oe_msg_pub.count_and_get (p_count => x_msg_count,
5160: p_data => x_msg_data
5161: );
5162: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5163: WHEN OTHERS
5164: THEN
5165: x_return_status := fnd_api.g_ret_sts_unexp_error;
5166:
5168: THEN
5169: CLOSE book_eligible;
5170: END IF;
5171:
5172: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
5173: THEN
5174: oe_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5175: END IF;
5176:
5170: END IF;
5171:
5172: IF oe_msg_pub.check_msg_level (oe_msg_pub.g_msg_lvl_unexp_error)
5173: THEN
5174: oe_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5175: END IF;
5176:
5177: oe_msg_pub.count_and_get (p_count => x_msg_count,
5178: p_data => x_msg_data
5173: THEN
5174: oe_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5175: END IF;
5176:
5177: oe_msg_pub.count_and_get (p_count => x_msg_count,
5178: p_data => x_msg_data
5179: );
5180: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5181: END complete_eligible_and_book;
5176:
5177: oe_msg_pub.count_and_get (p_count => x_msg_count,
5178: p_data => x_msg_data
5179: );
5180: oe_msg_pub.reset_msg_context (p_entity_code => 'HEADER');
5181: END complete_eligible_and_book;
5182: END oe_order_wf_util;