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 FND_API

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: G_DEBUG_MSG := G_DEBUG_MSG || '4';
246: END IF;
247:
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

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

246: END IF;
247:
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

Line 263: WHEN FND_API.G_EXC_ERROR THEN

259: IF g_debug_call > 0 THEN
260: G_DEBUG_MSG := G_DEBUG_MSG || 'E4';
261: END IF;
262:
263: WHEN FND_API.G_EXC_ERROR THEN
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:

Line 264: x_return_status := FND_API.G_RET_STS_ERROR;

260: G_DEBUG_MSG := G_DEBUG_MSG || 'E4';
261: END IF;
262:
263: WHEN FND_API.G_EXC_ERROR THEN
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)

Line 266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

262:
263: WHEN FND_API.G_EXC_ERROR THEN
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

Line 310: l_line_at_shipping VARCHAR2(1) := FND_API.G_FALSE;

306: l_changed_attributes WSH_INTERFACE.ChangedAttributeTabType;
307: l_line_rec OE_Order_Pub.line_rec_type;
308: l_line_id NUMBER;
309: l_return_status VARCHAR2(1);
310: l_line_at_shipping VARCHAR2(1) := FND_API.G_FALSE;
311: l_result_out VARCHAR2(30);
312: l_source_code VARCHAR2(2) := 'OE';
313: l_msg_count NUMBER;
314: l_msg_data VARCHAR2(2000);

Line 379: l_line_at_shipping := FND_API.G_FALSE;

375: FOR l_line_index IN p_update_lines_tbl.First .. p_update_lines_tbl.Last
376: LOOP
377:
378: l_line_id := p_update_lines_tbl(l_line_index).entity_id;
379: l_line_at_shipping := FND_API.G_FALSE;
380:
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);

Line 455: IF p_update_lines_tbl(l_line_index).param2 = FND_API.G_TRUE THEN

451: -- the current activity is shipping for the line.
452: -- this code is not required and explosion date never changes.
453:
454:
455: IF p_update_lines_tbl(l_line_index).param2 = FND_API.G_TRUE THEN
456: IF g_debug_call > 0 THEN
457: G_DEBUG_MSG := G_DEBUG_MSG || '7,';
458: END IF;
459:

Line 461: (1.0, l_line_id) = FND_API.G_TRUE THEN

457: G_DEBUG_MSG := G_DEBUG_MSG || '7,';
458: END IF;
459:
460: IF OE_Shipping_Integration_PUB.Is_Activity_Shipping
461: (1.0, l_line_id) = FND_API.G_TRUE THEN
462:
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add
465: ('explosion date changed, line is at ship '|| l_line_id,3);

Line 468: l_line_at_shipping := FND_API.G_TRUE;

464: oe_debug_pub.add
465: ('explosion date changed, line is at ship '|| l_line_id,3);
466: END IF;
467:
468: l_line_at_shipping := FND_API.G_TRUE;
469: ELSE
470: IF g_debug_call > 0 THEN
471: G_DEBUG_MSG := G_DEBUG_MSG || '8,';
472: END IF;

Line 490: := FND_API.G_MISS_CHAR;

486: ----------- Assign the values to table for Shipping ---------
487:
488: l_shp_index := l_shp_index + 1;
489: l_changed_attributes(l_shp_index).released_status
490: := FND_API.G_MISS_CHAR;
491:
492: -- Line is at SHIP_LINE call shipping with action code 'I'
493: -- If the line is not yet interfaced
494:

Line 495: IF p_update_lines_tbl(l_line_index).param4 = FND_API.G_TRUE THEN

491:
492: -- Line is at SHIP_LINE call shipping with action code 'I'
493: -- If the line is not yet interfaced
494:
495: IF p_update_lines_tbl(l_line_index).param4 = FND_API.G_TRUE THEN
496:
497: IF l_debug_level > 0 THEN
498: oe_debug_pub.add('line at shipping, update released flag '
499: || TO_CHAR ( L_LINE_ID ) , 3 ) ;

Line 542: IF p_update_lines_tbl(l_line_index).param2 = FND_API.G_TRUE

538:
539: -- Check If only explosion date has changed and the current activity
540: -- is shipping for the line.
541:
542: IF p_update_lines_tbl(l_line_index).param2 = FND_API.G_TRUE
543: AND l_line_at_shipping = FND_API.G_TRUE THEN
544:
545: IF l_debug_level > 0 THEN
546: oe_debug_pub.add('explosion date changed, activity shipping '

Line 543: AND l_line_at_shipping = FND_API.G_TRUE THEN

539: -- Check If only explosion date has changed and the current activity
540: -- is shipping for the line.
541:
542: IF p_update_lines_tbl(l_line_index).param2 = FND_API.G_TRUE
543: AND l_line_at_shipping = FND_API.G_TRUE THEN
544:
545: IF l_debug_level > 0 THEN
546: oe_debug_pub.add('explosion date changed, activity shipping '
547: || TO_CHAR ( L_LINE_ID ) , 3 ) ;

Line 676: l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN

672: ||L_CHANGED_ATTRIBUTES ( L_SHP_INDEX ) .ACTION_FLAG , 3 ) ;
673: END IF;
674:
675: IF l_line_rec.shipped_quantity IS NOT NULL AND
676: l_line_rec.shipped_quantity <> FND_API.G_MISS_NUM THEN
677: l_changed_attributes(l_shp_index).shipped_flag := 'Y';
678: ELSE
679: l_changed_attributes(l_shp_index).shipped_flag := 'N';
680: END IF;

Line 702: IF p_update_lines_tbl(l_line_index).param5 = FND_API.G_TRUE AND

698: oe_debug_pub.add(p_update_lines_tbl(l_line_index).param5
699: || '-- param5---', 1);
700: END IF;
701:
702: IF p_update_lines_tbl(l_line_index).param5 = FND_API.G_TRUE AND
703: nvl(l_line_rec.shipped_quantity,0) = 0 AND
704: nvl(l_line_rec.ordered_quantity,0) <> 0 AND -- bug 2129287
705: nvl(l_line_rec.ship_tolerance_below,0) < 100 THEN --1829490
706: IF g_debug_call > 0 THEN

Line 802: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

798: oe_debug_pub.add( 'global picture index: '
799: || L_INDEX , 1 ) ;
800: END IF;
801:
802: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
803: RAISE FND_API.G_EXC_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;

Line 803: RAISE FND_API.G_EXC_ERROR;

799: || L_INDEX , 1 ) ;
800: END IF;
801:
802: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
803: RAISE FND_API.G_EXC_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:

Line 804: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

800: END IF;
801:
802: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
803: RAISE FND_API.G_EXC_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: IF l_index IS NOT NULL THEN

Line 805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

801:
802: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
803: RAISE FND_API.G_EXC_ERROR;
804: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
806: END IF;
807:
808: IF l_index IS NOT NULL THEN
809:

Line 858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

854: oe_debug_pub.add
855: ('return status Process_Requests_And_Notify() '||L_RETURN_STATUS , 3 ) ;
856: END IF;
857:
858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
861: THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 859: RAISE FND_API.G_EXC_ERROR;

855: ('return status Process_Requests_And_Notify() '||L_RETURN_STATUS , 3 ) ;
856: END IF;
857:
858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
861: THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;

Line 860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

856: END IF;
857:
858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
861: THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864: END IF; -- aso_installed

Line 862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

858: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR
861: THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: END IF;
864: END IF; -- aso_installed
865: END IF; -- code_release_level
866:

Line 891: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

887: x_return_status => l_return_status,
888: x_msg_count => l_msg_count,
889: x_msg_data => l_msg_data);
890:
891: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add
894: (' ( MLP_DBG ) CALL TO GET_OPM_ITEM_FROM APPS FAILED' , 1 ) ;
895: END IF;

Line 896: RAISE FND_API.G_EXC_ERROR;

892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add
894: (' ( MLP_DBG ) CALL TO GET_OPM_ITEM_FROM APPS FAILED' , 1 ) ;
895: END IF;
896: RAISE FND_API.G_EXC_ERROR;
897: END IF; */
898:
899: IF oe_line_util.dual_uom_control -- INVCONV Process_Characteristics
900: (l_line_rec.inventory_item_id,l_line_rec.ship_from_org_id,l_item_rec) THEN

Line 941: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

937: x_return_status => l_return_status);
938: IF g_debug_call > 0 THEN
939: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-4-31';
940: END IF;
941: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;

Line 942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

938: IF g_debug_call > 0 THEN
939: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-4-31';
940: END IF;
941: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946:

Line 943: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

939: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-4-31';
940: END IF;
941: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946:
947: IF l_line_rec.arrival_set_id IS NOT NULL AND

Line 944: RAISE FND_API.G_EXC_ERROR;

940: END IF;
941: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946:
947: IF l_line_rec.arrival_set_id IS NOT NULL AND
948: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN

Line 948: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN

944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946:
947: IF l_line_rec.arrival_set_id IS NOT NULL AND
948: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN
949: -- Update the set status to closed.
950: UPDATE OE_SETS
951: SET SET_STATUS = 'C'
952: WHERE SET_ID = l_line_rec.arrival_set_id;

Line 1273: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1269: IF g_debug_call > 0 THEN
1270: G_DEBUG_MSG := G_DEBUG_MSG || '46,';
1271: END IF;
1272:
1273: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1274:
1275: --Changes for Bug - 2898616
1276: IF l_force_ui = 'Y' THEN
1277: IF l_debug_level > 0 THEN

Line 1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1278: oe_debug_pub.add('Setting the global to force UI Block',2);
1279: END IF;
1280: OE_GLOBALS.G_FORCE_CLEAR_UI_BLOCK := 'Y';
1281: END IF;
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1284: -- 3571148 changes
1285: IF l_debug_level > 0 THEN
1286: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;

Line 1283: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1279: END IF;
1280: OE_GLOBALS.G_FORCE_CLEAR_UI_BLOCK := 'Y';
1281: END IF;
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1284: -- 3571148 changes
1285: IF l_debug_level > 0 THEN
1286: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
1287: END IF;

Line 1346: l_return_status := FND_API.G_RET_STS_SUCCESS;

1342: l_ok_to_cancel := FALSE;
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;

Line 1373: RAISE fnd_api.g_exc_error;

1369: oe_debug_pub.ADD('Bug 6391881::: l_ok_to_cancel is false.', 1);
1370: END IF;
1371:
1372: IF NOT ( l_wsh_no_data_found = TRUE AND l_ok_to_cancel = TRUE ) THEN
1373: RAISE fnd_api.g_exc_error;
1374: END IF;
1375: -- End: Changes for bug 6391881
1376:
1377: IF g_debug_call > 0 THEN

Line 1456: l_return_status := FND_API.G_RET_STS_SUCCESS;

1452: END IF; -- return status check
1453:
1454: ELSE
1455:
1456: l_return_status := FND_API.G_RET_STS_SUCCESS;
1457: IF l_debug_level > 0 THEN
1458: oe_debug_pub.add('DO NOT CALL SHIPPING API,RETURN SUCCESS ',3);
1459: END IF;
1460:

Line 1491: RAISE FND_API.G_EXC_ERROR ;

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:
1495: EXCEPTION WHEN OTHERS THEN

Line 1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1503: oe_debug_pub.add('Exit update_shipping_from_oe() at ',0.5);
1504: END IF;
1505:
1506: EXCEPTION
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)

Line 1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1505:
1506: EXCEPTION
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

Line 1523: WHEN FND_API.G_EXC_ERROR THEN

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
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

Line 1524: x_return_status := FND_API.G_RET_STS_ERROR;

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
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';

Line 1531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1527: IF g_debug_call > 0 THEN
1528: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-4';
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

Line 1556: , p_hold_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1552: -----------------------------------------------------------------*/
1553: PROCEDURE Update_Shipping_PVT
1554: (
1555: p_line_id IN NUMBER
1556: , p_hold_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1557: , p_shipping_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1558: , x_return_status OUT NOCOPY VARCHAR2
1559:
1560: )

Line 1557: , p_shipping_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1553: PROCEDURE Update_Shipping_PVT
1554: (
1555: p_line_id IN NUMBER
1556: , p_hold_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1557: , p_shipping_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1558: , x_return_status OUT NOCOPY VARCHAR2
1559:
1560: )
1561: IS

Line 1578: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;

1574:
1575: -- Prepare the table for calling Update_Shipping_From_OE
1576:
1577: l_update_lines_tbl(1).entity_id := p_line_id;
1578: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
1579: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
1580:
1581: IF p_hold_type IS NOT NULL AND
1582: p_hold_type <> FND_API.G_MISS_CHAR THEN

Line 1579: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;

1575: -- Prepare the table for calling Update_Shipping_From_OE
1576:
1577: l_update_lines_tbl(1).entity_id := p_line_id;
1578: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
1579: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
1580:
1581: IF p_hold_type IS NOT NULL AND
1582: p_hold_type <> FND_API.G_MISS_CHAR THEN
1583:

Line 1582: p_hold_type <> FND_API.G_MISS_CHAR THEN

1578: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
1579: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
1580:
1581: IF p_hold_type IS NOT NULL AND
1582: p_hold_type <> FND_API.G_MISS_CHAR THEN
1583:
1584: l_update_lines_tbl(1).param3 := p_hold_type;
1585:
1586: END IF;

Line 1589: p_shipping_activity <> FND_API.G_MISS_CHAR THEN

1585:
1586: END IF;
1587:
1588: IF p_shipping_activity IS NOT NULL AND
1589: p_shipping_activity <> FND_API.G_MISS_CHAR THEN
1590:
1591: l_update_lines_tbl(1).param4 := p_shipping_activity;
1592:
1593: END IF;

Line 1601: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1597: p_update_lines_tbl => l_update_lines_tbl,
1598: x_return_status => x_return_status
1599: );
1600:
1601: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1603: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;

Line 1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1598: x_return_status => x_return_status
1599: );
1600:
1601: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1603: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606: IF l_debug_level > 0 THEN

Line 1603: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1599: );
1600:
1601: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1603: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606: IF l_debug_level > 0 THEN
1607: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.UPDATE_SHIPPING_PVT' , 1 ) ;

Line 1604: RAISE FND_API.G_EXC_ERROR;

1600:
1601: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1603: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1604: RAISE FND_API.G_EXC_ERROR;
1605: END IF;
1606: IF l_debug_level > 0 THEN
1607: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.UPDATE_SHIPPING_PVT' , 1 ) ;
1608: END IF;

Line 1614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1610: G_DEBUG_MSG := G_DEBUG_MSG || '54,';
1611: END IF;
1612: EXCEPTION
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

Line 1615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1611: END IF;
1612: EXCEPTION
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

Line 1627: WHEN FND_API.G_EXC_ERROR THEN

1623: END IF;
1624: IF g_debug_call > 0 THEN
1625: G_DEBUG_MSG := G_DEBUG_MSG || 'E6,';
1626: END IF;
1627: WHEN FND_API.G_EXC_ERROR THEN
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:

Line 1628: x_return_status := FND_API.G_RET_STS_ERROR;

1624: IF g_debug_call > 0 THEN
1625: G_DEBUG_MSG := G_DEBUG_MSG || 'E6,';
1626: END IF;
1627: WHEN FND_API.G_EXC_ERROR THEN
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)

Line 1630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1626: END IF;
1627: WHEN FND_API.G_EXC_ERROR THEN
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

Line 1695: p_line_rec.top_model_line_id <> FND_API.G_MISS_NUM AND

1691: G_DEBUG_MSG := G_DEBUG_MSG || '61';
1692: END IF;
1693:
1694: IF p_line_rec.top_model_line_id IS NOT NULL AND
1695: p_line_rec.top_model_line_id <> FND_API.G_MISS_NUM AND
1696: NVL(p_line_rec.model_remnant_flag,'N') = 'N' THEN
1697:
1698:
1699: SELECT line_id,

Line 1738: l_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN

1734: END IF; -- if part of model
1735:
1736:
1737: IF l_line_rec.ship_tolerance_below IS NULL OR
1738: l_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN
1739: l_ship_tolerance_below := 0;
1740: ELSE
1741: l_ship_tolerance_below := l_line_rec.ship_tolerance_below;
1742: END IF;

Line 1746: l_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN

1742: END IF;
1743:
1744:
1745: IF l_line_rec.ship_tolerance_above IS NULL OR
1746: l_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN
1747:
1748: l_ship_tolerance_above := 0;
1749: ELSE
1750: l_ship_tolerance_above := l_line_rec.ship_tolerance_above;

Line 1763: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN

1759: oe_debug_pub.add('LINE SET ID '||TO_CHAR(L_LINE_REC.LINE_SET_ID),3);
1760: END IF;
1761:
1762: IF l_line_rec.line_set_id IS NOT NULL AND
1763: l_line_rec.line_set_id <> FND_API.G_MISS_NUM THEN
1764:
1765: IF g_debug_call > 0 THEN
1766: G_DEBUG_MSG := G_DEBUG_MSG || '64';
1767: END IF;

Line 1780: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1776: x_return_status => l_x_return_status,
1777: x_msg_count => l_msg_count,
1778: x_msg_data => l_msg_data);
1779:
1780: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;

Line 1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1777: x_msg_count => l_msg_count,
1778: x_msg_data => l_msg_data);
1779:
1780: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:

Line 1782: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

1778: x_msg_data => l_msg_data);
1779:
1780: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:
1786: ELSE

Line 1783: RAISE FND_API.G_EXC_ERROR;

1779:
1780: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1783: RAISE FND_API.G_EXC_ERROR;
1784: END IF;
1785:
1786: ELSE
1787:

Line 2066: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2062: oe_debug_pub.add('EXITING FROM CHECK_SHIPMENT_LINE : '||X_RESULT_OUT , 1 );
2063: END IF;
2064:
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

Line 2067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2063: END IF;
2064:
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

Line 2102: p_top_model_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

2098: PROCEDURE Get_PTO_Shipped_Quantity
2099: ---------------------------------------------------------------------*/
2100: PROCEDURE Get_PTO_Shipped_Quantity
2101: (
2102: p_top_model_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
2103: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2104: , x_ratio_status OUT NOCOPY VARCHAR2
2105:
2106: , x_return_status OUT NOCOPY VARCHAR2

Line 2120: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;

2116: l_parent_index NUMBER :=0;
2117: l_return_index NUMBER :=0;
2118: l_top_shipped_quantity NUMBER :=0;
2119: l_parent_shipped_quantity NUMBER :=0;
2120: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;
2121: l_ship_date DATE;
2122:
2123: /* Added for bug 1952023 */
2124: l_over_shipped VARCHAR2(1) := FND_API.G_FALSE;

Line 2124: l_over_shipped VARCHAR2(1) := FND_API.G_FALSE;

2120: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;
2121: l_ship_date DATE;
2122:
2123: /* Added for bug 1952023 */
2124: l_over_shipped VARCHAR2(1) := FND_API.G_FALSE;
2125: l_under_shipped VARCHAR2(1) := FND_API.G_FALSE;
2126: l_line_shipped VARCHAR2(1) := FND_API.G_TRUE;
2127:
2128: --

Line 2125: l_under_shipped VARCHAR2(1) := FND_API.G_FALSE;

2121: l_ship_date DATE;
2122:
2123: /* Added for bug 1952023 */
2124: l_over_shipped VARCHAR2(1) := FND_API.G_FALSE;
2125: l_under_shipped VARCHAR2(1) := FND_API.G_FALSE;
2126: l_line_shipped VARCHAR2(1) := FND_API.G_TRUE;
2127:
2128: --
2129: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2126: l_line_shipped VARCHAR2(1) := FND_API.G_TRUE;

2122:
2123: /* Added for bug 1952023 */
2124: l_over_shipped VARCHAR2(1) := FND_API.G_FALSE;
2125: l_under_shipped VARCHAR2(1) := FND_API.G_FALSE;
2126: l_line_shipped VARCHAR2(1) := FND_API.G_TRUE;
2127:
2128: --
2129: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2130: --

Line 2137: p_top_model_line_id <> FND_API.G_MISS_NUM THEN

2133: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY '|| TO_CHAR ( P_TOP_MODEL_LINE_ID ) , 1 ) ;
2134: END IF;
2135:
2136: IF p_top_model_line_id IS NOT NULL AND
2137: p_top_model_line_id <> FND_API.G_MISS_NUM THEN
2138:
2139: -- Call function to get all the lines in a PTO.
2140:
2141: -- p_x_line_tbl := OE_Config_Util.Query_Options(p_top_model_line_id);

Line 2188: l_pto_shipment_tbl(l_pto_index).shippable_flag := FND_API.G_TRUE;

2184: G_DEBUG_MSG := G_DEBUG_MSG || '73,';
2185: END IF;
2186:
2187: IF nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'Y' THEN
2188: l_pto_shipment_tbl(l_pto_index).shippable_flag := FND_API.G_TRUE;
2189: l_ship_date := l_line_tbl(l_line_index).actual_shipment_date;
2190:
2191: IF nvl(l_line_tbl(l_line_index).shipped_quantity,0) = 0 THEN
2192: IF l_debug_level > 0 THEN

Line 2195: l_line_shipped := FND_API.G_FALSE;

2191: IF nvl(l_line_tbl(l_line_index).shipped_quantity,0) = 0 THEN
2192: IF l_debug_level > 0 THEN
2193: oe_debug_pub.add( 'LINE IS NOT SHIPPED : '||L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID , 3 ) ;
2194: END IF;
2195: l_line_shipped := FND_API.G_FALSE;
2196: END IF;
2197: ELSE
2198: l_pto_shipment_tbl(l_pto_index).shippable_flag := FND_API.G_FALSE;
2199: END IF;

Line 2198: l_pto_shipment_tbl(l_pto_index).shippable_flag := FND_API.G_FALSE;

2194: END IF;
2195: l_line_shipped := FND_API.G_FALSE;
2196: END IF;
2197: ELSE
2198: l_pto_shipment_tbl(l_pto_index).shippable_flag := FND_API.G_FALSE;
2199: END IF;
2200:
2201: /* Added for bug 1952023 */
2202: IF nvl(l_line_tbl(l_line_index).shipped_quantity,0) > nvl(l_line_tbl(l_line_index).ordered_quantity,0) THEN

Line 2207: l_over_shipped := FND_API.G_TRUE;

2203:
2204: IF l_debug_level > 0 THEN
2205: oe_debug_pub.add( 'LINE IS OVER SHIPPED '||L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID , 3 ) ;
2206: END IF;
2207: l_over_shipped := FND_API.G_TRUE;
2208:
2209: END IF;
2210:
2211: IF nvl(l_line_tbl(l_line_index).shipped_quantity,0) < nvl(l_line_tbl(l_line_index).ordered_quantity,0) AND

Line 2217: l_under_shipped := FND_API.G_TRUE;

2213:
2214: IF l_debug_level > 0 THEN
2215: oe_debug_pub.add( 'LINE IS UNDER SHIPPED '||L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID , 3 ) ;
2216: END IF;
2217: l_under_shipped := FND_API.G_TRUE;
2218:
2219: END IF;
2220:
2221: << END_PREPARE_LOOP >>

Line 2266: l_ratio_status = FND_API.G_TRUE

2262:
2263: l_pto_index := l_pto_shipment_tbl.FIRST;
2264:
2265: WHILE l_pto_index IS NOT NULL AND
2266: l_ratio_status = FND_API.G_TRUE
2267: LOOP
2268:
2269: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN
2270:

Line 2269: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN

2265: WHILE l_pto_index IS NOT NULL AND
2266: l_ratio_status = FND_API.G_TRUE
2267: LOOP
2268:
2269: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN
2270:
2271: GOTO SKIP_THE_LINE;
2272:
2273: END IF;

Line 2291: l_ratio_status := FND_API.G_FALSE;

2287:
2288: IF l_debug_level > 0 THEN
2289: oe_debug_pub.add( 'PTO HAS NOT BEEN SHIPPED IN PROPORTION ' , 3 ) ;
2290: END IF;
2291: l_ratio_status := FND_API.G_FALSE;
2292: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2293: ELSE
2294: l_pto_shipment_tbl(l_parent_index).shipped_quantity := l_parent_shipped_quantity;
2295: END IF;

Line 2302: l_ratio_status := FND_API.G_FALSE;

2298:
2299: IF l_debug_level > 0 THEN
2300: oe_debug_pub.add( 'SHIPPED QUANTITY IN DECIMAL '||TO_CHAR ( L_PTO_SHIPMENT_TBL ( L_PARENT_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
2301: END IF;
2302: l_ratio_status := FND_API.G_FALSE;
2303: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2304:
2305: END IF;
2306:

Line 2318: l_ratio_status := FND_API.G_FALSE;

2314:
2315: IF l_debug_level > 0 THEN
2316: oe_debug_pub.add( 'PTO HAS NOT BEEN SHIPPED IN PROPORTION ' , 3 ) ;
2317: END IF;
2318: l_ratio_status := FND_API.G_FALSE;
2319: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2320: ELSE
2321: l_pto_shipment_tbl(l_top_index).shipped_quantity := l_top_shipped_quantity;
2322: END IF;

Line 2329: l_ratio_status := FND_API.G_FALSE;

2325:
2326: IF l_debug_level > 0 THEN
2327: oe_debug_pub.add( 'SHIPPED QUANTITY IN DECIMAL '||TO_CHAR ( L_PTO_SHIPMENT_TBL ( L_TOP_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
2328: END IF;
2329: l_ratio_status := FND_API.G_FALSE;
2330: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2331:
2332: END IF;
2333:

Line 2343: IF l_ratio_status = FND_API.G_TRUE THEN

2339: <>
2340:
2341: -- If the ratio is not broken populate the out line table.
2342:
2343: IF l_ratio_status = FND_API.G_TRUE THEN
2344:
2345: -- Assign the shipped quantity if not assigned to any of the lines
2346:
2347: l_pto_index := l_pto_shipment_tbl.FIRST;

Line 2392: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN

2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add( 'INDEX/LINE_ID/FINAL_INDEX '|| TO_CHAR ( L_LINE_INDEX ) ||'/'||P_X_LINE_TBL ( L_FINAL_INDEX ) .LINE_ID||'/'||TO_CHAR ( L_FINAL_INDEX ) , 3 ) ;
2390: END IF;
2391:
2392: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN
2393: p_x_line_tbl(l_final_index).shipped_quantity := l_pto_shipment_tbl(l_pto_index).shipped_quantity;
2394: p_x_line_tbl(l_final_index).actual_shipment_date := l_ship_date;
2395: IF l_debug_level > 0 THEN
2396: oe_debug_pub.add( 'SHIPPED QUANTITY ASSIGNED '||P_X_LINE_TBL ( L_FINAL_INDEX ) .ITEM_TYPE_CODE||TO_CHAR ( P_X_LINE_TBL ( L_FINAL_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;

Line 2410: IF l_over_shipped = FND_API.G_TRUE AND

2406: END LOOP;
2407: /* Added for bug 1952023 */
2408: ELSE
2409:
2410: IF l_over_shipped = FND_API.G_TRUE AND
2411: l_under_shipped = FND_API.G_FALSE AND
2412: l_line_shipped = FND_API.G_TRUE THEN
2413:
2414: IF l_debug_level > 0 THEN

Line 2411: l_under_shipped = FND_API.G_FALSE AND

2407: /* Added for bug 1952023 */
2408: ELSE
2409:
2410: IF l_over_shipped = FND_API.G_TRUE AND
2411: l_under_shipped = FND_API.G_FALSE AND
2412: l_line_shipped = FND_API.G_TRUE THEN
2413:
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'ONE OF THE LINE HAS BEEN OVER SHIPPED , MAKE THE MODEL REMNANT '||P_X_LINE_TBL ( 1 ) .TOP_MODEL_LINE_ID , 3 ) ;

Line 2412: l_line_shipped = FND_API.G_TRUE THEN

2408: ELSE
2409:
2410: IF l_over_shipped = FND_API.G_TRUE AND
2411: l_under_shipped = FND_API.G_FALSE AND
2412: l_line_shipped = FND_API.G_TRUE THEN
2413:
2414: IF l_debug_level > 0 THEN
2415: oe_debug_pub.add( 'ONE OF THE LINE HAS BEEN OVER SHIPPED , MAKE THE MODEL REMNANT '||P_X_LINE_TBL ( 1 ) .TOP_MODEL_LINE_ID , 3 ) ;
2416: END IF;

Line 2442: x_return_status := FND_API.G_RET_STS_SUCCESS;

2438: END IF;
2439:
2440: --x_line_tbl := l_line_tbl;
2441: x_ratio_status := l_ratio_status;
2442: x_return_status := FND_API.G_RET_STS_SUCCESS;
2443:
2444: IF l_debug_level > 0 THEN
2445: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;
2446: END IF;

Line 2448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2444: IF l_debug_level > 0 THEN
2445: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;
2446: END IF;
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

Line 2449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2445: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;
2446: END IF;
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

Line 2462: WHEN FND_API.G_EXC_ERROR THEN

2458: IF g_debug_call > 0 THEN
2459: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-10';
2460: END IF;
2461:
2462: WHEN FND_API.G_EXC_ERROR THEN
2463: x_return_status := FND_API.G_RET_STS_ERROR;
2464: IF g_debug_call > 0 THEN
2465: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-11';
2466: END IF;

Line 2463: x_return_status := FND_API.G_RET_STS_ERROR;

2459: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-10';
2460: END IF;
2461:
2462: WHEN FND_API.G_EXC_ERROR THEN
2463: x_return_status := FND_API.G_RET_STS_ERROR;
2464: IF g_debug_call > 0 THEN
2465: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-11';
2466: END IF;
2467:

Line 2469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2465: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-11';
2466: END IF;
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

Line 2521: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;

2517: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2518: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2519: l_split_index NUMBER :=0;
2520: l_pto_index NUMBER;
2521: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;
2522: l_ship_tolerance_below NUMBER;
2523: l_ship_tolerance_above NUMBER;
2524: l_update_tolerance_value NUMBER := 0 ;
2525: l_x_result_out VARCHAR2(30);

Line 2568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2564: ,p_x_line_tbl => l_line_tbl
2565: ,x_ratio_status => l_ratio_status
2566: ,x_return_status => l_return_status );
2567:
2568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2570: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: END IF;

Line 2569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2565: ,x_ratio_status => l_ratio_status
2566: ,x_return_status => l_return_status );
2567:
2568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2570: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: END IF;
2573:

Line 2570: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2566: ,x_return_status => l_return_status );
2567:
2568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2570: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: END IF;
2573:
2574: -- Get the top model line id index.

Line 2571: RAISE FND_API.G_EXC_ERROR;

2567:
2568: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2570: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2571: RAISE FND_API.G_EXC_ERROR;
2572: END IF;
2573:
2574: -- Get the top model line id index.
2575:

Line 2618: IF l_ratio_status = FND_API.G_TRUE THEN

2614:
2615: -- Check for shipment status when the ratio is not broken and the ship
2616: -- tolerances will be honoured.
2617:
2618: IF l_ratio_status = FND_API.G_TRUE THEN
2619:
2620: -- Loop to Update the shipped quantity of non shippable lines by calling
2621: -- process_order.
2622:

Line 2703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2699: l_set_recursion := 'N';
2700: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2701: END IF;
2702:
2703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;

Line 2704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2700: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2701: END IF;
2702:
2703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;
2708: IF g_debug_call > 0 THEN

Line 2705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2701: END IF;
2702:
2703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;
2708: IF g_debug_call > 0 THEN
2709: G_DEBUG_MSG := G_DEBUG_MSG || '88,';

Line 2706: RAISE FND_API.G_EXC_ERROR;

2702:
2703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2705: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2706: RAISE FND_API.G_EXC_ERROR;
2707: END IF;
2708: IF g_debug_call > 0 THEN
2709: G_DEBUG_MSG := G_DEBUG_MSG || '88,';
2710: END IF;

Line 2823: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2819: l_set_recursion := 'N';
2820: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2821: END IF;
2822:
2823: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2826: RAISE FND_API.G_EXC_ERROR;
2827: END IF;

Line 2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2820: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2821: END IF;
2822:
2823: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2826: RAISE FND_API.G_EXC_ERROR;
2827: END IF;
2828:

Line 2825: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2821: END IF;
2822:
2823: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2826: RAISE FND_API.G_EXC_ERROR;
2827: END IF;
2828:
2829: IF l_debug_level > 0 THEN

Line 2826: RAISE FND_API.G_EXC_ERROR;

2822:
2823: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2825: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2826: RAISE FND_API.G_EXC_ERROR;
2827: END IF;
2828:
2829: IF l_debug_level > 0 THEN
2830: oe_debug_pub.add( 'RET STS FROM PROCESS ORDER: '||L_RETURN_STATUS , 3 ) ;

Line 2863: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2859: p_shipment_status => l_x_result_out,
2860: x_return_status => x_return_status );
2861:
2862:
2863: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;

Line 2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2860: x_return_status => x_return_status );
2861:
2862:
2863: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;
2868:

Line 2865: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2861:
2862:
2863: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;
2868:
2869: END IF;

Line 2866: RAISE FND_API.G_EXC_ERROR;

2862:
2863: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2865: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2866: RAISE FND_API.G_EXC_ERROR;
2867: END IF;
2868:
2869: END IF;
2870:

Line 2883: ELSIF l_ratio_status = FND_API.G_FALSE THEN

2879: IF g_debug_call > 0 THEN
2880: G_DEBUG_MSG := G_DEBUG_MSG || '84,';
2881: END IF;
2882:
2883: ELSIF l_ratio_status = FND_API.G_FALSE THEN
2884:
2885: IF l_debug_level > 0 THEN
2886: oe_debug_pub.add( 'NOT SHIPPED , SHIPMENT RATIO IS BROKEN : ' , 3 ) ;
2887: END IF;

Line 2983: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2979: oe_split_util.cascade_non_proportional_Split
2980: (p_x_line_tbl => l_split_line_tbl,
2981: x_return_status => l_return_status);
2982:
2983: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2985: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2986: RAISE FND_API.G_EXC_ERROR;
2987: END IF;

Line 2984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2980: (p_x_line_tbl => l_split_line_tbl,
2981: x_return_status => l_return_status);
2982:
2983: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2985: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2986: RAISE FND_API.G_EXC_ERROR;
2987: END IF;
2988:

Line 2985: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2981: x_return_status => l_return_status);
2982:
2983: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2985: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2986: RAISE FND_API.G_EXC_ERROR;
2987: END IF;
2988:
2989: IF l_debug_level > 0 THEN

Line 2986: RAISE FND_API.G_EXC_ERROR;

2982:
2983: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2985: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2986: RAISE FND_API.G_EXC_ERROR;
2987: END IF;
2988:
2989: IF l_debug_level > 0 THEN
2990: oe_debug_pub.add( 'RET STS FROM NON PRO SPLIT/'||L_RETURN_STATUS , 3 ) ;

Line 3052: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3048: ( p_line_rec => l_split_line_tbl(l_split_index),
3049: p_shipment_status => l_x_result_out,
3050: x_return_status => x_return_status );
3051:
3052: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;

Line 3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3049: p_shipment_status => l_x_result_out,
3050: x_return_status => x_return_status );
3051:
3052: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:

Line 3054: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3050: x_return_status => x_return_status );
3051:
3052: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:
3058: END IF;

Line 3055: RAISE FND_API.G_EXC_ERROR;

3051:
3052: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3054: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3055: RAISE FND_API.G_EXC_ERROR;
3056: END IF;
3057:
3058: END IF;
3059: ---- non shippable lines not in fulfillment set start ---------

Line 3063: AND l_fulfillment_set_flag = FND_API.G_FALSE THEN

3059: ---- non shippable lines not in fulfillment set start ---------
3060:
3061: ELSIF nvl(l_split_line_tbl(l_split_index).shippable_flag,'N')= 'N' AND
3062: nvl(l_split_line_tbl(l_split_index).model_remnant_flag,'N') = 'Y'
3063: AND l_fulfillment_set_flag = FND_API.G_FALSE THEN
3064:
3065: l_item_key := to_char(l_split_line_tbl(l_split_index).line_id);
3066:
3067: IF l_debug_level > 0 THEN

Line 3086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3082: END IF;
3083: IF g_debug_call > 0 THEN
3084: G_DEBUG_MSG := G_DEBUG_MSG || '89';
3085: END IF;
3086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'LINE IS NOT AT FULFILLMENT ACTIVITY : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID ) , 3 ) ;

Line 3087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3083: IF g_debug_call > 0 THEN
3084: G_DEBUG_MSG := G_DEBUG_MSG || '89';
3085: END IF;
3086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'LINE IS NOT AT FULFILLMENT ACTIVITY : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID ) , 3 ) ;
3091: END IF;

Line 3088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3084: G_DEBUG_MSG := G_DEBUG_MSG || '89';
3085: END IF;
3086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3089: IF l_debug_level > 0 THEN
3090: oe_debug_pub.add( 'LINE IS NOT AT FULFILLMENT ACTIVITY : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID ) , 3 ) ;
3091: END IF;
3092: ELSE

Line 3111: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3107: p_activity_id => l_activity_id,
3108: x_fulfillment_activity => l_fulfillment_activity,
3109: x_return_status => l_return_status);
3110:
3111: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3114: RAISE FND_API.G_EXC_ERROR;
3115: END IF;

Line 3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3108: x_fulfillment_activity => l_fulfillment_activity,
3109: x_return_status => l_return_status);
3110:
3111: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3114: RAISE FND_API.G_EXC_ERROR;
3115: END IF;
3116:

Line 3113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3109: x_return_status => l_return_status);
3110:
3111: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3114: RAISE FND_API.G_EXC_ERROR;
3115: END IF;
3116:
3117: IF l_debug_level > 0 THEN

Line 3114: RAISE FND_API.G_EXC_ERROR;

3110:
3111: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3113: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3114: RAISE FND_API.G_EXC_ERROR;
3115: END IF;
3116:
3117: IF l_debug_level > 0 THEN
3118: oe_debug_pub.add( 'FULFILLMENT ACT : '||L_FULFILLMENT_ACTIVITY , 3 ) ;

Line 3185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3181: p_fulfillment_type => 'No Activity',
3182: p_fulfillment_activity => 'NO_ACTIVITY',
3183: x_return_status => l_return_status);
3184:
3185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;

Line 3186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3182: p_fulfillment_activity => 'NO_ACTIVITY',
3183: x_return_status => l_return_status);
3184:
3185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190:

Line 3187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3183: x_return_status => l_return_status);
3184:
3185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190:
3191: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count

Line 3188: RAISE FND_API.G_EXC_ERROR;

3184:
3185: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3187: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3188: RAISE FND_API.G_EXC_ERROR;
3189: END IF;
3190:
3191: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count
3192: LOOP

Line 3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3203: IF l_debug_level > 0 THEN
3204: oe_debug_pub.add( 'RET STS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3205: END IF;
3206:
3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3209: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3210: RAISE FND_API.G_EXC_ERROR;
3211: END IF;

Line 3208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3204: oe_debug_pub.add( 'RET STS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3205: END IF;
3206:
3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3209: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3210: RAISE FND_API.G_EXC_ERROR;
3211: END IF;
3212:

Line 3209: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3205: END IF;
3206:
3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3209: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3210: RAISE FND_API.G_EXC_ERROR;
3211: END IF;
3212:
3213: l_item_key := to_char(l_fulfill_tbl(l_fulfill_index).line_id);

Line 3210: RAISE FND_API.G_EXC_ERROR;

3206:
3207: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3209: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3210: RAISE FND_API.G_EXC_ERROR;
3211: END IF;
3212:
3213: l_item_key := to_char(l_fulfill_tbl(l_fulfill_index).line_id);
3214:

Line 3245: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3241: IF l_debug_level > 0 THEN
3242: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
3243: END IF;
3244:
3245: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;

Line 3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3242: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
3243: END IF;
3244:
3245: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250:

Line 3247: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3243: END IF;
3244:
3245: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250:
3251: END LOOP; -- fulfill table has rows.

Line 3248: RAISE FND_API.G_EXC_ERROR;

3244:
3245: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3247: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3248: RAISE FND_API.G_EXC_ERROR;
3249: END IF;
3250:
3251: END LOOP; -- fulfill table has rows.
3252:

Line 3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3260: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_PTO_KIT : '||X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
3261: END IF;
3262:
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

Line 3265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3261: END IF;
3262:
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

Line 3275: WHEN FND_API.G_EXC_ERROR THEN

3271: , 'Ship_Confirm_PTO_KIT'
3272: );
3273: END IF;
3274:
3275: WHEN FND_API.G_EXC_ERROR THEN
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: WHEN OTHERS THEN
3279: IF l_debug_level > 0 THEN

Line 3276: x_return_status := FND_API.G_RET_STS_ERROR;

3272: );
3273: END IF;
3274:
3275: WHEN FND_API.G_EXC_ERROR THEN
3276: x_return_status := FND_API.G_RET_STS_ERROR;
3277:
3278: WHEN OTHERS THEN
3279: IF l_debug_level > 0 THEN
3280: oe_debug_pub.add( 'SHIP_CONFIRM_PTO_KIT : EXITING WITH OTHERS ERROR' , 1 ) ;

Line 3288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3284: END IF;
3285: IF g_debug_call > 0 THEN
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

Line 3308: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

3304:
3305:
3306: /*--------------------------------------------------------------*/
3307: PROCEDURE Ship_Confirm_Standard_Line
3308: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3309: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3310: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3311: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3312: ,p_check_line_set IN VARCHAR2 := 'Y'

Line 3311: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

3307: PROCEDURE Ship_Confirm_Standard_Line
3308: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3309: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3310: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3311: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3312: ,p_check_line_set IN VARCHAR2 := 'Y'
3313: ,x_return_status OUT NOCOPY VARCHAR2)
3314:
3315: IS

Line 3349: p_line_id = FND_API.G_MISS_NUM THEN

3345: G_DEBUG_MSG := G_DEBUG_MSG || '101,';
3346: END IF;
3347:
3348: IF p_line_id IS NULL OR
3349: p_line_id = FND_API.G_MISS_NUM THEN
3350: l_line_rec := p_line_rec;
3351: IF l_debug_level > 0 THEN
3352: oe_debug_pub.add( 'p_line_rec.line_id '||P_LINE_REC.LINE_ID , 3 ) ;
3353: END IF;

Line 3366: IF p_shipment_status <> FND_API.G_MISS_CHAR AND

3362:
3363:
3364: -- Check for Shipment Status
3365:
3366: IF p_shipment_status <> FND_API.G_MISS_CHAR AND
3367: p_shipment_status IS NOT NULL THEN
3368:
3369: IF l_debug_level > 0 THEN
3370: oe_debug_pub.add( '1 shipment status '|| P_SHIPMENT_STATUS , 1 ) ;

Line 3468: l_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR

3464:
3465: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND
3466: l_line_rec.ordered_quantity > l_line_rec.shipped_quantity AND
3467: (l_line_rec.top_model_line_id is null OR
3468: l_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
3469: nvl(l_line_rec.model_remnant_flag,'N') = 'Y') THEN
3470:
3471: -- Split API is called only for Standard line. For PTO/ATO it
3472: -- will be called from respective procedures.

Line 3533: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN

3529: END IF;
3530:
3531: l_line_tbl(1).ordered_quantity := l_temp_shipped_qty;
3532: -- Check if item is dual UOM
3533: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3534:
3535: -- User can order in a 3rd UOM that is not primary nor secondary
3536: -- but a convertable UOM.
3537: -- 3rd conversion case, we need to perform an item specific conversion

Line 3570: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN

3566:
3567: ELSE -- UOMS are same. This is good for discrete and OPM
3568: l_line_tbl(1).ordered_quantity := l_line_rec.shipped_quantity;
3569: -- check if item is a dual UOM
3570: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3571: l_line_tbl(1).ordered_quantity2 := l_line_rec.shipped_quantity2;
3572: -- single UOM item
3573: ELSE
3574: l_line_tbl(1).ordered_quantity2 := NULL;

Line 3597: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN

3593:
3594: IF ( l_uom_different = 1 ) THEN -- UOMS are different and it is dual item line -- INVCONV
3595: l_line_tbl(2).ordered_quantity := l_line_rec.ordered_quantity - l_temp_shipped_qty;
3596: -- Check if item is a dual UOM
3597: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3598:
3599: -- In OPM, User can order in a 3rd UOM that is not primary nor secondary
3600: -- but a convertable UOM.
3601: -- 3rd conversion case, we need to perform an item specific conversion

Line 3632: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN

3628: ELSE -- UOMS are same. This is good for discrete and OPM
3629: l_line_tbl(2).ordered_quantity := l_line_rec.ordered_quantity -
3630: l_line_rec.shipped_quantity;
3631: -- Check if item is a dual UOM
3632: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3633: l_line_tbl(2).ordered_quantity2 := l_line_rec.ordered_quantity2 -
3634: l_line_rec.shipped_quantity2;
3635: -- Item is a single UOM
3636: ELSE

Line 3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3693: IF l_debug_level > 0 THEN
3694: oe_debug_pub.add( 'RET STS PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
3695: END IF;
3696:
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;

Line 3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3694: oe_debug_pub.add( 'RET STS PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
3695: END IF;
3696:
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;
3702: END IF; -- split

Line 3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3695: END IF;
3696:
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;
3702: END IF; -- split
3703:

Line 3700: RAISE FND_API.G_EXC_ERROR;

3696:
3697: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3698: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3699: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3700: RAISE FND_API.G_EXC_ERROR;
3701: END IF;
3702: END IF; -- split
3703:
3704: IF g_debug_call > 0 THEN

Line 3771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3767: IF l_debug_level > 0 THEN
3768: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3769: END IF;
3770:
3771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF;

Line 3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3768: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3769: END IF;
3770:
3771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF;
3776: IF g_debug_call > 0 THEN

Line 3773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3769: END IF;
3770:
3771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF;
3776: IF g_debug_call > 0 THEN
3777: G_DEBUG_MSG := G_DEBUG_MSG || '9-25';

Line 3774: RAISE FND_API.G_EXC_ERROR;

3770:
3771: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3773: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3774: RAISE FND_API.G_EXC_ERROR;
3775: END IF;
3776: IF g_debug_call > 0 THEN
3777: G_DEBUG_MSG := G_DEBUG_MSG || '9-25';
3778: END IF;

Line 3809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3805: x_return_status => l_return_status);
3806: IF g_debug_call > 0 THEN
3807: G_DEBUG_MSG := G_DEBUG_MSG || '9-27';
3808: END IF;
3809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;

Line 3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3806: IF g_debug_call > 0 THEN
3807: G_DEBUG_MSG := G_DEBUG_MSG || '9-27';
3808: END IF;
3809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;
3814:

Line 3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3807: G_DEBUG_MSG := G_DEBUG_MSG || '9-27';
3808: END IF;
3809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;
3814:
3815: IF l_line_rec.arrival_set_id IS NOT NULL AND

Line 3812: RAISE FND_API.G_EXC_ERROR;

3808: END IF;
3809: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3810: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3811: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;
3814:
3815: IF l_line_rec.arrival_set_id IS NOT NULL AND
3816: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN

Line 3816: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN

3812: RAISE FND_API.G_EXC_ERROR;
3813: END IF;
3814:
3815: IF l_line_rec.arrival_set_id IS NOT NULL AND
3816: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN
3817: UPDATE OE_SETS
3818: SET SET_STATUS = 'C'
3819: WHERE SET_ID = l_line_rec.arrival_set_id;
3820: IF l_debug_level > 0 THEN

Line 3829: x_return_status := FND_API.G_RET_STS_SUCCESS;

3825: END IF;
3826: IF g_debug_call > 0 THEN
3827: G_DEBUG_MSG := G_DEBUG_MSG || '9-28';
3828: END IF;
3829: x_return_status := FND_API.G_RET_STS_SUCCESS;
3830:
3831: IF l_debug_level > 0 THEN
3832: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_STANDARD_LINE '|| X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
3833: END IF;

Line 3836: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3832: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_STANDARD_LINE '|| X_RETURN_STATUS , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
3833: END IF;
3834:
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

Line 3837: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3833: END IF;
3834:
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

Line 3850: WHEN FND_API.G_EXC_ERROR THEN

3846: IF g_debug_call > 0 THEN
3847: G_DEBUG_MSG := G_DEBUG_MSG || 'E20';
3848: END IF;
3849:
3850: WHEN FND_API.G_EXC_ERROR THEN
3851: IF l_debug_level > 0 THEN
3852: oe_debug_pub.add( 'SHIP_CONFIRM_STANDARD_LINE EXC ERROR' , 1 ) ;
3853: END IF;
3854: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3854: x_return_status := FND_API.G_RET_STS_ERROR;

3850: WHEN FND_API.G_EXC_ERROR THEN
3851: IF l_debug_level > 0 THEN
3852: oe_debug_pub.add( 'SHIP_CONFIRM_STANDARD_LINE EXC ERROR' , 1 ) ;
3853: END IF;
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855: IF g_debug_call > 0 THEN
3856: G_DEBUG_MSG := G_DEBUG_MSG || 'E-21';
3857: END IF;
3858:

Line 3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3859: WHEN OTHERS THEN
3860: IF l_debug_level > 0 THEN
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

Line 3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3917: IF l_debug_level > 0 THEN
3918: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
3919: END IF;
3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3924: IF l_debug_level > 0 THEN
3925: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;

Line 3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3918: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
3919: END IF;
3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3924: IF l_debug_level > 0 THEN
3925: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
3926: END IF;

Line 3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3919: END IF;
3920:
3921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3924: IF l_debug_level > 0 THEN
3925: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
3926: END IF;
3927: ELSE

Line 3956: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3952: p_param3 => 'WAIT_FOR_CTO',
3953: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3954: x_return_status => l_return_status);
3955:
3956: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: END IF;

Line 3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3953: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3954: x_return_status => l_return_status);
3955:
3956: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: END IF;
3961:

Line 3958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3954: x_return_status => l_return_status);
3955:
3956: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: END IF;
3961:
3962: END IF;

Line 3959: RAISE FND_API.G_EXC_ERROR;

3955:
3956: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3958: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3959: RAISE FND_API.G_EXC_ERROR;
3960: END IF;
3961:
3962: END IF;
3963: END IF;

Line 4062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4058: IF l_debug_level > 0 THEN
4059: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4060: END IF;
4061:
4062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;

Line 4063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4059: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4060: END IF;
4061:
4062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;
4067:

Line 4064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4060: END IF;
4061:
4062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;
4067:
4068: IF g_debug_call > 0 THEN

Line 4065: RAISE FND_API.G_EXC_ERROR;

4061:
4062: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4064: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4065: RAISE FND_API.G_EXC_ERROR;
4066: END IF;
4067:
4068: IF g_debug_call > 0 THEN
4069: G_DEBUG_MSG := G_DEBUG_MSG || '10-7';

Line 4147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4143: END IF;
4144: IF g_debug_call > 0 THEN
4145: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-10-9';
4146: END IF;
4147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4150: RAISE FND_API.G_EXC_ERROR;
4151: END IF;

Line 4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4144: IF g_debug_call > 0 THEN
4145: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-10-9';
4146: END IF;
4147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4150: RAISE FND_API.G_EXC_ERROR;
4151: END IF;
4152:

Line 4149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4145: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-10-9';
4146: END IF;
4147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4150: RAISE FND_API.G_EXC_ERROR;
4151: END IF;
4152:
4153: IF l_debug_level > 0 THEN

Line 4150: RAISE FND_API.G_EXC_ERROR;

4146: END IF;
4147: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4149: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4150: RAISE FND_API.G_EXC_ERROR;
4151: END IF;
4152:
4153: IF l_debug_level > 0 THEN
4154: oe_debug_pub.add('RET STS FROM PROCESS ORDER:'||L_RETURN_STATUS , 3 ) ;

Line 4170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4166: IF g_debug_call > 0 THEN
4167: G_DEBUG_MSG := G_DEBUG_MSG || '1-10';
4168: END IF;
4169:
4170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;

Line 4171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4167: G_DEBUG_MSG := G_DEBUG_MSG || '1-10';
4168: END IF;
4169:
4170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175:

Line 4172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4168: END IF;
4169:
4170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175:
4176: IF l_debug_level > 0 THEN -- Added debug for bug 13435459

Line 4173: RAISE FND_API.G_EXC_ERROR;

4169:
4170: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4171: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4172: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4173: RAISE FND_API.G_EXC_ERROR;
4174: END IF;
4175:
4176: IF l_debug_level > 0 THEN -- Added debug for bug 13435459
4177: OE_DEBUG_PUB.add('Exit Ship_Confirm_ATO() at ',0.5);

Line 4179: x_return_status := FND_API.G_RET_STS_SUCCESS;

4175:
4176: IF l_debug_level > 0 THEN -- Added debug for bug 13435459
4177: OE_DEBUG_PUB.add('Exit Ship_Confirm_ATO() at ',0.5);
4178: END IF;
4179: x_return_status := FND_API.G_RET_STS_SUCCESS;
4180:
4181: EXCEPTION
4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4178: END IF;
4179: x_return_status := FND_API.G_RET_STS_SUCCESS;
4180:
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

Line 4183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4179: x_return_status := FND_API.G_RET_STS_SUCCESS;
4180:
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

Line 4195: WHEN FND_API.G_EXC_ERROR THEN

4191: IF g_debug_call > 0 THEN
4192: G_DEBUG_MSG := G_DEBUG_MSG || 'E-24';
4193: END IF;
4194:
4195: WHEN FND_API.G_EXC_ERROR THEN
4196: x_return_status := FND_API.G_RET_STS_ERROR;
4197: IF g_debug_call > 0 THEN
4198: G_DEBUG_MSG := G_DEBUG_MSG || 'E-25';
4199: END IF;

Line 4196: x_return_status := FND_API.G_RET_STS_ERROR;

4192: G_DEBUG_MSG := G_DEBUG_MSG || 'E-24';
4193: END IF;
4194:
4195: WHEN FND_API.G_EXC_ERROR THEN
4196: x_return_status := FND_API.G_RET_STS_ERROR;
4197: IF g_debug_call > 0 THEN
4198: G_DEBUG_MSG := G_DEBUG_MSG || 'E-25';
4199: END IF;
4200:

Line 4205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4201: WHEN OTHERS THEN
4202: IF l_debug_level > 0 THEN
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

Line 4237: l_line_shipped VARCHAR2(1) := FND_API.G_FALSE;

4233: l_process_index NUMBER := 0;
4234: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4235: l_set_index NUMBER := 0;
4236: l_control_rec OE_GLOBALS.Control_Rec_Type;
4237: l_line_shipped VARCHAR2(1) := FND_API.G_FALSE;
4238: l_return_status VARCHAR2(1);
4239: l_set_recursion VARCHAR2(1) := 'N';
4240:
4241: --

Line 4299: l_line_tbl(l_line_index).top_model_line_id <> FND_API.G_MISS_NUM AND

4295: l_process_tbl(l_process_index) := l_line_tbl(l_line_index);
4296:
4297:
4298: ELSIF (l_line_tbl(l_line_index).top_model_line_id IS NOT NULL AND
4299: l_line_tbl(l_line_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4300: l_line_tbl(l_line_index).line_id = l_line_tbl(l_line_index).top_model_line_id) AND
4301: (l_line_tbl(l_line_index).ato_line_id IS NULL OR
4302: l_line_tbl(l_line_index).ato_line_id = FND_API.G_MISS_NUM) THEN
4303: IF l_debug_level > 0 THEN

Line 4302: l_line_tbl(l_line_index).ato_line_id = FND_API.G_MISS_NUM) THEN

4298: ELSIF (l_line_tbl(l_line_index).top_model_line_id IS NOT NULL AND
4299: l_line_tbl(l_line_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4300: l_line_tbl(l_line_index).line_id = l_line_tbl(l_line_index).top_model_line_id) AND
4301: (l_line_tbl(l_line_index).ato_line_id IS NULL OR
4302: l_line_tbl(l_line_index).ato_line_id = FND_API.G_MISS_NUM) THEN
4303: IF l_debug_level > 0 THEN
4304: oe_debug_pub.add( 'IT IS A PTO/KIT ' , 3 ) ;
4305: END IF;
4306: l_process_index := l_process_index + 1;

Line 4330: l_process_tbl(l_process_index).top_model_line_id <> FND_API.G_MISS_NUM AND

4326: FOR l_process_index IN l_process_tbl.FIRST .. l_process_tbl.LAST
4327: LOOP
4328:
4329: IF l_process_tbl(l_process_index).top_model_line_id IS NOT NULL AND
4330: l_process_tbl(l_process_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4331: /* Commented for bug 1820608
4332: (l_process_tbl(l_process_index).ato_line_id IS NULL OR
4333: l_process_tbl(l_process_index).ato_line_id = FND_API.G_MISS_NUM) THEN */
4334: /* Added condition of KIT for bug 1926571 */

Line 4333: l_process_tbl(l_process_index).ato_line_id = FND_API.G_MISS_NUM) THEN */

4329: IF l_process_tbl(l_process_index).top_model_line_id IS NOT NULL AND
4330: l_process_tbl(l_process_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4331: /* Commented for bug 1820608
4332: (l_process_tbl(l_process_index).ato_line_id IS NULL OR
4333: l_process_tbl(l_process_index).ato_line_id = FND_API.G_MISS_NUM) THEN */
4334: /* Added condition of KIT for bug 1926571 */
4335: l_process_tbl(l_process_index).item_type_code IN ('MODEL','KIT') THEN
4336: IF l_debug_level > 0 THEN
4337: oe_debug_pub.add( 'IT IS PTO/KIT '||TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .TOP_MODEL_LINE_ID ) , 3 ) ;

Line 4349: l_line_tbl(l_line_index).shipped_quantity <> FND_API.G_MISS_NUM THEN

4345:
4346: IF l_line_tbl(l_line_index).top_model_line_id = l_process_tbl(l_process_index).top_model_line_id AND
4347: nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'Y' AND
4348: nvl(l_line_tbl(l_line_index).shipped_quantity,0) <> 0 AND
4349: l_line_tbl(l_line_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4350: l_line_shipped := FND_API.G_TRUE;
4351: IF l_debug_level > 0 THEN
4352: oe_debug_pub.add( 'LINE IS SHIPPED '||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) , 3 ) ;
4353: END IF;

Line 4350: l_line_shipped := FND_API.G_TRUE;

4346: IF l_line_tbl(l_line_index).top_model_line_id = l_process_tbl(l_process_index).top_model_line_id AND
4347: nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'Y' AND
4348: nvl(l_line_tbl(l_line_index).shipped_quantity,0) <> 0 AND
4349: l_line_tbl(l_line_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4350: l_line_shipped := FND_API.G_TRUE;
4351: IF l_debug_level > 0 THEN
4352: oe_debug_pub.add( 'LINE IS SHIPPED '||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) , 3 ) ;
4353: END IF;
4354:

Line 4360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4356: (
4357: p_top_model_line_id => l_process_tbl(l_process_index).top_model_line_id,
4358: x_return_status => l_return_status
4359: );
4360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4363: RAISE FND_API.G_EXC_ERROR;
4364: END IF;

Line 4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4357: p_top_model_line_id => l_process_tbl(l_process_index).top_model_line_id,
4358: x_return_status => l_return_status
4359: );
4360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4363: RAISE FND_API.G_EXC_ERROR;
4364: END IF;
4365:

Line 4362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4358: x_return_status => l_return_status
4359: );
4360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4363: RAISE FND_API.G_EXC_ERROR;
4364: END IF;
4365:
4366: GOTO END_PTO_KIT_SET;

Line 4363: RAISE FND_API.G_EXC_ERROR;

4359: );
4360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4363: RAISE FND_API.G_EXC_ERROR;
4364: END IF;
4365:
4366: GOTO END_PTO_KIT_SET;
4367:

Line 4375: l_process_tbl(l_process_index).shipped_quantity <> FND_API.G_MISS_NUM THEN

4371: <>
4372: NULL;
4373:
4374: ELSIF nvl(l_process_tbl(l_process_index).shipped_quantity,0) <> 0 AND
4375: l_process_tbl(l_process_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4376: IF l_debug_level > 0 THEN
4377: oe_debug_pub.add( 'INSIDE THE LOOP : LINE ID : '|| TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4378: END IF;
4379: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN

Line 4386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4382: p_line_rec => l_process_tbl(l_process_index),
4383: x_return_status => l_return_status
4384: );
4385:
4386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4389: RAISE FND_API.G_EXC_ERROR;
4390: END IF;

Line 4387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4383: x_return_status => l_return_status
4384: );
4385:
4386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4389: RAISE FND_API.G_EXC_ERROR;
4390: END IF;
4391: END IF;

Line 4388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4384: );
4385:
4386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4389: RAISE FND_API.G_EXC_ERROR;
4390: END IF;
4391: END IF;
4392:

Line 4389: RAISE FND_API.G_EXC_ERROR;

4385:
4386: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4388: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4389: RAISE FND_API.G_EXC_ERROR;
4390: END IF;
4391: END IF;
4392:
4393: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

Line 4400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4396: p_line_id => l_process_tbl(l_process_index).line_id,
4397: x_return_status => l_return_status
4398: );
4399:
4400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;

Line 4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4397: x_return_status => l_return_status
4398: );
4399:
4400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;
4405: END IF;

Line 4402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4398: );
4399:
4400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;
4405: END IF;
4406:

Line 4403: RAISE FND_API.G_EXC_ERROR;

4399:
4400: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4401: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4402: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;
4405: END IF;
4406:
4407: l_line_shipped := FND_API.G_TRUE;

Line 4407: l_line_shipped := FND_API.G_TRUE;

4403: RAISE FND_API.G_EXC_ERROR;
4404: END IF;
4405: END IF;
4406:
4407: l_line_shipped := FND_API.G_TRUE;
4408: END IF;
4409:
4410: IF l_line_shipped = FND_API.G_FALSE THEN
4411:

Line 4410: IF l_line_shipped = FND_API.G_FALSE THEN

4406:
4407: l_line_shipped := FND_API.G_TRUE;
4408: END IF;
4409:
4410: IF l_line_shipped = FND_API.G_FALSE THEN
4411:
4412: IF l_debug_level > 0 THEN
4413: oe_debug_pub.add( 'SHIP SET IS PARTIALLY SHIPPED REMOVING THE SETID '||TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4414: END IF;

Line 4430: l_line_shipped := FND_API.G_FALSE;

4426: l_set_tbl(l_set_index).operation := OE_GLOBALS.G_OPR_UPDATE;
4427:
4428: END IF;
4429:
4430: l_line_shipped := FND_API.G_FALSE;
4431:
4432: END LOOP;
4433:
4434: IF l_set_index <> 0 THEN

Line 4477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4473:
4474: IF l_debug_level > 0 THEN
4475: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4476: END IF;
4477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4480: RAISE FND_API.G_EXC_ERROR;
4481: END IF;

Line 4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4474: IF l_debug_level > 0 THEN
4475: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4476: END IF;
4477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4480: RAISE FND_API.G_EXC_ERROR;
4481: END IF;
4482: END IF;

Line 4479: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4475: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4476: END IF;
4477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4480: RAISE FND_API.G_EXC_ERROR;
4481: END IF;
4482: END IF;
4483:

Line 4480: RAISE FND_API.G_EXC_ERROR;

4476: END IF;
4477: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4479: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4480: RAISE FND_API.G_EXC_ERROR;
4481: END IF;
4482: END IF;
4483:
4484: x_return_status := l_return_status;

Line 4495: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4491: G_DEBUG_MSG := G_DEBUG_MSG || '11-9';
4492: END IF;
4493:
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

Line 4496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4492: END IF;
4493:
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

Line 4509: WHEN FND_API.G_EXC_ERROR THEN

4505: IF g_debug_call > 0 THEN
4506: G_DEBUG_MSG := G_DEBUG_MSG || 'E-27';
4507: END IF;
4508:
4509: WHEN FND_API.G_EXC_ERROR THEN
4510: x_return_status := FND_API.G_RET_STS_ERROR;
4511: IF g_debug_call > 0 THEN
4512: G_DEBUG_MSG := G_DEBUG_MSG || 'E-28';
4513: END IF;

Line 4510: x_return_status := FND_API.G_RET_STS_ERROR;

4506: G_DEBUG_MSG := G_DEBUG_MSG || 'E-27';
4507: END IF;
4508:
4509: WHEN FND_API.G_EXC_ERROR THEN
4510: x_return_status := FND_API.G_RET_STS_ERROR;
4511: IF g_debug_call > 0 THEN
4512: G_DEBUG_MSG := G_DEBUG_MSG || 'E-28';
4513: END IF;
4514: WHEN OTHERS THEN

Line 4515: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4511: IF g_debug_call > 0 THEN
4512: G_DEBUG_MSG := G_DEBUG_MSG || 'E-28';
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

Line 4580: p_process_id <> FND_API.G_MISS_NUM) THEN

4576:
4577:
4578: IF p_process_type = 'ATO' AND
4579: (p_process_id IS NOT NULL AND
4580: p_process_id <> FND_API.G_MISS_NUM) THEN
4581:
4582: -- Call procedure for Ship Confirmation of ATO
4583: Ship_Confirm_ATO
4584: (

Line 4588: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4584: (
4585: p_line_id => p_process_id,
4586: x_return_status => l_x_return_status
4587: );
4588: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;

Line 4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4585: p_line_id => p_process_id,
4586: x_return_status => l_x_return_status
4587: );
4588: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4593:

Line 4590: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

4586: x_return_status => l_x_return_status
4587: );
4588: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4593:
4594: ELSIF p_process_type = 'PTO_KIT' AND

Line 4591: RAISE FND_API.G_EXC_ERROR;

4587: );
4588: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4590: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4591: RAISE FND_API.G_EXC_ERROR;
4592: END IF;
4593:
4594: ELSIF p_process_type = 'PTO_KIT' AND
4595: (p_process_id IS NOT NULL AND

Line 4596: p_process_id <> FND_API.G_MISS_NUM) THEN

4592: END IF;
4593:
4594: ELSIF p_process_type = 'PTO_KIT' AND
4595: (p_process_id IS NOT NULL AND
4596: p_process_id <> FND_API.G_MISS_NUM) THEN
4597:
4598: -- Call procedure for Ship Confirmation of PTO and KIT
4599:
4600:

Line 4606: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4602: (
4603: p_top_model_line_id => p_process_id,
4604: x_return_status => l_x_return_status
4605: );
4606: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4608: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4609: RAISE FND_API.G_EXC_ERROR;
4610: END IF;

Line 4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4603: p_top_model_line_id => p_process_id,
4604: x_return_status => l_x_return_status
4605: );
4606: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4608: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4609: RAISE FND_API.G_EXC_ERROR;
4610: END IF;
4611:

Line 4608: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

4604: x_return_status => l_x_return_status
4605: );
4606: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4608: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4609: RAISE FND_API.G_EXC_ERROR;
4610: END IF;
4611:
4612:

Line 4609: RAISE FND_API.G_EXC_ERROR;

4605: );
4606: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4608: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4609: RAISE FND_API.G_EXC_ERROR;
4610: END IF;
4611:
4612:
4613: ELSIF p_process_type = 'SHIP_SET' AND

Line 4615: p_process_id <> FND_API.G_MISS_NUM) THEN

4611:
4612:
4613: ELSIF p_process_type = 'SHIP_SET' AND
4614: (p_process_id IS NOT NULL AND
4615: p_process_id <> FND_API.G_MISS_NUM) THEN
4616:
4617: -- Call procedure for Ship Confirmation of SHIP_SET
4618:
4619: Ship_Confirm_Ship_Set

Line 4624: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4620: (
4621: p_ship_set_id => p_process_id,
4622: x_return_status => l_x_return_status
4623: );
4624: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;

Line 4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4621: p_ship_set_id => p_process_id,
4622: x_return_status => l_x_return_status
4623: );
4624: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;
4629: ELSE

Line 4626: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

4622: x_return_status => l_x_return_status
4623: );
4624: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;
4629: ELSE
4630:

Line 4627: RAISE FND_API.G_EXC_ERROR;

4623: );
4624: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4626: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4627: RAISE FND_API.G_EXC_ERROR;
4628: END IF;
4629: ELSE
4630:
4631: -- Call procedure for Ship Confirmation of Standard Line

Line 4642: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4638: p_line_id => p_process_id,
4639: x_return_status => l_x_return_status
4640: );
4641:
4642: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4645: RAISE FND_API.G_EXC_ERROR;
4646: END IF;

Line 4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4639: x_return_status => l_x_return_status
4640: );
4641:
4642: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4645: RAISE FND_API.G_EXC_ERROR;
4646: END IF;
4647:

Line 4644: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

4640: );
4641:
4642: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4645: RAISE FND_API.G_EXC_ERROR;
4646: END IF;
4647:
4648:

Line 4645: RAISE FND_API.G_EXC_ERROR;

4641:
4642: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4643: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4644: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4645: RAISE FND_API.G_EXC_ERROR;
4646: END IF;
4647:
4648:
4649: END IF;

Line 4651: x_return_status := FND_API.G_RET_STS_SUCCESS;

4647:
4648:
4649: END IF;
4650:
4651: x_return_status := FND_API.G_RET_STS_SUCCESS;
4652: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4653: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4654: null;
4655: END IF;

Line 4663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4659: oe_debug_pub.add( 'RETURNED FROM OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIP_CONFIRM '|| X_RETURN_STATUS , 0.5 ) ;
4660: END IF;
4661:
4662: EXCEPTION
4663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4664: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4665: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4666: null;
4667: END IF;

Line 4669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4665: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4666: null;
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

Line 4682: WHEN FND_API.G_EXC_ERROR THEN

4678: IF g_debug_call > 0 THEN
4679: G_DEBUG_MSG := G_DEBUG_MSG || 'E-30';
4680: END IF;
4681:
4682: WHEN FND_API.G_EXC_ERROR THEN
4683: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4684: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4685: null;
4686: END IF;

Line 4687: x_return_status := FND_API.G_RET_STS_ERROR;

4683: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4684: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4685: null;
4686: END IF;
4687: x_return_status := FND_API.G_RET_STS_ERROR;
4688: IF g_debug_call > 0 THEN
4689: G_DEBUG_MSG := G_DEBUG_MSG || 'E31';
4690: END IF;
4691: WHEN OTHERS THEN

Line 4699: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4695: END IF;
4696: IF g_debug_call > 0 THEN
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

Line 4742: l_shipping_activity VARCHAR2(1) := FND_API.G_TRUE;

4738: ,x_msg_data OUT NOCOPY VARCHAR2)
4739:
4740: IS
4741: l_line_index NUMBER;
4742: l_shipping_activity VARCHAR2(1) := FND_API.G_TRUE;
4743: l_return_status VARCHAR2(1);
4744: l_freeze_method VARCHAR2(30);
4745: l_flow_status_code VARCHAR2(30);
4746: l_line_category_code VARCHAR2(30);

Line 5116: x_return_status := FND_API.G_RET_STS_SUCCESS;

5112:
5113: IF g_debug_call > 0 THEN
5114: G_DEBUG_MSG := G_DEBUG_MSG || '209';
5115: END IF;
5116: x_return_status := FND_API.G_RET_STS_SUCCESS;
5117: RETURN;
5118: END IF; -- bulk mode
5119: --Start Bug 4094824
5120: BEGIN

Line 5158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5154: IF l_debug_level > 0 THEN
5155: oe_debug_pub.add('After calling explosion : '|| l_return_status , 3 ) ;
5156: END IF;
5157:
5158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5161: RAISE FND_API.G_EXC_ERROR;
5162: END IF;

Line 5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5155: oe_debug_pub.add('After calling explosion : '|| l_return_status , 3 ) ;
5156: END IF;
5157:
5158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5161: RAISE FND_API.G_EXC_ERROR;
5162: END IF;
5163:

Line 5160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5156: END IF;
5157:
5158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5161: RAISE FND_API.G_EXC_ERROR;
5162: END IF;
5163:
5164: IF l_ship_model_complete_flag = 'N' OR l_enforce_smc_flag = 'Y' THEN

Line 5161: RAISE FND_API.G_EXC_ERROR;

5157:
5158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5161: RAISE FND_API.G_EXC_ERROR;
5162: END IF;
5163:
5164: IF l_ship_model_complete_flag = 'N' OR l_enforce_smc_flag = 'Y' THEN
5165:

Line 5234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5230: (p_line_id => p_line_id
5231: ,p_top_model_line_id => l_top_model_line_id
5232: ,x_return_status => l_return_status);
5233:
5234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5236: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5237: RAISE FND_API.G_EXC_ERROR;
5238: END IF;

Line 5235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5231: ,p_top_model_line_id => l_top_model_line_id
5232: ,x_return_status => l_return_status);
5233:
5234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5236: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5237: RAISE FND_API.G_EXC_ERROR;
5238: END IF;
5239:

Line 5236: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5232: ,x_return_status => l_return_status);
5233:
5234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5236: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5237: RAISE FND_API.G_EXC_ERROR;
5238: END IF;
5239:
5240: ELSE -- standard, non-smc etc

Line 5237: RAISE FND_API.G_EXC_ERROR;

5233:
5234: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5236: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5237: RAISE FND_API.G_EXC_ERROR;
5238: END IF;
5239:
5240: ELSE -- standard, non-smc etc
5241:

Line 5255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5251: Update_Shipping_PVT(p_line_id => l_line_id,
5252: p_shipping_activity => l_shipping_activity,
5253: x_return_status => l_return_status);
5254:
5255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: END IF;

Line 5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5252: p_shipping_activity => l_shipping_activity,
5253: x_return_status => l_return_status);
5254:
5255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: END IF;
5260: END IF;

Line 5257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5253: x_return_status => l_return_status);
5254:
5255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: END IF;
5260: END IF;
5261:

Line 5258: RAISE FND_API.G_EXC_ERROR;

5254:
5255: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5257: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5258: RAISE FND_API.G_EXC_ERROR;
5259: END IF;
5260: END IF;
5261:
5262: END IF; -- big IF smc etc.

Line 5309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5305: IF l_debug_level > 0 THEN
5306: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5307: END IF;
5308:
5309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5311: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: END IF;

Line 5310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5306: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5307: END IF;
5308:
5309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5311: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: END IF;
5314:

Line 5311: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5307: END IF;
5308:
5309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5311: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: END IF;
5314:
5315: END IF;

Line 5312: RAISE FND_API.G_EXC_ERROR;

5308:
5309: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5311: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5312: RAISE FND_API.G_EXC_ERROR;
5313: END IF;
5314:
5315: END IF;
5316:

Line 5323: x_return_status := FND_API.G_RET_STS_SUCCESS;

5319: IF g_debug_call > 0 THEN
5320: G_DEBUG_MSG := G_DEBUG_MSG || '216';
5321: END IF;
5322:
5323: x_return_status := FND_API.G_RET_STS_SUCCESS;
5324:
5325: IF l_debug_level > 0 THEN
5326: oe_debug_pub.add( 'EXITING PROCESS_SHIPPING_ACTIVITY SUCCESSFULLY ' , 0.5 ) ; -- debug level changed to 0.5 for bug 13435459
5327: END IF;

Line 5331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5327: END IF;
5328:
5329: EXCEPTION
5330:
5331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5332: IF l_debug_level > 0 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 ;

Line 5335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5332: IF l_debug_level > 0 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');

Line 5345: WHEN FND_API.G_EXC_ERROR THEN

5341: IF g_debug_call > 0 THEN
5342: G_DEBUG_MSG := G_DEBUG_MSG || 'E-33';
5343: END IF;
5344:
5345: WHEN FND_API.G_EXC_ERROR THEN
5346: IF l_debug_level > 0 THEN
5347: oe_debug_pub.add( 'PROCESS_SHIPPING_ACTIVITY : EXE ERROR' , 1 ) ;
5348: END IF;
5349: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5349: x_return_status := FND_API.G_RET_STS_ERROR;

5345: WHEN FND_API.G_EXC_ERROR THEN
5346: IF l_debug_level > 0 THEN
5347: oe_debug_pub.add( 'PROCESS_SHIPPING_ACTIVITY : EXE ERROR' , 1 ) ;
5348: END IF;
5349: x_return_status := FND_API.G_RET_STS_ERROR;
5350: IF g_debug_call > 0 THEN
5351: G_DEBUG_MSG := G_DEBUG_MSG || 'E-34';
5352: END IF;
5353:

Line 5362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5358:
5359: IF l_debug_level > 0 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');

Line 5397: l_lines_not_at_ship VARCHAR2(1) := FND_API.G_FALSE;

5393: IS
5394: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5395: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5396: l_update_lines_index NUMBER := 0;
5397: l_lines_not_at_ship VARCHAR2(1) := FND_API.G_FALSE;
5398: l_activity_status_code VARCHAR2(8);
5399: l_dummy VARCHAR2(52);
5400: l_line_index NUMBER;
5401: --

Line 5410: x_return_status := FND_API.G_RET_STS_SUCCESS;

5406: IF l_debug_level > 0 THEN
5407: oe_debug_pub.add( 'ENTERING PROCESS_SMC_SHIPPING' , 3 ) ;
5408: END IF;
5409:
5410: x_return_status := FND_API.G_RET_STS_SUCCESS;
5411:
5412: OE_Config_Util.Query_Options
5413: (p_top_model_line_id => p_top_model_line_id,
5414: x_line_tbl => l_line_tbl);

Line 5479: := FND_API.G_FALSE;

5475: l_update_lines_index := l_update_lines_index + 1;
5476: l_update_lines_tbl(l_update_lines_index).entity_id
5477: := l_line_tbl(l_line_index).line_id;
5478: l_update_lines_tbl(l_update_lines_index).param1
5479: := FND_API.G_FALSE;
5480: l_update_lines_tbl(l_update_lines_index).param2
5481: := FND_API.G_FALSE;
5482: l_update_lines_tbl(l_update_lines_index).param4
5483: := FND_API.G_TRUE;

Line 5481: := FND_API.G_FALSE;

5477: := l_line_tbl(l_line_index).line_id;
5478: l_update_lines_tbl(l_update_lines_index).param1
5479: := FND_API.G_FALSE;
5480: l_update_lines_tbl(l_update_lines_index).param2
5481: := FND_API.G_FALSE;
5482: l_update_lines_tbl(l_update_lines_index).param4
5483: := FND_API.G_TRUE;
5484: END IF;
5485: END IF; -- if shippable

Line 5483: := FND_API.G_TRUE;

5479: := FND_API.G_FALSE;
5480: l_update_lines_tbl(l_update_lines_index).param2
5481: := FND_API.G_FALSE;
5482: l_update_lines_tbl(l_update_lines_index).param4
5483: := FND_API.G_TRUE;
5484: END IF;
5485: END IF; -- if shippable
5486:
5487:

Line 5514: l_lines_not_at_ship := FND_API.G_TRUE;

5510: WHEN no_data_found THEN
5511: IF l_debug_level > 0 THEN
5512: oe_debug_pub.add( 'ATO MODEL NOT PROCESSED IN A SMC' , 1 ) ;
5513: END IF;
5514: l_lines_not_at_ship := FND_API.G_TRUE;
5515:
5516: WHEN others THEN
5517: IF l_debug_level > 0 THEN
5518: oe_debug_pub.add( 'ATO MODEL SQL '|| SQLERRM , 1 ) ;

Line 5546: l_lines_not_at_ship := FND_API.G_TRUE;

5542: IF l_debug_level > 0 THEN
5543: oe_debug_pub.add( 'NOT AT SHIPPING: '|| TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) || ' '|| L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;
5544: END IF;
5545:
5546: l_lines_not_at_ship := FND_API.G_TRUE;
5547:
5548: WHEN TOO_MANY_ROWS THEN
5549: IF l_debug_level > 0 THEN
5550: oe_debug_pub.add( 'LINE IS AT SHIPPING TOO MANY ROWS : ' || TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) || ' ' || L_LINE_TBL ( L_LINE_INDEX ) .ITEM_TYPE_CODE , 3 ) ;

Line 5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5554: IF l_debug_level > 0 THEN
5555: oe_debug_pub.add( 'PROCESS SHIPPING ACTIVITY :'||SUBSTR ( SQLERRM , 1 , 200 ) , 3 ) ;
5556: END IF;
5557:
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END;
5560:
5561: IF l_lines_not_at_ship = FND_API.G_TRUE THEN
5562: IF l_debug_level > 0 THEN

Line 5561: IF l_lines_not_at_ship = FND_API.G_TRUE THEN

5557:
5558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5559: END;
5560:
5561: IF l_lines_not_at_ship = FND_API.G_TRUE THEN
5562: IF l_debug_level > 0 THEN
5563: oe_debug_pub.add( 'ALL LINES NOT AT SHIP , RETURNING...' , 1 ) ;
5564: END IF;
5565: RETURN;

Line 5592: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5588: Update_Shipping_From_OE
5589: ( p_update_lines_tbl => l_update_lines_tbl,
5590: x_return_status => x_return_status);
5591:
5592: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5594: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: END IF;

Line 5593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5589: ( p_update_lines_tbl => l_update_lines_tbl,
5590: x_return_status => x_return_status);
5591:
5592: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5594: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: END IF;
5597: IF l_debug_level > 0 THEN

Line 5594: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

5590: x_return_status => x_return_status);
5591:
5592: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5594: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: END IF;
5597: IF l_debug_level > 0 THEN
5598: oe_debug_pub.add( 'UPDATE_SHIPPING_FROM_OE : '|| X_RETURN_STATUS , 3 ) ;

Line 5595: RAISE FND_API.G_EXC_ERROR;

5591:
5592: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5593: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5594: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5595: RAISE FND_API.G_EXC_ERROR;
5596: END IF;
5597: IF l_debug_level > 0 THEN
5598: oe_debug_pub.add( 'UPDATE_SHIPPING_FROM_OE : '|| X_RETURN_STATUS , 3 ) ;
5599: END IF;

Line 5624: (1.0, l_line_tbl(l_line_index).line_id) = FND_API.G_TRUE AND

5620: END IF;
5621:
5622: IF nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'N' AND
5623: OE_Shipping_Integration_PUB.Is_Activity_Shipping
5624: (1.0, l_line_tbl(l_line_index).line_id) = FND_API.G_TRUE AND
5625: p_line_id <> l_line_tbl(l_line_index).line_id THEN
5626:
5627: IF l_debug_level > 0 THEN
5628: oe_debug_pub.add( 'COMP SHIP_LINE , NONSHIP: '||L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID , 3 ) ;

Line 5663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5659: oe_debug_pub.add( 'LEAVING PROCESS_SMC_SHIPPING' , 3 ) ;
5660: END IF;
5661:
5662: EXCEPTION
5663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5664: IF l_debug_level > 0 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 ;

Line 5667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5664: IF l_debug_level > 0 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');

Line 5677: WHEN FND_API.G_EXC_ERROR THEN

5673: IF g_debug_call > 0 THEN
5674: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-36';
5675: END IF;
5676:
5677: WHEN FND_API.G_EXC_ERROR THEN
5678: IF l_debug_level > 0 THEN
5679: oe_debug_pub.add( 'PROCESS_SMC_SHIPPING : EXE ERROR' , 1 ) ;
5680: END IF;
5681: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5681: x_return_status := FND_API.G_RET_STS_ERROR;

5677: WHEN FND_API.G_EXC_ERROR THEN
5678: IF l_debug_level > 0 THEN
5679: oe_debug_pub.add( 'PROCESS_SMC_SHIPPING : EXE ERROR' , 1 ) ;
5680: END IF;
5681: x_return_status := FND_API.G_RET_STS_ERROR;
5682: IF g_debug_call > 0 THEN
5683: G_DEBUG_MSG := G_DEBUG_MSG || 'E-37';
5684: END IF;
5685:

Line 5694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5690:
5691: IF l_debug_level > 0 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');

Line 5808: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5804: ,p_caller => 'Ship_Confirm_Split_Lines'
5805: ,x_return_status => l_return_status);
5806:
5807:
5808: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5811: RAISE FND_API.G_EXC_ERROR;
5812: END IF;

Line 5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5805: ,x_return_status => l_return_status);
5806:
5807:
5808: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5811: RAISE FND_API.G_EXC_ERROR;
5812: END IF;
5813:

Line 5810: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5806:
5807:
5808: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5811: RAISE FND_API.G_EXC_ERROR;
5812: END IF;
5813:
5814:

Line 5811: RAISE FND_API.G_EXC_ERROR;

5807:
5808: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5809: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5810: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5811: RAISE FND_API.G_EXC_ERROR;
5812: END IF;
5813:
5814:
5815: UPDATE OE_ORDER_LINES

Line 5840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5836: IF l_debug_level > 0 THEN
5837: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
5838: END IF;
5839:
5840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5843: RAISE FND_API.G_EXC_ERROR;
5844: END IF;

Line 5841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5837: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
5838: END IF;
5839:
5840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5843: RAISE FND_API.G_EXC_ERROR;
5844: END IF;
5845:

Line 5842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5838: END IF;
5839:
5840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5843: RAISE FND_API.G_EXC_ERROR;
5844: END IF;
5845:
5846: END IF; -- if wdd has lines staged/shipped or not deleted

Line 5843: RAISE FND_API.G_EXC_ERROR;

5839:
5840: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5841: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5842: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5843: RAISE FND_API.G_EXC_ERROR;
5844: END IF;
5845:
5846: END IF; -- if wdd has lines staged/shipped or not deleted
5847:

Line 5893: x_return_status := FND_API.G_RET_STS_SUCCESS;

5889:
5890: Print_Time
5891: ('entering Call_Notification_Framework ' || p_caller);
5892:
5893: x_return_status := FND_API.G_RET_STS_SUCCESS;
5894:
5895:
5896: IF p_caller = 'Ship_Confirm_Split_Lines' THEN
5897: l_line_tbl(I) := p_line_rec;

Line 5938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5934: oe_debug_pub.add
5935: (J || ' UPDATE_GLOBAL ret sts: ' || x_RETURN_STATUS);
5936: END IF;
5937:
5938: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5939: RETURN;
5940: END IF;
5941:
5942:

Line 5994: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5990: IF g_debug_call > 0 THEN
5991: G_DEBUG_MSG := G_DEBUG_MSG || '14-7';
5992: END IF;
5993:
5994: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5995: RETURN;
5996: END IF;
5997:
5998: END IF; -- aso_installed

Line 6043: ,p_init_msg_list => FND_API.G_TRUE

6039: l_action_rec.org_id := MO_GLOBAL.get_current_org_id();
6040:
6041: WSH_bulk_process_grp.Create_update_delivery_details
6042: ( p_api_version_number => 1.0
6043: ,p_init_msg_list => FND_API.G_TRUE
6044: ,p_commit => FND_API.G_FALSE
6045: ,p_action_prms => l_action_rec
6046: ,p_line_rec => p_line_rec
6047: ,x_out_rec => l_out_rec

Line 6044: ,p_commit => FND_API.G_FALSE

6040:
6041: WSH_bulk_process_grp.Create_update_delivery_details
6042: ( p_api_version_number => 1.0
6043: ,p_init_msg_list => FND_API.G_TRUE
6044: ,p_commit => FND_API.G_FALSE
6045: ,p_action_prms => l_action_rec
6046: ,p_line_rec => p_line_rec
6047: ,x_out_rec => l_out_rec
6048: ,x_return_status => l_return_status

Line 6055: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR

6051:
6052: oe_debug_pub.add
6053: ('return status from WSH '|| l_return_status || '-' || l_msg_count, 5);
6054:
6055: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR
6056: l_return_status = 'W' THEN
6057:
6058: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
6059: OE_Sys_Parameters.Value('FIRM_DEMAND_EVENTS') = 'SHIPPING_INTERFACED'

Line 6137: (p_encoded => FND_API.G_FALSE,

6133:
6134: END IF;
6135:
6136: Fnd_Msg_Pub.GET
6137: (p_encoded => FND_API.G_FALSE,
6138: p_data => l_error_msg,
6139: p_msg_index_out => l_msg_index);
6140:
6141: IF l_debug_level > 0 THEN

Line 6162: x_return_status := FND_API.G_RET_STS_SUCCESS;

6158:
6159: END IF; -- if there were errors
6160:
6161: IF l_return_status = 'W' THEN
6162: x_return_status := FND_API.G_RET_STS_SUCCESS;
6163: ELSE
6164: x_return_status := l_return_status;
6165: END IF;
6166:

Line 6172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6168: oe_debug_pub.add('return status from vshpb'|| x_return_status, 5);
6169: END IF;
6170:
6171: EXCEPTION
6172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6173: IF l_debug_level > 0 THEN
6174: oe_debug_pub.add('OM_TO_WSH_INTERFACE : UNEXPECTED ERROR',1);
6175: END IF;
6176:

Line 6177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6173: IF l_debug_level > 0 THEN
6174: oe_debug_pub.add('OM_TO_WSH_INTERFACE : UNEXPECTED ERROR',1);
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');

Line 6187: WHEN FND_API.G_EXC_ERROR THEN

6183: IF g_debug_call > 0 THEN
6184: G_DEBUG_MSG := G_DEBUG_MSG || 'E-39';
6185: END IF;
6186:
6187: WHEN FND_API.G_EXC_ERROR THEN
6188: IF l_debug_level > 0 THEN
6189: oe_debug_pub.add('OM_TO_WSH_INTERFACE : EXE ERROR',1);
6190: END IF;
6191: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6191: x_return_status := FND_API.G_RET_STS_ERROR;

6187: WHEN FND_API.G_EXC_ERROR THEN
6188: IF l_debug_level > 0 THEN
6189: oe_debug_pub.add('OM_TO_WSH_INTERFACE : EXE ERROR',1);
6190: END IF;
6191: x_return_status := FND_API.G_RET_STS_ERROR;
6192:
6193: WHEN OTHERS THEN
6194: IF l_debug_level > 0 THEN
6195: oe_debug_pub.add('OM_TO_WSH_INTERFACE, OTHERS '|| sqlerrm ,1);

Line 6201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6197:
6198: IF l_debug_level > 0 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');