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.GME_MOBILE_TXN dependencies on GME_COMMON_PVT

Line 58: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;

54: l_transaction_type_id NUMBER;
55: BEGIN
56:
57: IF p_transaction_type_id = G_ING_ISSUE THEN
58: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
59: ELSIF p_transaction_type_id = G_ING_RETURN THEN
60: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
61: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
62: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;

Line 60: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;

56:
57: IF p_transaction_type_id = G_ING_ISSUE THEN
58: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
59: ELSIF p_transaction_type_id = G_ING_RETURN THEN
60: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
61: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
62: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
63: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
64: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;

Line 62: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;

58: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
59: ELSIF p_transaction_type_id = G_ING_RETURN THEN
60: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
61: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
62: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
63: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
64: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
65: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
66: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;

Line 64: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;

60: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
61: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
62: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
63: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
64: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
65: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
66: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;
67: ELSIF p_transaction_type_id = G_BYPROD_RETURN THEN
68: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;

Line 66: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;

62: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
63: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
64: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
65: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
66: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;
67: ELSIF p_transaction_type_id = G_BYPROD_RETURN THEN
68: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;
69: END IF;
70:

Line 68: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;

64: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
65: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
66: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;
67: ELSIF p_transaction_type_id = G_BYPROD_RETURN THEN
68: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;
69: END IF;
70:
71: RETURN l_transaction_type_id;
72:

Line 100: IF p_line_type = gme_common_pvt.g_line_type_ing THEN

96: IF p_rsrv_pndlot_id IS NULL THEN
97: RAISE no_rsrv_pndlot_id;
98: END IF;
99:
100: IF p_line_type = gme_common_pvt.g_line_type_ing THEN
101: --calling gme_reservations_pvt API to relieve reservations
102: gme_reservations_pvt.relieve_reservation(p_reservation_id => p_rsrv_pndlot_id,
103: p_prim_relieve_qty => p_relieve_qty,
104: x_return_status => x_return_status);

Line 107: gme_common_pvt.count_and_get (x_count => l_count

103: p_prim_relieve_qty => p_relieve_qty,
104: x_return_status => x_return_status);
105:
106: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
107: gme_common_pvt.count_and_get (x_count => l_count
108: ,p_encoded => fnd_api.g_false
109: ,x_data => x_error_msg);
110:
111: END IF;

Line 119: gme_common_pvt.count_and_get (x_count => l_count

115: ,p_secondary_quantity=> p_sec_qty
116: ,x_return_status => x_return_status);
117:
118: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
119: gme_common_pvt.count_and_get (x_count => l_count
120: ,p_encoded => fnd_api.g_false
121: ,x_data => x_error_msg);
122:
123: END IF;

Line 254: gme_common_pvt.g_user_ident := p_user_id;

250: IF (g_debug IS NOT NULL) THEN
251: gme_debug.log_initialize ('MobileCreTxn');
252: END IF;
253:
254: gme_common_pvt.g_user_ident := p_user_id;
255: gme_common_pvt.g_login_id := p_login_id;
256: gme_common_pvt.set_timestamp;
257:
258: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 255: gme_common_pvt.g_login_id := p_login_id;

251: gme_debug.log_initialize ('MobileCreTxn');
252: END IF;
253:
254: gme_common_pvt.g_user_ident := p_user_id;
255: gme_common_pvt.g_login_id := p_login_id;
256: gme_common_pvt.set_timestamp;
257:
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: x_error_msg := ' ';

Line 256: gme_common_pvt.set_timestamp;

252: END IF;
253:
254: gme_common_pvt.g_user_ident := p_user_id;
255: gme_common_pvt.g_login_id := p_login_id;
256: gme_common_pvt.set_timestamp;
257:
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259: x_error_msg := ' ';
260:

Line 297: -- Bug 5255933 Use GME_COMMON_PVT to get error message

293: x_return_status => x_return_status);
294:
295:
296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- Bug 5255933 Use GME_COMMON_PVT to get error message
298: --x_error_msg := fnd_message.get;
299: GME_COMMON_PVT.count_and_get (x_count => l_count
300: ,p_encoded => fnd_api.g_false
301: ,x_data => x_error_msg);

Line 299: GME_COMMON_PVT.count_and_get (x_count => l_count

295:
296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
297: -- Bug 5255933 Use GME_COMMON_PVT to get error message
298: --x_error_msg := fnd_message.get;
299: GME_COMMON_PVT.count_and_get (x_count => l_count
300: ,p_encoded => fnd_api.g_false
301: ,x_data => x_error_msg);
302:
303: x_txn_id := -1;

Line 364: gme_common_pvt.g_user_ident := p_user_id;

360:
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: x_error_msg := ' ';
363:
364: gme_common_pvt.g_user_ident := p_user_id;
365: gme_common_pvt.g_login_id := p_login_id;
366: gme_common_pvt.set_timestamp;
367:
368: l_mmli_rec_in.lot_number := p_lot_number;

Line 365: gme_common_pvt.g_login_id := p_login_id;

361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: x_error_msg := ' ';
363:
364: gme_common_pvt.g_user_ident := p_user_id;
365: gme_common_pvt.g_login_id := p_login_id;
366: gme_common_pvt.set_timestamp;
367:
368: l_mmli_rec_in.lot_number := p_lot_number;
369: l_mmli_rec_in.transaction_quantity := p_txn_qty;

Line 366: gme_common_pvt.set_timestamp;

362: x_error_msg := ' ';
363:
364: gme_common_pvt.g_user_ident := p_user_id;
365: gme_common_pvt.g_login_id := p_login_id;
366: gme_common_pvt.set_timestamp;
367:
368: l_mmli_rec_in.lot_number := p_lot_number;
369: l_mmli_rec_in.transaction_quantity := p_txn_qty;
370: l_mmli_rec_in.primary_quantity := p_txn_prim_qty;

Line 463: GME_COMMON_PVT.Count_And_Get (x_count => l_msg_count

459: ,x_msg_count =>l_msg_count
460: ,x_msg_data =>l_msg_data))
461:
462: THEN
463: GME_COMMON_PVT.Count_And_Get (x_count => l_msg_count
464: ,p_encoded => fnd_api.g_false
465: ,x_data => x_error_msg);
466:
467: x_return_status := FND_API.G_RET_STS_ERROR;

Line 644: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;

640: FROM mtl_material_transactions
641: WHERE organization_id = p_org_id
642: AND transaction_source_id = p_batch_id
643: AND trx_source_line_id = p_material_detail_id
644: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;
645: BEGIN
646:
647: IF (g_debug IS NOT NULL) THEN
648: gme_debug.log_initialize ('MobileFetchAgrTxns');

Line 713: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type

709: AND lot_number = NVL(p_lot_number, l.lot_number)
710: AND m.organization_id = p_org_id
711: AND m.transaction_source_id = p_batch_id
712: AND m.trx_source_line_id = p_material_detail_id
713: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
714: GROUP BY m.revision,l.lot_number;
715:
716: EXCEPTION
717: WHEN OTHERS THEN

Line 758: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type

754: FROM mtl_material_transactions
755: WHERE organization_id = p_org_id
756: AND transaction_source_id = p_batch_id
757: AND trx_source_line_id = p_material_detail_id
758: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
759: AND revision = p_revision
760: GROUP BY revision;
761: BEGIN
762:

Line 940: gme_common_pvt.g_user_ident := p_user_id;

936: IF (g_debug IS NOT NULL) THEN
937: gme_debug.log_initialize ('MobileProcessTxn');
938: END IF;
939:
940: gme_common_pvt.g_user_ident := p_user_id;
941: gme_common_pvt.g_login_id := p_login_id;
942: gme_common_pvt.set_timestamp;
943:
944: GME_TRANSACTIONS_PVT.Process_Transactions

Line 941: gme_common_pvt.g_login_id := p_login_id;

937: gme_debug.log_initialize ('MobileProcessTxn');
938: END IF;
939:
940: gme_common_pvt.g_user_ident := p_user_id;
941: gme_common_pvt.g_login_id := p_login_id;
942: gme_common_pvt.set_timestamp;
943:
944: GME_TRANSACTIONS_PVT.Process_Transactions
945: (p_api_version => 2.0,

Line 942: gme_common_pvt.set_timestamp;

938: END IF;
939:
940: gme_common_pvt.g_user_ident := p_user_id;
941: gme_common_pvt.g_login_id := p_login_id;
942: gme_common_pvt.set_timestamp;
943:
944: GME_TRANSACTIONS_PVT.Process_Transactions
945: (p_api_version => 2.0,
946: p_init_msg_list => fnd_api.g_false,

Line 961: gme_common_pvt.log_message('PM_SAVED_CHANGES');

957: --x_error_msg := fnd_message.get;
958: x_error_msg := l_msg_data;
959: /* Bug 5438355: Added success message. */
960: ELSE
961: gme_common_pvt.log_message('PM_SAVED_CHANGES');
962: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
963: x_count => l_msg_count,
964: x_data => x_error_msg);
965: END IF;

Line 962: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,

958: x_error_msg := l_msg_data;
959: /* Bug 5438355: Added success message. */
960: ELSE
961: gme_common_pvt.log_message('PM_SAVED_CHANGES');
962: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
963: x_count => l_msg_count,
964: x_data => x_error_msg);
965: END IF;
966:

Line 969: GME_COMMON_PVT.g_transaction_header_id := NULL;

965: END IF;
966:
967: --- Reseting this global variable. I guess this should be done in
968: --- GME_TRANSACTIONS_PVT.Process_Transactions
969: GME_COMMON_PVT.g_transaction_header_id := NULL;
970:
971: EXCEPTION
972: WHEN OTHERS THEN
973: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 1181: gme_common_pvt.count_and_get (x_count => l_msg_count,

1177: || 'When others exception:'
1178: || SQLERRM);
1179: END IF;
1180:
1181: gme_common_pvt.count_and_get (x_count => l_msg_count,
1182: p_encoded => fnd_api.g_false,
1183: x_data => x_error_msg);
1184: x_return_status := fnd_api.g_ret_sts_unexp_error;
1185:

Line 1742: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;

1738: l_msg_data VARCHAR2(2000);
1739: l_msg_index NUMBER;
1740: l_batch_header GME_BATCH_HEADER%ROWTYPE;
1741: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;
1742: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;
1743:
1744: BACKFLUSH_ERROR EXCEPTION;
1745:
1746: BEGIN

Line 1768: ,p_validation_level => gme_common_pvt.g_max_errors

1764: l_batch_header.batch_id := p_batch_id;
1765:
1766: GME_API_PUB.Incremental_Backflush
1767: (p_api_version => 2.0
1768: ,p_validation_level => gme_common_pvt.g_max_errors
1769: ,p_init_msg_list => fnd_api.g_false
1770: ,p_commit => fnd_api.g_true
1771: ,x_message_count => l_msg_count
1772: ,x_message_list => l_msg_list

Line 1860: gme_common_pvt.g_user_ident := p_uid;

1856: gme_debug.log_initialize ('MobileSaveRsrcUsage');
1857: END IF;
1858:
1859: fnd_profile.put('USER_ID',to_char(p_uid));
1860: gme_common_pvt.g_user_ident := p_uid;
1861:
1862: l_input_rec.batchstep_resource_id := p_resource_id;
1863: l_input_rec.actual_rsrc_count := to_number(p_count);
1864: l_input_rec.actual_rsrc_usage := to_number(p_usage);

Line 2160: ,p_validation_level => gme_common_pvt.g_max_errors

2156: l_pending_product_lots_rec.reason_id := p_reason_id;
2157:
2158: GME_API_PUB.create_pending_product_lot
2159: (p_api_version => 2.0
2160: ,p_validation_level => gme_common_pvt.g_max_errors
2161: ,p_init_msg_list => fnd_api.g_true
2162: ,p_commit => fnd_api.g_true
2163: ,x_message_count => l_message_count
2164: ,x_message_list => x_error_msg

Line 2297: ,p_validation_level => gme_common_pvt.g_max_errors

2293: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2294:
2295: GME_API_PUB.update_pending_product_lot
2296: (p_api_version => 2.0
2297: ,p_validation_level => gme_common_pvt.g_max_errors
2298: ,p_init_msg_list => fnd_api.g_true
2299: ,p_commit => fnd_api.g_true
2300: ,x_message_count => l_message_count
2301: ,x_message_list => l_message_list

Line 2363: l_rsrv_tab GME_COMMON_PVT.reservations_tab;

2359: l_msg_data VARCHAR2(2000);
2360: l_index INTEGER;
2361: l_nb_rec NUMBER;
2362: l_dispensed NUMBER := 0;
2363: l_rsrv_tab GME_COMMON_PVT.reservations_tab;
2364:
2365: BEGIN
2366:
2367: IF (g_debug IS NOT NULL) THEN

Line 2739: , p_demand_source_type_id => gme_common_pvt.g_txn_source_type

2735: , p_is_revision_control => l_is_revision_control
2736: , p_is_lot_control => l_is_lot_control
2737: , p_is_serial_control => FALSE
2738: , p_grade_code => NULL
2739: , p_demand_source_type_id => gme_common_pvt.g_txn_source_type
2740: , p_demand_source_name => NULL
2741: , p_lot_expiration_date => SYSDATE
2742: , p_onhand_source => 3
2743: , x_tree_id => x_tree_id

Line 3094: IF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN

3090: END IF;
3091:
3092: -- If the ingredient line has a release type of auto by step then the
3093: -- associated step must be in WIP or Completed
3094: IF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3095: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3096: p_material_detail_id => p_material_detail_id
3097: ,x_batchstep_id => l_batchstep_id
3098: ,x_batchstep_status => l_batchstep_status);

Line 3095: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(

3091:
3092: -- If the ingredient line has a release type of auto by step then the
3093: -- associated step must be in WIP or Completed
3094: IF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3095: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3096: p_material_detail_id => p_material_detail_id
3097: ,x_batchstep_id => l_batchstep_id
3098: ,x_batchstep_status => l_batchstep_status);
3099: IF l_is_item_associated_to_step AND

Line 3267: IF l_release_type = GME_COMMON_PVT.g_mtl_auto_release THEN

3263: -- If product release type is Automatic By Step, then:
3264: -- a) if associated to a step, step status must be Completed
3265: -- b) if not associated to a step, batch status must be Completed
3266:
3267: IF l_release_type = GME_COMMON_PVT.g_mtl_auto_release THEN
3268: IF l_batch_status <> 3 THEN
3269: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3270: RAISE ITEM_NOT_VALID;
3271: END IF;

Line 3272: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN

3268: IF l_batch_status <> 3 THEN
3269: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3270: RAISE ITEM_NOT_VALID;
3271: END IF;
3272: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3273: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3274: p_material_detail_id => p_material_detail_id
3275: ,x_batchstep_id => l_batchstep_id
3276: ,x_batchstep_status => l_batchstep_status);

Line 3273: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(

3269: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3270: RAISE ITEM_NOT_VALID;
3271: END IF;
3272: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3273: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3274: p_material_detail_id => p_material_detail_id
3275: ,x_batchstep_id => l_batchstep_id
3276: ,x_batchstep_status => l_batchstep_status);
3277: IF l_is_item_associated_to_step THEN

Line 3365: AND m.transaction_type_id = GME_COMMON_PVT.g_ing_issue

3361: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3362: AND m.organization_id = p_organization_id
3363: AND m.transaction_source_id = p_batch_id
3364: AND m.trx_source_line_id = p_material_detail_id
3365: AND m.transaction_type_id = GME_COMMON_PVT.g_ing_issue
3366: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
3367: AND lc.inventory_location_id(+) = m.locator_id;
3368:
3369: EXCEPTION

Line 3366: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type

3362: AND m.organization_id = p_organization_id
3363: AND m.transaction_source_id = p_batch_id
3364: AND m.trx_source_line_id = p_material_detail_id
3365: AND m.transaction_type_id = GME_COMMON_PVT.g_ing_issue
3366: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
3367: AND lc.inventory_location_id(+) = m.locator_id;
3368:
3369: EXCEPTION
3370: WHEN OTHERS THEN

Line 3445: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type

3441: AND m.organization_id = p_organization_id
3442: AND m.transaction_source_id = p_batch_id
3443: AND m.trx_source_line_id = p_material_detail_id
3444: AND m.transaction_type_id = l_txn_type_id
3445: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
3446: AND lc.inventory_location_id(+) = m.locator_id;
3447:
3448: EXCEPTION
3449: WHEN OTHERS THEN

Line 3497: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

3493: WHERE transaction_interface_id = v_transaction_id;
3494:
3495: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM_TXN';
3496: l_mmti_rec mtl_transactions_interface%ROWTYPE;
3497: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3498: BEGIN
3499:
3500: IF (g_debug IS NOT NULL) THEN
3501: gme_debug.log_initialize ('MobileCreatePhantomTxn');

Line 3516: gme_common_pvt.log_message('GME_NO_TRANS_FOUND');

3512: OPEN cur_get_transaction(p_mmti_trans_id);
3513: FETCH cur_get_transaction INTO l_mmti_rec;
3514: IF cur_get_transaction%NOTFOUND THEN
3515: CLOSE cur_get_transaction;
3516: gme_common_pvt.log_message('GME_NO_TRANS_FOUND');
3517: RAISE fnd_api.g_exc_error;
3518: END IF;
3519: CLOSE cur_get_transaction;
3520:

Line 3527: (gme_common_pvt.g_ing_return

3523: BULK COLLECT INTO l_mmli_tbl;
3524: CLOSE cur_get_lot_transaction;
3525:
3526: IF l_mmti_rec.transaction_type_id NOT IN
3527: (gme_common_pvt.g_ing_return
3528: ,gme_common_pvt.g_prod_completion
3529: ,gme_common_pvt.g_byprod_completion) THEN
3530:
3531:

Line 3528: ,gme_common_pvt.g_prod_completion

3524: CLOSE cur_get_lot_transaction;
3525:
3526: IF l_mmti_rec.transaction_type_id NOT IN
3527: (gme_common_pvt.g_ing_return
3528: ,gme_common_pvt.g_prod_completion
3529: ,gme_common_pvt.g_byprod_completion) THEN
3530:
3531:
3532: FOR i IN 1..l_mmli_tbl.COUNT

Line 3529: ,gme_common_pvt.g_byprod_completion) THEN

3525:
3526: IF l_mmti_rec.transaction_type_id NOT IN
3527: (gme_common_pvt.g_ing_return
3528: ,gme_common_pvt.g_prod_completion
3529: ,gme_common_pvt.g_byprod_completion) THEN
3530:
3531:
3532: FOR i IN 1..l_mmli_tbl.COUNT
3533: LOOP

Line 3547: GME_COMMON_PVT.G_MOVE_TO_TEMP := FND_API.G_FALSE;

3543: (-1) * l_mmti_rec.secondary_transaction_quantity;
3544:
3545: END IF;
3546:
3547: GME_COMMON_PVT.G_MOVE_TO_TEMP := FND_API.G_FALSE;
3548:
3549: GME_TRANSACTIONS_PVT.Create_Material_Txn
3550:
3551: (p_mmti_rec => l_mmti_rec

Line 3616: x_exception_material gme_common_pvt.exceptions_tab;

3612: l_batch_step gme_batch_steps%ROWTYPE;
3613: l_batch_step_out gme_batch_steps%ROWTYPE;
3614: x_batch_step gme_batch_steps%ROWTYPE;
3615: l_batch_header gme_batch_header%ROWTYPE;
3616: x_exception_material gme_common_pvt.exceptions_tab;
3617: step_alloc_error EXCEPTION;
3618: expected_error EXCEPTION;
3619: validate_step_error EXCEPTION;
3620: validate_step_status_error EXCEPTION;

Line 3630: gme_common_pvt.g_user_name := p_uname;

3626: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3627: l_act_complt_dt := TO_DATE(p_act_complt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3628:
3629: fnd_profile.put('USER_ID',to_char(p_uid));
3630: gme_common_pvt.g_user_name := p_uname;
3631: gme_common_pvt.g_user_ident := p_uid;
3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3634:

Line 3631: gme_common_pvt.g_user_ident := p_uid;

3627: l_act_complt_dt := TO_DATE(p_act_complt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3628:
3629: fnd_profile.put('USER_ID',to_char(p_uid));
3630: gme_common_pvt.g_user_name := p_uname;
3631: gme_common_pvt.g_user_ident := p_uid;
3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3634:
3635: l_batch_header.batch_id := p_batch_id;

Line 3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3628:
3629: fnd_profile.put('USER_ID',to_char(p_uid));
3630: gme_common_pvt.g_user_name := p_uname;
3631: gme_common_pvt.g_user_ident := p_uid;
3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3634:
3635: l_batch_header.batch_id := p_batch_id;
3636: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN

Line 3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3629: fnd_profile.put('USER_ID',to_char(p_uid));
3630: gme_common_pvt.g_user_name := p_uname;
3631: gme_common_pvt.g_user_ident := p_uid;
3632: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3633: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3634:
3635: l_batch_header.batch_id := p_batch_id;
3636: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN
3637: RAISE expected_error;

Line 3652: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR

3648:
3649: -- Bug 4774944 Rework.
3650: -- Check for 'Step controls batch status' parameter.
3651: IF l_batch_header.batch_status = 1 AND
3652: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR
3653: l_batch_header.parentline_id IS NOT NULL ) THEN
3654: RAISE validate_step_status_error;
3655: END IF;
3656:

Line 3671: p_validation_level => gme_common_pvt.g_max_errors,

3667: RAISE validate_step_error;
3668: END IF;
3669:
3670: gme_api_main.complete_step (
3671: p_validation_level => gme_common_pvt.g_max_errors,
3672: p_init_msg_list => FND_API.G_TRUE,
3673: x_message_count => x_message_count,
3674: x_message_list => x_message_list,
3675: x_return_status => x_return_status,

Line 3706: gme_common_pvt.count_and_get (x_count => x_message_count

3702: ROLLBACK TO SAVEPOINT complete_step_mobile ;
3703: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3704: x_message_list := FND_MESSAGE.GET;
3705: WHEN validate_step_error THEN
3706: gme_common_pvt.count_and_get (x_count => x_message_count
3707: ,p_encoded => fnd_api.g_false
3708: ,x_data => x_message_list);
3709: WHEN validate_step_status_error THEN
3710: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');

Line 3741: gme_common_pvt.g_user_name := p_uname;

3737: BEGIN
3738: x_return_status := FND_API.G_RET_STS_SUCCESS;
3739: x_error_msg := '';
3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;
3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3745:

Line 3742: gme_common_pvt.g_user_ident := p_uid;

3738: x_return_status := FND_API.G_RET_STS_SUCCESS;
3739: x_error_msg := '';
3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;
3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3745:
3746: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;

Line 3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3739: x_error_msg := '';
3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;
3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3745:
3746: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3747: l_in_rsrc_txn_rec.organization_id := p_organization_id;

Line 3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3740: FND_PROFILE.put('USER_ID',to_char(p_uid));
3741: gme_common_pvt.g_user_name := p_uname;
3742: gme_common_pvt.g_user_ident := p_uid;
3743: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3744: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3745:
3746: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3747: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3748: l_in_rsrc_txn_rec.trans_date := p_trans_date;

Line 3820: x_exception_material gme_common_pvt.exceptions_tab;

3816: l_batch_step gme_batch_steps%ROWTYPE;
3817: l_batch_step_out gme_batch_steps%ROWTYPE;
3818: x_batch_step gme_batch_steps%ROWTYPE;
3819: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3820: x_exception_material gme_common_pvt.exceptions_tab;
3821: step_alloc_error EXCEPTION;
3822: expected_error EXCEPTION;
3823: validate_step_error EXCEPTION;
3824: validate_step_status_error EXCEPTION;

Line 3832: gme_common_pvt.g_user_name := p_uname;

3828:
3829: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3830:
3831: fnd_profile.put('USER_ID',to_char(p_uid));
3832: gme_common_pvt.g_user_name := p_uname;
3833: gme_common_pvt.g_user_ident := p_uid;
3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3836:

Line 3833: gme_common_pvt.g_user_ident := p_uid;

3829: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3830:
3831: fnd_profile.put('USER_ID',to_char(p_uid));
3832: gme_common_pvt.g_user_name := p_uname;
3833: gme_common_pvt.g_user_ident := p_uid;
3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3836:
3837: l_batch_hdr_rec.batch_id := p_batch_id;

Line 3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3830:
3831: fnd_profile.put('USER_ID',to_char(p_uid));
3832: gme_common_pvt.g_user_name := p_uname;
3833: gme_common_pvt.g_user_ident := p_uid;
3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3836:
3837: l_batch_hdr_rec.batch_id := p_batch_id;
3838: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN

Line 3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3831: fnd_profile.put('USER_ID',to_char(p_uid));
3832: gme_common_pvt.g_user_name := p_uname;
3833: gme_common_pvt.g_user_ident := p_uid;
3834: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3835: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3836:
3837: l_batch_hdr_rec.batch_id := p_batch_id;
3838: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN
3839: RAISE expected_error;

Line 3852: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR

3848:
3849: -- Bug 4774944 Rework.
3850: -- Check for 'Step controls batch status' parameter.
3851: IF l_batch_hdr_rec.batch_status = 1 AND
3852: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR
3853: l_batch_hdr_rec.parentline_id IS NOT NULL ) THEN
3854: RAISE validate_step_status_error;
3855: END IF;
3856:

Line 3871: p_validation_level => gme_common_pvt.g_max_errors,

3867: RAISE validate_step_error;
3868: END IF;
3869:
3870: gme_api_main.release_step (
3871: p_validation_level => gme_common_pvt.g_max_errors,
3872: p_init_msg_list => FND_API.G_TRUE,
3873: x_message_count => x_message_count,
3874: x_message_list => x_message_list,
3875: x_return_status => x_return_status,

Line 3892: GME_COMMON_PVT.count_and_get (x_count => l_count

3888: ROLLBACK TO SAVEPOINT release_step_mobile ;
3889: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3890: x_message_list := FND_MESSAGE.GET;
3891: WHEN validate_step_error THEN
3892: GME_COMMON_PVT.count_and_get (x_count => l_count
3893: ,p_encoded => fnd_api.g_false
3894: ,x_data => x_message_list);
3895:
3896: WHEN validate_step_status_error THEN

Line 3928: gme_common_pvt.g_user_name := p_uname;

3924: BEGIN
3925: x_return_status := FND_API.G_RET_STS_SUCCESS;
3926: x_error_msg := '';
3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;
3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3932: l_in_rsrc_txn_rec.line_id := p_resource_id;

Line 3929: gme_common_pvt.g_user_ident := p_uid;

3925: x_return_status := FND_API.G_RET_STS_SUCCESS;
3926: x_error_msg := '';
3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;
3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3932: l_in_rsrc_txn_rec.line_id := p_resource_id;
3933: l_in_rsrc_txn_rec.organization_id := p_organization_id;

Line 3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));

3926: x_error_msg := '';
3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;
3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3932: l_in_rsrc_txn_rec.line_id := p_resource_id;
3933: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3934: l_in_rsrc_txn_rec.start_date := p_start_date;

Line 3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

3927: FND_PROFILE.put('USER_ID',to_char(p_uid));
3928: gme_common_pvt.g_user_name := p_uname;
3929: gme_common_pvt.g_user_ident := p_uid;
3930: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3931: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3932: l_in_rsrc_txn_rec.line_id := p_resource_id;
3933: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3934: l_in_rsrc_txn_rec.start_date := p_start_date;
3935: l_in_rsrc_txn_rec.end_date := p_start_date;

Line 4094: IF NOT (gme_common_pvt.check_close_period(p_org_id, p_trans_date)) THEN

4090: x_message OUT NOCOPY VARCHAR2) IS
4091: l_count NUMBER;
4092: BEGIN
4093: x_return_status := FND_API.G_RET_STS_SUCCESS;
4094: IF NOT (gme_common_pvt.check_close_period(p_org_id, p_trans_date)) THEN
4095: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
4096: x_count => l_count,
4097: x_data => x_message);
4098: END IF;

Line 4095: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,

4091: l_count NUMBER;
4092: BEGIN
4093: x_return_status := FND_API.G_RET_STS_SUCCESS;
4094: IF NOT (gme_common_pvt.check_close_period(p_org_id, p_trans_date)) THEN
4095: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
4096: x_count => l_count,
4097: x_data => x_message);
4098: END IF;
4099: END check_close_period;

Line 4146: --calling gme_common_pvt routine

4142:
4143: x_return_status := fnd_api.g_ret_sts_success;
4144: x_error_msg := ' ';
4145:
4146: --calling gme_common_pvt routine
4147: gme_common_pvt.fetch_trans_date(p_material_detail_id => p_material_detail_id,
4148: p_invoke_mode => 'T',
4149: x_trans_date => l_trans_date,
4150: x_return_status => x_return_status);

Line 4147: gme_common_pvt.fetch_trans_date(p_material_detail_id => p_material_detail_id,

4143: x_return_status := fnd_api.g_ret_sts_success;
4144: x_error_msg := ' ';
4145:
4146: --calling gme_common_pvt routine
4147: gme_common_pvt.fetch_trans_date(p_material_detail_id => p_material_detail_id,
4148: p_invoke_mode => 'T',
4149: x_trans_date => l_trans_date,
4150: x_return_status => x_return_status);
4151:

Line 4153: gme_common_pvt.count_and_get (x_count => l_count

4149: x_trans_date => l_trans_date,
4150: x_return_status => x_return_status);
4151:
4152: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4153: gme_common_pvt.count_and_get (x_count => l_count
4154: ,p_encoded => fnd_api.g_false
4155: ,x_data => x_error_msg);
4156:
4157: END IF;