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.INV_RCV_STD_INSPECT_APIS dependencies on FND_API

Line 99: x_return_status := fnd_api.g_ret_sts_success;

95: l_reason_id number;--OPM Convergence
96: BEGIN
97:
98: --Initialize the return status
99: x_return_status := fnd_api.g_ret_sts_success;
100:
101: l_product_txn_id := p_product_transaction_id;
102:
103: --First create the MTLI record for the lot that was inspected

Line 149: IF x_return_status = fnd_api.g_ret_sts_error THEN

145: , p_hold_date => l_hold_date);--OPM Convergence
146:
147:
148:
149: IF x_return_status = fnd_api.g_ret_sts_error THEN
150: RAISE fnd_api.g_exc_error;
151: END IF;
152:
153: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 150: RAISE fnd_api.g_exc_error;

146:
147:
148:
149: IF x_return_status = fnd_api.g_ret_sts_error THEN
150: RAISE fnd_api.g_exc_error;
151: END IF;
152:
153: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
154: RAISE fnd_api.g_exc_unexpected_error;

Line 153: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

149: IF x_return_status = fnd_api.g_ret_sts_error THEN
150: RAISE fnd_api.g_exc_error;
151: END IF;
152:
153: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156:
157: IF (l_debug = 1) THEN

Line 154: RAISE fnd_api.g_exc_unexpected_error;

150: RAISE fnd_api.g_exc_error;
151: END IF;
152:
153: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
154: RAISE fnd_api.g_exc_unexpected_error;
155: END IF;
156:
157: IF (l_debug = 1) THEN
158: print_debug('process_lot_serial_intf 1.1: Created MTLI record for lot: txn if: ' || l_txn_if_id || ', serial_temp_id: ' ||

Line 211: IF x_return_status = fnd_api.g_ret_sts_error THEN

207: , p_product_code => l_prod_code
208: , p_att_exist => l_yes
209: , p_update_msn => l_no);
210:
211: IF x_return_status = fnd_api.g_ret_sts_error THEN
212: RAISE fnd_api.g_exc_error;
213: END IF;
214:
215: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 212: RAISE fnd_api.g_exc_error;

208: , p_att_exist => l_yes
209: , p_update_msn => l_no);
210:
211: IF x_return_status = fnd_api.g_ret_sts_error THEN
212: RAISE fnd_api.g_exc_error;
213: END IF;
214:
215: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
216: RAISE fnd_api.g_exc_unexpected_error;

Line 215: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

211: IF x_return_status = fnd_api.g_ret_sts_error THEN
212: RAISE fnd_api.g_exc_error;
213: END IF;
214:
215: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
216: RAISE fnd_api.g_exc_unexpected_error;
217: END IF;
218:
219: IF (l_debug = 1) THEN

Line 216: RAISE fnd_api.g_exc_unexpected_error;

212: RAISE fnd_api.g_exc_error;
213: END IF;
214:
215: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
216: RAISE fnd_api.g_exc_unexpected_error;
217: END IF;
218:
219: IF (l_debug = 1) THEN
220: print_debug('process_lot_serial_intf 1.2: Created MSNI record for serial: ' || p_serial_number || ' with txn_if_id: '

Line 226: WHEN fnd_api.g_exc_error THEN

222: END IF;
223: END IF; --END IF for a serial controlled item
224:
225: EXCEPTION
226: WHEN fnd_api.g_exc_error THEN
227: x_return_status := fnd_api.g_ret_sts_error;
228: -- Get message count and data
229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
230: WHEN fnd_api.g_exc_unexpected_error THEN

Line 227: x_return_status := fnd_api.g_ret_sts_error;

223: END IF; --END IF for a serial controlled item
224:
225: EXCEPTION
226: WHEN fnd_api.g_exc_error THEN
227: x_return_status := fnd_api.g_ret_sts_error;
228: -- Get message count and data
229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
230: WHEN fnd_api.g_exc_unexpected_error THEN
231: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 230: WHEN fnd_api.g_exc_unexpected_error THEN

226: WHEN fnd_api.g_exc_error THEN
227: x_return_status := fnd_api.g_ret_sts_error;
228: -- Get message count and data
229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
230: WHEN fnd_api.g_exc_unexpected_error THEN
231: x_return_status := fnd_api.g_ret_sts_unexp_error;
232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
233: WHEN OTHERS THEN
234: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 231: x_return_status := fnd_api.g_ret_sts_unexp_error;

227: x_return_status := fnd_api.g_ret_sts_error;
228: -- Get message count and data
229: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
230: WHEN fnd_api.g_exc_unexpected_error THEN
231: x_return_status := fnd_api.g_ret_sts_unexp_error;
232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
233: WHEN OTHERS THEN
234: x_return_status := fnd_api.g_ret_sts_unexp_error;
235: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 234: x_return_status := fnd_api.g_ret_sts_unexp_error;

230: WHEN fnd_api.g_exc_unexpected_error THEN
231: x_return_status := fnd_api.g_ret_sts_unexp_error;
232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
233: WHEN OTHERS THEN
234: x_return_status := fnd_api.g_ret_sts_unexp_error;
235: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
236: fnd_msg_pub.add_exc_msg(g_pkg_name, 'process_lot_serial_intf');
237: END IF;
238: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 487: x_return_status := fnd_api.g_ret_sts_success;

483: l_split_line_id NUMBER; --for debug
484: l_progress VARCHAR2(10) := '0';
485:
486: BEGIN
487: x_return_status := fnd_api.g_ret_sts_success;
488:
489: IF (l_debug = 1) THEN
490: print_debug('main_process: Just entering main_process', 4);
491: print_debug('p_inventory_item_id => '||p_inventory_item_id,4);

Line 521: IF x_return_status <> fnd_api.g_ret_sts_success THEN

517: , x_return_status => x_return_status
518: , x_error_code => x_msg_data
519: );
520:
521: IF x_return_status <> fnd_api.g_ret_sts_success THEN
522: RETURN;
523: END IF;
524:
525: SAVEPOINT inspect_main_sp;

Line 688: RAISE fnd_api.g_exc_error;

684: -- CHECK FOR ERROR HERE
685: IF l_remaining_mol_qty > 0 then
686: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
687: fnd_msg_pub.ADD;
688: RAISE fnd_api.g_exc_error;
689: END IF;
690: -- MOLCON
691: EXIT;
692: END IF;

Line 708: RAISE fnd_api.g_exc_error;

704: -- CHECK FOR ERROR HERE
705: IF l_remaining_mol_qty > 0 then
706: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
707: fnd_msg_pub.ADD;
708: RAISE fnd_api.g_exc_error;
709: END IF;
710: -- MOLCON
711: EXIT;
712: END IF;

Line 727: RAISE fnd_api.g_exc_error;

723: -- CHECK FOR ERROR HERE
724: IF l_remaining_mol_qty > 0 then
725: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
726: fnd_msg_pub.ADD;
727: RAISE fnd_api.g_exc_error;
728: END IF;
729: -- MOLCON
730: EXIT;
731: END IF;

Line 936: IF l_return_status = fnd_api.g_ret_sts_error THEN

932: IF (l_debug = 1) THEN
933: print_debug('main_process : Call to split_mo returns: ' || l_return_status, 4);
934: END IF;
935:
936: IF l_return_status = fnd_api.g_ret_sts_error THEN
937: RAISE fnd_api.g_exc_error;
938: END IF;
939:
940: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 937: RAISE fnd_api.g_exc_error;

933: print_debug('main_process : Call to split_mo returns: ' || l_return_status, 4);
934: END IF;
935:
936: IF l_return_status = fnd_api.g_ret_sts_error THEN
937: RAISE fnd_api.g_exc_error;
938: END IF;
939:
940: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
941: RAISE fnd_api.g_exc_unexpected_error;

Line 940: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

936: IF l_return_status = fnd_api.g_ret_sts_error THEN
937: RAISE fnd_api.g_exc_error;
938: END IF;
939:
940: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
941: RAISE fnd_api.g_exc_unexpected_error;
942: END IF;
943: l_new_mol_id := l_mo_splt_tb(1).line_id;
944: ELSE

Line 941: RAISE fnd_api.g_exc_unexpected_error;

937: RAISE fnd_api.g_exc_error;
938: END IF;
939:
940: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
941: RAISE fnd_api.g_exc_unexpected_error;
942: END IF;
943: l_new_mol_id := l_mo_splt_tb(1).line_id;
944: ELSE
945: l_new_mol_id := l_mol_line_id;

Line 1057: IF l_return_status = fnd_api.g_ret_sts_error THEN

1053: , p_mmtt_temp_id => l_mmtt_ids(i)
1054: , p_sec_uom => l_sec_uom --OPM Convergence
1055: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
1056:
1057: IF l_return_status = fnd_api.g_ret_sts_error THEN
1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060:
1061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1058: RAISE fnd_api.g_exc_error;

1054: , p_sec_uom => l_sec_uom --OPM Convergence
1055: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
1056:
1057: IF l_return_status = fnd_api.g_ret_sts_error THEN
1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060:
1061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1062: RAISE fnd_api.g_exc_unexpected_error;

Line 1061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1057: IF l_return_status = fnd_api.g_ret_sts_error THEN
1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060:
1061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064:
1065: /* FP-J Lot/Serial Support Enhancement

Line 1062: RAISE fnd_api.g_exc_unexpected_error;

1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060:
1061: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1062: RAISE fnd_api.g_exc_unexpected_error;
1063: END IF;
1064:
1065: /* FP-J Lot/Serial Support Enhancement
1066: * Process the lot numbers and serial numbers corresponding to the RTI

Line 1109: IF l_return_status = fnd_api.g_ret_sts_error THEN

1105: IF (l_debug = 1) THEN
1106: print_debug('main_process: process_lot_serial_intf returns: ' || l_return_status, 4);
1107: END IF;
1108:
1109: IF l_return_status = fnd_api.g_ret_sts_error THEN
1110: RAISE fnd_api.g_exc_error;
1111: END IF;
1112:
1113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1110: RAISE fnd_api.g_exc_error;

1106: print_debug('main_process: process_lot_serial_intf returns: ' || l_return_status, 4);
1107: END IF;
1108:
1109: IF l_return_status = fnd_api.g_ret_sts_error THEN
1110: RAISE fnd_api.g_exc_error;
1111: END IF;
1112:
1113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1114: RAISE fnd_api.g_exc_unexpected_error;

Line 1113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1109: IF l_return_status = fnd_api.g_ret_sts_error THEN
1110: RAISE fnd_api.g_exc_error;
1111: END IF;
1112:
1113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1114: RAISE fnd_api.g_exc_unexpected_error;
1115: END IF;
1116: END IF; --END IF check lot and serial controls
1117: END LOOP; -- End MMTT Loop

Line 1114: RAISE fnd_api.g_exc_unexpected_error;

1110: RAISE fnd_api.g_exc_error;
1111: END IF;
1112:
1113: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1114: RAISE fnd_api.g_exc_unexpected_error;
1115: END IF;
1116: END IF; --END IF check lot and serial controls
1117: END LOOP; -- End MMTT Loop
1118:

Line 1127: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1123: , x_msg_data => x_msg_data
1124: , p_org_id => l_organization_id
1125: , p_mo_line_id => l_new_mol_id);
1126:
1127: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1128: IF (l_debug = 1) THEN
1129: print_debug(' Error in Activate_Plan_For_Load ' || x_msg_data, 1);
1130: END IF;
1131: RAISE fnd_api.g_exc_error;

Line 1131: RAISE fnd_api.g_exc_error;

1127: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1128: IF (l_debug = 1) THEN
1129: print_debug(' Error in Activate_Plan_For_Load ' || x_msg_data, 1);
1130: END IF;
1131: RAISE fnd_api.g_exc_error;
1132: ELSE
1133: IF (l_debug = 1) THEN
1134: print_debug('Successfully called Activate_Plan_For_Load for ' || l_rec_count || ' row(s)', 9);
1135: END IF;

Line 1154: -- RAISE fnd_api.g_exc_error;

1150: -- MOLCON COMMENTED THIS CALL HERE
1151: -- THIS HAS TO BE TRACKED ABOVE
1152: -- fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
1153: -- fnd_msg_pub.ADD;
1154: -- RAISE fnd_api.g_exc_error;
1155:
1156: END IF; --END IF IF (l_rtv_qty > 0)
1157: END LOOP;
1158:

Line 1178: RAISE fnd_api.g_exc_error;

1174: IF (l_remaining_qty > 0) THEN
1175: IF (l_debug = 1) THEN
1176: print_debug('main_process: No more MOL, but remaining qty still exists', 4);
1177: END IF;
1178: RAISE fnd_api.g_exc_error;
1179: END IF;
1180:
1181: EXCEPTION
1182: WHEN fnd_api.g_exc_error THEN

Line 1182: WHEN fnd_api.g_exc_error THEN

1178: RAISE fnd_api.g_exc_error;
1179: END IF;
1180:
1181: EXCEPTION
1182: WHEN fnd_api.g_exc_error THEN
1183: IF (l_debug = 1) THEN
1184: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
1185: END IF;
1186:

Line 1188: x_return_status := fnd_api.g_ret_sts_error;

1184: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
1185: END IF;
1186:
1187: ROLLBACK TO inspect_main_sp;
1188: x_return_status := fnd_api.g_ret_sts_error;
1189: -- Get message count and data
1190: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1191:
1192: IF (mol_cursor%ISOPEN) THEN

Line 1208: WHEN fnd_api.g_exc_unexpected_error THEN

1204: IF (rtv_serial_cursor%isopen) THEN
1205: CLOSE rtv_serial_cursor;
1206: END IF;
1207:
1208: WHEN fnd_api.g_exc_unexpected_error THEN
1209: IF (l_debug = 1) THEN
1210: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
1211: END IF;
1212:

Line 1214: x_return_status := fnd_api.g_ret_sts_unexp_error;

1210: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
1211: END IF;
1212:
1213: ROLLBACK TO inspect_main_sp;
1214: x_return_status := fnd_api.g_ret_sts_unexp_error;
1215: -- Get message count and data
1216: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1217:
1218: IF (mol_cursor%ISOPEN) THEN

Line 1240: x_return_status := fnd_api.g_ret_sts_unexp_error;

1236: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
1237: END IF;
1238:
1239: ROLLBACK TO inspect_main_sp;
1240: x_return_status := fnd_api.g_ret_sts_unexp_error;
1241:
1242: --
1243: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1244: fnd_msg_pub.add_exc_msg(g_pkg_name, 'main_process');

Line 1323: x_return_status := fnd_api.g_ret_sts_success;

1319: l_lot_number varchar2(80);
1320:
1321: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1322: begin
1323: x_return_status := fnd_api.g_ret_sts_success;
1324:
1325: savepoint process_sl_sp;
1326:
1327: --

Line 1415: IF l_return_status = fnd_api.g_ret_sts_error THEN

1411: , p_attribute13 => p_attribute13
1412: , p_attribute14 => p_attribute14
1413: , p_attribute15 => p_attribute15);
1414:
1415: IF l_return_status = fnd_api.g_ret_sts_error THEN
1416: RAISE fnd_api.g_exc_error;
1417: END IF ;
1418:
1419: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1416: RAISE fnd_api.g_exc_error;

1412: , p_attribute14 => p_attribute14
1413: , p_attribute15 => p_attribute15);
1414:
1415: IF l_return_status = fnd_api.g_ret_sts_error THEN
1416: RAISE fnd_api.g_exc_error;
1417: END IF ;
1418:
1419: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;

Line 1419: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1415: IF l_return_status = fnd_api.g_ret_sts_error THEN
1416: RAISE fnd_api.g_exc_error;
1417: END IF ;
1418:
1419: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;
1422:
1423: END LOOP;

Line 1420: RAISE fnd_api.g_exc_unexpected_error;

1416: RAISE fnd_api.g_exc_error;
1417: END IF ;
1418:
1419: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;
1422:
1423: END LOOP;
1424:

Line 1426: when fnd_api.g_exc_error THEN

1422:
1423: END LOOP;
1424:
1425: exception
1426: when fnd_api.g_exc_error THEN
1427: rollback to process_sl_sp;
1428:
1429: x_return_status := fnd_api.g_ret_sts_error;
1430:

Line 1429: x_return_status := fnd_api.g_ret_sts_error;

1425: exception
1426: when fnd_api.g_exc_error THEN
1427: rollback to process_sl_sp;
1428:
1429: x_return_status := fnd_api.g_ret_sts_error;
1430:
1431: -- Get message count and data
1432: fnd_msg_pub.count_and_get
1433: ( p_count => x_msg_count

Line 1437: when fnd_api.g_exc_unexpected_error THEN

1433: ( p_count => x_msg_count
1434: , p_data => x_msg_data
1435: );
1436:
1437: when fnd_api.g_exc_unexpected_error THEN
1438: rollback to process_sl_sp;
1439:
1440: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1441:

Line 1440: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1436:
1437: when fnd_api.g_exc_unexpected_error THEN
1438: rollback to process_sl_sp;
1439:
1440: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1441:
1442: -- Get message count and data
1443: fnd_msg_pub.count_and_get
1444: ( p_count => x_msg_count

Line 1451: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1447:
1448: when others THEN
1449: rollback to process_sl_sp;
1450:
1451: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1452: --
1453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1454: THEN
1455: fnd_msg_pub.add_exc_msg

Line 1613: x_return_status := fnd_api.g_ret_sts_success;

1609: and rt.routing_header_id = g_inspection_routing;
1610:
1611: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1612: begin
1613: x_return_status := fnd_api.g_ret_sts_success;
1614:
1615: -- dbms_output.put_line('main_process_po: Just entering main_process_po');
1616:
1617: --First check if the transaction date satisfies the validation.

Line 1636: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1632: , x_return_status => x_return_status
1633: , x_error_code => x_msg_data
1634: );
1635:
1636: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1637: RETURN;
1638: END IF;
1639:
1640: savepoint inspect_main_po_sp;

Line 1802: IF l_return_status = fnd_api.g_ret_sts_error THEN

1798: , p_qa_collection_id => l_qa_collection_id
1799: , p_sec_uom => l_sec_uom --OPM Convergence
1800: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
1801:
1802: IF l_return_status = fnd_api.g_ret_sts_error THEN
1803: RAISE fnd_api.g_exc_error;
1804: END IF ;
1805:
1806: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1803: RAISE fnd_api.g_exc_error;

1799: , p_sec_uom => l_sec_uom --OPM Convergence
1800: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
1801:
1802: IF l_return_status = fnd_api.g_ret_sts_error THEN
1803: RAISE fnd_api.g_exc_error;
1804: END IF ;
1805:
1806: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1807: RAISE fnd_api.g_exc_unexpected_error;

Line 1806: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1802: IF l_return_status = fnd_api.g_ret_sts_error THEN
1803: RAISE fnd_api.g_exc_error;
1804: END IF ;
1805:
1806: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1807: RAISE fnd_api.g_exc_unexpected_error;
1808: END IF;
1809:
1810: -- dbms_output.put_line('main_process_po: Successful insert_inspect_rec_rti');

Line 1807: RAISE fnd_api.g_exc_unexpected_error;

1803: RAISE fnd_api.g_exc_error;
1804: END IF ;
1805:
1806: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1807: RAISE fnd_api.g_exc_unexpected_error;
1808: END IF;
1809:
1810: -- dbms_output.put_line('main_process_po: Successful insert_inspect_rec_rti');
1811:

Line 1820: RAISE FND_API.G_EXC_ERROR;

1816:
1817: IF l_remaining_qty > 0 THEN
1818: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
1819: FND_MSG_PUB.Add;
1820: RAISE FND_API.G_EXC_ERROR;
1821: END IF;
1822:
1823: close rtv_cursor;
1824:

Line 1826: when fnd_api.g_exc_error THEN

1822:
1823: close rtv_cursor;
1824:
1825: exception
1826: when fnd_api.g_exc_error THEN
1827: rollback to inspect_main_po_sp;
1828:
1829: x_return_status := fnd_api.g_ret_sts_error;
1830:

Line 1829: x_return_status := fnd_api.g_ret_sts_error;

1825: exception
1826: when fnd_api.g_exc_error THEN
1827: rollback to inspect_main_po_sp;
1828:
1829: x_return_status := fnd_api.g_ret_sts_error;
1830:
1831: -- Get message count and data
1832: fnd_msg_pub.count_and_get
1833: ( p_count => x_msg_count

Line 1841: when fnd_api.g_exc_unexpected_error THEN

1837: IF (rtv_cursor%isopen) THEN
1838: CLOSE rtv_cursor;
1839: END IF;
1840:
1841: when fnd_api.g_exc_unexpected_error THEN
1842: rollback to inspect_main_po_sp;
1843:
1844: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1845:

Line 1844: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1840:
1841: when fnd_api.g_exc_unexpected_error THEN
1842: rollback to inspect_main_po_sp;
1843:
1844: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1845:
1846: -- Get message count and data
1847: fnd_msg_pub.count_and_get
1848: ( p_count => x_msg_count

Line 1859: x_return_status := fnd_api.g_ret_sts_unexp_error ;

1855:
1856: when others THEN
1857: rollback to inspect_main_po_sp;
1858:
1859: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1860: --
1861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1862: THEN
1863: fnd_msg_pub.add_exc_msg

Line 2028: x_return_status := fnd_api.g_ret_sts_success;

2024: and rt.transaction_type <> 'UNORDERED'
2025: and rt.routing_header_id = g_inspection_routing;
2026: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2027: begin
2028: x_return_status := fnd_api.g_ret_sts_success;
2029:
2030: -- dbms_output.put_line('main_process_intransit: Just entering main_process_intransit');
2031:
2032: --First check if the transaction date satisfies the validation.

Line 2051: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2047: , x_return_status => x_return_status
2048: , x_error_code => x_msg_data
2049: );
2050:
2051: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2052: RETURN;
2053: END IF;
2054:
2055: savepoint inspect_main_intransit_sp;

Line 2218: IF l_return_status = fnd_api.g_ret_sts_error THEN

2214: , p_qa_collection_id => l_qa_collection_id
2215: , p_sec_uom => l_sec_uom --OPM Convergence
2216: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
2217:
2218: IF l_return_status = fnd_api.g_ret_sts_error THEN
2219: RAISE fnd_api.g_exc_error;
2220: END IF ;
2221:
2222: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2219: RAISE fnd_api.g_exc_error;

2215: , p_sec_uom => l_sec_uom --OPM Convergence
2216: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
2217:
2218: IF l_return_status = fnd_api.g_ret_sts_error THEN
2219: RAISE fnd_api.g_exc_error;
2220: END IF ;
2221:
2222: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2223: RAISE fnd_api.g_exc_unexpected_error;

Line 2222: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2218: IF l_return_status = fnd_api.g_ret_sts_error THEN
2219: RAISE fnd_api.g_exc_error;
2220: END IF ;
2221:
2222: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2223: RAISE fnd_api.g_exc_unexpected_error;
2224: END IF;
2225:
2226: -- dbms_output.put_line('main_process_intransit: Successful insert_inspect_rec_rti');

Line 2223: RAISE fnd_api.g_exc_unexpected_error;

2219: RAISE fnd_api.g_exc_error;
2220: END IF ;
2221:
2222: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2223: RAISE fnd_api.g_exc_unexpected_error;
2224: END IF;
2225:
2226: -- dbms_output.put_line('main_process_intransit: Successful insert_inspect_rec_rti');
2227:

Line 2236: RAISE FND_API.G_EXC_ERROR;

2232:
2233: IF l_remaining_qty > 0 THEN
2234: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
2235: FND_MSG_PUB.Add;
2236: RAISE FND_API.G_EXC_ERROR;
2237: END IF;
2238:
2239: close rtv_cursor;
2240:

Line 2242: when fnd_api.g_exc_error THEN

2238:
2239: close rtv_cursor;
2240:
2241: exception
2242: when fnd_api.g_exc_error THEN
2243: rollback to inspect_main_intransit_sp;
2244:
2245: x_return_status := fnd_api.g_ret_sts_error;
2246:

Line 2245: x_return_status := fnd_api.g_ret_sts_error;

2241: exception
2242: when fnd_api.g_exc_error THEN
2243: rollback to inspect_main_intransit_sp;
2244:
2245: x_return_status := fnd_api.g_ret_sts_error;
2246:
2247: -- Get message count and data
2248: fnd_msg_pub.count_and_get
2249: ( p_count => x_msg_count

Line 2257: when fnd_api.g_exc_unexpected_error THEN

2253: IF (rtv_cursor%isopen) THEN
2254: CLOSE rtv_cursor;
2255: END IF;
2256:
2257: when fnd_api.g_exc_unexpected_error THEN
2258: rollback to inspect_main_intransit_sp;
2259:
2260: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2261:

Line 2260: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2256:
2257: when fnd_api.g_exc_unexpected_error THEN
2258: rollback to inspect_main_intransit_sp;
2259:
2260: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2261:
2262: -- Get message count and data
2263: fnd_msg_pub.count_and_get
2264: ( p_count => x_msg_count

Line 2275: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2271:
2272: when others THEN
2273: rollback to inspect_main_intransit_sp;
2274:
2275: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2276: --
2277: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2278: THEN
2279: fnd_msg_pub.add_exc_msg

Line 2443: x_return_status := fnd_api.g_ret_sts_success;

2439: and rt.transaction_type <> 'UNORDERED'
2440: and rt.routing_header_id = g_inspection_routing;
2441: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2442: begin
2443: x_return_status := fnd_api.g_ret_sts_success;
2444:
2445: -- dbms_output.put_line('main_process_rma: Just entering main_process_rma');
2446: --First check if the transaction date satisfies the validation.
2447: --If the transaction date is invalid then error out the transaction

Line 2465: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2461: , x_return_status => x_return_status
2462: , x_error_code => x_msg_data
2463: );
2464:
2465: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2466: RETURN;
2467: END IF;
2468:
2469: savepoint inspect_main_rma_sp;

Line 2628: IF l_return_status = fnd_api.g_ret_sts_error THEN

2624: , p_qa_collection_id => l_qa_collection_id
2625: , p_sec_uom => l_sec_uom --OPM Convergence
2626: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence);
2627:
2628: IF l_return_status = fnd_api.g_ret_sts_error THEN
2629: RAISE fnd_api.g_exc_error;
2630: END IF ;
2631:
2632: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2629: RAISE fnd_api.g_exc_error;

2625: , p_sec_uom => l_sec_uom --OPM Convergence
2626: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence);
2627:
2628: IF l_return_status = fnd_api.g_ret_sts_error THEN
2629: RAISE fnd_api.g_exc_error;
2630: END IF ;
2631:
2632: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2633: RAISE fnd_api.g_exc_unexpected_error;

Line 2632: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2628: IF l_return_status = fnd_api.g_ret_sts_error THEN
2629: RAISE fnd_api.g_exc_error;
2630: END IF ;
2631:
2632: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2633: RAISE fnd_api.g_exc_unexpected_error;
2634: END IF;
2635:
2636: -- dbms_output.put_line('main_process_rma: Successful insert_inspect_rec_rti');

Line 2633: RAISE fnd_api.g_exc_unexpected_error;

2629: RAISE fnd_api.g_exc_error;
2630: END IF ;
2631:
2632: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2633: RAISE fnd_api.g_exc_unexpected_error;
2634: END IF;
2635:
2636: -- dbms_output.put_line('main_process_rma: Successful insert_inspect_rec_rti');
2637:

Line 2646: RAISE FND_API.G_EXC_ERROR;

2642:
2643: IF l_remaining_qty > 0 THEN
2644: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
2645: FND_MSG_PUB.Add;
2646: RAISE FND_API.G_EXC_ERROR;
2647: END IF;
2648:
2649: close rtv_cursor;
2650:

Line 2652: when fnd_api.g_exc_error THEN

2648:
2649: close rtv_cursor;
2650:
2651: exception
2652: when fnd_api.g_exc_error THEN
2653: rollback to inspect_main_rma_sp;
2654:
2655: x_return_status := fnd_api.g_ret_sts_error;
2656:

Line 2655: x_return_status := fnd_api.g_ret_sts_error;

2651: exception
2652: when fnd_api.g_exc_error THEN
2653: rollback to inspect_main_rma_sp;
2654:
2655: x_return_status := fnd_api.g_ret_sts_error;
2656:
2657: -- Get message count and data
2658: fnd_msg_pub.count_and_get
2659: ( p_count => x_msg_count

Line 2667: when fnd_api.g_exc_unexpected_error THEN

2663: IF (rtv_cursor%isopen) THEN
2664: CLOSE rtv_cursor;
2665: END IF;
2666:
2667: when fnd_api.g_exc_unexpected_error THEN
2668: rollback to inspect_main_rma_sp;
2669:
2670: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2671:

Line 2670: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2666:
2667: when fnd_api.g_exc_unexpected_error THEN
2668: rollback to inspect_main_rma_sp;
2669:
2670: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2671:
2672: -- Get message count and data
2673: fnd_msg_pub.count_and_get
2674: ( p_count => x_msg_count

Line 2685: x_return_status := fnd_api.g_ret_sts_unexp_error ;

2681:
2682: when others THEN
2683: rollback to inspect_main_rma_sp;
2684:
2685: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2686: --
2687: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2688: THEN
2689: fnd_msg_pub.add_exc_msg

Line 2851: x_return_status := fnd_api.g_ret_sts_success;

2847: and rt.transaction_type <> 'UNORDERED'
2848: and rt.routing_header_id = g_inspection_routing;
2849: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2850: begin
2851: x_return_status := fnd_api.g_ret_sts_success;
2852:
2853: -- dbms_output.put_line('main_process_receipt: Just entering main_process_receipt');
2854: --First check if the transaction date satisfies the validation.
2855: --If the transaction date is invalid then error out the transaction

Line 2873: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2869: , x_return_status => x_return_status
2870: , x_error_code => x_msg_data
2871: );
2872:
2873: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2874: RETURN;
2875: END IF;
2876:
2877: savepoint inspect_main_receipt_sp;

Line 3052: IF l_return_status = fnd_api.g_ret_sts_error THEN

3048: , p_qa_collection_id => l_qa_collection_id ,
3049: p_sec_uom => l_sec_uom --OPM Convergence
3050: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
3051:
3052: IF l_return_status = fnd_api.g_ret_sts_error THEN
3053: IF (l_debug = 1) THEN
3054: print_debug('exc_error ' || l_return_status, 4);
3055: END IF;
3056: RAISE fnd_api.g_exc_error;

Line 3056: RAISE fnd_api.g_exc_error;

3052: IF l_return_status = fnd_api.g_ret_sts_error THEN
3053: IF (l_debug = 1) THEN
3054: print_debug('exc_error ' || l_return_status, 4);
3055: END IF;
3056: RAISE fnd_api.g_exc_error;
3057: END IF ;
3058:
3059: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3060: IF (l_debug = 1) THEN

Line 3059: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3055: END IF;
3056: RAISE fnd_api.g_exc_error;
3057: END IF ;
3058:
3059: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3060: IF (l_debug = 1) THEN
3061: print_debug('exc_unexpected_error ' || l_return_status, 4);
3062: END IF;
3063: RAISE fnd_api.g_exc_unexpected_error;

Line 3063: RAISE fnd_api.g_exc_unexpected_error;

3059: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3060: IF (l_debug = 1) THEN
3061: print_debug('exc_unexpected_error ' || l_return_status, 4);
3062: END IF;
3063: RAISE fnd_api.g_exc_unexpected_error;
3064: END IF;
3065:
3066: -- dbms_output.put_line('main_process_receipt: Successful insert_inspect_rec_rti');
3067:

Line 3082: RAISE FND_API.G_EXC_ERROR;

3078:
3079: IF l_remaining_qty > 0 THEN
3080: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3081: FND_MSG_PUB.Add;
3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;
3084:
3085: close rtv_cursor;
3086:

Line 3088: when fnd_api.g_exc_error THEN

3084:
3085: close rtv_cursor;
3086:
3087: exception
3088: when fnd_api.g_exc_error THEN
3089: IF (l_debug = 1) THEN
3090: print_debug('Jumped to Exception exc_error ', 4);
3091: END IF;
3092: rollback to inspect_main_receipt_sp;

Line 3094: x_return_status := fnd_api.g_ret_sts_error;

3090: print_debug('Jumped to Exception exc_error ', 4);
3091: END IF;
3092: rollback to inspect_main_receipt_sp;
3093:
3094: x_return_status := fnd_api.g_ret_sts_error;
3095: IF (l_debug = 1) THEN
3096: print_debug('Jumped to Exception exc_error ' || x_return_status, 4);
3097: END IF;
3098:

Line 3109: when fnd_api.g_exc_unexpected_error THEN

3105: IF (rtv_cursor%isopen) THEN
3106: CLOSE rtv_cursor;
3107: END IF;
3108:
3109: when fnd_api.g_exc_unexpected_error THEN
3110: IF (l_debug = 1) THEN
3111: print_debug('Jumped to Exception unexpected_exc_error ', 4);
3112: END IF;
3113: rollback to inspect_main_receipt_sp;

Line 3115: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3111: print_debug('Jumped to Exception unexpected_exc_error ', 4);
3112: END IF;
3113: rollback to inspect_main_receipt_sp;
3114:
3115: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3116: IF (l_debug = 1) THEN
3117: print_debug('Jumped to Exception unexpected_exc_error ' || x_return_status, 4);
3118: END IF;
3119:

Line 3136: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3132: print_debug('Jumped to Exception others', 4);
3133: END IF;
3134: rollback to inspect_main_receipt_sp;
3135:
3136: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3137: IF (l_debug = 1) THEN
3138: print_debug('Jumped to Exception others' || x_return_status, 4);
3139: END IF;
3140: --

Line 3316: x_return_status := fnd_api.g_ret_sts_success;

3312:
3313: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
3314:
3315: begin
3316: x_return_status := fnd_api.g_ret_sts_success;
3317:
3318: savepoint insert_rti_sp;
3319:
3320: SELECT

Line 3834: when fnd_api.g_exc_error THEN

3830: --setting product_transaction_id for the MTLI/MSNI records
3831: g_interface_transaction_id := l_interface_transaction_id;
3832:
3833: exception
3834: when fnd_api.g_exc_error THEN
3835: rollback to insert_rti_sp;
3836:
3837: x_return_status := fnd_api.g_ret_sts_error;
3838:

Line 3837: x_return_status := fnd_api.g_ret_sts_error;

3833: exception
3834: when fnd_api.g_exc_error THEN
3835: rollback to insert_rti_sp;
3836:
3837: x_return_status := fnd_api.g_ret_sts_error;
3838:
3839: -- Get message count and data
3840: fnd_msg_pub.count_and_get
3841: ( p_count => x_msg_count

Line 3845: when fnd_api.g_exc_unexpected_error THEN

3841: ( p_count => x_msg_count
3842: , p_data => x_msg_data
3843: );
3844:
3845: when fnd_api.g_exc_unexpected_error THEN
3846: rollback to insert_rti_sp;
3847:
3848: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3849:

Line 3848: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3844:
3845: when fnd_api.g_exc_unexpected_error THEN
3846: rollback to insert_rti_sp;
3847:
3848: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3849:
3850: -- Get message count and data
3851: fnd_msg_pub.count_and_get
3852: ( p_count => x_msg_count

Line 3859: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3855:
3856: when others THEN
3857: rollback to insert_rti_sp;
3858:
3859: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3860: --
3861: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3862: THEN
3863: fnd_msg_pub.add_exc_msg

Line 3910: x_return_status := fnd_api.g_ret_sts_success;

3906: r_val20 varchar2(200) := NULL;
3907:
3908: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3909: begin
3910: x_return_status := fnd_api.g_ret_sts_success;
3911:
3912: /*
3913: dbms_output.put_line('rcv_mgr_rpc_call: group_id '
3914: || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id);

Line 3937: x_return_status := fnd_api.g_ret_sts_error;

3933:
3934: IF (rc = 0 and (l_outcome NOT IN ('WARNING', 'ERROR'))) THEN
3935: NULL;
3936: ELSIF (rc = 1) THEN
3937: x_return_status := fnd_api.g_ret_sts_error;
3938: ELSIF (rc = 2) THEN
3939: x_return_status := fnd_api.g_ret_sts_error;
3940: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
3941: x_return_status := fnd_api.g_ret_sts_error;

Line 3939: x_return_status := fnd_api.g_ret_sts_error;

3935: NULL;
3936: ELSIF (rc = 1) THEN
3937: x_return_status := fnd_api.g_ret_sts_error;
3938: ELSIF (rc = 2) THEN
3939: x_return_status := fnd_api.g_ret_sts_error;
3940: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
3941: x_return_status := fnd_api.g_ret_sts_error;
3942:
3943: rc := fnd_transaction.get_values (

Line 3941: x_return_status := fnd_api.g_ret_sts_error;

3937: x_return_status := fnd_api.g_ret_sts_error;
3938: ELSIF (rc = 2) THEN
3939: x_return_status := fnd_api.g_ret_sts_error;
3940: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
3941: x_return_status := fnd_api.g_ret_sts_error;
3942:
3943: rc := fnd_transaction.get_values (
3944: r_val1, r_val2, r_val3, r_val4, r_val5,
3945: r_val6, r_val7, r_val8, r_val9, r_val10,

Line 3988: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

3984:
3985: PROCEDURE launch_rcv_manager_rpc(
3986: x_return_status OUT NOCOPY VARCHAR2
3987: , x_return_code OUT NOCOPY NUMBER) IS
3988: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
3989: l_msg_count NUMBER;
3990: l_msg_data VARCHAR2(400);
3991: l_label_status VARCHAR2(500);
3992: l_txn_id_tbl inv_label.transaction_id_rec_type;

Line 4047: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4043: , p_business_flow_code => 2
4044: , p_transaction_id => l_txn_id_tbl
4045: );
4046:
4047: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4048: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4049: fnd_msg_pub.ADD;
4050: x_return_status := 'W';
4051:

Line 4083: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

4079: print_debug('return status is launch procedure ' || x_return_status, 4);
4080: print_debug('return msg data l_msg_data: ' || l_msg_data, 4);
4081: END IF;
4082:
4083: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4084: IF (l_debug = 1) THEN
4085: print_debug('launch_rcv_manager_rpc 6.5: Encountered g_exc_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
4086: END IF;
4087: RAISE FND_API.G_EXC_ERROR;

Line 4087: RAISE FND_API.G_EXC_ERROR;

4083: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
4084: IF (l_debug = 1) THEN
4085: print_debug('launch_rcv_manager_rpc 6.5: Encountered g_exc_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
4086: END IF;
4087: RAISE FND_API.G_EXC_ERROR;
4088: END IF;
4089:
4090: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4091: IF (l_debug = 1) THEN

Line 4090: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

4086: END IF;
4087: RAISE FND_API.G_EXC_ERROR;
4088: END IF;
4089:
4090: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4091: IF (l_debug = 1) THEN
4092: print_debug('launch_rcv_manager_rpc 6.6: Encountered g_exc_unexp_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
4093: END IF;
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4090: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4091: IF (l_debug = 1) THEN
4092: print_debug('launch_rcv_manager_rpc 6.6: Encountered g_exc_unexp_error while calling receiving manager;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'), 4);
4093: END IF;
4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: END IF;
4096:
4097: EXCEPTION
4098: WHEN fnd_api.g_exc_error THEN

Line 4098: WHEN fnd_api.g_exc_error THEN

4094: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4095: END IF;
4096:
4097: EXCEPTION
4098: WHEN fnd_api.g_exc_error THEN
4099: x_return_status := fnd_api.g_ret_sts_error;
4100: IF (c_rti_txn_id%ISOPEN) THEN
4101: CLOSE c_rti_txn_id;
4102: END IF;

Line 4099: x_return_status := fnd_api.g_ret_sts_error;

4095: END IF;
4096:
4097: EXCEPTION
4098: WHEN fnd_api.g_exc_error THEN
4099: x_return_status := fnd_api.g_ret_sts_error;
4100: IF (c_rti_txn_id%ISOPEN) THEN
4101: CLOSE c_rti_txn_id;
4102: END IF;
4103: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4103: WHEN fnd_api.g_exc_unexpected_error THEN

4099: x_return_status := fnd_api.g_ret_sts_error;
4100: IF (c_rti_txn_id%ISOPEN) THEN
4101: CLOSE c_rti_txn_id;
4102: END IF;
4103: WHEN fnd_api.g_exc_unexpected_error THEN
4104: x_return_status := fnd_api.g_ret_sts_unexp_error;
4105: IF (c_rti_txn_id%ISOPEN) THEN
4106: CLOSE c_rti_txn_id;
4107: END IF;

Line 4104: x_return_status := fnd_api.g_ret_sts_unexp_error;

4100: IF (c_rti_txn_id%ISOPEN) THEN
4101: CLOSE c_rti_txn_id;
4102: END IF;
4103: WHEN fnd_api.g_exc_unexpected_error THEN
4104: x_return_status := fnd_api.g_ret_sts_unexp_error;
4105: IF (c_rti_txn_id%ISOPEN) THEN
4106: CLOSE c_rti_txn_id;
4107: END IF;
4108: WHEN OTHERS THEN

Line 4109: x_return_status := fnd_api.g_ret_sts_unexp_error;

4105: IF (c_rti_txn_id%ISOPEN) THEN
4106: CLOSE c_rti_txn_id;
4107: END IF;
4108: WHEN OTHERS THEN
4109: x_return_status := fnd_api.g_ret_sts_unexp_error;
4110: IF (c_rti_txn_id%ISOPEN) THEN
4111: CLOSE c_rti_txn_id;
4112: END IF;
4113: END launch_rcv_manager_rpc;

Line 4422: x_return_status := fnd_api.g_ret_sts_success;

4418: END IF;
4419: END IF;
4420:
4421: x_inspection_qty := l_total_qty;
4422: x_return_status := fnd_api.g_ret_sts_success;
4423:
4424: return x_inspection_qty;
4425:
4426: EXCEPTION

Line 4427: when fnd_api.g_exc_error THEN

4423:
4424: return x_inspection_qty;
4425:
4426: EXCEPTION
4427: when fnd_api.g_exc_error THEN
4428: x_return_status := fnd_api.g_ret_sts_error;
4429: -- Get message count and data
4430: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
4431: print_debug('***Execution error occured***', 4);

Line 4428: x_return_status := fnd_api.g_ret_sts_error;

4424: return x_inspection_qty;
4425:
4426: EXCEPTION
4427: when fnd_api.g_exc_error THEN
4428: x_return_status := fnd_api.g_ret_sts_error;
4429: -- Get message count and data
4430: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
4431: print_debug('***Execution error occured***', 4);
4432: return 0; --Bug #3908752

Line 4433: when fnd_api.g_exc_unexpected_error THEN

4429: -- Get message count and data
4430: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
4431: print_debug('***Execution error occured***', 4);
4432: return 0; --Bug #3908752
4433: when fnd_api.g_exc_unexpected_error THEN
4434: x_return_status := fnd_api.g_ret_sts_unexp_error;
4435: -- Get message count and data
4436: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
4437: print_debug('***Unexpected error occured***', 4);

Line 4434: x_return_status := fnd_api.g_ret_sts_unexp_error;

4430: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
4431: print_debug('***Execution error occured***', 4);
4432: return 0; --Bug #3908752
4433: when fnd_api.g_exc_unexpected_error THEN
4434: x_return_status := fnd_api.g_ret_sts_unexp_error;
4435: -- Get message count and data
4436: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
4437: print_debug('***Unexpected error occured***', 4);
4438: return 0;

Line 4440: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4436: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
4437: print_debug('***Unexpected error occured***', 4);
4438: return 0;
4439: when others THEN
4440: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4441: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4442: THEN
4443: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'get_inspection_qty');
4444: END IF;