APPS.GME_MOBILE_RSRV dependencies on GME_COMMON_PVT

Line 131: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type

127: mr.RESERVATION_ID
128: FROM mtl_reservations mr,
129: wms_item_locations_kfv loc
130: WHERE mr.organization_id = p_organization_id
131: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
132: AND mr.demand_source_header_id = p_batch_id
133: AND mr.demand_source_line_id = p_material_detail_id
134: AND NVL(mr.subinventory_code, '-1') = NVL(p_subinventory_code, '-1')
135: AND NVL(mr.locator_id, -1) = NVL(p_locator_id, -1)

Line 215: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type

211: ,mr.revision
212: FROM mtl_reservations mr,
213: wms_item_locations_kfv loc
214: WHERE mr.organization_id = p_organization_id
215: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
216: AND mr.demand_source_header_id = p_batch_id
217: AND mr.demand_source_line_id = p_material_detail_id
218: AND (p_subinventory_code IS NULL OR (mr.subinventory_code = p_subinventory_code))
219: AND (p_locator_id IS NULL OR (mr.locator_id = p_locator_id))

Line 291: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type

287: ,mr.revision
288: FROM mtl_reservations mr,
289: wms_item_locations_kfv loc
290: WHERE mr.organization_id = p_organization_id
291: AND mr.demand_source_type_id = gme_common_pvt.g_txn_source_type
292: AND mr.demand_source_header_id = p_batch_id
293: AND mr.demand_source_line_id = p_material_detail_id
294: AND (mr.subinventory_code IS NOT NULL)
295: AND (p_revcontrol = 0 OR (p_revcontrol = 1 AND mr.revision IS NOT NULL))

Line 525: , p_demand_source_type_id => gme_common_pvt.g_txn_source_type

521: , p_is_revision_control => l_is_revision_control
522: , p_is_lot_control => l_is_lot_control
523: , p_is_serial_control => FALSE
524: , p_grade_code => NULL
525: , p_demand_source_type_id => gme_common_pvt.g_txn_source_type
526: , p_demand_source_header_id => p_batch_id
527: , p_demand_source_line_id => p_material_detail_id
528: , p_demand_source_name => NULL
529: , p_lot_expiration_date => SYSDATE

Line 886: gme_common_pvt.log_message('GME_RESERVATION_CREATED');

882: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
883: Get_Stacked_Messages(x_message => x_error_msg);
884: /* Bug 5438355: Added success message. */
885: ELSE
886: gme_common_pvt.log_message('GME_RESERVATION_CREATED');
887: gme_common_pvt.count_and_get (x_count => l_msg_count
888: ,p_encoded => fnd_api.g_false
889: ,x_data => x_error_msg);
890: COMMIT;

Line 887: gme_common_pvt.count_and_get (x_count => l_msg_count

883: Get_Stacked_Messages(x_message => x_error_msg);
884: /* Bug 5438355: Added success message. */
885: ELSE
886: gme_common_pvt.log_message('GME_RESERVATION_CREATED');
887: gme_common_pvt.count_and_get (x_count => l_msg_count
888: ,p_encoded => fnd_api.g_false
889: ,x_data => x_error_msg);
890: COMMIT;
891: END IF;

Line 896: gme_common_pvt.count_and_get (x_count => l_msg_count

892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_ERROR THEN
895: x_return_status := fnd_api.g_ret_sts_error;
896: gme_common_pvt.count_and_get (x_count => l_msg_count
897: ,p_encoded => fnd_api.g_false
898: ,x_data => x_error_msg);
899: WHEN OTHERS THEN
900: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 973: gme_common_pvt.log_message('GME_RESERVATION_UPDATED');

969: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
970: Get_Stacked_Messages(x_message => x_error_msg);
971: /* Bug 5438355: Added success message. */
972: ELSE
973: gme_common_pvt.log_message('GME_RESERVATION_UPDATED');
974: Get_Stacked_Messages(x_message => x_error_msg);
975: COMMIT;
976: END IF;
977: