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 757: RAISE fnd_api.g_exc_unexpected_error;

753: WHEN OTHERS THEN
754: IF (l_debug = 1) THEN
755: print_debug('Error in set_mol_wdd_tbl...',l_module_name,4);
756: END IF;
757: RAISE fnd_api.g_exc_unexpected_error;
758: END set_mol_wdd_tbl;
759:
760: PROCEDURE maintain_rsv_import_asn
761: (x_return_status OUT NOCOPY VARCHAR2

Line 793: x_return_status := fnd_api.g_ret_sts_success;

789:
790: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
791: l_progress := '10';
792: l_module_name := 'maintain_rsv_import_asn';
793: x_return_status := fnd_api.g_ret_sts_success;
794:
795: IF (l_debug = 1) THEN
796: print_debug('Entering maintain_rsv_import_asn...',l_module_name,4);
797: 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 842: RAISE fnd_api.g_exc_unexpected_error;

838: print_debug('Some other exception occurred!',l_module_name,4);
839: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
840: END IF;
841: l_progress := '@@@';
842: RAISE fnd_api.g_exc_unexpected_error;
843: END;
844: l_progress := '@@@';
845:
846: IF (l_debug = 1) THEN

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

861: print_debug('Returned from query_reservation',l_module_name,4);
862: print_debug('x_return_status: '||l_return_status,l_module_name,4);
863: END IF;
864:
865: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
866: l_progress := '@@@';
867: RAISE fnd_api.g_exc_unexpected_error;
868: END IF;
869:

Line 867: RAISE fnd_api.g_exc_unexpected_error;

863: END IF;
864:
865: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
866: l_progress := '@@@';
867: RAISE fnd_api.g_exc_unexpected_error;
868: END IF;
869:
870: l_remaining_prim_qty := p_cas_mol_rec_tb(1).primary_qty;
871:

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

926: print_debug('Returned from split_wdd',l_module_name,4);
927: print_debug('l_return_status =>'||l_return_status,l_module_name,4);
928: END IF;
929:
930: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
931: l_progress := '@@@';
932: RAISE fnd_api.g_exc_unexpected_error;
933: END IF;
934:

Line 932: RAISE fnd_api.g_exc_unexpected_error;

928: END IF;
929:
930: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
931: l_progress := '@@@';
932: RAISE fnd_api.g_exc_unexpected_error;
933: END IF;
934:
935: l_rsv_update_rec.demand_source_line_detail := l_new_wdd_id;
936: END IF;

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

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

Line 969: RAISE fnd_api.g_exc_unexpected_error;

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

Line 993: x_return_status := fnd_api.g_ret_sts_error;

989: IF (l_debug = 1) THEN
990: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
991: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
992: END IF;
993: x_return_status := fnd_api.g_ret_sts_error;
994: END maintain_rsv_import_asn;
995:
996: PROCEDURE maintain_rsv_cancel_asn
997: (x_return_status OUT NOCOPY VARCHAR2

Line 1025: x_return_status := fnd_api.g_ret_sts_success;

1021:
1022: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1023: l_progress := '10';
1024: l_module_name := 'MAINTAIN_RSV_CANCEL_ASN';
1025: x_return_status := fnd_api.g_ret_sts_success;
1026:
1027: IF (l_debug = 1) THEN
1028: print_debug('Entering maintain_rsv_cancel_asn...',l_module_name,4);
1029: 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 1074: RAISE fnd_api.g_exc_unexpected_error;

1070: print_debug('Some other exception occurred!',l_module_name,4);
1071: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1072: END IF;
1073: l_progress := '@@@';
1074: RAISE fnd_api.g_exc_unexpected_error;
1075: END;
1076: l_progress := '@@@';
1077:
1078: IF (l_debug = 1) THEN

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

1087: ,x_return_status => l_return_status
1088: );
1089: l_progress := '###';
1090:
1091: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1092: l_progress := '@@@';
1093: RAISE fnd_api.g_exc_unexpected_error;
1094: END IF;
1095:

Line 1093: RAISE fnd_api.g_exc_unexpected_error;

1089: l_progress := '###';
1090:
1091: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1092: l_progress := '@@@';
1093: RAISE fnd_api.g_exc_unexpected_error;
1094: END IF;
1095:
1096: IF (l_debug = 1) THEN
1097: print_debug('l_rsv_results_tbl.COUNT = ' ||l_rsv_results_tbl.COUNT,l_module_name,4);

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

1127: print_debug('Returned from delete_reservation',l_module_name,4);
1128: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1129: END IF;
1130:
1131: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1132: IF (l_debug = 1) THEN
1133: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1134: print_debug('Raising Exception!!!',l_module_name,4);
1135: END IF;

Line 1137: RAISE fnd_api.g_exc_unexpected_error;

1133: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1134: print_debug('Raising Exception!!!',l_module_name,4);
1135: END IF;
1136: l_progress := '@@@';
1137: RAISE fnd_api.g_exc_unexpected_error;
1138: END IF;
1139: ELSE --IF this is a manual rsv transferred from PO
1140: l_rsv_update_rec := l_rsv_results_tbl(i);
1141: l_rsv_update_rec.supply_source_type_id := g_source_type_po;

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

1155: print_debug('Returned from transfer_reservation',l_module_name,4);
1156: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1157: END IF;
1158:
1159: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1160: l_progress := '@@@';
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163:

Line 1161: RAISE fnd_api.g_exc_unexpected_error;

1157: END IF;
1158:
1159: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1160: l_progress := '@@@';
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163:
1164: IF (l_debug = 1) THEN
1165: print_debug('l_reservation_id: '||l_reservation_id,l_module_name,4);

Line 1186: x_return_status := fnd_api.g_ret_sts_error;

1182: IF (l_debug = 1) THEN
1183: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
1184: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1185: END IF;
1186: x_return_status := fnd_api.g_ret_sts_error;
1187: END maintain_rsv_cancel_asn;
1188:
1189: PROCEDURE maintain_rsv_receive
1190: (x_return_status OUT NOCOPY VARCHAR2

Line 1225: x_return_status := fnd_api.g_ret_sts_success;

1221:
1222: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1223: l_progress := '10';
1224: l_module_name := 'MAINTAIN_RSV_RECEIVE';
1225: x_return_status := fnd_api.g_ret_sts_success;
1226:
1227: IF (l_debug = 1) THEN
1228: print_debug('Entering maintain_rsv_receive...',l_module_name,4);
1229: 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 1273: RAISE fnd_api.g_exc_unexpected_error;

1269: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1270: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1271: END IF;
1272: l_progress := '###';
1273: RAISE fnd_api.g_exc_unexpected_error;
1274: END;
1275: l_progress := '###';
1276: ELSE --asn_line_flag = 'Y' THEN
1277: IF (l_debug = 1) THEN

Line 1299: RAISE fnd_api.g_exc_unexpected_error;

1295: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1296: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1297: END IF;
1298: l_progress := '###';
1299: RAISE fnd_api.g_exc_unexpected_error;
1300: END;
1301: l_progress := '###';
1302: END IF;
1303:

Line 1329: RAISE fnd_api.g_exc_unexpected_error;

1325: IF (l_debug = 1) THEN
1326: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1327: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1328: END IF;
1329: RAISE fnd_api.g_exc_unexpected_error;
1330: END;
1331: l_progress := '###';
1332:
1333: l_rsv_query_rec.supply_source_type_id := g_source_type_internal_req;

Line 1356: RAISE fnd_api.g_exc_unexpected_error;

1352: print_debug('Some other exception occurred! Raising Exception!',l_module_name,4);
1353: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1354: END IF;
1355: l_progress := '###';
1356: RAISE fnd_api.g_exc_unexpected_error;
1357: END;
1358: l_progress := '###';
1359:
1360: l_rsv_query_rec.supply_source_type_id := g_source_type_in_transit;

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

1402: ,x_return_status => l_return_status
1403: );
1404: l_progress := '###';
1405:
1406: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1407: l_progress := '@@@';
1408: RAISE fnd_api.g_exc_unexpected_error;
1409: END IF;
1410:

Line 1408: RAISE fnd_api.g_exc_unexpected_error;

1404: l_progress := '###';
1405:
1406: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1407: l_progress := '@@@';
1408: RAISE fnd_api.g_exc_unexpected_error;
1409: END IF;
1410:
1411: --3.0 Process reservations
1412: l_remaining_prim_qty := l_primary_qty;

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

1473: print_debug('Returned from delete_reservation',l_module_name,4);
1474: print_debug('x_return_status: '||l_return_status,l_module_name,4);
1475: END IF;
1476:
1477: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1478: l_progress := '@@@';
1479: RAISE fnd_api.g_exc_unexpected_error;
1480: END IF;
1481:

Line 1479: RAISE fnd_api.g_exc_unexpected_error;

1475: END IF;
1476:
1477: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1478: l_progress := '@@@';
1479: RAISE fnd_api.g_exc_unexpected_error;
1480: END IF;
1481:
1482:
1483: --{{

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

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

Line 1532: RAISE fnd_api.g_exc_unexpected_error;

1528: END IF;
1529:
1530: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1531: l_progress := '@@@';
1532: RAISE fnd_api.g_exc_unexpected_error;
1533: END IF;
1534:
1535: IF (l_debug = 1) THEN
1536: print_debug('l_new_wdd_id: '||l_new_wdd_id,l_module_name,4);

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

1583: ,p_mol_id => NULL
1584: );
1585: l_progress := '@@@';
1586:
1587: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1588: l_progress := '@@@';
1589: RAISE fnd_api.g_exc_unexpected_error;
1590: END IF;
1591:

Line 1589: RAISE fnd_api.g_exc_unexpected_error;

1585: l_progress := '@@@';
1586:
1587: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1588: l_progress := '@@@';
1589: RAISE fnd_api.g_exc_unexpected_error;
1590: END IF;
1591:
1592: l_rsv_update_rec.demand_source_line_detail := NULL;
1593: END IF;

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

1603: ,x_new_rsv_id => l_new_rsv_id
1604: ,x_return_status => l_return_status);
1605: l_progress := '@@@';
1606:
1607: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1608: l_progress := '@@@';
1609: RAISE fnd_api.g_exc_unexpected_error;
1610: END IF;
1611:

Line 1609: RAISE fnd_api.g_exc_unexpected_error;

1605: l_progress := '@@@';
1606:
1607: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1608: l_progress := '@@@';
1609: RAISE fnd_api.g_exc_unexpected_error;
1610: END IF;
1611:
1612: IF (l_debug = 1) THEN
1613: print_debug('l_new_rsv_id: '||l_new_rsv_id,l_module_name,4);

Line 1672: x_return_status := fnd_api.g_ret_sts_error;

1668: --********** END PROCEDURE maintain_rsv_receive *********}}
1669:
1670: EXCEPTION
1671: WHEN OTHERS THEN
1672: x_return_status := fnd_api.g_ret_sts_error;
1673: IF (l_debug = 1) THEN
1674: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
1675: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1676: print_debug('Exiting maintain_rsv_receive with error: '||l_progress,l_module_name,4);

Line 1713: x_return_status := fnd_api.g_ret_sts_success;

1709:
1710: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1711: l_progress := '10';
1712: l_module_name := 'MAINTAIN_RSV_DELIVER';
1713: x_return_status := fnd_api.g_ret_sts_success;
1714:
1715: IF (l_debug = 1) THEN
1716: print_debug('Entering maintain_rsv_deliver...',l_module_name,4);
1717: print_debug(' p_cas_mol_rec_tb(1).line_id => '||p_cas_mol_rec_tb(1).line_id,l_module_name,4);

Line 1749: RAISE fnd_api.g_exc_unexpected_error;

1745: print_debug('Some other exception occurred!',l_module_name,4);
1746: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
1747: END IF;
1748: l_progress := '@@@';
1749: RAISE fnd_api.g_exc_unexpected_error;
1750: END;
1751:
1752: l_progress := '@@@';
1753:

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

1790: -- print_debug('Returned from update_wdd',l_module_name,4);
1791: -- print_debug('x_return_status: '||l_return_status,l_module_name,4);
1792: --END IF;
1793:
1794: --IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1795: -- l_progress := '@@@';
1796: -- RAISE fnd_api.g_exc_unexpected_error;
1797: --END IF;
1798:

Line 1796: -- RAISE fnd_api.g_exc_unexpected_error;

1792: --END IF;
1793:
1794: --IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1795: -- l_progress := '@@@';
1796: -- RAISE fnd_api.g_exc_unexpected_error;
1797: --END IF;
1798:
1799: --{{
1800: --Test SO Xdock, WIP Pull or non-crossdock cases}}

Line 1849: RAISE fnd_api.g_exc_unexpected_error;

1845: WHEN OTHERS THEN
1846: IF (l_debug = 1) THEN
1847: print_debug('Error retrieving doc type for SO',l_module_name,4);
1848: END IF;
1849: RAISE fnd_api.g_exc_unexpected_error;
1850: END;
1851:
1852: IF (l_debug = 1) THEN
1853: print_debug('l_doc_type:'||l_doc_type,4);

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

1884: ,x_return_status => l_return_status
1885: );
1886: l_progress := '@@@';
1887:
1888: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1889: l_progress := '@@@';
1890: RAISE fnd_api.g_exc_unexpected_error;
1891: END IF;
1892:

Line 1890: RAISE fnd_api.g_exc_unexpected_error;

1886: l_progress := '@@@';
1887:
1888: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1889: l_progress := '@@@';
1890: RAISE fnd_api.g_exc_unexpected_error;
1891: END IF;
1892:
1893: l_remaining_prim_qty := p_cas_mol_rec_tb(1).primary_qty;
1894:

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

1953: print_debug('Returned from split_wdd',l_module_name,4);
1954: print_debug('l_return_status =>'||l_return_status,l_module_name,4);
1955: END IF;
1956:
1957: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1958: l_progress := '@@@';
1959: RAISE fnd_api.g_exc_unexpected_error;
1960: END IF;
1961:

Line 1959: RAISE fnd_api.g_exc_unexpected_error;

1955: END IF;
1956:
1957: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1958: l_progress := '@@@';
1959: RAISE fnd_api.g_exc_unexpected_error;
1960: END IF;
1961:
1962: l_rsv_update_rec.demand_source_line_detail := l_new_wdd_id;
1963: END IF;

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

2007: print_debug('Returned from transfer_reservation',l_module_name,4);
2008: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2009: END IF;
2010:
2011: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2012: l_progress := '@@@';
2013: RAISE fnd_api.g_exc_unexpected_error;
2014: END IF;
2015:

Line 2013: RAISE fnd_api.g_exc_unexpected_error;

2009: END IF;
2010:
2011: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2012: l_progress := '@@@';
2013: RAISE fnd_api.g_exc_unexpected_error;
2014: END IF;
2015:
2016: IF (l_debug = 1) THEN
2017: print_debug('l_new_rsv_id: '||l_new_rsv_id,l_module_name,4);

Line 2037: x_return_status := fnd_api.g_ret_sts_error;

2033: IF (l_debug = 1) THEN
2034: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
2035: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2036: END IF;
2037: x_return_status := fnd_api.g_ret_sts_error;
2038: END maintain_rsv_deliver;
2039:
2040: PROCEDURE maintain_rsv_returns
2041: (x_return_status OUT NOCOPY VARCHAR2

Line 2110: x_return_status := fnd_api.g_ret_sts_success;

2106: print_debug(' p_cas_mol_rec_tb(1).inspection_status => '||p_cas_mol_rec_tb(1).inspection_status,l_module_name,4);
2107: print_debug(' p_cas_mol_rec_tb(1).asn_line_flag => '||p_cas_mol_rec_tb(1).asn_line_flag,l_module_name,4);
2108: END IF;
2109:
2110: x_return_status := fnd_api.g_ret_sts_success;
2111:
2112: --2.0 Query availability in RCV
2113: IF (l_debug = 1) THEN
2114: print_debug('Calling inv_reservation_avail_pvt.available_supply_to_reserve',l_module_name,4);

Line 2176: RAISE fnd_api.g_exc_unexpected_error;

2172: WHERE mtrh.move_order_type = inv_globals.g_move_order_put_away
2173: AND mtrh.header_id = mtrl.header_id);
2174: EXCEPTION
2175: WHEN OTHERS THEN
2176: RAISE fnd_api.g_exc_unexpected_error;
2177: END;
2178:
2179: IF (l_debug = 1) THEN
2180: print_debug('l_qty_qith_no_wdd : ' || l_qty_with_no_wdd ,l_module_name,4);

Line 2310: RAISE fnd_api.g_exc_unexpected_error;

2306: IF (l_debug = 1) THEN
2307: print_debug('Some other exception occurred!',l_module_name,4);
2308: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2309: END IF;
2310: RAISE fnd_api.g_exc_unexpected_error;
2311: END;
2312:
2313: IF (l_rsv_results.primary_reservation_quantity > l_remaining_prim_qty) THEN
2314: IF (l_debug = 1) THEN

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

2331: print_debug('Returned from split_mo',l_module_name,4);
2332: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2333: END IF;
2334:
2335: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2336: IF (l_debug = 1) THEN
2337: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2338: print_debug('Raising Exception!!!',l_module_name,4);
2339: END IF;

Line 2341: RAISE fnd_api.g_exc_unexpected_error;

2337: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2338: print_debug('Raising Exception!!!',l_module_name,4);
2339: END IF;
2340: l_progress := '@@@';
2341: RAISE fnd_api.g_exc_unexpected_error;
2342: END IF;
2343:
2344: l_tmp_line_id := l_mo_split_tb(1).line_id;
2345:

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

2361: print_debug('Returned from relieve_reservation',l_module_name,4);
2362: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2363: END IF;
2364:
2365: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2366: IF (l_debug = 1) THEN
2367: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2368: print_debug('Raising Exception!!!',l_module_name,4);
2369: END IF;

Line 2371: RAISE fnd_api.g_exc_unexpected_error;

2367: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2368: print_debug('Raising Exception!!!',l_module_name,4);
2369: END IF;
2370: l_progress := '@@@';
2371: RAISE fnd_api.g_exc_unexpected_error;
2372: END IF;
2373:
2374: IF (l_debug = 1) THEN
2375: print_debug('Calling update_wdd...',l_module_name,4);

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

2388: print_debug('Returned from update_wdd',l_module_name,4);
2389: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2390: END IF;
2391:
2392: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2393: IF (l_debug = 1) THEN
2394: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
2395: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
2396: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 2400: RAISE fnd_api.g_exc_unexpected_error;

2396: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2397: print_debug('Raising Exception!!!',l_module_name,4);
2398: END IF;
2399: l_progress := '@@@';
2400: RAISE fnd_api.g_exc_unexpected_error;
2401: END IF;
2402: */
2403:
2404:

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

2423: print_debug('Returned from delete_reservation',l_module_name,4);
2424: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2425: END IF;
2426:
2427: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2428: IF (l_debug = 1) THEN
2429: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2430: print_debug('Raising Exception!!!',l_module_name,4);
2431: END IF;

Line 2433: RAISE fnd_api.g_exc_unexpected_error;

2429: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2430: print_debug('Raising Exception!!!',l_module_name,4);
2431: END IF;
2432: l_progress := '@@@';
2433: RAISE fnd_api.g_exc_unexpected_error;
2434: END IF;
2435:
2436: IF (l_debug = 1) THEN
2437: print_debug('Calling update_wdd...',l_module_name,4);

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

2450: print_debug('Returned from update_wdd',l_module_name,4);
2451: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2452: END IF;
2453:
2454: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2455: IF (l_debug = 1) THEN
2456: print_debug('x_msg_count: '||l_msg_count,l_module_name,4);
2457: print_debug('x_msg_data: '||l_msg_data,l_module_name,4);
2458: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);

Line 2462: RAISE fnd_api.g_exc_unexpected_error;

2458: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2459: print_debug('Raising Exception!!!',l_module_name,4);
2460: END IF;
2461: l_progress := '@@@';
2462: RAISE fnd_api.g_exc_unexpected_error;
2463: END IF;
2464:
2465: */
2466: l_tmp_line_id := l_mo_line_id;

Line 2523: RAISE fnd_api.g_exc_unexpected_error;

2519: EXCEPTION
2520: WHEN no_data_found THEN
2521: IF (l_debug = 1) THEN
2522: print_debug(' NO_DATA_FOUND Exception thrown when retrieving receipt_source_cod!',l_module_name,4);
2523: RAISE fnd_api.g_exc_unexpected_error;
2524: END IF;
2525: WHEN OTHERS THEN
2526: IF (l_debug = 1) THEN
2527: print_debug(' Other exceptions thrown when retrieving receipt_source_cod!',l_module_name,4);

Line 2529: RAISE fnd_api.g_exc_unexpected_error;

2525: WHEN OTHERS THEN
2526: IF (l_debug = 1) THEN
2527: print_debug(' Other exceptions thrown when retrieving receipt_source_cod!',l_module_name,4);
2528: END IF;
2529: RAISE fnd_api.g_exc_unexpected_error;
2530: END;
2531:
2532: IF (l_debug = 1) THEN
2533: print_debug('l_remaining_prim_qty= '|| l_remaining_prim_qty,l_module_name,4);

Line 2569: RAISE fnd_api.g_exc_unexpected_error;

2565: IF (l_debug = 1) THEN
2566: print_debug('Some other exception occurred in getting shipment details',l_module_name,4);
2567: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2568: END IF;
2569: RAISE fnd_api.g_exc_unexpected_error;
2570: END;
2571: l_rsv_update_rec.supply_source_type_id := g_source_type_in_transit;
2572: l_rsv_update_rec.supply_source_header_id := l_shipment_header_id;
2573: l_rsv_update_rec.supply_source_line_id := l_shipment_header_id;

Line 2579: RAISE fnd_api.g_exc_unexpected_error;

2575: ELSIF (l_receipt_source_code = 'CUSTOMER') THEN
2576: IF (l_debug = 1) THEN
2577: print_debug('RMA lines. Should not reach here!',l_module_name,4);
2578: END IF;
2579: RAISE fnd_api.g_exc_unexpected_error;
2580: END IF;
2581:
2582: IF (l_debug = 1) THEN
2583: print_debug('Calling transfer_reservation...',l_module_name,4);

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

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

Line 2608: RAISE fnd_api.g_exc_unexpected_error;

2604: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2605: print_debug('Raising Exception!!!',l_module_name,4);
2606: END IF;
2607: l_progress := '@@@';
2608: RAISE fnd_api.g_exc_unexpected_error;
2609: END IF;
2610:
2611: IF (l_debug = 1) THEN
2612: print_debug('l_new_rsv_id: '||l_new_rsv_id,l_module_name,4);

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

2688: print_debug('Returned from split_mo',l_module_name,4);
2689: print_debug('x_return_status: '||l_return_status,l_module_name,4);
2690: END IF;
2691:
2692: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
2693: IF (l_debug = 1) THEN
2694: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2695: print_debug('Raising Exception!!!',l_module_name,4);
2696: END IF;

Line 2698: RAISE fnd_api.g_exc_unexpected_error;

2694: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2695: print_debug('Raising Exception!!!',l_module_name,4);
2696: END IF;
2697: l_progress := '@@@';
2698: RAISE fnd_api.g_exc_unexpected_error;
2699: END IF;
2700:
2701: l_tmp_line_id := l_mo_split_tb(1).line_id;
2702: l_qty_to_close := l_qty_to_close - l_mol_rec.primary_quantity;

Line 2750: RAISE fnd_api.g_exc_unexpected_error;

2746: IF (l_qty_to_close > 0) THEN
2747: IF (l_debug = 1) THEN
2748: print_debug('l_qty_to_close > 0. Could not find matching move order for the qty !',l_module_name,4);
2749: END IF;
2750: RAISE fnd_api.g_exc_unexpected_error;
2751: END IF;
2752: END IF;
2753:
2754: IF (l_debug = 1) THEN

Line 2767: x_return_status := fnd_api.g_ret_sts_error;

2763: IF (l_debug = 1) THEN
2764: print_debug('Exception occurred at progress: '||l_progress,l_module_name,4);
2765: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
2766: END IF;
2767: x_return_status := fnd_api.g_ret_sts_error;
2768: END maintain_rsv_returns;
2769:
2770: PROCEDURE split_close_mo_for_ret_corr
2771: (x_return_status OUT NOCOPY VARCHAR2

Line 2888: x_return_status := fnd_api.g_ret_sts_success;

2884: END IF;
2885:
2886: l_progress := '10';
2887: l_module_name := 'SET_CLOSE_MO_FOR_RET_CORR';
2888: x_return_status := fnd_api.g_ret_sts_success;
2889:
2890: OPEN c_mol_no_mmtt(p_cas_mol_tb(1).organization_id
2891: ,p_cas_mol_tb(1).inventory_item_id
2892: ,p_cas_mol_tb(1).lpn_id

Line 2933: RAISE fnd_api.g_exc_error;

2929: AND wdt.status IN (3, 4) -- dispached or loaded
2930: AND wdt.task_type = 2 -- putaway
2931: );
2932:
2933: RAISE fnd_api.g_exc_error;
2934: EXCEPTION
2935: WHEN no_data_found THEN
2936: NULL;
2937: END;

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

2972: p_operation_type_id => NULL,
2973: p_mol_id => l_mol_rec.line_id,
2974: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
2975:
2976: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2977: IF (l_debug = 1) THEN
2978: print_debug('call_atf_api failed:'||l_mol_rec.line_id,l_module_name,4);
2979: END IF;
2980: --raise error

Line 2981: RAISE fnd_api.g_exc_error;

2977: IF (l_debug = 1) THEN
2978: print_debug('call_atf_api failed:'||l_mol_rec.line_id,l_module_name,4);
2979: END IF;
2980: --raise error
2981: RAISE fnd_api.g_exc_error;
2982: END IF;
2983:
2984: l_remaining_primary_quantity := l_remaining_primary_quantity -
2985: l_mol_qty_in_puom;

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

3001: x_return_status => x_return_status,
3002: x_msg_count => x_msg_count,
3003: x_msg_data => x_msg_data);
3004:
3005: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3006: RAISE fnd_api.g_exc_error;
3007: END IF;
3008:
3009:

Line 3006: RAISE fnd_api.g_exc_error;

3002: x_msg_count => x_msg_count,
3003: x_msg_data => x_msg_data);
3004:
3005: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3006: RAISE fnd_api.g_exc_error;
3007: END IF;
3008:
3009:
3010: IF (l_debug = 1) THEN

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

3034: p_operation_type_id => NULL,
3035: p_mol_id => l_mo_split_tb(1).line_id,
3036: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
3037:
3038: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3039: IF (l_debug = 1) THEN
3040: print_debug('call_atf_api failed:'||l_mo_split_tb(1).line_id,l_module_name,4);
3041: END IF;
3042: --raise error

Line 3043: RAISE fnd_api.g_exc_error;

3039: IF (l_debug = 1) THEN
3040: print_debug('call_atf_api failed:'||l_mo_split_tb(1).line_id,l_module_name,4);
3041: END IF;
3042: --raise error
3043: RAISE fnd_api.g_exc_error;
3044: END IF;
3045:
3046: --update the old line for wms process flag
3047: UPDATE mtl_txn_request_lines

Line 3065: RAISE fnd_api.g_exc_error;

3061: --raise error
3062: IF (l_debug = 1) THEN
3063: print_debug('Quantity Still Remaining!!! WHY???:'||l_remaining_primary_quantity,l_module_name,4);
3064: END IF;
3065: RAISE fnd_api.g_exc_error;
3066: END IF;
3067: EXCEPTION
3068: WHEN OTHERS THEN
3069: IF (l_debug = 1) THEN

Line 3073: x_return_status := fnd_api.g_ret_sts_error;

3069: IF (l_debug = 1) THEN
3070: print_debug('Exception occurred at progress:'||l_progress,l_module_name,4);
3071: print_debug('SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM,l_module_name,4);
3072: END IF;
3073: x_return_status := fnd_api.g_ret_sts_error;
3074: END split_close_mo_for_ret_corr;
3075:
3076: PROCEDURE maintain_reservations
3077: (x_return_status OUT NOCOPY VARCHAR2

Line 3097: x_return_status := fnd_api.g_ret_sts_success;

3093: END IF;
3094:
3095: l_progress := '10';
3096: l_module_name := 'MAINTAIN_RESERVATIONS';
3097: x_return_status := fnd_api.g_ret_sts_success;
3098:
3099:
3100:
3101: --{{

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

3201: ,x_msg_count => x_msg_count
3202: ,x_msg_data => x_msg_data
3203: ,p_cas_mol_tb => p_cas_mol_tb);
3204:
3205: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3206: IF (l_debug = 1) THEN
3207: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3208: END IF;
3209: --raise error

Line 3210: RAISE fnd_api.g_exc_error;

3206: IF (l_debug = 1) THEN
3207: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3208: END IF;
3209: --raise error
3210: RAISE fnd_api.g_exc_error;
3211: END IF;
3212:
3213: set_mol_wdd_tbl(p_cas_mol_tb(1),
3214: x_mol_tb,

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

3232: ,x_msg_count => x_msg_count
3233: ,x_msg_data => x_msg_data
3234: ,p_cas_mol_tb => p_cas_mol_tb);
3235:
3236: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3237: IF (l_debug = 1) THEN
3238: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3239: END IF;
3240: --raise error

Line 3241: RAISE fnd_api.g_exc_error;

3237: IF (l_debug = 1) THEN
3238: print_debug('split_mo_ret_corr failed for this process ',l_module_name,4);
3239: END IF;
3240: --raise error
3241: RAISE fnd_api.g_exc_error;
3242: END IF;
3243:
3244:
3245: --{{

Line 3280: x_return_status := fnd_api.g_ret_sts_error;

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