eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on FND_API

Line 429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

425: IF l_debug_level > 0 THEN
426: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
427: END IF;
428:
429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;

Line 430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

426: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
427: END IF;
428:
429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434:

Line 431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

427: END IF;
428:
429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434:
435: << END_REQ_QTY >>

Line 432: RAISE FND_API.G_EXC_ERROR;

428:
429: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
431: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
432: RAISE FND_API.G_EXC_ERROR;
433: END IF;
434:
435: << END_REQ_QTY >>
436: NULL;

Line 557: RAISE FND_API.G_EXC_ERROR;

553: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
554: IF l_debug_level > 0 THEN
555: OE_DEBUG_PUB.Add('Unable to lock the line/parent',3);
556: END IF;
557: RAISE FND_API.G_EXC_ERROR;
558:
559:
560: WHEN OTHERS THEN
561: IF l_debug_level > 0 THEN

Line 565: RAISE FND_API.G_EXC_ERROR;

561: IF l_debug_level > 0 THEN
562: OE_DEBUG_PUB.Add('Unable to process ship confirm line:'||
563: sqlerrm,3);
564: END IF;
565: RAISE FND_API.G_EXC_ERROR;
566:
567: END;
568: --bug3549422 ends
569:

Line 570: IF p_line_tbl(J).ship_tolerance_below = FND_API.G_MISS_NUM THEN

566:
567: END;
568: --bug3549422 ends
569:
570: IF p_line_tbl(J).ship_tolerance_below = FND_API.G_MISS_NUM THEN
571:
572: l_ship_tolerance_below_upd := l_ship_tolerance_below;
573:
574: ELSE

Line 580: IF p_line_tbl(J).over_ship_reason_code = FND_API.G_MISS_CHAR THEN

576: l_ship_tolerance_below_upd := p_line_tbl(J).ship_tolerance_below;
577:
578: END IF;
579:
580: IF p_line_tbl(J).over_ship_reason_code = FND_API.G_MISS_CHAR THEN
581:
582: l_over_ship_reason_code_upd := l_over_ship_reason_code;
583:
584: ELSE

Line 906: l_ship_set_id <> FND_API.G_MISS_NUM) THEN

902:
903: -- Add to the ship confirm table
904:
905: IF (l_ship_set_id IS NOT NULL AND
906: l_ship_set_id <> FND_API.G_MISS_NUM) THEN
907: IF l_debug_level > 0 THEN
908: oe_debug_pub.add( 'SHIP SET SHIPPED : '||L_SHIP_SET_ID , 3 ) ;
909: END IF;
910:

Line 929: l_ato_line_id <> FND_API.G_MISS_NUM) AND

925:
926: END IF;
927:
928: ELSIF (l_ato_line_id IS NOT NULL AND
929: l_ato_line_id <> FND_API.G_MISS_NUM) AND
930: l_item_type_code = Oe_Globals.G_ITEM_CONFIG AND
931: l_ato_line_id = l_top_model_line_id THEN
932:
933: IF l_debug_level > 0 THEN

Line 955: l_top_model_line_id <> FND_API.G_MISS_NUM) AND

951:
952: END IF;
953:
954: ELSIF (l_top_model_line_id IS NOT NULL AND
955: l_top_model_line_id <> FND_API.G_MISS_NUM) AND
956: nvl(l_model_remnant_flag,'N') = 'N' THEN
957:
958: l_top_model_line_id_mod := mod(l_top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);-- Bug 8795918
959:

Line 1173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1169: IF l_debug_level > 0 THEN
1170: oe_debug_pub.add( 'RETRUN STATUS FROM PROCESS_SHIP_CONFIRM : '||L_RETURN_STATUS , 3 ) ;
1171: END IF;
1172:
1173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;

Line 1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1170: oe_debug_pub.add( 'RETRUN STATUS FROM PROCESS_SHIP_CONFIRM : '||L_RETURN_STATUS , 3 ) ;
1171: END IF;
1172:
1173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178:

Line 1175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1171: END IF;
1172:
1173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178:
1179: l_ship_confirm_index := l_ship_confirm_tbl.NEXT(l_ship_confirm_index);

Line 1176: RAISE FND_API.G_EXC_ERROR;

1172:
1173: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1175: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1176: RAISE FND_API.G_EXC_ERROR;
1177: END IF;
1178:
1179: l_ship_confirm_index := l_ship_confirm_tbl.NEXT(l_ship_confirm_index);
1180:

Line 1211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1207: ) ;
1208: oe_debug_pub.add('UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
1209: END IF;
1210:
1211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;

Line 1212: RAISE FND_API.G_EXC_ERROR;

1208: oe_debug_pub.add('UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
1209: END IF;
1210:
1211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216:

Line 1213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1209: END IF;
1210:
1211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216:
1217: IF l_notify_index is not null then

Line 1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1210:
1211: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1212: RAISE FND_API.G_EXC_ERROR;
1213: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END IF;
1216:
1217: IF l_notify_index is not null then
1218: -- modify Global Picture

Line 1289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1285: IF l_debug_level > 0 THEN
1286: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1287: END IF;
1288:
1289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;

Line 1290: RAISE FND_API.G_EXC_ERROR;

1286: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1287: END IF;
1288:
1289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:

Line 1291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1287: END IF;
1288:
1289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:
1295: ELSE /* pre-code H */

Line 1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1288:
1289: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1290: RAISE FND_API.G_EXC_ERROR;
1291: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1293: END IF;
1294:
1295: ELSE /* pre-code H */
1296:

Line 1312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1310: END IF;
1311:
1312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1313: RAISE FND_API.G_EXC_ERROR;
1314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: END IF;

Line 1313: RAISE FND_API.G_EXC_ERROR;

1309: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1310: END IF;
1311:
1312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1313: RAISE FND_API.G_EXC_ERROR;
1314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: END IF;
1317:

Line 1314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1310: END IF;
1311:
1312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1313: RAISE FND_API.G_EXC_ERROR;
1314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: END IF;
1317:
1318: END IF; /* code set is pack H or higher */

Line 1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1311:
1312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1313: RAISE FND_API.G_EXC_ERROR;
1314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: END IF;
1317:
1318: END IF; /* code set is pack H or higher */
1319: /* jolin end*/

Line 1323: x_return_status := FND_API.G_RET_STS_SUCCESS;

1319: /* jolin end*/
1320:
1321: END IF; --IF p_line_tbl.COUNT > 0
1322:
1323: x_return_status := FND_API.G_RET_STS_SUCCESS;
1324:
1325: OE_MSG_PUB.Count_And_Get
1326: ( p_count => x_msg_count
1327: , p_data => x_msg_data

Line 1336: WHEN FND_API.G_EXC_ERROR THEN

1332: END IF;
1333:
1334: EXCEPTION
1335:
1336: WHEN FND_API.G_EXC_ERROR THEN
1337:
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'EXC ERROR : '||SQLERRM , 1 ) ;
1340: END IF;

Line 1341: x_return_status := FND_API.G_RET_STS_ERROR;

1337:
1338: IF l_debug_level > 0 THEN
1339: oe_debug_pub.add( 'EXC ERROR : '||SQLERRM , 1 ) ;
1340: END IF;
1341: x_return_status := FND_API.G_RET_STS_ERROR;
1342:
1343: -- Get message count and data
1344:
1345: OE_MSG_PUB.Count_And_Get

Line 1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1346: ( p_count => x_msg_count
1347: , p_data => x_msg_data
1348: );
1349:
1350: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1351:
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1354: END IF;

Line 1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1351:
1352: IF l_debug_level > 0 THEN
1353: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1354: END IF;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1356:
1357: -- Get message count and data
1358:
1359: OE_MSG_PUB.Count_And_Get

Line 1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1380: OE_MSG_PUB.Count_And_Get
1381: ( p_count => x_msg_count
1382: , p_data => x_msg_data
1383: );
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1385:
1386: END Ship_Confirm;
1387:
1388: PROCEDURE Process_Requests

Line 1402: ,p_delete => FND_API.G_TRUE

1398: THEN
1399:
1400: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1401: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ
1402: ,p_delete => FND_API.G_TRUE
1403: ,x_return_status => l_return_status
1404: );
1405: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1405: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1401: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ
1402: ,p_delete => FND_API.G_TRUE
1403: ,x_return_status => l_return_status
1404: );
1405: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1408: RAISE FND_API.G_EXC_ERROR;
1409: END IF;

Line 1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1402: ,p_delete => FND_API.G_TRUE
1403: ,x_return_status => l_return_status
1404: );
1405: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1408: RAISE FND_API.G_EXC_ERROR;
1409: END IF;
1410:

Line 1407: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1403: ,x_return_status => l_return_status
1404: );
1405: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1408: RAISE FND_API.G_EXC_ERROR;
1409: END IF;
1410:
1411: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1408: RAISE FND_API.G_EXC_ERROR;

1404: );
1405: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1408: RAISE FND_API.G_EXC_ERROR;
1409: END IF;
1410:
1411: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1412: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att

Line 1413: ,p_delete => FND_API.G_TRUE

1409: END IF;
1410:
1411: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1412: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att
1413: ,p_delete => FND_API.G_TRUE
1414: ,x_return_status => l_return_status
1415: );
1416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1412: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att
1413: ,p_delete => FND_API.G_TRUE
1414: ,x_return_status => l_return_status
1415: );
1416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;

Line 1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1413: ,p_delete => FND_API.G_TRUE
1414: ,x_return_status => l_return_status
1415: );
1416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:

Line 1418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1414: ,x_return_status => l_return_status
1415: );
1416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1419: RAISE FND_API.G_EXC_ERROR;

1415: );
1416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1423: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att

Line 1424: ,p_delete => FND_API.G_TRUE

1420: END IF;
1421:
1422: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1423: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att
1424: ,p_delete => FND_API.G_TRUE
1425: ,x_return_status => l_return_status
1426: );
1427: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1427: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1423: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att
1424: ,p_delete => FND_API.G_TRUE
1425: ,x_return_status => l_return_status
1426: );
1427: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;

Line 1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1424: ,p_delete => FND_API.G_TRUE
1425: ,x_return_status => l_return_status
1426: );
1427: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:

Line 1429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1425: ,x_return_status => l_return_status
1426: );
1427: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1430: RAISE FND_API.G_EXC_ERROR;

1426: );
1427: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1428: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1429: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1434: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc

Line 1435: ,p_delete => FND_API.G_TRUE

1431: END IF;
1432:
1433: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1434: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc
1435: ,p_delete => FND_API.G_TRUE
1436: ,x_return_status => l_return_status
1437: );
1438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1434: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc
1435: ,p_delete => FND_API.G_TRUE
1436: ,x_return_status => l_return_status
1437: );
1438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;

Line 1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1435: ,p_delete => FND_API.G_TRUE
1436: ,x_return_status => l_return_status
1437: );
1438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443:

Line 1440: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1436: ,x_return_status => l_return_status
1437: );
1438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443:
1444: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1441: RAISE FND_API.G_EXC_ERROR;

1437: );
1438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1440: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443:
1444: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1445: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit

Line 1446: ,p_delete => FND_API.G_TRUE

1442: END IF;
1443:
1444: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1445: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit
1446: ,p_delete => FND_API.G_TRUE
1447: ,x_return_status => l_return_status
1448: );
1449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1445: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit
1446: ,p_delete => FND_API.G_TRUE
1447: ,x_return_status => l_return_status
1448: );
1449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1452: RAISE FND_API.G_EXC_ERROR;
1453: END IF;

Line 1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1446: ,p_delete => FND_API.G_TRUE
1447: ,x_return_status => l_return_status
1448: );
1449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1452: RAISE FND_API.G_EXC_ERROR;
1453: END IF;
1454:

Line 1451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1447: ,x_return_status => l_return_status
1448: );
1449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1452: RAISE FND_API.G_EXC_ERROR;
1453: END IF;
1454:
1455: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1452: RAISE FND_API.G_EXC_ERROR;

1448: );
1449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1451: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1452: RAISE FND_API.G_EXC_ERROR;
1453: END IF;
1454:
1455: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1456: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

Line 1457: ,p_delete => FND_API.G_TRUE

1453: END IF;
1454:
1455: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1456: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
1457: ,p_delete => FND_API.G_TRUE
1458: ,x_return_status => l_return_status
1459: );
1460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1456: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
1457: ,p_delete => FND_API.G_TRUE
1458: ,x_return_status => l_return_status
1459: );
1460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;

Line 1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1457: ,p_delete => FND_API.G_TRUE
1458: ,x_return_status => l_return_status
1459: );
1460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:

Line 1462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1458: ,x_return_status => l_return_status
1459: );
1460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1463: RAISE FND_API.G_EXC_ERROR;

1459: );
1460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1461: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1462: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1467: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ

Line 1468: ,p_delete => FND_API.G_TRUE

1464: END IF;
1465:
1466: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1467: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ
1468: ,p_delete => FND_API.G_TRUE
1469: ,x_return_status => l_return_status
1470: );
1471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1467: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ
1468: ,p_delete => FND_API.G_TRUE
1469: ,x_return_status => l_return_status
1470: );
1471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: END IF;

Line 1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1468: ,p_delete => FND_API.G_TRUE
1469: ,x_return_status => l_return_status
1470: );
1471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: END IF;
1476:

Line 1473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1469: ,x_return_status => l_return_status
1470: );
1471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: END IF;
1476:
1477: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1474: RAISE FND_API.G_EXC_ERROR;

1470: );
1471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1473: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: END IF;
1476:
1477: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1478: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Scredit

Line 1479: ,p_delete => FND_API.G_TRUE

1475: END IF;
1476:
1477: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1478: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Scredit
1479: ,p_delete => FND_API.G_TRUE
1480: ,x_return_status => l_return_status
1481: );
1482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1478: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Scredit
1479: ,p_delete => FND_API.G_TRUE
1480: ,x_return_status => l_return_status
1481: );
1482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;

Line 1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1479: ,p_delete => FND_API.G_TRUE
1480: ,x_return_status => l_return_status
1481: );
1482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:

Line 1484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1480: ,x_return_status => l_return_status
1481: );
1482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:
1488: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1485: RAISE FND_API.G_EXC_ERROR;

1481: );
1482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:
1488: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1489: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att

Line 1490: ,p_delete => FND_API.G_TRUE

1486: END IF;
1487:
1488: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1489: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att
1490: ,p_delete => FND_API.G_TRUE
1491: ,x_return_status => l_return_status
1492: );
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1489: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att
1490: ,p_delete => FND_API.G_TRUE
1491: ,x_return_status => l_return_status
1492: );
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;

Line 1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1490: ,p_delete => FND_API.G_TRUE
1491: ,x_return_status => l_return_status
1492: );
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498:

Line 1495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1491: ,x_return_status => l_return_status
1492: );
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498:
1499: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1496: RAISE FND_API.G_EXC_ERROR;

1492: );
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1494: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1495: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498:
1499: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1500: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Att

Line 1501: ,p_delete => FND_API.G_TRUE

1497: END IF;
1498:
1499: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1500: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Att
1501: ,p_delete => FND_API.G_TRUE
1502: ,x_return_status => l_return_status
1503: );
1504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1500: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Att
1501: ,p_delete => FND_API.G_TRUE
1502: ,x_return_status => l_return_status
1503: );
1504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: END IF;

Line 1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1501: ,p_delete => FND_API.G_TRUE
1502: ,x_return_status => l_return_status
1503: );
1504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: END IF;
1509:

Line 1506: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1502: ,x_return_status => l_return_status
1503: );
1504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: END IF;
1509:
1510: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1507: RAISE FND_API.G_EXC_ERROR;

1503: );
1504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1507: RAISE FND_API.G_EXC_ERROR;
1508: END IF;
1509:
1510: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1511: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Assoc

Line 1512: ,p_delete => FND_API.G_TRUE

1508: END IF;
1509:
1510: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1511: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Assoc
1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1511: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Assoc
1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;

Line 1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520:

Line 1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520:
1521: -- Execute all remaining delayed requests. This would execute

Line 1518: RAISE FND_API.G_EXC_ERROR;

1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;
1520:
1521: -- Execute all remaining delayed requests. This would execute
1522: -- requests logged against entity G_ENTITY_HEADER and G_ENTITY_ALL

Line 1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1524: OE_DELAYED_REQUESTS_PVT.Process_Delayed_Requests(
1525: x_return_status => l_return_status
1526: );
1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;

Line 1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1525: x_return_status => l_return_status
1526: );
1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:

Line 1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1526: );
1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:
1534:

Line 1531: RAISE FND_API.G_EXC_ERROR;

1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:
1534:
1535: END IF; --End of requests processing

Line 1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1882: IF l_debug_level > 0 THEN
1883: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
1884: END IF;
1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: END IF;

Line 1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1883: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
1884: END IF;
1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: END IF;
1891:

Line 1888: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1884: END IF;
1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: END IF;
1891:
1892: ELSE

Line 1889: RAISE FND_API.G_EXC_ERROR;

1885:
1886: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1889: RAISE FND_API.G_EXC_ERROR;
1890: END IF;
1891:
1892: ELSE
1893: IF l_debug_level > 0 THEN

Line 2039: and p_ship_line_rec.order_quantity_uom2(p_index) <> FND_API.G_MISS_CHAR )

2035:
2036: -- IF p_opm_check = 'Y' AND -- INVCONV -- pete
2037:
2038: IF ( p_ship_line_rec.order_quantity_uom2(p_index) is NOT NULL
2039: and p_ship_line_rec.order_quantity_uom2(p_index) <> FND_API.G_MISS_CHAR )
2040: THEN
2041:
2042: IF p_ship_line_rec.order_quantity_uom(p_index)
2043: <> p_ship_line_rec.order_quantity_uom2(p_index) THEN

Line 2228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2224: IF l_debug_level > 0 THEN
2225: oe_debug_pub.add('local split line RET STS : '||L_RETURN_STATUS,3);
2226: END IF;
2227:
2228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2231: RAISE FND_API.G_EXC_ERROR;
2232: END IF;

Line 2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2225: oe_debug_pub.add('local split line RET STS : '||L_RETURN_STATUS,3);
2226: END IF;
2227:
2228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2231: RAISE FND_API.G_EXC_ERROR;
2232: END IF;
2233:

Line 2230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2226: END IF;
2227:
2228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2231: RAISE FND_API.G_EXC_ERROR;
2232: END IF;
2233:
2234:

Line 2231: RAISE FND_API.G_EXC_ERROR;

2227:
2228: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2230: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2231: RAISE FND_API.G_EXC_ERROR;
2232: END IF;
2233:
2234:
2235: EXCEPTION

Line 2304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2300: IF l_debug_level > 0 THEN
2301: oe_debug_pub.add('RET STS FROM GET ACT RESULT: '||L_RETURN_STATUS , 3 ) ;
2302: END IF;
2303:
2304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2306: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2307: IF l_debug_level > 0 THEN
2308: oe_debug_pub.add('LINE IS NOT AT FULFILLMENT ACTIVITY ',3);

Line 2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2301: oe_debug_pub.add('RET STS FROM GET ACT RESULT: '||L_RETURN_STATUS , 3 ) ;
2302: END IF;
2303:
2304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2306: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2307: IF l_debug_level > 0 THEN
2308: oe_debug_pub.add('LINE IS NOT AT FULFILLMENT ACTIVITY ',3);
2309: END IF;

Line 2306: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2302: END IF;
2303:
2304: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2305: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2306: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2307: IF l_debug_level > 0 THEN
2308: oe_debug_pub.add('LINE IS NOT AT FULFILLMENT ACTIVITY ',3);
2309: END IF;
2310: ELSE

Line 2323: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2319: p_activity_id => l_activity_id,
2320: x_fulfillment_activity => l_fulfillment_activity,
2321: x_return_status => l_return_status);
2322:
2323: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;

Line 2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2320: x_fulfillment_activity => l_fulfillment_activity,
2321: x_return_status => l_return_status);
2322:
2323: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;
2328:

Line 2325: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2321: x_return_status => l_return_status);
2322:
2323: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;
2328:
2329: IF l_debug_level > 0 THEN

Line 2326: RAISE FND_API.G_EXC_ERROR;

2322:
2323: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2324: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2325: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2326: RAISE FND_API.G_EXC_ERROR;
2327: END IF;
2328:
2329: IF l_debug_level > 0 THEN
2330: oe_debug_pub.add( 'FULFILLMENT ACT : '||L_FULFILLMENT_ACTIVITY , 3 ) ;

Line 2335: l_fulfillment_set_flag = FND_API.G_FALSE THEN -- bug 4176692

2331: END IF;
2332:
2333: IF (l_fulfillment_activity = 'NO_ACTIVITY' OR
2334: l_fulfillment_activity = 'SHIP_LINE') AND
2335: l_fulfillment_set_flag = FND_API.G_FALSE THEN -- bug 4176692
2336:
2337: l_fulfill_index := l_fulfill_index + 1;
2338: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2339: l_fulfill_tbl(l_fulfill_index).line_id := line_rec.line_id;

Line 2384: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2380: p_fulfillment_type => 'No Activity',
2381: p_fulfillment_activity => 'NO_ACTIVITY',
2382: x_return_status => l_return_status);
2383:
2384: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;

Line 2385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2381: p_fulfillment_activity => 'NO_ACTIVITY',
2382: x_return_status => l_return_status);
2383:
2384: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;
2389:

Line 2386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2382: x_return_status => l_return_status);
2383:
2384: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;
2389:
2390: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count

Line 2387: RAISE FND_API.G_EXC_ERROR;

2383:
2384: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2385: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2386: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2387: RAISE FND_API.G_EXC_ERROR;
2388: END IF;
2389:
2390: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count
2391: LOOP

Line 2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2402: IF l_debug_level > 0 THEN
2403: oe_debug_pub.add('RET STS FROM FLOW STATUS API '||L_RETURN_STATUS,3);
2404: END IF;
2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;

Line 2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2403: oe_debug_pub.add('RET STS FROM FLOW STATUS API '||L_RETURN_STATUS,3);
2404: END IF;
2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411:

Line 2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2404: END IF;
2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411:
2412: OE_Delayed_Requests_Pvt.Log_Request

Line 2409: RAISE FND_API.G_EXC_ERROR;

2405:
2406: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2408: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411:
2412: OE_Delayed_Requests_Pvt.Log_Request
2413: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 2433: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2429: IF l_debug_level > 0 THEN
2430: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
2431: END IF;
2432:
2433: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;

Line 2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2430: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
2431: END IF;
2432:
2433: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;
2438:

Line 2435: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2431: END IF;
2432:
2433: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;
2438:
2439: END LOOP; -- fulfill table has rows.

Line 2436: RAISE FND_API.G_EXC_ERROR;

2432:
2433: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2434: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2435: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2436: RAISE FND_API.G_EXC_ERROR;
2437: END IF;
2438:
2439: END LOOP; -- fulfill table has rows.
2440:

Line 2524: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2520: IF l_debug_level > 0 THEN
2521: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
2522: END IF;
2523:
2524: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;

Line 2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2521: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
2522: END IF;
2523:
2524: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
2529: END IF;

Line 2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2522: END IF;
2523:
2524: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2525: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2526: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2527: IF l_debug_level > 0 THEN
2528: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
2529: END IF;
2530: ELSE

Line 2551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2547: p_param3 => 'WAIT_FOR_CTO',
2548: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2549: x_return_status => l_return_status);
2550:
2551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2554: RAISE FND_API.G_EXC_ERROR;
2555: END IF;

Line 2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2548: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2549: x_return_status => l_return_status);
2550:
2551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2554: RAISE FND_API.G_EXC_ERROR;
2555: END IF;
2556:

Line 2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2549: x_return_status => l_return_status);
2550:
2551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2554: RAISE FND_API.G_EXC_ERROR;
2555: END IF;
2556:
2557: IF l_debug_level > 0 THEN

Line 2554: RAISE FND_API.G_EXC_ERROR;

2550:
2551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2553: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2554: RAISE FND_API.G_EXC_ERROR;
2555: END IF;
2556:
2557: IF l_debug_level > 0 THEN
2558: oe_debug_pub.add('ato parent workflow progressed '

Line 2661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2657: p_param3 => 'SHIP_LINE',
2658: p_param4 => 'SHIP_CONFIRM',
2659: x_return_status => l_return_status);
2660:
2661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;

Line 2662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2658: p_param4 => 'SHIP_CONFIRM',
2659: x_return_status => l_return_status);
2660:
2661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666:

Line 2663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2659: x_return_status => l_return_status);
2660:
2661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666:
2667: IF l_debug_level > 0 THEN

Line 2664: RAISE FND_API.G_EXC_ERROR;

2660:
2661: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2663: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2664: RAISE FND_API.G_EXC_ERROR;
2665: END IF;
2666:
2667: IF l_debug_level > 0 THEN
2668: oe_debug_pub.add('after wf completion delayed request', 3);

Line 2690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2686: p_flow_status_code => 'SHIPPED',
2687: x_return_status => l_return_status );
2688:
2689:
2690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;

Line 2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2687: x_return_status => l_return_status );
2688:
2689:
2690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:

Line 2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2688:
2689:
2690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:
2696: IF l_debug_level > 0 THEN

Line 2693: RAISE FND_API.G_EXC_ERROR;

2689:
2690: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2692: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2693: RAISE FND_API.G_EXC_ERROR;
2694: END IF;
2695:
2696: IF l_debug_level > 0 THEN
2697: oe_debug_pub.add('leaving Ship_Confirm_Line', 3);

Line 3470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3466: IF l_debug_level > 0 THEN
3467: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
3468: END IF;
3469:
3470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3473: RAISE FND_API.G_EXC_ERROR;
3474: END IF;

Line 3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3467: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
3468: END IF;
3469:
3470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3473: RAISE FND_API.G_EXC_ERROR;
3474: END IF;
3475:

Line 3472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3468: END IF;
3469:
3470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3473: RAISE FND_API.G_EXC_ERROR;
3474: END IF;
3475:
3476: END IF; -- if wdd has lines staged/shipped or not deleted

Line 3473: RAISE FND_API.G_EXC_ERROR;

3469:
3470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3473: RAISE FND_API.G_EXC_ERROR;
3474: END IF;
3475:
3476: END IF; -- if wdd has lines staged/shipped or not deleted
3477:

Line 3673: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3669: IF l_debug_level > 0 THEN
3670: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
3671: END IF;
3672:
3673: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3676: RAISE FND_API.G_EXC_ERROR;
3677: END IF;

Line 3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3670: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
3671: END IF;
3672:
3673: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3676: RAISE FND_API.G_EXC_ERROR;
3677: END IF;
3678: END IF;

Line 3675: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3671: END IF;
3672:
3673: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3676: RAISE FND_API.G_EXC_ERROR;
3677: END IF;
3678: END IF;
3679:

Line 3676: RAISE FND_API.G_EXC_ERROR;

3672:
3673: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3675: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3676: RAISE FND_API.G_EXC_ERROR;
3677: END IF;
3678: END IF;
3679:
3680: I := p_set_tbl.NEXT(I);

Line 3693: RAISE FND_API.G_EXC_ERROR;

3689: IF l_debug_level > 0 THEN
3690: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3691: END IF;
3692: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3693: RAISE FND_API.G_EXC_ERROR;
3694:
3695: WHEN OTHERS THEN
3696: IF l_debug_level > 0 THEN
3697: oe_debug_pub.add('error in Remove_Lines_From_Shipset '|| sqlerrm,3);

Line 3760: x_return_status := FND_API.G_RET_STS_SUCCESS;

3756: END IF;
3757: --9354229
3758: oe_globals.g_call_process_req := FALSE;
3759:
3760: x_return_status := FND_API.G_RET_STS_SUCCESS;
3761: IF l_debug_level > 0 THEN
3762: oe_debug_pub.ADD('request_line_rec line_id count: ' || p_requested_line_rec.line_id.COUNT, 3);
3763: END IF;
3764:

Line 3892: RAISE FND_API.G_EXC_ERROR;

3888: IF l_debug_level > 0 THEN
3889: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3890: END IF;
3891: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3892: RAISE FND_API.G_EXC_ERROR;
3893: WHEN others THEN
3894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3895: IF l_debug_level > 0 THEN
3896: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);

Line 3894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3890: END IF;
3891: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3892: RAISE FND_API.G_EXC_ERROR;
3893: WHEN others THEN
3894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3895: IF l_debug_level > 0 THEN
3896: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
3897: END IF;
3898: RAISE;

Line 3921: RAISE FND_API.G_EXC_ERROR;

3917: IF l_debug_level > 0 THEN
3918: OE_DEBUG_PUB.Add('Unable to lock the ship set :' || l_ship_set_id ,3);
3919: END IF;
3920: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');
3921: RAISE FND_API.G_EXC_ERROR;
3922: WHEN others THEN
3923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3924: IF l_debug_level > 0 THEN
3925: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);

Line 3923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3919: END IF;
3920: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');
3921: RAISE FND_API.G_EXC_ERROR;
3922: WHEN others THEN
3923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3924: IF l_debug_level > 0 THEN
3925: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
3926: END IF;
3927: RAISE;

Line 3951: RAISE FND_API.G_EXC_ERROR;

3947: IF l_debug_level > 0 THEN
3948: OE_DEBUG_PUB.Add('Unable to lock the arrival set :' || l_arrival_set_id ,3);
3949: END IF;
3950: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');
3951: RAISE FND_API.G_EXC_ERROR;
3952: WHEN others THEN
3953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3954: IF l_debug_level > 0 THEN
3955: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);

Line 3953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3949: END IF;
3950: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');
3951: RAISE FND_API.G_EXC_ERROR;
3952: WHEN others THEN
3953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3954: IF l_debug_level > 0 THEN
3955: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
3956: END IF;
3957: RAISE;

Line 3993: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3989: IF l_debug_level > 0 THEN
3990: Oe_Debug_pub.Add('returning ...'|| x_return_status, 5);
3991: END IF;
3992:
3993: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3995: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: END IF;

Line 3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3990: Oe_Debug_pub.Add('returning ...'|| x_return_status, 5);
3991: END IF;
3992:
3993: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3995: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: END IF;
3998:

Line 3995: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3991: END IF;
3992:
3993: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3995: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: END IF;
3998:
3999: RETURN;

Line 3996: RAISE FND_API.G_EXC_ERROR;

3992:
3993: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3995: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3996: RAISE FND_API.G_EXC_ERROR;
3997: END IF;
3998:
3999: RETURN;
4000:

Line 4237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4233: IF l_debug_level > 0 THEN
4234: Oe_Debug_pub.Add('Ret sts After Delayed Req'||l_return_status, 4);
4235: END IF;
4236:
4237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4240: RAISE FND_API.G_EXC_ERROR;
4241: END IF;

Line 4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4234: Oe_Debug_pub.Add('Ret sts After Delayed Req'||l_return_status, 4);
4235: END IF;
4236:
4237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4240: RAISE FND_API.G_EXC_ERROR;
4241: END IF;
4242:

Line 4239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4235: END IF;
4236:
4237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4240: RAISE FND_API.G_EXC_ERROR;
4241: END IF;
4242:
4243: K := l_order_has_lines.NEXT(K);

Line 4240: RAISE FND_API.G_EXC_ERROR;

4236:
4237: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4239: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4240: RAISE FND_API.G_EXC_ERROR;
4241: END IF;
4242:
4243: K := l_order_has_lines.NEXT(K);
4244: END LOOP;

Line 4315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4311: IF l_debug_level > 0 THEN
4312: oe_debug_pub.add('After call to Authorize_MultiPayments return status : ' || l_return_status,5);
4313: END IF;
4314:
4315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4316: RAISE FND_API.G_EXC_ERROR;
4317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319: END IF;

Line 4316: RAISE FND_API.G_EXC_ERROR;

4312: oe_debug_pub.add('After call to Authorize_MultiPayments return status : ' || l_return_status,5);
4313: END IF;
4314:
4315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4316: RAISE FND_API.G_EXC_ERROR;
4317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319: END IF;
4320: END;

Line 4317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4313: END IF;
4314:
4315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4316: RAISE FND_API.G_EXC_ERROR;
4317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319: END IF;
4320: END;
4321: END IF;

Line 4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4314:
4315: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4316: RAISE FND_API.G_EXC_ERROR;
4317: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4318: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4319: END IF;
4320: END;
4321: END IF;
4322: END LOOP;

Line 4339: RAISE FND_API.G_EXC_ERROR;

4335: oe_globals.g_call_process_req := TRUE;
4336: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4337: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4338: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4339: RAISE FND_API.G_EXC_ERROR;
4340:
4341: WHEN others THEN
4342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4343: IF l_debug_level > 0 THEN

Line 4342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4338: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4339: RAISE FND_API.G_EXC_ERROR;
4340:
4341: WHEN others THEN
4342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4343: IF l_debug_level > 0 THEN
4344: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
4345: END IF;
4346: --9354229

Line 4375: x_return_status := FND_API.G_RET_STS_SUCCESS;

4371: l_temp_index NUMBER;
4372: l_temp_header_id NUMBER;
4373:
4374: BEGIN
4375: x_return_status := FND_API.G_RET_STS_SUCCESS;
4376:
4377: l_temp_header_id := p_ship_line_rec.header_id(p_start_index);
4378: l_order_start_index := p_start_index;
4379:

Line 4524: x_return_status := FND_API.G_RET_STS_SUCCESS;

4520: oe_debug_pub.ADD('entering Handle_Bulk_Mode_Per_Order '
4521: || p_ship_line_rec.header_id(p_start_index),5);
4522: END IF;
4523:
4524: x_return_status := FND_API.G_RET_STS_SUCCESS;
4525:
4526: -- Setting the message context, bug 4516453
4527: OE_MSG_PUB.set_msg_context(
4528: p_entity_code => 'HEADER'

Line 4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4710: IF l_debug_level > 0 THEN
4711: Oe_Debug_pub.Add('After price line for '||l_return_status, 1);
4712: END IF;
4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;

Line 4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4711: Oe_Debug_pub.Add('After price line for '||l_return_status, 1);
4712: END IF;
4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719:

Line 4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4712: END IF;
4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719:
4720: J := l_order_has_lines.NEXT(J);

Line 4717: RAISE FND_API.G_EXC_ERROR;

4713:
4714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4717: RAISE FND_API.G_EXC_ERROR;
4718: END IF;
4719:
4720: J := l_order_has_lines.NEXT(J);
4721: END LOOP;

Line 4751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

4747: IF l_debug_level > 0 THEN
4748: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status,5);
4749: END IF;
4750:
4751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4752: RAISE FND_API.G_EXC_ERROR;
4753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4755: END IF;

Line 4752: RAISE FND_API.G_EXC_ERROR;

4748: oe_debug_pub.add('After call to Authorizat Payment return status : ' || l_return_status,5);
4749: END IF;
4750:
4751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4752: RAISE FND_API.G_EXC_ERROR;
4753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4755: END IF;
4756: END;

Line 4753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4749: END IF;
4750:
4751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4752: RAISE FND_API.G_EXC_ERROR;
4753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4755: END IF;
4756: END;
4757: END IF;

Line 4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4750:
4751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
4752: RAISE FND_API.G_EXC_ERROR;
4753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4755: END IF;
4756: END;
4757: END IF;
4758: --CC Reversal ER#16014135 End

Line 4891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4887: oe_debug_pub.add('Workflow complete activity failed. Raising');
4888: RAISE ;
4889: END ;
4890:
4891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;

Line 4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4888: RAISE ;
4889: END ;
4890:
4891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;
4896:

Line 4893: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4889: END ;
4890:
4891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;
4896:
4897: END IF;

Line 4894: RAISE FND_API.G_EXC_ERROR;

4890:
4891: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4893: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4894: RAISE FND_API.G_EXC_ERROR;
4895: END IF;
4896:
4897: END IF;
4898:

Line 4998: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4994: ,x_return_status => l_return_status
4995: ,p_line_tbl => l_line_tbl
4996: ,p_old_line_tbl => l_old_line_tbl );
4997:
4998: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4999: x_return_status := l_return_status;
5000: IF l_debug_level > 0 THEN
5001: OE_DEBUG_PUB.Add ('Failure in Process_Requests_ANd_Notify',1);
5002: END IF;

Line 5011: ,p_delete => FND_API.G_TRUE

5007: oe_debug_pub.add('OEXPSHCB:calling Tax Delayed Request');
5008: END IF;
5009: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
5010: (p_request_type => OE_GLOBALS.G_TAX_LINE
5011: ,p_delete => FND_API.G_TRUE
5012: ,x_return_status => l_return_status
5013: );
5014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5010: (p_request_type => OE_GLOBALS.G_TAX_LINE
5011: ,p_delete => FND_API.G_TRUE
5012: ,x_return_status => l_return_status
5013: );
5014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5016: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;

Line 5015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5011: ,p_delete => FND_API.G_TRUE
5012: ,x_return_status => l_return_status
5013: );
5014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5016: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;
5019: --12552430 End

Line 5016: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5012: ,x_return_status => l_return_status
5013: );
5014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5016: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;
5019: --12552430 End
5020:

Line 5017: RAISE FND_API.G_EXC_ERROR;

5013: );
5014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5016: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5017: RAISE FND_API.G_EXC_ERROR;
5018: END IF;
5019: --12552430 End
5020:
5021: -- Reseting the msg context, bug 4516453

Line 5036: RAISE FND_API.G_EXC_ERROR;

5032: END IF;
5033: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
5034: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
5035: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
5036: RAISE FND_API.G_EXC_ERROR;
5037:
5038: WHEN others THEN
5039: IF l_debug_level > 0 THEN
5040: oe_debug_pub.add('error in Handle_Bulk_Mode_Per_Order ' || sqlerrm, 1);

Line 5081: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN

5077: END IF;
5078:
5079: -- MOAC check for Org_id
5080: l_org_id := MO_GLOBAL.get_current_org_id;
5081: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
5082: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
5083: OE_MSG_PUB.Add;
5084: RAISE FND_API.G_EXC_ERROR;
5085: END IF;

Line 5084: RAISE FND_API.G_EXC_ERROR;

5080: l_org_id := MO_GLOBAL.get_current_org_id;
5081: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
5082: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
5083: OE_MSG_PUB.Add;
5084: RAISE FND_API.G_EXC_ERROR;
5085: END IF;
5086:
5087: SAVEPOINT om_ship_confirm;
5088:

Line 5089: x_return_status := FND_API.G_RET_STS_SUCCESS;

5085: END IF;
5086:
5087: SAVEPOINT om_ship_confirm;
5088:
5089: x_return_status := FND_API.G_RET_STS_SUCCESS;
5090:
5091: ---------- Create Freight Cost Records first --------
5092: IF p_line_adj_rec.line_id.COUNT > 0 THEN
5093:

Line 5177: IF x_return_status = FND_API.G_RET_STS_ERROR

5173: ,x_return_status => x_return_status );
5174:
5175: END IF;
5176:
5177: IF x_return_status = FND_API.G_RET_STS_ERROR
5178: THEN
5179: RAISE FND_API.G_EXC_ERROR;
5180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5181: x_return_status is NULL THEN

Line 5179: RAISE FND_API.G_EXC_ERROR;

5175: END IF;
5176:
5177: IF x_return_status = FND_API.G_RET_STS_ERROR
5178: THEN
5179: RAISE FND_API.G_EXC_ERROR;
5180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5181: x_return_status is NULL THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: END IF;

Line 5180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

5176:
5177: IF x_return_status = FND_API.G_RET_STS_ERROR
5178: THEN
5179: RAISE FND_API.G_EXC_ERROR;
5180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5181: x_return_status is NULL THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: END IF;
5184:

Line 5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5178: THEN
5179: RAISE FND_API.G_EXC_ERROR;
5180: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5181: x_return_status is NULL THEN
5182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5183: END IF;
5184:
5185: IF l_debug_level > 0 THEN
5186: oe_debug_pub.add('leaving Ship_Confirm_New', 2);

Line 5191: WHEN FND_API.G_EXC_ERROR THEN

5187: END IF;
5188:
5189: EXCEPTION
5190:
5191: WHEN FND_API.G_EXC_ERROR THEN
5192: IF l_debug_level > 0 THEN
5193: oe_debug_pub.add('ship_confirm_new EXC ERROR: '||SQLERRM,1);
5194: END IF;
5195:

Line 5200: x_return_status := FND_API.G_RET_STS_ERROR;

5196: --Bug 14125646 clear the delayed requests
5197: OE_Delayed_Requests_PVT.Clear_Request
5198: ( x_return_status => l_return_status);
5199:
5200: x_return_status := FND_API.G_RET_STS_ERROR;
5201:
5202: OE_MSG_PUB.Count_And_Get
5203: (p_count => x_msg_count
5204: ,p_data => x_msg_data);

Line 5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5207: oe_debug_pub.add('rollback to om_ship_confirm',1);
5208: END IF;
5209: ROLLBACK to om_ship_confirm;
5210:
5211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5212: IF l_debug_level > 0 THEN
5213: oe_debug_pub.add('ship_confirm_new UNEXPECTED ERROR : '||SQLERRM, 1);
5214: END IF;
5215:

Line 5220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

5216: --Bug 14125646 clear the delayed requests
5217: OE_Delayed_Requests_PVT.Clear_Request
5218: ( x_return_status => l_return_status);
5219:
5220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5221:
5222: OE_MSG_PUB.Count_And_Get
5223: (p_count => x_msg_count
5224: ,p_data => x_msg_data);

Line 5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5247: OE_MSG_PUB.Count_And_Get
5248: (p_count => x_msg_count
5249: ,p_data => x_msg_data);
5250:
5251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5252:
5253: IF l_debug_level > 0 THEN
5254: oe_debug_pub.add('rollback to om_ship_confirm : ',1);
5255: END IF;

Line 5301: l_return_status := FND_API.G_RET_STS_SUCCESS;

5297: IF l_debug_level > 0 THEN
5298: oe_debug_pub.add('entering Call_Notification_Framework ' || p_caller, 3);
5299: END IF;
5300:
5301: l_return_status := FND_API.G_RET_STS_SUCCESS;
5302:
5303: -- Commented for bug 8799963
5304: /*IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'N' THEN
5305: IF l_debug_level > 0 THEN

Line 5419: IF l_return_status = FND_API.G_RET_STS_ERROR

5415: IF l_debug_level > 0 THEN
5416: oe_debug_pub.add(J || ' UPDATE_GLOBAL ret sts: ' || l_retuRN_STATUS);
5417: END IF;
5418:
5419: IF l_return_status = FND_API.G_RET_STS_ERROR
5420: THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5423: l_return_status is NULL THEN

Line 5421: RAISE FND_API.G_EXC_ERROR;

5417: END IF;
5418:
5419: IF l_return_status = FND_API.G_RET_STS_ERROR
5420: THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5423: l_return_status is NULL THEN
5424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5425: END IF;

Line 5422: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

5418:
5419: IF l_return_status = FND_API.G_RET_STS_ERROR
5420: THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5423: l_return_status is NULL THEN
5424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5425: END IF;
5426:

Line 5424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5420: THEN
5421: RAISE FND_API.G_EXC_ERROR;
5422: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5423: l_return_status is NULL THEN
5424: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5425: END IF;
5426:
5427: IF J IS NOT NULL THEN
5428:

Line 5522: x_return_status := FND_API.G_RET_STS_SUCCESS;

5518: l_return_status VARCHAR2(256);
5519:
5520: BEGIN
5521: x_result_out := 'S';
5522: x_return_status := FND_API.G_RET_STS_SUCCESS;
5523:
5524: --query row
5525: OE_Line_Util.Query_Row
5526: (

Line 5534: -- RAISE FND_API.G_EXC_ERROR;

5530: --check line status
5531: --IF (l_line_rec.flow_status_code <> 'AWAITING_SHIPPING')
5532: --THEN
5533: -- x_result_out := 'F';
5534: -- RAISE FND_API.G_EXC_ERROR;
5535: --END IF;
5536: l_count := 0;
5537: select Count (1)
5538: INTO l_count

Line 5550: RAISE FND_API.G_EXC_ERROR;

5546:
5547: IF (l_count < 1)
5548: THEN
5549: x_result_out := 'W';
5550: RAISE FND_API.G_EXC_ERROR;
5551: END IF;
5552:
5553: OE_Shipping_Integration_PVT.Check_Shipment_Line
5554: (

Line 5566: RAISE FND_API.G_EXC_ERROR;

5562: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5563: )
5564: THEN
5565: x_result_out := 'T';
5566: RAISE FND_API.G_EXC_ERROR;
5567: END IF;
5568: l_count := 0;
5569: SELECT Count(1)
5570: INTO l_count

Line 5578: RAISE FND_API.G_EXC_ERROR;

5574:
5575: IF (l_count > 0 )
5576: THEN
5577: x_result_out := 'D';
5578: RAISE FND_API.G_EXC_ERROR;
5579: END IF;
5580:
5581: --prepare call to shipping API
5582: l_update_lines_tbl(1).entity_id := p_line_id;

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

5579: END IF;
5580:
5581: --prepare call to shipping API
5582: l_update_lines_tbl(1).entity_id := p_line_id;
5583: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5584: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5585: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5586: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5587:

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

5580:
5581: --prepare call to shipping API
5582: l_update_lines_tbl(1).entity_id := p_line_id;
5583: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5584: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5585: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5586: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5587:
5588: --Step 4 : Call shipping integration

Line 5585: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;

5581: --prepare call to shipping API
5582: l_update_lines_tbl(1).entity_id := p_line_id;
5583: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5584: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5585: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5586: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5587:
5588: --Step 4 : Call shipping integration
5589: OE_Shipping_Integration_PVT.Update_Shipping_From_OE

Line 5595: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

5591: p_update_lines_tbl => l_update_lines_tbl,
5592: x_return_status => l_return_status
5593: );
5594:
5595: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5596: THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: END IF;
5599:

Line 5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5593: );
5594:
5595: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5596: THEN
5597: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5598: END IF;
5599:
5600:
5601: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 5604: ,p_delete => FND_API.G_TRUE

5600:
5601: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
5602: (
5603: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
5604: ,p_delete => FND_API.G_TRUE
5605: ,x_return_status => l_return_status
5606: );
5607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5608: THEN

Line 5607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

5603: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
5604: ,p_delete => FND_API.G_TRUE
5605: ,x_return_status => l_return_status
5606: );
5607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5608: THEN
5609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5610: END IF;
5611: EXCEPTION

Line 5609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5605: ,x_return_status => l_return_status
5606: );
5607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5608: THEN
5609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5610: END IF;
5611: EXCEPTION
5612: WHEN FND_API.G_EXC_ERROR THEN
5613: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5612: WHEN FND_API.G_EXC_ERROR THEN

5608: THEN
5609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5610: END IF;
5611: EXCEPTION
5612: WHEN FND_API.G_EXC_ERROR THEN
5613: x_return_status := FND_API.G_RET_STS_ERROR;
5614: OE_MSG_PUB.Count_And_Get
5615: ( p_count => x_msg_count
5616: , p_data => x_msg_data

Line 5613: x_return_status := FND_API.G_RET_STS_ERROR;

5609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5610: END IF;
5611: EXCEPTION
5612: WHEN FND_API.G_EXC_ERROR THEN
5613: x_return_status := FND_API.G_RET_STS_ERROR;
5614: OE_MSG_PUB.Count_And_Get
5615: ( p_count => x_msg_count
5616: , p_data => x_msg_data
5617: );

Line 5620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5616: , p_data => x_msg_data
5617: );
5618:
5619: WHEN OTHERS THEN
5620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5621: x_result_out := 'U';
5622: OE_MSG_PUB.Count_And_Get
5623: ( p_count => x_msg_count
5624: , p_data => x_msg_data