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 383: OE_MSG_PUB.set_msg_context(

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

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

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

Line 1284: l_msg_count := OE_MSG_PUB.COUNT_MSG;

1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
1282: END IF;
1283: OE_MSG_PUB.Transfer_Msg_Stack(p_type => 'ERROR' ); --bug4741573
1284: l_msg_count := OE_MSG_PUB.COUNT_MSG;
1285:
1286: FOR I IN 1..l_msg_count LOOP
1287: l_msg_data := OE_MSG_PUB.Get(I,'F');
1288: IF l_debug_level > 0 THEN

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

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

Line 1342: oe_msg_pub.delete_msg;

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

Line 1441: oe_msg_pub.add_text

1437: GOTO BEFORE_CATCH_DCP;
1438:
1439: WHEN others THEN
1440: IF l_debug_level > 0 THEN
1441: oe_msg_pub.add_text
1442: ('Update_Shipping_From_OE, DCP post process'|| sqlerrm);
1443: oe_debug_pub.add('OM call to WSH DCP,others '|| sqlerrm, 1);
1444: END IF;
1445: END;

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

1454: END IF;
1455:
1456: END IF;-- count is 0
1457:
1458: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'LINE');
1459: x_return_status := l_return_status;
1460:
1461:
1462: -- code changes for 5590106 starts here.

Line 1485: oe_msg_pub.add;

1481:
1482: IF l_cxl_dd_count > 0 THEN
1483: OE_DEBUG_PUB.add('DD is not cancelled',1);
1484: fnd_message.set_name('ONT', 'OE_CANCEL_NOTHING');
1485: oe_msg_pub.add;
1486: RAISE FND_API.G_EXC_ERROR ;
1487:
1488: END IF;
1489:

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

1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1504:
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506:
1507: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1508: THEN
1509: OE_MSG_PUB.Add_Exc_Msg
1510: ( G_PKG_NAME,
1511: 'Update_Shipping_From_OE'

Line 1509: OE_MSG_PUB.Add_Exc_Msg

1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506:
1507: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1508: THEN
1509: OE_MSG_PUB.Add_Exc_Msg
1510: ( G_PKG_NAME,
1511: 'Update_Shipping_From_OE'
1512: );
1513: END IF;

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

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

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

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

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

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

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

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

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

1525: END IF;
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528:
1529: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1530: THEN
1531: OE_MSG_PUB.Add_Exc_Msg
1532: ( G_PKG_NAME,
1533: 'Update_Shipping_From_OE'

Line 1531: OE_MSG_PUB.Add_Exc_Msg

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

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

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

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

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

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

1609:
1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612:
1613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: OE_MSG_PUB.Add_Exc_Msg
1616: ( G_PKG_NAME,
1617: 'Update_Shipping_PVT'

Line 1615: OE_MSG_PUB.Add_Exc_Msg

1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612:
1613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: OE_MSG_PUB.Add_Exc_Msg
1616: ( G_PKG_NAME,
1617: 'Update_Shipping_PVT'
1618: );
1619: END IF;

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

1624: x_return_status := FND_API.G_RET_STS_ERROR;
1625: WHEN OTHERS THEN
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1627:
1628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: OE_MSG_PUB.Add_Exc_Msg
1631: ( G_PKG_NAME,
1632: 'Update_Shipping_PVT'

Line 1630: OE_MSG_PUB.Add_Exc_Msg

1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1627:
1628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: OE_MSG_PUB.Add_Exc_Msg
1631: ( G_PKG_NAME,
1632: 'Update_Shipping_PVT'
1633: );
1634: END IF;

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

2061: EXCEPTION
2062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064:
2065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2066: THEN
2067: OE_MSG_PUB.Add_Exc_Msg
2068: ( G_PKG_NAME,
2069: 'Check_Shipment_Line'

Line 2067: OE_MSG_PUB.Add_Exc_Msg

2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064:
2065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2066: THEN
2067: OE_MSG_PUB.Add_Exc_Msg
2068: ( G_PKG_NAME,
2069: 'Check_Shipment_Line'
2070: );
2071: END IF;

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

2074: END IF;
2075:
2076: WHEN OTHERS THEN
2077:
2078: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: OE_MSG_PUB.Add_Exc_Msg
2081: (G_PKG_NAME,
2082: 'CHeck_Shipment_Line'

Line 2080: OE_MSG_PUB.Add_Exc_Msg

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

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

2435: EXCEPTION
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2438:
2439: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2440: THEN
2441: OE_MSG_PUB.Add_Exc_Msg
2442: ( G_PKG_NAME,
2443: 'Get_PTO_Shipped_Quantity'

Line 2441: OE_MSG_PUB.Add_Exc_Msg

2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2438:
2439: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2440: THEN
2441: OE_MSG_PUB.Add_Exc_Msg
2442: ( G_PKG_NAME,
2443: 'Get_PTO_Shipped_Quantity'
2444: );
2445: END IF;

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

2455:
2456: WHEN OTHERS THEN
2457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2458:
2459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2460: THEN
2461: OE_MSG_PUB.Add_Exc_Msg
2462: ( G_PKG_NAME,
2463: 'Get_PTO_Shipped_Quantity'

Line 2461: OE_MSG_PUB.Add_Exc_Msg

2457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2458:
2459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2460: THEN
2461: OE_MSG_PUB.Add_Exc_Msg
2462: ( G_PKG_NAME,
2463: 'Get_PTO_Shipped_Quantity'
2464: );
2465: END IF;

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

3251: EXCEPTION
3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3254:
3255: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3256: THEN
3257: OE_MSG_PUB.Add_Exc_Msg
3258: ( G_PKG_NAME
3259: , 'Ship_Confirm_PTO_KIT'

Line 3257: OE_MSG_PUB.Add_Exc_Msg

3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3254:
3255: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3256: THEN
3257: OE_MSG_PUB.Add_Exc_Msg
3258: ( G_PKG_NAME
3259: , 'Ship_Confirm_PTO_KIT'
3260: );
3261: END IF;

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

3274: G_DEBUG_MSG := G_DEBUG_MSG || 'E9';
3275: END IF;
3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3277:
3278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3279: THEN
3280: OE_MSG_PUB.Add_Exc_Msg
3281: ( G_PKG_NAME
3282: , 'Ship_Confirm_PTO_KIT'

Line 3280: OE_MSG_PUB.Add_Exc_Msg

3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3277:
3278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3279: THEN
3280: OE_MSG_PUB.Add_Exc_Msg
3281: ( G_PKG_NAME
3282: , 'Ship_Confirm_PTO_KIT'
3283: );
3284: END IF;

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

3823: EXCEPTION
3824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3826:
3827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN
3829: OE_MSG_PUB.Add_Exc_Msg
3830: ( G_PKG_NAME,
3831: 'Ship_Confirm_Standard_Line'

Line 3829: OE_MSG_PUB.Add_Exc_Msg

3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3826:
3827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN
3829: OE_MSG_PUB.Add_Exc_Msg
3830: ( G_PKG_NAME,
3831: 'Ship_Confirm_Standard_Line'
3832: );
3833: END IF;

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

3849: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
3850: END IF;
3851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3852:
3853: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3854: THEN
3855: OE_MSG_PUB.Add_Exc_Msg
3856: ( G_PKG_NAME,
3857: 'Ship_Confirm_Standard_Line'

Line 3855: OE_MSG_PUB.Add_Exc_Msg

3851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3852:
3853: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3854: THEN
3855: OE_MSG_PUB.Add_Exc_Msg
3856: ( G_PKG_NAME,
3857: 'Ship_Confirm_Standard_Line'
3858: );
3859: END IF;

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

4167: EXCEPTION
4168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4170:
4171: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4172: THEN
4173: OE_MSG_PUB.Add_Exc_Msg
4174: (G_PKG_NAME,
4175: 'Ship_Confirm_ATO');

Line 4173: OE_MSG_PUB.Add_Exc_Msg

4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4170:
4171: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4172: THEN
4173: OE_MSG_PUB.Add_Exc_Msg
4174: (G_PKG_NAME,
4175: 'Ship_Confirm_ATO');
4176: END IF;
4177: IF g_debug_call > 0 THEN

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

4189: oe_debug_pub.add('ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
4190: END IF;
4191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4192:
4193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4194: THEN
4195: OE_MSG_PUB.Add_Exc_Msg
4196: ( G_PKG_NAME,
4197: 'Ship_Confirm_ATO');

Line 4195: OE_MSG_PUB.Add_Exc_Msg

4191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4192:
4193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4194: THEN
4195: OE_MSG_PUB.Add_Exc_Msg
4196: ( G_PKG_NAME,
4197: 'Ship_Confirm_ATO');
4198: END IF;
4199: IF g_debug_call > 0 THEN

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

4478: EXCEPTION
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: OE_MSG_PUB.Add_Exc_Msg
4485: ( G_PKG_NAME,
4486: 'Ship_Confirm_Ship_Set'

Line 4484: OE_MSG_PUB.Add_Exc_Msg

4480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: OE_MSG_PUB.Add_Exc_Msg
4485: ( G_PKG_NAME,
4486: 'Ship_Confirm_Ship_Set'
4487: );
4488: END IF;

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

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

Line 4503: OE_MSG_PUB.Add_Exc_Msg

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

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

4649: END IF;
4650:
4651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4652:
4653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4654: THEN
4655: OE_MSG_PUB.Add_Exc_Msg
4656: ( G_PKG_NAME,
4657: 'Process_Ship_Confirm'

Line 4655: OE_MSG_PUB.Add_Exc_Msg

4651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4652:
4653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4654: THEN
4655: OE_MSG_PUB.Add_Exc_Msg
4656: ( G_PKG_NAME,
4657: 'Process_Ship_Confirm'
4658: );
4659: END IF;

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

4679: G_DEBUG_MSG := G_DEBUG_MSG || 'E-32';
4680: END IF;
4681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4682:
4683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4684: THEN
4685: OE_MSG_PUB.Add_Exc_Msg
4686: ( G_PKG_NAME,
4687: 'Process_Ship_Confirm'

Line 4685: OE_MSG_PUB.Add_Exc_Msg

4681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4682:
4683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4684: THEN
4685: OE_MSG_PUB.Add_Exc_Msg
4686: ( G_PKG_NAME,
4687: 'Process_Ship_Confirm'
4688: );
4689: END IF;

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

5313: oe_debug_pub.add( 'PROCESS_SHIPPING_ACTIVITY : UNEXPECTED ERROR' , 1 ) ;
5314: END IF;
5315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5316:
5317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5318: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5319: 'Process_Shipping_Activity');
5320: END IF;
5321: IF g_debug_call > 0 THEN

Line 5318: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5314: END IF;
5315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5316:
5317: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5318: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5319: 'Process_Shipping_Activity');
5320: END IF;
5321: IF g_debug_call > 0 THEN
5322: G_DEBUG_MSG := G_DEBUG_MSG || 'E-33';

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

5340: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
5341: END IF;
5342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5343:
5344: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5345: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5346: 'Process_Shipping_Activity');
5347: END IF;
5348:

Line 5345: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5341: END IF;
5342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5343:
5344: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5345: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5346: 'Process_Shipping_Activity');
5347: END IF;
5348:
5349: -- Get message count and data

Line 5351: OE_MSG_PUB.Count_And_Get

5347: END IF;
5348:
5349: -- Get message count and data
5350:
5351: OE_MSG_PUB.Count_And_Get
5352: ( p_count => x_msg_count
5353: ,p_data => x_msg_data);
5354: IF g_debug_call > 0 THEN
5355: G_DEBUG_MSG := G_DEBUG_MSG || 'E-35';

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

5640: oe_debug_pub.add( 'PROCESS_SMC_SHIPPING : UNEXPECTED ERROR' , 1 ) ;
5641: END IF;
5642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5643:
5644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5645: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5646: 'Process_SMC_Shipping');
5647: END IF;
5648: IF g_debug_call > 0 THEN

Line 5645: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

5641: END IF;
5642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5643:
5644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5645: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5646: 'Process_SMC_Shipping');
5647: END IF;
5648: IF g_debug_call > 0 THEN
5649: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-36';

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

5667: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
5668: END IF;
5669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5670:
5671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5672: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
5673: 'Process_SMC_Shipping');
5674: END IF;
5675: IF g_debug_call > 0 THEN

Line 5672: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

Line 6122: --oe_msg_pub.add;

6118: END IF;
6119:
6120: fnd_message.set_name('ONT','OE_SHP_ERROR');
6121: FND_MESSAGE.SET_TOKEN('ERROR_MESSAGE',l_error_msg);
6122: --oe_msg_pub.add;
6123:
6124: OE_BULK_MSG_PUB.ADD;
6125: oe_debug_pub.add('here again 2 ', 5);
6126:

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

6150: END IF;
6151:
6152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6153:
6154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6155: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6156: 'OM_To_WSH_Interface');
6157: END IF;
6158: IF g_debug_call > 0 THEN

Line 6155: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

6151:
6152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6153:
6154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6155: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6156: 'OM_To_WSH_Interface');
6157: END IF;
6158: IF g_debug_call > 0 THEN
6159: G_DEBUG_MSG := G_DEBUG_MSG || 'E-39';

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

6174: oe_debug_pub.add('ERROR MESSAGE : '||SUBSTR(SQLERRM ,1,100),1);
6175: END IF;
6176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6177:
6178: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6179: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6180: 'OM_To_WSH_Interface');
6181: END IF;
6182:

Line 6179: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

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

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

6263: end if;
6264:
6265: WHEN OTHERS THEN
6266:
6267: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6268: THEN
6269: OE_MSG_PUB.Add_Exc_Msg
6270: ( G_PKG_NAME
6271: , 'ship_complete'

Line 6269: OE_MSG_PUB.Add_Exc_Msg

6265: WHEN OTHERS THEN
6266:
6267: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6268: THEN
6269: OE_MSG_PUB.Add_Exc_Msg
6270: ( G_PKG_NAME
6271: , 'ship_complete'
6272: );
6273: END IF;