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 377: l_line_at_shipping := FND_API.G_FALSE;

373: FOR l_line_index IN p_update_lines_tbl.First .. p_update_lines_tbl.Last
374: LOOP
375:
376: l_line_id := p_update_lines_tbl(l_line_index).entity_id;
377: l_line_at_shipping := FND_API.G_FALSE;
378:
379: OE_Line_Util.Query_Row --bug 4516453, moved query_row here to set msg context
380: ( p_line_id => l_line_id,
381: x_line_rec => l_line_rec);

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

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

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

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

Line 466: l_line_at_shipping := FND_API.G_TRUE;

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

Line 488: := FND_API.G_MISS_CHAR;

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

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

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

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

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

Line 541: AND l_line_at_shipping = FND_API.G_TRUE THEN

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

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

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

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

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

Line 800: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 801: RAISE FND_API.G_EXC_ERROR;

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

Line 802: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 856: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 857: RAISE FND_API.G_EXC_ERROR;

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

Line 858: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR

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

Line 860: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 894: RAISE FND_API.G_EXC_ERROR;

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

Line 939: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 940: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 941: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 942: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1264: IF g_debug_call > 0 THEN
1265: G_DEBUG_MSG := G_DEBUG_MSG || '46,';
1266: END IF;
1267:
1268: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1269:
1270: --Changes for Bug - 2898616
1271: IF l_force_ui = 'Y' THEN
1272: IF l_debug_level > 0 THEN

Line 1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1274: END IF;
1275: OE_GLOBALS.G_FORCE_CLEAR_UI_BLOCK := 'Y';
1276: END IF;
1277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1278: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1279: -- 3571148 changes
1280: IF l_debug_level > 0 THEN
1281: oe_debug_pub.add( ' INSIDE EXPECTED ERROR' , 1 ) ;
1282: END IF;

Line 1341: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1368: RAISE fnd_api.g_exc_error;

1364: oe_debug_pub.ADD('Bug 6391881::: l_ok_to_cancel is false.', 1);
1365: END IF;
1366:
1367: IF NOT ( l_wsh_no_data_found = TRUE AND l_ok_to_cancel = TRUE ) THEN
1368: RAISE fnd_api.g_exc_error;
1369: END IF;
1370: -- End: Changes for bug 6391881
1371:
1372: IF g_debug_call > 0 THEN

Line 1451: l_return_status := FND_API.G_RET_STS_SUCCESS;

1447: END IF; -- return status check
1448:
1449: ELSE
1450:
1451: l_return_status := FND_API.G_RET_STS_SUCCESS;
1452: IF l_debug_level > 0 THEN
1453: oe_debug_pub.add('DO NOT CALL SHIPPING API,RETURN SUCCESS ',3);
1454: END IF;
1455:

Line 1486: RAISE FND_API.G_EXC_ERROR ;

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

Line 1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1499: oe_debug_pub.add( 'returning from UPDATE_SHIPPING_FROM_OE' , 1 ) ;
1500: END IF;
1501:
1502: EXCEPTION
1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1504:
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506:
1507: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1501:
1502: EXCEPTION
1503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1504:
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1506:
1507: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1508: THEN
1509: OE_MSG_PUB.Add_Exc_Msg

Line 1519: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1520: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1523: IF g_debug_call > 0 THEN
1524: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-4';
1525: END IF;
1526: WHEN OTHERS THEN
1527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1528:
1529: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1530: THEN
1531: OE_MSG_PUB.Add_Exc_Msg

Line 1552: , p_hold_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1548: -----------------------------------------------------------------*/
1549: PROCEDURE Update_Shipping_PVT
1550: (
1551: p_line_id IN NUMBER
1552: , p_hold_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1553: , p_shipping_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1554: , x_return_status OUT NOCOPY VARCHAR2
1555:
1556: )

Line 1553: , p_shipping_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

1549: PROCEDURE Update_Shipping_PVT
1550: (
1551: p_line_id IN NUMBER
1552: , p_hold_type IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1553: , p_shipping_activity IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
1554: , x_return_status OUT NOCOPY VARCHAR2
1555:
1556: )
1557: IS

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

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

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

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

Line 1578: p_hold_type <> FND_API.G_MISS_CHAR THEN

1574: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
1575: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
1576:
1577: IF p_hold_type IS NOT NULL AND
1578: p_hold_type <> FND_API.G_MISS_CHAR THEN
1579:
1580: l_update_lines_tbl(1).param3 := p_hold_type;
1581:
1582: END IF;

Line 1585: p_shipping_activity <> FND_API.G_MISS_CHAR THEN

1581:
1582: END IF;
1583:
1584: IF p_shipping_activity IS NOT NULL AND
1585: p_shipping_activity <> FND_API.G_MISS_CHAR THEN
1586:
1587: l_update_lines_tbl(1).param4 := p_shipping_activity;
1588:
1589: END IF;

Line 1597: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1593: p_update_lines_tbl => l_update_lines_tbl,
1594: x_return_status => x_return_status
1595: );
1596:
1597: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;

Line 1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1594: x_return_status => x_return_status
1595: );
1596:
1597: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1598: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1599: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602: IF l_debug_level > 0 THEN

Line 1599: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1600: RAISE FND_API.G_EXC_ERROR;

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

Line 1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1606: G_DEBUG_MSG := G_DEBUG_MSG || '54,';
1607: END IF;
1608: EXCEPTION
1609:
1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612:
1613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN

Line 1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1607: END IF;
1608: EXCEPTION
1609:
1610: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1612:
1613: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1614: THEN
1615: OE_MSG_PUB.Add_Exc_Msg

Line 1623: WHEN FND_API.G_EXC_ERROR THEN

1619: END IF;
1620: IF g_debug_call > 0 THEN
1621: G_DEBUG_MSG := G_DEBUG_MSG || 'E6,';
1622: END IF;
1623: WHEN FND_API.G_EXC_ERROR THEN
1624: x_return_status := FND_API.G_RET_STS_ERROR;
1625: WHEN OTHERS THEN
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1627:

Line 1624: x_return_status := FND_API.G_RET_STS_ERROR;

1620: IF g_debug_call > 0 THEN
1621: G_DEBUG_MSG := G_DEBUG_MSG || 'E6,';
1622: END IF;
1623: WHEN FND_API.G_EXC_ERROR THEN
1624: x_return_status := FND_API.G_RET_STS_ERROR;
1625: WHEN OTHERS THEN
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1627:
1628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1622: END IF;
1623: WHEN FND_API.G_EXC_ERROR THEN
1624: x_return_status := FND_API.G_RET_STS_ERROR;
1625: WHEN OTHERS THEN
1626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1627:
1628: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: OE_MSG_PUB.Add_Exc_Msg

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

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

Line 1734: l_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN

1730: END IF; -- if part of model
1731:
1732:
1733: IF l_line_rec.ship_tolerance_below IS NULL OR
1734: l_line_rec.ship_tolerance_below = FND_API.G_MISS_NUM THEN
1735: l_ship_tolerance_below := 0;
1736: ELSE
1737: l_ship_tolerance_below := l_line_rec.ship_tolerance_below;
1738: END IF;

Line 1742: l_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN

1738: END IF;
1739:
1740:
1741: IF l_line_rec.ship_tolerance_above IS NULL OR
1742: l_line_rec.ship_tolerance_above = FND_API.G_MISS_NUM THEN
1743:
1744: l_ship_tolerance_above := 0;
1745: ELSE
1746: l_ship_tolerance_above := l_line_rec.ship_tolerance_above;

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

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

Line 1776: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1772: x_return_status => l_x_return_status,
1773: x_msg_count => l_msg_count,
1774: x_msg_data => l_msg_data);
1775:
1776: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1778: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1779: RAISE FND_API.G_EXC_ERROR;
1780: END IF;

Line 1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1778: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

1774: x_msg_data => l_msg_data);
1775:
1776: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1778: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1779: RAISE FND_API.G_EXC_ERROR;
1780: END IF;
1781:
1782: ELSE

Line 1779: RAISE FND_API.G_EXC_ERROR;

1775:
1776: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1777: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1778: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
1779: RAISE FND_API.G_EXC_ERROR;
1780: END IF;
1781:
1782: ELSE
1783:

Line 2062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2058: oe_debug_pub.add('EXITING FROM CHECK_SHIPMENT_LINE : '||X_RESULT_OUT , 1 );
2059: END IF;
2060:
2061: EXCEPTION
2062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064:
2065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2066: THEN

Line 2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2059: END IF;
2060:
2061: EXCEPTION
2062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2063: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2064:
2065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2066: THEN
2067: OE_MSG_PUB.Add_Exc_Msg

Line 2098: p_top_model_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

2094: PROCEDURE Get_PTO_Shipped_Quantity
2095: ---------------------------------------------------------------------*/
2096: PROCEDURE Get_PTO_Shipped_Quantity
2097: (
2098: p_top_model_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
2099: , p_x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
2100: , x_ratio_status OUT NOCOPY VARCHAR2
2101:
2102: , x_return_status OUT NOCOPY VARCHAR2

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

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

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

2116: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;
2117: l_ship_date DATE;
2118:
2119: /* Added for bug 1952023 */
2120: l_over_shipped VARCHAR2(1) := FND_API.G_FALSE;
2121: l_under_shipped VARCHAR2(1) := FND_API.G_FALSE;
2122: l_line_shipped VARCHAR2(1) := FND_API.G_TRUE;
2123:
2124: --

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

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

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

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

Line 2133: p_top_model_line_id <> FND_API.G_MISS_NUM THEN

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

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

2179: G_DEBUG_MSG := G_DEBUG_MSG || '73,';
2180: END IF;
2181:
2182: IF nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'Y' THEN
2183: l_pto_shipment_tbl(l_pto_index).shippable_flag := FND_API.G_TRUE;
2184: l_ship_date := l_line_tbl(l_line_index).actual_shipment_date;
2185:
2186: IF nvl(l_line_tbl(l_line_index).shipped_quantity,0) = 0 THEN
2187: IF l_debug_level > 0 THEN

Line 2190: l_line_shipped := FND_API.G_FALSE;

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

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

2189: END IF;
2190: l_line_shipped := FND_API.G_FALSE;
2191: END IF;
2192: ELSE
2193: l_pto_shipment_tbl(l_pto_index).shippable_flag := FND_API.G_FALSE;
2194: END IF;
2195:
2196: /* Added for bug 1952023 */
2197: IF nvl(l_line_tbl(l_line_index).shipped_quantity,0) > nvl(l_line_tbl(l_line_index).ordered_quantity,0) THEN

Line 2202: l_over_shipped := FND_API.G_TRUE;

2198:
2199: IF l_debug_level > 0 THEN
2200: oe_debug_pub.add( 'LINE IS OVER SHIPPED '||L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID , 3 ) ;
2201: END IF;
2202: l_over_shipped := FND_API.G_TRUE;
2203:
2204: END IF;
2205:
2206: IF nvl(l_line_tbl(l_line_index).shipped_quantity,0) < nvl(l_line_tbl(l_line_index).ordered_quantity,0) AND

Line 2212: l_under_shipped := FND_API.G_TRUE;

2208:
2209: IF l_debug_level > 0 THEN
2210: oe_debug_pub.add( 'LINE IS UNDER SHIPPED '||L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID , 3 ) ;
2211: END IF;
2212: l_under_shipped := FND_API.G_TRUE;
2213:
2214: END IF;
2215:
2216: << END_PREPARE_LOOP >>

Line 2259: l_ratio_status = FND_API.G_TRUE

2255:
2256: l_pto_index := l_pto_shipment_tbl.FIRST;
2257:
2258: WHILE l_pto_index IS NOT NULL AND
2259: l_ratio_status = FND_API.G_TRUE
2260: LOOP
2261:
2262: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN
2263:

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

2258: WHILE l_pto_index IS NOT NULL AND
2259: l_ratio_status = FND_API.G_TRUE
2260: LOOP
2261:
2262: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN
2263:
2264: GOTO SKIP_THE_LINE;
2265:
2266: END IF;

Line 2282: l_ratio_status := FND_API.G_FALSE;

2278:
2279: IF l_debug_level > 0 THEN
2280: oe_debug_pub.add( 'PTO HAS NOT BEEN SHIPPED IN PROPORTION ' , 3 ) ;
2281: END IF;
2282: l_ratio_status := FND_API.G_FALSE;
2283: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2284: ELSE
2285: l_pto_shipment_tbl(l_parent_index).shipped_quantity := l_parent_shipped_quantity;
2286: END IF;

Line 2293: l_ratio_status := FND_API.G_FALSE;

2289:
2290: IF l_debug_level > 0 THEN
2291: oe_debug_pub.add( 'SHIPPED QUANTITY IN DECIMAL '||TO_CHAR ( L_PTO_SHIPMENT_TBL ( L_PARENT_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
2292: END IF;
2293: l_ratio_status := FND_API.G_FALSE;
2294: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2295:
2296: END IF;
2297:

Line 2309: l_ratio_status := FND_API.G_FALSE;

2305:
2306: IF l_debug_level > 0 THEN
2307: oe_debug_pub.add( 'PTO HAS NOT BEEN SHIPPED IN PROPORTION ' , 3 ) ;
2308: END IF;
2309: l_ratio_status := FND_API.G_FALSE;
2310: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2311: ELSE
2312: l_pto_shipment_tbl(l_top_index).shipped_quantity := l_top_shipped_quantity;
2313: END IF;

Line 2320: l_ratio_status := FND_API.G_FALSE;

2316:
2317: IF l_debug_level > 0 THEN
2318: oe_debug_pub.add( 'SHIPPED QUANTITY IN DECIMAL '||TO_CHAR ( L_PTO_SHIPMENT_TBL ( L_TOP_INDEX ) .SHIPPED_QUANTITY ) , 3 ) ;
2319: END IF;
2320: l_ratio_status := FND_API.G_FALSE;
2321: GOTO END_CALCULATE_SHIPPED_QUANTITY;
2322:
2323: END IF;
2324:

Line 2334: IF l_ratio_status = FND_API.G_TRUE THEN

2330: <>
2331:
2332: -- If the ratio is not broken populate the out line table.
2333:
2334: IF l_ratio_status = FND_API.G_TRUE THEN
2335:
2336: -- Assign the shipped quantity if not assigned to any of the lines
2337:
2338: l_pto_index := l_pto_shipment_tbl.FIRST;

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

2376: IF l_debug_level > 0 THEN
2377: 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 ) ;
2378: END IF;
2379:
2380: IF l_pto_shipment_tbl(l_pto_index).shippable_flag = FND_API.G_FALSE THEN
2381: p_x_line_tbl(l_final_index).shipped_quantity := l_pto_shipment_tbl(l_pto_index).shipped_quantity;
2382: p_x_line_tbl(l_final_index).actual_shipment_date := l_ship_date;
2383: IF l_debug_level > 0 THEN
2384: 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 2398: IF l_over_shipped = FND_API.G_TRUE AND

2394: END LOOP;
2395: /* Added for bug 1952023 */
2396: ELSE
2397:
2398: IF l_over_shipped = FND_API.G_TRUE AND
2399: l_under_shipped = FND_API.G_FALSE AND
2400: l_line_shipped = FND_API.G_TRUE THEN
2401:
2402: IF l_debug_level > 0 THEN

Line 2399: l_under_shipped = FND_API.G_FALSE AND

2395: /* Added for bug 1952023 */
2396: ELSE
2397:
2398: IF l_over_shipped = FND_API.G_TRUE AND
2399: l_under_shipped = FND_API.G_FALSE AND
2400: l_line_shipped = FND_API.G_TRUE THEN
2401:
2402: IF l_debug_level > 0 THEN
2403: 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 2400: l_line_shipped = FND_API.G_TRUE THEN

2396: ELSE
2397:
2398: IF l_over_shipped = FND_API.G_TRUE AND
2399: l_under_shipped = FND_API.G_FALSE AND
2400: l_line_shipped = FND_API.G_TRUE THEN
2401:
2402: IF l_debug_level > 0 THEN
2403: 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 ) ;
2404: END IF;

Line 2430: x_return_status := FND_API.G_RET_STS_SUCCESS;

2426: END IF;
2427:
2428: --x_line_tbl := l_line_tbl;
2429: x_ratio_status := l_ratio_status;
2430: x_return_status := FND_API.G_RET_STS_SUCCESS;
2431:
2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;
2434: END IF;

Line 2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2432: IF l_debug_level > 0 THEN
2433: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;
2434: END IF;
2435: EXCEPTION
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2438:
2439: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2440: THEN

Line 2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2433: oe_debug_pub.add( 'EXITING OE_SHIPPING_INTEGRATION_PVT.GET_PTO_SHIPPED_QUANTITY ' , 1 ) ;
2434: END IF;
2435: EXCEPTION
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2438:
2439: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2440: THEN
2441: OE_MSG_PUB.Add_Exc_Msg

Line 2450: WHEN FND_API.G_EXC_ERROR THEN

2446: IF g_debug_call > 0 THEN
2447: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-10';
2448: END IF;
2449:
2450: WHEN FND_API.G_EXC_ERROR THEN
2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: IF g_debug_call > 0 THEN
2453: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-11';
2454: END IF;

Line 2451: x_return_status := FND_API.G_RET_STS_ERROR;

2447: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-10';
2448: END IF;
2449:
2450: WHEN FND_API.G_EXC_ERROR THEN
2451: x_return_status := FND_API.G_RET_STS_ERROR;
2452: IF g_debug_call > 0 THEN
2453: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-11';
2454: END IF;
2455:

Line 2457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2453: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-11';
2454: END IF;
2455:
2456: WHEN OTHERS THEN
2457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2458:
2459: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2460: THEN
2461: OE_MSG_PUB.Add_Exc_Msg

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

2505: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2506: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2507: l_split_index NUMBER :=0;
2508: l_pto_index NUMBER;
2509: l_ratio_status VARCHAR2(1) := FND_API.G_TRUE;
2510: l_ship_tolerance_below NUMBER;
2511: l_ship_tolerance_above NUMBER;
2512: l_update_tolerance_value NUMBER := 0 ;
2513: l_x_result_out VARCHAR2(30);

Line 2556: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2552: ,p_x_line_tbl => l_line_tbl
2553: ,x_ratio_status => l_ratio_status
2554: ,x_return_status => l_return_status );
2555:
2556: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;

Line 2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2553: ,x_ratio_status => l_ratio_status
2554: ,x_return_status => l_return_status );
2555:
2556: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;
2561:

Line 2558: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2554: ,x_return_status => l_return_status );
2555:
2556: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;
2561:
2562: -- Get the top model line id index.

Line 2559: RAISE FND_API.G_EXC_ERROR;

2555:
2556: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2558: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2559: RAISE FND_API.G_EXC_ERROR;
2560: END IF;
2561:
2562: -- Get the top model line id index.
2563:

Line 2606: IF l_ratio_status = FND_API.G_TRUE THEN

2602:
2603: -- Check for shipment status when the ratio is not broken and the ship
2604: -- tolerances will be honoured.
2605:
2606: IF l_ratio_status = FND_API.G_TRUE THEN
2607:
2608: -- Loop to Update the shipped quantity of non shippable lines by calling
2609: -- process_order.
2610:

Line 2691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2687: l_set_recursion := 'N';
2688: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2689: END IF;
2690:
2691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;

Line 2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2688: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2689: END IF;
2690:
2691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696: IF g_debug_call > 0 THEN

Line 2693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2689: END IF;
2690:
2691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696: IF g_debug_call > 0 THEN
2697: G_DEBUG_MSG := G_DEBUG_MSG || '88,';

Line 2694: RAISE FND_API.G_EXC_ERROR;

2690:
2691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2694: RAISE FND_API.G_EXC_ERROR;
2695: END IF;
2696: IF g_debug_call > 0 THEN
2697: G_DEBUG_MSG := G_DEBUG_MSG || '88,';
2698: END IF;

Line 2811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2807: l_set_recursion := 'N';
2808: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2809: END IF;
2810:
2811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;

Line 2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2808: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2809: END IF;
2810:
2811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;
2816:

Line 2813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2809: END IF;
2810:
2811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;
2816:
2817: IF l_debug_level > 0 THEN

Line 2814: RAISE FND_API.G_EXC_ERROR;

2810:
2811: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2812: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2813: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2814: RAISE FND_API.G_EXC_ERROR;
2815: END IF;
2816:
2817: IF l_debug_level > 0 THEN
2818: oe_debug_pub.add( 'RET STS FROM PROCESS ORDER: '||L_RETURN_STATUS , 3 ) ;

Line 2851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2847: p_shipment_status => l_x_result_out,
2848: x_return_status => x_return_status );
2849:
2850:
2851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;

Line 2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2848: x_return_status => x_return_status );
2849:
2850:
2851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;
2856:

Line 2853: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2849:
2850:
2851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;
2856:
2857: END IF;

Line 2854: RAISE FND_API.G_EXC_ERROR;

2850:
2851: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2853: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2854: RAISE FND_API.G_EXC_ERROR;
2855: END IF;
2856:
2857: END IF;
2858:

Line 2871: ELSIF l_ratio_status = FND_API.G_FALSE THEN

2867: IF g_debug_call > 0 THEN
2868: G_DEBUG_MSG := G_DEBUG_MSG || '84,';
2869: END IF;
2870:
2871: ELSIF l_ratio_status = FND_API.G_FALSE THEN
2872:
2873: IF l_debug_level > 0 THEN
2874: oe_debug_pub.add( 'NOT SHIPPED , SHIPMENT RATIO IS BROKEN : ' , 3 ) ;
2875: END IF;

Line 2971: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2967: oe_split_util.cascade_non_proportional_Split
2968: (p_x_line_tbl => l_split_line_tbl,
2969: x_return_status => l_return_status);
2970:
2971: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2974: RAISE FND_API.G_EXC_ERROR;
2975: END IF;

Line 2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2968: (p_x_line_tbl => l_split_line_tbl,
2969: x_return_status => l_return_status);
2970:
2971: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2974: RAISE FND_API.G_EXC_ERROR;
2975: END IF;
2976:

Line 2973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2969: x_return_status => l_return_status);
2970:
2971: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2974: RAISE FND_API.G_EXC_ERROR;
2975: END IF;
2976:
2977: IF l_debug_level > 0 THEN

Line 2974: RAISE FND_API.G_EXC_ERROR;

2970:
2971: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2973: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2974: RAISE FND_API.G_EXC_ERROR;
2975: END IF;
2976:
2977: IF l_debug_level > 0 THEN
2978: oe_debug_pub.add( 'RET STS FROM NON PRO SPLIT/'||L_RETURN_STATUS , 3 ) ;

Line 3040: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3036: ( p_line_rec => l_split_line_tbl(l_split_index),
3037: p_shipment_status => l_x_result_out,
3038: x_return_status => x_return_status );
3039:
3040: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;

Line 3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3037: p_shipment_status => l_x_result_out,
3038: x_return_status => x_return_status );
3039:
3040: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:

Line 3042: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3038: x_return_status => x_return_status );
3039:
3040: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:
3046: END IF;

Line 3043: RAISE FND_API.G_EXC_ERROR;

3039:
3040: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3041: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3042: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3043: RAISE FND_API.G_EXC_ERROR;
3044: END IF;
3045:
3046: END IF;
3047: ---- non shippable lines not in fulfillment set start ---------

Line 3051: AND l_fulfillment_set_flag = FND_API.G_FALSE THEN

3047: ---- non shippable lines not in fulfillment set start ---------
3048:
3049: ELSIF nvl(l_split_line_tbl(l_split_index).shippable_flag,'N')= 'N' AND
3050: nvl(l_split_line_tbl(l_split_index).model_remnant_flag,'N') = 'Y'
3051: AND l_fulfillment_set_flag = FND_API.G_FALSE THEN
3052:
3053: l_item_key := to_char(l_split_line_tbl(l_split_index).line_id);
3054:
3055: IF l_debug_level > 0 THEN

Line 3074: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3070: END IF;
3071: IF g_debug_call > 0 THEN
3072: G_DEBUG_MSG := G_DEBUG_MSG || '89';
3073: END IF;
3074: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3076: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3077: IF l_debug_level > 0 THEN
3078: oe_debug_pub.add( 'LINE IS NOT AT FULFILLMENT ACTIVITY : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID ) , 3 ) ;

Line 3075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3071: IF g_debug_call > 0 THEN
3072: G_DEBUG_MSG := G_DEBUG_MSG || '89';
3073: END IF;
3074: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3076: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3077: IF l_debug_level > 0 THEN
3078: oe_debug_pub.add( 'LINE IS NOT AT FULFILLMENT ACTIVITY : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID ) , 3 ) ;
3079: END IF;

Line 3076: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3072: G_DEBUG_MSG := G_DEBUG_MSG || '89';
3073: END IF;
3074: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3075: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3076: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3077: IF l_debug_level > 0 THEN
3078: oe_debug_pub.add( 'LINE IS NOT AT FULFILLMENT ACTIVITY : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( L_SPLIT_INDEX ) .LINE_ID ) , 3 ) ;
3079: END IF;
3080: ELSE

Line 3099: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3095: p_activity_id => l_activity_id,
3096: x_fulfillment_activity => l_fulfillment_activity,
3097: x_return_status => l_return_status);
3098:
3099: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3102: RAISE FND_API.G_EXC_ERROR;
3103: END IF;

Line 3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3096: x_fulfillment_activity => l_fulfillment_activity,
3097: x_return_status => l_return_status);
3098:
3099: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3102: RAISE FND_API.G_EXC_ERROR;
3103: END IF;
3104:

Line 3101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3097: x_return_status => l_return_status);
3098:
3099: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3102: RAISE FND_API.G_EXC_ERROR;
3103: END IF;
3104:
3105: IF l_debug_level > 0 THEN

Line 3102: RAISE FND_API.G_EXC_ERROR;

3098:
3099: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3102: RAISE FND_API.G_EXC_ERROR;
3103: END IF;
3104:
3105: IF l_debug_level > 0 THEN
3106: oe_debug_pub.add( 'FULFILLMENT ACT : '||L_FULFILLMENT_ACTIVITY , 3 ) ;

Line 3173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3169: p_fulfillment_type => 'No Activity',
3170: p_fulfillment_activity => 'NO_ACTIVITY',
3171: x_return_status => l_return_status);
3172:
3173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;

Line 3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3170: p_fulfillment_activity => 'NO_ACTIVITY',
3171: x_return_status => l_return_status);
3172:
3173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;
3178:

Line 3175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3171: x_return_status => l_return_status);
3172:
3173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;
3178:
3179: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count

Line 3176: RAISE FND_API.G_EXC_ERROR;

3172:
3173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3176: RAISE FND_API.G_EXC_ERROR;
3177: END IF;
3178:
3179: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count
3180: LOOP

Line 3195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3191: IF l_debug_level > 0 THEN
3192: oe_debug_pub.add( 'RET STS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3193: END IF;
3194:
3195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;

Line 3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3192: oe_debug_pub.add( 'RET STS FROM FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3193: END IF;
3194:
3195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200:

Line 3197: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3193: END IF;
3194:
3195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200:
3201: l_item_key := to_char(l_fulfill_tbl(l_fulfill_index).line_id);

Line 3198: RAISE FND_API.G_EXC_ERROR;

3194:
3195: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3197: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3198: RAISE FND_API.G_EXC_ERROR;
3199: END IF;
3200:
3201: l_item_key := to_char(l_fulfill_tbl(l_fulfill_index).line_id);
3202:

Line 3233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3229: IF l_debug_level > 0 THEN
3230: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
3231: END IF;
3232:
3233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3236: RAISE FND_API.G_EXC_ERROR;
3237: END IF;

Line 3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3230: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
3231: END IF;
3232:
3233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3236: RAISE FND_API.G_EXC_ERROR;
3237: END IF;
3238:

Line 3235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3231: END IF;
3232:
3233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3236: RAISE FND_API.G_EXC_ERROR;
3237: END IF;
3238:
3239: END LOOP; -- fulfill table has rows.

Line 3236: RAISE FND_API.G_EXC_ERROR;

3232:
3233: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3234: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3235: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3236: RAISE FND_API.G_EXC_ERROR;
3237: END IF;
3238:
3239: END LOOP; -- fulfill table has rows.
3240:

Line 3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3248: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_PTO_KIT : '||X_RETURN_STATUS , 1 ) ;
3249: END IF;
3250:
3251: EXCEPTION
3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3254:
3255: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3256: THEN

Line 3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3249: END IF;
3250:
3251: EXCEPTION
3252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3254:
3255: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3256: THEN
3257: OE_MSG_PUB.Add_Exc_Msg

Line 3263: WHEN FND_API.G_EXC_ERROR THEN

3259: , 'Ship_Confirm_PTO_KIT'
3260: );
3261: END IF;
3262:
3263: WHEN FND_API.G_EXC_ERROR THEN
3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265:
3266: WHEN OTHERS THEN
3267: IF l_debug_level > 0 THEN

Line 3264: x_return_status := FND_API.G_RET_STS_ERROR;

3260: );
3261: END IF;
3262:
3263: WHEN FND_API.G_EXC_ERROR THEN
3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265:
3266: WHEN OTHERS THEN
3267: IF l_debug_level > 0 THEN
3268: oe_debug_pub.add( 'SHIP_CONFIRM_PTO_KIT : EXITING WITH OTHERS ERROR' , 1 ) ;

Line 3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3272: END IF;
3273: IF g_debug_call > 0 THEN
3274: G_DEBUG_MSG := G_DEBUG_MSG || 'E9';
3275: END IF;
3276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3277:
3278: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3279: THEN
3280: OE_MSG_PUB.Add_Exc_Msg

Line 3296: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM

3292:
3293:
3294: /*--------------------------------------------------------------*/
3295: PROCEDURE Ship_Confirm_Standard_Line
3296: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3297: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3298: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3299: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3300: ,p_check_line_set IN VARCHAR2 := 'Y'

Line 3299: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR

3295: PROCEDURE Ship_Confirm_Standard_Line
3296: (p_line_id IN NUMBER DEFAULT FND_API.G_MISS_NUM
3297: ,p_line_rec IN OE_ORDER_PUB.line_rec_type
3298: DEFAULT OE_ORDER_PUB.G_MISS_LINE_REC
3299: ,p_shipment_status IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR
3300: ,p_check_line_set IN VARCHAR2 := 'Y'
3301: ,x_return_status OUT NOCOPY VARCHAR2)
3302:
3303: IS

Line 3337: p_line_id = FND_API.G_MISS_NUM THEN

3333: G_DEBUG_MSG := G_DEBUG_MSG || '101,';
3334: END IF;
3335:
3336: IF p_line_id IS NULL OR
3337: p_line_id = FND_API.G_MISS_NUM THEN
3338: l_line_rec := p_line_rec;
3339: IF l_debug_level > 0 THEN
3340: oe_debug_pub.add( 'p_line_rec.line_id '||P_LINE_REC.LINE_ID , 3 ) ;
3341: END IF;

Line 3354: IF p_shipment_status <> FND_API.G_MISS_CHAR AND

3350:
3351:
3352: -- Check for Shipment Status
3353:
3354: IF p_shipment_status <> FND_API.G_MISS_CHAR AND
3355: p_shipment_status IS NOT NULL THEN
3356:
3357: IF l_debug_level > 0 THEN
3358: oe_debug_pub.add( '1 shipment status '|| P_SHIPMENT_STATUS , 1 ) ;

Line 3456: l_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR

3452:
3453: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND
3454: l_line_rec.ordered_quantity > l_line_rec.shipped_quantity AND
3455: (l_line_rec.top_model_line_id is null OR
3456: l_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
3457: nvl(l_line_rec.model_remnant_flag,'N') = 'Y') THEN
3458:
3459: -- Split API is called only for Standard line. For PTO/ATO it
3460: -- will be called from respective procedures.

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

3517: END IF;
3518:
3519: l_line_tbl(1).ordered_quantity := l_temp_shipped_qty;
3520: -- Check if item is dual UOM
3521: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3522:
3523: -- User can order in a 3rd UOM that is not primary nor secondary
3524: -- but a convertable UOM.
3525: -- 3rd conversion case, we need to perform an item specific conversion

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

3554:
3555: ELSE -- UOMS are same. This is good for discrete and OPM
3556: l_line_tbl(1).ordered_quantity := l_line_rec.shipped_quantity;
3557: -- check if item is a dual UOM
3558: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3559: l_line_tbl(1).ordered_quantity2 := l_line_rec.shipped_quantity2;
3560: -- single UOM item
3561: ELSE
3562: l_line_tbl(1).ordered_quantity2 := NULL;

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

3581:
3582: IF ( l_uom_different = 1 ) THEN -- UOMS are different and it is dual item line -- INVCONV
3583: l_line_tbl(2).ordered_quantity := l_line_rec.ordered_quantity - l_temp_shipped_qty;
3584: -- Check if item is a dual UOM
3585: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3586:
3587: -- In OPM, User can order in a 3rd UOM that is not primary nor secondary
3588: -- but a convertable UOM.
3589: -- 3rd conversion case, we need to perform an item specific conversion

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

3616: ELSE -- UOMS are same. This is good for discrete and OPM
3617: l_line_tbl(2).ordered_quantity := l_line_rec.ordered_quantity -
3618: l_line_rec.shipped_quantity;
3619: -- Check if item is a dual UOM
3620: IF ( l_line_tbl(1).ordered_quantity_uom2 <> FND_API.G_MISS_CHAR ) THEN
3621: l_line_tbl(2).ordered_quantity2 := l_line_rec.ordered_quantity2 -
3622: l_line_rec.shipped_quantity2;
3623: -- Item is a single UOM
3624: ELSE

Line 3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3681: IF l_debug_level > 0 THEN
3682: oe_debug_pub.add( 'RET STS PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
3683: END IF;
3684:
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;

Line 3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3682: oe_debug_pub.add( 'RET STS PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
3683: END IF;
3684:
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690: END IF; -- split

Line 3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3683: END IF;
3684:
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690: END IF; -- split
3691:

Line 3688: RAISE FND_API.G_EXC_ERROR;

3684:
3685: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3687: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3688: RAISE FND_API.G_EXC_ERROR;
3689: END IF;
3690: END IF; -- split
3691:
3692: IF g_debug_call > 0 THEN

Line 3759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3755: IF l_debug_level > 0 THEN
3756: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3757: END IF;
3758:
3759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3762: RAISE FND_API.G_EXC_ERROR;
3763: END IF;

Line 3760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3756: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
3757: END IF;
3758:
3759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3762: RAISE FND_API.G_EXC_ERROR;
3763: END IF;
3764: IF g_debug_call > 0 THEN

Line 3761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3757: END IF;
3758:
3759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3762: RAISE FND_API.G_EXC_ERROR;
3763: END IF;
3764: IF g_debug_call > 0 THEN
3765: G_DEBUG_MSG := G_DEBUG_MSG || '9-25';

Line 3762: RAISE FND_API.G_EXC_ERROR;

3758:
3759: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3761: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3762: RAISE FND_API.G_EXC_ERROR;
3763: END IF;
3764: IF g_debug_call > 0 THEN
3765: G_DEBUG_MSG := G_DEBUG_MSG || '9-25';
3766: END IF;

Line 3797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3793: x_return_status => l_return_status);
3794: IF g_debug_call > 0 THEN
3795: G_DEBUG_MSG := G_DEBUG_MSG || '9-27';
3796: END IF;
3797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3800: RAISE FND_API.G_EXC_ERROR;
3801: END IF;

Line 3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3794: IF g_debug_call > 0 THEN
3795: G_DEBUG_MSG := G_DEBUG_MSG || '9-27';
3796: END IF;
3797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3800: RAISE FND_API.G_EXC_ERROR;
3801: END IF;
3802:

Line 3799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3795: G_DEBUG_MSG := G_DEBUG_MSG || '9-27';
3796: END IF;
3797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3800: RAISE FND_API.G_EXC_ERROR;
3801: END IF;
3802:
3803: IF l_line_rec.arrival_set_id IS NOT NULL AND

Line 3800: RAISE FND_API.G_EXC_ERROR;

3796: END IF;
3797: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3800: RAISE FND_API.G_EXC_ERROR;
3801: END IF;
3802:
3803: IF l_line_rec.arrival_set_id IS NOT NULL AND
3804: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN

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

3800: RAISE FND_API.G_EXC_ERROR;
3801: END IF;
3802:
3803: IF l_line_rec.arrival_set_id IS NOT NULL AND
3804: l_line_rec.arrival_set_id <> FND_API.G_MISS_NUM THEN
3805: UPDATE OE_SETS
3806: SET SET_STATUS = 'C'
3807: WHERE SET_ID = l_line_rec.arrival_set_id;
3808: IF l_debug_level > 0 THEN

Line 3817: x_return_status := FND_API.G_RET_STS_SUCCESS;

3813: END IF;
3814: IF g_debug_call > 0 THEN
3815: G_DEBUG_MSG := G_DEBUG_MSG || '9-28';
3816: END IF;
3817: x_return_status := FND_API.G_RET_STS_SUCCESS;
3818:
3819: IF l_debug_level > 0 THEN
3820: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_STANDARD_LINE '|| X_RETURN_STATUS , 1 ) ;
3821: END IF;

Line 3824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3820: oe_debug_pub.add( 'EXITING SHIP_CONFIRM_STANDARD_LINE '|| X_RETURN_STATUS , 1 ) ;
3821: END IF;
3822:
3823: EXCEPTION
3824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3826:
3827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN

Line 3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3821: END IF;
3822:
3823: EXCEPTION
3824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3826:
3827: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3828: THEN
3829: OE_MSG_PUB.Add_Exc_Msg

Line 3838: WHEN FND_API.G_EXC_ERROR THEN

3834: IF g_debug_call > 0 THEN
3835: G_DEBUG_MSG := G_DEBUG_MSG || 'E20';
3836: END IF;
3837:
3838: WHEN FND_API.G_EXC_ERROR THEN
3839: IF l_debug_level > 0 THEN
3840: oe_debug_pub.add( 'SHIP_CONFIRM_STANDARD_LINE EXC ERROR' , 1 ) ;
3841: END IF;
3842: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3842: x_return_status := FND_API.G_RET_STS_ERROR;

3838: WHEN FND_API.G_EXC_ERROR THEN
3839: IF l_debug_level > 0 THEN
3840: oe_debug_pub.add( 'SHIP_CONFIRM_STANDARD_LINE EXC ERROR' , 1 ) ;
3841: END IF;
3842: x_return_status := FND_API.G_RET_STS_ERROR;
3843: IF g_debug_call > 0 THEN
3844: G_DEBUG_MSG := G_DEBUG_MSG || 'E-21';
3845: END IF;
3846:

Line 3851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3847: WHEN OTHERS THEN
3848: IF l_debug_level > 0 THEN
3849: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
3850: END IF;
3851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3852:
3853: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3854: THEN
3855: OE_MSG_PUB.Add_Exc_Msg

Line 3909: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3905: IF l_debug_level > 0 THEN
3906: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
3907: END IF;
3908:
3909: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3912: IF l_debug_level > 0 THEN
3913: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;

Line 3910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3906: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
3907: END IF;
3908:
3909: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3912: IF l_debug_level > 0 THEN
3913: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
3914: END IF;

Line 3911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3907: END IF;
3908:
3909: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3911: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3912: IF l_debug_level > 0 THEN
3913: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
3914: END IF;
3915: ELSE

Line 3944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3940: p_param3 => 'WAIT_FOR_CTO',
3941: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3942: x_return_status => l_return_status);
3943:
3944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3947: RAISE FND_API.G_EXC_ERROR;
3948: END IF;

Line 3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3941: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3942: x_return_status => l_return_status);
3943:
3944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3947: RAISE FND_API.G_EXC_ERROR;
3948: END IF;
3949:

Line 3946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3942: x_return_status => l_return_status);
3943:
3944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3947: RAISE FND_API.G_EXC_ERROR;
3948: END IF;
3949:
3950: END IF;

Line 3947: RAISE FND_API.G_EXC_ERROR;

3943:
3944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3947: RAISE FND_API.G_EXC_ERROR;
3948: END IF;
3949:
3950: END IF;
3951: END IF;

Line 4050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4046: IF l_debug_level > 0 THEN
4047: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4048: END IF;
4049:
4050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4052: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4053: RAISE FND_API.G_EXC_ERROR;
4054: END IF;

Line 4051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4047: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4048: END IF;
4049:
4050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4052: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4053: RAISE FND_API.G_EXC_ERROR;
4054: END IF;
4055:

Line 4052: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4048: END IF;
4049:
4050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4052: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4053: RAISE FND_API.G_EXC_ERROR;
4054: END IF;
4055:
4056: IF g_debug_call > 0 THEN

Line 4053: RAISE FND_API.G_EXC_ERROR;

4049:
4050: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4052: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4053: RAISE FND_API.G_EXC_ERROR;
4054: END IF;
4055:
4056: IF g_debug_call > 0 THEN
4057: G_DEBUG_MSG := G_DEBUG_MSG || '10-7';

Line 4135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4131: END IF;
4132: IF g_debug_call > 0 THEN
4133: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-10-9';
4134: END IF;
4135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4138: RAISE FND_API.G_EXC_ERROR;
4139: END IF;

Line 4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4132: IF g_debug_call > 0 THEN
4133: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-10-9';
4134: END IF;
4135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4138: RAISE FND_API.G_EXC_ERROR;
4139: END IF;
4140:

Line 4137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4133: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-10-9';
4134: END IF;
4135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4138: RAISE FND_API.G_EXC_ERROR;
4139: END IF;
4140:
4141: IF l_debug_level > 0 THEN

Line 4138: RAISE FND_API.G_EXC_ERROR;

4134: END IF;
4135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4138: RAISE FND_API.G_EXC_ERROR;
4139: END IF;
4140:
4141: IF l_debug_level > 0 THEN
4142: oe_debug_pub.add('RET STS FROM PROCESS ORDER:'||L_RETURN_STATUS , 3 ) ;

Line 4158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4154: IF g_debug_call > 0 THEN
4155: G_DEBUG_MSG := G_DEBUG_MSG || '1-10';
4156: END IF;
4157:
4158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4161: RAISE FND_API.G_EXC_ERROR;
4162: END IF;

Line 4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4155: G_DEBUG_MSG := G_DEBUG_MSG || '1-10';
4156: END IF;
4157:
4158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4161: RAISE FND_API.G_EXC_ERROR;
4162: END IF;
4163:

Line 4160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4156: END IF;
4157:
4158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4161: RAISE FND_API.G_EXC_ERROR;
4162: END IF;
4163:
4164:

Line 4161: RAISE FND_API.G_EXC_ERROR;

4157:
4158: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4160: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4161: RAISE FND_API.G_EXC_ERROR;
4162: END IF;
4163:
4164:
4165: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4165: x_return_status := FND_API.G_RET_STS_SUCCESS;

4161: RAISE FND_API.G_EXC_ERROR;
4162: END IF;
4163:
4164:
4165: x_return_status := FND_API.G_RET_STS_SUCCESS;
4166:
4167: EXCEPTION
4168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4164:
4165: x_return_status := FND_API.G_RET_STS_SUCCESS;
4166:
4167: EXCEPTION
4168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4170:
4171: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4172: THEN

Line 4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4165: x_return_status := FND_API.G_RET_STS_SUCCESS;
4166:
4167: EXCEPTION
4168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4170:
4171: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4172: THEN
4173: OE_MSG_PUB.Add_Exc_Msg

Line 4181: WHEN FND_API.G_EXC_ERROR THEN

4177: IF g_debug_call > 0 THEN
4178: G_DEBUG_MSG := G_DEBUG_MSG || 'E-24';
4179: END IF;
4180:
4181: WHEN FND_API.G_EXC_ERROR THEN
4182: x_return_status := FND_API.G_RET_STS_ERROR;
4183: IF g_debug_call > 0 THEN
4184: G_DEBUG_MSG := G_DEBUG_MSG || 'E-25';
4185: END IF;

Line 4182: x_return_status := FND_API.G_RET_STS_ERROR;

4178: G_DEBUG_MSG := G_DEBUG_MSG || 'E-24';
4179: END IF;
4180:
4181: WHEN FND_API.G_EXC_ERROR THEN
4182: x_return_status := FND_API.G_RET_STS_ERROR;
4183: IF g_debug_call > 0 THEN
4184: G_DEBUG_MSG := G_DEBUG_MSG || 'E-25';
4185: END IF;
4186:

Line 4191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4187: WHEN OTHERS THEN
4188: IF l_debug_level > 0 THEN
4189: oe_debug_pub.add('ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
4190: END IF;
4191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4192:
4193: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4194: THEN
4195: OE_MSG_PUB.Add_Exc_Msg

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

4219: l_process_index NUMBER := 0;
4220: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4221: l_set_index NUMBER := 0;
4222: l_control_rec OE_GLOBALS.Control_Rec_Type;
4223: l_line_shipped VARCHAR2(1) := FND_API.G_FALSE;
4224: l_return_status VARCHAR2(1);
4225: l_set_recursion VARCHAR2(1) := 'N';
4226:
4227: --

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

4280: l_process_tbl(l_process_index) := l_line_tbl(l_line_index);
4281:
4282:
4283: ELSIF (l_line_tbl(l_line_index).top_model_line_id IS NOT NULL AND
4284: l_line_tbl(l_line_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4285: l_line_tbl(l_line_index).line_id = l_line_tbl(l_line_index).top_model_line_id) AND
4286: (l_line_tbl(l_line_index).ato_line_id IS NULL OR
4287: l_line_tbl(l_line_index).ato_line_id = FND_API.G_MISS_NUM) THEN
4288: IF l_debug_level > 0 THEN

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

4283: ELSIF (l_line_tbl(l_line_index).top_model_line_id IS NOT NULL AND
4284: l_line_tbl(l_line_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4285: l_line_tbl(l_line_index).line_id = l_line_tbl(l_line_index).top_model_line_id) AND
4286: (l_line_tbl(l_line_index).ato_line_id IS NULL OR
4287: l_line_tbl(l_line_index).ato_line_id = FND_API.G_MISS_NUM) THEN
4288: IF l_debug_level > 0 THEN
4289: oe_debug_pub.add( 'IT IS A PTO/KIT ' , 3 ) ;
4290: END IF;
4291: l_process_index := l_process_index + 1;

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

4311: FOR l_process_index IN l_process_tbl.FIRST .. l_process_tbl.LAST
4312: LOOP
4313:
4314: IF l_process_tbl(l_process_index).top_model_line_id IS NOT NULL AND
4315: l_process_tbl(l_process_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4316: /* Commented for bug 1820608
4317: (l_process_tbl(l_process_index).ato_line_id IS NULL OR
4318: l_process_tbl(l_process_index).ato_line_id = FND_API.G_MISS_NUM) THEN */
4319: /* Added condition of KIT for bug 1926571 */

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

4314: IF l_process_tbl(l_process_index).top_model_line_id IS NOT NULL AND
4315: l_process_tbl(l_process_index).top_model_line_id <> FND_API.G_MISS_NUM AND
4316: /* Commented for bug 1820608
4317: (l_process_tbl(l_process_index).ato_line_id IS NULL OR
4318: l_process_tbl(l_process_index).ato_line_id = FND_API.G_MISS_NUM) THEN */
4319: /* Added condition of KIT for bug 1926571 */
4320: l_process_tbl(l_process_index).item_type_code IN ('MODEL','KIT') THEN
4321: IF l_debug_level > 0 THEN
4322: oe_debug_pub.add( 'IT IS PTO/KIT '||TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .TOP_MODEL_LINE_ID ) , 3 ) ;

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

4330:
4331: IF l_line_tbl(l_line_index).top_model_line_id = l_process_tbl(l_process_index).top_model_line_id AND
4332: nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'Y' AND
4333: nvl(l_line_tbl(l_line_index).shipped_quantity,0) <> 0 AND
4334: l_line_tbl(l_line_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4335: l_line_shipped := FND_API.G_TRUE;
4336: IF l_debug_level > 0 THEN
4337: oe_debug_pub.add( 'LINE IS SHIPPED '||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) , 3 ) ;
4338: END IF;

Line 4335: l_line_shipped := FND_API.G_TRUE;

4331: IF l_line_tbl(l_line_index).top_model_line_id = l_process_tbl(l_process_index).top_model_line_id AND
4332: nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'Y' AND
4333: nvl(l_line_tbl(l_line_index).shipped_quantity,0) <> 0 AND
4334: l_line_tbl(l_line_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4335: l_line_shipped := FND_API.G_TRUE;
4336: IF l_debug_level > 0 THEN
4337: oe_debug_pub.add( 'LINE IS SHIPPED '||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) , 3 ) ;
4338: END IF;
4339:

Line 4345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4341: (
4342: p_top_model_line_id => l_process_tbl(l_process_index).top_model_line_id,
4343: x_return_status => l_return_status
4344: );
4345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: END IF;

Line 4346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4342: p_top_model_line_id => l_process_tbl(l_process_index).top_model_line_id,
4343: x_return_status => l_return_status
4344: );
4345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: END IF;
4350:

Line 4347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4343: x_return_status => l_return_status
4344: );
4345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: END IF;
4350:
4351: GOTO END_PTO_KIT_SET;

Line 4348: RAISE FND_API.G_EXC_ERROR;

4344: );
4345: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4347: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4348: RAISE FND_API.G_EXC_ERROR;
4349: END IF;
4350:
4351: GOTO END_PTO_KIT_SET;
4352:

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

4356: <>
4357: NULL;
4358:
4359: ELSIF nvl(l_process_tbl(l_process_index).shipped_quantity,0) <> 0 AND
4360: l_process_tbl(l_process_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4361: IF l_debug_level > 0 THEN
4362: oe_debug_pub.add( 'INSIDE THE LOOP : LINE ID : '|| TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4363: END IF;
4364: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN

Line 4371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4367: p_line_rec => l_process_tbl(l_process_index),
4368: x_return_status => l_return_status
4369: );
4370:
4371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;

Line 4372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4368: x_return_status => l_return_status
4369: );
4370:
4371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376: END IF;

Line 4373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4369: );
4370:
4371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376: END IF;
4377:

Line 4374: RAISE FND_API.G_EXC_ERROR;

4370:
4371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4374: RAISE FND_API.G_EXC_ERROR;
4375: END IF;
4376: END IF;
4377:
4378: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

Line 4385: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 4386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4387: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 4388: RAISE FND_API.G_EXC_ERROR;

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

Line 4392: l_line_shipped := FND_API.G_TRUE;

4388: RAISE FND_API.G_EXC_ERROR;
4389: END IF;
4390: END IF;
4391:
4392: l_line_shipped := FND_API.G_TRUE;
4393: END IF;
4394:
4395: IF l_line_shipped = FND_API.G_FALSE THEN
4396:

Line 4395: IF l_line_shipped = FND_API.G_FALSE THEN

4391:
4392: l_line_shipped := FND_API.G_TRUE;
4393: END IF;
4394:
4395: IF l_line_shipped = FND_API.G_FALSE THEN
4396:
4397: IF l_debug_level > 0 THEN
4398: oe_debug_pub.add( 'SHIP SET IS PARTIALLY SHIPPED REMOVING THE SETID '||TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4399: END IF;

Line 4415: l_line_shipped := FND_API.G_FALSE;

4411: l_set_tbl(l_set_index).operation := OE_GLOBALS.G_OPR_UPDATE;
4412:
4413: END IF;
4414:
4415: l_line_shipped := FND_API.G_FALSE;
4416:
4417: END LOOP;
4418:
4419: IF l_set_index <> 0 THEN

Line 4462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4458:
4459: IF l_debug_level > 0 THEN
4460: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4461: END IF;
4462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;

Line 4463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4459: IF l_debug_level > 0 THEN
4460: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4461: END IF;
4462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;
4467: END IF;

Line 4464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4460: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
4461: END IF;
4462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;
4467: END IF;
4468:

Line 4465: RAISE FND_API.G_EXC_ERROR;

4461: END IF;
4462: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4464: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4465: RAISE FND_API.G_EXC_ERROR;
4466: END IF;
4467: END IF;
4468:
4469: x_return_status := l_return_status;

Line 4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4475: G_DEBUG_MSG := G_DEBUG_MSG || '11-9';
4476: END IF;
4477:
4478: EXCEPTION
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN

Line 4480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4476: END IF;
4477:
4478: EXCEPTION
4479: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4481:
4482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4483: THEN
4484: OE_MSG_PUB.Add_Exc_Msg

Line 4493: WHEN FND_API.G_EXC_ERROR THEN

4489: IF g_debug_call > 0 THEN
4490: G_DEBUG_MSG := G_DEBUG_MSG || 'E-27';
4491: END IF;
4492:
4493: WHEN FND_API.G_EXC_ERROR THEN
4494: x_return_status := FND_API.G_RET_STS_ERROR;
4495: IF g_debug_call > 0 THEN
4496: G_DEBUG_MSG := G_DEBUG_MSG || 'E-28';
4497: END IF;

Line 4494: x_return_status := FND_API.G_RET_STS_ERROR;

4490: G_DEBUG_MSG := G_DEBUG_MSG || 'E-27';
4491: END IF;
4492:
4493: WHEN FND_API.G_EXC_ERROR THEN
4494: x_return_status := FND_API.G_RET_STS_ERROR;
4495: IF g_debug_call > 0 THEN
4496: G_DEBUG_MSG := G_DEBUG_MSG || 'E-28';
4497: END IF;
4498: WHEN OTHERS THEN

Line 4499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4495: IF g_debug_call > 0 THEN
4496: G_DEBUG_MSG := G_DEBUG_MSG || 'E-28';
4497: END IF;
4498: WHEN OTHERS THEN
4499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4500:
4501: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4502: THEN
4503: OE_MSG_PUB.Add_Exc_Msg

Line 4563: p_process_id <> FND_API.G_MISS_NUM) THEN

4559:
4560:
4561: IF p_process_type = 'ATO' AND
4562: (p_process_id IS NOT NULL AND
4563: p_process_id <> FND_API.G_MISS_NUM) THEN
4564:
4565: -- Call procedure for Ship Confirmation of ATO
4566: Ship_Confirm_ATO
4567: (

Line 4571: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4567: (
4568: p_line_id => p_process_id,
4569: x_return_status => l_x_return_status
4570: );
4571: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: END IF;

Line 4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4568: p_line_id => p_process_id,
4569: x_return_status => l_x_return_status
4570: );
4571: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: END IF;
4576:

Line 4573: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

4569: x_return_status => l_x_return_status
4570: );
4571: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: END IF;
4576:
4577: ELSIF p_process_type = 'PTO_KIT' AND

Line 4574: RAISE FND_API.G_EXC_ERROR;

4570: );
4571: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4573: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4574: RAISE FND_API.G_EXC_ERROR;
4575: END IF;
4576:
4577: ELSIF p_process_type = 'PTO_KIT' AND
4578: (p_process_id IS NOT NULL AND

Line 4579: p_process_id <> FND_API.G_MISS_NUM) THEN

4575: END IF;
4576:
4577: ELSIF p_process_type = 'PTO_KIT' AND
4578: (p_process_id IS NOT NULL AND
4579: p_process_id <> FND_API.G_MISS_NUM) THEN
4580:
4581: -- Call procedure for Ship Confirmation of PTO and KIT
4582:
4583:

Line 4589: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4591: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 4592: RAISE FND_API.G_EXC_ERROR;

4588: );
4589: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4590: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4591: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4592: RAISE FND_API.G_EXC_ERROR;
4593: END IF;
4594:
4595:
4596: ELSIF p_process_type = 'SHIP_SET' AND

Line 4598: p_process_id <> FND_API.G_MISS_NUM) THEN

4594:
4595:
4596: ELSIF p_process_type = 'SHIP_SET' AND
4597: (p_process_id IS NOT NULL AND
4598: p_process_id <> FND_API.G_MISS_NUM) THEN
4599:
4600: -- Call procedure for Ship Confirmation of SHIP_SET
4601:
4602: Ship_Confirm_Ship_Set

Line 4607: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 4608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4609: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 4610: RAISE FND_API.G_EXC_ERROR;

4606: );
4607: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4608: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4609: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4610: RAISE FND_API.G_EXC_ERROR;
4611: END IF;
4612: ELSE
4613:
4614: -- Call procedure for Ship Confirmation of Standard Line

Line 4625: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 4626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 4627: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 4628: RAISE FND_API.G_EXC_ERROR;

4624:
4625: IF l_x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4627: ELSIF l_x_return_status = FND_API.G_RET_STS_ERROR THEN
4628: RAISE FND_API.G_EXC_ERROR;
4629: END IF;
4630:
4631:
4632: END IF;

Line 4634: x_return_status := FND_API.G_RET_STS_SUCCESS;

4630:
4631:
4632: END IF;
4633:
4634: x_return_status := FND_API.G_RET_STS_SUCCESS;
4635: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4636: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4637: null;
4638: END IF;

Line 4645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4641: oe_debug_pub.add( 'RETURNED FROM OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIP_CONFIRM '|| X_RETURN_STATUS , 1 ) ;
4642: END IF;
4643:
4644: EXCEPTION
4645: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4646: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4647: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4648: null;
4649: END IF;

Line 4651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4647: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4648: null;
4649: END IF;
4650:
4651: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4652:
4653: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4654: THEN
4655: OE_MSG_PUB.Add_Exc_Msg

Line 4664: WHEN FND_API.G_EXC_ERROR THEN

4660: IF g_debug_call > 0 THEN
4661: G_DEBUG_MSG := G_DEBUG_MSG || 'E-30';
4662: END IF;
4663:
4664: WHEN FND_API.G_EXC_ERROR THEN
4665: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4666: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4667: null;
4668: END IF;

Line 4669: x_return_status := FND_API.G_RET_STS_ERROR;

4665: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4666: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4667: null;
4668: END IF;
4669: x_return_status := FND_API.G_RET_STS_ERROR;
4670: IF g_debug_call > 0 THEN
4671: G_DEBUG_MSG := G_DEBUG_MSG || 'E31';
4672: END IF;
4673: WHEN OTHERS THEN

Line 4681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4677: END IF;
4678: IF g_debug_call > 0 THEN
4679: G_DEBUG_MSG := G_DEBUG_MSG || 'E-32';
4680: END IF;
4681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4682:
4683: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4684: THEN
4685: OE_MSG_PUB.Add_Exc_Msg

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

4720: ,x_msg_data OUT NOCOPY VARCHAR2)
4721:
4722: IS
4723: l_line_index NUMBER;
4724: l_shipping_activity VARCHAR2(1) := FND_API.G_TRUE;
4725: l_return_status VARCHAR2(1);
4726: l_freeze_method VARCHAR2(30);
4727: l_flow_status_code VARCHAR2(30);
4728: l_line_category_code VARCHAR2(30);

Line 5098: x_return_status := FND_API.G_RET_STS_SUCCESS;

5094:
5095: IF g_debug_call > 0 THEN
5096: G_DEBUG_MSG := G_DEBUG_MSG || '209';
5097: END IF;
5098: x_return_status := FND_API.G_RET_STS_SUCCESS;
5099: RETURN;
5100: END IF; -- bulk mode
5101: --Start Bug 4094824
5102: BEGIN

Line 5140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5136: IF l_debug_level > 0 THEN
5137: oe_debug_pub.add('After calling explosion : '|| l_return_status , 3 ) ;
5138: END IF;
5139:
5140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;

Line 5141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5137: oe_debug_pub.add('After calling explosion : '|| l_return_status , 3 ) ;
5138: END IF;
5139:
5140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5145:

Line 5142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5138: END IF;
5139:
5140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5145:
5146: IF l_ship_model_complete_flag = 'N' OR l_enforce_smc_flag = 'Y' THEN

Line 5143: RAISE FND_API.G_EXC_ERROR;

5139:
5140: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5142: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5143: RAISE FND_API.G_EXC_ERROR;
5144: END IF;
5145:
5146: IF l_ship_model_complete_flag = 'N' OR l_enforce_smc_flag = 'Y' THEN
5147:

Line 5216: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5212: (p_line_id => p_line_id
5213: ,p_top_model_line_id => l_top_model_line_id
5214: ,x_return_status => l_return_status);
5215:
5216: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;

Line 5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5213: ,p_top_model_line_id => l_top_model_line_id
5214: ,x_return_status => l_return_status);
5215:
5216: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;
5221:

Line 5218: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5214: ,x_return_status => l_return_status);
5215:
5216: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;
5221:
5222: ELSE -- standard, non-smc etc

Line 5219: RAISE FND_API.G_EXC_ERROR;

5215:
5216: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5219: RAISE FND_API.G_EXC_ERROR;
5220: END IF;
5221:
5222: ELSE -- standard, non-smc etc
5223:

Line 5237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5233: Update_Shipping_PVT(p_line_id => l_line_id,
5234: p_shipping_activity => l_shipping_activity,
5235: x_return_status => l_return_status);
5236:
5237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5240: RAISE FND_API.G_EXC_ERROR;
5241: END IF;

Line 5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5234: p_shipping_activity => l_shipping_activity,
5235: x_return_status => l_return_status);
5236:
5237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5240: RAISE FND_API.G_EXC_ERROR;
5241: END IF;
5242: END IF;

Line 5239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5235: x_return_status => l_return_status);
5236:
5237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5240: RAISE FND_API.G_EXC_ERROR;
5241: END IF;
5242: END IF;
5243:

Line 5240: RAISE FND_API.G_EXC_ERROR;

5236:
5237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5240: RAISE FND_API.G_EXC_ERROR;
5241: END IF;
5242: END IF;
5243:
5244: END IF; -- big IF smc etc.

Line 5289: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5285: IF l_debug_level > 0 THEN
5286: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5287: END IF;
5288:
5289: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: END IF;

Line 5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5286: oe_debug_pub.add( 'RETURN STS FLOW STATUS API '||L_RETURN_STATUS , 3 ) ;
5287: END IF;
5288:
5289: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: END IF;
5294:

Line 5291: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5287: END IF;
5288:
5289: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: END IF;
5294:
5295: END IF;

Line 5292: RAISE FND_API.G_EXC_ERROR;

5288:
5289: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5291: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5292: RAISE FND_API.G_EXC_ERROR;
5293: END IF;
5294:
5295: END IF;
5296:

Line 5303: x_return_status := FND_API.G_RET_STS_SUCCESS;

5299: IF g_debug_call > 0 THEN
5300: G_DEBUG_MSG := G_DEBUG_MSG || '216';
5301: END IF;
5302:
5303: x_return_status := FND_API.G_RET_STS_SUCCESS;
5304:
5305: IF l_debug_level > 0 THEN
5306: oe_debug_pub.add( 'EXITING PROCESS_SHIPPING_ACTIVITY SUCCESSFULLY ' , 1 ) ;
5307: END IF;

Line 5311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5307: END IF;
5308:
5309: EXCEPTION
5310:
5311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5312: IF l_debug_level > 0 THEN
5313: oe_debug_pub.add( 'PROCESS_SHIPPING_ACTIVITY : UNEXPECTED ERROR' , 1 ) ;
5314: END IF;
5315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 5325: WHEN FND_API.G_EXC_ERROR THEN

5321: IF g_debug_call > 0 THEN
5322: G_DEBUG_MSG := G_DEBUG_MSG || 'E-33';
5323: END IF;
5324:
5325: WHEN FND_API.G_EXC_ERROR THEN
5326: IF l_debug_level > 0 THEN
5327: oe_debug_pub.add( 'PROCESS_SHIPPING_ACTIVITY : EXE ERROR' , 1 ) ;
5328: END IF;
5329: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5329: x_return_status := FND_API.G_RET_STS_ERROR;

5325: WHEN FND_API.G_EXC_ERROR THEN
5326: IF l_debug_level > 0 THEN
5327: oe_debug_pub.add( 'PROCESS_SHIPPING_ACTIVITY : EXE ERROR' , 1 ) ;
5328: END IF;
5329: x_return_status := FND_API.G_RET_STS_ERROR;
5330: IF g_debug_call > 0 THEN
5331: G_DEBUG_MSG := G_DEBUG_MSG || 'E-34';
5332: END IF;
5333:

Line 5342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

5373: IS
5374: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
5375: l_update_lines_tbl OE_ORDER_PUB.Request_Tbl_Type;
5376: l_update_lines_index NUMBER := 0;
5377: l_lines_not_at_ship VARCHAR2(1) := FND_API.G_FALSE;
5378: l_activity_status_code VARCHAR2(8);
5379: l_dummy VARCHAR2(52);
5380: l_line_index NUMBER;
5381: --

Line 5390: x_return_status := FND_API.G_RET_STS_SUCCESS;

5386: IF l_debug_level > 0 THEN
5387: oe_debug_pub.add( 'ENTERING PROCESS_SMC_SHIPPING' , 3 ) ;
5388: END IF;
5389:
5390: x_return_status := FND_API.G_RET_STS_SUCCESS;
5391:
5392: OE_Config_Util.Query_Options
5393: (p_top_model_line_id => p_top_model_line_id,
5394: x_line_tbl => l_line_tbl);

Line 5459: := FND_API.G_FALSE;

5455: l_update_lines_index := l_update_lines_index + 1;
5456: l_update_lines_tbl(l_update_lines_index).entity_id
5457: := l_line_tbl(l_line_index).line_id;
5458: l_update_lines_tbl(l_update_lines_index).param1
5459: := FND_API.G_FALSE;
5460: l_update_lines_tbl(l_update_lines_index).param2
5461: := FND_API.G_FALSE;
5462: l_update_lines_tbl(l_update_lines_index).param4
5463: := FND_API.G_TRUE;

Line 5461: := FND_API.G_FALSE;

5457: := l_line_tbl(l_line_index).line_id;
5458: l_update_lines_tbl(l_update_lines_index).param1
5459: := FND_API.G_FALSE;
5460: l_update_lines_tbl(l_update_lines_index).param2
5461: := FND_API.G_FALSE;
5462: l_update_lines_tbl(l_update_lines_index).param4
5463: := FND_API.G_TRUE;
5464: END IF;
5465: END IF; -- if shippable

Line 5463: := FND_API.G_TRUE;

5459: := FND_API.G_FALSE;
5460: l_update_lines_tbl(l_update_lines_index).param2
5461: := FND_API.G_FALSE;
5462: l_update_lines_tbl(l_update_lines_index).param4
5463: := FND_API.G_TRUE;
5464: END IF;
5465: END IF; -- if shippable
5466:
5467:

Line 5494: l_lines_not_at_ship := FND_API.G_TRUE;

5490: WHEN no_data_found THEN
5491: IF l_debug_level > 0 THEN
5492: oe_debug_pub.add( 'ATO MODEL NOT PROCESSED IN A SMC' , 1 ) ;
5493: END IF;
5494: l_lines_not_at_ship := FND_API.G_TRUE;
5495:
5496: WHEN others THEN
5497: IF l_debug_level > 0 THEN
5498: oe_debug_pub.add( 'ATO MODEL SQL '|| SQLERRM , 1 ) ;

Line 5526: l_lines_not_at_ship := FND_API.G_TRUE;

5522: IF l_debug_level > 0 THEN
5523: 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 ) ;
5524: END IF;
5525:
5526: l_lines_not_at_ship := FND_API.G_TRUE;
5527:
5528: WHEN TOO_MANY_ROWS THEN
5529: IF l_debug_level > 0 THEN
5530: 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 5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5534: IF l_debug_level > 0 THEN
5535: oe_debug_pub.add( 'PROCESS SHIPPING ACTIVITY :'||SUBSTR ( SQLERRM , 1 , 200 ) , 3 ) ;
5536: END IF;
5537:
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: END;
5540:
5541: IF l_lines_not_at_ship = FND_API.G_TRUE THEN
5542: IF l_debug_level > 0 THEN

Line 5541: IF l_lines_not_at_ship = FND_API.G_TRUE THEN

5537:
5538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5539: END;
5540:
5541: IF l_lines_not_at_ship = FND_API.G_TRUE THEN
5542: IF l_debug_level > 0 THEN
5543: oe_debug_pub.add( 'ALL LINES NOT AT SHIP , RETURNING...' , 1 ) ;
5544: END IF;
5545: RETURN;

Line 5572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5568: Update_Shipping_From_OE
5569: ( p_update_lines_tbl => l_update_lines_tbl,
5570: x_return_status => x_return_status);
5571:
5572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5575: RAISE FND_API.G_EXC_ERROR;
5576: END IF;

Line 5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5569: ( p_update_lines_tbl => l_update_lines_tbl,
5570: x_return_status => x_return_status);
5571:
5572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5575: RAISE FND_API.G_EXC_ERROR;
5576: END IF;
5577: IF l_debug_level > 0 THEN

Line 5574: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

5570: x_return_status => x_return_status);
5571:
5572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5575: RAISE FND_API.G_EXC_ERROR;
5576: END IF;
5577: IF l_debug_level > 0 THEN
5578: oe_debug_pub.add( 'UPDATE_SHIPPING_FROM_OE : '|| X_RETURN_STATUS , 3 ) ;

Line 5575: RAISE FND_API.G_EXC_ERROR;

5571:
5572: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5574: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
5575: RAISE FND_API.G_EXC_ERROR;
5576: END IF;
5577: IF l_debug_level > 0 THEN
5578: oe_debug_pub.add( 'UPDATE_SHIPPING_FROM_OE : '|| X_RETURN_STATUS , 3 ) ;
5579: END IF;

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

5600: END IF;
5601:
5602: IF nvl(l_line_tbl(l_line_index).shippable_flag,'N') = 'N' AND
5603: OE_Shipping_Integration_PUB.Is_Activity_Shipping
5604: (1.0, l_line_tbl(l_line_index).line_id) = FND_API.G_TRUE AND
5605: p_line_id <> l_line_tbl(l_line_index).line_id THEN
5606:
5607: IF l_debug_level > 0 THEN
5608: oe_debug_pub.add( 'COMP SHIP_LINE , NONSHIP: '||L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID , 3 ) ;

Line 5638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5634: oe_debug_pub.add( 'LEAVING PROCESS_SMC_SHIPPING' , 3 ) ;
5635: END IF;
5636:
5637: EXCEPTION
5638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5639: IF l_debug_level > 0 THEN
5640: oe_debug_pub.add( 'PROCESS_SMC_SHIPPING : UNEXPECTED ERROR' , 1 ) ;
5641: END IF;
5642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 5642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 5652: WHEN FND_API.G_EXC_ERROR THEN

5648: IF g_debug_call > 0 THEN
5649: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-E-36';
5650: END IF;
5651:
5652: WHEN FND_API.G_EXC_ERROR THEN
5653: IF l_debug_level > 0 THEN
5654: oe_debug_pub.add( 'PROCESS_SMC_SHIPPING : EXE ERROR' , 1 ) ;
5655: END IF;
5656: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5656: x_return_status := FND_API.G_RET_STS_ERROR;

5652: WHEN FND_API.G_EXC_ERROR THEN
5653: IF l_debug_level > 0 THEN
5654: oe_debug_pub.add( 'PROCESS_SMC_SHIPPING : EXE ERROR' , 1 ) ;
5655: END IF;
5656: x_return_status := FND_API.G_RET_STS_ERROR;
5657: IF g_debug_call > 0 THEN
5658: G_DEBUG_MSG := G_DEBUG_MSG || 'E-37';
5659: END IF;
5660:

Line 5669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 5783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5779: ,p_caller => 'Ship_Confirm_Split_Lines'
5780: ,x_return_status => l_return_status);
5781:
5782:
5783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: END IF;

Line 5784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5780: ,x_return_status => l_return_status);
5781:
5782:
5783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: END IF;
5788:

Line 5785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5781:
5782:
5783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: END IF;
5788:
5789:

Line 5786: RAISE FND_API.G_EXC_ERROR;

5782:
5783: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5785: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5786: RAISE FND_API.G_EXC_ERROR;
5787: END IF;
5788:
5789:
5790: UPDATE OE_ORDER_LINES

Line 5815: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5811: IF l_debug_level > 0 THEN
5812: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
5813: END IF;
5814:
5815: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5817: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5818: RAISE FND_API.G_EXC_ERROR;
5819: END IF;

Line 5816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5812: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
5813: END IF;
5814:
5815: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5817: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5818: RAISE FND_API.G_EXC_ERROR;
5819: END IF;
5820:

Line 5817: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5813: END IF;
5814:
5815: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5817: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5818: RAISE FND_API.G_EXC_ERROR;
5819: END IF;
5820:
5821: END IF; -- if wdd has lines staged/shipped or not deleted

Line 5818: RAISE FND_API.G_EXC_ERROR;

5814:
5815: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5817: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5818: RAISE FND_API.G_EXC_ERROR;
5819: END IF;
5820:
5821: END IF; -- if wdd has lines staged/shipped or not deleted
5822:

Line 5868: x_return_status := FND_API.G_RET_STS_SUCCESS;

5864:
5865: Print_Time
5866: ('entering Call_Notification_Framework ' || p_caller);
5867:
5868: x_return_status := FND_API.G_RET_STS_SUCCESS;
5869:
5870:
5871: IF p_caller = 'Ship_Confirm_Split_Lines' THEN
5872: l_line_tbl(I) := p_line_rec;

Line 5913: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5909: oe_debug_pub.add
5910: (J || ' UPDATE_GLOBAL ret sts: ' || x_RETURN_STATUS);
5911: END IF;
5912:
5913: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5914: RETURN;
5915: END IF;
5916:
5917:

Line 5969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

5965: IF g_debug_call > 0 THEN
5966: G_DEBUG_MSG := G_DEBUG_MSG || '14-7';
5967: END IF;
5968:
5969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5970: RETURN;
5971: END IF;
5972:
5973: END IF; -- aso_installed

Line 6018: ,p_init_msg_list => FND_API.G_TRUE

6014: l_action_rec.org_id := MO_GLOBAL.get_current_org_id();
6015:
6016: WSH_bulk_process_grp.Create_update_delivery_details
6017: ( p_api_version_number => 1.0
6018: ,p_init_msg_list => FND_API.G_TRUE
6019: ,p_commit => FND_API.G_FALSE
6020: ,p_action_prms => l_action_rec
6021: ,p_line_rec => p_line_rec
6022: ,x_out_rec => l_out_rec

Line 6019: ,p_commit => FND_API.G_FALSE

6015:
6016: WSH_bulk_process_grp.Create_update_delivery_details
6017: ( p_api_version_number => 1.0
6018: ,p_init_msg_list => FND_API.G_TRUE
6019: ,p_commit => FND_API.G_FALSE
6020: ,p_action_prms => l_action_rec
6021: ,p_line_rec => p_line_rec
6022: ,x_out_rec => l_out_rec
6023: ,x_return_status => l_return_status

Line 6030: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR

6026:
6027: oe_debug_pub.add
6028: ('return status from WSH '|| l_return_status || '-' || l_msg_count, 5);
6029:
6030: IF l_return_status = FND_API.G_RET_STS_SUCCESS OR
6031: l_return_status = 'W' THEN
6032:
6033: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' AND
6034: OE_Sys_Parameters.Value('FIRM_DEMAND_EVENTS') = 'SHIPPING_INTERFACED'

Line 6112: (p_encoded => FND_API.G_FALSE,

6108:
6109: END IF;
6110:
6111: Fnd_Msg_Pub.GET
6112: (p_encoded => FND_API.G_FALSE,
6113: p_data => l_error_msg,
6114: p_msg_index_out => l_msg_index);
6115:
6116: IF l_debug_level > 0 THEN

Line 6137: x_return_status := FND_API.G_RET_STS_SUCCESS;

6133:
6134: END IF; -- if there were errors
6135:
6136: IF l_return_status = 'W' THEN
6137: x_return_status := FND_API.G_RET_STS_SUCCESS;
6138: ELSE
6139: x_return_status := l_return_status;
6140: END IF;
6141:

Line 6147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

6143: oe_debug_pub.add('return status from vshpb'|| x_return_status, 5);
6144: END IF;
6145:
6146: EXCEPTION
6147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6148: IF l_debug_level > 0 THEN
6149: oe_debug_pub.add('OM_TO_WSH_INTERFACE : UNEXPECTED ERROR',1);
6150: END IF;
6151:

Line 6152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

6148: IF l_debug_level > 0 THEN
6149: oe_debug_pub.add('OM_TO_WSH_INTERFACE : UNEXPECTED ERROR',1);
6150: END IF;
6151:
6152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6153:
6154: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6155: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
6156: 'OM_To_WSH_Interface');

Line 6162: WHEN FND_API.G_EXC_ERROR THEN

6158: IF g_debug_call > 0 THEN
6159: G_DEBUG_MSG := G_DEBUG_MSG || 'E-39';
6160: END IF;
6161:
6162: WHEN FND_API.G_EXC_ERROR THEN
6163: IF l_debug_level > 0 THEN
6164: oe_debug_pub.add('OM_TO_WSH_INTERFACE : EXE ERROR',1);
6165: END IF;
6166: x_return_status := FND_API.G_RET_STS_ERROR;

Line 6166: x_return_status := FND_API.G_RET_STS_ERROR;

6162: WHEN FND_API.G_EXC_ERROR THEN
6163: IF l_debug_level > 0 THEN
6164: oe_debug_pub.add('OM_TO_WSH_INTERFACE : EXE ERROR',1);
6165: END IF;
6166: x_return_status := FND_API.G_RET_STS_ERROR;
6167:
6168: WHEN OTHERS THEN
6169: IF l_debug_level > 0 THEN
6170: oe_debug_pub.add('OM_TO_WSH_INTERFACE, OTHERS '|| sqlerrm ,1);

Line 6176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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