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

Line 7: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

3: G_PKG_NAME CONSTANT VARCHAR2(40) := 'GMO_SWORKBENCH_PVT';
4: PROCEDURE UPDATE_PLANNING_STATUS
5: (
6: P_API_VERSION IN NUMBER,
7: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
8: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
9: X_MSG_COUNT OUT NOCOPY NUMBER,
10: X_MSG_DATA OUT NOCOPY VARCHAR2,
11: P_RESERVATION_ID IN NUMBER,

Line 488: x_return_status := fnd_api.g_ret_sts_error;

484: GMD.material_detail_id =p_material_detail_id and RES.DEMAND_SOURCE_HEADER_ID (+) = GMD.BATCH_ID
485: AND RES.DEMAND_SOURCE_LINE_ID(+) = GMD.MATERIAL_DETAIL_ID;
486: EXCEPTION
487: WHEN error_get_item THEN
488: x_return_status := fnd_api.g_ret_sts_error;
489: WHEN OTHERS THEN
490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

487: WHEN error_get_item THEN
488: x_return_status := fnd_api.g_ret_sts_error;
489: WHEN OTHERS THEN
490: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
491: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
492: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
493: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
494: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
495: END create_material_reservation;

Line 540: x_return_status := fnd_api.g_ret_sts_success;

536: gme_debug.put_line ('input value plan_qty => ' || p_matl_dtl_rec.plan_qty);
537: gme_debug.put_line ('input value resv_um => ' || p_resv_um );
538: gme_debug.put_line ('input value release_type => ' || p_matl_dtl_rec.release_type );
539: END IF;*/
540: x_return_status := fnd_api.g_ret_sts_success;
541: --Bug#4604943 Begin validate the batch and material line
542: validate_mtl_for_reservation(
543: p_material_detail_rec => p_matl_dtl_rec
544: ,x_return_status => l_return_status

Line 547: IF l_return_status <> fnd_api.g_ret_sts_success THEN

543: p_material_detail_rec => p_matl_dtl_rec
544: ,x_return_status => l_return_status
545: ,x_msg_count => x_msg_count
546: ,x_msg_data => x_msg_data);
547: IF l_return_status <> fnd_api.g_ret_sts_success THEN
548: RAISE invalid_mtl_for_rsrv;
549: END IF;
550: --Bug#4604943 End
551: l_rsv_rec.requirement_date := p_matl_dtl_rec.material_requirement_date;

Line 620: ,p_init_msg_lst => fnd_api.g_false

616: -- nsinghi Bug5176319. Commented p_force_reservation_flag parameter. As per inv team, onhand could be -ve
617: -- before reservation, and hence this parameter should not be used.
618: inv_reservation_pub.create_reservation
619: (p_api_version_number => 1.0
620: ,p_init_msg_lst => fnd_api.g_false
621: ,x_return_status => l_return_status
622: ,x_msg_count => x_msg_count
623: ,x_msg_data => x_msg_data
624: ,p_rsv_rec => l_rsv_rec

Line 627: ,p_partial_reservation_flag => fnd_api.g_true

623: ,x_msg_data => x_msg_data
624: ,p_rsv_rec => l_rsv_rec
625: ,p_serial_number => l_in_serial_num
626: ,x_serial_number => l_out_serial_num
627: ,p_partial_reservation_flag => fnd_api.g_true
628: -- ,p_force_reservation_flag => fnd_api.g_true
629: ,p_validation_flag => fnd_api.g_true
630: ,x_quantity_reserved => l_qty_reserved
631: ,x_reservation_id => l_reservation_id

Line 628: -- ,p_force_reservation_flag => fnd_api.g_true

624: ,p_rsv_rec => l_rsv_rec
625: ,p_serial_number => l_in_serial_num
626: ,x_serial_number => l_out_serial_num
627: ,p_partial_reservation_flag => fnd_api.g_true
628: -- ,p_force_reservation_flag => fnd_api.g_true
629: ,p_validation_flag => fnd_api.g_true
630: ,x_quantity_reserved => l_qty_reserved
631: ,x_reservation_id => l_reservation_id
632: ,p_partial_rsv_exists => TRUE);

Line 629: ,p_validation_flag => fnd_api.g_true

625: ,p_serial_number => l_in_serial_num
626: ,x_serial_number => l_out_serial_num
627: ,p_partial_reservation_flag => fnd_api.g_true
628: -- ,p_force_reservation_flag => fnd_api.g_true
629: ,p_validation_flag => fnd_api.g_true
630: ,x_quantity_reserved => l_qty_reserved
631: ,x_reservation_id => l_reservation_id
632: ,p_partial_rsv_exists => TRUE);
633: --ns_debug_call('in create2'|| x_msg_data );

Line 646: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

642: || ' qty reserved IS '
643: || l_qty_reserved );
644: END IF;*/
645: IF (l_return_status IN
646: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
647: RAISE create_resvn_err;
648: END IF;
649: /* IF g_debug <= gme_debug.g_log_procedure THEN
650: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 674: x_return_status := fnd_api.g_ret_sts_unexp_error;

670: || ' Error is '
671: || SQLERRM);
672: END IF;*/
673: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
674: x_return_status := fnd_api.g_ret_sts_unexp_error;
675: END create_material_reservation;
676: PROCEDURE validate_mtl_for_reservation(
677: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
678: ,x_msg_data OUT NOCOPY VARCHAR2

Line 689: x_return_status := fnd_api.g_ret_sts_success;

685: fetch_failure EXCEPTION;
686: demand_line_error EXCEPTION;
687: batch_status_error EXCEPTION;
688: BEGIN
689: x_return_status := fnd_api.g_ret_sts_success;
690: l_batch_header_rec.batch_id := p_material_detail_rec.batch_id;
691: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
692: RAISE fetch_failure;
693: END IF;

Line 729: x_return_status := fnd_api.g_ret_sts_error;

725: END IF; /* outer most if */
726: --ns_debug_call('in validate'|| x_msg_data );
727: EXCEPTION
728: WHEN fetch_failure THEN
729: x_return_status := fnd_api.g_ret_sts_error;
730: WHEN demand_line_error THEN
731: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
732: x_msg_data:='GME_INVALID_DEMAND_LINE';
733: x_return_status := fnd_api.g_ret_sts_error;

Line 733: x_return_status := fnd_api.g_ret_sts_error;

729: x_return_status := fnd_api.g_ret_sts_error;
730: WHEN demand_line_error THEN
731: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
732: x_msg_data:='GME_INVALID_DEMAND_LINE';
733: x_return_status := fnd_api.g_ret_sts_error;
734: WHEN batch_status_error THEN
735: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
736: x_msg_data:='GME_INVALID_BATCH_STATUS';
737: x_return_status := fnd_api.g_ret_sts_error;

Line 737: x_return_status := fnd_api.g_ret_sts_error;

733: x_return_status := fnd_api.g_ret_sts_error;
734: WHEN batch_status_error THEN
735: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
736: x_msg_data:='GME_INVALID_BATCH_STATUS';
737: x_return_status := fnd_api.g_ret_sts_error;
738: WHEN OTHERS THEN
739: /* IF g_debug <= gme_debug.g_log_unexpected THEN
740: gme_debug.put_line ( 'When others exception in '
741: || g_pkg_name

Line 748: x_return_status := fnd_api.g_ret_sts_unexp_error;

744: || ' Error is '
745: || SQLERRM);
746: END IF;*/
747: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
748: x_return_status := fnd_api.g_ret_sts_unexp_error;
749: END validate_mtl_for_reservation;
750: PROCEDURE update_reservation (
751: p_reservation_id IN NUMBER
752: ,p_revision IN VARCHAR2 DEFAULT NULL

Line 786: x_return_status := fnd_api.g_ret_sts_success;

782: /* IF g_debug <= gme_debug.g_log_procedure THEN
783: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
784: || l_api_name);
785: END IF;*/
786: x_return_status := fnd_api.g_ret_sts_success;
787: query_reservation (p_reservation_id => p_reservation_id
788: ,x_reservation_rec => l_orig_rsv_rec
789: ,x_return_status => l_return_status);
790: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

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

786: x_return_status := fnd_api.g_ret_sts_success;
787: query_reservation (p_reservation_id => p_reservation_id
788: ,x_reservation_rec => l_orig_rsv_rec
789: ,x_return_status => l_return_status);
790: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
791: RAISE query_resvn_error;
792: END IF;
793: l_rsv_rec.reservation_id := p_reservation_id;
794: if(p_revision is not null)then

Line 820: ,p_init_msg_lst => fnd_api.g_false

816: || p_reservation_id);
817: END IF;*/
818: inv_reservation_pub.update_reservation
819: (p_api_version_number => 1.0
820: ,p_init_msg_lst => fnd_api.g_false
821: ,x_return_status => l_return_status
822: ,x_msg_count => l_msg_count
823: ,x_msg_data => l_msg_data
824: ,p_original_rsv_rec => l_orig_rsv_rec

Line 828: ,p_validation_flag => fnd_api.g_true

824: ,p_original_rsv_rec => l_orig_rsv_rec
825: ,p_to_rsv_rec => l_rsv_rec
826: ,p_original_serial_number => l_serial_number
827: ,p_to_serial_number => l_serial_number
828: ,p_validation_flag => fnd_api.g_true
829: ,p_check_availability => fnd_api.g_true);
830: /*IF g_debug <= gme_debug.g_log_statement THEN
831: gme_debug.put_line
832: ( g_pkg_name

Line 829: ,p_check_availability => fnd_api.g_true);

825: ,p_to_rsv_rec => l_rsv_rec
826: ,p_original_serial_number => l_serial_number
827: ,p_to_serial_number => l_serial_number
828: ,p_validation_flag => fnd_api.g_true
829: ,p_check_availability => fnd_api.g_true);
830: /*IF g_debug <= gme_debug.g_log_statement THEN
831: gme_debug.put_line
832: ( g_pkg_name
833: || '.'

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

839: || l_api_name
840: || 'Error is :'
841: || l_msg_data);
842: END IF;*/
843: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
844: RAISE update_resvn_error;
845: END IF;
846: /* IF g_debug <= gme_debug.g_log_procedure THEN
847: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 864: x_return_status := fnd_api.g_ret_sts_unexp_error;

860: || ' Error is '
861: || SQLERRM);
862: END IF;*/
863: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
864: x_return_status := fnd_api.g_ret_sts_unexp_error;
865: END update_reservation;
866:
867: PROCEDURE query_reservation (
868: p_reservation_id IN NUMBER

Line 887: x_return_status := fnd_api.g_ret_sts_success;

883: /*IF g_debug <= gme_debug.g_log_procedure THEN
884: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
885: || l_api_name);
886: END IF;*/
887: x_return_status := fnd_api.g_ret_sts_success;
888: l_rsv_rec.reservation_id := p_reservation_id;
889: /* IF g_debug <= gme_debug.g_log_statement THEN
890: gme_debug.put_line
891: ( g_pkg_name

Line 899: ,p_init_msg_lst => fnd_api.g_false

895: || p_reservation_id);
896: END IF;*/
897: inv_reservation_pub.query_reservation
898: (p_api_version_number => 1.0
899: ,p_init_msg_lst => fnd_api.g_false
900: ,x_return_status => l_return_status
901: ,x_msg_count => l_msg_count
902: ,x_msg_data => l_msg_data
903: ,p_query_input => l_rsv_rec

Line 904: ,p_lock_records => fnd_api.g_false

900: ,x_return_status => l_return_status
901: ,x_msg_count => l_msg_count
902: ,x_msg_data => l_msg_data
903: ,p_query_input => l_rsv_rec
904: ,p_lock_records => fnd_api.g_false
905: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
906: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
907: ,x_mtl_reservation_tbl => l_rsv_tbl
908: ,x_mtl_reservation_tbl_count => l_rsv_count

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

919: || l_api_name
920: || 'Error is :'
921: || l_msg_data);
922: END IF;*/
923: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
924: RAISE update_resvn_error;
925: END IF;
926: x_reservation_rec := l_rsv_tbl (1);
927: /* IF g_debug <= gme_debug.g_log_procedure THEN

Line 943: x_return_status := fnd_api.g_ret_sts_unexp_error;

939: || ' Error is '
940: || SQLERRM);
941: END IF;
942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);*/
943: x_return_status := fnd_api.g_ret_sts_unexp_error;
944: END query_reservation;
945:
946:
947: