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_RESERVATION_UTIL dependencies on FND_API

Line 71: x_return_status := fnd_api.g_ret_sts_success;

67: print_debug(' p_mol_id => ' ||p_mol_id,l_module_name,4);
68: print_debug(' p_released_status => ' ||p_released_status,l_module_name,4);
69: END IF;
70:
71: x_return_status := fnd_api.g_ret_sts_success;
72:
73: l_progress := '@@@';
74:
75: l_detail_info_tab(1).delivery_detail_id := p_wdd_id;

Line 105: p_init_msg_list => fnd_api.g_false,

101:
102: l_progress := '@@@';
103: wsh_interface_ext_grp.create_update_delivery_detail
104: (p_api_version_number => 1.0,
105: p_init_msg_list => fnd_api.g_false,
106: p_commit => fnd_api.g_false,
107: x_return_status => l_return_status,
108: x_msg_count => l_msg_count,
109: x_msg_data => l_msg_data,

Line 106: p_commit => fnd_api.g_false,

102: l_progress := '@@@';
103: wsh_interface_ext_grp.create_update_delivery_detail
104: (p_api_version_number => 1.0,
105: p_init_msg_list => fnd_api.g_false,
106: p_commit => fnd_api.g_false,
107: x_return_status => l_return_status,
108: x_msg_count => l_msg_count,
109: x_msg_data => l_msg_data,
110: p_detail_info_tab => l_detail_info_tab,

Line 120: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

116: print_debug('Returned from wsh_interface_ext_grp.create_update_delivery_detail',l_module_name,4);
117: print_debug('l_return_status =>'||l_return_status,l_module_name,4);
118: END IF;
119:
120: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
121: l_progress := '@@@';
122: IF (l_debug = 1) THEN
123: print_debug('wsh_interface_ext_grp.create_update_delivery_detail returned with error',l_module_name,4);
124: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 128: RAISE fnd_api.g_exc_unexpected_error;

124: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
125: print_debug('Raising Exception!!!',l_module_name,4);
126: END IF;
127: l_progress := '@@@';
128: RAISE fnd_api.g_exc_unexpected_error;
129: ELSE
130: IF (l_debug = 1) THEN
131: print_debug('wsh_interface_ext_grp.create_update_delivery_detail returned with success',l_module_name,4);
132: END IF;

Line 148: x_return_status := fnd_api.g_ret_sts_error;

144: IF (l_debug = 1) THEN
145: print_debug('Exception occurred at progress:'||l_progress,l_module_name,4);
146: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
147: END IF;
148: x_return_status := fnd_api.g_ret_sts_error;
149: END update_wdd;
150:
151: PROCEDURE split_wdd
152: (x_return_status OUT NOCOPY VARCHAR2

Line 176: x_return_status := fnd_api.g_ret_sts_success;

172:
173: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
174: l_progress := '10';
175: l_module_name := 'SPLIT_WDD';
176: x_return_status := fnd_api.g_ret_sts_success;
177:
178: IF (l_debug = 1) THEN
179: print_debug('Entering split_wdd...',l_module_name,4);
180: print_debug(' p_wdd_id => ' ||p_wdd_id,l_module_name,4);

Line 200: p_init_msg_list => fnd_api.g_false,

196: END IF;
197:
198: wsh_interface_grp.delivery_detail_action
199: (p_api_version_number => 1.0,
200: p_init_msg_list => fnd_api.g_false,
201: p_commit => fnd_api.g_false,
202: x_return_status => l_return_status,
203: x_msg_count => l_msg_count,
204: x_msg_data => l_msg_data,

Line 201: p_commit => fnd_api.g_false,

197:
198: wsh_interface_grp.delivery_detail_action
199: (p_api_version_number => 1.0,
200: p_init_msg_list => fnd_api.g_false,
201: p_commit => fnd_api.g_false,
202: x_return_status => l_return_status,
203: x_msg_count => l_msg_count,
204: x_msg_data => l_msg_data,
205: p_detail_id_tab => l_detail_ids,

Line 216: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

212: print_debug('Returned from wsh_interface_grp.delivery_detail_action',l_module_name,4);
213: print_debug('l_return_status =>'||l_return_status,l_module_name,4);
214: END IF;
215:
216: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
217: IF (l_debug = 1) THEN
218: print_debug('wsh_interface_grp.delivery_detail_action returned with error',l_module_name,4);
219: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
220: print_debug('Raising Exception!!!',l_module_name,4);

Line 223: RAISE fnd_api.g_exc_unexpected_error;

219: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
220: print_debug('Raising Exception!!!',l_module_name,4);
221: END IF;
222: l_progress := '@@@';
223: RAISE fnd_api.g_exc_unexpected_error;
224: ELSE
225: l_progress := '@@@';
226:
227: l_tmp := l_action_out_rec.result_id_tab.first;

Line 261: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

257: print_debug('Returned from update_wdd',l_module_name,4);
258: print_debug('l_return_status =>'||l_return_status,l_module_name,4);
259: END IF;
260:
261: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
262: l_progress := '@@@';
263: IF (l_debug = 1) THEN
264: print_debug('update_wdd returned with error',l_module_name,4);
265: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 269: RAISE fnd_api.g_exc_unexpected_error;

265: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
266: print_debug('Raising Exception!!!',l_module_name,4);
267: END IF;
268: l_progress := '@@@';
269: RAISE fnd_api.g_exc_unexpected_error;
270: ELSE
271: IF (l_debug = 1) THEN
272: print_debug('update_wdd returned with success',l_module_name,4);
273: END IF;

Line 291: x_return_status := fnd_api.g_ret_sts_error;

287: IF (l_debug = 1) THEN
288: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
289: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
290: END IF;
291: x_return_status := fnd_api.g_ret_sts_error;
292: END split_wdd;
293:
294: PROCEDURE query_reservation
295: (p_query_input IN inv_reservation_global.mtl_reservation_rec_type

Line 315: x_return_status := fnd_api.g_ret_sts_success;

311:
312: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
313: l_progress := '10';
314: l_module_name := 'QUERY_RESERVATION';
315: x_return_status := fnd_api.g_ret_sts_success;
316:
317: IF NOT wms_install.check_install(l_return_status,
318: l_msg_count,
319: l_msg_data,

Line 337: , p_lock_records => fnd_api.g_true --???

333: , x_return_status => l_return_status
334: , x_msg_count => l_msg_count
335: , x_msg_data => l_msg_data
336: , p_query_input => p_query_input
337: , p_lock_records => fnd_api.g_true --???
338: , p_sort_by_req_date => p_sort_by_req_date
339: , x_mtl_reservation_tbl => x_rsv_results
340: , x_mtl_reservation_tbl_count => l_rsv_results_count
341: , x_error_code => l_error_code

Line 349: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

345: print_debug('Returned from inv_reservation_pub.query_reservation',l_module_name,4);
346: print_debug('x_return_status: '||l_return_status,l_module_name,4);
347: END IF;
348:
349: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
350: IF (l_debug = 1) THEN
351: print_debug('x_error_code: '||l_error_code,l_module_name,4);
352: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
353: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);

Line 358: RAISE fnd_api.g_exc_unexpected_error;

354: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
355: print_debug('Raising Exception!!!',l_module_name,4);
356: END IF;
357: l_progress := '@@@';
358: RAISE fnd_api.g_exc_unexpected_error;
359: END IF;
360:
361: l_progress := '@@@';
362:

Line 376: x_return_status := fnd_api.g_ret_sts_error;

372: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
373: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
374: print_debug('Exiting query_reservation with error',l_module_name,4);
375: END IF;
376: x_return_status := fnd_api.g_ret_sts_error;
377: END query_reservation;
378:
379: PROCEDURE transfer_reservation
380: (p_original_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

Line 398: x_return_status := fnd_api.g_ret_sts_success;

394: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
395: l_progress := '10';
396: l_module_name := 'TRANSFER_RESERVATIONS';
397:
398: x_return_status := fnd_api.g_ret_sts_success;
399:
400: IF NOT wms_install.check_install(l_return_status,
401: l_msg_count,
402: l_msg_data,

Line 423: ,p_validation_flag => fnd_api.g_false --??

419: ,p_original_rsv_rec => p_original_rsv_rec
420: ,p_to_rsv_rec => p_to_rsv_rec
421: ,p_original_serial_number => l_dummy_serial
422: ,p_to_serial_number => l_dummy_serial
423: ,p_validation_flag => fnd_api.g_false --??
424: ,x_to_reservation_id => x_new_rsv_id);
425:
426: IF (l_debug = 1) THEN
427: print_debug('Returned from inv_reservation_pub.transfer_reservation',l_module_name,4);

Line 431: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

427: print_debug('Returned from inv_reservation_pub.transfer_reservation',l_module_name,4);
428: print_debug('x_return_status =>'||l_return_status,l_module_name,4);
429: END IF;
430:
431: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
432: IF (l_debug = 1) THEN
433: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
434: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
435: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 439: RAISE fnd_api.g_exc_unexpected_error;

435: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
436: print_debug('Raising Exception!!!',l_module_name,4);
437: END IF;
438: l_progress := '@@@';
439: RAISE fnd_api.g_exc_unexpected_error;
440: END IF;
441:
442: l_progress := '@@@';
443:

Line 454: x_return_status := fnd_api.g_ret_sts_error;

450: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
451: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
452: print_debug('Exiting transfer_reservation with error',l_module_name,4);
453: END IF;
454: x_return_status := fnd_api.g_ret_sts_error;
455: END transfer_reservation;
456:
457: PROCEDURE relieve_reservation
458: (p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

Line 481: x_return_status := fnd_api.g_ret_sts_success;

477: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
478: l_progress := '10';
479: l_module_name := 'RELIEVE_RESERVATIONS';
480:
481: x_return_status := fnd_api.g_ret_sts_success;
482:
483: IF NOT wms_install.check_install(l_return_status,
484: l_msg_count,
485: l_msg_data,

Line 495: print_debug(' p_relieve_all => '||fnd_api.g_false,l_module_name,4);

491: END IF;
492:
493: IF (l_debug = 1) THEN
494: print_debug('Calling inv_reservation_pub.relieve_reservation',l_module_name,4);
495: print_debug(' p_relieve_all => '||fnd_api.g_false,l_module_name,4);
496: print_debug(' p_primary_relieved_quantity => '||p_prim_qty_to_relieve,l_module_name,4);
497: END IF;
498:
499: inv_reservation_pub.relieve_reservation

Line 509: , p_relieve_all => fnd_api.g_false

505: , p_primary_relieved_quantity=> p_prim_qty_to_relieve
506: , p_original_serial_number => l_dummy_serial
507: , x_primary_relieved_quantity=> l_tmp_prim_relieved_qty
508: , x_primary_remain_quantity => l_tmp_prim_remain_qty
509: , p_relieve_all => fnd_api.g_false
510: );
511:
512: IF (l_debug = 1) THEN
513: print_debug('Returned from inv_reservation_pub.query_reservation',l_module_name,4);

Line 517: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

513: print_debug('Returned from inv_reservation_pub.query_reservation',l_module_name,4);
514: print_debug('x_return_status: '||l_return_status,l_module_name,4);
515: END IF;
516:
517: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
518: IF (l_debug = 1) THEN
519: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
520: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
521: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 525: RAISE fnd_api.g_exc_unexpected_error;

521: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
522: print_debug('Raising Exception!!!',l_module_name,4);
523: END IF;
524: l_progress := '@@@';
525: RAISE fnd_api.g_exc_unexpected_error;
526: END IF;
527:
528: l_progress := '@@@';
529:

Line 543: x_return_status := fnd_api.g_ret_sts_error;

539: print_debug('Exception occurred at progress:'||l_progress,l_module_name,4);
540: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
541: print_debug('Exiting relieve_reservation with success',l_module_name,4);
542: END IF;
543: x_return_status := fnd_api.g_ret_sts_error;
544: END relieve_reservation;
545:
546: PROCEDURE delete_reservation
547: (p_rsv_rec IN inv_reservation_global.mtl_reservation_rec_type

Line 593: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

589: print_debug('Returned from inv_reservation_pub.delete_reservation',l_module_name,4);
590: print_debug('x_return_status =>'||l_return_status,l_module_name,4);
591: END IF;
592:
593: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
594: IF (l_debug = 1) THEN
595: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
596: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
597: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 601: RAISE fnd_api.g_exc_unexpected_error;

597: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
598: print_debug('Raising Exception!!!',l_module_name,4);
599: END IF;
600: l_progress := '@@@';
601: RAISE fnd_api.g_exc_unexpected_error;
602: END IF;
603:
604: l_progress := '@@@';
605:

Line 616: x_return_status := fnd_api.g_ret_sts_error;

612: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
613: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
614: print_debug('Exiting delete_reservation with error',l_module_name,4);
615: END IF;
616: x_return_status := fnd_api.g_ret_sts_error;
617: END delete_reservation;
618:
619: PROCEDURE reduce_reservation
620: (p_mtl_rsv_rec IN inv_reservation_global.mtl_maintain_rsv_rec_type

Line 659: , p_delete_flag => fnd_api.g_true

655: , x_msg_count => l_msg_count
656: , x_msg_data => l_msg_data
657: , x_quantity_modified => l_qty_modified
658: , p_mtl_maintain_rsv_rec => p_mtl_rsv_rec
659: , p_delete_flag => fnd_api.g_true
660: , p_sort_by_criteria => g_query_demand_ship_date_desc --???
661: );
662: IF (l_debug = 1) THEN
663: print_debug('Returned from inv_maintain_reservations_pub.reduce_reservation',l_module_name,4);

Line 667: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

663: print_debug('Returned from inv_maintain_reservations_pub.reduce_reservation',l_module_name,4);
664: print_debug('x_return_status =>'||l_return_status,l_module_name,4);
665: END IF;
666:
667: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
668: IF (l_debug = 1) THEN
669: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
670: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
671: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 675: RAISE fnd_api.g_exc_unexpected_error;

671: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
672: print_debug('Raising Exception!!!',l_module_name,4);
673: END IF;
674: l_progress := '@@@';
675: RAISE fnd_api.g_exc_unexpected_error;
676: END IF;
677:
678: l_progress := '@@@';
679:

Line 691: x_return_status := fnd_api.g_ret_sts_error;

687: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
688: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
689: print_debug('Exiting reduce_reservation with error',l_module_name,4);
690: END IF;
691: x_return_status := fnd_api.g_ret_sts_error;
692: END reduce_reservation;
693:
694: --This will be called from maintain_rsv_receive
695: PROCEDURE set_mol_wdd_tbl

Line 795: RAISE fnd_api.g_exc_unexpected_error;

791: WHEN OTHERS THEN
792: IF (l_debug = 1) THEN
793: print_debug('Error in set_mol_wdd_tbl...',l_module_name,4);
794: END IF;
795: RAISE fnd_api.g_exc_unexpected_error;
796: END set_mol_wdd_tbl;
797:
798: PROCEDURE maintain_rsv_import_asn
799: (x_return_status OUT NOCOPY VARCHAR2

Line 831: x_return_status := fnd_api.g_ret_sts_success;

827:
828: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
829: l_progress := '10';
830: l_module_name := 'maintain_rsv_import_asn';
831: x_return_status := fnd_api.g_ret_sts_success;
832:
833: IF (l_debug = 1) THEN
834: print_debug('Entering maintain_rsv_import_asn...',l_module_name,4);
835: print_debug(' p_cas_mol_rec_tb(1).po_header_id => '||p_cas_mol_rec_tb(1).po_header_id,l_module_name,4);

Line 880: RAISE fnd_api.g_exc_unexpected_error;

876: print_debug('Some other exception occurred!',l_module_name,4);
877: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
878: END IF;
879: l_progress := '@@@';
880: RAISE fnd_api.g_exc_unexpected_error;
881: END;
882: l_progress := '@@@';
883:
884: IF (l_debug = 1) THEN

Line 903: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

899: print_debug('Returned from query_reservation',l_module_name,4);
900: print_debug('x_return_status: '||l_return_status,l_module_name,4);
901: END IF;
902:
903: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
904: l_progress := '@@@';
905: RAISE fnd_api.g_exc_unexpected_error;
906: END IF;
907:

Line 905: RAISE fnd_api.g_exc_unexpected_error;

901: END IF;
902:
903: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
904: l_progress := '@@@';
905: RAISE fnd_api.g_exc_unexpected_error;
906: END IF;
907:
908: l_remaining_prim_qty := p_cas_mol_rec_tb(1).primary_qty;
909:

Line 968: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

964: print_debug('Returned from split_wdd',l_module_name,4);
965: print_debug('l_return_status =>'||l_return_status,l_module_name,4);
966: END IF;
967:
968: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
969: l_progress := '@@@';
970: RAISE fnd_api.g_exc_unexpected_error;
971: END IF;
972:

Line 970: RAISE fnd_api.g_exc_unexpected_error;

966: END IF;
967:
968: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
969: l_progress := '@@@';
970: RAISE fnd_api.g_exc_unexpected_error;
971: END IF;
972:
973: l_rsv_update_rec.demand_source_line_detail := l_new_wdd_id;
974: END IF;

Line 1005: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1001: print_debug('Returned from transfer_reservation',l_module_name,4);
1002: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1003: END IF;
1004:
1005: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1006: l_progress := '@@@';
1007: RAISE fnd_api.g_exc_unexpected_error;
1008: END IF;
1009:

Line 1007: RAISE fnd_api.g_exc_unexpected_error;

1003: END IF;
1004:
1005: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1006: l_progress := '@@@';
1007: RAISE fnd_api.g_exc_unexpected_error;
1008: END IF;
1009:
1010: IF (l_debug = 1) THEN
1011: print_debug('l_reservation_id: '||l_reservation_id,l_module_name,4);

Line 1031: x_return_status := fnd_api.g_ret_sts_error;

1027: IF (l_debug = 1) THEN
1028: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
1029: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1030: END IF;
1031: x_return_status := fnd_api.g_ret_sts_error;
1032: END maintain_rsv_import_asn;
1033:
1034: PROCEDURE maintain_rsv_cancel_asn
1035: (x_return_status OUT NOCOPY VARCHAR2

Line 1063: x_return_status := fnd_api.g_ret_sts_success;

1059:
1060: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1061: l_progress := '10';
1062: l_module_name := 'MAINTAIN_RSV_CANCEL_ASN';
1063: x_return_status := fnd_api.g_ret_sts_success;
1064:
1065: IF (l_debug = 1) THEN
1066: print_debug('Entering maintain_rsv_cancel_asn...',l_module_name,4);
1067: print_debug(' p_cas_mol_rec_tb(1).po_header_id => '||p_cas_mol_rec_tb(1).po_header_id,l_module_name,4);

Line 1112: RAISE fnd_api.g_exc_unexpected_error;

1108: print_debug('Some other exception occurred!',l_module_name,4);
1109: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1110: END IF;
1111: l_progress := '@@@';
1112: RAISE fnd_api.g_exc_unexpected_error;
1113: END;
1114: l_progress := '@@@';
1115:
1116: IF (l_debug = 1) THEN

Line 1129: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1125: ,x_return_status => l_return_status
1126: );
1127: l_progress := '###';
1128:
1129: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1130: l_progress := '@@@';
1131: RAISE fnd_api.g_exc_unexpected_error;
1132: END IF;
1133:

Line 1131: RAISE fnd_api.g_exc_unexpected_error;

1127: l_progress := '###';
1128:
1129: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1130: l_progress := '@@@';
1131: RAISE fnd_api.g_exc_unexpected_error;
1132: END IF;
1133:
1134: IF (l_debug = 1) THEN
1135: print_debug('l_rsv_results_tbl.COUNT = ' ||l_rsv_results_tbl.COUNT,l_module_name,4);

Line 1169: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1165: print_debug('Returned from delete_reservation',l_module_name,4);
1166: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1167: END IF;
1168:
1169: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1170: IF (l_debug = 1) THEN
1171: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1172: print_debug('Raising Exception!!!',l_module_name,4);
1173: END IF;

Line 1175: RAISE fnd_api.g_exc_unexpected_error;

1171: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1172: print_debug('Raising Exception!!!',l_module_name,4);
1173: END IF;
1174: l_progress := '@@@';
1175: RAISE fnd_api.g_exc_unexpected_error;
1176: END IF;
1177: ELSE --IF this is a manual rsv transferred from PO
1178: l_rsv_update_rec := l_rsv_results_tbl(i);
1179: l_rsv_update_rec.supply_source_type_id := g_source_type_po;

Line 1197: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1193: print_debug('Returned from transfer_reservation',l_module_name,4);
1194: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1195: END IF;
1196:
1197: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1198: l_progress := '@@@';
1199: RAISE fnd_api.g_exc_unexpected_error;
1200: END IF;
1201:

Line 1199: RAISE fnd_api.g_exc_unexpected_error;

1195: END IF;
1196:
1197: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1198: l_progress := '@@@';
1199: RAISE fnd_api.g_exc_unexpected_error;
1200: END IF;
1201:
1202: IF (l_debug = 1) THEN
1203: print_debug('l_reservation_id: '||l_reservation_id,l_module_name,4);

Line 1224: x_return_status := fnd_api.g_ret_sts_error;

1220: IF (l_debug = 1) THEN
1221: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
1222: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1223: END IF;
1224: x_return_status := fnd_api.g_ret_sts_error;
1225: END maintain_rsv_cancel_asn;
1226:
1227: PROCEDURE maintain_rsv_receive
1228: (x_return_status OUT NOCOPY VARCHAR2

Line 1267: x_return_status := fnd_api.g_ret_sts_success;

1263:
1264: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1265: l_progress := '10';
1266: l_module_name := 'MAINTAIN_RSV_RECEIVE';
1267: x_return_status := fnd_api.g_ret_sts_success;
1268:
1269: IF (l_debug = 1) THEN
1270: print_debug('Entering maintain_rsv_receive...',l_module_name,4);
1271: print_debug(' p_cas_mol_rec_tb(1).inventory_item_id => '||p_cas_mol_rec_tb(1).inventory_item_id,l_module_name,4);

Line 1318: RAISE fnd_api.g_exc_unexpected_error;

1314: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1315: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1316: END IF;
1317: l_progress := '###';
1318: RAISE fnd_api.g_exc_unexpected_error;
1319: END;
1320: l_progress := '###';
1321: ELSE --asn_line_flag = 'Y' THEN
1322: IF (l_debug = 1) THEN

Line 1344: RAISE fnd_api.g_exc_unexpected_error;

1340: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1341: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1342: END IF;
1343: l_progress := '###';
1344: RAISE fnd_api.g_exc_unexpected_error;
1345: END;
1346: l_progress := '###';
1347: END IF;
1348:

Line 1374: RAISE fnd_api.g_exc_unexpected_error;

1370: IF (l_debug = 1) THEN
1371: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1372: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1373: END IF;
1374: RAISE fnd_api.g_exc_unexpected_error;
1375: END;
1376: l_progress := '###';
1377:
1378: l_rsv_query_rec.supply_source_type_id := g_source_type_internal_req;

Line 1401: RAISE fnd_api.g_exc_unexpected_error;

1397: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1398: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1399: END IF;
1400: l_progress := '###';
1401: RAISE fnd_api.g_exc_unexpected_error;
1402: END;
1403: l_progress := '###';
1404:
1405: l_rsv_query_rec.supply_source_type_id := g_source_type_in_transit;

Line 1451: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1447: ,x_return_status => l_return_status
1448: );
1449: l_progress := '###';
1450:
1451: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1452: l_progress := '@@@';
1453: RAISE fnd_api.g_exc_unexpected_error;
1454: END IF;
1455:

Line 1453: RAISE fnd_api.g_exc_unexpected_error;

1449: l_progress := '###';
1450:
1451: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1452: l_progress := '@@@';
1453: RAISE fnd_api.g_exc_unexpected_error;
1454: END IF;
1455:
1456: --3.0 Process reservations
1457: l_remaining_prim_qty := l_primary_qty;

Line 1531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1527: print_debug('Returned from delete_reservation',l_module_name,4);
1528: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1529: END IF;
1530:
1531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1532: l_progress := '@@@';
1533: RAISE fnd_api.g_exc_unexpected_error;
1534: END IF;
1535:

Line 1533: RAISE fnd_api.g_exc_unexpected_error;

1529: END IF;
1530:
1531: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1532: l_progress := '@@@';
1533: RAISE fnd_api.g_exc_unexpected_error;
1534: END IF;
1535:
1536:
1537: --{{

Line 1593: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1589: print_debug('Returned from split_wdd',l_module_name,4);
1590: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1591: END IF;
1592:
1593: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1594: l_progress := '@@@';
1595: RAISE fnd_api.g_exc_unexpected_error;
1596: END IF;
1597:

Line 1595: RAISE fnd_api.g_exc_unexpected_error;

1591: END IF;
1592:
1593: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1594: l_progress := '@@@';
1595: RAISE fnd_api.g_exc_unexpected_error;
1596: END IF;
1597:
1598: IF (l_debug = 1) THEN
1599: print_debug('l_new_wdd_id: '||l_new_wdd_id,l_module_name,4);

Line 1662: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1658: ,p_mol_id => NULL
1659: );
1660: l_progress := '@@@';
1661:
1662: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1663: l_progress := '@@@';
1664: RAISE fnd_api.g_exc_unexpected_error;
1665: END IF;
1666:

Line 1664: RAISE fnd_api.g_exc_unexpected_error;

1660: l_progress := '@@@';
1661:
1662: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1663: l_progress := '@@@';
1664: RAISE fnd_api.g_exc_unexpected_error;
1665: END IF;
1666:
1667: l_rsv_update_rec.demand_source_line_detail := NULL;
1668: END IF;

Line 1696: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1692: ,x_new_rsv_id => l_new_rsv_id
1693: ,x_return_status => l_return_status);
1694: l_progress := '@@@';
1695:
1696: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1697: l_progress := '@@@';
1698: RAISE fnd_api.g_exc_unexpected_error;
1699: END IF;
1700:

Line 1698: RAISE fnd_api.g_exc_unexpected_error;

1694: l_progress := '@@@';
1695:
1696: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1697: l_progress := '@@@';
1698: RAISE fnd_api.g_exc_unexpected_error;
1699: END IF;
1700:
1701: IF (l_debug = 1) THEN
1702: print_debug('l_new_rsv_id: '||l_new_rsv_id,l_module_name,4);

Line 1761: x_return_status := fnd_api.g_ret_sts_error;

1757: --********** END PROCEDURE maintain_rsv_receive *********}}
1758:
1759: EXCEPTION
1760: WHEN OTHERS THEN
1761: x_return_status := fnd_api.g_ret_sts_error;
1762: IF (l_debug = 1) THEN
1763: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
1764: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1765: print_debug('Exiting maintain_rsv_receive with error: '||l_progress,l_module_name,4);

Line 1810: x_return_status := fnd_api.g_ret_sts_success;

1806:
1807: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1808: l_progress := '10';
1809: l_module_name := 'MAINTAIN_RSV_DELIVER';
1810: x_return_status := fnd_api.g_ret_sts_success;
1811:
1812: IF (l_debug = 1) THEN
1813: print_debug('Entering maintain_rsv_deliver...',l_module_name,4);
1814: print_debug(' p_cas_mol_rec_tb(1).line_id => '||p_cas_mol_rec_tb(1).line_id,l_module_name,4);

Line 1846: RAISE fnd_api.g_exc_unexpected_error;

1842: print_debug('Some other exception occurred!',l_module_name,4);
1843: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1844: END IF;
1845: l_progress := '@@@';
1846: RAISE fnd_api.g_exc_unexpected_error;
1847: END;
1848:
1849: l_progress := '@@@';
1850:

Line 1891: --IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1887: -- print_debug('Returned from update_wdd',l_module_name,4);
1888: -- print_debug('x_return_status: '||l_return_status,l_module_name,4);
1889: --END IF;
1890:
1891: --IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1892: -- l_progress := '@@@';
1893: -- RAISE fnd_api.g_exc_unexpected_error;
1894: --END IF;
1895:

Line 1893: -- RAISE fnd_api.g_exc_unexpected_error;

1889: --END IF;
1890:
1891: --IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1892: -- l_progress := '@@@';
1893: -- RAISE fnd_api.g_exc_unexpected_error;
1894: --END IF;
1895:
1896: --{{
1897: --Test SO Xdock, WIP Pull or non-crossdock cases}}

Line 1947: RAISE fnd_api.g_exc_unexpected_error;

1943: WHEN OTHERS THEN
1944: IF (l_debug = 1) THEN
1945: print_debug('Error retrieving doc type for SO',l_module_name,4);
1946: END IF;
1947: RAISE fnd_api.g_exc_unexpected_error;
1948: END;
1949:
1950: IF (l_debug = 1) THEN
1951: print_debug('l_doc_type:'||l_doc_type,4);

Line 2048: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2044: ,x_return_status => l_return_status
2045: );
2046: l_progress := '@@@';
2047:
2048: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2049: l_progress := '@@@';
2050: RAISE fnd_api.g_exc_unexpected_error;
2051: END IF;
2052:

Line 2050: RAISE fnd_api.g_exc_unexpected_error;

2046: l_progress := '@@@';
2047:
2048: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2049: l_progress := '@@@';
2050: RAISE fnd_api.g_exc_unexpected_error;
2051: END IF;
2052:
2053: --14038720
2054: IF (l_lpn_id IS NOT NULL AND l_rsv_results_tbl.Count = 0) THEN

Line 2071: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2067: ,x_rsv_results => l_rsv_results_tbl
2068: ,x_return_status => l_return_status
2069: );
2070:
2071: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2072: l_progress := '@@@';
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF;
2075:

Line 2073: RAISE fnd_api.g_exc_unexpected_error;

2069: );
2070:
2071: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2072: l_progress := '@@@';
2073: RAISE fnd_api.g_exc_unexpected_error;
2074: END IF;
2075:
2076:
2077: END IF ;

Line 2157: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2153: print_debug('Returned from split_wdd',l_module_name,4);
2154: print_debug('l_return_status =>'||l_return_status,l_module_name,4);
2155: END IF;
2156:
2157: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2158: l_progress := '@@@';
2159: RAISE fnd_api.g_exc_unexpected_error;
2160: END IF;
2161:

Line 2159: RAISE fnd_api.g_exc_unexpected_error;

2155: END IF;
2156:
2157: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2158: l_progress := '@@@';
2159: RAISE fnd_api.g_exc_unexpected_error;
2160: END IF;
2161:
2162: l_rsv_update_rec.demand_source_line_detail := l_new_wdd_id;
2163: END IF;

Line 2216: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2212: print_debug('Returned from transfer_reservation',l_module_name,4);
2213: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2214: END IF;
2215:
2216: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2217: l_progress := '@@@';
2218: RAISE fnd_api.g_exc_unexpected_error;
2219: END IF;
2220:

Line 2218: RAISE fnd_api.g_exc_unexpected_error;

2214: END IF;
2215:
2216: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2217: l_progress := '@@@';
2218: RAISE fnd_api.g_exc_unexpected_error;
2219: END IF;
2220:
2221: IF (l_debug = 1) THEN
2222: print_debug('l_new_rsv_id: '||l_new_rsv_id,l_module_name,4);

Line 2243: x_return_status := fnd_api.g_ret_sts_error;

2239: IF (l_debug = 1) THEN
2240: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
2241: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2242: END IF;
2243: x_return_status := fnd_api.g_ret_sts_error;
2244: END maintain_rsv_deliver;
2245:
2246: PROCEDURE maintain_rsv_returns
2247: (x_return_status OUT NOCOPY VARCHAR2

Line 2316: x_return_status := fnd_api.g_ret_sts_success;

2312: print_debug(' p_cas_mol_rec_tb(1).inspection_status => '||p_cas_mol_rec_tb(1).inspection_status,l_module_name,4);
2313: print_debug(' p_cas_mol_rec_tb(1).asn_line_flag => '||p_cas_mol_rec_tb(1).asn_line_flag,l_module_name,4);
2314: END IF;
2315:
2316: x_return_status := fnd_api.g_ret_sts_success;
2317:
2318: --2.0 Query availability in RCV
2319: IF (l_debug = 1) THEN
2320: print_debug('Calling inv_reservation_avail_pvt.available_supply_to_reserve',l_module_name,4);

Line 2382: RAISE fnd_api.g_exc_unexpected_error;

2378: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2379: AND mtrh.header_id = mtrl.header_id);
2380: EXCEPTION
2381: WHEN OTHERS THEN
2382: RAISE fnd_api.g_exc_unexpected_error;
2383: END;
2384:
2385: IF (l_debug = 1) THEN
2386: print_debug('l_qty_qith_no_wdd : ' || l_qty_with_no_wdd ,l_module_name,4);

Line 2516: RAISE fnd_api.g_exc_unexpected_error;

2512: IF (l_debug = 1) THEN
2513: print_debug('Some other exception occurred!',l_module_name,4);
2514: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2515: END IF;
2516: RAISE fnd_api.g_exc_unexpected_error;
2517: END;
2518:
2519: IF (l_rsv_results.primary_reservation_quantity > l_remaining_prim_qty) THEN
2520: IF (l_debug = 1) THEN

Line 2541: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2537: print_debug('Returned from split_mo',l_module_name,4);
2538: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2539: END IF;
2540:
2541: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2542: IF (l_debug = 1) THEN
2543: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2544: print_debug('Raising Exception!!!',l_module_name,4);
2545: END IF;

Line 2547: RAISE fnd_api.g_exc_unexpected_error;

2543: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2544: print_debug('Raising Exception!!!',l_module_name,4);
2545: END IF;
2546: l_progress := '@@@';
2547: RAISE fnd_api.g_exc_unexpected_error;
2548: END IF;
2549:
2550: l_tmp_line_id := l_mo_split_tb(1).line_id;
2551:

Line 2571: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2567: print_debug('Returned from relieve_reservation',l_module_name,4);
2568: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2569: END IF;
2570:
2571: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2572: IF (l_debug = 1) THEN
2573: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2574: print_debug('Raising Exception!!!',l_module_name,4);
2575: END IF;

Line 2577: RAISE fnd_api.g_exc_unexpected_error;

2573: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2574: print_debug('Raising Exception!!!',l_module_name,4);
2575: END IF;
2576: l_progress := '@@@';
2577: RAISE fnd_api.g_exc_unexpected_error;
2578: END IF;
2579:
2580: IF (l_debug = 1) THEN
2581: print_debug('Calling update_wdd...',l_module_name,4);

Line 2598: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2594: print_debug('Returned from update_wdd',l_module_name,4);
2595: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2596: END IF;
2597:
2598: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2599: IF (l_debug = 1) THEN
2600: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
2601: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
2602: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 2606: RAISE fnd_api.g_exc_unexpected_error;

2602: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2603: print_debug('Raising Exception!!!',l_module_name,4);
2604: END IF;
2605: l_progress := '@@@';
2606: RAISE fnd_api.g_exc_unexpected_error;
2607: END IF;
2608: */
2609:
2610:

Line 2633: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2629: print_debug('Returned from delete_reservation',l_module_name,4);
2630: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2631: END IF;
2632:
2633: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2634: IF (l_debug = 1) THEN
2635: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2636: print_debug('Raising Exception!!!',l_module_name,4);
2637: END IF;

Line 2639: RAISE fnd_api.g_exc_unexpected_error;

2635: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2636: print_debug('Raising Exception!!!',l_module_name,4);
2637: END IF;
2638: l_progress := '@@@';
2639: RAISE fnd_api.g_exc_unexpected_error;
2640: END IF;
2641:
2642: IF (l_debug = 1) THEN
2643: print_debug('Calling update_wdd...',l_module_name,4);

Line 2660: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2656: print_debug('Returned from update_wdd',l_module_name,4);
2657: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2658: END IF;
2659:
2660: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2661: IF (l_debug = 1) THEN
2662: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
2663: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
2664: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 2668: RAISE fnd_api.g_exc_unexpected_error;

2664: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2665: print_debug('Raising Exception!!!',l_module_name,4);
2666: END IF;
2667: l_progress := '@@@';
2668: RAISE fnd_api.g_exc_unexpected_error;
2669: END IF;
2670:
2671: */
2672: l_tmp_line_id := l_mo_line_id;

Line 2729: RAISE fnd_api.g_exc_unexpected_error;

2725: EXCEPTION
2726: WHEN no_data_found THEN
2727: IF (l_debug = 1) THEN
2728: print_debug(' NO_DATA_FOUND Exception thrown when retrieving receipt_source_cod!',l_module_name,4);
2729: RAISE fnd_api.g_exc_unexpected_error;
2730: END IF;
2731: WHEN OTHERS THEN
2732: IF (l_debug = 1) THEN
2733: print_debug(' Other exceptions thrown when retrieving receipt_source_cod!',l_module_name,4);

Line 2735: RAISE fnd_api.g_exc_unexpected_error;

2731: WHEN OTHERS THEN
2732: IF (l_debug = 1) THEN
2733: print_debug(' Other exceptions thrown when retrieving receipt_source_cod!',l_module_name,4);
2734: END IF;
2735: RAISE fnd_api.g_exc_unexpected_error;
2736: END;
2737:
2738: IF (l_debug = 1) THEN
2739: print_debug('l_remaining_prim_qty= '|| l_remaining_prim_qty,l_module_name,4);

Line 2775: RAISE fnd_api.g_exc_unexpected_error;

2771: IF (l_debug = 1) THEN
2772: print_debug('Some other exception occurred in getting shipment details',l_module_name,4);
2773: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2774: END IF;
2775: RAISE fnd_api.g_exc_unexpected_error;
2776: END;
2777: l_rsv_update_rec.supply_source_type_id := g_source_type_in_transit;
2778: l_rsv_update_rec.supply_source_header_id := l_shipment_header_id;
2779: l_rsv_update_rec.supply_source_line_id := l_shipment_header_id;

Line 2785: RAISE fnd_api.g_exc_unexpected_error;

2781: ELSIF (l_receipt_source_code = 'CUSTOMER') THEN
2782: IF (l_debug = 1) THEN
2783: print_debug('RMA lines. Should not reach here!',l_module_name,4);
2784: END IF;
2785: RAISE fnd_api.g_exc_unexpected_error;
2786: END IF;
2787:
2788: IF (l_debug = 1) THEN
2789: print_debug('Calling transfer_reservation...',l_module_name,4);

Line 2806: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2802: print_debug('Returned from transfer_reservation',l_module_name,4);
2803: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2804: END IF;
2805:
2806: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2807: IF (l_debug = 1) THEN
2808: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
2809: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
2810: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 2814: RAISE fnd_api.g_exc_unexpected_error;

2810: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2811: print_debug('Raising Exception!!!',l_module_name,4);
2812: END IF;
2813: l_progress := '@@@';
2814: RAISE fnd_api.g_exc_unexpected_error;
2815: END IF;
2816:
2817: IF (l_debug = 1) THEN
2818: print_debug('l_new_rsv_id: '||l_new_rsv_id,l_module_name,4);

Line 2898: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

2894: print_debug('Returned from split_mo',l_module_name,4);
2895: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2896: END IF;
2897:
2898: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2899: IF (l_debug = 1) THEN
2900: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2901: print_debug('Raising Exception!!!',l_module_name,4);
2902: END IF;

Line 2904: RAISE fnd_api.g_exc_unexpected_error;

2900: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2901: print_debug('Raising Exception!!!',l_module_name,4);
2902: END IF;
2903: l_progress := '@@@';
2904: RAISE fnd_api.g_exc_unexpected_error;
2905: END IF;
2906:
2907: l_tmp_line_id := l_mo_split_tb(1).line_id;
2908: l_qty_to_close := l_qty_to_close - l_mol_rec.primary_quantity;

Line 2956: RAISE fnd_api.g_exc_unexpected_error;

2952: IF (l_qty_to_close > 0) THEN
2953: IF (l_debug = 1) THEN
2954: print_debug('l_qty_to_close > 0. Could not find matching move order for the qty !',l_module_name,4);
2955: END IF;
2956: RAISE fnd_api.g_exc_unexpected_error;
2957: END IF;
2958: END IF;
2959:
2960: IF (l_debug = 1) THEN

Line 2973: x_return_status := fnd_api.g_ret_sts_error;

2969: IF (l_debug = 1) THEN
2970: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
2971: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2972: END IF;
2973: x_return_status := fnd_api.g_ret_sts_error;
2974: END maintain_rsv_returns;
2975:
2976: PROCEDURE split_close_mo_for_ret_corr
2977: (x_return_status OUT NOCOPY VARCHAR2

Line 3094: x_return_status := fnd_api.g_ret_sts_success;

3090: END IF;
3091:
3092: l_progress := '10';
3093: l_module_name := 'SET_CLOSE_MO_FOR_RET_CORR';
3094: x_return_status := fnd_api.g_ret_sts_success;
3095:
3096: OPEN c_mol_no_mmtt(p_cas_mol_tb(1).organization_id
3097: ,p_cas_mol_tb(1).inventory_item_id
3098: ,p_cas_mol_tb(1).lpn_id

Line 3139: RAISE fnd_api.g_exc_error;

3135: AND wdt.status IN (3, 4) -- dispached or loaded
3136: AND wdt.task_type = 2 -- putaway
3137: );
3138:
3139: RAISE fnd_api.g_exc_error;
3140: EXCEPTION
3141: WHEN no_data_found THEN
3142: NULL;
3143: END;

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

3178: p_operation_type_id => NULL,
3179: p_mol_id => l_mol_rec.line_id,
3180: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
3181:
3182: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3183: IF (l_debug = 1) THEN
3184: print_debug('call_atf_api failed:'||l_mol_rec.line_id,l_module_name,4);
3185: END IF;
3186: --raise error

Line 3187: RAISE fnd_api.g_exc_error;

3183: IF (l_debug = 1) THEN
3184: print_debug('call_atf_api failed:'||l_mol_rec.line_id,l_module_name,4);
3185: END IF;
3186: --raise error
3187: RAISE fnd_api.g_exc_error;
3188: END IF;
3189:
3190: l_remaining_primary_quantity := l_remaining_primary_quantity -
3191: l_mol_qty_in_puom;

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

3207: x_return_status => x_return_status,
3208: x_msg_count => x_msg_count,
3209: x_msg_data => x_msg_data);
3210:
3211: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3212: RAISE fnd_api.g_exc_error;
3213: END IF;
3214:
3215:

Line 3212: RAISE fnd_api.g_exc_error;

3208: x_msg_count => x_msg_count,
3209: x_msg_data => x_msg_data);
3210:
3211: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3212: RAISE fnd_api.g_exc_error;
3213: END IF;
3214:
3215:
3216: IF (l_debug = 1) THEN

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

3240: p_operation_type_id => NULL,
3241: p_mol_id => l_mo_split_tb(1).line_id,
3242: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
3243:
3244: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3245: IF (l_debug = 1) THEN
3246: print_debug('call_atf_api failed:'||l_mo_split_tb(1).line_id,l_module_name,4);
3247: END IF;
3248: --raise error

Line 3249: RAISE fnd_api.g_exc_error;

3245: IF (l_debug = 1) THEN
3246: print_debug('call_atf_api failed:'||l_mo_split_tb(1).line_id,l_module_name,4);
3247: END IF;
3248: --raise error
3249: RAISE fnd_api.g_exc_error;
3250: END IF;
3251:
3252: --update the old line for wms process flag
3253: UPDATE mtl_txn_request_lines

Line 3271: RAISE fnd_api.g_exc_error;

3267: --raise error
3268: IF (l_debug = 1) THEN
3269: print_debug('Quantity Still Remaining!!! WHY???:'||l_remaining_primary_quantity,l_module_name,4);
3270: END IF;
3271: RAISE fnd_api.g_exc_error;
3272: END IF;
3273: EXCEPTION
3274: WHEN OTHERS THEN
3275: IF (l_debug = 1) THEN

Line 3279: x_return_status := fnd_api.g_ret_sts_error;

3275: IF (l_debug = 1) THEN
3276: print_debug('Exception occurred at progress:'||l_progress,l_module_name,4);
3277: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
3278: END IF;
3279: x_return_status := fnd_api.g_ret_sts_error;
3280: END split_close_mo_for_ret_corr;
3281:
3282: PROCEDURE maintain_reservations
3283: (x_return_status OUT NOCOPY VARCHAR2

Line 3303: x_return_status := fnd_api.g_ret_sts_success;

3299: END IF;
3300:
3301: l_progress := '10';
3302: l_module_name := 'MAINTAIN_RESERVATIONS';
3303: x_return_status := fnd_api.g_ret_sts_success;
3304:
3305:
3306:
3307: --{{

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

3407: ,x_msg_count => x_msg_count
3408: ,x_msg_data => x_msg_data
3409: ,p_cas_mol_tb => p_cas_mol_tb);
3410:
3411: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3412: IF (l_debug = 1) THEN
3413: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3414: END IF;
3415: --raise error

Line 3416: RAISE fnd_api.g_exc_error;

3412: IF (l_debug = 1) THEN
3413: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3414: END IF;
3415: --raise error
3416: RAISE fnd_api.g_exc_error;
3417: END IF;
3418:
3419: set_mol_wdd_tbl(p_cas_mol_tb(1),
3420: x_mol_tb,

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

3438: ,x_msg_count => x_msg_count
3439: ,x_msg_data => x_msg_data
3440: ,p_cas_mol_tb => p_cas_mol_tb);
3441:
3442: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3443: IF (l_debug = 1) THEN
3444: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3445: END IF;
3446: --raise error

Line 3447: RAISE fnd_api.g_exc_error;

3443: IF (l_debug = 1) THEN
3444: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3445: END IF;
3446: --raise error
3447: RAISE fnd_api.g_exc_error;
3448: END IF;
3449:
3450:
3451: --{{

Line 3486: x_return_status := fnd_api.g_ret_sts_error;

3482: IF (l_debug = 1) THEN
3483: print_debug('Exception occurred at progress:'||l_progress,l_module_name,4);
3484: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
3485: END IF;
3486: x_return_status := fnd_api.g_ret_sts_error;
3487: END maintain_reservations;
3488: END inv_rcv_reservation_util;
3489: