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_CNCL_ORDER_IMPORT_PVT dependencies on OE_MSG_PUB

Line 1225: OE_MSG_PUB.Initialize;

1221: IF p_init_msg_list = FND_API.G_TRUE THEN
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'BEFORE INITIALIZING MESSAGES LIST' ) ;
1224: END IF;
1225: OE_MSG_PUB.Initialize;
1226: END IF;
1227:
1228: /* -----------------------------------------------------------
1229: Set message context

Line 1236: OE_MSG_PUB.set_msg_context(

1232: IF l_debug_level > 0 THEN
1233: oe_debug_pub.add( 'BEFORE SETTING MESSAGE CONTEXT' ) ;
1234: END IF;
1235:
1236: OE_MSG_PUB.set_msg_context(
1237: p_entity_code => 'HEADER'
1238: ,p_entity_ref => null
1239: ,p_entity_id => null
1240: ,p_header_id => null

Line 1699: OE_MSG_PUB.reset_msg_context('HEADER');

1695: --
1696: WHEN FND_API.G_EXC_ERROR THEN
1697: --
1698: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1699: OE_MSG_PUB.reset_msg_context('HEADER');
1700: --
1701: RAISE;
1702: --
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1706: OE_MSG_PUB.reset_msg_context('HEADER');

1702: --
1703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1704: --
1705: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1706: OE_MSG_PUB.reset_msg_context('HEADER');
1707: --
1708: RAISE;
1709: --
1710: WHEN OTHERS THEN

Line 1712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1708: RAISE;
1709: --
1710: WHEN OTHERS THEN
1711: --
1712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1713: --
1714: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header');
1715: --
1716: END IF;

Line 1714: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header');

1710: WHEN OTHERS THEN
1711: --
1712: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1713: --
1714: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header');
1715: --
1716: END IF;
1717: --
1718: OE_Header_Security.g_check_all_cols_constraint := 'Y';

Line 1719: OE_MSG_PUB.reset_msg_context('HEADER');

1715: --
1716: END IF;
1717: --
1718: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1719: OE_MSG_PUB.reset_msg_context('HEADER');
1720: --
1721: RAISE;
1722: --
1723: END;

Line 1877: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

1873: --
1874: WHEN FND_API.G_EXC_ERROR THEN
1875: --
1876: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1877: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1878: --
1879: RAISE;
1880: --
1881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1884: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

1880: --
1881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1882: --
1883: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1884: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1885: --
1886: RAISE;
1887: --
1888: WHEN OTHERS THEN

Line 1890: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1886: RAISE;
1887: --
1888: WHEN OTHERS THEN
1889: --
1890: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1891: --
1892: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Adjs');
1893: --
1894: END IF;

Line 1892: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Adjs');

1888: WHEN OTHERS THEN
1889: --
1890: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1891: --
1892: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Adjs');
1893: --
1894: END IF;
1895: --
1896: OE_Header_Security.g_check_all_cols_constraint := 'Y';

Line 1897: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

1893: --
1894: END IF;
1895: --
1896: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1897: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1898: --
1899: RAISE;
1900: --
1901: END;

Line 2016: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');

2012: --
2013: WHEN FND_API.G_EXC_ERROR THEN
2014: --
2015: OE_Header_Security.g_check_all_cols_constraint := 'Y';
2016: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
2017: --
2018: RAISE;
2019: --
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2023: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');

2019: --
2020: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2021: --
2022: OE_Header_Security.g_check_all_cols_constraint := 'Y';
2023: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
2024: --
2025: RAISE;
2026: --
2027: WHEN OTHERS THEN

Line 2029: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2025: RAISE;
2026: --
2027: WHEN OTHERS THEN
2028: --
2029: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2030: --
2031: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Scredits');
2032: --
2033: END IF;

Line 2031: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Scredits');

2027: WHEN OTHERS THEN
2028: --
2029: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2030: --
2031: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Scredits');
2032: --
2033: END IF;
2034: --
2035: OE_Header_Security.g_check_all_cols_constraint := 'Y';

Line 2036: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

2032: --
2033: END IF;
2034: --
2035: OE_Header_Security.g_check_all_cols_constraint := 'Y';
2036: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
2037: --
2038: RAISE;
2039: --
2040: END;

Line 2516: OE_MSG_PUB.Add_TEXT(failure_message);

2512: IF l_debug_level > 0 THEN
2513: oe_debug_pub.add( 'ERROR IN GETTING CCID' ) ;
2514: END IF;
2515: failure_message := fnd_flex_ext.get_message;
2516: OE_MSG_PUB.Add_TEXT(failure_message);
2517: p_return_status := FND_API.G_RET_STS_ERROR;
2518: l_validate_only := FND_API.G_TRUE;
2519: IF l_debug_level > 0 THEN
2520: oe_debug_pub.add( 'FAILURE MESSAGE = ' || SUBSTR ( FAILURE_MESSAGE , 1 , 50 ) ) ;

Line 2558: OE_MSG_PUB.Add;

2554: l_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
2555: FND_MESSAGE.SET_NAME('ONT','OE_OIM_INVALID_ITEM_ID');
2556: FND_MESSAGE.SET_TOKEN('ORDER_NO', l_orig_sys_document_ref);
2557: FND_MESSAGE.SET_TOKEN('ORDER_SOURCE', l_order_source_id);
2558: OE_MSG_PUB.Add;
2559: p_return_status := FND_API.G_RET_STS_ERROR;
2560: l_validate_only := FND_API.G_TRUE;
2561: IF l_debug_level > 0 THEN
2562: oe_debug_pub.add( 'CANNOT IMPORT ORDER AS BOTH INVENTORY_ITEM_ID AND INVENTORY_ITEM_SEGMENTS ARE POPULATED' ) ;

Line 2657: OE_MSG_PUB.reset_msg_context('LINE');

2653: EXCEPTION
2654: --
2655: WHEN FND_API.G_EXC_ERROR THEN
2656: --
2657: OE_MSG_PUB.reset_msg_context('LINE');
2658: --
2659: RAISE;
2660: --
2661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2663: OE_MSG_PUB.reset_msg_context('LINE');

2659: RAISE;
2660: --
2661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2662: --
2663: OE_MSG_PUB.reset_msg_context('LINE');
2664: --
2665: RAISE;
2666: --
2667: WHEN OTHERS THEN

Line 2669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2665: RAISE;
2666: --
2667: WHEN OTHERS THEN
2668: --
2669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2670: --
2671: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Lines');
2672: --
2673: END IF;

Line 2671: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Lines');

2667: WHEN OTHERS THEN
2668: --
2669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2670: --
2671: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Lines');
2672: --
2673: END IF;
2674: --
2675: OE_MSG_PUB.reset_msg_context('LINE');

Line 2675: OE_MSG_PUB.reset_msg_context('LINE');

2671: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Lines');
2672: --
2673: END IF;
2674: --
2675: OE_MSG_PUB.reset_msg_context('LINE');
2676: --
2677: RAISE;
2678: --
2679: END;

Line 2837: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

2833: EXCEPTION
2834: --
2835: WHEN FND_API.G_EXC_ERROR THEN
2836: --
2837: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
2838: --
2839: RAISE;
2840: --
2841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2843: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

2839: RAISE;
2840: --
2841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2842: --
2843: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
2844: --
2845: RAISE;
2846: --
2847: WHEN OTHERS THEN

Line 2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2845: RAISE;
2846: --
2847: WHEN OTHERS THEN
2848: --
2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2850: --
2851: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Adjs');
2852: --
2853: END IF;

Line 2851: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Adjs');

2847: WHEN OTHERS THEN
2848: --
2849: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2850: --
2851: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Adjs');
2852: --
2853: END IF;
2854: --
2855: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

Line 2855: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

2851: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Adjs');
2852: --
2853: END IF;
2854: --
2855: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
2856: --
2857: RAISE;
2858: --
2859: END;

Line 2978: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

2974: EXCEPTION
2975: --
2976: WHEN FND_API.G_EXC_ERROR THEN
2977: --
2978: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
2979: --
2980: RAISE;
2981: --
2982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2984: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

2980: RAISE;
2981: --
2982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2983: --
2984: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
2985: --
2986: RAISE;
2987: --
2988: WHEN OTHERS THEN

Line 2990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2986: RAISE;
2987: --
2988: WHEN OTHERS THEN
2989: --
2990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2991: --
2992: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Scredits');
2993: --
2994: END IF;

Line 2992: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Scredits');

2988: WHEN OTHERS THEN
2989: --
2990: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2991: --
2992: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Scredits');
2993: --
2994: END IF;
2995: --
2996: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

Line 2996: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

2992: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Scredits');
2993: --
2994: END IF;
2995: --
2996: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
2997: --
2998: RAISE;
2999: --
3000: END;

Line 3073: OE_MSG_PUB.reset_msg_context('HEADER');

3069: --
3070: l_header_rec.return_status := FND_API.G_RET_STS_ERROR;
3071: --
3072: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3073: OE_MSG_PUB.reset_msg_context('HEADER');
3074: --
3075: RAISE;
3076: --
3077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3082: OE_MSG_PUB.reset_msg_context('HEADER');

3078: --
3079: l_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3080: --
3081: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3082: OE_MSG_PUB.reset_msg_context('HEADER');
3083: --
3084: RAISE;
3085: --
3086: WHEN OTHERS THEN

Line 3090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3086: WHEN OTHERS THEN
3087: --
3088: l_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3089: --
3090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3091: --
3092: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3093: 'Header');
3094: --

Line 3092: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3088: l_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3089: --
3090: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3091: --
3092: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3093: 'Header');
3094: --
3095: END IF;
3096: --

Line 3098: OE_MSG_PUB.reset_msg_context('HEADER');

3094: --
3095: END IF;
3096: --
3097: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3098: OE_MSG_PUB.reset_msg_context('HEADER');
3099: --
3100: RAISE;
3101: --
3102: END;

Line 3136: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');

3132: --
3133: l_header_scredit_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
3134: --
3135: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3136: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
3137: --
3138: RAISE;
3139: --
3140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3145: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');

3141: --
3142: l_header_scredit_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3143: --
3144: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3145: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
3146: --
3147: RAISE;
3148: --
3149: WHEN OTHERS THEN

Line 3153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3149: WHEN OTHERS THEN
3150: --
3151: l_header_scredit_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3152: --
3153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3154: --
3155: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3156: 'Header_Scredits');
3157: --

Line 3155: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3151: l_header_scredit_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3152: --
3153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3154: --
3155: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3156: 'Header_Scredits');
3157: --
3158: END IF;
3159: --

Line 3161: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');

3157: --
3158: END IF;
3159: --
3160: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3161: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
3162: --
3163: RAISE;
3164: --
3165: END;

Line 3202: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

3198: --
3199: l_header_adj_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
3200: --
3201: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3202: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
3203: --
3204: RAISE;
3205: --
3206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3211: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

3207: --
3208: l_header_adj_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3209: --
3210: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3211: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
3212: --
3213: RAISE;
3214: --
3215: WHEN OTHERS THEN

Line 3219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3215: WHEN OTHERS THEN
3216: --
3217: l_header_adj_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3218: --
3219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3220: --
3221: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3222: 'Header_Adjs');
3223: --

Line 3221: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3217: l_header_adj_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3218: --
3219: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3220: --
3221: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3222: 'Header_Adjs');
3223: --
3224: END IF;
3225: --

Line 3227: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');

3223: --
3224: END IF;
3225: --
3226: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3227: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
3228: --
3229: RAISE;
3230: --
3231: END;

Line 3361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)

3357: EXCEPTION
3358:
3359: WHEN NO_DATA_FOUND THEN
3360:
3361: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3362: THEN
3363:
3364: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');

Line 3366: OE_MSG_PUB.Add;

3362: THEN
3363:
3364: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3365: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');
3366: OE_MSG_PUB.Add;
3367:
3368: END IF;
3369:
3370: WHEN OTHERS THEN

Line 3372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3368: END IF;
3369:
3370: WHEN OTHERS THEN
3371:
3372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3373: THEN
3374: OE_MSG_PUB.Add_Exc_Msg
3375: ( G_PKG_NAME
3376: , 'Order_Import'

Line 3374: OE_MSG_PUB.Add_Exc_Msg

3370: WHEN OTHERS THEN
3371:
3372: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3373: THEN
3374: OE_MSG_PUB.Add_Exc_Msg
3375: ( G_PKG_NAME
3376: , 'Order_Import'
3377: );
3378: END IF;

Line 3588: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

3584: --
3585: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
3586: --
3587: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3588: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
3589: --
3590: RAISE;
3591: --
3592: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3597: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

3593: --
3594: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595: --
3596: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3597: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
3598: --
3599: RAISE;
3600: --
3601: WHEN OTHERS THEN

Line 3605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3601: WHEN OTHERS THEN
3602: --
3603: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: --
3605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3606: --
3607: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3608: 'Line_Scredits');
3609: --

Line 3607: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3603: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3604: --
3605: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3606: --
3607: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3608: 'Line_Scredits');
3609: --
3610: END IF;
3611: --

Line 3613: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

3609: --
3610: END IF;
3611: --
3612: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3613: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
3614: --
3615: RAISE;
3616: --
3617: END;

Line 3660: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

3656: --
3657: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_ERROR;
3658: --
3659: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3660: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
3661: --
3662: RAISE;
3663: --
3664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3669: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

3665: --
3666: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3667: --
3668: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3669: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
3670: --
3671: RAISE;
3672: --
3673: WHEN OTHERS THEN

Line 3677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3673: WHEN OTHERS THEN
3674: --
3675: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3676: --
3677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3678: --
3679: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3680: 'Line_Adjs');
3681: --

Line 3679: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3675: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3676: --
3677: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3678: --
3679: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3680: 'Line_Adjs');
3681: --
3682: END IF;
3683: --

Line 3685: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

3681: --
3682: END IF;
3683: --
3684: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3685: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
3686: --
3687: RAISE;
3688: --
3689: END;

Line 3701: OE_MSG_PUB.reset_msg_context('LINE');

3697: --
3698: l_line_tbl(L).return_status := FND_API.G_RET_STS_ERROR;
3699: --
3700: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3701: OE_MSG_PUB.reset_msg_context('LINE');
3702: --
3703: RAISE;
3704: --
3705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3710: OE_MSG_PUB.reset_msg_context('LINE');

3706: --
3707: l_line_tbl(L).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3708: --
3709: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3710: OE_MSG_PUB.reset_msg_context('LINE');
3711: --
3712: RAISE;
3713: --
3714: WHEN OTHERS THEN

Line 3718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3714: WHEN OTHERS THEN
3715: --
3716: l_line_tbl(L).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3717: --
3718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3719: --
3720: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3721: 'Lines');
3722: --

Line 3720: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3716: l_line_tbl(L).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3717: --
3718: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3719: --
3720: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3721: 'Lines');
3722: --
3723: END IF;
3724: --

Line 3726: OE_MSG_PUB.reset_msg_context('LINE');

3722: --
3723: END IF;
3724: --
3725: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3726: OE_MSG_PUB.reset_msg_context('LINE');
3727: --
3728: RAISE;
3729: --
3730: END;

Line 3880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3876: WHEN OTHERS THEN
3877: IF l_debug_level > 0 THEN
3878: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3879: END IF;
3880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3881: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3882: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3883: END IF;
3884: END;

Line 3882: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

3878: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3879: END IF;
3880: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3881: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3882: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3883: END IF;
3884: END;
3885:
3886: BEGIN

Line 3917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3913: WHEN OTHERS THEN
3914: IF l_debug_level > 0 THEN
3915: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3916: END IF;
3917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3918: THEN
3919: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3920: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3921: END IF;

Line 3920: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

3916: END IF;
3917: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3918: THEN
3919: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3920: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3921: END IF;
3922: END;
3923: END IF;
3924: END LOOP;

Line 3958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3954: WHEN OTHERS THEN
3955: IF l_debug_level > 0 THEN
3956: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3957: END IF;
3958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3959: THEN
3960: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3962: END IF;

Line 3961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

3957: END IF;
3958: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3959: THEN
3960: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3962: END IF;
3963: END;
3964: END IF;
3965: END LOOP;

Line 4000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3996: WHEN OTHERS THEN
3997: IF l_debug_level > 0 THEN
3998: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3999: END IF;
4000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4001: THEN
4002: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
4003: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4004: END IF;

Line 4003: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

3999: END IF;
4000: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4001: THEN
4002: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
4003: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4004: END IF;
4005: END;
4006: END IF;
4007: END LOOP;

Line 4047: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count

4043: /* -----------------------------------------------------------
4044: Update the processing messages table
4045: -----------------------------------------------------------
4046: */
4047: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count
4048: ,p_data => p_msg_data);
4049:
4050: IF l_debug_level > 0 THEN
4051: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( P_MSG_COUNT ) ) ;

Line 4065: oe_msg_pub.get (

4061: LOOP
4062: IF l_debug_level > 0 THEN
4063: oe_debug_pub.add( 'BEFORE CALLING GET' ) ;
4064: END IF;
4065: oe_msg_pub.get (
4066: p_msg_index => -2
4067: ,p_encoded => 'F'
4068: ,p_data => p_msg_data
4069: ,p_msg_index_out => l_msg_index);

Line 4085: oe_msg_pub.get_msg_context (

4081: begin
4082: IF l_debug_level > 0 THEN
4083: oe_debug_pub.add( 'BEFORE CALLING GET_MSG_CONTEXT' ) ;
4084: END IF;
4085: oe_msg_pub.get_msg_context (
4086: p_msg_index => l_msg_index
4087: ,x_entity_code => l_msg_entity_code
4088: ,x_entity_ref => l_msg_entity_ref
4089: ,x_entity_id => l_msg_entity_id

Line 4124: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN

4120: end if;
4121: IF l_debug_level > 0 THEN
4122: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
4123: END IF;
4124: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4125: IF l_debug_level > 0 THEN
4126: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
4127: END IF;
4128: p_msg_data := oe_msg_pub.get(l_msg_index, 'F');

Line 4128: p_msg_data := oe_msg_pub.get(l_msg_index, 'F');

4124: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4125: IF l_debug_level > 0 THEN
4126: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
4127: END IF;
4128: p_msg_data := oe_msg_pub.get(l_msg_index, 'F');
4129: END IF;
4130:
4131: l_msg_context := '';
4132: IF l_msg_order_source_id IS NOT NULL THEN

Line 4185: oe_msg_pub.g_msg_tbl(l_msg_index).header_id := l_header_rec.header_id;

4181: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
4182: IF l_debug_level > 0 THEN
4183: oe_debug_pub.add( 'Header id updated in msg stack:' || l_header_rec.header_id ) ;
4184: END IF;
4185: oe_msg_pub.g_msg_tbl(l_msg_index).header_id := l_header_rec.header_id;
4186: END IF;
4187: -- end bug 4195533
4188: END LOOP;
4189: <>

Line 4239: OE_MSG_PUB.save_messages (l_request_id);

4235: oe_debug_pub.add( 'BEFORE SAVING MESSAGES IN THE DATABASE TABLE' ) ;
4236: END IF;
4237:
4238: IF p_msg_count > 0 THEN
4239: OE_MSG_PUB.save_messages (l_request_id);
4240: END IF;
4241: COMMIT; /* commit again to commit the error messages */
4242:
4243:

Line 4296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4292: WHEN OTHERS THEN
4293: IF l_debug_level > 0 THEN
4294: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
4295: END IF;
4296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4297: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4298: END IF;
4299: p_msg_count := p_msg_count + 1;
4300: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4297: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');

4293: IF l_debug_level > 0 THEN
4294: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
4295: END IF;
4296: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4297: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4298: END IF;
4299: p_msg_count := p_msg_count + 1;
4300: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4301: