APPS.GML_OPM_ROI_GRP dependencies on GML_OPM_ROI_GRP

Line 1: PACKAGE BODY GML_OPM_ROI_GRP AS

1: PACKAGE BODY GML_OPM_ROI_GRP AS
2: /* $Header: GMLGROIB.pls 115.9 2004/06/03 20:23:28 mchandak ship $*/
3:
4: g_asn_debug VARCHAR2(1):= NVL(FND_PROFILE.VALUE('PO_RVCTP_ENABLE_TRACE'),'N');
5: g_opm_restrict_rma_lots VARCHAR2(100) ;

Line 10: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'GML_OPM_ROI_GRP', p_level => p_level);

6: g_opm_rma_lot_info_exists BOOLEAN ;
7:
8: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
9: BEGIN
10: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => 'GML_OPM_ROI_GRP', p_level => p_level);
11: END print_debug;
12:
13: PROCEDURE insert_errors(p_rti_id IN NUMBER,
14: p_group_id IN NUMBER,

Line 124: asn_debug.put_line('Unhandled exception in gml_opm_roi_grp.insert_errors=>'||substr(sqlerrm,1,200));

120:
121: EXCEPTION
122: WHEN OTHERS THEN
123: IF (g_asn_debug = 'Y') THEN
124: asn_debug.put_line('Unhandled exception in gml_opm_roi_grp.insert_errors=>'||substr(sqlerrm,1,200));
125: END IF;
126: END insert_errors;
127:
128:

Line 292: p_error_message => 'UNHANDLED EXCEPTION IN GML_OPM_ROI_GRP.VALIDATE_QUANTITY_ONHAND :' || l_progress||'-' ||

288: p_group_id => NULL,
289: p_header_interface_id => NULL,
290: p_column_name => 'PRIMARY_QUANTITY',
291: p_table_name => l_table_name,
292: p_error_message => 'UNHANDLED EXCEPTION IN GML_OPM_ROI_GRP.VALIDATE_QUANTITY_ONHAND :' || l_progress||'-' ||
293: substr(sqlerrm,1,1000),
294: p_mesg_owner => NULL,
295: p_Error_Message_name => NULL);
296:

Line 309: PROCEDURE validate_opm_parameters(x_opm_record IN OUT NOCOPY gml_opm_roi_grp.opm_record_type) IS

305: END IF;
306: END validate_quantity_onhand;
307:
308:
309: PROCEDURE validate_opm_parameters(x_opm_record IN OUT NOCOPY gml_opm_roi_grp.opm_record_type) IS
310: l_item_um2 VARCHAR2(4);
311: l_return_status VARCHAR2(1);
312: l_msg_count BINARY_INTEGER;
313: l_msg_data VARCHAR2(2000);

Line 519: PROCEDURE validate_lot_attributes(p_lot_attribute_rec IN OUT NOCOPY gml_opm_roi_grp.lot_attributes_rec_type,

515: END IF;
516:
517: END validate_opm_parameters;
518:
519: PROCEDURE validate_lot_attributes(p_lot_attribute_rec IN OUT NOCOPY gml_opm_roi_grp.lot_attributes_rec_type,
520: p_inventory_item_id IN NUMBER,
521: p_organization_id IN NUMBER,
522: p_trans_date IN DATE,
523: p_rti_id IN NUMBER,

Line 714: PROCEDURE check_lot_status(p_lot_attribute_rec IN OUT NOCOPY gml_opm_roi_grp.lot_attributes_rec_type,

710:
711: END validate_lot_attributes ;
712:
713:
714: PROCEDURE check_lot_status(p_lot_attribute_rec IN OUT NOCOPY gml_opm_roi_grp.lot_attributes_rec_type,
715: p_organization_id IN NUMBER,
716: p_locator_id IN NUMBER,
717: p_trans_date IN DATE,
718: p_rti_id IN NUMBER,

Line 1300: l_pkg_name CONSTANT VARCHAR2(30) := 'GML_OPM_ROI_GRP';

1296: ) IS
1297:
1298: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Opm_Lot';
1299: l_api_version CONSTANT NUMBER := 1.0;
1300: l_pkg_name CONSTANT VARCHAR2(30) := 'GML_OPM_ROI_GRP';
1301:
1302: l_transaction_type rcv_transactions_interface.transaction_type%TYPE ;
1303: l_source_document_code rcv_transactions_interface.source_document_code%TYPE ;
1304: l_item_id NUMBER;

Line 1312: l_lot_attribute_rec gml_opm_roi_grp.lot_attributes_rec_type ;

1308: l_locator_id NUMBER;
1309: l_unit_of_measure rcv_transactions_interface.unit_of_measure%TYPE;
1310: l_secondary_unit_of_measure rcv_transactions_interface.secondary_unit_of_measure%TYPE;
1311: l_validation_flag rcv_transactions_interface.validation_flag%TYPE;
1312: l_lot_attribute_rec gml_opm_roi_grp.lot_attributes_rec_type ;
1313:
1314: l_new_lot_rec GMIGAPI.lot_rec_typ;
1315: l_lot_no ic_lots_mst.lot_no%TYPE;
1316: l_sublot_no ic_lots_mst.sublot_no%TYPE;

Line 2641: END GML_OPM_ROI_GRP ;

2637: END IF;
2638: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data);
2639: END validate_opm_lot;
2640:
2641: END GML_OPM_ROI_GRP ;