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 76: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;

72: l_transaction_type_id NUMBER;
73: BEGIN
74:
75: IF p_transaction_type_id = G_ING_ISSUE THEN
76: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
77: ELSIF p_transaction_type_id = G_ING_RETURN THEN
78: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
79: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
80: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;

Line 78: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;

74:
75: IF p_transaction_type_id = G_ING_ISSUE THEN
76: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
77: ELSIF p_transaction_type_id = G_ING_RETURN THEN
78: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
79: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
80: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
81: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
82: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;

Line 80: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;

76: l_transaction_type_id := GME_COMMON_PVT.g_ing_issue;
77: ELSIF p_transaction_type_id = G_ING_RETURN THEN
78: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
79: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
80: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
81: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
82: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
83: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
84: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;

Line 82: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;

78: l_transaction_type_id := GME_COMMON_PVT.g_ing_return;
79: ELSIF p_transaction_type_id = G_PROD_COMPLETION THEN
80: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
81: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
82: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
83: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
84: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;
85: ELSIF p_transaction_type_id = G_BYPROD_RETURN THEN
86: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;

Line 84: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;

80: l_transaction_type_id := GME_COMMON_PVT.g_prod_completion;
81: ELSIF p_transaction_type_id = G_PROD_RETURN THEN
82: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
83: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
84: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;
85: ELSIF p_transaction_type_id = G_BYPROD_RETURN THEN
86: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;
87: END IF;
88:

Line 86: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;

82: l_transaction_type_id := GME_COMMON_PVT.g_prod_return;
83: ELSIF p_transaction_type_id = G_BYPROD_COMPLETION THEN
84: l_transaction_type_id := GME_COMMON_PVT.g_byprod_completion;
85: ELSIF p_transaction_type_id = G_BYPROD_RETURN THEN
86: l_transaction_type_id := GME_COMMON_PVT.g_byprod_return;
87: END IF;
88:
89: RETURN l_transaction_type_id;
90:

Line 118: IF p_line_type = gme_common_pvt.g_line_type_ing THEN

114: IF p_rsrv_pndlot_id IS NULL THEN
115: RAISE no_rsrv_pndlot_id;
116: END IF;
117:
118: IF p_line_type = gme_common_pvt.g_line_type_ing THEN
119: --calling gme_reservations_pvt API to relieve reservations
120: gme_reservations_pvt.relieve_reservation(p_reservation_id => p_rsrv_pndlot_id,
121: p_prim_relieve_qty => p_relieve_qty,
122: x_return_status => x_return_status);

Line 125: gme_common_pvt.count_and_get (x_count => l_count

121: p_prim_relieve_qty => p_relieve_qty,
122: x_return_status => x_return_status);
123:
124: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
125: gme_common_pvt.count_and_get (x_count => l_count
126: ,p_encoded => fnd_api.g_false
127: ,x_data => x_error_msg);
128:
129: END IF;

Line 137: gme_common_pvt.count_and_get (x_count => l_count

133: ,p_secondary_quantity=> p_sec_qty
134: ,x_return_status => x_return_status);
135:
136: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
137: gme_common_pvt.count_and_get (x_count => l_count
138: ,p_encoded => fnd_api.g_false
139: ,x_data => x_error_msg);
140:
141: END IF;

Line 189: gme_common_pvt.count_and_get (x_count => l_count

185: x_return_status => x_return_status,
186: x_error_msg => x_error_msg);
187:
188: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
189: gme_common_pvt.count_and_get (x_count => l_count
190: ,p_encoded => fnd_api.g_false
191: ,x_data => x_error_msg);
192:
193: END IF;

Line 332: gme_common_pvt.g_user_ident := p_user_id;

328: IF (g_debug IS NOT NULL) THEN
329: gme_debug.log_initialize ('MobileCreTxn');
330: END IF;
331:
332: gme_common_pvt.g_user_ident := p_user_id;
333: gme_common_pvt.g_login_id := p_login_id;
334: gme_common_pvt.set_timestamp;
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 333: gme_common_pvt.g_login_id := p_login_id;

329: gme_debug.log_initialize ('MobileCreTxn');
330: END IF;
331:
332: gme_common_pvt.g_user_ident := p_user_id;
333: gme_common_pvt.g_login_id := p_login_id;
334: gme_common_pvt.set_timestamp;
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: x_error_msg := ' ';

Line 334: gme_common_pvt.set_timestamp;

330: END IF;
331:
332: gme_common_pvt.g_user_ident := p_user_id;
333: gme_common_pvt.g_login_id := p_login_id;
334: gme_common_pvt.set_timestamp;
335:
336: x_return_status := FND_API.G_RET_STS_SUCCESS;
337: x_error_msg := ' ';
338:

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

386: x_return_status => x_return_status);
387:
388:
389: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
390: -- Bug 5255933 Use GME_COMMON_PVT to get error message
391: --x_error_msg := fnd_message.get;
392: GME_COMMON_PVT.count_and_get (x_count => l_count
393: ,p_encoded => fnd_api.g_false
394: ,x_data => x_error_msg);

Line 392: GME_COMMON_PVT.count_and_get (x_count => l_count

388:
389: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
390: -- Bug 5255933 Use GME_COMMON_PVT to get error message
391: --x_error_msg := fnd_message.get;
392: GME_COMMON_PVT.count_and_get (x_count => l_count
393: ,p_encoded => fnd_api.g_false
394: ,x_data => x_error_msg);
395:
396: x_txn_id := -1;

Line 455: gme_common_pvt.g_user_ident := p_user_id;

451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: x_error_msg := ' ';
454:
455: gme_common_pvt.g_user_ident := p_user_id;
456: gme_common_pvt.g_login_id := p_login_id;
457: gme_common_pvt.set_timestamp;
458:
459: l_mmli_rec_in.lot_number := p_lot_number;

Line 456: gme_common_pvt.g_login_id := p_login_id;

452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: x_error_msg := ' ';
454:
455: gme_common_pvt.g_user_ident := p_user_id;
456: gme_common_pvt.g_login_id := p_login_id;
457: gme_common_pvt.set_timestamp;
458:
459: l_mmli_rec_in.lot_number := p_lot_number;
460: l_mmli_rec_in.transaction_quantity := p_txn_qty;

Line 457: gme_common_pvt.set_timestamp;

453: x_error_msg := ' ';
454:
455: gme_common_pvt.g_user_ident := p_user_id;
456: gme_common_pvt.g_login_id := p_login_id;
457: gme_common_pvt.set_timestamp;
458:
459: l_mmli_rec_in.lot_number := p_lot_number;
460: l_mmli_rec_in.transaction_quantity := p_txn_qty;
461: l_mmli_rec_in.primary_quantity := p_txn_prim_qty;

Line 554: GME_COMMON_PVT.Count_And_Get (x_count => l_msg_count

550: ,x_msg_count =>l_msg_count
551: ,x_msg_data =>l_msg_data))
552:
553: THEN
554: GME_COMMON_PVT.Count_And_Get (x_count => l_msg_count
555: ,p_encoded => fnd_api.g_false
556: ,x_data => x_error_msg);
557:
558: x_return_status := FND_API.G_RET_STS_ERROR;

Line 735: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;

731: FROM mtl_material_transactions
732: WHERE organization_id = p_org_id
733: AND transaction_source_id = p_batch_id
734: AND trx_source_line_id = p_material_detail_id
735: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type;
736: BEGIN
737:
738: IF (g_debug IS NOT NULL) THEN
739: gme_debug.log_initialize ('MobileFetchAgrTxns');

Line 804: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type

800: AND lot_number = NVL(p_lot_number, l.lot_number)
801: AND m.organization_id = p_org_id
802: AND m.transaction_source_id = p_batch_id
803: AND m.trx_source_line_id = p_material_detail_id
804: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
805: GROUP BY m.revision,l.lot_number;
806:
807: EXCEPTION
808: WHEN OTHERS THEN

Line 849: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type

845: FROM mtl_material_transactions
846: WHERE organization_id = p_org_id
847: AND transaction_source_id = p_batch_id
848: AND trx_source_line_id = p_material_detail_id
849: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
850: AND revision = p_revision
851: GROUP BY revision;
852: BEGIN
853:

Line 1031: gme_common_pvt.g_user_ident := p_user_id;

1027: IF (g_debug IS NOT NULL) THEN
1028: gme_debug.log_initialize ('MobileProcessTxn');
1029: END IF;
1030:
1031: gme_common_pvt.g_user_ident := p_user_id;
1032: gme_common_pvt.g_login_id := p_login_id;
1033: gme_common_pvt.set_timestamp;
1034:
1035: -- Bug 8234700 - Let's pass in false to process transactions and commit after

Line 1032: gme_common_pvt.g_login_id := p_login_id;

1028: gme_debug.log_initialize ('MobileProcessTxn');
1029: END IF;
1030:
1031: gme_common_pvt.g_user_ident := p_user_id;
1032: gme_common_pvt.g_login_id := p_login_id;
1033: gme_common_pvt.set_timestamp;
1034:
1035: -- Bug 8234700 - Let's pass in false to process transactions and commit after
1036: -- This more closely mimics how save is done on the form and commits all work together.

Line 1033: gme_common_pvt.set_timestamp;

1029: END IF;
1030:
1031: gme_common_pvt.g_user_ident := p_user_id;
1032: gme_common_pvt.g_login_id := p_login_id;
1033: gme_common_pvt.set_timestamp;
1034:
1035: -- Bug 8234700 - Let's pass in false to process transactions and commit after
1036: -- This more closely mimics how save is done on the form and commits all work together.
1037: GME_TRANSACTIONS_PVT.Process_Transactions

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

1051: --x_error_msg := fnd_message.get;
1052: x_error_msg := l_msg_data;
1053: /* Bug 5438355: Added success message. */
1054: ELSE
1055: gme_common_pvt.log_message('PM_SAVED_CHANGES');
1056: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
1057: x_count => l_msg_count,
1058: x_data => x_error_msg);
1059: -- Bug 8234700 - Let's commit the work done by process transactions.

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

1052: x_error_msg := l_msg_data;
1053: /* Bug 5438355: Added success message. */
1054: ELSE
1055: gme_common_pvt.log_message('PM_SAVED_CHANGES');
1056: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
1057: x_count => l_msg_count,
1058: x_data => x_error_msg);
1059: -- Bug 8234700 - Let's commit the work done by process transactions.
1060: COMMIT;

Line 1065: GME_COMMON_PVT.g_transaction_header_id := NULL;

1061: END IF;
1062:
1063: --- Reseting this global variable. I guess this should be done in
1064: --- GME_TRANSACTIONS_PVT.Process_Transactions
1065: GME_COMMON_PVT.g_transaction_header_id := NULL;
1066:
1067: EXCEPTION
1068: WHEN OTHERS THEN
1069: IF g_debug <= gme_debug.g_log_unexpected THEN

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

1273: || 'When others exception:'
1274: || SQLERRM);
1275: END IF;
1276:
1277: gme_common_pvt.count_and_get (x_count => l_msg_count,
1278: p_encoded => fnd_api.g_false,
1279: x_data => x_error_msg);
1280: x_return_status := fnd_api.g_ret_sts_unexp_error;
1281:

Line 1838: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;

1834: l_msg_data VARCHAR2(2000);
1835: l_msg_index NUMBER;
1836: l_batch_header GME_BATCH_HEADER%ROWTYPE;
1837: l_material_details GME_MATERIAL_DETAILS%ROWTYPE;
1838: l_exception_material_tab GME_COMMON_PVT.exceptions_tab;
1839:
1840: BACKFLUSH_ERROR EXCEPTION;
1841:
1842: BEGIN

Line 1864: ,p_validation_level => gme_common_pvt.g_max_errors

1860: l_batch_header.batch_id := p_batch_id;
1861:
1862: GME_API_PUB.Incremental_Backflush
1863: (p_api_version => 2.0
1864: ,p_validation_level => gme_common_pvt.g_max_errors
1865: ,p_init_msg_list => fnd_api.g_false
1866: ,p_commit => fnd_api.g_true
1867: ,x_message_count => l_msg_count
1868: ,x_message_list => l_msg_list

Line 1956: gme_common_pvt.g_user_ident := p_uid;

1952: gme_debug.log_initialize ('MobileSaveRsrcUsage');
1953: END IF;
1954:
1955: fnd_profile.put('USER_ID',to_char(p_uid));
1956: gme_common_pvt.g_user_ident := p_uid;
1957:
1958: l_input_rec.batchstep_resource_id := p_resource_id;
1959: l_input_rec.actual_rsrc_count := to_number(p_count);
1960: l_input_rec.actual_rsrc_usage := to_number(p_usage);

Line 2256: ,p_validation_level => gme_common_pvt.g_max_errors

2252: l_pending_product_lots_rec.reason_id := p_reason_id;
2253:
2254: GME_API_PUB.create_pending_product_lot
2255: (p_api_version => 2.0
2256: ,p_validation_level => gme_common_pvt.g_max_errors
2257: ,p_init_msg_list => fnd_api.g_true
2258: ,p_commit => fnd_api.g_true
2259: ,x_message_count => l_message_count
2260: ,x_message_list => x_error_msg

Line 2393: ,p_validation_level => gme_common_pvt.g_max_errors

2389: gme_debug.put_line('Reason id = '|| l_pending_product_lots_rec.reason_id);
2390:
2391: GME_API_PUB.update_pending_product_lot
2392: (p_api_version => 2.0
2393: ,p_validation_level => gme_common_pvt.g_max_errors
2394: ,p_init_msg_list => fnd_api.g_true
2395: ,p_commit => fnd_api.g_true
2396: ,x_message_count => l_message_count
2397: ,x_message_list => l_message_list

Line 2459: l_rsrv_tab GME_COMMON_PVT.reservations_tab;

2455: l_msg_data VARCHAR2(2000);
2456: l_index INTEGER;
2457: l_nb_rec NUMBER;
2458: l_dispensed NUMBER := 0;
2459: l_rsrv_tab GME_COMMON_PVT.reservations_tab;
2460:
2461: BEGIN
2462:
2463: IF (g_debug IS NOT NULL) THEN

Line 2835: , p_demand_source_type_id => gme_common_pvt.g_txn_source_type

2831: , p_is_revision_control => l_is_revision_control
2832: , p_is_lot_control => l_is_lot_control
2833: , p_is_serial_control => FALSE
2834: , p_grade_code => NULL
2835: , p_demand_source_type_id => gme_common_pvt.g_txn_source_type
2836: , p_demand_source_name => NULL
2837: , p_lot_expiration_date => SYSDATE
2838: , p_onhand_source => 3
2839: , x_tree_id => x_tree_id

Line 3190: IF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN

3186: END IF;
3187:
3188: -- If the ingredient line has a release type of auto by step then the
3189: -- associated step must be in WIP or Completed
3190: IF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3191: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3192: p_material_detail_id => p_material_detail_id
3193: ,x_batchstep_id => l_batchstep_id
3194: ,x_batchstep_status => l_batchstep_status);

Line 3191: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(

3187:
3188: -- If the ingredient line has a release type of auto by step then the
3189: -- associated step must be in WIP or Completed
3190: IF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3191: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3192: p_material_detail_id => p_material_detail_id
3193: ,x_batchstep_id => l_batchstep_id
3194: ,x_batchstep_status => l_batchstep_status);
3195: IF l_is_item_associated_to_step AND

Line 3363: IF l_release_type = GME_COMMON_PVT.g_mtl_auto_release THEN

3359: -- If product release type is Automatic By Step, then:
3360: -- a) if associated to a step, step status must be Completed
3361: -- b) if not associated to a step, batch status must be Completed
3362:
3363: IF l_release_type = GME_COMMON_PVT.g_mtl_auto_release THEN
3364: IF l_batch_status <> 3 THEN
3365: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3366: RAISE ITEM_NOT_VALID;
3367: END IF;

Line 3368: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN

3364: IF l_batch_status <> 3 THEN
3365: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3366: RAISE ITEM_NOT_VALID;
3367: END IF;
3368: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3369: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3370: p_material_detail_id => p_material_detail_id
3371: ,x_batchstep_id => l_batchstep_id
3372: ,x_batchstep_status => l_batchstep_status);

Line 3369: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(

3365: FND_MESSAGE.SET_NAME('GME', 'GME_YIELD_BATCH_COMPLETE');
3366: RAISE ITEM_NOT_VALID;
3367: END IF;
3368: ELSIF l_release_type = GME_COMMON_PVT.g_mtl_autobystep_release THEN
3369: l_is_item_associated_to_step := GME_COMMON_PVT.Get_Assoc_Step(
3370: p_material_detail_id => p_material_detail_id
3371: ,x_batchstep_id => l_batchstep_id
3372: ,x_batchstep_status => l_batchstep_status);
3373: IF l_is_item_associated_to_step THEN

Line 3461: AND m.transaction_type_id = GME_COMMON_PVT.g_ing_issue

3457: AND l.lot_number = NVL(p_lot_number, l.lot_number)
3458: AND m.organization_id = p_organization_id
3459: AND m.transaction_source_id = p_batch_id
3460: AND m.trx_source_line_id = p_material_detail_id
3461: AND m.transaction_type_id = GME_COMMON_PVT.g_ing_issue
3462: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
3463: AND lc.inventory_location_id(+) = m.locator_id;
3464:
3465: EXCEPTION

Line 3462: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type

3458: AND m.organization_id = p_organization_id
3459: AND m.transaction_source_id = p_batch_id
3460: AND m.trx_source_line_id = p_material_detail_id
3461: AND m.transaction_type_id = GME_COMMON_PVT.g_ing_issue
3462: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
3463: AND lc.inventory_location_id(+) = m.locator_id;
3464:
3465: EXCEPTION
3466: WHEN OTHERS THEN

Line 3541: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type

3537: AND m.organization_id = p_organization_id
3538: AND m.transaction_source_id = p_batch_id
3539: AND m.trx_source_line_id = p_material_detail_id
3540: AND m.transaction_type_id = l_txn_type_id
3541: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
3542: AND lc.inventory_location_id(+) = m.locator_id;
3543:
3544: EXCEPTION
3545: WHEN OTHERS THEN

Line 3593: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

3589: WHERE transaction_interface_id = v_transaction_id;
3590:
3591: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_PHANTOM_TXN';
3592: l_mmti_rec mtl_transactions_interface%ROWTYPE;
3593: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
3594: BEGIN
3595:
3596: IF (g_debug IS NOT NULL) THEN
3597: gme_debug.log_initialize ('MobileCreatePhantomTxn');

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

3608: OPEN cur_get_transaction(p_mmti_trans_id);
3609: FETCH cur_get_transaction INTO l_mmti_rec;
3610: IF cur_get_transaction%NOTFOUND THEN
3611: CLOSE cur_get_transaction;
3612: gme_common_pvt.log_message('GME_NO_TRANS_FOUND');
3613: RAISE fnd_api.g_exc_error;
3614: END IF;
3615: CLOSE cur_get_transaction;
3616:

Line 3623: (gme_common_pvt.g_ing_return

3619: BULK COLLECT INTO l_mmli_tbl;
3620: CLOSE cur_get_lot_transaction;
3621:
3622: IF l_mmti_rec.transaction_type_id NOT IN
3623: (gme_common_pvt.g_ing_return
3624: ,gme_common_pvt.g_prod_completion
3625: ,gme_common_pvt.g_byprod_completion) THEN
3626:
3627:

Line 3624: ,gme_common_pvt.g_prod_completion

3620: CLOSE cur_get_lot_transaction;
3621:
3622: IF l_mmti_rec.transaction_type_id NOT IN
3623: (gme_common_pvt.g_ing_return
3624: ,gme_common_pvt.g_prod_completion
3625: ,gme_common_pvt.g_byprod_completion) THEN
3626:
3627:
3628: FOR i IN 1..l_mmli_tbl.COUNT

Line 3625: ,gme_common_pvt.g_byprod_completion) THEN

3621:
3622: IF l_mmti_rec.transaction_type_id NOT IN
3623: (gme_common_pvt.g_ing_return
3624: ,gme_common_pvt.g_prod_completion
3625: ,gme_common_pvt.g_byprod_completion) THEN
3626:
3627:
3628: FOR i IN 1..l_mmli_tbl.COUNT
3629: LOOP

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

3639: (-1) * l_mmti_rec.secondary_transaction_quantity;
3640:
3641: END IF;
3642:
3643: GME_COMMON_PVT.G_MOVE_TO_TEMP := FND_API.G_FALSE;
3644:
3645: GME_TRANSACTIONS_PVT.Create_Material_Txn
3646:
3647: (p_mmti_rec => l_mmti_rec

Line 3712: x_exception_material gme_common_pvt.exceptions_tab;

3708: l_batch_step gme_batch_steps%ROWTYPE;
3709: l_batch_step_out gme_batch_steps%ROWTYPE;
3710: x_batch_step gme_batch_steps%ROWTYPE;
3711: l_batch_header gme_batch_header%ROWTYPE;
3712: x_exception_material gme_common_pvt.exceptions_tab;
3713: step_alloc_error EXCEPTION;
3714: expected_error EXCEPTION;
3715: validate_step_error EXCEPTION;
3716: validate_step_status_error EXCEPTION;

Line 3726: gme_common_pvt.g_user_name := p_uname;

3722: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3723: l_act_complt_dt := TO_DATE(p_act_complt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3724:
3725: fnd_profile.put('USER_ID',to_char(p_uid));
3726: gme_common_pvt.g_user_name := p_uname;
3727: gme_common_pvt.g_user_ident := p_uid;
3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3730:

Line 3727: gme_common_pvt.g_user_ident := p_uid;

3723: l_act_complt_dt := TO_DATE(p_act_complt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3724:
3725: fnd_profile.put('USER_ID',to_char(p_uid));
3726: gme_common_pvt.g_user_name := p_uname;
3727: gme_common_pvt.g_user_ident := p_uid;
3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3730:
3731: l_batch_header.batch_id := p_batch_id;

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

3724:
3725: fnd_profile.put('USER_ID',to_char(p_uid));
3726: gme_common_pvt.g_user_name := p_uname;
3727: gme_common_pvt.g_user_ident := p_uid;
3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3730:
3731: l_batch_header.batch_id := p_batch_id;
3732: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN

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

3725: fnd_profile.put('USER_ID',to_char(p_uid));
3726: gme_common_pvt.g_user_name := p_uname;
3727: gme_common_pvt.g_user_ident := p_uid;
3728: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3729: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3730:
3731: l_batch_header.batch_id := p_batch_id;
3732: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_header, l_batch_header)) THEN
3733: RAISE expected_error;

Line 3748: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR

3744:
3745: -- Bug 4774944 Rework.
3746: -- Check for 'Step controls batch status' parameter.
3747: IF l_batch_header.batch_status = 1 AND
3748: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR
3749: l_batch_header.parentline_id IS NOT NULL ) THEN
3750: RAISE validate_step_status_error;
3751: END IF;
3752:

Line 3767: p_validation_level => gme_common_pvt.g_max_errors,

3763: RAISE validate_step_error;
3764: END IF;
3765:
3766: gme_api_main.complete_step (
3767: p_validation_level => gme_common_pvt.g_max_errors,
3768: p_init_msg_list => FND_API.G_TRUE,
3769: x_message_count => x_message_count,
3770: x_message_list => x_message_list,
3771: x_return_status => x_return_status,

Line 3796: p_header_id => gme_common_pvt.get_txn_header_id,

3792: END IF;
3793:
3794: -- Bug 13986776 - Added Code to call save batch.
3795: gme_api_pub.save_batch(x_return_status => x_return_status,
3796: p_header_id => gme_common_pvt.get_txn_header_id,
3797: p_table => 2,
3798: p_commit => 'T',
3799: p_clear_qty_cache => 'T');
3800:

Line 3810: gme_common_pvt.count_and_get (x_count => x_message_count

3806: ROLLBACK TO SAVEPOINT complete_step_mobile ;
3807: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
3808: x_message_list := FND_MESSAGE.GET;
3809: WHEN validate_step_error THEN
3810: gme_common_pvt.count_and_get (x_count => x_message_count
3811: ,p_encoded => fnd_api.g_false
3812: ,x_data => x_message_list);
3813: WHEN validate_step_status_error THEN
3814: FND_MESSAGE.SET_NAME('GME','GME_API_INV_BATCH_CMPL_STEP');

Line 3845: gme_common_pvt.g_user_name := p_uname;

3841: BEGIN
3842: x_return_status := FND_API.G_RET_STS_SUCCESS;
3843: x_error_msg := '';
3844: FND_PROFILE.put('USER_ID',to_char(p_uid));
3845: gme_common_pvt.g_user_name := p_uname;
3846: gme_common_pvt.g_user_ident := p_uid;
3847: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3848: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3849:

Line 3846: gme_common_pvt.g_user_ident := p_uid;

3842: x_return_status := FND_API.G_RET_STS_SUCCESS;
3843: x_error_msg := '';
3844: FND_PROFILE.put('USER_ID',to_char(p_uid));
3845: gme_common_pvt.g_user_name := p_uname;
3846: gme_common_pvt.g_user_ident := p_uid;
3847: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3848: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3849:
3850: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;

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

3843: x_error_msg := '';
3844: FND_PROFILE.put('USER_ID',to_char(p_uid));
3845: gme_common_pvt.g_user_name := p_uname;
3846: gme_common_pvt.g_user_ident := p_uid;
3847: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3848: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3849:
3850: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3851: l_in_rsrc_txn_rec.organization_id := p_organization_id;

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

3844: FND_PROFILE.put('USER_ID',to_char(p_uid));
3845: gme_common_pvt.g_user_name := p_uname;
3846: gme_common_pvt.g_user_ident := p_uid;
3847: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3848: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3849:
3850: l_in_rsrc_txn_rec.poc_trans_id := p_trans_id;
3851: l_in_rsrc_txn_rec.organization_id := p_organization_id;
3852: l_in_rsrc_txn_rec.trans_date := p_trans_date;

Line 3924: x_exception_material gme_common_pvt.exceptions_tab;

3920: l_batch_step gme_batch_steps%ROWTYPE;
3921: l_batch_step_out gme_batch_steps%ROWTYPE;
3922: x_batch_step gme_batch_steps%ROWTYPE;
3923: l_batch_hdr_rec gme_batch_header%ROWTYPE;
3924: x_exception_material gme_common_pvt.exceptions_tab;
3925: step_alloc_error EXCEPTION;
3926: expected_error EXCEPTION;
3927: validate_step_error EXCEPTION;
3928: validate_step_status_error EXCEPTION;

Line 3936: gme_common_pvt.g_user_name := p_uname;

3932:
3933: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3934:
3935: fnd_profile.put('USER_ID',to_char(p_uid));
3936: gme_common_pvt.g_user_name := p_uname;
3937: gme_common_pvt.g_user_ident := p_uid;
3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3940:

Line 3937: gme_common_pvt.g_user_ident := p_uid;

3933: l_act_strt_dt := TO_DATE(p_act_strt_dt, p_date_format||HOUR_MIN_SEC_FORMAT_STRING);
3934:
3935: fnd_profile.put('USER_ID',to_char(p_uid));
3936: gme_common_pvt.g_user_name := p_uname;
3937: gme_common_pvt.g_user_ident := p_uid;
3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3940:
3941: l_batch_hdr_rec.batch_id := p_batch_id;

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

3934:
3935: fnd_profile.put('USER_ID',to_char(p_uid));
3936: gme_common_pvt.g_user_name := p_uname;
3937: gme_common_pvt.g_user_ident := p_uid;
3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3940:
3941: l_batch_hdr_rec.batch_id := p_batch_id;
3942: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN

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

3935: fnd_profile.put('USER_ID',to_char(p_uid));
3936: gme_common_pvt.g_user_name := p_uname;
3937: gme_common_pvt.g_user_ident := p_uid;
3938: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
3939: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
3940:
3941: l_batch_hdr_rec.batch_id := p_batch_id;
3942: IF NOT (gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec)) THEN
3943: RAISE expected_error;

Line 3956: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR

3952:
3953: -- Bug 4774944 Rework.
3954: -- Check for 'Step controls batch status' parameter.
3955: IF l_batch_hdr_rec.batch_status = 1 AND
3956: (gme_common_pvt.g_step_controls_batch_sts_ind <> 1 OR
3957: l_batch_hdr_rec.parentline_id IS NOT NULL ) THEN
3958: RAISE validate_step_status_error;
3959: END IF;
3960:

Line 3975: p_validation_level => gme_common_pvt.g_max_errors,

3971: RAISE validate_step_error;
3972: END IF;
3973:
3974: gme_api_main.release_step (
3975: p_validation_level => gme_common_pvt.g_max_errors,
3976: p_init_msg_list => FND_API.G_TRUE,
3977: x_message_count => x_message_count,
3978: x_message_list => x_message_list,
3979: x_return_status => x_return_status,

Line 3993: p_header_id => gme_common_pvt.get_txn_header_id,

3989: -- Added the code to perform the transactions on releasing the step
3990: --
3991: ELSE
3992: gme_api_pub.save_batch(x_return_status => x_return_status,
3993: p_header_id => gme_common_pvt.get_txn_header_id,
3994: p_table => 2,
3995: p_commit => 'T',
3996: p_clear_qty_cache => 'T');
3997: END IF;

Line 4006: GME_COMMON_PVT.count_and_get (x_count => l_count

4002: ROLLBACK TO SAVEPOINT release_step_mobile ;
4003: FND_MESSAGE.SET_NAME('GME', 'GME_API_UNALLOC_MATERIALS');
4004: x_message_list := FND_MESSAGE.GET;
4005: WHEN validate_step_error THEN
4006: GME_COMMON_PVT.count_and_get (x_count => l_count
4007: ,p_encoded => fnd_api.g_false
4008: ,x_data => x_message_list);
4009:
4010: WHEN validate_step_status_error THEN

Line 4042: gme_common_pvt.g_user_name := p_uname;

4038: BEGIN
4039: x_return_status := FND_API.G_RET_STS_SUCCESS;
4040: x_error_msg := '';
4041: FND_PROFILE.put('USER_ID',to_char(p_uid));
4042: gme_common_pvt.g_user_name := p_uname;
4043: gme_common_pvt.g_user_ident := p_uid;
4044: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
4045: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
4046: l_in_rsrc_txn_rec.line_id := p_resource_id;

Line 4043: gme_common_pvt.g_user_ident := p_uid;

4039: x_return_status := FND_API.G_RET_STS_SUCCESS;
4040: x_error_msg := '';
4041: FND_PROFILE.put('USER_ID',to_char(p_uid));
4042: gme_common_pvt.g_user_name := p_uname;
4043: gme_common_pvt.g_user_ident := p_uid;
4044: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
4045: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
4046: l_in_rsrc_txn_rec.line_id := p_resource_id;
4047: l_in_rsrc_txn_rec.organization_id := p_organization_id;

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

4040: x_error_msg := '';
4041: FND_PROFILE.put('USER_ID',to_char(p_uid));
4042: gme_common_pvt.g_user_name := p_uname;
4043: gme_common_pvt.g_user_ident := p_uid;
4044: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
4045: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
4046: l_in_rsrc_txn_rec.line_id := p_resource_id;
4047: l_in_rsrc_txn_rec.organization_id := p_organization_id;
4048: l_in_rsrc_txn_rec.start_date := p_start_date;

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

4041: FND_PROFILE.put('USER_ID',to_char(p_uid));
4042: gme_common_pvt.g_user_name := p_uname;
4043: gme_common_pvt.g_user_ident := p_uid;
4044: gme_common_pvt.g_login_id := TO_NUMBER (fnd_profile.VALUE ('LOGIN_ID'));
4045: gme_common_pvt.g_user_ident := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
4046: l_in_rsrc_txn_rec.line_id := p_resource_id;
4047: l_in_rsrc_txn_rec.organization_id := p_organization_id;
4048: l_in_rsrc_txn_rec.start_date := p_start_date;
4049: l_in_rsrc_txn_rec.end_date := p_start_date;

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

4220: x_message OUT NOCOPY VARCHAR2) IS
4221: l_count NUMBER;
4222: BEGIN
4223: x_return_status := FND_API.G_RET_STS_SUCCESS;
4224: IF NOT (gme_common_pvt.check_close_period(p_org_id, p_trans_date)) THEN
4225: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
4226: x_count => l_count,
4227: x_data => x_message);
4228: END IF;

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

4221: l_count NUMBER;
4222: BEGIN
4223: x_return_status := FND_API.G_RET_STS_SUCCESS;
4224: IF NOT (gme_common_pvt.check_close_period(p_org_id, p_trans_date)) THEN
4225: gme_common_pvt.count_and_get(p_encoded => FND_API.G_FALSE,
4226: x_count => l_count,
4227: x_data => x_message);
4228: END IF;
4229: END check_close_period;

Line 4276: --calling gme_common_pvt routine

4272:
4273: x_return_status := fnd_api.g_ret_sts_success;
4274: x_error_msg := ' ';
4275:
4276: --calling gme_common_pvt routine
4277: gme_common_pvt.fetch_trans_date(p_material_detail_id => p_material_detail_id,
4278: p_invoke_mode => 'T',
4279: x_trans_date => l_trans_date,
4280: x_return_status => x_return_status);

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

4273: x_return_status := fnd_api.g_ret_sts_success;
4274: x_error_msg := ' ';
4275:
4276: --calling gme_common_pvt routine
4277: gme_common_pvt.fetch_trans_date(p_material_detail_id => p_material_detail_id,
4278: p_invoke_mode => 'T',
4279: x_trans_date => l_trans_date,
4280: x_return_status => x_return_status);
4281:

Line 4283: gme_common_pvt.count_and_get (x_count => l_count

4279: x_trans_date => l_trans_date,
4280: x_return_status => x_return_status);
4281:
4282: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4283: gme_common_pvt.count_and_get (x_count => l_count
4284: ,p_encoded => fnd_api.g_false
4285: ,x_data => x_error_msg);
4286:
4287: END IF;

Line 4604: IF (l_txn_type_id NOT IN (GME_COMMON_PVT.g_prod_completion, GME_COMMON_PVT.g_byprod_completion) OR

4600: -- If the transaction is not a prod/byprod completion
4601: -- or if the Label Auto printing is switched off, then the
4602: -- labels are not to be printed
4603: --
4604: IF (l_txn_type_id NOT IN (GME_COMMON_PVT.g_prod_completion, GME_COMMON_PVT.g_byprod_completion) OR
4605: GMO_LABEL_MGMT_GRP.AUTO_PRINT_ENABLED () = FALSE) THEN
4606: x_return_status := 'S';
4607: return;
4608: END IF;