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 1221: OE_MSG_PUB.Initialize;

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

Line 1232: OE_MSG_PUB.set_msg_context(

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

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

1691: --
1692: WHEN FND_API.G_EXC_ERROR THEN
1693: --
1694: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1695: OE_MSG_PUB.reset_msg_context('HEADER');
1696: --
1697: RAISE;
1698: --
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1698: --
1699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1700: --
1701: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1702: OE_MSG_PUB.reset_msg_context('HEADER');
1703: --
1704: RAISE;
1705: --
1706: WHEN OTHERS THEN

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

1704: RAISE;
1705: --
1706: WHEN OTHERS THEN
1707: --
1708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1709: --
1710: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header');
1711: --
1712: END IF;

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

1706: WHEN OTHERS THEN
1707: --
1708: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1709: --
1710: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header');
1711: --
1712: END IF;
1713: --
1714: OE_Header_Security.g_check_all_cols_constraint := 'Y';

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

1711: --
1712: END IF;
1713: --
1714: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1715: OE_MSG_PUB.reset_msg_context('HEADER');
1716: --
1717: RAISE;
1718: --
1719: END;

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

1869: --
1870: WHEN FND_API.G_EXC_ERROR THEN
1871: --
1872: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1873: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1874: --
1875: RAISE;
1876: --
1877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1876: --
1877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1878: --
1879: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1880: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1881: --
1882: RAISE;
1883: --
1884: WHEN OTHERS THEN

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

1882: RAISE;
1883: --
1884: WHEN OTHERS THEN
1885: --
1886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1887: --
1888: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Adjs');
1889: --
1890: END IF;

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

1884: WHEN OTHERS THEN
1885: --
1886: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1887: --
1888: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Adjs');
1889: --
1890: END IF;
1891: --
1892: OE_Header_Security.g_check_all_cols_constraint := 'Y';

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

1889: --
1890: END IF;
1891: --
1892: OE_Header_Security.g_check_all_cols_constraint := 'Y';
1893: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
1894: --
1895: RAISE;
1896: --
1897: END;

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

2008: --
2009: WHEN FND_API.G_EXC_ERROR THEN
2010: --
2011: OE_Header_Security.g_check_all_cols_constraint := 'Y';
2012: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
2013: --
2014: RAISE;
2015: --
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2015: --
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: --
2018: OE_Header_Security.g_check_all_cols_constraint := 'Y';
2019: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
2020: --
2021: RAISE;
2022: --
2023: WHEN OTHERS THEN

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

2021: RAISE;
2022: --
2023: WHEN OTHERS THEN
2024: --
2025: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2026: --
2027: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Scredits');
2028: --
2029: END IF;

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

2023: WHEN OTHERS THEN
2024: --
2025: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2026: --
2027: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Header_Scredits');
2028: --
2029: END IF;
2030: --
2031: OE_Header_Security.g_check_all_cols_constraint := 'Y';

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

2028: --
2029: END IF;
2030: --
2031: OE_Header_Security.g_check_all_cols_constraint := 'Y';
2032: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
2033: --
2034: RAISE;
2035: --
2036: END;

Line 2512: OE_MSG_PUB.Add_TEXT(failure_message);

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

Line 2554: OE_MSG_PUB.Add;

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

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

2649: EXCEPTION
2650: --
2651: WHEN FND_API.G_EXC_ERROR THEN
2652: --
2653: OE_MSG_PUB.reset_msg_context('LINE');
2654: --
2655: RAISE;
2656: --
2657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2655: RAISE;
2656: --
2657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2658: --
2659: OE_MSG_PUB.reset_msg_context('LINE');
2660: --
2661: RAISE;
2662: --
2663: WHEN OTHERS THEN

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

2661: RAISE;
2662: --
2663: WHEN OTHERS THEN
2664: --
2665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2666: --
2667: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Lines');
2668: --
2669: END IF;

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

2663: WHEN OTHERS THEN
2664: --
2665: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2666: --
2667: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Lines');
2668: --
2669: END IF;
2670: --
2671: OE_MSG_PUB.reset_msg_context('LINE');

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

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

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

2829: EXCEPTION
2830: --
2831: WHEN FND_API.G_EXC_ERROR THEN
2832: --
2833: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
2834: --
2835: RAISE;
2836: --
2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2835: RAISE;
2836: --
2837: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2838: --
2839: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
2840: --
2841: RAISE;
2842: --
2843: WHEN OTHERS THEN

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

2841: RAISE;
2842: --
2843: WHEN OTHERS THEN
2844: --
2845: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2846: --
2847: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Adjs');
2848: --
2849: END IF;

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

2843: WHEN OTHERS THEN
2844: --
2845: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2846: --
2847: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Adjs');
2848: --
2849: END IF;
2850: --
2851: OE_MSG_PUB.reset_msg_context('LINE_ADJ');

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

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

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

2970: EXCEPTION
2971: --
2972: WHEN FND_API.G_EXC_ERROR THEN
2973: --
2974: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
2975: --
2976: RAISE;
2977: --
2978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2976: RAISE;
2977: --
2978: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2979: --
2980: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
2981: --
2982: RAISE;
2983: --
2984: WHEN OTHERS THEN

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

2982: RAISE;
2983: --
2984: WHEN OTHERS THEN
2985: --
2986: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2987: --
2988: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Scredits');
2989: --
2990: END IF;

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

2984: WHEN OTHERS THEN
2985: --
2986: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2987: --
2988: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Line_Scredits');
2989: --
2990: END IF;
2991: --
2992: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');

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

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

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

3065: --
3066: l_header_rec.return_status := FND_API.G_RET_STS_ERROR;
3067: --
3068: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3069: OE_MSG_PUB.reset_msg_context('HEADER');
3070: --
3071: RAISE;
3072: --
3073: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3074: --
3075: l_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3076: --
3077: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3078: OE_MSG_PUB.reset_msg_context('HEADER');
3079: --
3080: RAISE;
3081: --
3082: WHEN OTHERS THEN

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

3082: WHEN OTHERS THEN
3083: --
3084: l_header_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3085: --
3086: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3087: --
3088: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3089: 'Header');
3090: --

Line 3088: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

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

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

3090: --
3091: END IF;
3092: --
3093: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3094: OE_MSG_PUB.reset_msg_context('HEADER');
3095: --
3096: RAISE;
3097: --
3098: END;

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

3128: --
3129: l_header_scredit_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
3130: --
3131: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3132: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
3133: --
3134: RAISE;
3135: --
3136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3137: --
3138: l_header_scredit_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3139: --
3140: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3141: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
3142: --
3143: RAISE;
3144: --
3145: WHEN OTHERS THEN

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

3145: WHEN OTHERS THEN
3146: --
3147: l_header_scredit_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3148: --
3149: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3150: --
3151: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3152: 'Header_Scredits');
3153: --

Line 3151: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

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

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

3153: --
3154: END IF;
3155: --
3156: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3157: OE_MSG_PUB.reset_msg_context('HEADER_SCREDIT');
3158: --
3159: RAISE;
3160: --
3161: END;

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

3194: --
3195: l_header_adj_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
3196: --
3197: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3198: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
3199: --
3200: RAISE;
3201: --
3202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3203: --
3204: l_header_adj_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3205: --
3206: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3207: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
3208: --
3209: RAISE;
3210: --
3211: WHEN OTHERS THEN

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

3211: WHEN OTHERS THEN
3212: --
3213: l_header_adj_tbl(I).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3214: --
3215: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3216: --
3217: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3218: 'Header_Adjs');
3219: --

Line 3217: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

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

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

3219: --
3220: END IF;
3221: --
3222: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3223: OE_MSG_PUB.reset_msg_context('HEADER_ADJ');
3224: --
3225: RAISE;
3226: --
3227: END;

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

3303: EXCEPTION
3304:
3305: WHEN NO_DATA_FOUND THEN
3306:
3307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3308: THEN
3309:
3310: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');

Line 3312: OE_MSG_PUB.Add;

3308: THEN
3309:
3310: fnd_message.set_name('ONT','OE_VALUE_TO_ID_ERROR');
3311: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','line_type_id');
3312: OE_MSG_PUB.Add;
3313:
3314: END IF;
3315:
3316: WHEN OTHERS THEN

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

3314: END IF;
3315:
3316: WHEN OTHERS THEN
3317:
3318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3319: THEN
3320: OE_MSG_PUB.Add_Exc_Msg
3321: ( G_PKG_NAME
3322: , 'Order_Import'

Line 3320: OE_MSG_PUB.Add_Exc_Msg

3316: WHEN OTHERS THEN
3317:
3318: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3319: THEN
3320: OE_MSG_PUB.Add_Exc_Msg
3321: ( G_PKG_NAME
3322: , 'Order_Import'
3323: );
3324: END IF;

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

3515: --
3516: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_ERROR;
3517: --
3518: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3519: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
3520: --
3521: RAISE;
3522: --
3523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3524: --
3525: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3526: --
3527: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3528: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
3529: --
3530: RAISE;
3531: --
3532: WHEN OTHERS THEN

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

3532: WHEN OTHERS THEN
3533: --
3534: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3535: --
3536: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3537: --
3538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3539: 'Line_Scredits');
3540: --

Line 3538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3534: l_line_scredit_tbl(J).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3535: --
3536: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3537: --
3538: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3539: 'Line_Scredits');
3540: --
3541: END IF;
3542: --

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

3540: --
3541: END IF;
3542: --
3543: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3544: OE_MSG_PUB.reset_msg_context('LINE_SCREDIT');
3545: --
3546: RAISE;
3547: --
3548: END;

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

3587: --
3588: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_ERROR;
3589: --
3590: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3591: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
3592: --
3593: RAISE;
3594: --
3595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3596: --
3597: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3598: --
3599: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3600: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
3601: --
3602: RAISE;
3603: --
3604: WHEN OTHERS THEN

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

3604: WHEN OTHERS THEN
3605: --
3606: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3607: --
3608: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3609: --
3610: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3611: 'Line_Adjs');
3612: --

Line 3610: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3606: l_line_adj_tbl(K).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3607: --
3608: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3609: --
3610: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3611: 'Line_Adjs');
3612: --
3613: END IF;
3614: --

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

3612: --
3613: END IF;
3614: --
3615: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3616: OE_MSG_PUB.reset_msg_context('LINE_ADJ');
3617: --
3618: RAISE;
3619: --
3620: END;

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

3628: --
3629: l_line_tbl(L).return_status := FND_API.G_RET_STS_ERROR;
3630: --
3631: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3632: OE_MSG_PUB.reset_msg_context('LINE');
3633: --
3634: RAISE;
3635: --
3636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3637: --
3638: l_line_tbl(L).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3639: --
3640: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3641: OE_MSG_PUB.reset_msg_context('LINE');
3642: --
3643: RAISE;
3644: --
3645: WHEN OTHERS THEN

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

3645: WHEN OTHERS THEN
3646: --
3647: l_line_tbl(L).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3648: --
3649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3650: --
3651: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3652: 'Lines');
3653: --

Line 3651: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,

3647: l_line_tbl(L).return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3648: --
3649: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3650: --
3651: OE_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
3652: 'Lines');
3653: --
3654: END IF;
3655: --

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

3653: --
3654: END IF;
3655: --
3656: OE_Header_Security.g_check_all_cols_constraint := 'Y';
3657: OE_MSG_PUB.reset_msg_context('LINE');
3658: --
3659: RAISE;
3660: --
3661: END;

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

3807: WHEN OTHERS THEN
3808: IF l_debug_level > 0 THEN
3809: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3810: END IF;
3811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3812: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3813: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3814: END IF;
3815: END;

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

3809: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3810: END IF;
3811: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3812: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3813: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3814: END IF;
3815: END;
3816:
3817: BEGIN

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

3844: WHEN OTHERS THEN
3845: IF l_debug_level > 0 THEN
3846: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3847: END IF;
3848: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3849: THEN
3850: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3851: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3852: END IF;

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

3847: END IF;
3848: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3849: THEN
3850: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3851: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3852: END IF;
3853: END;
3854: END IF;
3855: END LOOP;

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

3885: WHEN OTHERS THEN
3886: IF l_debug_level > 0 THEN
3887: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3888: END IF;
3889: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3890: THEN
3891: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3892: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3893: END IF;

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

3888: END IF;
3889: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3890: THEN
3891: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3892: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3893: END IF;
3894: END;
3895: END IF;
3896: END LOOP;

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

3927: WHEN OTHERS THEN
3928: IF l_debug_level > 0 THEN
3929: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
3930: END IF;
3931: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3932: THEN
3933: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3934: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3935: END IF;

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

3930: END IF;
3931: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3932: THEN
3933: l_return_status_upd_err := FND_API.G_RET_STS_UNEXP_ERROR;
3934: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
3935: END IF;
3936: END;
3937: END IF;
3938: END LOOP;

Line 3978: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count

3974: /* -----------------------------------------------------------
3975: Update the processing messages table
3976: -----------------------------------------------------------
3977: */
3978: OE_MSG_PUB.Count_And_Get (p_count => p_msg_count
3979: ,p_data => p_msg_data);
3980:
3981: IF l_debug_level > 0 THEN
3982: oe_debug_pub.add( 'MESSAGES RETURNED: '|| TO_CHAR ( P_MSG_COUNT ) ) ;

Line 3996: oe_msg_pub.get (

3992: LOOP
3993: IF l_debug_level > 0 THEN
3994: oe_debug_pub.add( 'BEFORE CALLING GET' ) ;
3995: END IF;
3996: oe_msg_pub.get (
3997: p_msg_index => -2
3998: ,p_encoded => 'F'
3999: ,p_data => p_msg_data
4000: ,p_msg_index_out => l_msg_index);

Line 4016: oe_msg_pub.get_msg_context (

4012: begin
4013: IF l_debug_level > 0 THEN
4014: oe_debug_pub.add( 'BEFORE CALLING GET_MSG_CONTEXT' ) ;
4015: END IF;
4016: oe_msg_pub.get_msg_context (
4017: p_msg_index => l_msg_index
4018: ,x_entity_code => l_msg_entity_code
4019: ,x_entity_ref => l_msg_entity_ref
4020: ,x_entity_id => l_msg_entity_id

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

4051: end if;
4052: IF l_debug_level > 0 THEN
4053: oe_debug_pub.add( 'AFTER CALLING GET_MSG_CONTEXT' ) ;
4054: END IF;
4055: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
4058: END IF;
4059: p_msg_data := oe_msg_pub.get(l_msg_index, 'F');

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

4055: IF oe_msg_pub.g_msg_tbl(l_msg_index).message_text IS NULL THEN
4056: IF l_debug_level > 0 THEN
4057: oe_debug_pub.add( 'IN INDEX.MESSAGE_TEXT IS NULL' ) ;
4058: END IF;
4059: p_msg_data := oe_msg_pub.get(l_msg_index, 'F');
4060: END IF;
4061:
4062: l_msg_context := '';
4063: IF l_msg_order_source_id IS NOT NULL THEN

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

4112: AND l_header_rec.header_id <> FND_API.G_MISS_NUM THEN
4113: IF l_debug_level > 0 THEN
4114: oe_debug_pub.add( 'Header id updated in msg stack:' || l_header_rec.header_id ) ;
4115: END IF;
4116: oe_msg_pub.g_msg_tbl(l_msg_index).header_id := l_header_rec.header_id;
4117: END IF;
4118: -- end bug 4195533
4119: END LOOP;
4120: <>

Line 4170: OE_MSG_PUB.save_messages (l_request_id);

4166: oe_debug_pub.add( 'BEFORE SAVING MESSAGES IN THE DATABASE TABLE' ) ;
4167: END IF;
4168:
4169: IF p_msg_count > 0 THEN
4170: OE_MSG_PUB.save_messages (l_request_id);
4171: END IF;
4172: COMMIT; /* commit again to commit the error messages */
4173:
4174:

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

4223: WHEN OTHERS THEN
4224: IF l_debug_level > 0 THEN
4225: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
4226: END IF;
4227: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4228: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4229: END IF;
4230: p_msg_count := p_msg_count + 1;
4231: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

4224: IF l_debug_level > 0 THEN
4225: oe_debug_pub.add( 'UNEXPECTED ERROR: '||SQLERRM ) ;
4226: END IF;
4227: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4228: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Import_Order');
4229: END IF;
4230: p_msg_count := p_msg_count + 1;
4231: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4232: