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 155: x_return_status := fnd_api.g_ret_sts_success;

151: l_reason_id number;--OPM Convergence
152: BEGIN
153:
154: --Initialize the return status
155: x_return_status := fnd_api.g_ret_sts_success;
156:
157: l_product_txn_id := p_product_transaction_id;
158:
159: --First create the MTLI record for the lot that was inspected

Line 205: IF x_return_status = fnd_api.g_ret_sts_error THEN

201: , p_hold_date => l_hold_date);--OPM Convergence
202:
203:
204:
205: IF x_return_status = fnd_api.g_ret_sts_error THEN
206: RAISE fnd_api.g_exc_error;
207: END IF;
208:
209: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 206: RAISE fnd_api.g_exc_error;

202:
203:
204:
205: IF x_return_status = fnd_api.g_ret_sts_error THEN
206: RAISE fnd_api.g_exc_error;
207: END IF;
208:
209: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
210: RAISE fnd_api.g_exc_unexpected_error;

Line 209: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

205: IF x_return_status = fnd_api.g_ret_sts_error THEN
206: RAISE fnd_api.g_exc_error;
207: END IF;
208:
209: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
212:
213: IF (l_debug = 1) THEN

Line 210: RAISE fnd_api.g_exc_unexpected_error;

206: RAISE fnd_api.g_exc_error;
207: END IF;
208:
209: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
210: RAISE fnd_api.g_exc_unexpected_error;
211: END IF;
212:
213: IF (l_debug = 1) THEN
214: print_debug('process_lot_serial_intf 1.1: Created MTLI record for lot: txn if: ' || l_txn_if_id || ', serial_temp_id: ' ||

Line 267: IF x_return_status = fnd_api.g_ret_sts_error THEN

263: , p_product_code => l_prod_code
264: , p_att_exist => l_yes
265: , p_update_msn => l_no);
266:
267: IF x_return_status = fnd_api.g_ret_sts_error THEN
268: RAISE fnd_api.g_exc_error;
269: END IF;
270:
271: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 268: RAISE fnd_api.g_exc_error;

264: , p_att_exist => l_yes
265: , p_update_msn => l_no);
266:
267: IF x_return_status = fnd_api.g_ret_sts_error THEN
268: RAISE fnd_api.g_exc_error;
269: END IF;
270:
271: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
272: RAISE fnd_api.g_exc_unexpected_error;

Line 271: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

267: IF x_return_status = fnd_api.g_ret_sts_error THEN
268: RAISE fnd_api.g_exc_error;
269: END IF;
270:
271: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
272: RAISE fnd_api.g_exc_unexpected_error;
273: END IF;
274:
275: IF (l_debug = 1) THEN

Line 272: RAISE fnd_api.g_exc_unexpected_error;

268: RAISE fnd_api.g_exc_error;
269: END IF;
270:
271: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
272: RAISE fnd_api.g_exc_unexpected_error;
273: END IF;
274:
275: IF (l_debug = 1) THEN
276: print_debug('process_lot_serial_intf 1.2: Created MSNI record for serial: ' || p_serial_number || ' with txn_if_id: '

Line 282: WHEN fnd_api.g_exc_error THEN

278: END IF;
279: END IF; --END IF for a serial controlled item
280:
281: EXCEPTION
282: WHEN fnd_api.g_exc_error THEN
283: x_return_status := fnd_api.g_ret_sts_error;
284: -- Get message count and data
285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: WHEN fnd_api.g_exc_unexpected_error THEN

Line 283: x_return_status := fnd_api.g_ret_sts_error;

279: END IF; --END IF for a serial controlled item
280:
281: EXCEPTION
282: WHEN fnd_api.g_exc_error THEN
283: x_return_status := fnd_api.g_ret_sts_error;
284: -- Get message count and data
285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: WHEN fnd_api.g_exc_unexpected_error THEN
287: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 286: WHEN fnd_api.g_exc_unexpected_error THEN

282: WHEN fnd_api.g_exc_error THEN
283: x_return_status := fnd_api.g_ret_sts_error;
284: -- Get message count and data
285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: WHEN fnd_api.g_exc_unexpected_error THEN
287: x_return_status := fnd_api.g_ret_sts_unexp_error;
288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
289: WHEN OTHERS THEN
290: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 287: x_return_status := fnd_api.g_ret_sts_unexp_error;

283: x_return_status := fnd_api.g_ret_sts_error;
284: -- Get message count and data
285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: WHEN fnd_api.g_exc_unexpected_error THEN
287: x_return_status := fnd_api.g_ret_sts_unexp_error;
288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
289: WHEN OTHERS THEN
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 290: x_return_status := fnd_api.g_ret_sts_unexp_error;

286: WHEN fnd_api.g_exc_unexpected_error THEN
287: x_return_status := fnd_api.g_ret_sts_unexp_error;
288: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
289: WHEN OTHERS THEN
290: x_return_status := fnd_api.g_ret_sts_unexp_error;
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
292: fnd_msg_pub.add_exc_msg(g_pkg_name, 'process_lot_serial_intf');
293: END IF;
294: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 463: IF l_return_status = fnd_api.g_ret_sts_error

459: 4
460: );
461: END IF;
462:
463: IF l_return_status = fnd_api.g_ret_sts_error
464: THEN
465: RAISE fnd_api.g_exc_error;
466: END IF;
467:

Line 465: RAISE fnd_api.g_exc_error;

461: END IF;
462:
463: IF l_return_status = fnd_api.g_ret_sts_error
464: THEN
465: RAISE fnd_api.g_exc_error;
466: END IF;
467:
468: IF l_return_status = fnd_api.g_ret_sts_unexp_error
469: THEN

Line 468: IF l_return_status = fnd_api.g_ret_sts_unexp_error

464: THEN
465: RAISE fnd_api.g_exc_error;
466: END IF;
467:
468: IF l_return_status = fnd_api.g_ret_sts_unexp_error
469: THEN
470: RAISE fnd_api.g_exc_unexpected_error;
471: END IF;
472:

Line 470: RAISE fnd_api.g_exc_unexpected_error;

466: END IF;
467:
468: IF l_return_status = fnd_api.g_ret_sts_unexp_error
469: THEN
470: RAISE fnd_api.g_exc_unexpected_error;
471: END IF;
472:
473: l_new_mol_id := l_mo_splt_tb (1).line_id;
474: ELSE

Line 617: IF l_return_status = fnd_api.g_ret_sts_error

613: p_sec_uom => l_sec_uom,
614: p_secondary_qty => l_rtv_sec_qty
615: ); --OPM Convergence
616:
617: IF l_return_status = fnd_api.g_ret_sts_error
618: THEN
619: RAISE fnd_api.g_exc_error;
620: END IF;
621:

Line 619: RAISE fnd_api.g_exc_error;

615: ); --OPM Convergence
616:
617: IF l_return_status = fnd_api.g_ret_sts_error
618: THEN
619: RAISE fnd_api.g_exc_error;
620: END IF;
621:
622: IF l_return_status = fnd_api.g_ret_sts_unexp_error
623: THEN

Line 622: IF l_return_status = fnd_api.g_ret_sts_unexp_error

618: THEN
619: RAISE fnd_api.g_exc_error;
620: END IF;
621:
622: IF l_return_status = fnd_api.g_ret_sts_unexp_error
623: THEN
624: RAISE fnd_api.g_exc_unexpected_error;
625: END IF;
626:

Line 624: RAISE fnd_api.g_exc_unexpected_error;

620: END IF;
621:
622: IF l_return_status = fnd_api.g_ret_sts_unexp_error
623: THEN
624: RAISE fnd_api.g_exc_unexpected_error;
625: END IF;
626:
627: l_progress := '120';
628:

Line 726: IF x_return_status = fnd_api.g_ret_sts_error

722: ,
723: p_hold_date => l_hold_date
724: ); --OPM Convergence
725:
726: IF x_return_status = fnd_api.g_ret_sts_error
727: THEN
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:

Line 728: RAISE fnd_api.g_exc_error;

724: ); --OPM Convergence
725:
726: IF x_return_status = fnd_api.g_ret_sts_error
727: THEN
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:
731: IF x_return_status = fnd_api.g_ret_sts_unexp_error
732: THEN

Line 731: IF x_return_status = fnd_api.g_ret_sts_unexp_error

727: THEN
728: RAISE fnd_api.g_exc_error;
729: END IF;
730:
731: IF x_return_status = fnd_api.g_ret_sts_unexp_error
732: THEN
733: RAISE fnd_api.g_exc_unexpected_error;
734: END IF;
735:

Line 733: RAISE fnd_api.g_exc_unexpected_error;

729: END IF;
730:
731: IF x_return_status = fnd_api.g_ret_sts_unexp_error
732: THEN
733: RAISE fnd_api.g_exc_unexpected_error;
734: END IF;
735:
736: IF (l_debug = 1)
737: THEN

Line 788: IF x_return_status = fnd_api.g_ret_sts_error

784: p_att_exist => l_yes,
785: p_update_msn => l_no
786: );
787:
788: IF x_return_status = fnd_api.g_ret_sts_error
789: THEN
790: RAISE fnd_api.g_exc_error;
791: END IF;
792:

Line 790: RAISE fnd_api.g_exc_error;

786: );
787:
788: IF x_return_status = fnd_api.g_ret_sts_error
789: THEN
790: RAISE fnd_api.g_exc_error;
791: END IF;
792:
793: IF x_return_status = fnd_api.g_ret_sts_unexp_error
794: THEN

Line 793: IF x_return_status = fnd_api.g_ret_sts_unexp_error

789: THEN
790: RAISE fnd_api.g_exc_error;
791: END IF;
792:
793: IF x_return_status = fnd_api.g_ret_sts_unexp_error
794: THEN
795: RAISE fnd_api.g_exc_unexpected_error;
796: END IF;
797:

Line 795: RAISE fnd_api.g_exc_unexpected_error;

791: END IF;
792:
793: IF x_return_status = fnd_api.g_ret_sts_unexp_error
794: THEN
795: RAISE fnd_api.g_exc_unexpected_error;
796: END IF;
797:
798: IF (l_debug = 1)
799: THEN

Line 846: IF l_return_status = fnd_api.g_ret_sts_error

842: 4
843: );
844: END IF;
845:
846: IF l_return_status = fnd_api.g_ret_sts_error
847: THEN
848: RAISE fnd_api.g_exc_error;
849: END IF;
850:

Line 848: RAISE fnd_api.g_exc_error;

844: END IF;
845:
846: IF l_return_status = fnd_api.g_ret_sts_error
847: THEN
848: RAISE fnd_api.g_exc_error;
849: END IF;
850:
851: IF l_return_status = fnd_api.g_ret_sts_unexp_error
852: THEN

Line 851: IF l_return_status = fnd_api.g_ret_sts_unexp_error

847: THEN
848: RAISE fnd_api.g_exc_error;
849: END IF;
850:
851: IF l_return_status = fnd_api.g_ret_sts_unexp_error
852: THEN
853: RAISE fnd_api.g_exc_unexpected_error;
854: END IF;
855:

Line 853: RAISE fnd_api.g_exc_unexpected_error;

849: END IF;
850:
851: IF l_return_status = fnd_api.g_ret_sts_unexp_error
852: THEN
853: RAISE fnd_api.g_exc_unexpected_error;
854: END IF;
855:
856: l_progress := '170';
857: END IF; --END IF check lot and serial controls

Line 871: IF (x_return_status <> fnd_api.g_ret_sts_success)

867: p_mo_line_id => l_new_mol_id
868: );
869: l_progress := '180';
870:
871: IF (x_return_status <> fnd_api.g_ret_sts_success)
872: THEN
873: IF (l_debug = 1)
874: THEN
875: print_debug (' Error in Activate_Plan_For_Load ' || x_msg_data, 1);

Line 878: RAISE fnd_api.g_exc_error;

874: THEN
875: print_debug (' Error in Activate_Plan_For_Load ' || x_msg_data, 1);
876: END IF;
877:
878: RAISE fnd_api.g_exc_error;
879: ELSE
880: IF (l_debug = 1)
881: THEN
882: print_debug ( 'Successfully called Activate_Plan_For_Load for '

Line 901: WHEN fnd_api.g_exc_error

897: WHERE line_id = l_new_mol_id;
898:
899: l_progress := '200';
900: EXCEPTION
901: WHEN fnd_api.g_exc_error
902: THEN
903: IF (l_debug = 1)
904: THEN
905: print_debug ('l_progress ' || l_progress, 4);

Line 908: x_return_status := fnd_api.g_ret_sts_error;

904: THEN
905: print_debug ('l_progress ' || l_progress, 4);
906: END IF;
907:
908: x_return_status := fnd_api.g_ret_sts_error;
909: -- Get message count and data
910: fnd_msg_pub.count_and_get (p_count => x_msg_count,
911: p_data => x_msg_data);
912: WHEN fnd_api.g_exc_unexpected_error

Line 912: WHEN fnd_api.g_exc_unexpected_error

908: x_return_status := fnd_api.g_ret_sts_error;
909: -- Get message count and data
910: fnd_msg_pub.count_and_get (p_count => x_msg_count,
911: p_data => x_msg_data);
912: WHEN fnd_api.g_exc_unexpected_error
913: THEN
914: IF (l_debug = 1)
915: THEN
916: print_debug ('l_progress ' || l_progress, 4);

Line 921: x_return_status := fnd_api.g_ret_sts_unexp_error;

917: print_debug (' SQLCODE ' || SQLCODE, 4);
918: print_debug (' SQLERRM ' || SQLERRM, 4);
919: END IF;
920:
921: x_return_status := fnd_api.g_ret_sts_unexp_error;
922: fnd_msg_pub.count_and_get (p_count => x_msg_count,
923: p_data => x_msg_data);
924: WHEN OTHERS
925: THEN

Line 933: x_return_status := fnd_api.g_ret_sts_unexp_error;

929: print_debug (' SQLCODE ' || SQLCODE, 4);
930: print_debug (' SQLERRM ' || SQLERRM, 4);
931: END IF;
932:
933: x_return_status := fnd_api.g_ret_sts_unexp_error;
934:
935: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
936: THEN
937: fnd_msg_pub.add_exc_msg (g_pkg_name, 'split_mol_create_rti');

Line 1189: x_return_status := fnd_api.g_ret_sts_success;

1185: l_new_mol_id NUMBER;
1186: l_split_line_id NUMBER; --for debug
1187: l_progress VARCHAR2 (10) := '0';
1188: BEGIN
1189: x_return_status := fnd_api.g_ret_sts_success;
1190:
1191: IF (l_debug = 1)
1192: THEN
1193: print_debug (' new main_process: Just entering main_process', 4);

Line 1229: IF x_return_status <> fnd_api.g_ret_sts_success

1225: x_return_status => x_return_status,
1226: x_error_code => x_msg_data
1227: );
1228:
1229: IF x_return_status <> fnd_api.g_ret_sts_success
1230: THEN
1231: RETURN;
1232: END IF;
1233:

Line 1510: RAISE fnd_api.g_exc_error;

1506: IF l_remaining_mol_qty > 0
1507: THEN
1508: fnd_message.set_name ('INV', 'INV_RCV_NO_ROWS');
1509: fnd_msg_pub.ADD;
1510: RAISE fnd_api.g_exc_error;
1511: END IF;
1512:
1513: -- MOLCON
1514: EXIT;

Line 1529: RAISE fnd_api.g_exc_error;

1525: IF l_remaining_mol_qty > 0
1526: THEN
1527: fnd_message.set_name ('INV', 'INV_RCV_NO_ROWS');
1528: fnd_msg_pub.ADD;
1529: RAISE fnd_api.g_exc_error;
1530: END IF;
1531:
1532: -- MOLCON
1533: EXIT;

Line 1950: RAISE fnd_api.g_exc_error;

1946: 4
1947: );
1948: END IF;
1949:
1950: RAISE fnd_api.g_exc_error;
1951: END IF;
1952: EXCEPTION
1953: WHEN fnd_api.g_exc_error
1954: THEN

Line 1953: WHEN fnd_api.g_exc_error

1949:
1950: RAISE fnd_api.g_exc_error;
1951: END IF;
1952: EXCEPTION
1953: WHEN fnd_api.g_exc_error
1954: THEN
1955: IF (l_debug = 1)
1956: THEN
1957: print_debug

Line 1965: x_return_status := fnd_api.g_ret_sts_error;

1961: );
1962: END IF;
1963:
1964: ROLLBACK TO inspect_main_sp;
1965: x_return_status := fnd_api.g_ret_sts_error;
1966: -- Get message count and data
1967: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1968: p_data => x_msg_data);
1969:

Line 1984: WHEN fnd_api.g_exc_unexpected_error

1980: IF (rtv_lot_cursor%ISOPEN)
1981: THEN
1982: CLOSE rtv_lot_cursor;
1983: END IF;
1984: WHEN fnd_api.g_exc_unexpected_error
1985: THEN
1986: IF (l_debug = 1)
1987: THEN
1988: print_debug

Line 1996: x_return_status := fnd_api.g_ret_sts_unexp_error;

1992: );
1993: END IF;
1994:
1995: ROLLBACK TO inspect_main_sp;
1996: x_return_status := fnd_api.g_ret_sts_unexp_error;
1997: -- Get message count and data
1998: fnd_msg_pub.count_and_get (p_count => x_msg_count,
1999: p_data => x_msg_data);
2000:

Line 2029: x_return_status := fnd_api.g_ret_sts_unexp_error;

2025: print_debug ('SQLERRM ' || SQLERRM, 4);
2026: END IF;
2027:
2028: ROLLBACK TO inspect_main_sp;
2029: x_return_status := fnd_api.g_ret_sts_unexp_error;
2030:
2031: --
2032: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
2033: THEN

Line 2338: x_return_status := fnd_api.g_ret_sts_success;

2334: l_progress VARCHAR2(10) := '0';
2335: l_mol_prim_qty NUMBER;--Bug 13484877
2336:
2337: BEGIN
2338: x_return_status := fnd_api.g_ret_sts_success;
2339:
2340: IF (l_debug = 1) THEN
2341: print_debug('main_process: Just entering main_process', 4);
2342: print_debug('p_inventory_item_id => '||p_inventory_item_id,4);

Line 2372: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2368: , x_return_status => x_return_status
2369: , x_error_code => x_msg_data
2370: );
2371:
2372: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2373: RETURN;
2374: END IF;
2375:
2376: SAVEPOINT inspect_main_sp;

Line 2577: RAISE fnd_api.g_exc_error;

2573: goto no_mol_match;
2574: /* commenting for 12942776
2575: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
2576: fnd_msg_pub.ADD;
2577: RAISE fnd_api.g_exc_error;
2578: */
2579: END IF;
2580: -- MOLCON
2581: EXIT;

Line 2598: RAISE fnd_api.g_exc_error;

2594: -- CHECK FOR ERROR HERE
2595: IF l_remaining_mol_qty > 0 then
2596: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
2597: fnd_msg_pub.ADD;
2598: RAISE fnd_api.g_exc_error;
2599: END IF;
2600: -- MOLCON
2601: EXIT;
2602: END IF;

Line 2617: RAISE fnd_api.g_exc_error;

2613: -- CHECK FOR ERROR HERE
2614: IF l_remaining_mol_qty > 0 then
2615: fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
2616: fnd_msg_pub.ADD;
2617: RAISE fnd_api.g_exc_error;
2618: END IF;
2619: -- MOLCON
2620: EXIT;
2621: END IF;

Line 2827: IF l_return_status = fnd_api.g_ret_sts_error THEN

2823: IF (l_debug = 1) THEN
2824: print_debug('main_process : Call to split_mo returns: ' || l_return_status, 4);
2825: END IF;
2826:
2827: IF l_return_status = fnd_api.g_ret_sts_error THEN
2828: RAISE fnd_api.g_exc_error;
2829: END IF;
2830:
2831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2828: RAISE fnd_api.g_exc_error;

2824: print_debug('main_process : Call to split_mo returns: ' || l_return_status, 4);
2825: END IF;
2826:
2827: IF l_return_status = fnd_api.g_ret_sts_error THEN
2828: RAISE fnd_api.g_exc_error;
2829: END IF;
2830:
2831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2832: RAISE fnd_api.g_exc_unexpected_error;

Line 2831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2827: IF l_return_status = fnd_api.g_ret_sts_error THEN
2828: RAISE fnd_api.g_exc_error;
2829: END IF;
2830:
2831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2832: RAISE fnd_api.g_exc_unexpected_error;
2833: END IF;
2834: l_new_mol_id := l_mo_splt_tb(1).line_id;
2835: ELSE

Line 2832: RAISE fnd_api.g_exc_unexpected_error;

2828: RAISE fnd_api.g_exc_error;
2829: END IF;
2830:
2831: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2832: RAISE fnd_api.g_exc_unexpected_error;
2833: END IF;
2834: l_new_mol_id := l_mo_splt_tb(1).line_id;
2835: ELSE
2836: l_new_mol_id := l_mol_line_id;

Line 2948: IF l_return_status = fnd_api.g_ret_sts_error THEN

2944: , p_mmtt_temp_id => l_mmtt_ids(i)
2945: , p_sec_uom => l_sec_uom --OPM Convergence
2946: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
2947:
2948: IF l_return_status = fnd_api.g_ret_sts_error THEN
2949: RAISE fnd_api.g_exc_error;
2950: END IF;
2951:
2952: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2949: RAISE fnd_api.g_exc_error;

2945: , p_sec_uom => l_sec_uom --OPM Convergence
2946: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
2947:
2948: IF l_return_status = fnd_api.g_ret_sts_error THEN
2949: RAISE fnd_api.g_exc_error;
2950: END IF;
2951:
2952: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2953: RAISE fnd_api.g_exc_unexpected_error;

Line 2952: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

2948: IF l_return_status = fnd_api.g_ret_sts_error THEN
2949: RAISE fnd_api.g_exc_error;
2950: END IF;
2951:
2952: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2953: RAISE fnd_api.g_exc_unexpected_error;
2954: END IF;
2955:
2956: /* FP-J Lot/Serial Support Enhancement

Line 2953: RAISE fnd_api.g_exc_unexpected_error;

2949: RAISE fnd_api.g_exc_error;
2950: END IF;
2951:
2952: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
2953: RAISE fnd_api.g_exc_unexpected_error;
2954: END IF;
2955:
2956: /* FP-J Lot/Serial Support Enhancement
2957: * Process the lot numbers and serial numbers corresponding to the RTI

Line 3000: IF l_return_status = fnd_api.g_ret_sts_error THEN

2996: IF (l_debug = 1) THEN
2997: print_debug('main_process: process_lot_serial_intf returns: ' || l_return_status, 4);
2998: END IF;
2999:
3000: IF l_return_status = fnd_api.g_ret_sts_error THEN
3001: RAISE fnd_api.g_exc_error;
3002: END IF;
3003:
3004: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3001: RAISE fnd_api.g_exc_error;

2997: print_debug('main_process: process_lot_serial_intf returns: ' || l_return_status, 4);
2998: END IF;
2999:
3000: IF l_return_status = fnd_api.g_ret_sts_error THEN
3001: RAISE fnd_api.g_exc_error;
3002: END IF;
3003:
3004: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3005: RAISE fnd_api.g_exc_unexpected_error;

Line 3004: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3000: IF l_return_status = fnd_api.g_ret_sts_error THEN
3001: RAISE fnd_api.g_exc_error;
3002: END IF;
3003:
3004: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3005: RAISE fnd_api.g_exc_unexpected_error;
3006: END IF;
3007: END IF; --END IF check lot and serial controls
3008: END LOOP; -- End MMTT Loop

Line 3005: RAISE fnd_api.g_exc_unexpected_error;

3001: RAISE fnd_api.g_exc_error;
3002: END IF;
3003:
3004: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3005: RAISE fnd_api.g_exc_unexpected_error;
3006: END IF;
3007: END IF; --END IF check lot and serial controls
3008: END LOOP; -- End MMTT Loop
3009:

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

3014: , x_msg_data => x_msg_data
3015: , p_org_id => l_organization_id
3016: , p_mo_line_id => l_new_mol_id);
3017:
3018: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3019: IF (l_debug = 1) THEN
3020: print_debug(' Error in Activate_Plan_For_Load ' || x_msg_data, 1);
3021: END IF;
3022: RAISE fnd_api.g_exc_error;

Line 3022: RAISE fnd_api.g_exc_error;

3018: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3019: IF (l_debug = 1) THEN
3020: print_debug(' Error in Activate_Plan_For_Load ' || x_msg_data, 1);
3021: END IF;
3022: RAISE fnd_api.g_exc_error;
3023: ELSE
3024: IF (l_debug = 1) THEN
3025: print_debug('Successfully called Activate_Plan_For_Load for ' || l_rec_count || ' row(s)', 9);
3026: END IF;

Line 3045: -- RAISE fnd_api.g_exc_error;

3041: -- MOLCON COMMENTED THIS CALL HERE
3042: -- THIS HAS TO BE TRACKED ABOVE
3043: -- fnd_message.set_name('INV', 'INV_RCV_NO_ROWS');
3044: -- fnd_msg_pub.ADD;
3045: -- RAISE fnd_api.g_exc_error;
3046:
3047: END IF; --END IF IF (l_rtv_qty > 0)
3048: END LOOP;
3049:

Line 3071: RAISE fnd_api.g_exc_error;

3067: IF (l_remaining_qty > 0) THEN
3068: IF (l_debug = 1) THEN
3069: print_debug('main_process: No more MOL, but remaining qty still exists', 4);
3070: END IF;
3071: RAISE fnd_api.g_exc_error;
3072: END IF;
3073:
3074: EXCEPTION
3075: WHEN fnd_api.g_exc_error THEN

Line 3075: WHEN fnd_api.g_exc_error THEN

3071: RAISE fnd_api.g_exc_error;
3072: END IF;
3073:
3074: EXCEPTION
3075: WHEN fnd_api.g_exc_error THEN
3076: IF (l_debug = 1) THEN
3077: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
3078: END IF;
3079:

Line 3081: x_return_status := fnd_api.g_ret_sts_error;

3077: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
3078: END IF;
3079:
3080: ROLLBACK TO inspect_main_sp;
3081: x_return_status := fnd_api.g_ret_sts_error;
3082: -- Get message count and data
3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3084:
3085: IF (mol_cursor%ISOPEN) THEN

Line 3101: WHEN fnd_api.g_exc_unexpected_error THEN

3097: IF (rtv_serial_cursor%isopen) THEN
3098: CLOSE rtv_serial_cursor;
3099: END IF;
3100:
3101: WHEN fnd_api.g_exc_unexpected_error THEN
3102: IF (l_debug = 1) THEN
3103: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
3104: END IF;
3105:

Line 3107: x_return_status := fnd_api.g_ret_sts_unexp_error;

3103: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
3104: END IF;
3105:
3106: ROLLBACK TO inspect_main_sp;
3107: x_return_status := fnd_api.g_ret_sts_unexp_error;
3108: -- Get message count and data
3109: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3110:
3111: IF (mol_cursor%ISOPEN) THEN

Line 3133: x_return_status := fnd_api.g_ret_sts_unexp_error;

3129: print_debug('Exception raised in main_process at progress: ' || l_progress, 4);
3130: END IF;
3131:
3132: ROLLBACK TO inspect_main_sp;
3133: x_return_status := fnd_api.g_ret_sts_unexp_error;
3134:
3135: --
3136: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3137: fnd_msg_pub.add_exc_msg(g_pkg_name, 'main_process');

Line 3214: x_return_status := fnd_api.g_ret_sts_success;

3210: l_debug NUMBER
3211: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3212: --l_serial_tbl inv_rcv_std_inspect_apis.t_serial_rec_tbl;
3213: BEGIN
3214: x_return_status := fnd_api.g_ret_sts_success;
3215: SAVEPOINT process_sl_sp;
3216:
3217: --
3218: -- Get the primary uom of item. If we are here the item should be serial

Line 3317: IF l_return_status = fnd_api.g_ret_sts_error

3313: p_attribute15 => p_attribute15,
3314: p_serial_tbl => l_serial_tbl
3315: );
3316:
3317: IF l_return_status = fnd_api.g_ret_sts_error
3318: THEN
3319: RAISE fnd_api.g_exc_error;
3320: END IF;
3321:

Line 3319: RAISE fnd_api.g_exc_error;

3315: );
3316:
3317: IF l_return_status = fnd_api.g_ret_sts_error
3318: THEN
3319: RAISE fnd_api.g_exc_error;
3320: END IF;
3321:
3322: IF l_return_status = fnd_api.g_ret_sts_unexp_error
3323: THEN

Line 3322: IF l_return_status = fnd_api.g_ret_sts_unexp_error

3318: THEN
3319: RAISE fnd_api.g_exc_error;
3320: END IF;
3321:
3322: IF l_return_status = fnd_api.g_ret_sts_unexp_error
3323: THEN
3324: RAISE fnd_api.g_exc_unexpected_error;
3325: END IF;
3326: EXCEPTION

Line 3324: RAISE fnd_api.g_exc_unexpected_error;

3320: END IF;
3321:
3322: IF l_return_status = fnd_api.g_ret_sts_unexp_error
3323: THEN
3324: RAISE fnd_api.g_exc_unexpected_error;
3325: END IF;
3326: EXCEPTION
3327: WHEN fnd_api.g_exc_error
3328: THEN

Line 3327: WHEN fnd_api.g_exc_error

3323: THEN
3324: RAISE fnd_api.g_exc_unexpected_error;
3325: END IF;
3326: EXCEPTION
3327: WHEN fnd_api.g_exc_error
3328: THEN
3329: ROLLBACK TO process_sl_sp;
3330: x_return_status := fnd_api.g_ret_sts_error;
3331: -- Get message count and data

Line 3330: x_return_status := fnd_api.g_ret_sts_error;

3326: EXCEPTION
3327: WHEN fnd_api.g_exc_error
3328: THEN
3329: ROLLBACK TO process_sl_sp;
3330: x_return_status := fnd_api.g_ret_sts_error;
3331: -- Get message count and data
3332: fnd_msg_pub.count_and_get (p_count => x_msg_count,
3333: p_data => x_msg_data
3334: );

Line 3335: WHEN fnd_api.g_exc_unexpected_error

3331: -- Get message count and data
3332: fnd_msg_pub.count_and_get (p_count => x_msg_count,
3333: p_data => x_msg_data
3334: );
3335: WHEN fnd_api.g_exc_unexpected_error
3336: THEN
3337: ROLLBACK TO process_sl_sp;
3338: x_return_status := fnd_api.g_ret_sts_unexp_error;
3339: -- Get message count and data

Line 3338: x_return_status := fnd_api.g_ret_sts_unexp_error;

3334: );
3335: WHEN fnd_api.g_exc_unexpected_error
3336: THEN
3337: ROLLBACK TO process_sl_sp;
3338: x_return_status := fnd_api.g_ret_sts_unexp_error;
3339: -- Get message count and data
3340: fnd_msg_pub.count_and_get (p_count => x_msg_count,
3341: p_data => x_msg_data
3342: );

Line 3346: x_return_status := fnd_api.g_ret_sts_unexp_error;

3342: );
3343: WHEN OTHERS
3344: THEN
3345: ROLLBACK TO process_sl_sp;
3346: x_return_status := fnd_api.g_ret_sts_unexp_error;
3347:
3348: --
3349: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
3350: THEN

Line 3505: x_return_status := fnd_api.g_ret_sts_success;

3501: and rt.routing_header_id = g_inspection_routing;
3502:
3503: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3504: begin
3505: x_return_status := fnd_api.g_ret_sts_success;
3506:
3507: -- dbms_output.put_line('main_process_po: Just entering main_process_po');
3508:
3509: --First check if the transaction date satisfies the validation.

Line 3528: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3524: , x_return_status => x_return_status
3525: , x_error_code => x_msg_data
3526: );
3527:
3528: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3529: RETURN;
3530: END IF;
3531:
3532: savepoint inspect_main_po_sp;

Line 3694: IF l_return_status = fnd_api.g_ret_sts_error THEN

3690: , p_qa_collection_id => l_qa_collection_id
3691: , p_sec_uom => l_sec_uom --OPM Convergence
3692: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
3693:
3694: IF l_return_status = fnd_api.g_ret_sts_error THEN
3695: RAISE fnd_api.g_exc_error;
3696: END IF ;
3697:
3698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3695: RAISE fnd_api.g_exc_error;

3691: , p_sec_uom => l_sec_uom --OPM Convergence
3692: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
3693:
3694: IF l_return_status = fnd_api.g_ret_sts_error THEN
3695: RAISE fnd_api.g_exc_error;
3696: END IF ;
3697:
3698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3699: RAISE fnd_api.g_exc_unexpected_error;

Line 3698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3694: IF l_return_status = fnd_api.g_ret_sts_error THEN
3695: RAISE fnd_api.g_exc_error;
3696: END IF ;
3697:
3698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3699: RAISE fnd_api.g_exc_unexpected_error;
3700: END IF;
3701:
3702: -- dbms_output.put_line('main_process_po: Successful insert_inspect_rec_rti');

Line 3699: RAISE fnd_api.g_exc_unexpected_error;

3695: RAISE fnd_api.g_exc_error;
3696: END IF ;
3697:
3698: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3699: RAISE fnd_api.g_exc_unexpected_error;
3700: END IF;
3701:
3702: -- dbms_output.put_line('main_process_po: Successful insert_inspect_rec_rti');
3703:

Line 3712: RAISE FND_API.G_EXC_ERROR;

3708:
3709: IF l_remaining_qty > 0 THEN
3710: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
3711: FND_MSG_PUB.Add;
3712: RAISE FND_API.G_EXC_ERROR;
3713: END IF;
3714:
3715: close rtv_cursor;
3716:

Line 3718: when fnd_api.g_exc_error THEN

3714:
3715: close rtv_cursor;
3716:
3717: exception
3718: when fnd_api.g_exc_error THEN
3719: rollback to inspect_main_po_sp;
3720:
3721: x_return_status := fnd_api.g_ret_sts_error;
3722:

Line 3721: x_return_status := fnd_api.g_ret_sts_error;

3717: exception
3718: when fnd_api.g_exc_error THEN
3719: rollback to inspect_main_po_sp;
3720:
3721: x_return_status := fnd_api.g_ret_sts_error;
3722:
3723: -- Get message count and data
3724: fnd_msg_pub.count_and_get
3725: ( p_count => x_msg_count

Line 3733: when fnd_api.g_exc_unexpected_error THEN

3729: IF (rtv_cursor%isopen) THEN
3730: CLOSE rtv_cursor;
3731: END IF;
3732:
3733: when fnd_api.g_exc_unexpected_error THEN
3734: rollback to inspect_main_po_sp;
3735:
3736: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3737:

Line 3736: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3732:
3733: when fnd_api.g_exc_unexpected_error THEN
3734: rollback to inspect_main_po_sp;
3735:
3736: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3737:
3738: -- Get message count and data
3739: fnd_msg_pub.count_and_get
3740: ( p_count => x_msg_count

Line 3751: x_return_status := fnd_api.g_ret_sts_unexp_error ;

3747:
3748: when others THEN
3749: rollback to inspect_main_po_sp;
3750:
3751: x_return_status := fnd_api.g_ret_sts_unexp_error ;
3752: --
3753: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3754: THEN
3755: fnd_msg_pub.add_exc_msg

Line 3920: x_return_status := fnd_api.g_ret_sts_success;

3916: and rt.transaction_type <> 'UNORDERED'
3917: and rt.routing_header_id = g_inspection_routing;
3918: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3919: begin
3920: x_return_status := fnd_api.g_ret_sts_success;
3921:
3922: -- dbms_output.put_line('main_process_intransit: Just entering main_process_intransit');
3923:
3924: --First check if the transaction date satisfies the validation.

Line 3943: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3939: , x_return_status => x_return_status
3940: , x_error_code => x_msg_data
3941: );
3942:
3943: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3944: RETURN;
3945: END IF;
3946:
3947: savepoint inspect_main_intransit_sp;

Line 4111: IF l_return_status = fnd_api.g_ret_sts_error THEN

4107: , p_qa_collection_id => l_qa_collection_id
4108: , p_sec_uom => l_sec_uom --OPM Convergence
4109: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
4110:
4111: IF l_return_status = fnd_api.g_ret_sts_error THEN
4112: RAISE fnd_api.g_exc_error;
4113: END IF ;
4114:
4115: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4112: RAISE fnd_api.g_exc_error;

4108: , p_sec_uom => l_sec_uom --OPM Convergence
4109: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
4110:
4111: IF l_return_status = fnd_api.g_ret_sts_error THEN
4112: RAISE fnd_api.g_exc_error;
4113: END IF ;
4114:
4115: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4116: RAISE fnd_api.g_exc_unexpected_error;

Line 4115: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4111: IF l_return_status = fnd_api.g_ret_sts_error THEN
4112: RAISE fnd_api.g_exc_error;
4113: END IF ;
4114:
4115: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4116: RAISE fnd_api.g_exc_unexpected_error;
4117: END IF;
4118:
4119: -- dbms_output.put_line('main_process_intransit: Successful insert_inspect_rec_rti');

Line 4116: RAISE fnd_api.g_exc_unexpected_error;

4112: RAISE fnd_api.g_exc_error;
4113: END IF ;
4114:
4115: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4116: RAISE fnd_api.g_exc_unexpected_error;
4117: END IF;
4118:
4119: -- dbms_output.put_line('main_process_intransit: Successful insert_inspect_rec_rti');
4120:

Line 4129: RAISE FND_API.G_EXC_ERROR;

4125:
4126: IF l_remaining_qty > 0 THEN
4127: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
4128: FND_MSG_PUB.Add;
4129: RAISE FND_API.G_EXC_ERROR;
4130: END IF;
4131:
4132: close rtv_cursor;
4133:

Line 4135: when fnd_api.g_exc_error THEN

4131:
4132: close rtv_cursor;
4133:
4134: exception
4135: when fnd_api.g_exc_error THEN
4136: rollback to inspect_main_intransit_sp;
4137:
4138: x_return_status := fnd_api.g_ret_sts_error;
4139:

Line 4138: x_return_status := fnd_api.g_ret_sts_error;

4134: exception
4135: when fnd_api.g_exc_error THEN
4136: rollback to inspect_main_intransit_sp;
4137:
4138: x_return_status := fnd_api.g_ret_sts_error;
4139:
4140: -- Get message count and data
4141: fnd_msg_pub.count_and_get
4142: ( p_count => x_msg_count

Line 4150: when fnd_api.g_exc_unexpected_error THEN

4146: IF (rtv_cursor%isopen) THEN
4147: CLOSE rtv_cursor;
4148: END IF;
4149:
4150: when fnd_api.g_exc_unexpected_error THEN
4151: rollback to inspect_main_intransit_sp;
4152:
4153: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4154:

Line 4153: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4149:
4150: when fnd_api.g_exc_unexpected_error THEN
4151: rollback to inspect_main_intransit_sp;
4152:
4153: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4154:
4155: -- Get message count and data
4156: fnd_msg_pub.count_and_get
4157: ( p_count => x_msg_count

Line 4168: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4164:
4165: when others THEN
4166: rollback to inspect_main_intransit_sp;
4167:
4168: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4169: --
4170: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4171: THEN
4172: fnd_msg_pub.add_exc_msg

Line 4337: x_return_status := fnd_api.g_ret_sts_success;

4333: and rt.transaction_type <> 'UNORDERED'
4334: and rt.routing_header_id = g_inspection_routing;
4335: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4336: begin
4337: x_return_status := fnd_api.g_ret_sts_success;
4338:
4339: -- dbms_output.put_line('main_process_rma: Just entering main_process_rma');
4340: --First check if the transaction date satisfies the validation.
4341: --If the transaction date is invalid then error out the transaction

Line 4359: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4355: , x_return_status => x_return_status
4356: , x_error_code => x_msg_data
4357: );
4358:
4359: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4360: RETURN;
4361: END IF;
4362:
4363: savepoint inspect_main_rma_sp;

Line 4526: IF l_return_status = fnd_api.g_ret_sts_error THEN

4522: , p_qa_collection_id => l_qa_collection_id
4523: , p_sec_uom => l_sec_uom --OPM Convergence
4524: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence);
4525:
4526: IF l_return_status = fnd_api.g_ret_sts_error THEN
4527: RAISE fnd_api.g_exc_error;
4528: END IF ;
4529:
4530: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 4527: RAISE fnd_api.g_exc_error;

4523: , p_sec_uom => l_sec_uom --OPM Convergence
4524: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence);
4525:
4526: IF l_return_status = fnd_api.g_ret_sts_error THEN
4527: RAISE fnd_api.g_exc_error;
4528: END IF ;
4529:
4530: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4531: RAISE fnd_api.g_exc_unexpected_error;

Line 4530: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4526: IF l_return_status = fnd_api.g_ret_sts_error THEN
4527: RAISE fnd_api.g_exc_error;
4528: END IF ;
4529:
4530: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4531: RAISE fnd_api.g_exc_unexpected_error;
4532: END IF;
4533:
4534: -- dbms_output.put_line('main_process_rma: Successful insert_inspect_rec_rti');

Line 4531: RAISE fnd_api.g_exc_unexpected_error;

4527: RAISE fnd_api.g_exc_error;
4528: END IF ;
4529:
4530: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4531: RAISE fnd_api.g_exc_unexpected_error;
4532: END IF;
4533:
4534: -- dbms_output.put_line('main_process_rma: Successful insert_inspect_rec_rti');
4535:

Line 4544: RAISE FND_API.G_EXC_ERROR;

4540:
4541: IF l_remaining_qty > 0 THEN
4542: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
4543: FND_MSG_PUB.Add;
4544: RAISE FND_API.G_EXC_ERROR;
4545: END IF;
4546:
4547: close rtv_cursor;
4548:

Line 4550: when fnd_api.g_exc_error THEN

4546:
4547: close rtv_cursor;
4548:
4549: exception
4550: when fnd_api.g_exc_error THEN
4551: rollback to inspect_main_rma_sp;
4552:
4553: x_return_status := fnd_api.g_ret_sts_error;
4554:

Line 4553: x_return_status := fnd_api.g_ret_sts_error;

4549: exception
4550: when fnd_api.g_exc_error THEN
4551: rollback to inspect_main_rma_sp;
4552:
4553: x_return_status := fnd_api.g_ret_sts_error;
4554:
4555: -- Get message count and data
4556: fnd_msg_pub.count_and_get
4557: ( p_count => x_msg_count

Line 4565: when fnd_api.g_exc_unexpected_error THEN

4561: IF (rtv_cursor%isopen) THEN
4562: CLOSE rtv_cursor;
4563: END IF;
4564:
4565: when fnd_api.g_exc_unexpected_error THEN
4566: rollback to inspect_main_rma_sp;
4567:
4568: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4569:

Line 4568: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4564:
4565: when fnd_api.g_exc_unexpected_error THEN
4566: rollback to inspect_main_rma_sp;
4567:
4568: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4569:
4570: -- Get message count and data
4571: fnd_msg_pub.count_and_get
4572: ( p_count => x_msg_count

Line 4583: x_return_status := fnd_api.g_ret_sts_unexp_error ;

4579:
4580: when others THEN
4581: rollback to inspect_main_rma_sp;
4582:
4583: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4584: --
4585: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4586: THEN
4587: fnd_msg_pub.add_exc_msg

Line 4750: x_return_status := fnd_api.g_ret_sts_success;

4746: and rt.transaction_type <> 'UNORDERED'
4747: and rt.routing_header_id = g_inspection_routing;
4748: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4749: begin
4750: x_return_status := fnd_api.g_ret_sts_success;
4751:
4752: -- dbms_output.put_line('main_process_receipt: Just entering main_process_receipt');
4753: --First check if the transaction date satisfies the validation.
4754: --If the transaction date is invalid then error out the transaction

Line 4772: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4768: , x_return_status => x_return_status
4769: , x_error_code => x_msg_data
4770: );
4771:
4772: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4773: RETURN;
4774: END IF;
4775:
4776: savepoint inspect_main_receipt_sp;

Line 4952: IF l_return_status = fnd_api.g_ret_sts_error THEN

4948: , p_qa_collection_id => l_qa_collection_id ,
4949: p_sec_uom => l_sec_uom --OPM Convergence
4950: , p_secondary_qty => l_rtv_sec_qty); --OPM Convergence
4951:
4952: IF l_return_status = fnd_api.g_ret_sts_error THEN
4953: IF (l_debug = 1) THEN
4954: print_debug('exc_error ' || l_return_status, 4);
4955: END IF;
4956: RAISE fnd_api.g_exc_error;

Line 4956: RAISE fnd_api.g_exc_error;

4952: IF l_return_status = fnd_api.g_ret_sts_error THEN
4953: IF (l_debug = 1) THEN
4954: print_debug('exc_error ' || l_return_status, 4);
4955: END IF;
4956: RAISE fnd_api.g_exc_error;
4957: END IF ;
4958:
4959: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4960: IF (l_debug = 1) THEN

Line 4959: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

4955: END IF;
4956: RAISE fnd_api.g_exc_error;
4957: END IF ;
4958:
4959: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4960: IF (l_debug = 1) THEN
4961: print_debug('exc_unexpected_error ' || l_return_status, 4);
4962: END IF;
4963: RAISE fnd_api.g_exc_unexpected_error;

Line 4963: RAISE fnd_api.g_exc_unexpected_error;

4959: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
4960: IF (l_debug = 1) THEN
4961: print_debug('exc_unexpected_error ' || l_return_status, 4);
4962: END IF;
4963: RAISE fnd_api.g_exc_unexpected_error;
4964: END IF;
4965:
4966: -- dbms_output.put_line('main_process_receipt: Successful insert_inspect_rec_rti');
4967:

Line 4982: RAISE FND_API.G_EXC_ERROR;

4978:
4979: IF l_remaining_qty > 0 THEN
4980: FND_MESSAGE.set_name('INV','INV_QTY_LESS_OR_EQUAL');
4981: FND_MSG_PUB.Add;
4982: RAISE FND_API.G_EXC_ERROR;
4983: END IF;
4984:
4985: close rtv_cursor;
4986:

Line 4988: when fnd_api.g_exc_error THEN

4984:
4985: close rtv_cursor;
4986:
4987: exception
4988: when fnd_api.g_exc_error THEN
4989: IF (l_debug = 1) THEN
4990: print_debug('Jumped to Exception exc_error ', 4);
4991: END IF;
4992: rollback to inspect_main_receipt_sp;

Line 4994: x_return_status := fnd_api.g_ret_sts_error;

4990: print_debug('Jumped to Exception exc_error ', 4);
4991: END IF;
4992: rollback to inspect_main_receipt_sp;
4993:
4994: x_return_status := fnd_api.g_ret_sts_error;
4995: IF (l_debug = 1) THEN
4996: print_debug('Jumped to Exception exc_error ' || x_return_status, 4);
4997: END IF;
4998:

Line 5009: when fnd_api.g_exc_unexpected_error THEN

5005: IF (rtv_cursor%isopen) THEN
5006: CLOSE rtv_cursor;
5007: END IF;
5008:
5009: when fnd_api.g_exc_unexpected_error THEN
5010: IF (l_debug = 1) THEN
5011: print_debug('Jumped to Exception unexpected_exc_error ', 4);
5012: END IF;
5013: rollback to inspect_main_receipt_sp;

Line 5015: x_return_status := fnd_api.g_ret_sts_unexp_error ;

5011: print_debug('Jumped to Exception unexpected_exc_error ', 4);
5012: END IF;
5013: rollback to inspect_main_receipt_sp;
5014:
5015: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5016: IF (l_debug = 1) THEN
5017: print_debug('Jumped to Exception unexpected_exc_error ' || x_return_status, 4);
5018: END IF;
5019:

Line 5036: x_return_status := fnd_api.g_ret_sts_unexp_error ;

5032: print_debug('Jumped to Exception others', 4);
5033: END IF;
5034: rollback to inspect_main_receipt_sp;
5035:
5036: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5037: IF (l_debug = 1) THEN
5038: print_debug('Jumped to Exception others' || x_return_status, 4);
5039: END IF;
5040: --

Line 5216: x_return_status := fnd_api.g_ret_sts_success;

5212:
5213: l_operating_unit_id MO_GLOB_ORG_ACCESS_TMP.ORGANIZATION_ID%TYPE; --
5214:
5215: begin
5216: x_return_status := fnd_api.g_ret_sts_success;
5217:
5218: savepoint insert_rti_sp;
5219:
5220: SELECT

Line 5734: when fnd_api.g_exc_error THEN

5730: --setting product_transaction_id for the MTLI/MSNI records
5731: g_interface_transaction_id := l_interface_transaction_id;
5732:
5733: exception
5734: when fnd_api.g_exc_error THEN
5735: rollback to insert_rti_sp;
5736:
5737: x_return_status := fnd_api.g_ret_sts_error;
5738:

Line 5737: x_return_status := fnd_api.g_ret_sts_error;

5733: exception
5734: when fnd_api.g_exc_error THEN
5735: rollback to insert_rti_sp;
5736:
5737: x_return_status := fnd_api.g_ret_sts_error;
5738:
5739: -- Get message count and data
5740: fnd_msg_pub.count_and_get
5741: ( p_count => x_msg_count

Line 5745: when fnd_api.g_exc_unexpected_error THEN

5741: ( p_count => x_msg_count
5742: , p_data => x_msg_data
5743: );
5744:
5745: when fnd_api.g_exc_unexpected_error THEN
5746: rollback to insert_rti_sp;
5747:
5748: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5749:

Line 5748: x_return_status := fnd_api.g_ret_sts_unexp_error ;

5744:
5745: when fnd_api.g_exc_unexpected_error THEN
5746: rollback to insert_rti_sp;
5747:
5748: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5749:
5750: -- Get message count and data
5751: fnd_msg_pub.count_and_get
5752: ( p_count => x_msg_count

Line 5759: x_return_status := fnd_api.g_ret_sts_unexp_error ;

5755:
5756: when others THEN
5757: rollback to insert_rti_sp;
5758:
5759: x_return_status := fnd_api.g_ret_sts_unexp_error ;
5760: --
5761: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
5762: THEN
5763: fnd_msg_pub.add_exc_msg

Line 5810: x_return_status := fnd_api.g_ret_sts_success;

5806: r_val20 varchar2(200) := NULL;
5807:
5808: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5809: begin
5810: x_return_status := fnd_api.g_ret_sts_success;
5811:
5812: /*
5813: dbms_output.put_line('rcv_mgr_rpc_call: group_id '
5814: || inv_RCV_COMMON_APIS.g_rcv_global_var.interface_group_id);

Line 5837: x_return_status := fnd_api.g_ret_sts_error;

5833:
5834: IF (rc = 0 and (l_outcome NOT IN ('WARNING', 'ERROR'))) THEN
5835: NULL;
5836: ELSIF (rc = 1) THEN
5837: x_return_status := fnd_api.g_ret_sts_error;
5838: ELSIF (rc = 2) THEN
5839: x_return_status := fnd_api.g_ret_sts_error;
5840: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
5841: x_return_status := fnd_api.g_ret_sts_error;

Line 5839: x_return_status := fnd_api.g_ret_sts_error;

5835: NULL;
5836: ELSIF (rc = 1) THEN
5837: x_return_status := fnd_api.g_ret_sts_error;
5838: ELSIF (rc = 2) THEN
5839: x_return_status := fnd_api.g_ret_sts_error;
5840: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
5841: x_return_status := fnd_api.g_ret_sts_error;
5842:
5843: rc := fnd_transaction.get_values (

Line 5841: x_return_status := fnd_api.g_ret_sts_error;

5837: x_return_status := fnd_api.g_ret_sts_error;
5838: ELSIF (rc = 2) THEN
5839: x_return_status := fnd_api.g_ret_sts_error;
5840: ELSIF (rc = 3 or (l_outcome IN ('WARNING', 'ERROR'))) THEN
5841: x_return_status := fnd_api.g_ret_sts_error;
5842:
5843: rc := fnd_transaction.get_values (
5844: r_val1, r_val2, r_val3, r_val4, r_val5,
5845: r_val6, r_val7, r_val8, r_val9, r_val10,

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

5884:
5885: PROCEDURE launch_rcv_manager_rpc(
5886: x_return_status OUT NOCOPY VARCHAR2
5887: , x_return_code OUT NOCOPY NUMBER) IS
5888: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
5889: l_msg_count NUMBER;
5890: l_msg_data VARCHAR2(400);
5891: l_label_status VARCHAR2(500);
5892: l_txn_id_tbl inv_label.transaction_id_rec_type;

Line 5947: IF l_return_status <> fnd_api.g_ret_sts_success THEN

5943: , p_business_flow_code => 2
5944: , p_transaction_id => l_txn_id_tbl
5945: );
5946:
5947: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5948: fnd_message.set_name('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
5949: fnd_msg_pub.ADD;
5950: x_return_status := 'W';
5951:

Line 5983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

5979: print_debug('return status is launch procedure ' || x_return_status, 4);
5980: print_debug('return msg data l_msg_data: ' || l_msg_data, 4);
5981: END IF;
5982:
5983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5984: IF (l_debug = 1) THEN
5985: 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);
5986: END IF;
5987: RAISE FND_API.G_EXC_ERROR;

Line 5987: RAISE FND_API.G_EXC_ERROR;

5983: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
5984: IF (l_debug = 1) THEN
5985: 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);
5986: END IF;
5987: RAISE FND_API.G_EXC_ERROR;
5988: END IF;
5989:
5990: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5991: IF (l_debug = 1) THEN

Line 5990: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

5986: END IF;
5987: RAISE FND_API.G_EXC_ERROR;
5988: END IF;
5989:
5990: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5991: IF (l_debug = 1) THEN
5992: 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);
5993: END IF;
5994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 5994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

5990: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5991: IF (l_debug = 1) THEN
5992: 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);
5993: END IF;
5994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5995: END IF;
5996:
5997: EXCEPTION
5998: WHEN fnd_api.g_exc_error THEN

Line 5998: WHEN fnd_api.g_exc_error THEN

5994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5995: END IF;
5996:
5997: EXCEPTION
5998: WHEN fnd_api.g_exc_error THEN
5999: x_return_status := fnd_api.g_ret_sts_error;
6000: IF (c_rti_txn_id%ISOPEN) THEN
6001: CLOSE c_rti_txn_id;
6002: END IF;

Line 5999: x_return_status := fnd_api.g_ret_sts_error;

5995: END IF;
5996:
5997: EXCEPTION
5998: WHEN fnd_api.g_exc_error THEN
5999: x_return_status := fnd_api.g_ret_sts_error;
6000: IF (c_rti_txn_id%ISOPEN) THEN
6001: CLOSE c_rti_txn_id;
6002: END IF;
6003: WHEN fnd_api.g_exc_unexpected_error THEN

Line 6003: WHEN fnd_api.g_exc_unexpected_error THEN

5999: x_return_status := fnd_api.g_ret_sts_error;
6000: IF (c_rti_txn_id%ISOPEN) THEN
6001: CLOSE c_rti_txn_id;
6002: END IF;
6003: WHEN fnd_api.g_exc_unexpected_error THEN
6004: x_return_status := fnd_api.g_ret_sts_unexp_error;
6005: IF (c_rti_txn_id%ISOPEN) THEN
6006: CLOSE c_rti_txn_id;
6007: END IF;

Line 6004: x_return_status := fnd_api.g_ret_sts_unexp_error;

6000: IF (c_rti_txn_id%ISOPEN) THEN
6001: CLOSE c_rti_txn_id;
6002: END IF;
6003: WHEN fnd_api.g_exc_unexpected_error THEN
6004: x_return_status := fnd_api.g_ret_sts_unexp_error;
6005: IF (c_rti_txn_id%ISOPEN) THEN
6006: CLOSE c_rti_txn_id;
6007: END IF;
6008: WHEN OTHERS THEN

Line 6009: x_return_status := fnd_api.g_ret_sts_unexp_error;

6005: IF (c_rti_txn_id%ISOPEN) THEN
6006: CLOSE c_rti_txn_id;
6007: END IF;
6008: WHEN OTHERS THEN
6009: x_return_status := fnd_api.g_ret_sts_unexp_error;
6010: IF (c_rti_txn_id%ISOPEN) THEN
6011: CLOSE c_rti_txn_id;
6012: END IF;
6013: END launch_rcv_manager_rpc;

Line 6321: x_return_status := fnd_api.g_ret_sts_success;

6317: END IF;
6318: END IF;
6319:
6320: x_inspection_qty := l_total_qty;
6321: x_return_status := fnd_api.g_ret_sts_success;
6322:
6323: return x_inspection_qty;
6324:
6325: EXCEPTION

Line 6326: when fnd_api.g_exc_error THEN

6322:
6323: return x_inspection_qty;
6324:
6325: EXCEPTION
6326: when fnd_api.g_exc_error THEN
6327: x_return_status := fnd_api.g_ret_sts_error;
6328: -- Get message count and data
6329: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
6330: print_debug('***Execution error occured***', 4);

Line 6327: x_return_status := fnd_api.g_ret_sts_error;

6323: return x_inspection_qty;
6324:
6325: EXCEPTION
6326: when fnd_api.g_exc_error THEN
6327: x_return_status := fnd_api.g_ret_sts_error;
6328: -- Get message count and data
6329: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
6330: print_debug('***Execution error occured***', 4);
6331: return 0; --Bug #3908752

Line 6332: when fnd_api.g_exc_unexpected_error THEN

6328: -- Get message count and data
6329: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
6330: print_debug('***Execution error occured***', 4);
6331: return 0; --Bug #3908752
6332: when fnd_api.g_exc_unexpected_error THEN
6333: x_return_status := fnd_api.g_ret_sts_unexp_error;
6334: -- Get message count and data
6335: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
6336: print_debug('***Unexpected error occured***', 4);

Line 6333: x_return_status := fnd_api.g_ret_sts_unexp_error;

6329: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
6330: print_debug('***Execution error occured***', 4);
6331: return 0; --Bug #3908752
6332: when fnd_api.g_exc_unexpected_error THEN
6333: x_return_status := fnd_api.g_ret_sts_unexp_error;
6334: -- Get message count and data
6335: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
6336: print_debug('***Unexpected error occured***', 4);
6337: return 0;

Line 6339: x_return_status := fnd_api.g_ret_sts_unexp_error ;

6335: fnd_msg_pub.count_and_get ( p_count => l_msg_count , p_data => x_msg_data);
6336: print_debug('***Unexpected error occured***', 4);
6337: return 0;
6338: when others THEN
6339: x_return_status := fnd_api.g_ret_sts_unexp_error ;
6340: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
6341: THEN
6342: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'get_inspection_qty');
6343: END IF;