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.

[Home] [Help]

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 602: x_return_status := fnd_api.g_ret_sts_error;

598: GMD.material_detail_id =p_material_detail_id and RES.DEMAND_SOURCE_HEADER_ID (+) = GMD.BATCH_ID
599: AND RES.DEMAND_SOURCE_LINE_ID(+) = GMD.MATERIAL_DETAIL_ID;
600: EXCEPTION
601: WHEN error_get_item THEN
602: x_return_status := fnd_api.g_ret_sts_error;
603: WHEN OTHERS THEN
604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');

Line 605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;

601: WHEN error_get_item THEN
602: x_return_status := fnd_api.g_ret_sts_error;
603: WHEN OTHERS THEN
604: --ns_debug_call('create Mtl Reservation : ERROR_TEXT :'||SQLERRM);
605: x_return_status := fnd_api.G_RET_STS_UNEXP_ERROR;
606: FND_MESSAGE.SET_NAME('GMO','GMO_VBATCH_UNEXPECTED_DB_ERR');
607: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
608: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
609: END create_material_reservation;

Line 654: x_return_status := fnd_api.g_ret_sts_success;

650: gme_debug.put_line ('input value plan_qty => ' || p_matl_dtl_rec.plan_qty);
651: gme_debug.put_line ('input value resv_um => ' || p_resv_um );
652: gme_debug.put_line ('input value release_type => ' || p_matl_dtl_rec.release_type );
653: END IF;*/
654: x_return_status := fnd_api.g_ret_sts_success;
655: --Bug#4604943 Begin validate the batch and material line
656: validate_mtl_for_reservation(
657: p_material_detail_rec => p_matl_dtl_rec
658: ,x_return_status => l_return_status

Line 661: IF l_return_status <> fnd_api.g_ret_sts_success THEN

657: p_material_detail_rec => p_matl_dtl_rec
658: ,x_return_status => l_return_status
659: ,x_msg_count => x_msg_count
660: ,x_msg_data => x_msg_data);
661: IF l_return_status <> fnd_api.g_ret_sts_success THEN
662: RAISE invalid_mtl_for_rsrv;
663: END IF;
664: --Bug#4604943 End
665: l_rsv_rec.requirement_date := p_matl_dtl_rec.material_requirement_date;

Line 734: ,p_init_msg_lst => fnd_api.g_false

730: -- nsinghi Bug5176319. Commented p_force_reservation_flag parameter. As per inv team, onhand could be -ve
731: -- before reservation, and hence this parameter should not be used.
732: inv_reservation_pub.create_reservation
733: (p_api_version_number => 1.0
734: ,p_init_msg_lst => fnd_api.g_false
735: ,x_return_status => l_return_status
736: ,x_msg_count => x_msg_count
737: ,x_msg_data => x_msg_data
738: ,p_rsv_rec => l_rsv_rec

Line 741: ,p_partial_reservation_flag => fnd_api.g_true

737: ,x_msg_data => x_msg_data
738: ,p_rsv_rec => l_rsv_rec
739: ,p_serial_number => l_in_serial_num
740: ,x_serial_number => l_out_serial_num
741: ,p_partial_reservation_flag => fnd_api.g_true
742: -- ,p_force_reservation_flag => fnd_api.g_true
743: ,p_validation_flag => fnd_api.g_true
744: ,x_quantity_reserved => l_qty_reserved
745: ,x_reservation_id => l_reservation_id

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

738: ,p_rsv_rec => l_rsv_rec
739: ,p_serial_number => l_in_serial_num
740: ,x_serial_number => l_out_serial_num
741: ,p_partial_reservation_flag => fnd_api.g_true
742: -- ,p_force_reservation_flag => fnd_api.g_true
743: ,p_validation_flag => fnd_api.g_true
744: ,x_quantity_reserved => l_qty_reserved
745: ,x_reservation_id => l_reservation_id
746: ,p_partial_rsv_exists => TRUE);

Line 743: ,p_validation_flag => fnd_api.g_true

739: ,p_serial_number => l_in_serial_num
740: ,x_serial_number => l_out_serial_num
741: ,p_partial_reservation_flag => fnd_api.g_true
742: -- ,p_force_reservation_flag => fnd_api.g_true
743: ,p_validation_flag => fnd_api.g_true
744: ,x_quantity_reserved => l_qty_reserved
745: ,x_reservation_id => l_reservation_id
746: ,p_partial_rsv_exists => TRUE);
747: --ns_debug_call('in create2'|| x_msg_data );

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

756: || ' qty reserved IS '
757: || l_qty_reserved );
758: END IF;*/
759: IF (l_return_status IN
760: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
761: RAISE create_resvn_err;
762: END IF;
763: /* IF g_debug <= gme_debug.g_log_procedure THEN
764: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

Line 788: x_return_status := fnd_api.g_ret_sts_unexp_error;

784: || ' Error is '
785: || SQLERRM);
786: END IF;*/
787: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
788: x_return_status := fnd_api.g_ret_sts_unexp_error;
789: END create_material_reservation;
790: PROCEDURE validate_mtl_for_reservation(
791: p_material_detail_rec IN GME_MATERIAL_DETAILS%ROWTYPE
792: ,x_msg_data OUT NOCOPY VARCHAR2

Line 803: x_return_status := fnd_api.g_ret_sts_success;

799: fetch_failure EXCEPTION;
800: demand_line_error EXCEPTION;
801: batch_status_error EXCEPTION;
802: BEGIN
803: x_return_status := fnd_api.g_ret_sts_success;
804: l_batch_header_rec.batch_id := p_material_detail_rec.batch_id;
805: IF NOT (gme_batch_header_dbl.fetch_row (l_batch_header_rec, l_batch_header_rec)) THEN
806: RAISE fetch_failure;
807: END IF;

Line 843: x_return_status := fnd_api.g_ret_sts_error;

839: END IF; /* outer most if */
840: --ns_debug_call('in validate'|| x_msg_data );
841: EXCEPTION
842: WHEN fetch_failure THEN
843: x_return_status := fnd_api.g_ret_sts_error;
844: WHEN demand_line_error THEN
845: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
846: x_msg_data:='GME_INVALID_DEMAND_LINE';
847: x_return_status := fnd_api.g_ret_sts_error;

Line 847: x_return_status := fnd_api.g_ret_sts_error;

843: x_return_status := fnd_api.g_ret_sts_error;
844: WHEN demand_line_error THEN
845: gme_common_pvt.log_message('GME_INVALID_DEMAND_LINE');
846: x_msg_data:='GME_INVALID_DEMAND_LINE';
847: x_return_status := fnd_api.g_ret_sts_error;
848: WHEN batch_status_error THEN
849: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
850: x_msg_data:='GME_INVALID_BATCH_STATUS';
851: x_return_status := fnd_api.g_ret_sts_error;

Line 851: x_return_status := fnd_api.g_ret_sts_error;

847: x_return_status := fnd_api.g_ret_sts_error;
848: WHEN batch_status_error THEN
849: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS','PROCESS','RESERVATIONS');
850: x_msg_data:='GME_INVALID_BATCH_STATUS';
851: x_return_status := fnd_api.g_ret_sts_error;
852: WHEN OTHERS THEN
853: /* IF g_debug <= gme_debug.g_log_unexpected THEN
854: gme_debug.put_line ( 'When others exception in '
855: || g_pkg_name

Line 862: x_return_status := fnd_api.g_ret_sts_unexp_error;

858: || ' Error is '
859: || SQLERRM);
860: END IF;*/
861: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
862: x_return_status := fnd_api.g_ret_sts_unexp_error;
863: END validate_mtl_for_reservation;
864: PROCEDURE update_reservation (
865: p_reservation_id IN NUMBER
866: ,p_revision IN VARCHAR2 DEFAULT NULL

Line 902: x_return_status := fnd_api.g_ret_sts_success;

898: /* IF g_debug <= gme_debug.g_log_procedure THEN
899: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
900: || l_api_name);
901: END IF;*/
902: x_return_status := fnd_api.g_ret_sts_success;
903: query_reservation (p_reservation_id => p_reservation_id
904: ,x_reservation_rec => l_orig_rsv_rec
905: ,x_return_status => l_return_status);
906: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

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

902: x_return_status := fnd_api.g_ret_sts_success;
903: query_reservation (p_reservation_id => p_reservation_id
904: ,x_reservation_rec => l_orig_rsv_rec
905: ,x_return_status => l_return_status);
906: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
907: RAISE query_resvn_error;
908: END IF;
909: l_rsv_rec.reservation_id := p_reservation_id;
910: if(p_revision is not null)then

Line 929: ,p_init_msg_lst => fnd_api.g_false

925: l_rsv_rec.requirement_date := p_new_date;
926:
927: inv_reservation_pub.update_reservation
928: (p_api_version_number => 1.0
929: ,p_init_msg_lst => fnd_api.g_false
930: ,x_return_status => l_return_status
931: ,x_msg_count => x_msg_count
932: ,x_msg_data => x_msg_data
933: ,p_original_rsv_rec => l_orig_rsv_rec

Line 937: ,p_validation_flag => fnd_api.g_true

933: ,p_original_rsv_rec => l_orig_rsv_rec
934: ,p_to_rsv_rec => l_rsv_rec
935: ,p_original_serial_number => l_serial_number
936: ,p_to_serial_number => l_serial_number
937: ,p_validation_flag => fnd_api.g_true
938: ,p_check_availability => fnd_api.g_true);
939:
940:
941: EXCEPTION

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

934: ,p_to_rsv_rec => l_rsv_rec
935: ,p_original_serial_number => l_serial_number
936: ,p_to_serial_number => l_serial_number
937: ,p_validation_flag => fnd_api.g_true
938: ,p_check_availability => fnd_api.g_true);
939:
940:
941: EXCEPTION
942: WHEN query_resvn_error THEN

Line 956: x_return_status := fnd_api.g_ret_sts_unexp_error;

952: || ' Error is '
953: || SQLERRM);
954: END IF;*/
955: --fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
956: x_return_status := fnd_api.g_ret_sts_unexp_error;
957: END update_reservation;
958:
959: PROCEDURE query_reservation (
960: p_reservation_id IN NUMBER

Line 979: x_return_status := fnd_api.g_ret_sts_success;

975: /*IF g_debug <= gme_debug.g_log_procedure THEN
976: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
977: || l_api_name);
978: END IF;*/
979: x_return_status := fnd_api.g_ret_sts_success;
980: l_rsv_rec.reservation_id := p_reservation_id;
981: /* IF g_debug <= gme_debug.g_log_statement THEN
982: gme_debug.put_line
983: ( g_pkg_name

Line 991: ,p_init_msg_lst => fnd_api.g_false

987: || p_reservation_id);
988: END IF;*/
989: inv_reservation_pub.query_reservation
990: (p_api_version_number => 1.0
991: ,p_init_msg_lst => fnd_api.g_false
992: ,x_return_status => l_return_status
993: ,x_msg_count => l_msg_count
994: ,x_msg_data => l_msg_data
995: ,p_query_input => l_rsv_rec

Line 996: ,p_lock_records => fnd_api.g_false

992: ,x_return_status => l_return_status
993: ,x_msg_count => l_msg_count
994: ,x_msg_data => l_msg_data
995: ,p_query_input => l_rsv_rec
996: ,p_lock_records => fnd_api.g_false
997: ,p_sort_by_req_date => inv_reservation_global.g_query_no_sort
998: ,p_cancel_order_mode => inv_reservation_global.g_cancel_order_no
999: ,x_mtl_reservation_tbl => l_rsv_tbl
1000: ,x_mtl_reservation_tbl_count => l_rsv_count

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

1011: || l_api_name
1012: || 'Error is :'
1013: || l_msg_data);
1014: END IF;*/
1015: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1016: RAISE update_resvn_error;
1017: END IF;
1018: x_reservation_rec := l_rsv_tbl (1);
1019: /* IF g_debug <= gme_debug.g_log_procedure THEN

Line 1035: x_return_status := fnd_api.g_ret_sts_unexp_error;

1031: || ' Error is '
1032: || SQLERRM);
1033: END IF;
1034: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);*/
1035: x_return_status := fnd_api.g_ret_sts_unexp_error;
1036: END query_reservation;
1037:
1038:
1039: