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

APPS.OE_SHIP_CONFIRMATION_PUB dependencies on FND_API

Line 420: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
418: END IF;
419:
420: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;
418: END IF;
419:
420: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:

Line 422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

418: END IF;
419:
420: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: << END_REQ_QTY >>

Line 423: RAISE FND_API.G_EXC_ERROR;

419:
420: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
423: RAISE FND_API.G_EXC_ERROR;
424: END IF;
425:
426: << END_REQ_QTY >>
427: NULL;

Line 544: RAISE FND_API.G_EXC_ERROR;

540: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
541: IF l_debug_level > 0 THEN
542: OE_DEBUG_PUB.Add('Unable to lock the line/parent',3);
543: END IF;
544: RAISE FND_API.G_EXC_ERROR;
545:
546:
547: WHEN OTHERS THEN
548: IF l_debug_level > 0 THEN

Line 552: RAISE FND_API.G_EXC_ERROR;

548: IF l_debug_level > 0 THEN
549: OE_DEBUG_PUB.Add('Unable to process ship confirm line:'||
550: sqlerrm,3);
551: END IF;
552: RAISE FND_API.G_EXC_ERROR;
553:
554: END;
555: --bug3549422 ends
556:

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

553:
554: END;
555: --bug3549422 ends
556:
557: IF p_line_tbl(J).ship_tolerance_below = FND_API.G_MISS_NUM THEN
558:
559: l_ship_tolerance_below_upd := l_ship_tolerance_below;
560:
561: ELSE

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

563: l_ship_tolerance_below_upd := p_line_tbl(J).ship_tolerance_below;
564:
565: END IF;
566:
567: IF p_line_tbl(J).over_ship_reason_code = FND_API.G_MISS_CHAR THEN
568:
569: l_over_ship_reason_code_upd := l_over_ship_reason_code;
570:
571: ELSE

Line 891: l_ship_set_id <> FND_API.G_MISS_NUM) THEN

887:
888: -- Add to the ship confirm table
889:
890: IF (l_ship_set_id IS NOT NULL AND
891: l_ship_set_id <> FND_API.G_MISS_NUM) THEN
892: IF l_debug_level > 0 THEN
893: oe_debug_pub.add( 'SHIP SET SHIPPED : '||L_SHIP_SET_ID , 3 ) ;
894: END IF;
895:

Line 911: l_ato_line_id <> FND_API.G_MISS_NUM) AND

907:
908: END IF;
909:
910: ELSIF (l_ato_line_id IS NOT NULL AND
911: l_ato_line_id <> FND_API.G_MISS_NUM) AND
912: l_item_type_code = Oe_Globals.G_ITEM_CONFIG AND
913: l_ato_line_id = l_top_model_line_id THEN
914:
915: IF l_debug_level > 0 THEN

Line 935: l_top_model_line_id <> FND_API.G_MISS_NUM) AND

931:
932: END IF;
933:
934: ELSIF (l_top_model_line_id IS NOT NULL AND
935: l_top_model_line_id <> FND_API.G_MISS_NUM) AND
936: nvl(l_model_remnant_flag,'N') = 'N' THEN
937:
938: IF l_debug_level > 0 THEN
939: oe_debug_pub.add( 'PTO/KIT SHIPPED : '||L_TOP_MODEL_LINE_ID , 3 ) ;

Line 1143: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1139: IF l_debug_level > 0 THEN
1140: oe_debug_pub.add( 'RETRUN STATUS FROM PROCESS_SHIP_CONFIRM : '||L_RETURN_STATUS , 3 ) ;
1141: END IF;
1142:
1143: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;

Line 1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1140: oe_debug_pub.add( 'RETRUN STATUS FROM PROCESS_SHIP_CONFIRM : '||L_RETURN_STATUS , 3 ) ;
1141: END IF;
1142:
1143: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:

Line 1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1141: END IF;
1142:
1143: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:
1149: l_ship_confirm_index := l_ship_confirm_tbl.NEXT(l_ship_confirm_index);

Line 1146: RAISE FND_API.G_EXC_ERROR;

1142:
1143: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1144: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1145: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:
1149: l_ship_confirm_index := l_ship_confirm_tbl.NEXT(l_ship_confirm_index);
1150:

Line 1180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1176: oe_debug_pub.add('UPDATE_GLOBAL RET_STATUS FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_RETURN_STATUS , 1 ) ;
1177: oe_debug_pub.add('UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
1178: END IF;
1179:
1180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1181: RAISE FND_API.G_EXC_ERROR;
1182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;

Line 1181: RAISE FND_API.G_EXC_ERROR;

1177: oe_debug_pub.add('UPDATE_GLOBAL INDEX FOR LINE_ID '||L_LINE_TBL ( L_LOOP_INDEX ) .LINE_ID ||' IS: ' || L_NOTIFY_INDEX , 1 ) ;
1178: END IF;
1179:
1180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1181: RAISE FND_API.G_EXC_ERROR;
1182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185:

Line 1182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1178: END IF;
1179:
1180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1181: RAISE FND_API.G_EXC_ERROR;
1182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185:
1186: IF l_notify_index is not null then

Line 1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1179:
1180: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1181: RAISE FND_API.G_EXC_ERROR;
1182: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1183: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1184: END IF;
1185:
1186: IF l_notify_index is not null then
1187: -- modify Global Picture

Line 1244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1240: IF l_debug_level > 0 THEN
1241: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1242: END IF;
1243:
1244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;

Line 1245: RAISE FND_API.G_EXC_ERROR;

1241: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1242: END IF;
1243:
1244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:

Line 1246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1242: END IF;
1243:
1244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: ELSE /* pre-code H */

Line 1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1243:
1244: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1245: RAISE FND_API.G_EXC_ERROR;
1246: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249:
1250: ELSE /* pre-code H */
1251:

Line 1267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1263: IF l_debug_level > 0 THEN
1264: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1265: END IF;
1266:
1267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END IF;

Line 1268: RAISE FND_API.G_EXC_ERROR;

1264: oe_debug_pub.add( 'RETURNED FROM PROCESS REQUEST AND NOTIFY : '||L_RETURN_STATUS , 3 ) ;
1265: END IF;
1266:
1267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END IF;
1272:

Line 1269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1265: END IF;
1266:
1267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END IF;
1272:
1273: END IF; /* code set is pack H or higher */

Line 1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1266:
1267: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1268: RAISE FND_API.G_EXC_ERROR;
1269: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1270: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1271: END IF;
1272:
1273: END IF; /* code set is pack H or higher */
1274: /* jolin end*/

Line 1278: x_return_status := FND_API.G_RET_STS_SUCCESS;

1274: /* jolin end*/
1275:
1276: END IF; --IF p_line_tbl.COUNT > 0
1277:
1278: x_return_status := FND_API.G_RET_STS_SUCCESS;
1279:
1280: OE_MSG_PUB.Count_And_Get
1281: ( p_count => x_msg_count
1282: , p_data => x_msg_data

Line 1291: WHEN FND_API.G_EXC_ERROR THEN

1287: END IF;
1288:
1289: EXCEPTION
1290:
1291: WHEN FND_API.G_EXC_ERROR THEN
1292:
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add( 'EXC ERROR : '||SQLERRM , 1 ) ;
1295: END IF;

Line 1296: x_return_status := FND_API.G_RET_STS_ERROR;

1292:
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add( 'EXC ERROR : '||SQLERRM , 1 ) ;
1295: END IF;
1296: x_return_status := FND_API.G_RET_STS_ERROR;
1297:
1298: -- Get message count and data
1299:
1300: OE_MSG_PUB.Count_And_Get

Line 1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1301: ( p_count => x_msg_count
1302: , p_data => x_msg_data
1303: );
1304:
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1306:
1307: IF l_debug_level > 0 THEN
1308: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1309: END IF;

Line 1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1306:
1307: IF l_debug_level > 0 THEN
1308: oe_debug_pub.add( 'UNEXPECTED ERROR : '||SQLERRM , 1 ) ;
1309: END IF;
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1311:
1312: -- Get message count and data
1313:
1314: OE_MSG_PUB.Count_And_Get

Line 1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1335: OE_MSG_PUB.Count_And_Get
1336: ( p_count => x_msg_count
1337: , p_data => x_msg_data
1338: );
1339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1340:
1341: END Ship_Confirm;
1342:
1343: PROCEDURE Process_Requests

Line 1357: ,p_delete => FND_API.G_TRUE

1353: THEN
1354:
1355: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1356: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ
1357: ,p_delete => FND_API.G_TRUE
1358: ,x_return_status => l_return_status
1359: );
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1356: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ
1357: ,p_delete => FND_API.G_TRUE
1358: ,x_return_status => l_return_status
1359: );
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;

Line 1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1357: ,p_delete => FND_API.G_TRUE
1358: ,x_return_status => l_return_status
1359: );
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;
1365:

Line 1362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1358: ,x_return_status => l_return_status
1359: );
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;
1365:
1366: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1363: RAISE FND_API.G_EXC_ERROR;

1359: );
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1362: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;
1365:
1366: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1367: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att

Line 1368: ,p_delete => FND_API.G_TRUE

1364: END IF;
1365:
1366: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1367: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att
1368: ,p_delete => FND_API.G_TRUE
1369: ,x_return_status => l_return_status
1370: );
1371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1367: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att
1368: ,p_delete => FND_API.G_TRUE
1369: ,x_return_status => l_return_status
1370: );
1371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: ,p_delete => FND_API.G_TRUE
1369: ,x_return_status => l_return_status
1370: );
1371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:

Line 1373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1369: ,x_return_status => l_return_status
1370: );
1371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1374: RAISE FND_API.G_EXC_ERROR;

1370: );
1371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1378: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att

Line 1379: ,p_delete => FND_API.G_TRUE

1375: END IF;
1376:
1377: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1378: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att
1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1378: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att
1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;

Line 1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:

Line 1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1385: RAISE FND_API.G_EXC_ERROR;

1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1383: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1384: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1389: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc

Line 1390: ,p_delete => FND_API.G_TRUE

1386: END IF;
1387:
1388: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1389: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc
1390: ,p_delete => FND_API.G_TRUE
1391: ,x_return_status => l_return_status
1392: );
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1389: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc
1390: ,p_delete => FND_API.G_TRUE
1391: ,x_return_status => l_return_status
1392: );
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;

Line 1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1390: ,p_delete => FND_API.G_TRUE
1391: ,x_return_status => l_return_status
1392: );
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:

Line 1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1391: ,x_return_status => l_return_status
1392: );
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1396: RAISE FND_API.G_EXC_ERROR;

1392: );
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1400: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit

Line 1401: ,p_delete => FND_API.G_TRUE

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

Line 1404: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1406: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1407: RAISE FND_API.G_EXC_ERROR;

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

Line 1412: ,p_delete => FND_API.G_TRUE

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

Line 1415: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1417: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1418: RAISE FND_API.G_EXC_ERROR;

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

Line 1423: ,p_delete => FND_API.G_TRUE

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

Line 1426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1429: RAISE FND_API.G_EXC_ERROR;

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

Line 1434: ,p_delete => FND_API.G_TRUE

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

Line 1437: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1439: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1440: RAISE FND_API.G_EXC_ERROR;

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

Line 1445: ,p_delete => FND_API.G_TRUE

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

Line 1448: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1450: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1451: RAISE FND_API.G_EXC_ERROR;

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

Line 1456: ,p_delete => FND_API.G_TRUE

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

Line 1459: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1461: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1462: RAISE FND_API.G_EXC_ERROR;

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

Line 1467: ,p_delete => FND_API.G_TRUE

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

Line 1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1468: ,x_return_status => l_return_status
1469: );
1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;
1475:
1476: -- Execute all remaining delayed requests. This would execute

Line 1473: RAISE FND_API.G_EXC_ERROR;

1469: );
1470: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1472: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1473: RAISE FND_API.G_EXC_ERROR;
1474: END IF;
1475:
1476: -- Execute all remaining delayed requests. This would execute
1477: -- requests logged against entity G_ENTITY_HEADER and G_ENTITY_ALL

Line 1483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1481: );
1482:
1483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1486: RAISE FND_API.G_EXC_ERROR;
1487: END IF;
1488:
1489:

Line 1486: RAISE FND_API.G_EXC_ERROR;

1482:
1483: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1486: RAISE FND_API.G_EXC_ERROR;
1487: END IF;
1488:
1489:
1490: END IF; --End of requests processing

Line 1796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1792: IF l_debug_level > 0 THEN
1793: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
1794: END IF;
1795:
1796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1799: RAISE FND_API.G_EXC_ERROR;
1800: END IF;

Line 1797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1793: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
1794: END IF;
1795:
1796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1799: RAISE FND_API.G_EXC_ERROR;
1800: END IF;
1801:

Line 1798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1794: END IF;
1795:
1796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1799: RAISE FND_API.G_EXC_ERROR;
1800: END IF;
1801:
1802: ELSE

Line 1799: RAISE FND_API.G_EXC_ERROR;

1795:
1796: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1798: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1799: RAISE FND_API.G_EXC_ERROR;
1800: END IF;
1801:
1802: ELSE
1803: IF l_debug_level > 0 THEN

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

1925:
1926: -- IF p_opm_check = 'Y' AND -- INVCONV -- pete
1927:
1928: IF ( p_ship_line_rec.order_quantity_uom2(p_index) is NOT NULL
1929: and p_ship_line_rec.order_quantity_uom2(p_index) <> FND_API.G_MISS_CHAR )
1930: THEN
1931: oe_debug_pub.add('PAL here 2 index is '|| p_index, 3);
1932: IF p_ship_line_rec.order_quantity_uom(p_index)
1933: <> p_ship_line_rec.order_quantity_uom2(p_index) THEN

Line 2086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2082: IF l_debug_level > 0 THEN
2083: oe_debug_pub.add('local split line RET STS : '||L_RETURN_STATUS,3);
2084: END IF;
2085:
2086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;

Line 2087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2083: oe_debug_pub.add('local split line RET STS : '||L_RETURN_STATUS,3);
2084: END IF;
2085:
2086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091:

Line 2088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2084: END IF;
2085:
2086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091:
2092: oe_debug_pub.add('PAL here 10 index is '|| p_index, 3);

Line 2089: RAISE FND_API.G_EXC_ERROR;

2085:
2086: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2088: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2089: RAISE FND_API.G_EXC_ERROR;
2090: END IF;
2091:
2092: oe_debug_pub.add('PAL here 10 index is '|| p_index, 3);
2093: EXCEPTION

Line 2161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2157: IF l_debug_level > 0 THEN
2158: oe_debug_pub.add('RET STS FROM GET ACT RESULT: '||L_RETURN_STATUS , 3 ) ;
2159: END IF;
2160:
2161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2164: IF l_debug_level > 0 THEN
2165: oe_debug_pub.add('LINE IS NOT AT FULFILLMENT ACTIVITY ',3);

Line 2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2158: oe_debug_pub.add('RET STS FROM GET ACT RESULT: '||L_RETURN_STATUS , 3 ) ;
2159: END IF;
2160:
2161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2164: IF l_debug_level > 0 THEN
2165: oe_debug_pub.add('LINE IS NOT AT FULFILLMENT ACTIVITY ',3);
2166: END IF;

Line 2163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2159: END IF;
2160:
2161: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2162: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2163: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2164: IF l_debug_level > 0 THEN
2165: oe_debug_pub.add('LINE IS NOT AT FULFILLMENT ACTIVITY ',3);
2166: END IF;
2167: ELSE

Line 2180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2176: p_activity_id => l_activity_id,
2177: x_fulfillment_activity => l_fulfillment_activity,
2178: x_return_status => l_return_status);
2179:
2180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;

Line 2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2177: x_fulfillment_activity => l_fulfillment_activity,
2178: x_return_status => l_return_status);
2179:
2180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;
2185:

Line 2182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2178: x_return_status => l_return_status);
2179:
2180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;
2185:
2186: IF l_debug_level > 0 THEN

Line 2183: RAISE FND_API.G_EXC_ERROR;

2179:
2180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2183: RAISE FND_API.G_EXC_ERROR;
2184: END IF;
2185:
2186: IF l_debug_level > 0 THEN
2187: oe_debug_pub.add( 'FULFILLMENT ACT : '||L_FULFILLMENT_ACTIVITY , 3 ) ;

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

2188: END IF;
2189:
2190: IF (l_fulfillment_activity = 'NO_ACTIVITY' OR
2191: l_fulfillment_activity = 'SHIP_LINE') AND
2192: l_fulfillment_set_flag = FND_API.G_FALSE THEN -- bug 4176692
2193:
2194: l_fulfill_index := l_fulfill_index + 1;
2195: l_fulfill_tbl(l_fulfill_index) := OE_Order_PUB.G_MISS_LINE_REC;
2196: l_fulfill_tbl(l_fulfill_index).line_id := line_rec.line_id;

Line 2236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2232: p_fulfillment_type => 'No Activity',
2233: p_fulfillment_activity => 'NO_ACTIVITY',
2234: x_return_status => l_return_status);
2235:
2236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: END IF;

Line 2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2233: p_fulfillment_activity => 'NO_ACTIVITY',
2234: x_return_status => l_return_status);
2235:
2236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: END IF;
2241:

Line 2238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2234: x_return_status => l_return_status);
2235:
2236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: END IF;
2241:
2242: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count

Line 2239: RAISE FND_API.G_EXC_ERROR;

2235:
2236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2239: RAISE FND_API.G_EXC_ERROR;
2240: END IF;
2241:
2242: FOR l_fulfill_index IN 1 .. l_fulfill_tbl.count
2243: LOOP

Line 2258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2254: IF l_debug_level > 0 THEN
2255: oe_debug_pub.add('RET STS FROM FLOW STATUS API '||L_RETURN_STATUS,3);
2256: END IF;
2257:
2258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2260: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;

Line 2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2255: oe_debug_pub.add('RET STS FROM FLOW STATUS API '||L_RETURN_STATUS,3);
2256: END IF;
2257:
2258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2260: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;
2263:

Line 2260: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2256: END IF;
2257:
2258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2260: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;
2263:
2264: OE_Delayed_Requests_Pvt.Log_Request

Line 2261: RAISE FND_API.G_EXC_ERROR;

2257:
2258: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2260: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;
2263:
2264: OE_Delayed_Requests_Pvt.Log_Request
2265: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

Line 2285: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2281: IF l_debug_level > 0 THEN
2282: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
2283: END IF;
2284:
2285: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2287: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;

Line 2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2282: oe_debug_pub.add( 'RET STS FULFILL SERVICE '||L_RETURN_STATUS , 3 ) ;
2283: END IF;
2284:
2285: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2287: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;
2290:

Line 2287: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2283: END IF;
2284:
2285: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2287: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;
2290:
2291: END LOOP; -- fulfill table has rows.

Line 2288: RAISE FND_API.G_EXC_ERROR;

2284:
2285: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2287: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.G_EXC_ERROR;
2289: END IF;
2290:
2291: END LOOP; -- fulfill table has rows.
2292:

Line 2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2372: IF l_debug_level > 0 THEN
2373: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
2374: END IF;
2375:
2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;

Line 2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2373: oe_debug_pub.add( 'STATUS GET ACTIVITY RESULT : '||L_RETURN_STATUS , 3 ) ;
2374: END IF;
2375:
2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
2381: END IF;

Line 2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2374: END IF;
2375:
2376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2377: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2378: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2379: IF l_debug_level > 0 THEN
2380: oe_debug_pub.add( 'LINE IS NOT AT WAIT_FOR_CTO ACTIVITY' , 1 ) ;
2381: END IF;
2382: ELSE

Line 2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2399: p_param3 => 'WAIT_FOR_CTO',
2400: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2401: x_return_status => l_return_status);
2402:
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;

Line 2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2400: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2401: x_return_status => l_return_status);
2402:
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:

Line 2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2401: x_return_status => l_return_status);
2402:
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:
2409: IF l_debug_level > 0 THEN

Line 2406: RAISE FND_API.G_EXC_ERROR;

2402:
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2405: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2406: RAISE FND_API.G_EXC_ERROR;
2407: END IF;
2408:
2409: IF l_debug_level > 0 THEN
2410: oe_debug_pub.add('ato parent workflow progressed '

Line 2512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2508: p_param3 => 'SHIP_LINE',
2509: p_param4 => 'SHIP_CONFIRM',
2510: x_return_status => l_return_status);
2511:
2512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2515: RAISE FND_API.G_EXC_ERROR;
2516: END IF;

Line 2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2509: p_param4 => 'SHIP_CONFIRM',
2510: x_return_status => l_return_status);
2511:
2512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2515: RAISE FND_API.G_EXC_ERROR;
2516: END IF;
2517:

Line 2514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2510: x_return_status => l_return_status);
2511:
2512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2515: RAISE FND_API.G_EXC_ERROR;
2516: END IF;
2517:
2518: IF l_debug_level > 0 THEN

Line 2515: RAISE FND_API.G_EXC_ERROR;

2511:
2512: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2513: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2514: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2515: RAISE FND_API.G_EXC_ERROR;
2516: END IF;
2517:
2518: IF l_debug_level > 0 THEN
2519: oe_debug_pub.add('after wf completion delayed request', 3);

Line 2541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2537: p_flow_status_code => 'SHIPPED',
2538: x_return_status => l_return_status );
2539:
2540:
2541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2544: RAISE FND_API.G_EXC_ERROR;
2545: END IF;

Line 2542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2538: x_return_status => l_return_status );
2539:
2540:
2541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2544: RAISE FND_API.G_EXC_ERROR;
2545: END IF;
2546:

Line 2543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2539:
2540:
2541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2544: RAISE FND_API.G_EXC_ERROR;
2545: END IF;
2546:
2547: IF l_debug_level > 0 THEN

Line 2544: RAISE FND_API.G_EXC_ERROR;

2540:
2541: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2543: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2544: RAISE FND_API.G_EXC_ERROR;
2545: END IF;
2546:
2547: IF l_debug_level > 0 THEN
2548: oe_debug_pub.add('leaving Ship_Confirm_Line', 3);

Line 3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3286: IF l_debug_level > 0 THEN
3287: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
3288: END IF;
3289:
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;

Line 3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3287: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
3288: END IF;
3289:
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295:

Line 3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3288: END IF;
3289:
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295:
3296: END IF; -- if wdd has lines staged/shipped or not deleted

Line 3293: RAISE FND_API.G_EXC_ERROR;

3289:
3290: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3292: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3293: RAISE FND_API.G_EXC_ERROR;
3294: END IF;
3295:
3296: END IF; -- if wdd has lines staged/shipped or not deleted
3297:

Line 3491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3487: IF l_debug_level > 0 THEN
3488: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
3489: END IF;
3490:
3491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3494: RAISE FND_API.G_EXC_ERROR;
3495: END IF;

Line 3492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3488: oe_debug_pub.add('RET STS FROM PROCESS ORDER : '||L_RETURN_STATUS,3);
3489: END IF;
3490:
3491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3494: RAISE FND_API.G_EXC_ERROR;
3495: END IF;
3496: END IF;

Line 3493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3489: END IF;
3490:
3491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3494: RAISE FND_API.G_EXC_ERROR;
3495: END IF;
3496: END IF;
3497:

Line 3494: RAISE FND_API.G_EXC_ERROR;

3490:
3491: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3492: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3493: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3494: RAISE FND_API.G_EXC_ERROR;
3495: END IF;
3496: END IF;
3497:
3498: I := p_set_tbl.NEXT(I);

Line 3511: RAISE FND_API.G_EXC_ERROR;

3507: IF l_debug_level > 0 THEN
3508: OE_DEBUG_PUB.Add('Unable to lock the line',3);
3509: END IF;
3510: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3511: RAISE FND_API.G_EXC_ERROR;
3512:
3513: WHEN OTHERS THEN
3514: IF l_debug_level > 0 THEN
3515: oe_debug_pub.add('error in Remove_Lines_From_Shipset '|| sqlerrm,3);

Line 3566: x_return_status := FND_API.G_RET_STS_SUCCESS;

3562: IF l_debug_level > 0 THEN
3563: Oe_Debug_pub.Add('----------entering handle_nonbulk_mode', 3);
3564: END IF;
3565:
3566: x_return_status := FND_API.G_RET_STS_SUCCESS;
3567: IF l_debug_level > 0 THEN
3568: oe_debug_pub.ADD('request_line_rec line_id count: ' || p_requested_line_rec.line_id.COUNT, 3);
3569: END IF;
3570:

Line 3694: RAISE FND_API.G_EXC_ERROR;

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

Line 3696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3692: END IF;
3693: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
3694: RAISE FND_API.G_EXC_ERROR;
3695: WHEN others THEN
3696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3697: IF l_debug_level > 0 THEN
3698: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
3699: END IF;
3700: RAISE;

Line 3723: RAISE FND_API.G_EXC_ERROR;

3719: IF l_debug_level > 0 THEN
3720: OE_DEBUG_PUB.Add('Unable to lock the ship set :' || l_ship_set_id ,3);
3721: END IF;
3722: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');
3723: RAISE FND_API.G_EXC_ERROR;
3724: WHEN others THEN
3725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3726: IF l_debug_level > 0 THEN
3727: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);

Line 3725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3721: END IF;
3722: OE_Msg_Pub.Add_Text('Could not obtain Lock on Ship Set');
3723: RAISE FND_API.G_EXC_ERROR;
3724: WHEN others THEN
3725: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3726: IF l_debug_level > 0 THEN
3727: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
3728: END IF;
3729: RAISE;

Line 3753: RAISE FND_API.G_EXC_ERROR;

3749: IF l_debug_level > 0 THEN
3750: OE_DEBUG_PUB.Add('Unable to lock the arrival set :' || l_arrival_set_id ,3);
3751: END IF;
3752: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');
3753: RAISE FND_API.G_EXC_ERROR;
3754: WHEN others THEN
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3756: IF l_debug_level > 0 THEN
3757: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);

Line 3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3751: END IF;
3752: OE_Msg_Pub.Add_Text('Could not obtain Lock on Arrival Set');
3753: RAISE FND_API.G_EXC_ERROR;
3754: WHEN others THEN
3755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3756: IF l_debug_level > 0 THEN
3757: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
3758: END IF;
3759: RAISE;

Line 3795: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3791: IF l_debug_level > 0 THEN
3792: Oe_Debug_pub.Add('returning ...'|| x_return_status, 5);
3793: END IF;
3794:
3795: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3798: RAISE FND_API.G_EXC_ERROR;
3799: END IF;

Line 3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3792: Oe_Debug_pub.Add('returning ...'|| x_return_status, 5);
3793: END IF;
3794:
3795: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3798: RAISE FND_API.G_EXC_ERROR;
3799: END IF;
3800:

Line 3797: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3793: END IF;
3794:
3795: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3798: RAISE FND_API.G_EXC_ERROR;
3799: END IF;
3800:
3801: RETURN;

Line 3798: RAISE FND_API.G_EXC_ERROR;

3794:
3795: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3797: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3798: RAISE FND_API.G_EXC_ERROR;
3799: END IF;
3800:
3801: RETURN;
3802:

Line 4000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3996: IF l_debug_level > 0 THEN
3997: Oe_Debug_pub.Add('Ret sts After Delayed Req'||l_return_status, 4);
3998: END IF;
3999:
4000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4003: RAISE FND_API.G_EXC_ERROR;
4004: END IF;

Line 4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3997: Oe_Debug_pub.Add('Ret sts After Delayed Req'||l_return_status, 4);
3998: END IF;
3999:
4000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4003: RAISE FND_API.G_EXC_ERROR;
4004: END IF;
4005:

Line 4002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3998: END IF;
3999:
4000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4003: RAISE FND_API.G_EXC_ERROR;
4004: END IF;
4005:
4006: K := l_order_has_lines.NEXT(K);

Line 4003: RAISE FND_API.G_EXC_ERROR;

3999:
4000: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4002: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4003: RAISE FND_API.G_EXC_ERROR;
4004: END IF;
4005:
4006: K := l_order_has_lines.NEXT(K);
4007: END LOOP;

Line 4057: RAISE FND_API.G_EXC_ERROR;

4053: END IF;
4054: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4055: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4056: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4057: RAISE FND_API.G_EXC_ERROR;
4058:
4059: WHEN others THEN
4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4061: IF l_debug_level > 0 THEN

Line 4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4056: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4057: RAISE FND_API.G_EXC_ERROR;
4058:
4059: WHEN others THEN
4060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4061: IF l_debug_level > 0 THEN
4062: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
4063: END IF;
4064: OE_MSG_PUB.Save_API_Messages(); --bug 4516453

Line 4091: x_return_status := FND_API.G_RET_STS_SUCCESS;

4087: l_temp_index NUMBER;
4088: l_temp_header_id NUMBER;
4089:
4090: BEGIN
4091: x_return_status := FND_API.G_RET_STS_SUCCESS;
4092:
4093: l_temp_header_id := p_ship_line_rec.header_id(p_start_index);
4094: l_order_start_index := p_start_index;
4095:

Line 4233: x_return_status := FND_API.G_RET_STS_SUCCESS;

4229: oe_debug_pub.ADD('entering Handle_Bulk_Mode_Per_Order '
4230: || p_ship_line_rec.header_id(p_start_index),5);
4231: END IF;
4232:
4233: x_return_status := FND_API.G_RET_STS_SUCCESS;
4234:
4235: -- Setting the message context, bug 4516453
4236: OE_MSG_PUB.set_msg_context(
4237: p_entity_code => 'HEADER'

Line 4416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4412: IF l_debug_level > 0 THEN
4413: Oe_Debug_pub.Add('After price line for '||l_return_status, 1);
4414: END IF;
4415:
4416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;

Line 4417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4413: Oe_Debug_pub.Add('After price line for '||l_return_status, 1);
4414: END IF;
4415:
4416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;
4421:

Line 4418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4414: END IF;
4415:
4416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;
4421:
4422: J := l_order_has_lines.NEXT(J);

Line 4419: RAISE FND_API.G_EXC_ERROR;

4415:
4416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4418: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4419: RAISE FND_API.G_EXC_ERROR;
4420: END IF;
4421:
4422: J := l_order_has_lines.NEXT(J);
4423: END LOOP;

Line 4546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4542: itemkey => to_char(g_non_shippable_rec.ato_line_id(I)),
4543: activity => 'WAIT_FOR_CTO',
4544: result => OE_GLOBALS.G_WFR_COMPLETE);
4545:
4546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4549: RAISE FND_API.G_EXC_ERROR;
4550: END IF;

Line 4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4543: activity => 'WAIT_FOR_CTO',
4544: result => OE_GLOBALS.G_WFR_COMPLETE);
4545:
4546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4549: RAISE FND_API.G_EXC_ERROR;
4550: END IF;
4551:

Line 4548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

4544: result => OE_GLOBALS.G_WFR_COMPLETE);
4545:
4546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4549: RAISE FND_API.G_EXC_ERROR;
4550: END IF;
4551:
4552: END IF;

Line 4549: RAISE FND_API.G_EXC_ERROR;

4545:
4546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
4549: RAISE FND_API.G_EXC_ERROR;
4550: END IF;
4551:
4552: END IF;
4553:

Line 4653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

4649: ,x_return_status => l_return_status
4650: ,p_line_tbl => l_line_tbl
4651: ,p_old_line_tbl => l_old_line_tbl );
4652:
4653: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4654: x_return_status := l_return_status;
4655: IF l_debug_level > 0 THEN
4656: OE_DEBUG_PUB.Add ('Failure in Process_Requests_ANd_Notify',1);
4657: END IF;

Line 4675: RAISE FND_API.G_EXC_ERROR;

4671: END IF;
4672: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4673: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4674: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER');
4675: RAISE FND_API.G_EXC_ERROR;
4676:
4677: WHEN others THEN
4678: IF l_debug_level > 0 THEN
4679: oe_debug_pub.add('error in Handle_Bulk_Mode_Per_Order ' || sqlerrm, 1);

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

4715: END IF;
4716:
4717: -- MOAC check for Org_id
4718: l_org_id := MO_GLOBAL.get_current_org_id;
4719: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
4720: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
4721: OE_MSG_PUB.Add;
4722: RAISE FND_API.G_EXC_ERROR;
4723: END IF;

Line 4722: RAISE FND_API.G_EXC_ERROR;

4718: l_org_id := MO_GLOBAL.get_current_org_id;
4719: IF (l_org_id IS NULL OR l_org_id = FND_API.G_MISS_NUM) THEN
4720: FND_MESSAGE.set_name('FND','MO_ORG_REQUIRED');
4721: OE_MSG_PUB.Add;
4722: RAISE FND_API.G_EXC_ERROR;
4723: END IF;
4724:
4725: SAVEPOINT om_ship_confirm;
4726:

Line 4727: x_return_status := FND_API.G_RET_STS_SUCCESS;

4723: END IF;
4724:
4725: SAVEPOINT om_ship_confirm;
4726:
4727: x_return_status := FND_API.G_RET_STS_SUCCESS;
4728:
4729: ---------- Create Freight Cost Records first --------
4730: IF p_line_adj_rec.line_id.COUNT > 0 THEN
4731:

Line 4815: IF x_return_status = FND_API.G_RET_STS_ERROR

4811: ,x_return_status => x_return_status );
4812:
4813: END IF;
4814:
4815: IF x_return_status = FND_API.G_RET_STS_ERROR
4816: THEN
4817: RAISE FND_API.G_EXC_ERROR;
4818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
4819: x_return_status is NULL THEN

Line 4817: RAISE FND_API.G_EXC_ERROR;

4813: END IF;
4814:
4815: IF x_return_status = FND_API.G_RET_STS_ERROR
4816: THEN
4817: RAISE FND_API.G_EXC_ERROR;
4818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
4819: x_return_status is NULL THEN
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: END IF;

Line 4818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

4814:
4815: IF x_return_status = FND_API.G_RET_STS_ERROR
4816: THEN
4817: RAISE FND_API.G_EXC_ERROR;
4818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
4819: x_return_status is NULL THEN
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: END IF;
4822:

Line 4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4816: THEN
4817: RAISE FND_API.G_EXC_ERROR;
4818: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
4819: x_return_status is NULL THEN
4820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4821: END IF;
4822:
4823: IF l_debug_level > 0 THEN
4824: oe_debug_pub.add('leaving Ship_Confirm_New', 2);

Line 4829: WHEN FND_API.G_EXC_ERROR THEN

4825: END IF;
4826:
4827: EXCEPTION
4828:
4829: WHEN FND_API.G_EXC_ERROR THEN
4830: IF l_debug_level > 0 THEN
4831: oe_debug_pub.add('ship_confirm_new EXC ERROR: '||SQLERRM,1);
4832: END IF;
4833: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4833: x_return_status := FND_API.G_RET_STS_ERROR;

4829: WHEN FND_API.G_EXC_ERROR THEN
4830: IF l_debug_level > 0 THEN
4831: oe_debug_pub.add('ship_confirm_new EXC ERROR: '||SQLERRM,1);
4832: END IF;
4833: x_return_status := FND_API.G_RET_STS_ERROR;
4834:
4835: OE_MSG_PUB.Count_And_Get
4836: (p_count => x_msg_count
4837: ,p_data => x_msg_data);

Line 4844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4840: oe_debug_pub.add('rollback to om_ship_confirm',1);
4841: END IF;
4842: ROLLBACK to om_ship_confirm;
4843:
4844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4845: IF l_debug_level > 0 THEN
4846: oe_debug_pub.add('ship_confirm_new UNEXPECTED ERROR : '||SQLERRM, 1);
4847: END IF;
4848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4845: IF l_debug_level > 0 THEN
4846: oe_debug_pub.add('ship_confirm_new UNEXPECTED ERROR : '||SQLERRM, 1);
4847: END IF;
4848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4849:
4850: OE_MSG_PUB.Count_And_Get
4851: (p_count => x_msg_count
4852: ,p_data => x_msg_data);

Line 4875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4871: OE_MSG_PUB.Count_And_Get
4872: (p_count => x_msg_count
4873: ,p_data => x_msg_data);
4874:
4875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4876:
4877: IF l_debug_level > 0 THEN
4878: oe_debug_pub.add('rollback to om_ship_confirm : ',1);
4879: END IF;

Line 4925: l_return_status := FND_API.G_RET_STS_SUCCESS;

4921: IF l_debug_level > 0 THEN
4922: oe_debug_pub.add('entering Call_Notification_Framework ' || p_caller, 3);
4923: END IF;
4924:
4925: l_return_status := FND_API.G_RET_STS_SUCCESS;
4926:
4927: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'N' THEN
4928: IF l_debug_level > 0 THEN
4929: oe_debug_pub.add('returning from Call_Notification_Framework ', 3);

Line 5042: IF l_return_status = FND_API.G_RET_STS_ERROR

5038: IF l_debug_level > 0 THEN
5039: oe_debug_pub.add(J || ' UPDATE_GLOBAL ret sts: ' || l_retuRN_STATUS);
5040: END IF;
5041:
5042: IF l_return_status = FND_API.G_RET_STS_ERROR
5043: THEN
5044: RAISE FND_API.G_EXC_ERROR;
5045: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5046: l_return_status is NULL THEN

Line 5044: RAISE FND_API.G_EXC_ERROR;

5040: END IF;
5041:
5042: IF l_return_status = FND_API.G_RET_STS_ERROR
5043: THEN
5044: RAISE FND_API.G_EXC_ERROR;
5045: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5046: l_return_status is NULL THEN
5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5048: END IF;

Line 5045: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

5041:
5042: IF l_return_status = FND_API.G_RET_STS_ERROR
5043: THEN
5044: RAISE FND_API.G_EXC_ERROR;
5045: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5046: l_return_status is NULL THEN
5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5048: END IF;
5049:

Line 5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5043: THEN
5044: RAISE FND_API.G_EXC_ERROR;
5045: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
5046: l_return_status is NULL THEN
5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5048: END IF;
5049:
5050: IF J IS NOT NULL THEN
5051:

Line 5142: x_return_status := FND_API.G_RET_STS_SUCCESS;

5138: l_return_status VARCHAR2(256);
5139:
5140: BEGIN
5141: x_result_out := 'S';
5142: x_return_status := FND_API.G_RET_STS_SUCCESS;
5143:
5144: --query row
5145: OE_Line_Util.Query_Row
5146: (

Line 5154: -- RAISE FND_API.G_EXC_ERROR;

5150: --check line status
5151: --IF (l_line_rec.flow_status_code <> 'AWAITING_SHIPPING')
5152: --THEN
5153: -- x_result_out := 'F';
5154: -- RAISE FND_API.G_EXC_ERROR;
5155: --END IF;
5156: l_count := 0;
5157: select Count (1)
5158: INTO l_count

Line 5170: RAISE FND_API.G_EXC_ERROR;

5166:
5167: IF (l_count < 1)
5168: THEN
5169: x_result_out := 'W';
5170: RAISE FND_API.G_EXC_ERROR;
5171: END IF;
5172:
5173: OE_Shipping_Integration_PVT.Check_Shipment_Line
5174: (

Line 5186: RAISE FND_API.G_EXC_ERROR;

5182: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5183: )
5184: THEN
5185: x_result_out := 'T';
5186: RAISE FND_API.G_EXC_ERROR;
5187: END IF;
5188: l_count := 0;
5189: SELECT Count(1)
5190: INTO l_count

Line 5198: RAISE FND_API.G_EXC_ERROR;

5194:
5195: IF (l_count > 0 )
5196: THEN
5197: x_result_out := 'D';
5198: RAISE FND_API.G_EXC_ERROR;
5199: END IF;
5200:
5201: --prepare call to shipping API
5202: l_update_lines_tbl(1).entity_id := p_line_id;

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

5199: END IF;
5200:
5201: --prepare call to shipping API
5202: l_update_lines_tbl(1).entity_id := p_line_id;
5203: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5204: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5205: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5206: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5207:

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

5200:
5201: --prepare call to shipping API
5202: l_update_lines_tbl(1).entity_id := p_line_id;
5203: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5204: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5205: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5206: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5207:
5208: --Step 4 : Call shipping integration

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

5201: --prepare call to shipping API
5202: l_update_lines_tbl(1).entity_id := p_line_id;
5203: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5204: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5205: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5206: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5207:
5208: --Step 4 : Call shipping integration
5209: OE_Shipping_Integration_PVT.Update_Shipping_From_OE

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

5211: p_update_lines_tbl => l_update_lines_tbl,
5212: x_return_status => l_return_status
5213: );
5214:
5215: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5216: THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: END IF;
5219:

Line 5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5213: );
5214:
5215: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5216: THEN
5217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5218: END IF;
5219:
5220:
5221: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype

Line 5224: ,p_delete => FND_API.G_TRUE

5220:
5221: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
5222: (
5223: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
5224: ,p_delete => FND_API.G_TRUE
5225: ,x_return_status => l_return_status
5226: );
5227: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5228: THEN

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

5223: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
5224: ,p_delete => FND_API.G_TRUE
5225: ,x_return_status => l_return_status
5226: );
5227: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5228: THEN
5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231: EXCEPTION

Line 5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5225: ,x_return_status => l_return_status
5226: );
5227: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
5228: THEN
5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231: EXCEPTION
5232: WHEN FND_API.G_EXC_ERROR THEN
5233: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5232: WHEN FND_API.G_EXC_ERROR THEN

5228: THEN
5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231: EXCEPTION
5232: WHEN FND_API.G_EXC_ERROR THEN
5233: x_return_status := FND_API.G_RET_STS_ERROR;
5234: OE_MSG_PUB.Count_And_Get
5235: ( p_count => x_msg_count
5236: , p_data => x_msg_data

Line 5233: x_return_status := FND_API.G_RET_STS_ERROR;

5229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5230: END IF;
5231: EXCEPTION
5232: WHEN FND_API.G_EXC_ERROR THEN
5233: x_return_status := FND_API.G_RET_STS_ERROR;
5234: OE_MSG_PUB.Count_And_Get
5235: ( p_count => x_msg_count
5236: , p_data => x_msg_data
5237: );

Line 5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5236: , p_data => x_msg_data
5237: );
5238:
5239: WHEN OTHERS THEN
5240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5241: x_result_out := 'U';
5242: OE_MSG_PUB.Count_And_Get
5243: ( p_count => x_msg_count
5244: , p_data => x_msg_data