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

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

77: oe_debug_pub.add( 'TOO MANY ROWS IN VALIDATE RELEASE STATUS' , 1 ) ;
78: END IF;
79: x_result_out := 1;
80: WHEN OTHERS THEN
81: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
82: OE_MSG_PUB.Add_Exc_Msg
83: ( G_PKG_NAME
84: , 'Validate_Release_Status'
85: );

Line 82: OE_MSG_PUB.Add_Exc_Msg

78: END IF;
79: x_result_out := 1;
80: WHEN OTHERS THEN
81: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
82: OE_MSG_PUB.Add_Exc_Msg
83: ( G_PKG_NAME
84: , 'Validate_Release_Status'
85: );
86: END IF;

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

131: WHEN TOO_MANY_ROWS THEN
132: x_result_out := 1;
133: WHEN OTHERS THEN
134:
135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: OE_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME
139: , 'Validate_Pick'

Line 137: OE_MSG_PUB.Add_Exc_Msg

133: WHEN OTHERS THEN
134:
135: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: OE_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME
139: , 'Validate_Pick'
140: );
141: END IF;

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

248: EXCEPTION
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251:
252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: OE_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME,
256: 'Call_Process_Order'

Line 254: OE_MSG_PUB.Add_Exc_Msg

250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
251:
252: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
253: THEN
254: OE_MSG_PUB.Add_Exc_Msg
255: ( G_PKG_NAME,
256: 'Call_Process_Order'
257: );
258: END IF;

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

264: x_return_status := FND_API.G_RET_STS_ERROR;
265: WHEN OTHERS THEN
266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267:
268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: OE_MSG_PUB.Add_Exc_Msg
271: ( G_PKG_NAME,
272: 'Call_Process_Order'

Line 270: OE_MSG_PUB.Add_Exc_Msg

266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
267:
268: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
269: THEN
270: OE_MSG_PUB.Add_Exc_Msg
271: ( G_PKG_NAME,
272: 'Call_Process_Order'
273: );
274: END IF;

Line 385: OE_MSG_PUB.set_msg_context(

381: OE_Line_Util.Query_Row --bug 4516453, moved query_row here to set msg context
382: ( p_line_id => l_line_id,
383: x_line_rec => l_line_rec);
384: --- setting the msg context
385: OE_MSG_PUB.set_msg_context(
386: p_entity_code => 'LINE'
387: ,p_entity_id => l_line_rec.line_id
388: ,p_header_id => l_line_rec.header_id
389: ,p_line_id => l_line_rec.line_id

Line 1288: OE_MSG_PUB.Transfer_Msg_Stack(p_type => 'ERROR' ); --bug4741573

1284: -- 3571148 changes
1285: IF l_debug_level > 0 THEN
1286: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
1287: END IF;
1288: OE_MSG_PUB.Transfer_Msg_Stack(p_type => 'ERROR' ); --bug4741573
1289: l_msg_count := OE_MSG_PUB.COUNT_MSG;
1290:
1291: FOR I IN 1..l_msg_count LOOP
1292: l_msg_data := OE_MSG_PUB.Get(I,'F');

Line 1289: l_msg_count := OE_MSG_PUB.COUNT_MSG;

1285: IF l_debug_level > 0 THEN
1286: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
1287: END IF;
1288: OE_MSG_PUB.Transfer_Msg_Stack(p_type => 'ERROR' ); --bug4741573
1289: l_msg_count := OE_MSG_PUB.COUNT_MSG;
1290:
1291: FOR I IN 1..l_msg_count LOOP
1292: l_msg_data := OE_MSG_PUB.Get(I,'F');
1293: IF l_debug_level > 0 THEN

Line 1292: l_msg_data := OE_MSG_PUB.Get(I,'F');

1288: OE_MSG_PUB.Transfer_Msg_Stack(p_type => 'ERROR' ); --bug4741573
1289: l_msg_count := OE_MSG_PUB.COUNT_MSG;
1290:
1291: FOR I IN 1..l_msg_count LOOP
1292: l_msg_data := OE_MSG_PUB.Get(I,'F');
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add( L_MSG_DATA , 1 ) ;
1295: END IF;
1296: --code fix bug 6391881 :START

Line 1347: oe_msg_pub.delete_msg;

1343: ELSE
1344: oe_debug_pub.ADD('Bug 6391881::: Setting l_return_status to SUCCESS...', 1);
1345: l_msg_data := NULL;
1346: l_return_status := FND_API.G_RET_STS_SUCCESS;
1347: oe_msg_pub.delete_msg;
1348: END IF;
1349: ELSE -- we don't cancel a line when delivery details go missing.
1350: l_ok_to_cancel := FALSE;
1351: END IF; -- on l_exist_dd_count

Line 1446: oe_msg_pub.add_text

1442: GOTO BEFORE_CATCH_DCP;
1443:
1444: WHEN others THEN
1445: IF l_debug_level > 0 THEN
1446: oe_msg_pub.add_text
1447: ('Update_Shipping_From_OE, DCP post process'|| sqlerrm);
1448: oe_debug_pub.add('OM call to WSH DCP,others '|| sqlerrm, 1);
1449: END IF;
1450: END;

Line 1463: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');

1459: END IF;
1460:
1461: END IF;-- count is 0
1462:
1463: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1464: x_return_status := l_return_status;
1465:
1466:
1467: -- code changes for 5590106 starts here.

Line 1490: oe_msg_pub.add;

1486:
1487: IF l_cxl_dd_count > 0 THEN
1488: OE_DEBUG_PUB.add('DD is not cancelled',1);
1489: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');
1490: oe_msg_pub.add;
1491: RAISE FND_API.G_EXC_ERROR ;
1492:
1493: END IF;
1494:

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

1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508:
1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1510:
1511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1512: THEN
1513: OE_MSG_PUB.Add_Exc_Msg
1514: ( G_PKG_NAME,
1515: 'Update_Shipping_From_OE'

Line 1513: OE_MSG_PUB.Add_Exc_Msg

1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1510:
1511: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1512: THEN
1513: OE_MSG_PUB.Add_Exc_Msg
1514: ( G_PKG_NAME,
1515: 'Update_Shipping_From_OE'
1516: );
1517: END IF;

Line 1518: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

1514: ( G_PKG_NAME,
1515: 'Update_Shipping_From_OE'
1516: );
1517: END IF;
1518: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
1519: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1520: IF g_debug_call > 0 THEN
1521: G_DEBUG_MSG := G_DEBUG_MSG || 'E5';
1522: END IF;

Line 1519: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');

1515: 'Update_Shipping_From_OE'
1516: );
1517: END IF;
1518: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
1519: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1520: IF g_debug_call > 0 THEN
1521: G_DEBUG_MSG := G_DEBUG_MSG || 'E5';
1522: END IF;
1523: WHEN FND_API.G_EXC_ERROR THEN

Line 1525: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

1521: G_DEBUG_MSG := G_DEBUG_MSG || 'E5';
1522: END IF;
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
1526: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1527: IF g_debug_call > 0 THEN
1528: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-4';
1529: END IF;

Line 1526: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');

1522: END IF;
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: x_return_status := FND_API.G_RET_STS_ERROR;
1525: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
1526: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1527: IF g_debug_call > 0 THEN
1528: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-4';
1529: END IF;
1530: WHEN OTHERS THEN

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

1529: END IF;
1530: WHEN OTHERS THEN
1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1532:
1533: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1534: THEN
1535: OE_MSG_PUB.Add_Exc_Msg
1536: ( G_PKG_NAME,
1537: 'Update_Shipping_From_OE'

Line 1535: OE_MSG_PUB.Add_Exc_Msg

1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1532:
1533: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1534: THEN
1535: OE_MSG_PUB.Add_Exc_Msg
1536: ( G_PKG_NAME,
1537: 'Update_Shipping_From_OE'
1538: );
1539: END IF;

Line 1543: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

1539: END IF;
1540: IF l_debug_level > 0 THEN
1541: oe_debug_pub.add( 'ERROR MESSAGE : '||SQLERRM , 1 ) ;
1542: END IF;
1543: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
1544: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1545: IF g_debug_call > 0 THEN
1546: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-5';
1547: END IF;

Line 1544: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');

1540: IF l_debug_level > 0 THEN
1541: oe_debug_pub.add( 'ERROR MESSAGE : '||SQLERRM , 1 ) ;
1542: END IF;
1543: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
1544: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1545: IF g_debug_call > 0 THEN
1546: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-5';
1547: END IF;
1548: END Update_Shipping_From_OE;

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

1613:
1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1616:
1617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1618: THEN
1619: OE_MSG_PUB.Add_Exc_Msg
1620: ( G_PKG_NAME,
1621: 'Update_Shipping_PVT'

Line 1619: OE_MSG_PUB.Add_Exc_Msg

1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1616:
1617: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1618: THEN
1619: OE_MSG_PUB.Add_Exc_Msg
1620: ( G_PKG_NAME,
1621: 'Update_Shipping_PVT'
1622: );
1623: END IF;

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

1628: x_return_status := FND_API.G_RET_STS_ERROR;
1629: WHEN OTHERS THEN
1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1631:
1632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1633: THEN
1634: OE_MSG_PUB.Add_Exc_Msg
1635: ( G_PKG_NAME,
1636: 'Update_Shipping_PVT'

Line 1634: OE_MSG_PUB.Add_Exc_Msg

1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1631:
1632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1633: THEN
1634: OE_MSG_PUB.Add_Exc_Msg
1635: ( G_PKG_NAME,
1636: 'Update_Shipping_PVT'
1637: );
1638: END IF;

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

2065: EXCEPTION
2066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2068:
2069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2070: THEN
2071: OE_MSG_PUB.Add_Exc_Msg
2072: ( G_PKG_NAME,
2073: 'Check_Shipment_Line'

Line 2071: OE_MSG_PUB.Add_Exc_Msg

2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2068:
2069: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2070: THEN
2071: OE_MSG_PUB.Add_Exc_Msg
2072: ( G_PKG_NAME,
2073: 'Check_Shipment_Line'
2074: );
2075: END IF;

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

2078: END IF;
2079:
2080: WHEN OTHERS THEN
2081:
2082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2083: THEN
2084: OE_MSG_PUB.Add_Exc_Msg
2085: (G_PKG_NAME,
2086: 'CHeck_Shipment_Line'

Line 2084: OE_MSG_PUB.Add_Exc_Msg

2080: WHEN OTHERS THEN
2081:
2082: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2083: THEN
2084: OE_MSG_PUB.Add_Exc_Msg
2085: (G_PKG_NAME,
2086: 'CHeck_Shipment_Line'
2087: );
2088: END IF;

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

2447: EXCEPTION
2448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2450:
2451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2452: THEN
2453: OE_MSG_PUB.Add_Exc_Msg
2454: ( G_PKG_NAME,
2455: 'Get_PTO_Shipped_Quantity'

Line 2453: OE_MSG_PUB.Add_Exc_Msg

2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2450:
2451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2452: THEN
2453: OE_MSG_PUB.Add_Exc_Msg
2454: ( G_PKG_NAME,
2455: 'Get_PTO_Shipped_Quantity'
2456: );
2457: END IF;

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

2467:
2468: WHEN OTHERS THEN
2469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2470:
2471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2472: THEN
2473: OE_MSG_PUB.Add_Exc_Msg
2474: ( G_PKG_NAME,
2475: 'Get_PTO_Shipped_Quantity'

Line 2473: OE_MSG_PUB.Add_Exc_Msg

2469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2470:
2471: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2472: THEN
2473: OE_MSG_PUB.Add_Exc_Msg
2474: ( G_PKG_NAME,
2475: 'Get_PTO_Shipped_Quantity'
2476: );
2477: END IF;

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

3263: EXCEPTION
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3266:
3267: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3268: THEN
3269: OE_MSG_PUB.Add_Exc_Msg
3270: ( G_PKG_NAME
3271: , 'Ship_Confirm_PTO_KIT'

Line 3269: OE_MSG_PUB.Add_Exc_Msg

3265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3266:
3267: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3268: THEN
3269: OE_MSG_PUB.Add_Exc_Msg
3270: ( G_PKG_NAME
3271: , 'Ship_Confirm_PTO_KIT'
3272: );
3273: END IF;

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

3286: G_DEBUG_MSG := G_DEBUG_MSG || 'E9';
3287: END IF;
3288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3289:
3290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3291: THEN
3292: OE_MSG_PUB.Add_Exc_Msg
3293: ( G_PKG_NAME
3294: , 'Ship_Confirm_PTO_KIT'

Line 3292: OE_MSG_PUB.Add_Exc_Msg

3288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3289:
3290: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3291: THEN
3292: OE_MSG_PUB.Add_Exc_Msg
3293: ( G_PKG_NAME
3294: , 'Ship_Confirm_PTO_KIT'
3295: );
3296: END IF;

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

3835: EXCEPTION
3836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3838:
3839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3840: THEN
3841: OE_MSG_PUB.Add_Exc_Msg
3842: ( G_PKG_NAME,
3843: 'Ship_Confirm_Standard_Line'

Line 3841: OE_MSG_PUB.Add_Exc_Msg

3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3838:
3839: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3840: THEN
3841: OE_MSG_PUB.Add_Exc_Msg
3842: ( G_PKG_NAME,
3843: 'Ship_Confirm_Standard_Line'
3844: );
3845: END IF;

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

3861: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
3862: END IF;
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3864:
3865: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3866: THEN
3867: OE_MSG_PUB.Add_Exc_Msg
3868: ( G_PKG_NAME,
3869: 'Ship_Confirm_Standard_Line'

Line 3867: OE_MSG_PUB.Add_Exc_Msg

3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3864:
3865: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3866: THEN
3867: OE_MSG_PUB.Add_Exc_Msg
3868: ( G_PKG_NAME,
3869: 'Ship_Confirm_Standard_Line'
3870: );
3871: END IF;

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

4181: EXCEPTION
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4184:
4185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4186: THEN
4187: OE_MSG_PUB.Add_Exc_Msg
4188: (G_PKG_NAME,
4189: 'Ship_Confirm_ATO');

Line 4187: OE_MSG_PUB.Add_Exc_Msg

4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4184:
4185: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4186: THEN
4187: OE_MSG_PUB.Add_Exc_Msg
4188: (G_PKG_NAME,
4189: 'Ship_Confirm_ATO');
4190: END IF;
4191: IF g_debug_call > 0 THEN

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

4203: oe_debug_pub.add('ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
4204: END IF;
4205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4206:
4207: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4208: THEN
4209: OE_MSG_PUB.Add_Exc_Msg
4210: ( G_PKG_NAME,
4211: 'Ship_Confirm_ATO');

Line 4209: OE_MSG_PUB.Add_Exc_Msg

4205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4206:
4207: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4208: THEN
4209: OE_MSG_PUB.Add_Exc_Msg
4210: ( G_PKG_NAME,
4211: 'Ship_Confirm_ATO');
4212: END IF;
4213: IF g_debug_call > 0 THEN

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

4494: EXCEPTION
4495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4497:
4498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4499: THEN
4500: OE_MSG_PUB.Add_Exc_Msg
4501: ( G_PKG_NAME,
4502: 'Ship_Confirm_Ship_Set'

Line 4500: OE_MSG_PUB.Add_Exc_Msg

4496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4497:
4498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4499: THEN
4500: OE_MSG_PUB.Add_Exc_Msg
4501: ( G_PKG_NAME,
4502: 'Ship_Confirm_Ship_Set'
4503: );
4504: END IF;

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

4513: END IF;
4514: WHEN OTHERS THEN
4515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4516:
4517: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4518: THEN
4519: OE_MSG_PUB.Add_Exc_Msg
4520: ( G_PKG_NAME,
4521: 'Ship_Confirm_Ship_Set'

Line 4519: OE_MSG_PUB.Add_Exc_Msg

4515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4516:
4517: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4518: THEN
4519: OE_MSG_PUB.Add_Exc_Msg
4520: ( G_PKG_NAME,
4521: 'Ship_Confirm_Ship_Set'
4522: );
4523: END IF;

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

4667: END IF;
4668:
4669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4670:
4671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4672: THEN
4673: OE_MSG_PUB.Add_Exc_Msg
4674: ( G_PKG_NAME,
4675: 'Process_Ship_Confirm'

Line 4673: OE_MSG_PUB.Add_Exc_Msg

4669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4670:
4671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4672: THEN
4673: OE_MSG_PUB.Add_Exc_Msg
4674: ( G_PKG_NAME,
4675: 'Process_Ship_Confirm'
4676: );
4677: END IF;

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

4697: G_DEBUG_MSG := G_DEBUG_MSG || 'E-32';
4698: END IF;
4699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4700:
4701: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4702: THEN
4703: OE_MSG_PUB.Add_Exc_Msg
4704: ( G_PKG_NAME,
4705: 'Process_Ship_Confirm'

Line 4703: OE_MSG_PUB.Add_Exc_Msg

4699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4700:
4701: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4702: THEN
4703: OE_MSG_PUB.Add_Exc_Msg
4704: ( G_PKG_NAME,
4705: 'Process_Ship_Confirm'
4706: );
4707: END IF;

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

5333: oe_debug_pub.add( 'PROCESS_SHIPPING_ACTIVITY : UNEXPECTED ERROR' , 1 ) ;
5334: END IF;
5335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5336:
5337: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5338: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5339: 'Process_Shipping_Activity');
5340: END IF;
5341: IF g_debug_call > 0 THEN

Line 5338: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5334: END IF;
5335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5336:
5337: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5338: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5339: 'Process_Shipping_Activity');
5340: END IF;
5341: IF g_debug_call > 0 THEN
5342: G_DEBUG_MSG := G_DEBUG_MSG || 'E-33';

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

5360: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
5361: END IF;
5362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5363:
5364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5365: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5366: 'Process_Shipping_Activity');
5367: END IF;
5368:

Line 5365: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5361: END IF;
5362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5363:
5364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5365: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5366: 'Process_Shipping_Activity');
5367: END IF;
5368:
5369: -- Get message count and data

Line 5371: OE_MSG_PUB.Count_And_Get

5367: END IF;
5368:
5369: -- Get message count and data
5370:
5371: OE_MSG_PUB.Count_And_Get
5372: ( p_count => x_msg_count
5373: ,p_data => x_msg_data);
5374: IF g_debug_call > 0 THEN
5375: G_DEBUG_MSG := G_DEBUG_MSG || 'E-35';

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

5665: oe_debug_pub.add( 'PROCESS_SMC_SHIPPING : UNEXPECTED ERROR' , 1 ) ;
5666: END IF;
5667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5668:
5669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5670: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5671: 'Process_SMC_Shipping');
5672: END IF;
5673: IF g_debug_call > 0 THEN

Line 5670: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5666: END IF;
5667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5668:
5669: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5670: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5671: 'Process_SMC_Shipping');
5672: END IF;
5673: IF g_debug_call > 0 THEN
5674: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-36';

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

5692: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
5693: END IF;
5694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5695:
5696: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5697: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5698: 'Process_SMC_Shipping');
5699: END IF;
5700: IF g_debug_call > 0 THEN

Line 5697: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5693: END IF;
5694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5695:
5696: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5697: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5698: 'Process_SMC_Shipping');
5699: END IF;
5700: IF g_debug_call > 0 THEN
5701: G_DEBUG_MSG := G_DEBUG_MSG || 'E-38';

Line 6147: --oe_msg_pub.add;

6143: END IF;
6144:
6145: fnd_message.set_name('ONT','OE_SHP_ERROR');
6146: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_error_msg);
6147: --oe_msg_pub.add;
6148:
6149: OE_BULK_MSG_PUB.ADD;
6150: oe_debug_pub.add('here again 2 ', 5);
6151:

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

6175: END IF;
6176:
6177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6178:
6179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6180: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6181: 'OM_To_WSH_Interface');
6182: END IF;
6183: IF g_debug_call > 0 THEN

Line 6180: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6176:
6177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6178:
6179: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6180: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6181: 'OM_To_WSH_Interface');
6182: END IF;
6183: IF g_debug_call > 0 THEN
6184: G_DEBUG_MSG := G_DEBUG_MSG || 'E-39';

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

6199: oe_debug_pub.add('ERROR MESSAGE : '||SUBSTR(SQLERRM ,1,100),1);
6200: END IF;
6201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6202:
6203: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6204: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6205: 'OM_To_WSH_Interface');
6206: END IF;
6207:

Line 6204: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6200: END IF;
6201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6202:
6203: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6204: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6205: 'OM_To_WSH_Interface');
6206: END IF;
6207:
6208: END OM_To_WSH_Interface;

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

6288: end if;
6289:
6290: WHEN OTHERS THEN
6291:
6292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6293: THEN
6294: OE_MSG_PUB.Add_Exc_Msg
6295: ( G_PKG_NAME
6296: , 'ship_complete'

Line 6294: OE_MSG_PUB.Add_Exc_Msg

6290: WHEN OTHERS THEN
6291:
6292: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6293: THEN
6294: OE_MSG_PUB.Add_Exc_Msg
6295: ( G_PKG_NAME
6296: , 'ship_complete'
6297: );
6298: END IF;