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_TRANSACTIONS_PVT dependencies on GME_COMMON_PVT

Line 44: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl

40: |
41: +==========================================================================+ */
42: PROCEDURE create_material_txn (
43: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
44: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
45: ,p_phantom_trans IN NUMBER DEFAULT 0
46: ,x_return_status OUT NOCOPY VARCHAR2)
47: IS
48: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';

Line 51: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

47: IS
48: l_api_name CONSTANT VARCHAR2 (30) := 'CREATE_MATERIAL_TXN';
49: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
50: l_mmti_rec mtl_transactions_interface%ROWTYPE;
51: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
52: m_mmti_rec mtl_transactions_interface%ROWTYPE;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;
55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

Line 53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

49: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
50: l_mmti_rec mtl_transactions_interface%ROWTYPE;
51: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
52: m_mmti_rec mtl_transactions_interface%ROWTYPE;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;
55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
56: l_mat_dtl_rec gme_material_details%ROWTYPE;
57: m_mat_dtl_rec gme_material_details%ROWTYPE;

Line 55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

51: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
52: m_mmti_rec mtl_transactions_interface%ROWTYPE;
53: m_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
54: x_mmti_rec mtl_transactions_interface%ROWTYPE;
55: x_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
56: l_mat_dtl_rec gme_material_details%ROWTYPE;
57: m_mat_dtl_rec gme_material_details%ROWTYPE;
58: l_ret NUMBER;
59: l_api_version NUMBER;

Line 175: IF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue THEN

171: END IF;
172:
173: m_mmti_rec.transaction_source_id := m_mat_dtl_rec.batch_id;
174:
175: IF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue THEN
176: --(35)
177: m_mmti_rec.transaction_type_id :=
178: gme_common_pvt.g_prod_completion;
179: -- (44)

Line 178: gme_common_pvt.g_prod_completion;

174:
175: IF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue THEN
176: --(35)
177: m_mmti_rec.transaction_type_id :=
178: gme_common_pvt.g_prod_completion;
179: -- (44)
180: m_mmti_rec.transaction_action_id :=
181: gme_common_pvt.g_prod_comp_txn_action;
182: --(31)

Line 181: gme_common_pvt.g_prod_comp_txn_action;

177: m_mmti_rec.transaction_type_id :=
178: gme_common_pvt.g_prod_completion;
179: -- (44)
180: m_mmti_rec.transaction_action_id :=
181: gme_common_pvt.g_prod_comp_txn_action;
182: --(31)
183: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN
184: --(43)
185: m_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;

Line 183: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN

179: -- (44)
180: m_mmti_rec.transaction_action_id :=
181: gme_common_pvt.g_prod_comp_txn_action;
182: --(31)
183: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN
184: --(43)
185: m_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;
186: -- (17)
187: m_mmti_rec.transaction_action_id :=

Line 185: m_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;

181: gme_common_pvt.g_prod_comp_txn_action;
182: --(31)
183: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN
184: --(43)
185: m_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;
186: -- (17)
187: m_mmti_rec.transaction_action_id :=
188: gme_common_pvt.g_prod_ret_txn_action;
189: --(27)

Line 188: gme_common_pvt.g_prod_ret_txn_action;

184: --(43)
185: m_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;
186: -- (17)
187: m_mmti_rec.transaction_action_id :=
188: gme_common_pvt.g_prod_ret_txn_action;
189: --(27)
190: ELSIF l_mmti_rec.transaction_type_id =
191: gme_common_pvt.g_prod_completion THEN
192: -- (44)

Line 191: gme_common_pvt.g_prod_completion THEN

187: m_mmti_rec.transaction_action_id :=
188: gme_common_pvt.g_prod_ret_txn_action;
189: --(27)
190: ELSIF l_mmti_rec.transaction_type_id =
191: gme_common_pvt.g_prod_completion THEN
192: -- (44)
193: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;
194: -- (35)
195: m_mmti_rec.transaction_action_id :=

Line 193: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;

189: --(27)
190: ELSIF l_mmti_rec.transaction_type_id =
191: gme_common_pvt.g_prod_completion THEN
192: -- (44)
193: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;
194: -- (35)
195: m_mmti_rec.transaction_action_id :=
196: gme_common_pvt.g_ing_issue_txn_action;
197: --(1)

Line 196: gme_common_pvt.g_ing_issue_txn_action;

192: -- (44)
193: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;
194: -- (35)
195: m_mmti_rec.transaction_action_id :=
196: gme_common_pvt.g_ing_issue_txn_action;
197: --(1)
198: ELSIF l_mmti_rec.transaction_type_id =
199: gme_common_pvt.g_prod_return THEN
200: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;

Line 199: gme_common_pvt.g_prod_return THEN

195: m_mmti_rec.transaction_action_id :=
196: gme_common_pvt.g_ing_issue_txn_action;
197: --(1)
198: ELSIF l_mmti_rec.transaction_type_id =
199: gme_common_pvt.g_prod_return THEN
200: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;
201: -- (17)
202: m_mmti_rec.transaction_action_id :=
203: gme_common_pvt.g_ing_ret_txn_action;

Line 200: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;

196: gme_common_pvt.g_ing_issue_txn_action;
197: --(1)
198: ELSIF l_mmti_rec.transaction_type_id =
199: gme_common_pvt.g_prod_return THEN
200: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;
201: -- (17)
202: m_mmti_rec.transaction_action_id :=
203: gme_common_pvt.g_ing_ret_txn_action;
204: --(27)

Line 203: gme_common_pvt.g_ing_ret_txn_action;

199: gme_common_pvt.g_prod_return THEN
200: m_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;
201: -- (17)
202: m_mmti_rec.transaction_action_id :=
203: gme_common_pvt.g_ing_ret_txn_action;
204: --(27)
205: ELSIF l_mmti_rec.transaction_type_id =
206: gme_common_pvt.g_byprod_completion THEN
207: -- add for byprod type_id

Line 206: gme_common_pvt.g_byprod_completion THEN

202: m_mmti_rec.transaction_action_id :=
203: gme_common_pvt.g_ing_ret_txn_action;
204: --(27)
205: ELSIF l_mmti_rec.transaction_type_id =
206: gme_common_pvt.g_byprod_completion THEN
207: -- add for byprod type_id
208: m_mmti_rec.transaction_action_id :=
209: gme_common_pvt.g_byprod_ret_txn_action;
210: --(32)

Line 209: gme_common_pvt.g_byprod_ret_txn_action;

205: ELSIF l_mmti_rec.transaction_type_id =
206: gme_common_pvt.g_byprod_completion THEN
207: -- add for byprod type_id
208: m_mmti_rec.transaction_action_id :=
209: gme_common_pvt.g_byprod_ret_txn_action;
210: --(32)
211: ELSE
212: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN
213: -- add for byprod type_id

Line 212: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN

208: m_mmti_rec.transaction_action_id :=
209: gme_common_pvt.g_byprod_ret_txn_action;
210: --(32)
211: ELSE
212: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN
213: -- add for byprod type_id
214: m_mmti_rec.transaction_action_id :=
215: gme_common_pvt.g_byprod_comp_txn_action;
216: --(31)

Line 215: gme_common_pvt.g_byprod_comp_txn_action;

211: ELSE
212: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN
213: -- add for byprod type_id
214: m_mmti_rec.transaction_action_id :=
215: gme_common_pvt.g_byprod_comp_txn_action;
216: --(31)
217: END IF;
218:
219: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 289: IF gme_common_pvt.g_move_to_temp = fnd_api.g_true THEN

285: END IF; -- for phantom
286: END IF; --p_phantom_trans <> 1 THEN
287:
288: -- code for moving the data to temp
289: IF gme_common_pvt.g_move_to_temp = fnd_api.g_true THEN
290: IF (g_debug <= gme_debug.g_log_statement) THEN
291: gme_debug.put_line ( g_pkg_name
292: || '.'
293: || l_api_name

Line 296: || gme_common_pvt.g_transaction_header_id);

292: || '.'
293: || l_api_name
294: || ':'
295: || 'calling validate transactions:'
296: || gme_common_pvt.g_transaction_header_id);
297:
298:
299: select count(*)
300: into l_cnt_int

Line 302: where transaction_header_id= gme_common_pvt.g_transaction_header_id;

298:
299: select count(*)
300: into l_cnt_int
301: from mtl_transactions_interface
302: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
303: gme_debug.put_line ( g_pkg_name
304: || '.'
305: || l_api_name
306: || ':'

Line 320: ,p_header_id => gme_common_pvt.g_transaction_header_id

316: l_ret := inv_txn_manager_grp.validate_transactions
317: (p_api_version => l_api_version
318: ,p_init_msg_list => fnd_api.g_true
319: ,p_validation_level => fnd_api.g_valid_level_full
320: ,p_header_id => gme_common_pvt.g_transaction_header_id
321: ,x_return_status => l_return_status
322: ,x_msg_count => l_msg_count
323: ,x_msg_data => l_msg_data
324: ,x_trans_count => l_txn_count

Line 331: where transaction_header_id= gme_common_pvt.g_transaction_header_id;

327: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
328: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
329: select count(*) into l_cnt_temp
330: from mtl_material_transactions_temp
331: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
332: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
333: END IF;
334: IF l_ret < 0 THEN
335: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 343: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'

339: IF (l_msg_data IS NOT NULL) THEN
340: IF (g_debug <= gme_debug.g_log_statement) THEN
341: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_msg_data is: '||l_msg_data);
342: END IF;
343: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
344: ,p_product_code => 'FND'
345: ,p_token1_name => 'MESSAGE'
346: ,p_token1_value => l_msg_data);
347: ELSE

Line 350: WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id

346: ,p_token1_value => l_msg_data);
347: ELSE
348: /* Bug 5256543 Get messages from interface table and put on stack */
349: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface
350: WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id
351: AND error_explanation IS NOT NULL) LOOP
352: IF (g_debug <= gme_debug.g_log_statement) THEN
353: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);
354: END IF;

Line 355: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'

351: AND error_explanation IS NOT NULL) LOOP
352: IF (g_debug <= gme_debug.g_log_statement) THEN
353: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);
354: END IF;
355: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
356: ,p_product_code => 'FND'
357: ,p_token1_name => 'MESSAGE'
358: ,p_token1_value => get_msgs.error_explanation);
359: END LOOP;

Line 418: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl

414: +==========================================================================+ */
415: PROCEDURE update_material_txn (
416: p_transaction_id IN NUMBER
417: ,p_mmti_rec IN mtl_transactions_interface%ROWTYPE
418: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
419: ,x_return_status OUT NOCOPY VARCHAR2)
420: IS
421: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
422: l_transaction_id NUMBER;

Line 424: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

420: IS
421: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN';
422: l_transaction_id NUMBER;
423: l_mmt_rec mtl_material_transactions%ROWTYPE;
424: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
425: l_mmti_rec mtl_transactions_interface%ROWTYPE;
426: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
427: l_mat_dtl_rec gme_material_details%ROWTYPE;
428: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 426: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

422: l_transaction_id NUMBER;
423: l_mmt_rec mtl_material_transactions%ROWTYPE;
424: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
425: l_mmti_rec mtl_transactions_interface%ROWTYPE;
426: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
427: l_mat_dtl_rec gme_material_details%ROWTYPE;
428: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
429: create_material_txn_err EXCEPTION;
430: delete_material_txn_err EXCEPTION;

Line 537: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl

533: |
534: +==========================================================================+ */
535: PROCEDURE update_material_txn (
536: p_mmt_rec IN mtl_material_transactions%ROWTYPE
537: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
538: ,x_return_status OUT NOCOPY VARCHAR2)
539: IS
540: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';
541: l_transaction_id NUMBER;

Line 543: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

539: IS
540: l_api_name CONSTANT VARCHAR2 (30) := 'UPDATE_MATERIAL_TXN-2';
541: l_transaction_id NUMBER;
542: l_mmt_rec mtl_material_transactions%ROWTYPE;
543: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
544: l_mmti_rec mtl_transactions_interface%ROWTYPE;
545: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
546: l_mat_dtl_rec gme_material_details%ROWTYPE;
547: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 545: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

541: l_transaction_id NUMBER;
542: l_mmt_rec mtl_material_transactions%ROWTYPE;
543: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
544: l_mmti_rec mtl_transactions_interface%ROWTYPE;
545: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
546: l_mat_dtl_rec gme_material_details%ROWTYPE;
547: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
548: create_material_txn_err EXCEPTION;
549: delete_material_txn_err EXCEPTION;

Line 696: AND pair_type = gme_common_pvt.g_pairs_phantom_type;

692: IS
693: SELECT transaction_id2
694: FROM gme_transaction_pairs
695: WHERE transaction_id1 = v_transaction_id
696: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
697:
698: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_TXN';
699: l_transaction_id NUMBER;
700: m_transaction_id NUMBER;

Line 702: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

698: l_api_name CONSTANT VARCHAR2 (30) := 'DELETE_MATERIAL_TXN';
699: l_transaction_id NUMBER;
700: m_transaction_id NUMBER;
701: l_mmt_rec mtl_material_transactions%ROWTYPE;
702: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
703: l_mmti_rec mtl_transactions_interface%ROWTYPE;
704: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
705: l_mat_dtl_rec gme_material_details%ROWTYPE;
706: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;

Line 704: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

700: m_transaction_id NUMBER;
701: l_mmt_rec mtl_material_transactions%ROWTYPE;
702: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
703: l_mmti_rec mtl_transactions_interface%ROWTYPE;
704: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
705: l_mat_dtl_rec gme_material_details%ROWTYPE;
706: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
707: create_material_txn_err EXCEPTION;
708: delete_material_txn_err EXCEPTION;

Line 802: IF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue THEN

798: ,x_material_detail => l_mat_dtl_rec) THEN
799: RAISE fnd_api.g_exc_error;
800: END IF;
801:
802: IF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue THEN
803: --(35)
804: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;
805: --(43)
806: l_mmti_rec.transaction_action_id :=

Line 804: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;

800: END IF;
801:
802: IF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue THEN
803: --(35)
804: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;
805: --(43)
806: l_mmti_rec.transaction_action_id :=
807: gme_common_pvt.g_ing_ret_txn_action;
808: --(27)

Line 807: gme_common_pvt.g_ing_ret_txn_action;

803: --(35)
804: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_return;
805: --(43)
806: l_mmti_rec.transaction_action_id :=
807: gme_common_pvt.g_ing_ret_txn_action;
808: --(27)
809: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN
810: --(43)
811: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;

Line 809: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN

805: --(43)
806: l_mmti_rec.transaction_action_id :=
807: gme_common_pvt.g_ing_ret_txn_action;
808: --(27)
809: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN
810: --(43)
811: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;
812: -- (35)
813: l_mmti_rec.transaction_action_id :=

Line 811: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;

807: gme_common_pvt.g_ing_ret_txn_action;
808: --(27)
809: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_return THEN
810: --(43)
811: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;
812: -- (35)
813: l_mmti_rec.transaction_action_id :=
814: gme_common_pvt.g_ing_issue_txn_action;
815: --(1)

Line 814: gme_common_pvt.g_ing_issue_txn_action;

810: --(43)
811: l_mmti_rec.transaction_type_id := gme_common_pvt.g_ing_issue;
812: -- (35)
813: l_mmti_rec.transaction_action_id :=
814: gme_common_pvt.g_ing_issue_txn_action;
815: --(1)
816: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_completion THEN
817: -- (44)
818: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;

Line 816: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_completion THEN

812: -- (35)
813: l_mmti_rec.transaction_action_id :=
814: gme_common_pvt.g_ing_issue_txn_action;
815: --(1)
816: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_completion THEN
817: -- (44)
818: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;
819: --(17)
820: l_mmti_rec.transaction_action_id :=

Line 818: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;

814: gme_common_pvt.g_ing_issue_txn_action;
815: --(1)
816: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_completion THEN
817: -- (44)
818: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;
819: --(17)
820: l_mmti_rec.transaction_action_id :=
821: gme_common_pvt.g_prod_ret_txn_action;
822: --(27)

Line 821: gme_common_pvt.g_prod_ret_txn_action;

817: -- (44)
818: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_return;
819: --(17)
820: l_mmti_rec.transaction_action_id :=
821: gme_common_pvt.g_prod_ret_txn_action;
822: --(27)
823: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_return THEN
824: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;
825: l_mmti_rec.transaction_action_id :=

Line 823: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_return THEN

819: --(17)
820: l_mmti_rec.transaction_action_id :=
821: gme_common_pvt.g_prod_ret_txn_action;
822: --(27)
823: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_return THEN
824: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;
825: l_mmti_rec.transaction_action_id :=
826: gme_common_pvt.g_prod_comp_txn_action;
827: --(31)

Line 824: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;

820: l_mmti_rec.transaction_action_id :=
821: gme_common_pvt.g_prod_ret_txn_action;
822: --(27)
823: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_return THEN
824: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;
825: l_mmti_rec.transaction_action_id :=
826: gme_common_pvt.g_prod_comp_txn_action;
827: --(31)
828: ELSIF l_mmti_rec.transaction_type_id =

Line 826: gme_common_pvt.g_prod_comp_txn_action;

822: --(27)
823: ELSIF l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_return THEN
824: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;
825: l_mmti_rec.transaction_action_id :=
826: gme_common_pvt.g_prod_comp_txn_action;
827: --(31)
828: ELSIF l_mmti_rec.transaction_type_id =
829: gme_common_pvt.g_byprod_completion THEN
830: l_mmti_rec.transaction_type_id := gme_common_pvt.g_byprod_return;

Line 829: gme_common_pvt.g_byprod_completion THEN

825: l_mmti_rec.transaction_action_id :=
826: gme_common_pvt.g_prod_comp_txn_action;
827: --(31)
828: ELSIF l_mmti_rec.transaction_type_id =
829: gme_common_pvt.g_byprod_completion THEN
830: l_mmti_rec.transaction_type_id := gme_common_pvt.g_byprod_return;
831: l_mmti_rec.transaction_action_id :=
832: gme_common_pvt.g_byprod_ret_txn_action;
833: --(32)

Line 830: l_mmti_rec.transaction_type_id := gme_common_pvt.g_byprod_return;

826: gme_common_pvt.g_prod_comp_txn_action;
827: --(31)
828: ELSIF l_mmti_rec.transaction_type_id =
829: gme_common_pvt.g_byprod_completion THEN
830: l_mmti_rec.transaction_type_id := gme_common_pvt.g_byprod_return;
831: l_mmti_rec.transaction_action_id :=
832: gme_common_pvt.g_byprod_ret_txn_action;
833: --(32)
834: ELSE

Line 832: gme_common_pvt.g_byprod_ret_txn_action;

828: ELSIF l_mmti_rec.transaction_type_id =
829: gme_common_pvt.g_byprod_completion THEN
830: l_mmti_rec.transaction_type_id := gme_common_pvt.g_byprod_return;
831: l_mmti_rec.transaction_action_id :=
832: gme_common_pvt.g_byprod_ret_txn_action;
833: --(32)
834: ELSE
835: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN
836: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;

Line 835: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN

831: l_mmti_rec.transaction_action_id :=
832: gme_common_pvt.g_byprod_ret_txn_action;
833: --(32)
834: ELSE
835: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN
836: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;
837: l_mmti_rec.transaction_action_id :=
838: gme_common_pvt.g_byprod_comp_txn_action;
839: --(31)

Line 836: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;

832: gme_common_pvt.g_byprod_ret_txn_action;
833: --(32)
834: ELSE
835: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN
836: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;
837: l_mmti_rec.transaction_action_id :=
838: gme_common_pvt.g_byprod_comp_txn_action;
839: --(31)
840: END IF;

Line 838: gme_common_pvt.g_byprod_comp_txn_action;

834: ELSE
835: --l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return THEN
836: l_mmti_rec.transaction_type_id := gme_common_pvt.g_prod_completion;
837: l_mmti_rec.transaction_action_id :=
838: gme_common_pvt.g_byprod_comp_txn_action;
839: --(31)
840: END IF;
841:
842: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 915: || gme_common_pvt.g_pairs_reversal_type);

911: || '.'
912: || l_api_name
913: || ':'
914: || 'inserting into pairs table pair_type:'
915: || gme_common_pvt.g_pairs_reversal_type);
916: END IF;
917:
918: INSERT INTO gme_transaction_pairs
919: (batch_id, material_detail_id

Line 924: ,gme_common_pvt.g_pairs_reversal_type);

920: ,transaction_id1, transaction_id2
921: ,pair_type)
922: VALUES (l_mat_dtl_rec.batch_id, l_mat_dtl_rec.material_detail_id
923: ,l_mmt_rec.transaction_id, NULL
924: ,gme_common_pvt.g_pairs_reversal_type);
925:
926: -- changes for phantom
927: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL AND p_txns_pair IS NULL THEN
928: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 1039: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl

1035: |
1036: +==========================================================================+ */
1037: PROCEDURE build_txn_inter (
1038: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1039: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
1040: ,p_assign_phantom IN NUMBER DEFAULT 0
1041: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1042: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1043: ,x_return_status OUT NOCOPY VARCHAR2)

Line 1042: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

1038: p_mmti_rec IN mtl_transactions_interface%ROWTYPE
1039: ,p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl
1040: ,p_assign_phantom IN NUMBER DEFAULT 0
1041: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1042: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1043: ,x_return_status OUT NOCOPY VARCHAR2)
1044: IS
1045: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1046: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

Line 1046: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

1042: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1043: ,x_return_status OUT NOCOPY VARCHAR2)
1044: IS
1045: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1046: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1047: l_api_name CONSTANT VARCHAR2 (30) := 'BUILD_TXN_INTER';
1048: x_header_id NUMBER;
1049: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
1050: l_insert_hdr BOOLEAN;

Line 1128: IF (x_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue) THEN

1124: || 'transaction_quantity '
1125: || l_mmli_tbl (i).transaction_quantity);
1126: END IF;
1127: /* Bug 4929610 added lot expiry check */
1128: IF (x_mmti_rec.transaction_type_id = gme_common_pvt.g_ing_issue) THEN
1129: IF (gme_transactions_pvt.is_lot_expired (p_organization_id => x_mmti_rec.organization_id,
1130: p_inventory_item_id => x_mmti_rec.inventory_item_id,
1131: p_lot_number => l_mmli_tbl(i).lot_number,
1132: p_date => x_mmti_rec.transaction_date)) THEN

Line 1265: IF gme_common_pvt.g_transaction_header_id IS NULL THEN

1261: END IF;
1262:
1263: l_mmti_rec := p_mmti_rec;
1264:
1265: IF gme_common_pvt.g_transaction_header_id IS NULL THEN
1266: SELECT mtl_material_transactions_s.NEXTVAL
1267: INTO gme_common_pvt.g_transaction_header_id
1268: FROM DUAL;
1269:

Line 1267: INTO gme_common_pvt.g_transaction_header_id

1263: l_mmti_rec := p_mmti_rec;
1264:
1265: IF gme_common_pvt.g_transaction_header_id IS NULL THEN
1266: SELECT mtl_material_transactions_s.NEXTVAL
1267: INTO gme_common_pvt.g_transaction_header_id
1268: FROM DUAL;
1269:
1270: IF (g_debug <= gme_debug.g_log_statement) THEN
1271: gme_debug.put_line ( g_pkg_name

Line 1275: || 'GME_COMMON_PVT.g_transaction_header_id '

1271: gme_debug.put_line ( g_pkg_name
1272: || '.'
1273: || l_api_name
1274: || ':'
1275: || 'GME_COMMON_PVT.g_transaction_header_id '
1276: || gme_common_pvt.g_transaction_header_id);
1277: END IF;
1278: END IF;
1279:

Line 1276: || gme_common_pvt.g_transaction_header_id);

1272: || '.'
1273: || l_api_name
1274: || ':'
1275: || 'GME_COMMON_PVT.g_transaction_header_id '
1276: || gme_common_pvt.g_transaction_header_id);
1277: END IF;
1278: END IF;
1279:
1280: l_mmti_rec.transaction_header_id :=

Line 1281: gme_common_pvt.g_transaction_header_id;

1277: END IF;
1278: END IF;
1279:
1280: l_mmti_rec.transaction_header_id :=
1281: gme_common_pvt.g_transaction_header_id;
1282:
1283: IF (g_debug <= gme_debug.g_log_statement) THEN
1284: gme_debug.put_line ( g_pkg_name
1285: || '.'

Line 1297: (gme_common_pvt.g_ing_return

1293: INTO l_mmti_rec.transaction_interface_id
1294: FROM DUAL;
1295:
1296: IF l_mmti_rec.transaction_type_id IN
1297: (gme_common_pvt.g_ing_return
1298: ,gme_common_pvt.g_prod_completion
1299: ,gme_common_pvt.g_byprod_completion) THEN
1300: l_mmti_rec.transaction_batch_seq := 1;
1301: l_mmti_rec.transaction_batch_id := l_mmti_rec.transaction_header_id ;

Line 1298: ,gme_common_pvt.g_prod_completion

1294: FROM DUAL;
1295:
1296: IF l_mmti_rec.transaction_type_id IN
1297: (gme_common_pvt.g_ing_return
1298: ,gme_common_pvt.g_prod_completion
1299: ,gme_common_pvt.g_byprod_completion) THEN
1300: l_mmti_rec.transaction_batch_seq := 1;
1301: l_mmti_rec.transaction_batch_id := l_mmti_rec.transaction_header_id ;
1302: l_mmti_rec.transaction_quantity :=

Line 1299: ,gme_common_pvt.g_byprod_completion) THEN

1295:
1296: IF l_mmti_rec.transaction_type_id IN
1297: (gme_common_pvt.g_ing_return
1298: ,gme_common_pvt.g_prod_completion
1299: ,gme_common_pvt.g_byprod_completion) THEN
1300: l_mmti_rec.transaction_batch_seq := 1;
1301: l_mmti_rec.transaction_batch_id := l_mmti_rec.transaction_header_id ;
1302: l_mmti_rec.transaction_quantity :=
1303: ABS(l_mmti_rec.transaction_quantity);

Line 1488: || gme_common_pvt.g_user_ident);

1484: || '.'
1485: || l_api_name
1486: || ':'
1487: || 'last_updated_by: '
1488: || gme_common_pvt.g_user_ident);
1489: gme_debug.put_line ( g_pkg_name
1490: || '.'
1491: || l_api_name
1492: || ':'

Line 1573: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB_LOC'

1569: INTO l_type
1570: FROM mtl_transaction_types
1571: WHERE transaction_type_id = l_mmti_rec.transaction_type_id;
1572: IF l_locator IS NOT NULL THEN
1573: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB_LOC'
1574: ,'TRANSTYPE',l_type,'ITEM',l_item
1575: ,'SUBINV',l_mmti_rec.subinventory_code
1576: ,'LOCN',l_locator);
1577: ELSE

Line 1578: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB'

1574: ,'TRANSTYPE',l_type,'ITEM',l_item
1575: ,'SUBINV',l_mmti_rec.subinventory_code
1576: ,'LOCN',l_locator);
1577: ELSE
1578: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB'
1579: ,'TRANSTYPE',l_type,'ITEM',l_item
1580: ,'SUBINV',l_mmti_rec.subinventory_code);
1581: END IF;
1582: gme_debug.put_line ( g_pkg_name

Line 1668: (gme_common_pvt.g_ing_return

1664: l_subinventory_code := p_subinventory_code;
1665: l_locator_id := p_locator_id;
1666:
1667: IF l_transaction_type_id IN
1668: (gme_common_pvt.g_ing_return
1669: ,gme_common_pvt.g_prod_completion
1670: ,gme_common_pvt.g_byprod_completion) THEN
1671: l_mmli_rec.transaction_quantity :=
1672: ABS(l_mmli_rec.transaction_quantity);

Line 1669: ,gme_common_pvt.g_prod_completion

1665: l_locator_id := p_locator_id;
1666:
1667: IF l_transaction_type_id IN
1668: (gme_common_pvt.g_ing_return
1669: ,gme_common_pvt.g_prod_completion
1670: ,gme_common_pvt.g_byprod_completion) THEN
1671: l_mmli_rec.transaction_quantity :=
1672: ABS(l_mmli_rec.transaction_quantity);
1673: l_mmli_rec.secondary_transaction_quantity :=

Line 1670: ,gme_common_pvt.g_byprod_completion) THEN

1666:
1667: IF l_transaction_type_id IN
1668: (gme_common_pvt.g_ing_return
1669: ,gme_common_pvt.g_prod_completion
1670: ,gme_common_pvt.g_byprod_completion) THEN
1671: l_mmli_rec.transaction_quantity :=
1672: ABS(l_mmli_rec.transaction_quantity);
1673: l_mmli_rec.secondary_transaction_quantity :=
1674: ABS(l_mmli_rec.secondary_transaction_quantity);

Line 1690: ,p_organization_id => gme_common_pvt.g_organization_id

1686: ,p_trx_status_enabled => NULL
1687: ,p_trx_type_id => l_transaction_type_id
1688: ,p_lot_status_enabled => NULL
1689: ,p_serial_status_enabled => NULL
1690: ,p_organization_id => gme_common_pvt.g_organization_id
1691: ,p_inventory_item_id => l_inventory_item_id
1692: ,p_sub_code => p_subinventory_code
1693: ,p_locator_id => p_locator_id
1694: ,p_lot_number => l_mmli_rec.lot_number

Line 1730: ,gme_common_pvt.g_timestamp --last_update_date

1726: ,lot_number, transaction_quantity
1727: ,primary_quantity
1728: ,secondary_transaction_quantity)
1729: VALUES ( p_trans_inter_id --transaction_interface_id
1730: ,gme_common_pvt.g_timestamp --last_update_date
1731: ,gme_common_pvt.g_user_ident --last_updated_by
1732: ,gme_common_pvt.g_user_ident --last_update_login
1733: ,gme_common_pvt.g_timestamp --creation_date
1734: ,gme_common_pvt.g_user_ident --created_by

Line 1731: ,gme_common_pvt.g_user_ident --last_updated_by

1727: ,primary_quantity
1728: ,secondary_transaction_quantity)
1729: VALUES ( p_trans_inter_id --transaction_interface_id
1730: ,gme_common_pvt.g_timestamp --last_update_date
1731: ,gme_common_pvt.g_user_ident --last_updated_by
1732: ,gme_common_pvt.g_user_ident --last_update_login
1733: ,gme_common_pvt.g_timestamp --creation_date
1734: ,gme_common_pvt.g_user_ident --created_by
1735: ,l_mmli_rec.lot_number --lot_number

Line 1732: ,gme_common_pvt.g_user_ident --last_update_login

1728: ,secondary_transaction_quantity)
1729: VALUES ( p_trans_inter_id --transaction_interface_id
1730: ,gme_common_pvt.g_timestamp --last_update_date
1731: ,gme_common_pvt.g_user_ident --last_updated_by
1732: ,gme_common_pvt.g_user_ident --last_update_login
1733: ,gme_common_pvt.g_timestamp --creation_date
1734: ,gme_common_pvt.g_user_ident --created_by
1735: ,l_mmli_rec.lot_number --lot_number
1736: ,l_mmli_rec.transaction_quantity --lot_quantity

Line 1733: ,gme_common_pvt.g_timestamp --creation_date

1729: VALUES ( p_trans_inter_id --transaction_interface_id
1730: ,gme_common_pvt.g_timestamp --last_update_date
1731: ,gme_common_pvt.g_user_ident --last_updated_by
1732: ,gme_common_pvt.g_user_ident --last_update_login
1733: ,gme_common_pvt.g_timestamp --creation_date
1734: ,gme_common_pvt.g_user_ident --created_by
1735: ,l_mmli_rec.lot_number --lot_number
1736: ,l_mmli_rec.transaction_quantity --lot_quantity
1737: ,l_mmli_rec.primary_quantity

Line 1734: ,gme_common_pvt.g_user_ident --created_by

1730: ,gme_common_pvt.g_timestamp --last_update_date
1731: ,gme_common_pvt.g_user_ident --last_updated_by
1732: ,gme_common_pvt.g_user_ident --last_update_login
1733: ,gme_common_pvt.g_timestamp --creation_date
1734: ,gme_common_pvt.g_user_ident --created_by
1735: ,l_mmli_rec.lot_number --lot_number
1736: ,l_mmli_rec.transaction_quantity --lot_quantity
1737: ,l_mmli_rec.primary_quantity
1738: ,l_mmli_rec.secondary_transaction_quantity);

Line 1755: WHERE organization_id = gme_common_pvt.g_organization_id

1751: WHEN material_status_err THEN
1752: SELECT substr(concatenated_segments,1,100)
1753: INTO l_item
1754: FROM mtl_system_items_kfv
1755: WHERE organization_id = gme_common_pvt.g_organization_id
1756: AND inventory_item_id = l_inventory_item_id;
1757: SELECT transaction_type_name
1758: INTO l_type
1759: FROM mtl_transaction_types

Line 1761: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_LOT'

1757: SELECT transaction_type_name
1758: INTO l_type
1759: FROM mtl_transaction_types
1760: WHERE transaction_type_id = p_transaction_type_id;
1761: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_LOT'
1762: ,'TRANSTYPE',l_type,'ITEM',l_item
1763: ,'LOT',l_mmli_rec.lot_number);
1764: gme_debug.put_line ( g_pkg_name
1765: || '.'

Line 1823: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

1819: +==========================================================================+ */
1820: PROCEDURE get_transactions (
1821: p_transaction_id IN NUMBER
1822: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
1823: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
1824: ,x_return_status OUT NOCOPY VARCHAR2)
1825: IS
1826:
1827: -- Namit S. Bug4917213. Changed query to add hint to improve sharable memory.

Line 1864: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);

1860: || 'Entering with transaction '||p_transaction_id);
1861: END IF;
1862:
1863: IF p_transaction_id IS NULL THEN
1864: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
1865:
1866: IF (g_debug <= gme_debug.g_log_statement) THEN
1867: gme_debug.put_line ( g_pkg_name
1868: || '.'

Line 1877: OPEN cur_get_transaction (l_transaction_id, gme_common_pvt.g_pairs_reversal_type);

1873: END IF;
1874:
1875: l_transaction_id := p_transaction_id;
1876: -- Namit S. Bug4917213.
1877: OPEN cur_get_transaction (l_transaction_id, gme_common_pvt.g_pairs_reversal_type);
1878: FETCH cur_get_transaction
1879: INTO x_mmt_rec;
1880: IF cur_get_transaction%FOUND THEN
1881: IF (g_debug <= gme_debug.g_log_statement) THEN

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

1898: RAISE fnd_api.g_exc_error;
1899: END IF;
1900: ELSE /* IF cur_get_transaction%FOUND THEN */
1901: CLOSE cur_get_transaction;
1902: gme_common_pvt.log_message ('GME_NO_TRANS_FOUND');
1903: RAISE fnd_api.g_exc_error;
1904: END IF;
1905: CLOSE cur_get_transaction;
1906:

Line 1964: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl

1960: |
1961: +==========================================================================+ */
1962: PROCEDURE construct_mmti (
1963: p_mmt_rec IN mtl_material_transactions%ROWTYPE
1964: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
1965: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1966: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1967: ,x_return_status OUT NOCOPY VARCHAR2)
1968: IS

Line 1966: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl

1962: PROCEDURE construct_mmti (
1963: p_mmt_rec IN mtl_material_transactions%ROWTYPE
1964: ,p_mmln_tbl IN gme_common_pvt.mtl_trans_lots_num_tbl
1965: ,x_mmti_rec OUT NOCOPY mtl_transactions_interface%ROWTYPE
1966: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1967: ,x_return_status OUT NOCOPY VARCHAR2)
1968: IS
1969: l_mmt_rec mtl_material_transactions%ROWTYPE;
1970: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

Line 1970: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

1966: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
1967: ,x_return_status OUT NOCOPY VARCHAR2)
1968: IS
1969: l_mmt_rec mtl_material_transactions%ROWTYPE;
1970: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1971: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1972: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1973: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_MMTI';
1974: BEGIN

Line 1972: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

1968: IS
1969: l_mmt_rec mtl_material_transactions%ROWTYPE;
1970: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
1971: l_mmti_rec mtl_transactions_interface%ROWTYPE;
1972: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
1973: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTRUCT_MMTI';
1974: BEGIN
1975: -- Initially let us assign the return status to success
1976: x_return_status := fnd_api.g_ret_sts_success;

Line 2086: ,x_mmt_tbl OUT NOCOPY gme_common_pvt.mtl_mat_tran_tbl

2082: +==========================================================================+ */
2083: PROCEDURE get_mat_trans (
2084: p_mat_det_id IN NUMBER
2085: ,p_batch_id IN NUMBER
2086: ,x_mmt_tbl OUT NOCOPY gme_common_pvt.mtl_mat_tran_tbl
2087: ,x_return_status OUT NOCOPY VARCHAR2)
2088: IS
2089:
2090: -- Namit S. Bug4917213. Changed query to add hint to improve sharable memory.

Line 2123: gme_common_pvt.g_txn_source_type, gme_common_pvt.g_pairs_reversal_type);

2119:
2120: IF p_mat_det_id IS NOT NULL AND p_batch_id IS NOT NULL THEN
2121: -- Namit S. Bug4917213.
2122: OPEN cur_get_trans (p_mat_det_id, p_batch_id,
2123: gme_common_pvt.g_txn_source_type, gme_common_pvt.g_pairs_reversal_type);
2124: FETCH cur_get_trans
2125: BULK COLLECT INTO x_mmt_tbl;
2126: CLOSE cur_get_trans;
2127: END IF;

Line 2174: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

2170: |
2171: +==========================================================================+ */
2172: PROCEDURE get_lot_trans (
2173: p_transaction_id IN NUMBER
2174: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
2175: ,x_return_status OUT NOCOPY VARCHAR2)
2176: IS
2177: CURSOR cur_get_lot_trans (v_transaction_id NUMBER)
2178: IS

Line 2262: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type

2258: IS
2259: SELECT transaction_interface_id
2260: FROM mtl_transactions_interface
2261: WHERE transaction_header_id = v_hdr_id
2262: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
2263: AND wip_entity_type = gme_common_pvt.g_wip_entity_type_batch;
2264:
2265: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
2266: l_number_tab gme_common_pvt.number_tab;

Line 2263: AND wip_entity_type = gme_common_pvt.g_wip_entity_type_batch;

2259: SELECT transaction_interface_id
2260: FROM mtl_transactions_interface
2261: WHERE transaction_header_id = v_hdr_id
2262: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
2263: AND wip_entity_type = gme_common_pvt.g_wip_entity_type_batch;
2264:
2265: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
2266: l_number_tab gme_common_pvt.number_tab;
2267: no_transaction_found EXCEPTION;

Line 2266: l_number_tab gme_common_pvt.number_tab;

2262: AND transaction_source_type_id = gme_common_pvt.g_txn_source_type
2263: AND wip_entity_type = gme_common_pvt.g_wip_entity_type_batch;
2264:
2265: l_return_status VARCHAR2 (1) := fnd_api.g_ret_sts_success;
2266: l_number_tab gme_common_pvt.number_tab;
2267: no_transaction_found EXCEPTION;
2268: l_api_name CONSTANT VARCHAR2 (30) := 'GME_PRE_PROCESS';
2269: BEGIN
2270: -- Initially let us assign the return status to success

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

2278: IF p_transaction_hdr_id IS NOT NULL THEN
2279: OPEN cur_get_trans (p_transaction_hdr_id);
2280: IF cur_get_trans%NOTFOUND THEN
2281: CLOSE cur_get_trans;
2282: gme_common_pvt.log_message ('GME_NO_TRANS_FOUND');
2283: RAISE fnd_api.g_exc_error;
2284: END IF;
2285: FETCH cur_get_trans
2286: BULK COLLECT INTO l_number_tab;

Line 2374: gme_common_pvt.g_precision,

2370: ) IS
2371: SELECT SUM (DECODE (v_trans_uom,
2372: t.transaction_uom, transaction_quantity,
2373: inv_convert.inv_um_convert (d.inventory_item_id,
2374: gme_common_pvt.g_precision,
2375: t.transaction_quantity,
2376: t.transaction_uom,
2377: v_trans_uom,
2378: NULL,

Line 2388: AND t.transaction_source_type_id = gme_common_pvt.g_txn_source_type

2384: WHERE t.organization_id = v_organization_id
2385: AND t.inventory_item_id = v_item_id
2386: AND t.transaction_source_id = v_batch_id
2387: AND t.trx_source_line_id = v_mat_det_id
2388: AND t.transaction_source_type_id = gme_common_pvt.g_txn_source_type
2389: AND t.trx_source_line_id = d.material_detail_id
2390: AND (t.revision IS NULL OR t.revision = v_revision)
2391: GROUP BY t.revision, t.inventory_item_id;
2392:

Line 2406: gme_common_pvt.g_precision,

2402: SELECT lot_number,
2403: SUM (DECODE (v_trans_uom,
2404: m.transaction_uom, m.transaction_quantity,
2405: inv_convert.inv_um_convert (d.inventory_item_id,
2406: gme_common_pvt.g_precision,
2407: m.transaction_quantity,
2408: m.transaction_uom,
2409: v_trans_uom,
2410: NULL,

Line 2423: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type

2419: AND l.inventory_item_id = v_item_id
2420: AND l.organization_id = v_organization_id
2421: AND l.transaction_source_id = v_batch_id
2422: AND m.trx_source_line_id = v_mat_det_id
2423: AND m.transaction_source_type_id = gme_common_pvt.g_txn_source_type
2424: -- Pawan Kumar added for checking of revision bug 5451006- 5493370
2425: AND (m.revision IS NULL OR m.revision = v_revision)
2426: GROUP BY l.lot_number, l.inventory_item_id;
2427:

Line 2557: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;

2553: WHERE transaction_interface_id = v_trans_inter_id
2554: GROUP BY lot_number;
2555:
2556: l_mmti_rec mtl_transactions_interface%ROWTYPE;
2557: l_mmli_tbl gme_common_pvt.mtl_trans_lots_inter_tbl;
2558: l_mat_dtl_rec gme_material_details%ROWTYPE;
2559: l_batch_hdr_rec gme_batch_header%ROWTYPE;
2560: l_item_rec mtl_system_items_b%ROWTYPE;
2561: l_available_qty NUMBER;

Line 2623: IF gme_common_pvt.g_batch_status_check = fnd_api.g_true THEN

2619:
2620: ELSE
2621: RAISE fnd_api.g_exc_error;
2622: END IF; -- trx_source_line_id IS NOT NULL
2623: IF gme_common_pvt.g_batch_status_check = fnd_api.g_true THEN
2624: IF l_batch_hdr_rec.batch_status NOT IN (2, 3) THEN
2625: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS');
2626: RAISE fnd_api.g_exc_error;
2627: END IF;

Line 2625: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS');

2621: RAISE fnd_api.g_exc_error;
2622: END IF; -- trx_source_line_id IS NOT NULL
2623: IF gme_common_pvt.g_batch_status_check = fnd_api.g_true THEN
2624: IF l_batch_hdr_rec.batch_status NOT IN (2, 3) THEN
2625: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS');
2626: RAISE fnd_api.g_exc_error;
2627: END IF;
2628: -- Check for step status in case the item is associated to a step.
2629: l_rel_type :=

Line 2630: gme_common_pvt.is_material_auto_release

2626: RAISE fnd_api.g_exc_error;
2627: END IF;
2628: -- Check for step status in case the item is associated to a step.
2629: l_rel_type :=
2630: gme_common_pvt.is_material_auto_release
2631: (l_mat_dtl_rec.material_detail_id);
2632: IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN -- /*3*/
2633: OPEN Cur_associated_step(l_mat_dtl_rec.material_detail_id);
2634: FETCH Cur_associated_step INTO l_step_status;

Line 2632: IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN -- /3/

2628: -- Check for step status in case the item is associated to a step.
2629: l_rel_type :=
2630: gme_common_pvt.is_material_auto_release
2631: (l_mat_dtl_rec.material_detail_id);
2632: IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN -- /*3*/
2633: OPEN Cur_associated_step(l_mat_dtl_rec.material_detail_id);
2634: FETCH Cur_associated_step INTO l_step_status;
2635: CLOSE Cur_associated_step;
2636: IF l_step_status NOT IN (2,3) THEN

Line 2637: gme_common_pvt.log_message ('GME_API_INVALID_STEP_STATUS');

2633: OPEN Cur_associated_step(l_mat_dtl_rec.material_detail_id);
2634: FETCH Cur_associated_step INTO l_step_status;
2635: CLOSE Cur_associated_step;
2636: IF l_step_status NOT IN (2,3) THEN
2637: gme_common_pvt.log_message ('GME_API_INVALID_STEP_STATUS');
2638: RAISE fnd_api.g_exc_error;
2639: END IF;
2640: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN
2641: -- check for item release type for products

Line 2640: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN

2636: IF l_step_status NOT IN (2,3) THEN
2637: gme_common_pvt.log_message ('GME_API_INVALID_STEP_STATUS');
2638: RAISE fnd_api.g_exc_error;
2639: END IF;
2640: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN
2641: -- check for item release type for products
2642: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release )
2643: AND l_mat_dtl_rec.line_type IN (1,2)
2644: AND l_mat_dtl_rec.phantom_line_id IS NULL THEN

Line 2642: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release )

2638: RAISE fnd_api.g_exc_error;
2639: END IF;
2640: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN
2641: -- check for item release type for products
2642: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release )
2643: AND l_mat_dtl_rec.line_type IN (1,2)
2644: AND l_mat_dtl_rec.phantom_line_id IS NULL THEN
2645: IF l_batch_hdr_rec.batch_status <> 3 THEN
2646: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');

Line 2646: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');

2642: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release )
2643: AND l_mat_dtl_rec.line_type IN (1,2)
2644: AND l_mat_dtl_rec.phantom_line_id IS NULL THEN
2645: IF l_batch_hdr_rec.batch_status <> 3 THEN
2646: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');
2647: RAISE fnd_api.g_exc_error;
2648: END IF;
2649: END IF;
2650: END IF; -- gme_common_pvt.g_batch_status_check

Line 2650: END IF; -- gme_common_pvt.g_batch_status_check

2646: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');
2647: RAISE fnd_api.g_exc_error;
2648: END IF;
2649: END IF;
2650: END IF; -- gme_common_pvt.g_batch_status_check
2651: IF l_mmti_rec.transaction_type_id IN
2652: (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return) THEN
2653: IF l_mat_dtl_rec.line_type <> -1 THEN
2654: /* Bug 5141394 Changed message */

Line 2652: (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return) THEN

2648: END IF;
2649: END IF;
2650: END IF; -- gme_common_pvt.g_batch_status_check
2651: IF l_mmti_rec.transaction_type_id IN
2652: (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return) THEN
2653: IF l_mat_dtl_rec.line_type <> -1 THEN
2654: /* Bug 5141394 Changed message */
2655: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
2656: RAISE fnd_api.g_exc_error;

Line 2655: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');

2651: IF l_mmti_rec.transaction_type_id IN
2652: (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return) THEN
2653: IF l_mat_dtl_rec.line_type <> -1 THEN
2654: /* Bug 5141394 Changed message */
2655: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
2656: RAISE fnd_api.g_exc_error;
2657: END IF;
2658: ELSIF l_mmti_rec.transaction_type_id IN
2659: (gme_common_pvt.g_prod_completion

Line 2659: (gme_common_pvt.g_prod_completion

2655: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
2656: RAISE fnd_api.g_exc_error;
2657: END IF;
2658: ELSIF l_mmti_rec.transaction_type_id IN
2659: (gme_common_pvt.g_prod_completion
2660: ,gme_common_pvt.g_prod_return) THEN
2661: IF l_mat_dtl_rec.line_type <> 1 THEN
2662: /* Bug 5141394 Changed message */
2663: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');

Line 2660: ,gme_common_pvt.g_prod_return) THEN

2656: RAISE fnd_api.g_exc_error;
2657: END IF;
2658: ELSIF l_mmti_rec.transaction_type_id IN
2659: (gme_common_pvt.g_prod_completion
2660: ,gme_common_pvt.g_prod_return) THEN
2661: IF l_mat_dtl_rec.line_type <> 1 THEN
2662: /* Bug 5141394 Changed message */
2663: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
2664: RAISE fnd_api.g_exc_error;

Line 2663: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');

2659: (gme_common_pvt.g_prod_completion
2660: ,gme_common_pvt.g_prod_return) THEN
2661: IF l_mat_dtl_rec.line_type <> 1 THEN
2662: /* Bug 5141394 Changed message */
2663: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
2664: RAISE fnd_api.g_exc_error;
2665: END IF;
2666: ELSIF l_mmti_rec.transaction_type_id IN
2667: (gme_common_pvt.g_byprod_completion

Line 2667: (gme_common_pvt.g_byprod_completion

2663: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
2664: RAISE fnd_api.g_exc_error;
2665: END IF;
2666: ELSIF l_mmti_rec.transaction_type_id IN
2667: (gme_common_pvt.g_byprod_completion
2668: ,gme_common_pvt.g_byprod_return) THEN
2669: IF l_mat_dtl_rec.line_type <> 2 THEN
2670: /* Bug 5141394 Changed message */
2671: --RLNAGARA Bug6873185 Moved below line which was setting message name inside the IF condition.

Line 2668: ,gme_common_pvt.g_byprod_return) THEN

2664: RAISE fnd_api.g_exc_error;
2665: END IF;
2666: ELSIF l_mmti_rec.transaction_type_id IN
2667: (gme_common_pvt.g_byprod_completion
2668: ,gme_common_pvt.g_byprod_return) THEN
2669: IF l_mat_dtl_rec.line_type <> 2 THEN
2670: /* Bug 5141394 Changed message */
2671: --RLNAGARA Bug6873185 Moved below line which was setting message name inside the IF condition.
2672: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');

Line 2672: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');

2668: ,gme_common_pvt.g_byprod_return) THEN
2669: IF l_mat_dtl_rec.line_type <> 2 THEN
2670: /* Bug 5141394 Changed message */
2671: --RLNAGARA Bug6873185 Moved below line which was setting message name inside the IF condition.
2672: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
2673: RAISE fnd_api.g_exc_error;
2674: END IF;
2675: END IF;
2676:

Line 2680: gme_common_pvt.g_transaction_header_id THEN

2676:
2677: -- check for phantom
2678: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL THEN
2679: IF l_mmti_rec.transaction_header_id <>
2680: gme_common_pvt.g_transaction_header_id THEN
2681: gme_common_pvt.log_message ('GME_PHANTOM_NO_RETURN');
2682: RAISE fnd_api.g_exc_error;
2683: END IF;
2684: END IF;

Line 2681: gme_common_pvt.log_message ('GME_PHANTOM_NO_RETURN');

2677: -- check for phantom
2678: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL THEN
2679: IF l_mmti_rec.transaction_header_id <>
2680: gme_common_pvt.g_transaction_header_id THEN
2681: gme_common_pvt.log_message ('GME_PHANTOM_NO_RETURN');
2682: RAISE fnd_api.g_exc_error;
2683: END IF;
2684: END IF;
2685:

Line 2691: gme_common_pvt.log_message ('PM_INVALID_ITEM');

2687: OPEN cur_get_item_rec (l_mmti_rec.inventory_item_id, l_mmti_rec.organization_id);
2688: FETCH cur_get_item_rec INTO l_item_rec;
2689: IF cur_get_item_rec%NOTFOUND THEN
2690: CLOSE cur_get_item_rec;
2691: gme_common_pvt.log_message ('PM_INVALID_ITEM');
2692: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2693: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
2694: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
2695: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));

Line 2706: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN

2702: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
2703: END IF;
2704:
2705: /* Bug 5358129 for ingredients lots should exist */
2706: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN
2707: FOR get_lots IN (SELECT DISTINCT lot_number FROM mtl_transaction_lots_interface WHERE transaction_interface_id = p_transaction_interface_id) LOOP
2708: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => l_mmti_rec.organization_id,
2709: p_inventory_item_id => l_mmti_rec.inventory_item_id,
2710: p_lot_number => get_lots.lot_number,

Line 2720: (gme_common_pvt.g_byprod_return

2716: END IF;
2717:
2718: -- if return transaction then check qty was issued and return not more than issued qty
2719: IF l_mmti_rec.transaction_type_id IN
2720: (gme_common_pvt.g_byprod_return
2721: ,gme_common_pvt.g_prod_return
2722: ,gme_common_pvt.g_ing_return) THEN
2723: IF (g_debug <= gme_debug.g_log_statement) THEN
2724: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||

Line 2721: ,gme_common_pvt.g_prod_return

2717:
2718: -- if return transaction then check qty was issued and return not more than issued qty
2719: IF l_mmti_rec.transaction_type_id IN
2720: (gme_common_pvt.g_byprod_return
2721: ,gme_common_pvt.g_prod_return
2722: ,gme_common_pvt.g_ing_return) THEN
2723: IF (g_debug <= gme_debug.g_log_statement) THEN
2724: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||
2725: 'Return transaction for : '||l_mmti_rec.transaction_type_id);

Line 2722: ,gme_common_pvt.g_ing_return) THEN

2718: -- if return transaction then check qty was issued and return not more than issued qty
2719: IF l_mmti_rec.transaction_type_id IN
2720: (gme_common_pvt.g_byprod_return
2721: ,gme_common_pvt.g_prod_return
2722: ,gme_common_pvt.g_ing_return) THEN
2723: IF (g_debug <= gme_debug.g_log_statement) THEN
2724: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||
2725: 'Return transaction for : '||l_mmti_rec.transaction_type_id);
2726:

Line 2763: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

2759: || l_available_qty);
2760: END IF;
2761:
2762: IF ABS (l_available_qty) < ABS (l_mmti_rec.transaction_quantity) THEN
2763: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
2764: RAISE fnd_api.g_exc_error;
2765: END IF;
2766: ELSE /* Lot Control */
2767: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 2803: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

2799: || l_available_qty);
2800: END IF;
2801:
2802: IF ABS (l_available_qty) < ABS (get_rec.l_mtli_lot_qty) THEN
2803: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
2804: RAISE fnd_api.g_exc_error;
2805: END IF;
2806: END LOOP;
2807: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */

Line 2888: gme_common_pvt.count_and_get (x_count => x_message_count

2884: || 'Entering');
2885: END IF;
2886:
2887: -- based on message call count and get
2888: gme_common_pvt.count_and_get (x_count => x_message_count
2889: ,p_encoded => fnd_api.g_false
2890: ,x_data => x_message_list);
2891:
2892: UPDATE mtl_transactions_interface

Line 2937: | and gme_common_pvt.reset_txn_hdr_tbl.

2933: |
2934: | HISTORY
2935: | Created 02-Feb-05 Pawan Kumar
2936: | 5176319 20-Jun-06 Namit S. Added call to gme_unrelease_batch_pvt.create_matl_resv_pplot
2937: | and gme_common_pvt.reset_txn_hdr_tbl.
2938: | Bug 5763818 28-Feb-2007 Archana Mundhe Do not update actual qty if
2939: | the material detail line has been deleted.
2940: | Bug 6997483 01-May-2005 Archana Mundhe Added parameter transaction_id
2941: | to gme_unrelease_batch_pvt.create_matl_resv_pplot.

Line 2970: AND t.transaction_source_type_id = gme_common_pvt.g_txn_source_type

2966: FROM mtl_material_transactions t , gme_material_details d, mtl_transaction_lot_numbers tl
2967: WHERE t.organization_id = v_organization_id
2968: AND t.transaction_source_id = v_batch_id
2969: AND t.trx_source_line_id = v_mat_det_id
2970: AND t.transaction_source_type_id = gme_common_pvt.g_txn_source_type
2971: AND t.trx_source_line_id = d.material_detail_id
2972: AND tl.transaction_id(+) = t.transaction_id) a;
2973:
2974: CURSOR cur_lot_qty (

Line 2990: gme_common_pvt.g_txn_source_type

2986: AND l.organization_id = v_organization_id
2987: AND l.transaction_source_id = v_batch_id
2988: AND m.trx_source_line_id = v_mat_det_id
2989: AND m.transaction_source_type_id =
2990: gme_common_pvt.g_txn_source_type
2991: GROUP BY l.lot_number, l.inventory_item_id;
2992:
2993: -- Bug 5763818
2994: CURSOR check_event_batchmtl_removed (

Line 3112: AND pair_type = gme_common_pvt.g_pairs_reversal_type;

3108: SET transaction_id2 = l_transaction_id
3109: WHERE batch_id = l_transaction_source_id
3110: AND material_detail_id = l_trx_source_line_id
3111: AND transaction_id1 = l_source_line_id
3112: AND pair_type = gme_common_pvt.g_pairs_reversal_type;
3113: -- now insert a reverse record
3114: INSERT INTO gme_transaction_pairs
3115: (batch_id, material_detail_id
3116: ,transaction_id1, transaction_id2

Line 3120: ,gme_common_pvt.g_pairs_reversal_type);

3116: ,transaction_id1, transaction_id2
3117: ,pair_type)
3118: VALUES (l_transaction_source_id, l_trx_source_line_id
3119: ,l_transaction_id, l_source_line_id
3120: ,gme_common_pvt.g_pairs_reversal_type);
3121:
3122: IF (g_debug <= gme_debug.g_log_statement) THEN
3123: gme_debug.put_line ( g_pkg_name
3124: || '.'

Line 3177: AND pair_type = gme_common_pvt.g_pairs_phantom_type;

3173: END IF;
3174: UPDATE gme_transaction_pairs
3175: SET transaction_id2 = l_transaction_id
3176: WHERE transaction_id2 = l_transaction_reference
3177: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
3178:
3179: BEGIN
3180: SELECT *
3181: INTO l_gme_pairs_rec

Line 3184: AND pair_type = gme_common_pvt.g_pairs_phantom_type;

3180: SELECT *
3181: INTO l_gme_pairs_rec
3182: FROM gme_transaction_pairs
3183: WHERE transaction_id2 = l_transaction_id
3184: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
3185:
3186: IF (g_debug <= gme_debug.g_log_statement) THEN
3187: gme_debug.put_line
3188: ( g_pkg_name

Line 3234: ,gme_common_pvt.g_pairs_phantom_type);

3230: ,transaction_id1, transaction_id2
3231: ,pair_type)
3232: VALUES (l_transaction_source_id, l_trx_source_line_id
3233: ,l_transaction_id, l_gme_pairs_rec.transaction_id1
3234: ,gme_common_pvt.g_pairs_phantom_type);
3235:
3236:
3237: EXCEPTION
3238: WHEN NO_DATA_FOUND THEN

Line 3278: ,gme_common_pvt.g_pairs_phantom_type);

3274: ,transaction_id1, transaction_id2
3275: ,pair_type)
3276: VALUES (l_transaction_source_id, l_trx_source_line_id
3277: ,l_transaction_id, l_transaction_reference
3278: ,gme_common_pvt.g_pairs_phantom_type);
3279: END;
3280: ELSE
3281: l_dispense_id := l_transaction_reference ;
3282: -- make a call to GMO for informing about dispense_id

Line 3284: IF l_transaction_type_id = gme_common_pvt.g_ing_issue THEN

3280: ELSE
3281: l_dispense_id := l_transaction_reference ;
3282: -- make a call to GMO for informing about dispense_id
3283: IF l_mat_dtl_rec.dispense_ind = 'Y' THEN
3284: IF l_transaction_type_id = gme_common_pvt.g_ing_issue THEN
3285: -- For consume
3286: GMO_DISPENSE_GRP.CHANGE_DISPENSE_STATUS
3287: (p_api_version => 1.0,
3288: p_init_msg_list => 'F',

Line 3389: l_transaction_type_id = gme_common_pvt.g_prod_completion

3385: -- Pawan Kumar bug 5483071 added check for transaction refernce and source_line_id
3386: -- THis done so that we donot try to invoke this for reversal of wip return
3387: -- dispense is not a issue as it is only for ingredients
3388: IF l_mat_dtl_rec.line_type <> -1 AND
3389: l_transaction_type_id = gme_common_pvt.g_prod_completion
3390: AND l_transaction_reference IS NULL
3391: -- Pawan Kumar add bug 5709186
3392: -- in case transaction added from transaction form, l_source_line_id is null.
3393: AND nvl(l_source_line_id, -99) < 0 THEN

Line 3488: gme_common_pvt.log_message ('GME_INVALID_FIELD'

3484: || 'Entering');
3485: END IF;
3486:
3487: IF p_batch_id IS NULL AND p_material_detail_id IS NULL THEN
3488: gme_common_pvt.log_message ('GME_INVALID_FIELD'
3489: ,'FIELD'
3490: ,'p_batch_id');
3491: RAISE fnd_api.g_exc_error;
3492: END IF;

Line 3569: | p_header_id Transaction header id DEFAULT gme_common_pvt.get_txn_header_id

3565: | x_msg_count Returns number of error message in the error message stack in case of failure
3566: | x_msg_data Returns the error message in case of failure
3567: | x_trans_count The count of material transaction interface records processed.
3568: | p_table Source of transaction records with value 1 of material transaction interface table and value 2 of material transaction temp table
3569: | p_header_id Transaction header id DEFAULT gme_common_pvt.get_txn_header_id
3570: |
3571: | RETURNS
3572: | returns via x_ OUT parameters
3573: |

Line 3579: | Added call to gme_common_pvt.log message to log the actual error message which we can

3575: | Created 07-Mar-05 Jalaj Srivastava
3576: | 26-JUL-2007 Swapna Bug#6266714
3577: | Added condition to check the transaction source type in the for loop query.
3578: | 26-JUL-2007 Swapna Bug#6685680
3579: | Added call to gme_common_pvt.log message to log the actual error message which we can
3580: | retrieve using gme_common_pvt.count_and_get from the wraper apis.
3581: +==========================================================================+ */
3582: /* Bug 5255959 added p_clear_qty_cache parameter */
3583: PROCEDURE process_transactions (

Line 3580: | retrieve using gme_common_pvt.count_and_get from the wraper apis.

3576: | 26-JUL-2007 Swapna Bug#6266714
3577: | Added condition to check the transaction source type in the for loop query.
3578: | 26-JUL-2007 Swapna Bug#6685680
3579: | Added call to gme_common_pvt.log message to log the actual error message which we can
3580: | retrieve using gme_common_pvt.count_and_get from the wraper apis.
3581: +==========================================================================+ */
3582: /* Bug 5255959 added p_clear_qty_cache parameter */
3583: PROCEDURE process_transactions (
3584: p_api_version IN NUMBER := 1

Line 3591: := gme_common_pvt.get_txn_header_id

3587: ,p_validation_level IN NUMBER
3588: := fnd_api.g_valid_level_full
3589: ,p_table IN NUMBER := 2
3590: ,p_header_id IN NUMBER
3591: := gme_common_pvt.get_txn_header_id
3592: ,x_return_status OUT NOCOPY VARCHAR2
3593: ,x_msg_count OUT NOCOPY NUMBER
3594: ,x_msg_data OUT NOCOPY VARCHAR2
3595: ,x_trans_count OUT NOCOPY NUMBER

Line 3605: gme_common_pvt.g_transaction_header_id;

3601: IS
3602: SELECT ERROR_CODE, error_explanation
3603: FROM mtl_transactions_interface
3604: WHERE transaction_header_id =
3605: gme_common_pvt.g_transaction_header_id;
3606:
3607: CURSOR get_error_temp
3608: IS
3609: SELECT ERROR_CODE, error_explanation

Line 3612: gme_common_pvt.g_transaction_header_id;

3608: IS
3609: SELECT ERROR_CODE, error_explanation
3610: FROM mtl_material_transactions_temp
3611: WHERE transaction_header_id =
3612: gme_common_pvt.g_transaction_header_id;
3613:
3614: l_api_name CONSTANT VARCHAR2 (30) := 'PROCESS_TRANSACTIONS';
3615: l_return NUMBER;
3616: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;

Line 3687: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'

3683: IF (l_return = 0) THEN
3684: x_return_status := 'S';
3685: END IF;
3686: IF (x_msg_data IS NOT NULL) THEN
3687: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
3688: ,p_product_code => 'FND'
3689: ,p_token1_name => 'MESSAGE'
3690: ,p_token1_value => x_msg_data);
3691: END IF;

Line 3698: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'

3694: IF p_table = 1 THEN
3695: x_msg_count := 0;
3696: FOR rec IN get_error_int LOOP
3697: /*Bug#6685680 Add the below call to log the actual error message*/
3698: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
3699: ,p_product_code => 'FND'
3700: ,p_token1_name => 'MESSAGE'
3701: ,p_token1_value => rec.error_explanation);
3702: --fnd_message.set_encoded (rec.error_explanation);

Line 3714: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'

3710: ELSE
3711: x_msg_count := 0;
3712: FOR rec IN get_error_temp LOOP
3713: /*Bug#6685680 Add the below call to log the actual error message*/
3714: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
3715: ,p_product_code => 'FND'
3716: ,p_token1_name => 'MESSAGE'
3717: ,p_token1_value => rec.error_explanation);
3718: --fnd_message.set_encoded (rec.error_explanation);

Line 3763: mmt.transaction_set_id = gme_common_pvt.g_transaction_header_id

3759: mtl_system_items_b msi,
3760: gme_material_details md,
3761: gme_transaction_pairs gtp
3762: WHERE
3763: mmt.transaction_set_id = gme_common_pvt.g_transaction_header_id
3764: AND mtln.transaction_id(+) = mmt.transaction_id
3765: AND msi.organization_id = mmt.organization_id
3766: AND msi.inventory_item_id = mmt.inventory_item_id
3767: AND md.material_detail_id = mmt.trx_source_line_id

Line 3771: AND mmt.transaction_source_type_id = gme_common_pvt.g_txn_source_type /Bug#6266714/

3767: AND md.material_detail_id = mmt.trx_source_line_id
3768: AND gtp.transaction_id1(+) = mmt.transaction_id
3769: AND gtp.batch_id(+) = mmt.transaction_source_id
3770: AND gtp.material_detail_id(+) = mmt.trx_source_line_id
3771: AND mmt.transaction_source_type_id = gme_common_pvt.g_txn_source_type /*Bug#6266714*/
3772: ORDER BY mmt.transaction_date,
3773: case md.line_type
3774: when -1 then 0
3775: when 2 then 1

Line 3849: gme_common_pvt.g_transaction_header_id := NULL;

3845: p_qty_tbl.delete();
3846: /* Bug 5903208 End GMF code */
3847:
3848: IF x_return_status = 'S' THEN
3849: gme_common_pvt.g_transaction_header_id := NULL;
3850: gme_common_pvt.g_batch_status_check := fnd_api.g_true;
3851: END IF;
3852: /* end temporary */
3853:

Line 3850: gme_common_pvt.g_batch_status_check := fnd_api.g_true;

3846: /* Bug 5903208 End GMF code */
3847:
3848: IF x_return_status = 'S' THEN
3849: gme_common_pvt.g_transaction_header_id := NULL;
3850: gme_common_pvt.g_batch_status_check := fnd_api.g_true;
3851: END IF;
3852: /* end temporary */
3853:
3854: IF (l_return = 0) AND (fnd_api.to_boolean (p_commit) ) THEN

Line 3868: gme_common_pvt.reset_txn_hdr_tbl; -- nsinghi bug#5176319

3864:
3865: inv_quantity_tree_pub.clear_quantity_cache;
3866: END IF;
3867:
3868: gme_common_pvt.reset_txn_hdr_tbl; -- nsinghi bug#5176319
3869:
3870: IF (NVL (g_debug, 0) IN
3871: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
3872: gme_debug.put_line ( g_pkg_name

Line 3949: DEFAULT gme_common_pvt.g_txn_source_type

3945: ,p_tree_mode IN INTEGER
3946: ,p_is_serial_control IN BOOLEAN DEFAULT FALSE
3947: ,p_grade_code IN VARCHAR2
3948: ,p_demand_source_type_id IN NUMBER
3949: DEFAULT gme_common_pvt.g_txn_source_type
3950: ,p_demand_source_header_id IN NUMBER DEFAULT -9999
3951: ,p_demand_source_line_id IN NUMBER DEFAULT -9999
3952: ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
3953: ,p_lot_expiration_date IN DATE DEFAULT NULL

Line 4176: DEFAULT gme_common_pvt.g_txn_source_type

4172: ,p_inventory_item_id IN NUMBER
4173: ,p_tree_mode IN INTEGER
4174: ,p_is_serial_control IN BOOLEAN := FALSE
4175: ,p_demand_source_type_id IN NUMBER
4176: DEFAULT gme_common_pvt.g_txn_source_type
4177: ,p_demand_source_header_id IN NUMBER DEFAULT -9999
4178: ,p_demand_source_line_id IN NUMBER DEFAULT -9999
4179: ,p_demand_source_name IN VARCHAR2 DEFAULT NULL
4180: ,p_lot_expiration_date IN DATE DEFAULT NULL

Line 4438: gme_common_pvt.log_message(p_product_code => 'INV', p_message_code => 'INV_LOT_EXPIRED');

4434: IF l_expire_date IS NULL THEN
4435: RETURN FALSE;
4436: ELSE
4437: IF l_expire_date < NVL(p_date, SYSDATE) THEN
4438: gme_common_pvt.log_message(p_product_code => 'INV', p_message_code => 'INV_LOT_EXPIRED');
4439: RETURN TRUE;
4440: END IF;
4441: END IF;
4442: RETURN FALSE;

Line 4500: ,gme_common_pvt.g_transaction_header_id

4496: ,reservation_quantity
4497: ,transaction_sequence_id
4498: ,transfer_lpn_id)
4499: VALUES (p_mmti_rec.transaction_interface_id
4500: ,gme_common_pvt.g_transaction_header_id
4501: ,'OPM' -- source_code
4502: ,p_mmti_rec.transaction_source_id --source_header_id
4503: ,1 -- lock_flag
4504: ,2 -- transaction_mode

Line 4510: ,gme_common_pvt.g_user_ident --last_updated_by

4506: ,2 -- validation_required
4507: , NVL (p_mmti_rec.source_line_id, -99)-- transaction_id for reversal
4508: ,p_mmti_rec.transaction_source_id -- batch id
4509: ,p_mmti_rec.trx_source_line_id -- material detail id
4510: ,gme_common_pvt.g_user_ident --last_updated_by
4511: ,gme_common_pvt.g_user_ident -- last_update_login
4512: ,gme_common_pvt.g_timestamp --last_update_date
4513: ,gme_common_pvt.g_timestamp --creation_date
4514: ,gme_common_pvt.g_user_ident --created_by

Line 4511: ,gme_common_pvt.g_user_ident -- last_update_login

4507: , NVL (p_mmti_rec.source_line_id, -99)-- transaction_id for reversal
4508: ,p_mmti_rec.transaction_source_id -- batch id
4509: ,p_mmti_rec.trx_source_line_id -- material detail id
4510: ,gme_common_pvt.g_user_ident --last_updated_by
4511: ,gme_common_pvt.g_user_ident -- last_update_login
4512: ,gme_common_pvt.g_timestamp --last_update_date
4513: ,gme_common_pvt.g_timestamp --creation_date
4514: ,gme_common_pvt.g_user_ident --created_by
4515: ,p_mmti_rec.inventory_item_id -- inventory_item_id

Line 4512: ,gme_common_pvt.g_timestamp --last_update_date

4508: ,p_mmti_rec.transaction_source_id -- batch id
4509: ,p_mmti_rec.trx_source_line_id -- material detail id
4510: ,gme_common_pvt.g_user_ident --last_updated_by
4511: ,gme_common_pvt.g_user_ident -- last_update_login
4512: ,gme_common_pvt.g_timestamp --last_update_date
4513: ,gme_common_pvt.g_timestamp --creation_date
4514: ,gme_common_pvt.g_user_ident --created_by
4515: ,p_mmti_rec.inventory_item_id -- inventory_item_id
4516: ,p_mmti_rec.revision

Line 4513: ,gme_common_pvt.g_timestamp --creation_date

4509: ,p_mmti_rec.trx_source_line_id -- material detail id
4510: ,gme_common_pvt.g_user_ident --last_updated_by
4511: ,gme_common_pvt.g_user_ident -- last_update_login
4512: ,gme_common_pvt.g_timestamp --last_update_date
4513: ,gme_common_pvt.g_timestamp --creation_date
4514: ,gme_common_pvt.g_user_ident --created_by
4515: ,p_mmti_rec.inventory_item_id -- inventory_item_id
4516: ,p_mmti_rec.revision
4517: ,p_mmti_rec.organization_id --organization_id

Line 4514: ,gme_common_pvt.g_user_ident --created_by

4510: ,gme_common_pvt.g_user_ident --last_updated_by
4511: ,gme_common_pvt.g_user_ident -- last_update_login
4512: ,gme_common_pvt.g_timestamp --last_update_date
4513: ,gme_common_pvt.g_timestamp --creation_date
4514: ,gme_common_pvt.g_user_ident --created_by
4515: ,p_mmti_rec.inventory_item_id -- inventory_item_id
4516: ,p_mmti_rec.revision
4517: ,p_mmti_rec.organization_id --organization_id
4518: /* FPBug#4543872 rework

Line 4537: gme_common_pvt.g_txn_source_type

4533: p_mmti_rec.transaction_uom, --transaction_uom
4534: p_mmti_rec.subinventory_code
4535: , --subinventory_code
4536: p_mmti_rec.locator_id, --locator_id
4537: gme_common_pvt.g_txn_source_type
4538: , -- (Batch) transaction_source_type_id
4539: gme_common_pvt.g_wip_entity_type_batch -- (for batch) wip_entity_type
4540: ,p_mmti_rec.transaction_source_name -- transaction_source_name
4541: ,p_mmti_rec.transaction_reference

Line 4539: gme_common_pvt.g_wip_entity_type_batch -- (for batch) wip_entity_type

4535: , --subinventory_code
4536: p_mmti_rec.locator_id, --locator_id
4537: gme_common_pvt.g_txn_source_type
4538: , -- (Batch) transaction_source_type_id
4539: gme_common_pvt.g_wip_entity_type_batch -- (for batch) wip_entity_type
4540: ,p_mmti_rec.transaction_source_name -- transaction_source_name
4541: ,p_mmti_rec.transaction_reference
4542: ,p_mmti_rec.reason_id
4543: ,p_mmti_rec.transaction_batch_id -- must populate for seq

Line 4583: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl

4579: +==========================================================================+ */
4580: PROCEDURE get_mmt_transactions (
4581: p_transaction_id IN NUMBER
4582: ,x_mmt_rec OUT NOCOPY mtl_material_transactions%ROWTYPE
4583: ,x_mmln_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_num_tbl
4584: ,x_return_status OUT NOCOPY VARCHAR2)
4585: IS
4586:
4587: CURSOR cur_get_transaction (v_transaction_id NUMBER)

Line 4613: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);

4609: || 'Entering with transaction '||p_transaction_id);
4610: END IF;
4611:
4612: IF p_transaction_id IS NULL THEN
4613: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
4614:
4615: IF (g_debug <= gme_debug.g_log_statement) THEN
4616: gme_debug.put_line ( g_pkg_name
4617: || '.'

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

4646: RAISE fnd_api.g_exc_error;
4647: END IF;
4648: ELSE /* IF cur_get_transaction%FOUND THEN */
4649: CLOSE cur_get_transaction;
4650: gme_common_pvt.log_message ('GME_NO_TRANS_FOUND');
4651: RAISE fnd_api.g_exc_error;
4652: END IF;
4653: CLOSE cur_get_transaction;
4654:

Line 4727: gme_common_pvt.log_message(p_message_code => 'INV_LOT_EXPIRED',

4723: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Normal Exiting');
4724: END IF;
4725: EXCEPTION
4726: WHEN expired_lot THEN
4727: gme_common_pvt.log_message(p_message_code => 'INV_LOT_EXPIRED',
4728: p_product_code => 'INV');
4729: x_return_status := fnd_api.g_ret_sts_error;
4730: WHEN invalid_lot THEN
4731: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4732: gme_common_pvt.log_message(p_message_code => 'INV_INVALID_LOT',

4728: p_product_code => 'INV');
4729: x_return_status := fnd_api.g_ret_sts_error;
4730: WHEN invalid_lot THEN
4731: x_return_status := fnd_api.g_ret_sts_unexp_error;
4732: gme_common_pvt.log_message(p_message_code => 'INV_INVALID_LOT',
4733: p_product_code => 'INV');
4734: WHEN OTHERS THEN
4735: x_return_status := fnd_api.g_ret_sts_unexp_error;
4736: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);

Line 4744: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,

4740: END validate_lot_for_ing;
4741:
4742: /* Added for bug 5597385 */
4743: PROCEDURE gmo_pre_process_val(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
4744: p_mmli_tbl IN gme_common_pvt.mtl_trans_lots_inter_tbl,
4745: p_mode IN VARCHAR2,
4746: x_return_status OUT NOCOPY VARCHAR2) IS
4747: CURSOR cur_get_item_rec (v_item_id NUMBER, v_org_id NUMBER) IS
4748: SELECT *

Line 4802: IF gme_common_pvt.g_batch_status_check = fnd_api.g_true THEN

4798: END IF; -- material fetch
4799: ELSE
4800: RAISE fnd_api.g_exc_error;
4801: END IF; -- trx_source_line_id IS NOT NULL
4802: IF gme_common_pvt.g_batch_status_check = fnd_api.g_true THEN
4803: IF l_batch_hdr_rec.batch_status NOT IN (2, 3) THEN
4804: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS');
4805: RAISE fnd_api.g_exc_error;
4806: END IF;

Line 4804: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS');

4800: RAISE fnd_api.g_exc_error;
4801: END IF; -- trx_source_line_id IS NOT NULL
4802: IF gme_common_pvt.g_batch_status_check = fnd_api.g_true THEN
4803: IF l_batch_hdr_rec.batch_status NOT IN (2, 3) THEN
4804: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS');
4805: RAISE fnd_api.g_exc_error;
4806: END IF;
4807: -- Check for step status in case the item is associated to a step.
4808: l_rel_type := gme_common_pvt.is_material_auto_release(l_mat_dtl_rec.material_detail_id);

Line 4808: l_rel_type := gme_common_pvt.is_material_auto_release(l_mat_dtl_rec.material_detail_id);

4804: gme_common_pvt.log_message ('GME_INVALID_BATCH_STATUS');
4805: RAISE fnd_api.g_exc_error;
4806: END IF;
4807: -- Check for step status in case the item is associated to a step.
4808: l_rel_type := gme_common_pvt.is_material_auto_release(l_mat_dtl_rec.material_detail_id);
4809: IF (l_rel_type = gme_common_pvt.g_mtl_autobystep_release) THEN
4810: OPEN Cur_associated_step(l_mat_dtl_rec.material_detail_id);
4811: FETCH Cur_associated_step INTO l_step_status;
4812: CLOSE Cur_associated_step;

Line 4809: IF (l_rel_type = gme_common_pvt.g_mtl_autobystep_release) THEN

4805: RAISE fnd_api.g_exc_error;
4806: END IF;
4807: -- Check for step status in case the item is associated to a step.
4808: l_rel_type := gme_common_pvt.is_material_auto_release(l_mat_dtl_rec.material_detail_id);
4809: IF (l_rel_type = gme_common_pvt.g_mtl_autobystep_release) THEN
4810: OPEN Cur_associated_step(l_mat_dtl_rec.material_detail_id);
4811: FETCH Cur_associated_step INTO l_step_status;
4812: CLOSE Cur_associated_step;
4813: IF l_step_status NOT IN (2,3) THEN

Line 4814: gme_common_pvt.log_message ('GME_API_INVALID_STEP_STATUS');

4810: OPEN Cur_associated_step(l_mat_dtl_rec.material_detail_id);
4811: FETCH Cur_associated_step INTO l_step_status;
4812: CLOSE Cur_associated_step;
4813: IF l_step_status NOT IN (2,3) THEN
4814: gme_common_pvt.log_message ('GME_API_INVALID_STEP_STATUS');
4815: RAISE fnd_api.g_exc_error;
4816: END IF;
4817: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN
4818: -- check for item release type for products

Line 4817: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN

4813: IF l_step_status NOT IN (2,3) THEN
4814: gme_common_pvt.log_message ('GME_API_INVALID_STEP_STATUS');
4815: RAISE fnd_api.g_exc_error;
4816: END IF;
4817: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN
4818: -- check for item release type for products
4819: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release AND l_mat_dtl_rec.line_type IN (1,2) AND l_mat_dtl_rec.phantom_line_id IS NULL) THEN
4820: IF l_batch_hdr_rec.batch_status <> 3 THEN
4821: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');

Line 4819: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release AND l_mat_dtl_rec.line_type IN (1,2) AND l_mat_dtl_rec.phantom_line_id IS NULL) THEN

4815: RAISE fnd_api.g_exc_error;
4816: END IF;
4817: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN
4818: -- check for item release type for products
4819: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release AND l_mat_dtl_rec.line_type IN (1,2) AND l_mat_dtl_rec.phantom_line_id IS NULL) THEN
4820: IF l_batch_hdr_rec.batch_status <> 3 THEN
4821: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');
4822: RAISE fnd_api.g_exc_error;
4823: END IF;

Line 4821: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');

4817: END IF; -- IF ( l_rel_type = gme_common_pvt.g_mtl_autobystep_release ) THEN
4818: -- check for item release type for products
4819: IF (l_rel_type = gme_common_pvt.g_mtl_auto_release AND l_mat_dtl_rec.line_type IN (1,2) AND l_mat_dtl_rec.phantom_line_id IS NULL) THEN
4820: IF l_batch_hdr_rec.batch_status <> 3 THEN
4821: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');
4822: RAISE fnd_api.g_exc_error;
4823: END IF;
4824: END IF;
4825: END IF; -- gme_common_pvt.g_batch_status_check

Line 4825: END IF; -- gme_common_pvt.g_batch_status_check

4821: gme_common_pvt.log_message('GME_INVALID_BATCH_STATUS');
4822: RAISE fnd_api.g_exc_error;
4823: END IF;
4824: END IF;
4825: END IF; -- gme_common_pvt.g_batch_status_check
4826: IF (l_mat_dtl_rec.line_type <> -1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return))
4827: OR (l_mat_dtl_rec.line_type <> 1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_prod_return))
4828: OR (l_mat_dtl_rec.line_type <> 2 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_completion, gme_common_pvt.g_byprod_return)) THEN
4829: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');

Line 4826: IF (l_mat_dtl_rec.line_type <> -1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return))

4822: RAISE fnd_api.g_exc_error;
4823: END IF;
4824: END IF;
4825: END IF; -- gme_common_pvt.g_batch_status_check
4826: IF (l_mat_dtl_rec.line_type <> -1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return))
4827: OR (l_mat_dtl_rec.line_type <> 1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_prod_return))
4828: OR (l_mat_dtl_rec.line_type <> 2 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_completion, gme_common_pvt.g_byprod_return)) THEN
4829: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
4830: RAISE fnd_api.g_exc_error;

Line 4827: OR (l_mat_dtl_rec.line_type <> 1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_prod_return))

4823: END IF;
4824: END IF;
4825: END IF; -- gme_common_pvt.g_batch_status_check
4826: IF (l_mat_dtl_rec.line_type <> -1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return))
4827: OR (l_mat_dtl_rec.line_type <> 1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_prod_return))
4828: OR (l_mat_dtl_rec.line_type <> 2 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_completion, gme_common_pvt.g_byprod_return)) THEN
4829: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
4830: RAISE fnd_api.g_exc_error;
4831: END IF;

Line 4828: OR (l_mat_dtl_rec.line_type <> 2 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_completion, gme_common_pvt.g_byprod_return)) THEN

4824: END IF;
4825: END IF; -- gme_common_pvt.g_batch_status_check
4826: IF (l_mat_dtl_rec.line_type <> -1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return))
4827: OR (l_mat_dtl_rec.line_type <> 1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_prod_return))
4828: OR (l_mat_dtl_rec.line_type <> 2 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_completion, gme_common_pvt.g_byprod_return)) THEN
4829: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
4830: RAISE fnd_api.g_exc_error;
4831: END IF;
4832: -- get the item propertites

Line 4829: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');

4825: END IF; -- gme_common_pvt.g_batch_status_check
4826: IF (l_mat_dtl_rec.line_type <> -1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_ing_issue, gme_common_pvt.g_ing_return))
4827: OR (l_mat_dtl_rec.line_type <> 1 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_prod_completion, gme_common_pvt.g_prod_return))
4828: OR (l_mat_dtl_rec.line_type <> 2 AND p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_completion, gme_common_pvt.g_byprod_return)) THEN
4829: gme_common_pvt.log_message ('GME_LINE_TYPE_TXN_TYPE_DIFF');
4830: RAISE fnd_api.g_exc_error;
4831: END IF;
4832: -- get the item propertites
4833: OPEN cur_get_item_rec (p_mmti_rec.inventory_item_id, p_mmti_rec.organization_id);

Line 4837: gme_common_pvt.log_message ('PM_INVALID_ITEM');

4833: OPEN cur_get_item_rec (p_mmti_rec.inventory_item_id, p_mmti_rec.organization_id);
4834: FETCH cur_get_item_rec INTO l_item_rec;
4835: IF cur_get_item_rec%NOTFOUND THEN
4836: CLOSE cur_get_item_rec;
4837: gme_common_pvt.log_message ('PM_INVALID_ITEM');
4838: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4839: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
4840: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
4841: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));

Line 4852: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN

4848: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
4849: END IF;
4850:
4851: /* Bug 5358129 for ingredients lots should exist */
4852: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN
4853: FOR i IN 1..p_mmli_tbl.COUNT LOOP
4854: gme_transactions_pvt.validate_lot_for_ing(p_organization_id => p_mmti_rec.organization_id,
4855: p_inventory_item_id => p_mmti_rec.inventory_item_id,
4856: p_lot_number => p_mmli_tbl(i).lot_number,

Line 4864: IF p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_return, gme_common_pvt.g_prod_return, gme_common_pvt.g_ing_return) THEN

4860: END IF;
4861: END LOOP;
4862: END IF;
4863: -- if return transaction then check qty was issued and return not more than issued qty
4864: IF p_mmti_rec.transaction_type_id IN (gme_common_pvt.g_byprod_return, gme_common_pvt.g_prod_return, gme_common_pvt.g_ing_return) THEN
4865: IF (g_debug <= gme_debug.g_log_statement) THEN
4866: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);
4867: END IF;
4868: IF l_item_rec.lot_control_code = 1 THEN

Line 4885: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

4881: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);
4882: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4883: END IF;
4884: IF ABS (l_available_qty) < ABS (p_mmti_rec.transaction_quantity) THEN
4885: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
4886: RAISE fnd_api.g_exc_error;
4887: END IF;
4888: ELSE /* Lot Control */
4889: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

Line 4906: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

4902: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);
4903: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4904: END IF;
4905: IF ABS(l_available_qty) < ABS(p_mmli_tbl(i).transaction_quantity) THEN
4906: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
4907: RAISE fnd_api.g_exc_error;
4908: END IF;
4909: END LOOP;
4910: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */