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_DEBUG

Line 180: IF (g_debug <= gme_debug.g_log_statement) THEN

176: BEGIN
177: /* Initially let us assign the return status to success */
178: x_return_status := fnd_api.g_ret_sts_success;
179:
180: IF (g_debug <= gme_debug.g_log_statement) THEN
181: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
182: || 'Entering');
183: END IF;
184:

Line 181: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

177: /* Initially let us assign the return status to success */
178: x_return_status := fnd_api.g_ret_sts_success;
179:
180: IF (g_debug <= gme_debug.g_log_statement) THEN
181: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
182: || 'Entering');
183: END IF;
184:
185: l_mmti_rec := p_mmti_rec;

Line 196: IF (g_debug <= gme_debug.g_log_statement) THEN

192: ,x_material_detail => l_mat_dtl_rec) THEN
193: RAISE fnd_api.g_exc_error;
194: END IF;
195:
196: IF (g_debug <= gme_debug.g_log_statement) THEN
197: gme_debug.put_line ( g_pkg_name
198: || '.'
199: || l_api_name
200: || ':'

Line 197: gme_debug.put_line ( g_pkg_name

193: RAISE fnd_api.g_exc_error;
194: END IF;
195:
196: IF (g_debug <= gme_debug.g_log_statement) THEN
197: gme_debug.put_line ( g_pkg_name
198: || '.'
199: || l_api_name
200: || ':'
201: || 'material det_id'

Line 203: gme_debug.put_line ( g_pkg_name

199: || l_api_name
200: || ':'
201: || 'material det_id'
202: || l_mat_dtl_rec.material_detail_id);
203: gme_debug.put_line ( g_pkg_name
204: || '.'
205: || l_api_name
206: || ':'
207: || 'batch_id'

Line 212: IF (g_debug <= gme_debug.g_log_statement) THEN

208: || l_mat_dtl_rec.batch_id);
209: END IF;
210:
211: -- Start bug 9832061
212: IF (g_debug <= gme_debug.g_log_statement) THEN
213: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
214: || 'Before calling gme_common_pvt.check_close_period');
215: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
216: || 'l_mmti_rec.transaction_date = ' || to_char(l_mmti_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 213: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

209: END IF;
210:
211: -- Start bug 9832061
212: IF (g_debug <= gme_debug.g_log_statement) THEN
213: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
214: || 'Before calling gme_common_pvt.check_close_period');
215: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
216: || 'l_mmti_rec.transaction_date = ' || to_char(l_mmti_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
217:

Line 215: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

211: -- Start bug 9832061
212: IF (g_debug <= gme_debug.g_log_statement) THEN
213: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
214: || 'Before calling gme_common_pvt.check_close_period');
215: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
216: || 'l_mmti_rec.transaction_date = ' || to_char(l_mmti_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
217:
218: END IF;
219:

Line 227: IF (g_debug <= gme_debug.g_log_statement) THEN

223: IF NOT gme_common_pvt.check_close_period(p_org_id => l_mmti_rec.organization_id
224: ,p_trans_date => l_mmti_rec.transaction_date) THEN
225:
226: -- Let's default to timestamp and overwrite if the user entered a different date.
227: IF (g_debug <= gme_debug.g_log_statement) THEN
228: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning gme_common_pvt.g_timestamp to transaction date');
229: END IF;
230:
231: l_mmti_rec.transaction_date := gme_common_pvt.g_timestamp;

Line 228: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning gme_common_pvt.g_timestamp to transaction date');

224: ,p_trans_date => l_mmti_rec.transaction_date) THEN
225:
226: -- Let's default to timestamp and overwrite if the user entered a different date.
227: IF (g_debug <= gme_debug.g_log_statement) THEN
228: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning gme_common_pvt.g_timestamp to transaction date');
229: END IF;
230:
231: l_mmti_rec.transaction_date := gme_common_pvt.g_timestamp;
232:

Line 236: IF (g_debug <= gme_debug.g_log_statement) THEN

232:
233: -- bug 9832061
234: --IF l_trans_date IS NOT NULL AND l_trans_date <> l_mmt_rec.transaction_date THEN
235: IF l_trans_date IS NOT NULL AND l_trans_date > l_mmti_rec.transaction_date THEN
236: IF (g_debug <= gme_debug.g_log_statement) THEN
237: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning l_trans_date to transaction date');
238: END IF;
239: l_mmti_rec.transaction_date := l_trans_date;
240: END IF;

Line 237: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning l_trans_date to transaction date');

233: -- bug 9832061
234: --IF l_trans_date IS NOT NULL AND l_trans_date <> l_mmt_rec.transaction_date THEN
235: IF l_trans_date IS NOT NULL AND l_trans_date > l_mmti_rec.transaction_date THEN
236: IF (g_debug <= gme_debug.g_log_statement) THEN
237: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning l_trans_date to transaction date');
238: END IF;
239: l_mmti_rec.transaction_date := l_trans_date;
240: END IF;
241: END IF;

Line 245: IF (g_debug <= gme_debug.g_log_statement) THEN

241: END IF;
242: -- Bug 8605909 Ends
243:
244: -- bug 9832061
245: IF (g_debug <= gme_debug.g_log_statement) THEN
246: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
247: || 'Final l_mmt_rec.transaction_date = ' || to_char(l_mmti_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
248: END IF;
249: -- END bug 9832061

Line 246: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

242: -- Bug 8605909 Ends
243:
244: -- bug 9832061
245: IF (g_debug <= gme_debug.g_log_statement) THEN
246: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
247: || 'Final l_mmt_rec.transaction_date = ' || to_char(l_mmti_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
248: END IF;
249: -- END bug 9832061
250:

Line 269: IF (g_debug <= gme_debug.g_log_statement) THEN

265: RAISE build_txn_inter_err;
266: END IF;
267: l_assign_phantom := 0;
268:
269: IF (g_debug <= gme_debug.g_log_statement) THEN
270: gme_debug.put_line ( g_pkg_name
271: || '.'
272: || l_api_name
273: || ':'

Line 270: gme_debug.put_line ( g_pkg_name

266: END IF;
267: l_assign_phantom := 0;
268:
269: IF (g_debug <= gme_debug.g_log_statement) THEN
270: gme_debug.put_line ( g_pkg_name
271: || '.'
272: || l_api_name
273: || ':'
274: || 'status after build : '

Line 276: gme_debug.put_line ( g_pkg_name

272: || l_api_name
273: || ':'
274: || 'status after build : '
275: || l_return_status);
276: gme_debug.put_line ( g_pkg_name
277: || '.'
278: || l_api_name
279: || ':'
280: || 'x_mmti_rec.transaction_interface_id : '

Line 282: gme_debug.put_line ( g_pkg_name

278: || l_api_name
279: || ':'
280: || 'x_mmti_rec.transaction_interface_id : '
281: || x_mmti_rec.transaction_interface_id);
282: gme_debug.put_line ( g_pkg_name
283: || '.'
284: || l_api_name
285: || ':'
286: || 'x_mmti_rec.transaction_reference : '

Line 299: IF (g_debug <= gme_debug.g_log_statement) THEN

295: m_mmli_tbl := p_mmli_tbl;
296: m_mmti_rec.trx_source_line_id := l_mat_dtl_rec.phantom_line_id;
297: m_mat_dtl_rec.material_detail_id := m_mmti_rec.trx_source_line_id;
298:
299: IF (g_debug <= gme_debug.g_log_statement) THEN
300: gme_debug.put_line ( g_pkg_name
301: || '.'
302: || l_api_name
303: || ':'

Line 300: gme_debug.put_line ( g_pkg_name

296: m_mmti_rec.trx_source_line_id := l_mat_dtl_rec.phantom_line_id;
297: m_mat_dtl_rec.material_detail_id := m_mmti_rec.trx_source_line_id;
298:
299: IF (g_debug <= gme_debug.g_log_statement) THEN
300: gme_debug.put_line ( g_pkg_name
301: || '.'
302: || l_api_name
303: || ':'
304: || 'for phantom line id:'

Line 306: gme_debug.put_line ( g_pkg_name

302: || l_api_name
303: || ':'
304: || 'for phantom line id:'
305: || l_mat_dtl_rec.phantom_line_id);
306: gme_debug.put_line ( g_pkg_name
307: || '.'
308: || l_api_name
309: || ':'
310: || ' original transaction_type_id :'

Line 367: IF (g_debug <= gme_debug.g_log_statement) THEN

363: gme_common_pvt.g_byprod_comp_txn_action;
364: --(31)
365: END IF;
366:
367: IF (g_debug <= gme_debug.g_log_statement) THEN
368: gme_debug.put_line ( g_pkg_name
369: || '.'
370: || l_api_name
371: || ':'

Line 368: gme_debug.put_line ( g_pkg_name

364: --(31)
365: END IF;
366:
367: IF (g_debug <= gme_debug.g_log_statement) THEN
368: gme_debug.put_line ( g_pkg_name
369: || '.'
370: || l_api_name
371: || ':'
372: || 'calling build for phantom');

Line 373: gme_debug.put_line ( g_pkg_name

369: || '.'
370: || l_api_name
371: || ':'
372: || 'calling build for phantom');
373: gme_debug.put_line ( g_pkg_name
374: || '.'
375: || l_api_name
376: || ':'
377: || 'transaction_type_id for phantom :'

Line 379: gme_debug.put_line ( g_pkg_name

375: || l_api_name
376: || ':'
377: || 'transaction_type_id for phantom :'
378: || m_mmti_rec.transaction_type_id);
379: gme_debug.put_line ( g_pkg_name
380: || '.'
381: || l_api_name
382: || ':'
383: || 'transaction_action_id for phantom :'

Line 385: gme_debug.put_line ( g_pkg_name

381: || l_api_name
382: || ':'
383: || 'transaction_action_id for phantom :'
384: || m_mmti_rec.transaction_action_id);
385: gme_debug.put_line ( g_pkg_name
386: || '.'
387: || l_api_name
388: || ':'
389: || 'm_mat_dtl_rec.phantom_line_id :'

Line 391: gme_debug.put_line ( g_pkg_name

387: || l_api_name
388: || ':'
389: || 'm_mat_dtl_rec.phantom_line_id :'
390: || m_mat_dtl_rec.phantom_line_id);
391: gme_debug.put_line ( g_pkg_name
392: || '.'
393: || l_api_name
394: || ':'
395: || 'x_mmti_rec.transaction_interface_id :'

Line 397: gme_debug.put_line ( g_pkg_name

393: || l_api_name
394: || ':'
395: || 'x_mmti_rec.transaction_interface_id :'
396: || x_mmti_rec.transaction_interface_id);
397: gme_debug.put_line ( g_pkg_name
398: || '.'
399: || l_api_name
400: || ':'
401: || 'x_mmti_rec.transaction_reference :'

Line 425: IF (g_debug <= gme_debug.g_log_statement) THEN

421: IF l_return_status <> fnd_api.g_ret_sts_success THEN
422: RAISE build_txn_inter_err;
423: END IF;
424:
425: IF (g_debug <= gme_debug.g_log_statement) THEN
426: gme_debug.put_line ( g_pkg_name
427: || '.'
428: || l_api_name
429: || ':'

Line 426: gme_debug.put_line ( g_pkg_name

422: RAISE build_txn_inter_err;
423: END IF;
424:
425: IF (g_debug <= gme_debug.g_log_statement) THEN
426: gme_debug.put_line ( g_pkg_name
427: || '.'
428: || l_api_name
429: || ':'
430: || 'status from build for phantom '

Line 438: IF (g_debug <= gme_debug.g_log_statement) THEN

434: END IF; --p_phantom_trans <> 1 THEN
435:
436: -- code for moving the data to temp
437: IF gme_common_pvt.g_move_to_temp = fnd_api.g_true THEN
438: IF (g_debug <= gme_debug.g_log_statement) THEN
439: gme_debug.put_line ( g_pkg_name
440: || '.'
441: || l_api_name
442: || ':'

Line 439: gme_debug.put_line ( g_pkg_name

435:
436: -- code for moving the data to temp
437: IF gme_common_pvt.g_move_to_temp = fnd_api.g_true THEN
438: IF (g_debug <= gme_debug.g_log_statement) THEN
439: gme_debug.put_line ( g_pkg_name
440: || '.'
441: || l_api_name
442: || ':'
443: || 'calling validate transactions:'

Line 451: gme_debug.put_line ( g_pkg_name

447: select count(*)
448: into l_cnt_int
449: from mtl_transactions_interface
450: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
451: gme_debug.put_line ( g_pkg_name
452: || '.'
453: || l_api_name
454: || ':'
455: || 'count from interface table:'

Line 477: IF (g_debug <= gme_debug.g_log_statement) THEN

473: ,x_msg_count => l_msg_count
474: ,x_msg_data => l_msg_data
475: ,x_trans_count => l_txn_count
476: ,p_free_tree => fnd_api.g_false);
477: IF (g_debug <= gme_debug.g_log_statement) THEN
478: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
479: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
480: select count(*) into l_cnt_temp
481: from mtl_material_transactions_temp

Line 478: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);

474: ,x_msg_data => l_msg_data
475: ,x_trans_count => l_txn_count
476: ,p_free_tree => fnd_api.g_false);
477: IF (g_debug <= gme_debug.g_log_statement) THEN
478: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
479: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
480: select count(*) into l_cnt_temp
481: from mtl_material_transactions_temp
482: where transaction_header_id= gme_common_pvt.g_transaction_header_id;

Line 479: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);

475: ,x_trans_count => l_txn_count
476: ,p_free_tree => fnd_api.g_false);
477: IF (g_debug <= gme_debug.g_log_statement) THEN
478: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
479: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
480: select count(*) into l_cnt_temp
481: from mtl_material_transactions_temp
482: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
483: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);

Line 483: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);

479: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
480: select count(*) into l_cnt_temp
481: from mtl_material_transactions_temp
482: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
483: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
484: END IF;
485: IF l_ret < 0 THEN
486: IF (g_debug <= gme_debug.g_log_statement) THEN
487: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');

Line 486: IF (g_debug <= gme_debug.g_log_statement) THEN

482: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
483: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
484: END IF;
485: IF l_ret < 0 THEN
486: IF (g_debug <= gme_debug.g_log_statement) THEN
487: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');
488: END IF;
489: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
490: IF (l_msg_data IS NOT NULL) THEN

Line 487: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');

483: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
484: END IF;
485: IF l_ret < 0 THEN
486: IF (g_debug <= gme_debug.g_log_statement) THEN
487: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');
488: END IF;
489: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
490: IF (l_msg_data IS NOT NULL) THEN
491: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 491: IF (g_debug <= gme_debug.g_log_statement) THEN

487: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');
488: END IF;
489: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
490: IF (l_msg_data IS NOT NULL) THEN
491: IF (g_debug <= gme_debug.g_log_statement) THEN
492: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_msg_data is: '||l_msg_data);
493: END IF;
494: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
495: ,p_product_code => 'FND'

Line 492: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_msg_data is: '||l_msg_data);

488: END IF;
489: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
490: IF (l_msg_data IS NOT NULL) THEN
491: IF (g_debug <= gme_debug.g_log_statement) THEN
492: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_msg_data is: '||l_msg_data);
493: END IF;
494: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
495: ,p_product_code => 'FND'
496: ,p_token1_name => 'MESSAGE'

Line 503: IF (g_debug <= gme_debug.g_log_statement) THEN

499: /* Bug 5256543 Get messages from interface table and put on stack */
500: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface
501: WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id
502: AND error_explanation IS NOT NULL) LOOP
503: IF (g_debug <= gme_debug.g_log_statement) THEN
504: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);
505: END IF;
506: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
507: ,p_product_code => 'FND'

Line 504: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);

500: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface
501: WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id
502: AND error_explanation IS NOT NULL) LOOP
503: IF (g_debug <= gme_debug.g_log_statement) THEN
504: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);
505: END IF;
506: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
507: ,p_product_code => 'FND'
508: ,p_token1_name => 'MESSAGE'

Line 515: IF (g_debug <= gme_debug.g_log_statement) THEN

511: END IF;
512: RAISE fnd_api.g_exc_error;
513: END IF;
514: END IF;
515: IF (g_debug <= gme_debug.g_log_statement) THEN
516: gme_debug.put_line ( g_pkg_name
517: || '.'
518: || l_api_name
519: || ':'

Line 516: gme_debug.put_line ( g_pkg_name

512: RAISE fnd_api.g_exc_error;
513: END IF;
514: END IF;
515: IF (g_debug <= gme_debug.g_log_statement) THEN
516: gme_debug.put_line ( g_pkg_name
517: || '.'
518: || l_api_name
519: || ':'
520: || 'Exiting with '

Line 525: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'

521: || x_return_status);
522: END IF;
523: EXCEPTION
524: WHEN build_txn_inter_err THEN
525: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'
526: ||' error from build_txn_inter');
527: x_return_status := l_return_status;
528: WHEN fnd_api.g_exc_error THEN
529: x_return_status := fnd_api.g_ret_sts_error;

Line 536: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

532: WHEN OTHERS THEN
533: x_return_status := fnd_api.g_ret_sts_unexp_error;
534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
535:
536: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
537: gme_debug.put_line ( g_pkg_name
538: || '.'
539: || l_api_name
540: || ':'

Line 537: gme_debug.put_line ( g_pkg_name

533: x_return_status := fnd_api.g_ret_sts_unexp_error;
534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
535:
536: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
537: gme_debug.put_line ( g_pkg_name
538: || '.'
539: || l_api_name
540: || ':'
541: || 'WHEN OTHERS:'

Line 578: IF (g_debug <= gme_debug.g_log_statement) THEN

574: x_out_lpnno OUT NOCOPY VARCHAR2,
575: x_context OUT NOCOPY NUMBER) RETURN BOOLEAN AS
576:
577: BEGIN
578: IF (g_debug <= gme_debug.g_log_statement) THEN
579: gme_debug.put_line ( g_pkg_name
580: || '.'
581: || 'check_lpn_subinv_loc'
582: || ': '

Line 579: gme_debug.put_line ( g_pkg_name

575: x_context OUT NOCOPY NUMBER) RETURN BOOLEAN AS
576:
577: BEGIN
578: IF (g_debug <= gme_debug.g_log_statement) THEN
579: gme_debug.put_line ( g_pkg_name
580: || '.'
581: || 'check_lpn_subinv_loc'
582: || ': '
583: || 'Input data Lpn :'||p_lpn_id || 'Subinv :'|| p_in_subinv ||' Locator : ' || p_in_locid);

Line 597: IF (g_debug <= gme_debug.g_log_statement) THEN

593: x_out_lpnno
594: FROM WMS_LICENSE_PLATE_NUMBERS
595: WHERE lpn_id = p_lpn_id;
596:
597: IF (g_debug <= gme_debug.g_log_statement) THEN
598: gme_debug.put_line ( g_pkg_name
599: || '.'
600: || 'check_lpn_subinv_loc'
601: || ':'

Line 598: gme_debug.put_line ( g_pkg_name

594: FROM WMS_LICENSE_PLATE_NUMBERS
595: WHERE lpn_id = p_lpn_id;
596:
597: IF (g_debug <= gme_debug.g_log_statement) THEN
598: gme_debug.put_line ( g_pkg_name
599: || '.'
600: || 'check_lpn_subinv_loc'
601: || ':'
602: || 'Fecthed data Subinv : '|| x_out_subinv ||' Locator : ' || x_out_locId || ' Context : ' || x_context);

Line 618: IF (g_debug <= gme_debug.g_log_statement) THEN

614: x_out_locId <> p_in_locid OR
615: (p_in_locid IS NULL and x_out_locId IS NOT NULL) OR
616: (x_out_locId IS NULL and p_in_locid IS NOT NULL)
617: ) THEN
618: IF (g_debug <= gme_debug.g_log_statement) THEN
619: gme_debug.put_line ( g_pkg_name
620: || '.'
621: || 'check_lpn_subinv_loc'
622: || ':'

Line 619: gme_debug.put_line ( g_pkg_name

615: (p_in_locid IS NULL and x_out_locId IS NOT NULL) OR
616: (x_out_locId IS NULL and p_in_locid IS NOT NULL)
617: ) THEN
618: IF (g_debug <= gme_debug.g_log_statement) THEN
619: gme_debug.put_line ( g_pkg_name
620: || '.'
621: || 'check_lpn_subinv_loc'
622: || ':'
623: || 'Returning FALSE' );

Line 698: IF (g_debug <= gme_debug.g_log_statement) THEN

694: BEGIN
695: --Initially let us assign the return status to success
696: x_return_status := fnd_api.g_ret_sts_success;
697:
698: IF (g_debug <= gme_debug.g_log_statement) THEN
699: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
700: || 'Entering');
701: END IF;
702:

Line 699: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

695: --Initially let us assign the return status to success
696: x_return_status := fnd_api.g_ret_sts_success;
697:
698: IF (g_debug <= gme_debug.g_log_statement) THEN
699: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
700: || 'Entering');
701: END IF;
702:
703: l_mmti_rec := p_mmti_rec;

Line 715: IF (g_debug <= gme_debug.g_log_statement) THEN

711: RAISE invalid_line_type;
712: END IF;
713: CLOSE Cur_get_material_line_type;
714:
715: IF (g_debug <= gme_debug.g_log_statement) THEN
716: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'line type is '||l_line_type);
717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_lot_divisible is '||l_lot_divisible);
718: END IF;
719:

Line 716: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'line type is '||l_line_type);

712: END IF;
713: CLOSE Cur_get_material_line_type;
714:
715: IF (g_debug <= gme_debug.g_log_statement) THEN
716: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'line type is '||l_line_type);
717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_lot_divisible is '||l_lot_divisible);
718: END IF;
719:
720: -- Bug 9301755 - Call delete first only for ingredient lines since we want

Line 717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_lot_divisible is '||l_lot_divisible);

713: CLOSE Cur_get_material_line_type;
714:
715: IF (g_debug <= gme_debug.g_log_statement) THEN
716: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'line type is '||l_line_type);
717: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_lot_divisible is '||l_lot_divisible);
718: END IF;
719:
720: -- Bug 9301755 - Call delete first only for ingredient lines since we want
721: -- the inventory put back before we call create txn again. This ensures all

Line 728: IF (g_debug <= gme_debug.g_log_statement) THEN

724: -- Bug 9770408 - Evaluate non divisible flag also. This is needed for Yield corrections.
725: l_delete_done := 0;
726: IF l_line_type = gme_common_pvt.g_line_type_ing OR l_lot_divisible = 'N' THEN
727: -- call to delete all the transactions for this transaction_id
728: IF (g_debug <= gme_debug.g_log_statement) THEN
729: gme_debug.put_line
730: ( g_pkg_name
731: || '.'
732: || l_api_name

Line 729: gme_debug.put_line

725: l_delete_done := 0;
726: IF l_line_type = gme_common_pvt.g_line_type_ing OR l_lot_divisible = 'N' THEN
727: -- call to delete all the transactions for this transaction_id
728: IF (g_debug <= gme_debug.g_log_statement) THEN
729: gme_debug.put_line
730: ( g_pkg_name
731: || '.'
732: || l_api_name
733: || ':'

Line 744: IF (g_debug <= gme_debug.g_log_statement) THEN

740: ,p_trans_date => l_mmti_rec.transaction_date
741: ,x_return_status => l_return_status);
742:
743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
744: IF (g_debug <= gme_debug.g_log_statement) THEN
745: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
746: END IF;
747: RAISE delete_material_txn_err;
748: END IF;

Line 745: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

741: ,x_return_status => l_return_status);
742:
743: IF l_return_status <> fnd_api.g_ret_sts_success THEN
744: IF (g_debug <= gme_debug.g_log_statement) THEN
745: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
746: END IF;
747: RAISE delete_material_txn_err;
748: END IF;
749: l_delete_done := 1;

Line 752: IF (g_debug <= gme_debug.g_log_statement) THEN

748: END IF;
749: l_delete_done := 1;
750: END IF;
751:
752: IF (g_debug <= gme_debug.g_log_statement) THEN
753: gme_debug.put_line ( g_pkg_name
754: || '.'
755: || l_api_name
756: || ':'

Line 753: gme_debug.put_line ( g_pkg_name

749: l_delete_done := 1;
750: END IF;
751:
752: IF (g_debug <= gme_debug.g_log_statement) THEN
753: gme_debug.put_line ( g_pkg_name
754: || '.'
755: || l_api_name
756: || ':'
757: || 'calling create in update with :'

Line 780: IF (g_debug <= gme_debug.g_log_statement) THEN

776: -- Bug 9301755 - Call delete for non ingredient lines.
777: -- IF l_line_type <> gme_common_pvt.g_line_type_ing THEN
778: IF l_delete_done = 0 THEN
779: -- call to delete all the transactions for this transaction_id
780: IF (g_debug <= gme_debug.g_log_statement) THEN
781: gme_debug.put_line
782: ( g_pkg_name
783: || '.'
784: || l_api_name

Line 781: gme_debug.put_line

777: -- IF l_line_type <> gme_common_pvt.g_line_type_ing THEN
778: IF l_delete_done = 0 THEN
779: -- call to delete all the transactions for this transaction_id
780: IF (g_debug <= gme_debug.g_log_statement) THEN
781: gme_debug.put_line
782: ( g_pkg_name
783: || '.'
784: || l_api_name
785: || ':'

Line 796: IF (g_debug <= gme_debug.g_log_statement) THEN

792: ,p_trans_date => l_mmti_rec.transaction_date
793: ,x_return_status => l_return_status);
794:
795: IF l_return_status <> fnd_api.g_ret_sts_success THEN
796: IF (g_debug <= gme_debug.g_log_statement) THEN
797: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
798: END IF;
799: RAISE delete_material_txn_err;
800: END IF;

Line 797: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

793: ,x_return_status => l_return_status);
794:
795: IF l_return_status <> fnd_api.g_ret_sts_success THEN
796: IF (g_debug <= gme_debug.g_log_statement) THEN
797: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
798: END IF;
799: RAISE delete_material_txn_err;
800: END IF;
801: END IF;

Line 803: IF (g_debug <= gme_debug.g_log_statement) THEN

799: RAISE delete_material_txn_err;
800: END IF;
801: END IF;
802:
803: IF (g_debug <= gme_debug.g_log_statement) THEN
804: gme_debug.put_line ( g_pkg_name
805: || '.'
806: || l_api_name
807: || ':'

Line 804: gme_debug.put_line ( g_pkg_name

800: END IF;
801: END IF;
802:
803: IF (g_debug <= gme_debug.g_log_statement) THEN
804: gme_debug.put_line ( g_pkg_name
805: || '.'
806: || l_api_name
807: || ':'
808: || 'Exiting with '

Line 813: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error fetching line_type.');

809: || x_return_status);
810: END IF;
811: EXCEPTION
812: WHEN invalid_line_type THEN
813: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error fetching line_type.');
814: x_return_status := fnd_api.g_ret_sts_unexp_error ;
815:
816: WHEN delete_material_txn_err THEN
817: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

Line 817: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

813: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error fetching line_type.');
814: x_return_status := fnd_api.g_ret_sts_unexp_error ;
815:
816: WHEN delete_material_txn_err THEN
817: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
818: x_return_status := l_return_status ;
819:
820: WHEN create_material_txn_err THEN
821: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');

Line 821: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');

817: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
818: x_return_status := l_return_status ;
819:
820: WHEN create_material_txn_err THEN
821: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
822: x_return_status := l_return_status ;
823: WHEN fnd_api.g_exc_error THEN
824: x_return_status := fnd_api.g_ret_sts_error;
825: WHEN fnd_api.g_exc_unexpected_error THEN

Line 831: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

827: WHEN OTHERS THEN
828: x_return_status := fnd_api.g_ret_sts_unexp_error;
829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
830:
831: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
832: gme_debug.put_line ( g_pkg_name
833: || '.'
834: || l_api_name
835: || ':'

Line 832: gme_debug.put_line ( g_pkg_name

828: x_return_status := fnd_api.g_ret_sts_unexp_error;
829: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
830:
831: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
832: gme_debug.put_line ( g_pkg_name
833: || '.'
834: || l_api_name
835: || ':'
836: || 'WHEN OTHERS:'

Line 904: IF (g_debug <= gme_debug.g_log_statement) THEN

900: BEGIN
901: -- Initially let us assign the return status to success
902: x_return_status := fnd_api.g_ret_sts_success;
903:
904: IF (g_debug <= gme_debug.g_log_statement) THEN
905: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
906: || 'Entering');
907: END IF;
908:

Line 905: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

901: -- Initially let us assign the return status to success
902: x_return_status := fnd_api.g_ret_sts_success;
903:
904: IF (g_debug <= gme_debug.g_log_statement) THEN
905: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
906: || 'Entering');
907: END IF;
908:
909: l_mmt_rec := p_mmt_rec;

Line 914: IF (g_debug <= gme_debug.g_log_statement) THEN

910: l_mmln_tbl := p_mmln_tbl;
911: -- get the transaction_id from the mmt record for deleting it.
912: l_transaction_id := l_mmt_rec.transaction_id;
913:
914: IF (g_debug <= gme_debug.g_log_statement) THEN
915: gme_debug.put_line ( g_pkg_name
916: || '.'
917: || l_api_name
918: || ':'

Line 915: gme_debug.put_line ( g_pkg_name

911: -- get the transaction_id from the mmt record for deleting it.
912: l_transaction_id := l_mmt_rec.transaction_id;
913:
914: IF (g_debug <= gme_debug.g_log_statement) THEN
915: gme_debug.put_line ( g_pkg_name
916: || '.'
917: || l_api_name
918: || ':'
919: || 'calling construct from mmt to mmti :'

Line 931: IF (g_debug <= gme_debug.g_log_statement) THEN

927: ,x_mmli_tbl => l_mmli_tbl
928: ,x_return_status => l_return_status);
929:
930: IF l_return_status <> fnd_api.g_ret_sts_success THEN
931: IF (g_debug <= gme_debug.g_log_statement) THEN
932: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
933: END IF;
934: RAISE fnd_api.g_exc_error;
935: END IF;

Line 932: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');

928: ,x_return_status => l_return_status);
929:
930: IF l_return_status <> fnd_api.g_ret_sts_success THEN
931: IF (g_debug <= gme_debug.g_log_statement) THEN
932: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
933: END IF;
934: RAISE fnd_api.g_exc_error;
935: END IF;
936:

Line 946: IF (g_debug <= gme_debug.g_log_statement) THEN

942: RAISE invalid_line_type;
943: END IF;
944: CLOSE Cur_get_material_line_type;
945:
946: IF (g_debug <= gme_debug.g_log_statement) THEN
947: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'line type is '||l_line_type);
948: END IF;
949:
950: -- Bug 8639523 - Call delete first only for ingredient lines since we want

Line 947: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'line type is '||l_line_type);

943: END IF;
944: CLOSE Cur_get_material_line_type;
945:
946: IF (g_debug <= gme_debug.g_log_statement) THEN
947: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'line type is '||l_line_type);
948: END IF;
949:
950: -- Bug 8639523 - Call delete first only for ingredient lines since we want
951: -- the inventory put back before we call create txn again. This ensures all

Line 958: IF (g_debug <= gme_debug.g_log_statement) THEN

954: -- Bug 9770408 - Evaluate non divisible flag also. This is needed for Yield corrections.
955: l_delete_done := 0;
956: IF l_line_type = gme_common_pvt.g_line_type_ing OR l_lot_divisible = 'N' THEN
957: -- call to delete all the transactions for this transaction_id
958: IF (g_debug <= gme_debug.g_log_statement) THEN
959: gme_debug.put_line
960: ( g_pkg_name
961: || '.'
962: || l_api_name

Line 959: gme_debug.put_line

955: l_delete_done := 0;
956: IF l_line_type = gme_common_pvt.g_line_type_ing OR l_lot_divisible = 'N' THEN
957: -- call to delete all the transactions for this transaction_id
958: IF (g_debug <= gme_debug.g_log_statement) THEN
959: gme_debug.put_line
960: ( g_pkg_name
961: || '.'
962: || l_api_name
963: || ':'

Line 974: IF (g_debug <= gme_debug.g_log_statement) THEN

970: ,p_trans_date => l_mmt_rec.transaction_date
971: ,x_return_status => l_return_status);
972:
973: IF l_return_status <> fnd_api.g_ret_sts_success THEN
974: IF (g_debug <= gme_debug.g_log_statement) THEN
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
976: END IF;
977: RAISE delete_material_txn_err;
978: END IF;

Line 975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

971: ,x_return_status => l_return_status);
972:
973: IF l_return_status <> fnd_api.g_ret_sts_success THEN
974: IF (g_debug <= gme_debug.g_log_statement) THEN
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
976: END IF;
977: RAISE delete_material_txn_err;
978: END IF;
979: l_delete_done := 1;

Line 982: IF (g_debug <= gme_debug.g_log_statement) THEN

978: END IF;
979: l_delete_done := 1;
980: END IF;
981:
982: IF (g_debug <= gme_debug.g_log_statement) THEN
983: gme_debug.put_line ( g_pkg_name
984: || '.'
985: || l_api_name
986: || ':'

Line 983: gme_debug.put_line ( g_pkg_name

979: l_delete_done := 1;
980: END IF;
981:
982: IF (g_debug <= gme_debug.g_log_statement) THEN
983: gme_debug.put_line ( g_pkg_name
984: || '.'
985: || l_api_name
986: || ':'
987: || 'calling create trans with ='

Line 989: gme_debug.put_line ( g_pkg_name

985: || l_api_name
986: || ':'
987: || 'calling create trans with ='
988: || l_mmt_rec.transaction_id);
989: gme_debug.put_line ( g_pkg_name
990: || '.'
991: || l_api_name
992: || ':'
993: || 'calling create trans with ='

Line 1009: IF (g_debug <= gme_debug.g_log_statement) THEN

1005: ,p_mmli_tbl => l_mmli_tbl
1006: ,x_return_status => l_return_status);
1007:
1008: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1009: IF (g_debug <= gme_debug.g_log_statement) THEN
1010: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
1011: END IF;
1012: RAISE create_material_txn_err;
1013: END IF;

Line 1010: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');

1006: ,x_return_status => l_return_status);
1007:
1008: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1009: IF (g_debug <= gme_debug.g_log_statement) THEN
1010: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
1011: END IF;
1012: RAISE create_material_txn_err;
1013: END IF;
1014:

Line 1019: IF (g_debug <= gme_debug.g_log_statement) THEN

1015: -- Bug 8639523 - Call delete for non ingredient lines.
1016: -- IF l_line_type <> gme_common_pvt.g_line_type_ing THEN
1017: IF l_delete_done = 0 THEN
1018: -- call to delete all the transactions for this transaction_id
1019: IF (g_debug <= gme_debug.g_log_statement) THEN
1020: gme_debug.put_line
1021: ( g_pkg_name
1022: || '.'
1023: || l_api_name

Line 1020: gme_debug.put_line

1016: -- IF l_line_type <> gme_common_pvt.g_line_type_ing THEN
1017: IF l_delete_done = 0 THEN
1018: -- call to delete all the transactions for this transaction_id
1019: IF (g_debug <= gme_debug.g_log_statement) THEN
1020: gme_debug.put_line
1021: ( g_pkg_name
1022: || '.'
1023: || l_api_name
1024: || ':'

Line 1036: IF (g_debug <= gme_debug.g_log_statement) THEN

1032: ,p_trans_date => l_mmt_rec.transaction_date
1033: ,x_return_status => l_return_status);
1034:
1035: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1036: IF (g_debug <= gme_debug.g_log_statement) THEN
1037: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
1038: END IF;
1039: RAISE delete_material_txn_err;
1040: END IF;

Line 1037: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

1033: ,x_return_status => l_return_status);
1034:
1035: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1036: IF (g_debug <= gme_debug.g_log_statement) THEN
1037: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
1038: END IF;
1039: RAISE delete_material_txn_err;
1040: END IF;
1041: END IF;

Line 1043: IF (g_debug <= gme_debug.g_log_statement) THEN

1039: RAISE delete_material_txn_err;
1040: END IF;
1041: END IF;
1042:
1043: IF (g_debug <= gme_debug.g_log_statement) THEN
1044: gme_debug.put_line ( g_pkg_name
1045: || '.'
1046: || l_api_name
1047: || ':'

Line 1044: gme_debug.put_line ( g_pkg_name

1040: END IF;
1041: END IF;
1042:
1043: IF (g_debug <= gme_debug.g_log_statement) THEN
1044: gme_debug.put_line ( g_pkg_name
1045: || '.'
1046: || l_api_name
1047: || ':'
1048: || 'Exiting with '

Line 1054: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error fetching line_type.');

1050: END IF;
1051:
1052: EXCEPTION
1053: WHEN invalid_line_type THEN
1054: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error fetching line_type.');
1055: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1056: WHEN delete_material_txn_err THEN
1057: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
1058: x_return_status := l_return_status ;

Line 1057: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

1053: WHEN invalid_line_type THEN
1054: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error fetching line_type.');
1055: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1056: WHEN delete_material_txn_err THEN
1057: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
1058: x_return_status := l_return_status ;
1059: WHEN create_material_txn_err THEN
1060: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
1061: x_return_status := l_return_status ;

Line 1060: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');

1056: WHEN delete_material_txn_err THEN
1057: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
1058: x_return_status := l_return_status ;
1059: WHEN create_material_txn_err THEN
1060: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
1061: x_return_status := l_return_status ;
1062: WHEN fnd_api.g_exc_error THEN
1063: x_return_status := fnd_api.g_ret_sts_error;
1064: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1070: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

1066: WHEN OTHERS THEN
1067: x_return_status := fnd_api.g_ret_sts_unexp_error;
1068: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1069:
1070: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
1071: gme_debug.put_line ( g_pkg_name
1072: || '.'
1073: || l_api_name
1074: || ':'

Line 1071: gme_debug.put_line ( g_pkg_name

1067: x_return_status := fnd_api.g_ret_sts_unexp_error;
1068: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1069:
1070: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
1071: gme_debug.put_line ( g_pkg_name
1072: || '.'
1073: || l_api_name
1074: || ':'
1075: || 'WHEN OTHERS:'

Line 1131: IF (g_debug <= gme_debug.g_log_statement) THEN

1127: BEGIN
1128: -- Initially let us assign the return status to success
1129: x_return_status := fnd_api.g_ret_sts_success;
1130:
1131: IF (g_debug <= gme_debug.g_log_statement) THEN
1132: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1133: || 'Entering');
1134: END IF;
1135:

Line 1132: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1128: -- Initially let us assign the return status to success
1129: x_return_status := fnd_api.g_ret_sts_success;
1130:
1131: IF (g_debug <= gme_debug.g_log_statement) THEN
1132: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1133: || 'Entering');
1134: END IF;
1135:
1136: l_transaction_id := p_transaction_id;

Line 1140: IF (g_debug <= gme_debug.g_log_statement) THEN

1136: l_transaction_id := p_transaction_id;
1137: l_trans_date := p_trans_date;
1138:
1139: IF l_transaction_id IS NOT NULL THEN
1140: IF (g_debug <= gme_debug.g_log_statement) THEN
1141: gme_debug.put_line
1142: ( g_pkg_name
1143: || '.'
1144: || l_api_name

Line 1141: gme_debug.put_line

1137: l_trans_date := p_trans_date;
1138:
1139: IF l_transaction_id IS NOT NULL THEN
1140: IF (g_debug <= gme_debug.g_log_statement) THEN
1141: gme_debug.put_line
1142: ( g_pkg_name
1143: || '.'
1144: || l_api_name
1145: || ':'

Line 1156: IF (g_debug <= gme_debug.g_log_statement) THEN

1152: ,x_mmln_tbl => l_mmln_tbl
1153: ,x_return_status => l_return_status);
1154:
1155: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1156: IF (g_debug <= gme_debug.g_log_statement) THEN
1157: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
1158: END IF;
1159: RAISE get_trans_err;
1160: END IF;

Line 1157: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');

1153: ,x_return_status => l_return_status);
1154:
1155: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1156: IF (g_debug <= gme_debug.g_log_statement) THEN
1157: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
1158: END IF;
1159: RAISE get_trans_err;
1160: END IF;
1161:

Line 1163: IF (g_debug <= gme_debug.g_log_statement) THEN

1159: RAISE get_trans_err;
1160: END IF;
1161:
1162: -- bug 9832061
1163: IF (g_debug <= gme_debug.g_log_statement) THEN
1164: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1165: || 'Before calling gme_common_pvt.check_close_period');
1166: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1167: || 'l_mmt_rec.transaction_date = ' || to_char(l_mmt_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));

Line 1164: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1160: END IF;
1161:
1162: -- bug 9832061
1163: IF (g_debug <= gme_debug.g_log_statement) THEN
1164: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1165: || 'Before calling gme_common_pvt.check_close_period');
1166: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1167: || 'l_mmt_rec.transaction_date = ' || to_char(l_mmt_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
1168:

Line 1166: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1162: -- bug 9832061
1163: IF (g_debug <= gme_debug.g_log_statement) THEN
1164: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1165: || 'Before calling gme_common_pvt.check_close_period');
1166: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1167: || 'l_mmt_rec.transaction_date = ' || to_char(l_mmt_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
1168:
1169: IF l_trans_date IS NOT NULL THEN
1170: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

Line 1170: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1166: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1167: || 'l_mmt_rec.transaction_date = ' || to_char(l_mmt_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
1168:
1169: IF l_trans_date IS NOT NULL THEN
1170: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1171: || 'l_trans_date = ' || to_char(l_trans_date, 'DD-MON-YYYY HH24:MI:SS'));
1172: END IF;
1173: END IF;
1174:

Line 1180: IF (g_debug <= gme_debug.g_log_statement) THEN

1176: IF NOT gme_common_pvt.check_close_period(p_org_id => l_mmt_rec.organization_id
1177: ,p_trans_date => l_mmt_rec.transaction_date) THEN
1178:
1179: -- Let's default to timestamp and overwrite if the user entered a different date.
1180: IF (g_debug <= gme_debug.g_log_statement) THEN
1181: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning gme_common_pvt.g_timestamp to transaction date');
1182: END IF;
1183:
1184: l_mmt_rec.transaction_date := gme_common_pvt.g_timestamp;

Line 1181: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning gme_common_pvt.g_timestamp to transaction date');

1177: ,p_trans_date => l_mmt_rec.transaction_date) THEN
1178:
1179: -- Let's default to timestamp and overwrite if the user entered a different date.
1180: IF (g_debug <= gme_debug.g_log_statement) THEN
1181: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning gme_common_pvt.g_timestamp to transaction date');
1182: END IF;
1183:
1184: l_mmt_rec.transaction_date := gme_common_pvt.g_timestamp;
1185:

Line 1189: IF (g_debug <= gme_debug.g_log_statement) THEN

1185:
1186: -- bug 9832061
1187: --IF l_trans_date IS NOT NULL AND l_trans_date <> l_mmt_rec.transaction_date THEN
1188: IF l_trans_date IS NOT NULL AND l_trans_date > l_mmt_rec.transaction_date THEN
1189: IF (g_debug <= gme_debug.g_log_statement) THEN
1190: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning l_trans_date to transaction date');
1191: END IF;
1192: l_mmt_rec.transaction_date := l_trans_date;
1193: END IF;

Line 1190: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning l_trans_date to transaction date');

1186: -- bug 9832061
1187: --IF l_trans_date IS NOT NULL AND l_trans_date <> l_mmt_rec.transaction_date THEN
1188: IF l_trans_date IS NOT NULL AND l_trans_date > l_mmt_rec.transaction_date THEN
1189: IF (g_debug <= gme_debug.g_log_statement) THEN
1190: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Assigning l_trans_date to transaction date');
1191: END IF;
1192: l_mmt_rec.transaction_date := l_trans_date;
1193: END IF;
1194: END IF;

Line 1198: IF (g_debug <= gme_debug.g_log_statement) THEN

1194: END IF;
1195: -- Bug 8605909 Ends
1196:
1197: -- bug 9832061
1198: IF (g_debug <= gme_debug.g_log_statement) THEN
1199: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1200: || 'Final l_mmt_rec.transaction_date = ' || to_char(l_mmt_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
1201: END IF;
1202: END IF;

Line 1199: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1195: -- Bug 8605909 Ends
1196:
1197: -- bug 9832061
1198: IF (g_debug <= gme_debug.g_log_statement) THEN
1199: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1200: || 'Final l_mmt_rec.transaction_date = ' || to_char(l_mmt_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
1201: END IF;
1202: END IF;
1203:

Line 1204: IF (g_debug <= gme_debug.g_log_statement) THEN

1200: || 'Final l_mmt_rec.transaction_date = ' || to_char(l_mmt_rec.transaction_date, 'DD-MON-YYYY HH24:MI:SS'));
1201: END IF;
1202: END IF;
1203:
1204: IF (g_debug <= gme_debug.g_log_statement) THEN
1205: gme_debug.put_line ( g_pkg_name
1206: || '.'
1207: || l_api_name
1208: || ':'

Line 1205: gme_debug.put_line ( g_pkg_name

1201: END IF;
1202: END IF;
1203:
1204: IF (g_debug <= gme_debug.g_log_statement) THEN
1205: gme_debug.put_line ( g_pkg_name
1206: || '.'
1207: || l_api_name
1208: || ':'
1209: || 'calling construct from mmt to mmti :'

Line 1211: gme_debug.put_line ( g_pkg_name

1207: || l_api_name
1208: || ':'
1209: || 'calling construct from mmt to mmti :'
1210: || l_mmt_rec.transaction_id);
1211: gme_debug.put_line ( g_pkg_name
1212: || '.'
1213: || l_api_name
1214: || ':'
1215: || 'the mmt record source line id(null) ='

Line 1226: IF (g_debug <= gme_debug.g_log_statement) THEN

1222: ,x_mmli_tbl => l_mmli_tbl
1223: ,x_return_status => l_return_status);
1224:
1225: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1226: IF (g_debug <= gme_debug.g_log_statement) THEN
1227: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
1228: END IF;
1229: RAISE fnd_api.g_exc_error;
1230: END IF;

Line 1227: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');

1223: ,x_return_status => l_return_status);
1224:
1225: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1226: IF (g_debug <= gme_debug.g_log_statement) THEN
1227: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
1228: END IF;
1229: RAISE fnd_api.g_exc_error;
1230: END IF;
1231:

Line 1232: IF (g_debug <= gme_debug.g_log_statement) THEN

1228: END IF;
1229: RAISE fnd_api.g_exc_error;
1230: END IF;
1231:
1232: IF (g_debug <= gme_debug.g_log_statement) THEN
1233: gme_debug.put_line ( g_pkg_name
1234: || '.'
1235: || l_api_name
1236: || ':'

Line 1233: gme_debug.put_line ( g_pkg_name

1229: RAISE fnd_api.g_exc_error;
1230: END IF;
1231:
1232: IF (g_debug <= gme_debug.g_log_statement) THEN
1233: gme_debug.put_line ( g_pkg_name
1234: || '.'
1235: || l_api_name
1236: || ':'
1237: || 'getting material for '

Line 1245: IF (g_debug <= gme_debug.g_log_statement) THEN

1241: -- get the material details of the transaction
1242: l_mat_dtl_rec.material_detail_id := l_mmt_rec.trx_source_line_id;
1243:
1244: -- Now fetch the material details for the material
1245: IF (g_debug <= gme_debug.g_log_statement) THEN
1246: gme_debug.put_line ( g_pkg_name
1247: || '.'
1248: || l_api_name
1249: || ':'

Line 1246: gme_debug.put_line ( g_pkg_name

1242: l_mat_dtl_rec.material_detail_id := l_mmt_rec.trx_source_line_id;
1243:
1244: -- Now fetch the material details for the material
1245: IF (g_debug <= gme_debug.g_log_statement) THEN
1246: gme_debug.put_line ( g_pkg_name
1247: || '.'
1248: || l_api_name
1249: || ':'
1250: || 'getting material for '

Line 1307: IF (g_debug <= gme_debug.g_log_statement) THEN

1303: --(31)
1304: l_mmti_rec.transfer_lpn_id := l_mmt_rec.lpn_id;
1305: END IF;
1306:
1307: IF (g_debug <= gme_debug.g_log_statement) THEN
1308: gme_debug.put_line ( g_pkg_name
1309: || '.'
1310: || l_api_name
1311: || ':'

Line 1308: gme_debug.put_line ( g_pkg_name

1304: l_mmti_rec.transfer_lpn_id := l_mmt_rec.lpn_id;
1305: END IF;
1306:
1307: IF (g_debug <= gme_debug.g_log_statement) THEN
1308: gme_debug.put_line ( g_pkg_name
1309: || '.'
1310: || l_api_name
1311: || ':'
1312: || 'sending transaction_type_id:'

Line 1314: gme_debug.put_line ( g_pkg_name

1310: || l_api_name
1311: || ':'
1312: || 'sending transaction_type_id:'
1313: || l_mmti_rec.transaction_type_id);
1314: gme_debug.put_line ( g_pkg_name
1315: || '.'
1316: || l_api_name
1317: || ':'
1318: || 'sending transaction_action_id:'

Line 1324: gme_debug.put_line ( g_pkg_name

1320: END IF;
1321:
1322: -- set for delete transaction
1323: l_mmti_rec.source_line_id := l_mmt_rec.transaction_id;
1324: gme_debug.put_line ( g_pkg_name
1325: || '.'
1326: || l_api_name
1327: || ':'
1328: || 'calling create trans with ='

Line 1339: IF (g_debug <= gme_debug.g_log_statement) THEN

1335: created first */
1336: IF (l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_return OR
1337: l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return ) THEN
1338: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL AND p_txns_pair IS NULL THEN
1339: IF (g_debug <= gme_debug.g_log_statement) THEN
1340: gme_debug.put_line ( g_pkg_name
1341: || '.'
1342: || l_api_name
1343: || ':'

Line 1340: gme_debug.put_line ( g_pkg_name

1336: IF (l_mmti_rec.transaction_type_id = gme_common_pvt.g_prod_return OR
1337: l_mmti_rec.transaction_type_id = gme_common_pvt.g_byprod_return ) THEN
1338: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL AND p_txns_pair IS NULL THEN
1339: IF (g_debug <= gme_debug.g_log_statement) THEN
1340: gme_debug.put_line ( g_pkg_name
1341: || '.'
1342: || l_api_name
1343: || ':'
1344: || 'deleting for phantom:'

Line 1356: IF (g_debug <= gme_debug.g_log_statement) THEN

1352:
1353: CLOSE cur_get_ph_txns;
1354:
1355: IF m_transaction_id IS NOT NULL THEN
1356: IF (g_debug <= gme_debug.g_log_statement) THEN
1357: gme_debug.put_line ( g_pkg_name
1358: || '.'
1359: || l_api_name
1360: || ':'

Line 1357: gme_debug.put_line ( g_pkg_name

1353: CLOSE cur_get_ph_txns;
1354:
1355: IF m_transaction_id IS NOT NULL THEN
1356: IF (g_debug <= gme_debug.g_log_statement) THEN
1357: gme_debug.put_line ( g_pkg_name
1358: || '.'
1359: || l_api_name
1360: || ':'
1361: || 'calling delete txns for phantom:'

Line 1370: IF (g_debug <= gme_debug.g_log_statement) THEN

1366: ,p_txns_pair => 1
1367: ,p_trans_date => l_trans_date
1368: ,x_return_status => l_return_status);
1369: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1370: IF (g_debug <= gme_debug.g_log_statement) THEN
1371: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
1372: END IF;
1373: RAISE delete_material_txn_err;
1374: END IF; -- ret status

Line 1371: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');

1367: ,p_trans_date => l_trans_date
1368: ,x_return_status => l_return_status);
1369: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1370: IF (g_debug <= gme_debug.g_log_statement) THEN
1371: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
1372: END IF;
1373: RAISE delete_material_txn_err;
1374: END IF; -- ret status
1375: ELSE

Line 1376: IF (g_debug <= gme_debug.g_log_statement) THEN

1372: END IF;
1373: RAISE delete_material_txn_err;
1374: END IF; -- ret status
1375: ELSE
1376: IF (g_debug <= gme_debug.g_log_statement) THEN
1377: gme_debug.put_line ( g_pkg_name
1378: || '.'
1379: || l_api_name
1380: || ':'

Line 1377: gme_debug.put_line ( g_pkg_name

1373: RAISE delete_material_txn_err;
1374: END IF; -- ret status
1375: ELSE
1376: IF (g_debug <= gme_debug.g_log_statement) THEN
1377: gme_debug.put_line ( g_pkg_name
1378: || '.'
1379: || l_api_name
1380: || ':'
1381: || 'no phantom txns found for '

Line 1393: IF (g_debug <= gme_debug.g_log_statement) THEN

1389: -- Bug 9717803 - Move transaction pair update to happen before create of mat txn.
1390: -- Insert into gme_transactions_pairs table
1391: -- code need to added for INSERT INTO GME_TRANSACTION_PAIRS tables
1392: -- which column will carry the material detail ld
1393: IF (g_debug <= gme_debug.g_log_statement) THEN
1394: gme_debug.put_line ( g_pkg_name
1395: || '.'
1396: || l_api_name
1397: || ':'

Line 1394: gme_debug.put_line ( g_pkg_name

1390: -- Insert into gme_transactions_pairs table
1391: -- code need to added for INSERT INTO GME_TRANSACTION_PAIRS tables
1392: -- which column will carry the material detail ld
1393: IF (g_debug <= gme_debug.g_log_statement) THEN
1394: gme_debug.put_line ( g_pkg_name
1395: || '.'
1396: || l_api_name
1397: || ':'
1398: || 'inserting into pairs table transaction_id:'

Line 1400: gme_debug.put_line ( g_pkg_name

1396: || l_api_name
1397: || ':'
1398: || 'inserting into pairs table transaction_id:'
1399: || l_transaction_id);
1400: gme_debug.put_line ( g_pkg_name
1401: || '.'
1402: || l_api_name
1403: || ':'
1404: || 'inserting into pairs table batch_id:'

Line 1406: gme_debug.put_line

1402: || l_api_name
1403: || ':'
1404: || 'inserting into pairs table batch_id:'
1405: || l_mat_dtl_rec.batch_id);
1406: gme_debug.put_line
1407: ( g_pkg_name
1408: || '.'
1409: || l_api_name
1410: || ':'

Line 1413: gme_debug.put_line ( g_pkg_name

1409: || l_api_name
1410: || ':'
1411: || 'inserting into pairs table material_detail_id:'
1412: || l_mat_dtl_rec.material_detail_id);
1413: gme_debug.put_line ( g_pkg_name
1414: || '.'
1415: || l_api_name
1416: || ':'
1417: || 'inserting into pairs table pair_type:'

Line 1437: IF (g_debug <= gme_debug.g_log_statement) THEN

1433: ,p_phantom_trans => 1
1434: ,x_return_status => l_return_status);
1435:
1436: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1437: IF (g_debug <= gme_debug.g_log_statement) THEN
1438: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
1439: END IF;
1440: RAISE create_material_txn_err;
1441: END IF;

Line 1438: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');

1434: ,x_return_status => l_return_status);
1435:
1436: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1437: IF (g_debug <= gme_debug.g_log_statement) THEN
1438: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
1439: END IF;
1440: RAISE create_material_txn_err;
1441: END IF;
1442:

Line 1443: IF (g_debug <= gme_debug.g_log_statement) THEN

1439: END IF;
1440: RAISE create_material_txn_err;
1441: END IF;
1442:
1443: IF (g_debug <= gme_debug.g_log_statement) THEN
1444: gme_debug.put_line ( g_pkg_name
1445: || '.'
1446: || l_api_name
1447: || ':'

Line 1444: gme_debug.put_line ( g_pkg_name

1440: RAISE create_material_txn_err;
1441: END IF;
1442:
1443: IF (g_debug <= gme_debug.g_log_statement) THEN
1444: gme_debug.put_line ( g_pkg_name
1445: || '.'
1446: || l_api_name
1447: || ':'
1448: || 'status from create :'

Line 1459: IF (g_debug <= gme_debug.g_log_statement) THEN

1455: IF (l_mmti_rec.transaction_type_id <> gme_common_pvt.g_prod_return AND
1456: l_mmti_rec.transaction_type_id <> gme_common_pvt.g_byprod_return ) THEN
1457: -- changes for phantom
1458: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL AND p_txns_pair IS NULL THEN
1459: IF (g_debug <= gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ( g_pkg_name
1461: || '.'
1462: || l_api_name
1463: || ':'

Line 1460: gme_debug.put_line ( g_pkg_name

1456: l_mmti_rec.transaction_type_id <> gme_common_pvt.g_byprod_return ) THEN
1457: -- changes for phantom
1458: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL AND p_txns_pair IS NULL THEN
1459: IF (g_debug <= gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ( g_pkg_name
1461: || '.'
1462: || l_api_name
1463: || ':'
1464: || 'deleting for phantom:'

Line 1476: IF (g_debug <= gme_debug.g_log_statement) THEN

1472:
1473: CLOSE cur_get_ph_txns;
1474:
1475: IF m_transaction_id IS NOT NULL THEN
1476: IF (g_debug <= gme_debug.g_log_statement) THEN
1477: gme_debug.put_line ( g_pkg_name
1478: || '.'
1479: || l_api_name
1480: || ':'

Line 1477: gme_debug.put_line ( g_pkg_name

1473: CLOSE cur_get_ph_txns;
1474:
1475: IF m_transaction_id IS NOT NULL THEN
1476: IF (g_debug <= gme_debug.g_log_statement) THEN
1477: gme_debug.put_line ( g_pkg_name
1478: || '.'
1479: || l_api_name
1480: || ':'
1481: || 'calling delete txns for phantom:'

Line 1490: IF (g_debug <= gme_debug.g_log_statement) THEN

1486: ,p_txns_pair => 1
1487: ,p_trans_date => l_trans_date
1488: ,x_return_status => l_return_status);
1489: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1490: IF (g_debug <= gme_debug.g_log_statement) THEN
1491: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
1492: END IF;
1493: RAISE delete_material_txn_err;
1494: END IF; -- ret status

Line 1491: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');

1487: ,p_trans_date => l_trans_date
1488: ,x_return_status => l_return_status);
1489: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1490: IF (g_debug <= gme_debug.g_log_statement) THEN
1491: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
1492: END IF;
1493: RAISE delete_material_txn_err;
1494: END IF; -- ret status
1495: ELSE

Line 1496: IF (g_debug <= gme_debug.g_log_statement) THEN

1492: END IF;
1493: RAISE delete_material_txn_err;
1494: END IF; -- ret status
1495: ELSE
1496: IF (g_debug <= gme_debug.g_log_statement) THEN
1497: gme_debug.put_line ( g_pkg_name
1498: || '.'
1499: || l_api_name
1500: || ':'

Line 1497: gme_debug.put_line ( g_pkg_name

1493: RAISE delete_material_txn_err;
1494: END IF; -- ret status
1495: ELSE
1496: IF (g_debug <= gme_debug.g_log_statement) THEN
1497: gme_debug.put_line ( g_pkg_name
1498: || '.'
1499: || l_api_name
1500: || ':'
1501: || 'no phantom txns found for '

Line 1507: IF (g_debug <= gme_debug.g_log_statement) THEN

1503: END IF;
1504: END IF; -- m_transaction_id is not null
1505: END IF;
1506: END IF;
1507: IF (g_debug <= gme_debug.g_log_statement) THEN
1508: gme_debug.put_line ( g_pkg_name
1509: || '.'
1510: || l_api_name
1511: || ':'

Line 1508: gme_debug.put_line ( g_pkg_name

1504: END IF; -- m_transaction_id is not null
1505: END IF;
1506: END IF;
1507: IF (g_debug <= gme_debug.g_log_statement) THEN
1508: gme_debug.put_line ( g_pkg_name
1509: || '.'
1510: || l_api_name
1511: || ':'
1512: || 'Exiting with '

Line 1517: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');

1513: || x_return_status);
1514: END IF;
1515: EXCEPTION
1516: WHEN delete_material_txn_err THEN
1517: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
1518: x_return_status := l_return_status ;
1519: WHEN get_trans_err THEN
1520: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
1521: x_return_status := l_return_status ;

Line 1520: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');

1516: WHEN delete_material_txn_err THEN
1517: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
1518: x_return_status := l_return_status ;
1519: WHEN get_trans_err THEN
1520: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
1521: x_return_status := l_return_status ;
1522: WHEN create_material_txn_err THEN
1523: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
1524: x_return_status := l_return_status ;

Line 1523: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');

1519: WHEN get_trans_err THEN
1520: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
1521: x_return_status := l_return_status ;
1522: WHEN create_material_txn_err THEN
1523: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
1524: x_return_status := l_return_status ;
1525: WHEN fnd_api.g_exc_error THEN
1526: x_return_status := fnd_api.g_ret_sts_error;
1527: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1528: IF (g_debug <= gme_debug.g_log_statement) THEN

1524: x_return_status := l_return_status ;
1525: WHEN fnd_api.g_exc_error THEN
1526: x_return_status := fnd_api.g_ret_sts_error;
1527: WHEN fnd_api.g_exc_unexpected_error THEN
1528: IF (g_debug <= gme_debug.g_log_statement) THEN
1529: gme_debug.put_line ( g_pkg_name
1530: || '.'
1531: || l_api_name
1532: || ':'

Line 1529: gme_debug.put_line ( g_pkg_name

1525: WHEN fnd_api.g_exc_error THEN
1526: x_return_status := fnd_api.g_ret_sts_error;
1527: WHEN fnd_api.g_exc_unexpected_error THEN
1528: IF (g_debug <= gme_debug.g_log_statement) THEN
1529: gme_debug.put_line ( g_pkg_name
1530: || '.'
1531: || l_api_name
1532: || ':'
1533: || 'Unexpected');

Line 1541: IF (g_debug <= gme_debug.g_log_statement) THEN

1537: WHEN OTHERS THEN
1538: x_return_status := fnd_api.g_ret_sts_unexp_error;
1539: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1540:
1541: IF (g_debug <= gme_debug.g_log_statement) THEN
1542: gme_debug.put_line ( g_pkg_name
1543: || '.'
1544: || l_api_name
1545: || ':'

Line 1542: gme_debug.put_line ( g_pkg_name

1538: x_return_status := fnd_api.g_ret_sts_unexp_error;
1539: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1540:
1541: IF (g_debug <= gme_debug.g_log_statement) THEN
1542: gme_debug.put_line ( g_pkg_name
1543: || '.'
1544: || l_api_name
1545: || ':'
1546: || 'WHEN OTHERS:'

Line 1622: IF (g_debug <= gme_debug.g_log_statement) THEN

1618: BEGIN
1619: -- Initially let us assign the return status to success
1620: x_return_status := fnd_api.g_ret_sts_success;
1621:
1622: IF (g_debug <= gme_debug.g_log_statement) THEN
1623: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1624: || 'Entering');
1625: END IF;
1626:

Line 1623: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1619: -- Initially let us assign the return status to success
1620: x_return_status := fnd_api.g_ret_sts_success;
1621:
1622: IF (g_debug <= gme_debug.g_log_statement) THEN
1623: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1624: || 'Entering');
1625: END IF;
1626:
1627: l_mmti_rec := p_mmti_rec;

Line 1642: IF (g_debug <= gme_debug.g_log_statement) THEN

1638: ,x_return_status => l_return_status
1639: ,p_insert_hdr => l_insert_hdr);
1640:
1641: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1642: IF (g_debug <= gme_debug.g_log_statement) THEN
1643: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build inter hdr');
1644: END IF;
1645: RAISE build_txn_inter_err;
1646: END IF;

Line 1643: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build inter hdr');

1639: ,p_insert_hdr => l_insert_hdr);
1640:
1641: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1642: IF (g_debug <= gme_debug.g_log_statement) THEN
1643: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build inter hdr');
1644: END IF;
1645: RAISE build_txn_inter_err;
1646: END IF;
1647:

Line 1648: IF (g_debug <= gme_debug.g_log_statement) THEN

1644: END IF;
1645: RAISE build_txn_inter_err;
1646: END IF;
1647:
1648: IF (g_debug <= gme_debug.g_log_statement) THEN
1649: gme_debug.put_line ( g_pkg_name
1650: || '.'
1651: || l_api_name
1652: || ':'

Line 1649: gme_debug.put_line ( g_pkg_name

1645: RAISE build_txn_inter_err;
1646: END IF;
1647:
1648: IF (g_debug <= gme_debug.g_log_statement) THEN
1649: gme_debug.put_line ( g_pkg_name
1650: || '.'
1651: || l_api_name
1652: || ':'
1653: || 'after header- inserting lot');

Line 1654: gme_debug.put_line ( g_pkg_name

1650: || '.'
1651: || l_api_name
1652: || ':'
1653: || 'after header- inserting lot');
1654: gme_debug.put_line ( g_pkg_name
1655: || '.'
1656: || l_api_name
1657: || ':'
1658: || 'after header- inter_id:'

Line 1660: gme_debug.put_line ( g_pkg_name

1656: || l_api_name
1657: || ':'
1658: || 'after header- inter_id:'
1659: || x_mmti_rec.transaction_interface_id);
1660: gme_debug.put_line ( g_pkg_name
1661: || '.'
1662: || l_api_name
1663: || ':'
1664: || 'after header- header_id:'

Line 1666: gme_debug.put_line ( g_pkg_name

1662: || l_api_name
1663: || ':'
1664: || 'after header- header_id:'
1665: || x_mmti_rec.transaction_header_id);
1666: gme_debug.put_line ( g_pkg_name
1667: || '.'
1668: || l_api_name
1669: || ':'
1670: || 'after header- trasn_type:'

Line 1676: IF (g_debug <= gme_debug.g_log_statement) THEN

1672: END IF;
1673:
1674: IF (l_mmli_tbl.COUNT > 0) THEN
1675: FOR i IN 1 .. l_mmli_tbl.COUNT LOOP
1676: IF (g_debug <= gme_debug.g_log_statement) THEN
1677: gme_debug.put_line ( g_pkg_name
1678: || '.'
1679: || l_api_name
1680: || ':'

Line 1677: gme_debug.put_line ( g_pkg_name

1673:
1674: IF (l_mmli_tbl.COUNT > 0) THEN
1675: FOR i IN 1 .. l_mmli_tbl.COUNT LOOP
1676: IF (g_debug <= gme_debug.g_log_statement) THEN
1677: gme_debug.put_line ( g_pkg_name
1678: || '.'
1679: || l_api_name
1680: || ':'
1681: || 'lot_number '

Line 1683: gme_debug.put_line ( g_pkg_name

1679: || l_api_name
1680: || ':'
1681: || 'lot_number '
1682: || l_mmli_tbl (i).lot_number);
1683: gme_debug.put_line ( g_pkg_name
1684: || '.'
1685: || l_api_name
1686: || ':'
1687: || 'transaction_quantity '

Line 1722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1718: ,from_name => NULL
1719: ,to_name => NULL);
1720:
1721: IF l_prim_qty = -99999 THEN
1722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1723: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1724: END IF;
1725: RAISE um_convert_error;
1726: END IF;

Line 1723: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');

1719: ,to_name => NULL);
1720:
1721: IF l_prim_qty = -99999 THEN
1722: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1723: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1724: END IF;
1725: RAISE um_convert_error;
1726: END IF;
1727:

Line 1728: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1724: END IF;
1725: RAISE um_convert_error;
1726: END IF;
1727:
1728: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1729: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_prim_qty= '||to_char(l_prim_qty));
1731: END IF;
1732: END IF;

Line 1729: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');

1725: RAISE um_convert_error;
1726: END IF;
1727:
1728: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1729: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_prim_qty= '||to_char(l_prim_qty));
1731: END IF;
1732: END IF;
1733: l_mmli_tbl(i).primary_quantity := l_prim_qty;

Line 1730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_prim_qty= '||to_char(l_prim_qty));

1726: END IF;
1727:
1728: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1729: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_prim_qty= '||to_char(l_prim_qty));
1731: END IF;
1732: END IF;
1733: l_mmli_tbl(i).primary_quantity := l_prim_qty;
1734: END IF;

Line 1753: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1749: ,from_name => NULL
1750: ,to_name => NULL);
1751:
1752: IF l_secondary_qty = -99999 THEN
1753: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1754: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1755: END IF;
1756: RAISE um_convert_error;
1757: END IF;

Line 1754: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');

1750: ,to_name => NULL);
1751:
1752: IF l_secondary_qty = -99999 THEN
1753: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1754: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1755: END IF;
1756: RAISE um_convert_error;
1757: END IF;
1758:

Line 1759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1755: END IF;
1756: RAISE um_convert_error;
1757: END IF;
1758:
1759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1760: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1761: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_secondary_qty= '||to_char(l_secondary_qty));
1762: END IF;
1763: END IF;

Line 1760: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');

1756: RAISE um_convert_error;
1757: END IF;
1758:
1759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1760: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1761: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_secondary_qty= '||to_char(l_secondary_qty));
1762: END IF;
1763: END IF;
1764: l_mmli_tbl(i).secondary_transaction_quantity := l_secondary_qty;

Line 1761: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_secondary_qty= '||to_char(l_secondary_qty));

1757: END IF;
1758:
1759: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1760: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1761: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_secondary_qty= '||to_char(l_secondary_qty));
1762: END IF;
1763: END IF;
1764: l_mmli_tbl(i).secondary_transaction_quantity := l_secondary_qty;
1765: END IF;

Line 1780: IF (g_debug <= gme_debug.g_log_statement) THEN

1776: ,x_mmli_rec => x_mmli_tbl (i)
1777: ,x_return_status => l_return_status);
1778:
1779: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1780: IF (g_debug <= gme_debug.g_log_statement) THEN
1781: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build lot inter');
1782: END IF;
1783: RAISE build_txn_inter_lot_err;
1784: END IF;

Line 1781: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build lot inter');

1777: ,x_return_status => l_return_status);
1778:
1779: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1780: IF (g_debug <= gme_debug.g_log_statement) THEN
1781: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build lot inter');
1782: END IF;
1783: RAISE build_txn_inter_lot_err;
1784: END IF;
1785:

Line 1806: IF (g_debug <= gme_debug.g_log_statement) THEN

1802: RAISE insert_hdr_err;
1803: END IF;
1804: END IF;
1805:
1806: IF (g_debug <= gme_debug.g_log_statement) THEN
1807: gme_debug.put_line ( g_pkg_name
1808: || '.'
1809: || l_api_name
1810: || ':'

Line 1807: gme_debug.put_line ( g_pkg_name

1803: END IF;
1804: END IF;
1805:
1806: IF (g_debug <= gme_debug.g_log_statement) THEN
1807: gme_debug.put_line ( g_pkg_name
1808: || '.'
1809: || l_api_name
1810: || ':'
1811: || 'Exiting with '

Line 1816: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'insert_hdr_err');

1812: || x_return_status);
1813: END IF;
1814: EXCEPTION
1815: WHEN insert_hdr_err THEN
1816: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'insert_hdr_err');
1817: x_return_status := l_return_status;
1818: WHEN um_convert_error THEN
1819: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1820: fnd_message.set_token ('ITEM_NO', l_item_no);

Line 1826: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'lot_expired_err');

1822: fnd_message.set_token ('TO_UOM', l_primary_uom);
1823: fnd_msg_pub.ADD;
1824: x_return_status := FND_API.g_ret_sts_error;
1825: WHEN lot_expired_err THEN
1826: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'lot_expired_err');
1827: x_return_status := 'T';
1828: WHEN build_txn_inter_lot_err THEN
1829: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_lot_err');
1830: x_return_status := l_return_status;

Line 1829: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_lot_err');

1825: WHEN lot_expired_err THEN
1826: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'lot_expired_err');
1827: x_return_status := 'T';
1828: WHEN build_txn_inter_lot_err THEN
1829: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_lot_err');
1830: x_return_status := l_return_status;
1831: WHEN build_txn_inter_err THEN
1832: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_err');
1833: x_return_status := l_return_status;

Line 1832: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_err');

1828: WHEN build_txn_inter_lot_err THEN
1829: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_lot_err');
1830: x_return_status := l_return_status;
1831: WHEN build_txn_inter_err THEN
1832: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_err');
1833: x_return_status := l_return_status;
1834: WHEN fnd_api.g_exc_error THEN
1835: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'user defined error');
1836: x_return_status := fnd_api.g_ret_sts_error;

Line 1835: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'user defined error');

1831: WHEN build_txn_inter_err THEN
1832: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_err');
1833: x_return_status := l_return_status;
1834: WHEN fnd_api.g_exc_error THEN
1835: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'user defined error');
1836: x_return_status := fnd_api.g_ret_sts_error;
1837: WHEN fnd_api.g_exc_unexpected_error THEN
1838: gme_debug.put_line ( g_pkg_name
1839: || '.'

Line 1838: gme_debug.put_line ( g_pkg_name

1834: WHEN fnd_api.g_exc_error THEN
1835: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'user defined error');
1836: x_return_status := fnd_api.g_ret_sts_error;
1837: WHEN fnd_api.g_exc_unexpected_error THEN
1838: gme_debug.put_line ( g_pkg_name
1839: || '.'
1840: || l_api_name
1841: || ':'
1842: || 'unexp'

Line 1849: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

1845: WHEN OTHERS THEN
1846: x_return_status := fnd_api.g_ret_sts_unexp_error;
1847: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1848:
1849: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1850: gme_debug.put_line ( g_pkg_name
1851: || '.'
1852: || l_api_name
1853: || ':'

Line 1850: gme_debug.put_line ( g_pkg_name

1846: x_return_status := fnd_api.g_ret_sts_unexp_error;
1847: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1848:
1849: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1850: gme_debug.put_line ( g_pkg_name
1851: || '.'
1852: || l_api_name
1853: || ':'
1854: || 'WHEN OTHERS:'

Line 1906: IF (g_debug <= gme_debug.g_log_statement) THEN

1902: BEGIN
1903: -- Initially let us assign the return status to success
1904: x_return_status := fnd_api.g_ret_sts_success;
1905:
1906: IF (g_debug <= gme_debug.g_log_statement) THEN
1907: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1908: || 'Entering');
1909: END IF;
1910:

Line 1907: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

1903: -- Initially let us assign the return status to success
1904: x_return_status := fnd_api.g_ret_sts_success;
1905:
1906: IF (g_debug <= gme_debug.g_log_statement) THEN
1907: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1908: || 'Entering');
1909: END IF;
1910:
1911: l_mmti_rec := p_mmti_rec;

Line 1918: IF (g_debug <= gme_debug.g_log_statement) THEN

1914: SELECT mtl_material_transactions_s.NEXTVAL
1915: INTO gme_common_pvt.g_transaction_header_id
1916: FROM DUAL;
1917:
1918: IF (g_debug <= gme_debug.g_log_statement) THEN
1919: gme_debug.put_line ( g_pkg_name
1920: || '.'
1921: || l_api_name
1922: || ':'

Line 1919: gme_debug.put_line ( g_pkg_name

1915: INTO gme_common_pvt.g_transaction_header_id
1916: FROM DUAL;
1917:
1918: IF (g_debug <= gme_debug.g_log_statement) THEN
1919: gme_debug.put_line ( g_pkg_name
1920: || '.'
1921: || l_api_name
1922: || ':'
1923: || 'GME_COMMON_PVT.g_transaction_header_id '

Line 1931: IF (g_debug <= gme_debug.g_log_statement) THEN

1927:
1928: l_mmti_rec.transaction_header_id :=
1929: gme_common_pvt.g_transaction_header_id;
1930:
1931: IF (g_debug <= gme_debug.g_log_statement) THEN
1932: gme_debug.put_line ( g_pkg_name
1933: || '.'
1934: || l_api_name
1935: || ':'

Line 1932: gme_debug.put_line ( g_pkg_name

1928: l_mmti_rec.transaction_header_id :=
1929: gme_common_pvt.g_transaction_header_id;
1930:
1931: IF (g_debug <= gme_debug.g_log_statement) THEN
1932: gme_debug.put_line ( g_pkg_name
1933: || '.'
1934: || l_api_name
1935: || ':'
1936: || 'l_mmti_rec.transaction_header_id '

Line 1983: IF (g_debug <= gme_debug.g_log_statement) THEN

1979: ,p_locator_id => l_mmti_rec.locator_id
1980: ,p_lot_number => NULL
1981: ,p_serial_number => NULL
1982: ,p_object_type => 'A') = 'N') THEN
1983: IF (g_debug <= gme_debug.g_log_statement) THEN
1984: gme_debug.put_line ( g_pkg_name
1985: || '.'
1986: || l_api_name
1987: || ':'

Line 1984: gme_debug.put_line ( g_pkg_name

1980: ,p_lot_number => NULL
1981: ,p_serial_number => NULL
1982: ,p_object_type => 'A') = 'N') THEN
1983: IF (g_debug <= gme_debug.g_log_statement) THEN
1984: gme_debug.put_line ( g_pkg_name
1985: || '.'
1986: || l_api_name
1987: || ':'
1988: || 'material status check not valid for item '

Line 1994: IF (g_debug <= gme_debug.g_log_statement) THEN

1990: END IF;
1991: RAISE material_status_err;
1992: END IF; /* inv_material_status_grp.is_status_applicable */
1993: -- for a phantom transaction- asssign value to transaction_refernece
1994: IF (g_debug <= gme_debug.g_log_statement) THEN
1995: gme_debug.put_line ( g_pkg_name
1996: || '.'
1997: || l_api_name
1998: || 'Material Status is VALID');

Line 1995: gme_debug.put_line ( g_pkg_name

1991: RAISE material_status_err;
1992: END IF; /* inv_material_status_grp.is_status_applicable */
1993: -- for a phantom transaction- asssign value to transaction_refernece
1994: IF (g_debug <= gme_debug.g_log_statement) THEN
1995: gme_debug.put_line ( g_pkg_name
1996: || '.'
1997: || l_api_name
1998: || 'Material Status is VALID');
1999: gme_debug.put_line ( g_pkg_name

Line 1999: gme_debug.put_line ( g_pkg_name

1995: gme_debug.put_line ( g_pkg_name
1996: || '.'
1997: || l_api_name
1998: || 'Material Status is VALID');
1999: gme_debug.put_line ( g_pkg_name
2000: || '.'
2001: || l_api_name
2002: || 'p_assign_phantom: '
2003: || p_assign_phantom);

Line 2011: IF (g_debug <= gme_debug.g_log_statement) THEN

2007: l_mmti_rec.transaction_reference :=
2008: (l_mmti_rec.transaction_interface_id);
2009: END IF;
2010:
2011: IF (g_debug <= gme_debug.g_log_statement) THEN
2012: gme_debug.put_line ( g_pkg_name
2013: || '.'
2014: || l_api_name
2015: || ':'

Line 2012: gme_debug.put_line ( g_pkg_name

2008: (l_mmti_rec.transaction_interface_id);
2009: END IF;
2010:
2011: IF (g_debug <= gme_debug.g_log_statement) THEN
2012: gme_debug.put_line ( g_pkg_name
2013: || '.'
2014: || l_api_name
2015: || ':'
2016: || 'transaction_interface_id: '

Line 2018: gme_debug.put_line ( g_pkg_name

2014: || l_api_name
2015: || ':'
2016: || 'transaction_interface_id: '
2017: || l_mmti_rec.transaction_interface_id);
2018: gme_debug.put_line ( g_pkg_name
2019: || '.'
2020: || l_api_name
2021: || ':'
2022: || 'transaction_source_id: '

Line 2024: gme_debug.put_line ( g_pkg_name

2020: || l_api_name
2021: || ':'
2022: || 'transaction_source_id: '
2023: || l_mmti_rec.transaction_source_id);
2024: gme_debug.put_line ( g_pkg_name
2025: || '.'
2026: || l_api_name
2027: || ':'
2028: || 'transaction_type_id: '

Line 2030: gme_debug.put_line ( g_pkg_name

2026: || l_api_name
2027: || ':'
2028: || 'transaction_type_id: '
2029: || l_mmti_rec.transaction_type_id);
2030: gme_debug.put_line ( g_pkg_name
2031: || '.'
2032: || l_api_name
2033: || ':'
2034: || 'transaction_source_type_id: '

Line 2036: gme_debug.put_line ( g_pkg_name

2032: || l_api_name
2033: || ':'
2034: || 'transaction_source_type_id: '
2035: || l_mmti_rec.transaction_source_type_id);
2036: gme_debug.put_line ( g_pkg_name
2037: || '.'
2038: || l_api_name
2039: || ':'
2040: || 'transaction_quantity: '

Line 2042: gme_debug.put_line ( g_pkg_name

2038: || l_api_name
2039: || ':'
2040: || 'transaction_quantity: '
2041: || l_mmti_rec.transaction_quantity);
2042: gme_debug.put_line ( g_pkg_name
2043: || '.'
2044: || l_api_name
2045: || ':'
2046: || 'transaction_uom: '

Line 2048: gme_debug.put_line ( g_pkg_name

2044: || l_api_name
2045: || ':'
2046: || 'transaction_uom: '
2047: || l_mmti_rec.transaction_uom);
2048: gme_debug.put_line ( g_pkg_name
2049: || '.'
2050: || l_api_name
2051: || ':'
2052: || 'secondary_transaction_quantity: '

Line 2054: gme_debug.put_line ( g_pkg_name

2050: || l_api_name
2051: || ':'
2052: || 'secondary_transaction_quantity: '
2053: || l_mmti_rec.secondary_transaction_quantity);
2054: gme_debug.put_line ( g_pkg_name
2055: || '.'
2056: || l_api_name
2057: || ':'
2058: || 'secondary_uom_code: '

Line 2060: gme_debug.put_line ( g_pkg_name

2056: || l_api_name
2057: || ':'
2058: || 'secondary_uom_code: '
2059: || l_mmti_rec.secondary_uom_code);
2060: gme_debug.put_line ( g_pkg_name
2061: || '.'
2062: || l_api_name
2063: || ':'
2064: || 'primary_quantity: '

Line 2066: gme_debug.put_line ( g_pkg_name

2062: || l_api_name
2063: || ':'
2064: || 'primary_quantity: '
2065: || l_mmti_rec.primary_quantity);
2066: gme_debug.put_line ( g_pkg_name
2067: || '.'
2068: || l_api_name
2069: || ':'
2070: || 'process_flag: '

Line 2072: gme_debug.put_line ( g_pkg_name

2068: || l_api_name
2069: || ':'
2070: || 'process_flag: '
2071: || l_mmti_rec.process_flag);
2072: gme_debug.put_line ( g_pkg_name
2073: || '.'
2074: || l_api_name
2075: || ':'
2076: || 'inventory_item_id: '

Line 2078: gme_debug.put_line ( g_pkg_name

2074: || l_api_name
2075: || ':'
2076: || 'inventory_item_id: '
2077: || l_mmti_rec.inventory_item_id);
2078: gme_debug.put_line ( g_pkg_name
2079: || '.'
2080: || l_api_name
2081: || ':'
2082: || 'revision: '

Line 2084: gme_debug.put_line ( g_pkg_name

2080: || l_api_name
2081: || ':'
2082: || 'revision: '
2083: || l_mmti_rec.revision);
2084: gme_debug.put_line ( g_pkg_name
2085: || '.'
2086: || l_api_name
2087: || ':'
2088: || 'transfer_lpn_id: '

Line 2090: gme_debug.put_line ( g_pkg_name

2086: || l_api_name
2087: || ':'
2088: || 'transfer_lpn_id: '
2089: || l_mmti_rec.transfer_lpn_id);
2090: gme_debug.put_line ( g_pkg_name
2091: || '.'
2092: || l_api_name
2093: || ':'
2094: || 'organization_id: '

Line 2096: gme_debug.put_line ( g_pkg_name

2092: || l_api_name
2093: || ':'
2094: || 'organization_id: '
2095: || l_mmti_rec.organization_id);
2096: gme_debug.put_line ( g_pkg_name
2097: || '.'
2098: || l_api_name
2099: || ':'
2100: || 'subinventory_code: '

Line 2102: gme_debug.put_line ( g_pkg_name

2098: || l_api_name
2099: || ':'
2100: || 'subinventory_code: '
2101: || TO_CHAR (l_mmti_rec.subinventory_code) );
2102: gme_debug.put_line ( g_pkg_name
2103: || '.'
2104: || l_api_name
2105: || ':'
2106: || 'locator_id:'

Line 2108: gme_debug.put_line ( g_pkg_name

2104: || l_api_name
2105: || ':'
2106: || 'locator_id:'
2107: || l_mmti_rec.locator_id);
2108: gme_debug.put_line ( g_pkg_name
2109: || '.'
2110: || l_api_name
2111: || ':'
2112: || 'source_line_id: '

Line 2114: gme_debug.put_line ( g_pkg_name

2110: || l_api_name
2111: || ':'
2112: || 'source_line_id: '
2113: || l_mmti_rec.source_line_id);
2114: gme_debug.put_line ( g_pkg_name
2115: || '.'
2116: || l_api_name
2117: || ':'
2118: || 'trx_source_line_id: '

Line 2120: gme_debug.put_line ( g_pkg_name

2116: || l_api_name
2117: || ':'
2118: || 'trx_source_line_id: '
2119: || l_mmti_rec.trx_source_line_id);
2120: gme_debug.put_line ( g_pkg_name
2121: || '.'
2122: || l_api_name
2123: || ':'
2124: || 'source_header_id: '

Line 2126: gme_debug.put_line ( g_pkg_name

2122: || l_api_name
2123: || ':'
2124: || 'source_header_id: '
2125: || l_mmti_rec.source_header_id);
2126: gme_debug.put_line ( g_pkg_name
2127: || '.'
2128: || l_api_name
2129: || ':'
2130: || 'transaction_source_name: '

Line 2132: gme_debug.put_line ( g_pkg_name

2128: || l_api_name
2129: || ':'
2130: || 'transaction_source_name: '
2131: || l_mmti_rec.transaction_source_name);
2132: gme_debug.put_line ( g_pkg_name
2133: || '.'
2134: || l_api_name
2135: || ':'
2136: || 'transaction_mode: '

Line 2138: gme_debug.put_line ( g_pkg_name

2134: || l_api_name
2135: || ':'
2136: || 'transaction_mode: '
2137: || l_mmti_rec.transaction_mode);
2138: gme_debug.put_line ( g_pkg_name
2139: || '.'
2140: || l_api_name
2141: || ':'
2142: || 'last_updated_by: '

Line 2144: gme_debug.put_line ( g_pkg_name

2140: || l_api_name
2141: || ':'
2142: || 'last_updated_by: '
2143: || gme_common_pvt.g_user_ident);
2144: gme_debug.put_line ( g_pkg_name
2145: || '.'
2146: || l_api_name
2147: || ':'
2148: || 'transaction_reference: '

Line 2150: gme_debug.put_line ( g_pkg_name

2146: || l_api_name
2147: || ':'
2148: || 'transaction_reference: '
2149: || l_mmti_rec.transaction_reference);
2150: gme_debug.put_line ( g_pkg_name
2151: || '.'
2152: || l_api_name
2153: || ':'
2154: || 'transaction_batch_id: '

Line 2156: gme_debug.put_line ( g_pkg_name

2152: || l_api_name
2153: || ':'
2154: || 'transaction_batch_id: '
2155: || l_mmti_rec.transaction_batch_id);
2156: gme_debug.put_line ( g_pkg_name
2157: || '.'
2158: || l_api_name
2159: || ':'
2160: || 'transaction_batch_seq: '

Line 2162: gme_debug.put_line ( g_pkg_name

2158: || l_api_name
2159: || ':'
2160: || 'transaction_batch_seq: '
2161: || l_mmti_rec.transaction_batch_seq);
2162: gme_debug.put_line ( g_pkg_name
2163: || '.'
2164: || l_api_name
2165: || ':'
2166: || 'reservation_quantity: '

Line 2168: gme_debug.put_line ( g_pkg_name

2164: || l_api_name
2165: || ':'
2166: || 'reservation_quantity: '
2167: || l_mmti_rec.reservation_quantity);
2168: gme_debug.put_line ( g_pkg_name
2169: || '.'
2170: || l_api_name
2171: || ':'
2172: || 'transaction_sequence_id: '

Line 2174: gme_debug.put_line ( g_pkg_name

2170: || l_api_name
2171: || ':'
2172: || 'transaction_sequence_id: '
2173: || l_mmti_rec.transaction_sequence_id);
2174: gme_debug.put_line ( g_pkg_name
2175: || '.'
2176: || l_api_name
2177: || ':'
2178: || 'reason_id: '

Line 2180: gme_debug.put_line ( g_pkg_name

2176: || l_api_name
2177: || ':'
2178: || 'reason_id: '
2179: || l_mmti_rec.reason_id);
2180: gme_debug.put_line ( g_pkg_name
2181: || '.'
2182: || l_api_name
2183: || ':'
2184: || 'transfer_lpn_id: '

Line 2186: gme_debug.put_line ( g_pkg_name

2182: || l_api_name
2183: || ':'
2184: || 'transfer_lpn_id: '
2185: || l_mmti_rec.transfer_lpn_id);
2186: gme_debug.put_line ( g_pkg_name
2187: || '.'
2188: || l_api_name
2189: || ':'
2190: || 'transaction_date: '

Line 2203: IF (g_debug <= gme_debug.g_log_statement) THEN

2199: END IF;
2200: END IF;
2201: x_mmti_rec := l_mmti_rec;
2202:
2203: IF (g_debug <= gme_debug.g_log_statement) THEN
2204: gme_debug.put_line ( g_pkg_name
2205: || '.'
2206: || l_api_name
2207: || ':'

Line 2204: gme_debug.put_line ( g_pkg_name

2200: END IF;
2201: x_mmti_rec := l_mmti_rec;
2202:
2203: IF (g_debug <= gme_debug.g_log_statement) THEN
2204: gme_debug.put_line ( g_pkg_name
2205: || '.'
2206: || l_api_name
2207: || ':'
2208: || 'after inserting header with status:'||x_return_status);

Line 2237: gme_debug.put_line ( g_pkg_name

2233: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB'
2234: ,'TRANSTYPE',l_type,'ITEM',l_item
2235: ,'SUBINV',l_mmti_rec.subinventory_code);
2236: END IF;
2237: gme_debug.put_line ( g_pkg_name
2238: || '.'
2239: || l_api_name
2240: || ':'
2241: || 'material status invalid for item, subinventory, locator etc'

Line 2245: gme_debug.put_line ( g_pkg_name

2241: || 'material status invalid for item, subinventory, locator etc'
2242: );
2243: x_return_status := 'T';
2244: WHEN fnd_api.g_exc_unexpected_error THEN
2245: gme_debug.put_line ( g_pkg_name
2246: || '.'
2247: || l_api_name
2248: || ':'
2249: || 'unexp'

Line 2256: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

2252: WHEN OTHERS THEN
2253: x_return_status := fnd_api.g_ret_sts_unexp_error;
2254: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2255:
2256: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2257: gme_debug.put_line ( g_pkg_name
2258: || '.'
2259: || l_api_name
2260: || ':'

Line 2257: gme_debug.put_line ( g_pkg_name

2253: x_return_status := fnd_api.g_ret_sts_unexp_error;
2254: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2255:
2256: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2257: gme_debug.put_line ( g_pkg_name
2258: || '.'
2259: || l_api_name
2260: || ':'
2261: || 'WHEN OTHERS:'

Line 2318: IF (g_debug <= gme_debug.g_log_statement) THEN

2314: material_status_err EXCEPTION;
2315: BEGIN
2316: x_return_status := fnd_api.g_ret_sts_success;
2317:
2318: IF (g_debug <= gme_debug.g_log_statement) THEN
2319: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2320: || 'Entering');
2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);
2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);

Line 2319: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

2315: BEGIN
2316: x_return_status := fnd_api.g_ret_sts_success;
2317:
2318: IF (g_debug <= gme_debug.g_log_statement) THEN
2319: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2320: || 'Entering');
2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);
2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);
2323: gme_debug.put_line ('p_subinventory_code is '||p_subinventory_code);

Line 2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);

2317:
2318: IF (g_debug <= gme_debug.g_log_statement) THEN
2319: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2320: || 'Entering');
2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);
2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);
2323: gme_debug.put_line ('p_subinventory_code is '||p_subinventory_code);
2324: gme_debug.put_line ('p_locator_id is '||p_locator_id);
2325: gme_debug.put_line ('p_lpn_id is '||p_lpn_id);

Line 2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);

2318: IF (g_debug <= gme_debug.g_log_statement) THEN
2319: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2320: || 'Entering');
2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);
2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);
2323: gme_debug.put_line ('p_subinventory_code is '||p_subinventory_code);
2324: gme_debug.put_line ('p_locator_id is '||p_locator_id);
2325: gme_debug.put_line ('p_lpn_id is '||p_lpn_id);
2326: END IF;

Line 2323: gme_debug.put_line ('p_subinventory_code is '||p_subinventory_code);

2319: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2320: || 'Entering');
2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);
2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);
2323: gme_debug.put_line ('p_subinventory_code is '||p_subinventory_code);
2324: gme_debug.put_line ('p_locator_id is '||p_locator_id);
2325: gme_debug.put_line ('p_lpn_id is '||p_lpn_id);
2326: END IF;
2327:

Line 2324: gme_debug.put_line ('p_locator_id is '||p_locator_id);

2320: || 'Entering');
2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);
2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);
2323: gme_debug.put_line ('p_subinventory_code is '||p_subinventory_code);
2324: gme_debug.put_line ('p_locator_id is '||p_locator_id);
2325: gme_debug.put_line ('p_lpn_id is '||p_lpn_id);
2326: END IF;
2327:
2328: l_mmli_rec := p_mmli_rec;

Line 2325: gme_debug.put_line ('p_lpn_id is '||p_lpn_id);

2321: gme_debug.put_line ('p_transaction_type_id is '||p_transaction_type_id);
2322: gme_debug.put_line ('p_inventory_item_id is '||p_inventory_item_id);
2323: gme_debug.put_line ('p_subinventory_code is '||p_subinventory_code);
2324: gme_debug.put_line ('p_locator_id is '||p_locator_id);
2325: gme_debug.put_line ('p_lpn_id is '||p_lpn_id);
2326: END IF;
2327:
2328: l_mmli_rec := p_mmli_rec;
2329: l_mmli_rec.transaction_interface_id := p_trans_inter_id;

Line 2363: IF (g_debug <= gme_debug.g_log_statement) THEN

2359: ,p_lot_number => l_mmli_rec.lot_number
2360: ,p_serial_number => NULL
2361: ,p_lpn_id => p_lpn_id
2362: ,p_object_type => 'A') = 'N') THEN
2363: IF (g_debug <= gme_debug.g_log_statement) THEN
2364: gme_debug.put_line ( g_pkg_name
2365: || '.'
2366: || l_api_name
2367: || ':'

Line 2364: gme_debug.put_line ( g_pkg_name

2360: ,p_serial_number => NULL
2361: ,p_lpn_id => p_lpn_id
2362: ,p_object_type => 'A') = 'N') THEN
2363: IF (g_debug <= gme_debug.g_log_statement) THEN
2364: gme_debug.put_line ( g_pkg_name
2365: || '.'
2366: || l_api_name
2367: || ':'
2368: || 'material status check is NOT valid for lot '

Line 2374: IF (g_debug <= gme_debug.g_log_statement) THEN

2370: END IF;
2371: RAISE material_status_err;
2372: END IF; /* inv_material_status_grp.is_status_applicable */
2373:
2374: IF (g_debug <= gme_debug.g_log_statement) THEN
2375: gme_debug.put_line ( g_pkg_name
2376: || '.'
2377: || l_api_name
2378: || ':'

Line 2375: gme_debug.put_line ( g_pkg_name

2371: RAISE material_status_err;
2372: END IF; /* inv_material_status_grp.is_status_applicable */
2373:
2374: IF (g_debug <= gme_debug.g_log_statement) THEN
2375: gme_debug.put_line ( g_pkg_name
2376: || '.'
2377: || l_api_name
2378: || ':'
2379: || 'Material Status is VALID for lot '

Line 2381: gme_debug.put_line ( g_pkg_name

2377: || l_api_name
2378: || ':'
2379: || 'Material Status is VALID for lot '
2380: || l_mmli_rec.lot_number);
2381: gme_debug.put_line ( g_pkg_name
2382: || '.'
2383: || l_api_name
2384: || ':'
2385: || 'lot_qty is '

Line 2530: IF (g_debug <= gme_debug.g_log_statement) THEN

2526: ,l_mmli_rec.n_attribute10);
2527:
2528: x_mmli_rec := l_mmli_rec;
2529:
2530: IF (g_debug <= gme_debug.g_log_statement) THEN
2531: gme_debug.put_line ( g_pkg_name
2532: || '.'
2533: || l_api_name
2534: || ':'

Line 2531: gme_debug.put_line ( g_pkg_name

2527:
2528: x_mmli_rec := l_mmli_rec;
2529:
2530: IF (g_debug <= gme_debug.g_log_statement) THEN
2531: gme_debug.put_line ( g_pkg_name
2532: || '.'
2533: || l_api_name
2534: || ':'
2535: || 'Exiting with '

Line 2552: gme_debug.put_line ( g_pkg_name

2548: WHERE transaction_type_id = p_transaction_type_id;
2549: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_LOT'
2550: ,'TRANSTYPE',l_type,'ITEM',l_item
2551: ,'LOT',l_mmli_rec.lot_number);
2552: gme_debug.put_line ( g_pkg_name
2553: || '.'
2554: || l_api_name
2555: || ':'
2556: || 'material status invalid for item, subinventory, locator etc');

Line 2559: gme_debug.put_line ( g_pkg_name

2555: || ':'
2556: || 'material status invalid for item, subinventory, locator etc');
2557: x_return_status := 'T';
2558: WHEN fnd_api.g_exc_error THEN
2559: gme_debug.put_line ( g_pkg_name
2560: || '.'
2561: || l_api_name
2562: || ':'
2563: || 'WHEN exe'

Line 2567: gme_debug.put_line ( g_pkg_name

2563: || 'WHEN exe'
2564: || SQLERRM);
2565: x_return_status := fnd_api.g_ret_sts_error;
2566: WHEN fnd_api.g_exc_unexpected_error THEN
2567: gme_debug.put_line ( g_pkg_name
2568: || '.'
2569: || l_api_name
2570: || ':'
2571: || 'unexp'

Line 2578: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

2574: WHEN OTHERS THEN
2575: x_return_status := fnd_api.g_ret_sts_unexp_error;
2576: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2577:
2578: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2579: gme_debug.put_line ( g_pkg_name
2580: || '.'
2581: || l_api_name
2582: || ':'

Line 2579: gme_debug.put_line ( g_pkg_name

2575: x_return_status := fnd_api.g_ret_sts_unexp_error;
2576: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2577:
2578: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2579: gme_debug.put_line ( g_pkg_name
2580: || '.'
2581: || l_api_name
2582: || ':'
2583: || 'WHEN OTHERS:'

Line 2646: IF (g_debug <= gme_debug.g_log_statement) THEN

2642:
2643: BEGIN
2644: x_return_status := fnd_api.g_ret_sts_success;
2645:
2646: IF (g_debug <= gme_debug.g_log_statement) THEN
2647: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2648: || 'Entering with transaction '||p_transaction_id);
2649: END IF;
2650:

Line 2647: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

2643: BEGIN
2644: x_return_status := fnd_api.g_ret_sts_success;
2645:
2646: IF (g_debug <= gme_debug.g_log_statement) THEN
2647: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2648: || 'Entering with transaction '||p_transaction_id);
2649: END IF;
2650:
2651: IF p_transaction_id IS NULL THEN

Line 2654: IF (g_debug <= gme_debug.g_log_statement) THEN

2650:
2651: IF p_transaction_id IS NULL THEN
2652: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
2653:
2654: IF (g_debug <= gme_debug.g_log_statement) THEN
2655: gme_debug.put_line ( g_pkg_name
2656: || '.'
2657: || l_api_name
2658: || ':'

Line 2655: gme_debug.put_line ( g_pkg_name

2651: IF p_transaction_id IS NULL THEN
2652: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
2653:
2654: IF (g_debug <= gme_debug.g_log_statement) THEN
2655: gme_debug.put_line ( g_pkg_name
2656: || '.'
2657: || l_api_name
2658: || ':'
2659: || 'TRANSACTION ID NEEDED FOR RETRIEVAL');

Line 2669: IF (g_debug <= gme_debug.g_log_statement) THEN

2665: OPEN cur_get_transaction (l_transaction_id, gme_common_pvt.g_pairs_reversal_type);
2666: FETCH cur_get_transaction
2667: INTO x_mmt_rec;
2668: IF cur_get_transaction%FOUND THEN
2669: IF (g_debug <= gme_debug.g_log_statement) THEN
2670: gme_debug.put_line ( g_pkg_name
2671: || '.'
2672: || l_api_name
2673: || ':'

Line 2670: gme_debug.put_line ( g_pkg_name

2666: FETCH cur_get_transaction
2667: INTO x_mmt_rec;
2668: IF cur_get_transaction%FOUND THEN
2669: IF (g_debug <= gme_debug.g_log_statement) THEN
2670: gme_debug.put_line ( g_pkg_name
2671: || '.'
2672: || l_api_name
2673: || ':'
2674: || 'TRANSACTIONS found for '

Line 2682: IF (g_debug <= gme_debug.g_log_statement) THEN

2678: ,x_mmln_tbl => x_mmln_tbl
2679: ,x_return_status => l_return_status);
2680:
2681: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2682: IF (g_debug <= gme_debug.g_log_statement) THEN
2683: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2684: || 'error from get lot trans');
2685: END IF;
2686: RAISE fnd_api.g_exc_error;

Line 2683: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

2679: ,x_return_status => l_return_status);
2680:
2681: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2682: IF (g_debug <= gme_debug.g_log_statement) THEN
2683: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2684: || 'error from get lot trans');
2685: END IF;
2686: RAISE fnd_api.g_exc_error;
2687: END IF;

Line 2695: IF (g_debug <= gme_debug.g_log_statement) THEN

2691: RAISE fnd_api.g_exc_error;
2692: END IF;
2693: CLOSE cur_get_transaction;
2694:
2695: IF (g_debug <= gme_debug.g_log_statement) THEN
2696: gme_debug.put_line ( g_pkg_name
2697: || '.'
2698: || l_api_name
2699: || ':'

Line 2696: gme_debug.put_line ( g_pkg_name

2692: END IF;
2693: CLOSE cur_get_transaction;
2694:
2695: IF (g_debug <= gme_debug.g_log_statement) THEN
2696: gme_debug.put_line ( g_pkg_name
2697: || '.'
2698: || l_api_name
2699: || ':'
2700: || 'TRANSACTION '

Line 2704: IF (g_debug <= gme_debug.g_log_statement) THEN

2700: || 'TRANSACTION '
2701: || x_mmt_rec.transaction_id);
2702: END IF;
2703:
2704: IF (g_debug <= gme_debug.g_log_statement) THEN
2705: gme_debug.put_line ( g_pkg_name
2706: || '.'
2707: || l_api_name
2708: || ':'

Line 2705: gme_debug.put_line ( g_pkg_name

2701: || x_mmt_rec.transaction_id);
2702: END IF;
2703:
2704: IF (g_debug <= gme_debug.g_log_statement) THEN
2705: gme_debug.put_line ( g_pkg_name
2706: || '.'
2707: || l_api_name
2708: || ':'
2709: || 'Exiting with '

Line 2721: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2717: WHEN OTHERS THEN
2718: x_return_status := fnd_api.g_ret_sts_unexp_error;
2719: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2720:
2721: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2722: gme_debug.put_line ( g_pkg_name
2723: || '.'
2724: || l_api_name
2725: || ':'

Line 2722: gme_debug.put_line ( g_pkg_name

2718: x_return_status := fnd_api.g_ret_sts_unexp_error;
2719: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2720:
2721: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2722: gme_debug.put_line ( g_pkg_name
2723: || '.'
2724: || l_api_name
2725: || ':'
2726: || 'WHEN OTHERS:'

Line 2766: IF (g_debug <= gme_debug.g_log_statement) THEN

2762: BEGIN
2763: -- Initially let us assign the return status to success
2764: x_return_status := fnd_api.g_ret_sts_success;
2765:
2766: IF (g_debug <= gme_debug.g_log_statement) THEN
2767: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2768: || 'Entering');
2769: END IF;
2770:

Line 2767: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

2763: -- Initially let us assign the return status to success
2764: x_return_status := fnd_api.g_ret_sts_success;
2765:
2766: IF (g_debug <= gme_debug.g_log_statement) THEN
2767: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2768: || 'Entering');
2769: END IF;
2770:
2771: l_mmt_rec := p_mmt_rec;

Line 2826: IF (g_debug <= gme_debug.g_log_statement) THEN

2822: l_mmln_tbl (i).secondary_transaction_quantity;
2823: END LOOP;
2824: END IF; --l_mmln_tbl.count
2825:
2826: IF (g_debug <= gme_debug.g_log_statement) THEN
2827: gme_debug.put_line ( g_pkg_name
2828: || '.'
2829: || l_api_name
2830: || ':'

Line 2827: gme_debug.put_line ( g_pkg_name

2823: END LOOP;
2824: END IF; --l_mmln_tbl.count
2825:
2826: IF (g_debug <= gme_debug.g_log_statement) THEN
2827: gme_debug.put_line ( g_pkg_name
2828: || '.'
2829: || l_api_name
2830: || ':'
2831: || 'Exiting with '

Line 2843: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2839: WHEN OTHERS THEN
2840: x_return_status := fnd_api.g_ret_sts_unexp_error;
2841: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2842:
2843: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2844: gme_debug.put_line ( g_pkg_name
2845: || '.'
2846: || l_api_name
2847: || ':'

Line 2844: gme_debug.put_line ( g_pkg_name

2840: x_return_status := fnd_api.g_ret_sts_unexp_error;
2841: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2842:
2843: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2844: gme_debug.put_line ( g_pkg_name
2845: || '.'
2846: || l_api_name
2847: || ':'
2848: || 'WHEN OTHERS:'

Line 2950: IF (g_debug <= gme_debug.g_log_statement) THEN

2946: BEGIN
2947: -- Initially let us assign the return status to success
2948: x_return_status := fnd_api.g_ret_sts_success;
2949:
2950: IF (g_debug <= gme_debug.g_log_statement) THEN
2951: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2952: || 'Entering with mat/batch '||p_mat_det_id||'/'||p_batch_id);
2953: END IF;
2954:

Line 2951: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

2947: -- Initially let us assign the return status to success
2948: x_return_status := fnd_api.g_ret_sts_success;
2949:
2950: IF (g_debug <= gme_debug.g_log_statement) THEN
2951: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2952: || 'Entering with mat/batch '||p_mat_det_id||'/'||p_batch_id);
2953: END IF;
2954:
2955: IF p_mat_det_id IS NOT NULL AND p_batch_id IS NOT NULL THEN

Line 2975: IF (g_debug <= gme_debug.g_log_statement) THEN

2971: BULK COLLECT INTO x_mmt_tbl;
2972: CLOSE cur_get_trans;
2973: END IF;
2974: END IF;
2975: IF (g_debug <= gme_debug.g_log_statement) THEN
2976: gme_debug.put_line ( g_pkg_name
2977: || '.'
2978: || l_api_name
2979: || ':'

Line 2976: gme_debug.put_line ( g_pkg_name

2972: CLOSE cur_get_trans;
2973: END IF;
2974: END IF;
2975: IF (g_debug <= gme_debug.g_log_statement) THEN
2976: gme_debug.put_line ( g_pkg_name
2977: || '.'
2978: || l_api_name
2979: || ':'
2980: || 'Exiting with '

Line 2992: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

2988: WHEN OTHERS THEN
2989: x_return_status := fnd_api.g_ret_sts_unexp_error;
2990: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2991:
2992: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2993: gme_debug.put_line ( g_pkg_name
2994: || '.'
2995: || l_api_name
2996: || ':'

Line 2993: gme_debug.put_line ( g_pkg_name

2989: x_return_status := fnd_api.g_ret_sts_unexp_error;
2990: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2991:
2992: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2993: gme_debug.put_line ( g_pkg_name
2994: || '.'
2995: || l_api_name
2996: || ':'
2997: || 'WHEN OTHERS:'

Line 3036: IF (g_debug <= gme_debug.g_log_statement) THEN

3032: BEGIN
3033: -- Initially let us assign the return status to success
3034: x_return_status := fnd_api.g_ret_sts_success;
3035:
3036: IF (g_debug <= gme_debug.g_log_statement) THEN
3037: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3038: || 'Entering with transaction id '||p_transaction_id);
3039:
3040: END IF;

Line 3037: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

3033: -- Initially let us assign the return status to success
3034: x_return_status := fnd_api.g_ret_sts_success;
3035:
3036: IF (g_debug <= gme_debug.g_log_statement) THEN
3037: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3038: || 'Entering with transaction id '||p_transaction_id);
3039:
3040: END IF;
3041:

Line 3049: IF (g_debug <= gme_debug.g_log_statement) THEN

3045: BULK COLLECT INTO x_mmln_tbl;
3046: CLOSE cur_get_lot_trans;
3047: END IF;
3048:
3049: IF (g_debug <= gme_debug.g_log_statement) THEN
3050: gme_debug.put_line ( g_pkg_name
3051: || '.'
3052: || l_api_name
3053: || ':'

Line 3050: gme_debug.put_line ( g_pkg_name

3046: CLOSE cur_get_lot_trans;
3047: END IF;
3048:
3049: IF (g_debug <= gme_debug.g_log_statement) THEN
3050: gme_debug.put_line ( g_pkg_name
3051: || '.'
3052: || l_api_name
3053: || ':'
3054: || 'lot count '

Line 3056: gme_debug.put_line ( g_pkg_name

3052: || l_api_name
3053: || ':'
3054: || 'lot count '
3055: || x_mmln_tbl.COUNT);
3056: gme_debug.put_line ( g_pkg_name
3057: || '.'
3058: || l_api_name
3059: || ':'
3060: || 'Exiting with '

Line 3071: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

3067: x_return_status := fnd_api.g_ret_sts_unexp_error;
3068: WHEN OTHERS THEN
3069: x_return_status := fnd_api.g_ret_sts_unexp_error;
3070:
3071: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3072: gme_debug.put_line ( g_pkg_name
3073: || '.'
3074: || l_api_name
3075: || ':'

Line 3072: gme_debug.put_line ( g_pkg_name

3068: WHEN OTHERS THEN
3069: x_return_status := fnd_api.g_ret_sts_unexp_error;
3070:
3071: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3072: gme_debug.put_line ( g_pkg_name
3073: || '.'
3074: || l_api_name
3075: || ':'
3076: || 'WHEN OTHERS:'

Line 3121: IF (g_debug <= gme_debug.g_log_statement) THEN

3117: BEGIN
3118: -- Initially let us assign the return status to success
3119: x_return_status := fnd_api.g_ret_sts_success;
3120:
3121: IF (g_debug <= gme_debug.g_log_statement) THEN
3122: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3123: || 'Entering with p_transaction_hdr_id '||p_transaction_hdr_id);
3124: END IF;
3125:

Line 3122: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

3118: -- Initially let us assign the return status to success
3119: x_return_status := fnd_api.g_ret_sts_success;
3120:
3121: IF (g_debug <= gme_debug.g_log_statement) THEN
3122: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3123: || 'Entering with p_transaction_hdr_id '||p_transaction_hdr_id);
3124: END IF;
3125:
3126: IF p_transaction_hdr_id IS NOT NULL THEN

Line 3139: IF (g_debug <= gme_debug.g_log_statement) THEN

3135: CLOSE cur_get_trans;
3136: END IF;
3137:
3138: FOR i IN 1 .. l_number_tab.COUNT LOOP
3139: IF (g_debug <= gme_debug.g_log_statement) THEN
3140: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3141: || 'calling pre_process_val with transaction_id '||l_number_tab (i));
3142: END IF;
3143: pre_process_val (p_transaction_interface_id => l_number_tab (i)

Line 3140: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

3136: END IF;
3137:
3138: FOR i IN 1 .. l_number_tab.COUNT LOOP
3139: IF (g_debug <= gme_debug.g_log_statement) THEN
3140: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3141: || 'calling pre_process_val with transaction_id '||l_number_tab (i));
3142: END IF;
3143: pre_process_val (p_transaction_interface_id => l_number_tab (i)
3144: ,x_return_status => l_return_status);

Line 3151: IF (g_debug <= gme_debug.g_log_statement) THEN

3147: RAISE fnd_api.g_exc_error;
3148: END IF;
3149: END LOOP;
3150:
3151: IF (g_debug <= gme_debug.g_log_statement) THEN
3152: gme_debug.put_line ( g_pkg_name
3153: || '.'
3154: || l_api_name
3155: || ':'

Line 3152: gme_debug.put_line ( g_pkg_name

3148: END IF;
3149: END LOOP;
3150:
3151: IF (g_debug <= gme_debug.g_log_statement) THEN
3152: gme_debug.put_line ( g_pkg_name
3153: || '.'
3154: || l_api_name
3155: || ':'
3156: || 'Exiting with '

Line 3172: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

3168: x_return_status := fnd_api.g_ret_sts_unexp_error;
3169: WHEN OTHERS THEN
3170: x_return_status := fnd_api.g_ret_sts_unexp_error;
3171:
3172: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3173: gme_debug.put_line ( g_pkg_name
3174: || '.'
3175: || l_api_name
3176: || ':'

Line 3173: gme_debug.put_line ( g_pkg_name

3169: WHEN OTHERS THEN
3170: x_return_status := fnd_api.g_ret_sts_unexp_error;
3171:
3172: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3173: gme_debug.put_line ( g_pkg_name
3174: || '.'
3175: || l_api_name
3176: || ':'
3177: || 'WHEN OTHERS:'

Line 3285: IF (g_debug <= gme_debug.g_log_statement) THEN

3281: BEGIN
3282: -- Initially let us assign the return status to success
3283: x_return_status := fnd_api.g_ret_sts_success;
3284:
3285: IF (g_debug <= gme_debug.g_log_statement) THEN
3286: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
3287: END IF;
3288: IF (g_debug <= gme_debug.g_log_statement) THEN
3289: gme_debug.put_line ( g_pkg_name

Line 3286: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');

3282: -- Initially let us assign the return status to success
3283: x_return_status := fnd_api.g_ret_sts_success;
3284:
3285: IF (g_debug <= gme_debug.g_log_statement) THEN
3286: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
3287: END IF;
3288: IF (g_debug <= gme_debug.g_log_statement) THEN
3289: gme_debug.put_line ( g_pkg_name
3290: || '.'

Line 3288: IF (g_debug <= gme_debug.g_log_statement) THEN

3284:
3285: IF (g_debug <= gme_debug.g_log_statement) THEN
3286: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
3287: END IF;
3288: IF (g_debug <= gme_debug.g_log_statement) THEN
3289: gme_debug.put_line ( g_pkg_name
3290: || '.'
3291: || l_api_name
3292: || ':'

Line 3289: gme_debug.put_line ( g_pkg_name

3285: IF (g_debug <= gme_debug.g_log_statement) THEN
3286: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
3287: END IF;
3288: IF (g_debug <= gme_debug.g_log_statement) THEN
3289: gme_debug.put_line ( g_pkg_name
3290: || '.'
3291: || l_api_name
3292: || ':'
3293: || 'p_lot_number: '

Line 3333: IF (g_debug <= gme_debug.g_log_statement) THEN

3329: END IF;
3330:
3331: CLOSE cur_lot_qty;
3332: END IF;
3333: IF (g_debug <= gme_debug.g_log_statement) THEN
3334: gme_debug.put_line ( g_pkg_name
3335: || '.'
3336: || l_api_name
3337: || ':'

Line 3334: gme_debug.put_line ( g_pkg_name

3330:
3331: CLOSE cur_lot_qty;
3332: END IF;
3333: IF (g_debug <= gme_debug.g_log_statement) THEN
3334: gme_debug.put_line ( g_pkg_name
3335: || '.'
3336: || l_api_name
3337: || ':'
3338: || 'Exiting with return status '

Line 3348: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

3344: WHEN OTHERS THEN
3345: x_return_status := fnd_api.g_ret_sts_unexp_error;
3346: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3347:
3348: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3349: gme_debug.put_line ( g_pkg_name
3350: || '.'
3351: || l_api_name
3352: || ':'

Line 3349: gme_debug.put_line ( g_pkg_name

3345: x_return_status := fnd_api.g_ret_sts_unexp_error;
3346: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3347:
3348: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3349: gme_debug.put_line ( g_pkg_name
3350: || '.'
3351: || l_api_name
3352: || ':'
3353: || 'WHEN OTHERS:'

Line 3423: IF (g_debug <= gme_debug.g_log_statement) THEN

3419: BEGIN
3420: -- Initially let us assign the return status to success
3421: x_return_status := fnd_api.g_ret_sts_success;
3422:
3423: IF (g_debug <= gme_debug.g_log_statement) THEN
3424: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3425: || 'Entering');
3426: END IF;
3427:

Line 3424: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

3420: -- Initially let us assign the return status to success
3421: x_return_status := fnd_api.g_ret_sts_success;
3422:
3423: IF (g_debug <= gme_debug.g_log_statement) THEN
3424: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3425: || 'Entering');
3426: END IF;
3427:
3428: OPEN cur_trans_detail (p_transaction_interface_id);

Line 3435: IF (g_debug <= gme_debug.g_log_statement) THEN

3431: INTO l_mmti_rec;
3432:
3433: CLOSE cur_trans_detail;
3434:
3435: IF (g_debug <= gme_debug.g_log_statement) THEN
3436: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);

Line 3436: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);

3432:
3433: CLOSE cur_trans_detail;
3434:
3435: IF (g_debug <= gme_debug.g_log_statement) THEN
3436: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);

Line 3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);

3433: CLOSE cur_trans_detail;
3434:
3435: IF (g_debug <= gme_debug.g_log_statement) THEN
3436: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);

Line 3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);

3434:
3435: IF (g_debug <= gme_debug.g_log_statement) THEN
3436: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);

Line 3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);

3435: IF (g_debug <= gme_debug.g_log_statement) THEN
3436: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);

Line 3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);

3436: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
3444: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);

Line 3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);

3437: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
3444: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
3445: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);

Line 3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);

3438: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
3444: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
3445: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
3446: END IF;

Line 3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);

3439: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
3444: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
3445: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
3446: END IF;
3447:

Line 3444: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);

3440: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
3444: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
3445: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
3446: END IF;
3447:
3448: IF l_mmti_rec.transaction_source_id IS NOT NULL THEN

Line 3445: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);

3441: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
3442: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
3443: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
3444: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
3445: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
3446: END IF;
3447:
3448: IF l_mmti_rec.transaction_source_id IS NOT NULL THEN
3449: l_batch_hdr_rec.batch_id := l_mmti_rec.transaction_source_id;

Line 3545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

3541: FETCH cur_get_item_rec INTO l_item_rec;
3542: IF cur_get_item_rec%NOTFOUND THEN
3543: CLOSE cur_get_item_rec;
3544: gme_common_pvt.log_message ('PM_INVALID_ITEM');
3545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3546: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
3547: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
3548: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
3549: END IF;

Line 3546: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');

3542: IF cur_get_item_rec%NOTFOUND THEN
3543: CLOSE cur_get_item_rec;
3544: gme_common_pvt.log_message ('PM_INVALID_ITEM');
3545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3546: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
3547: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
3548: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
3549: END IF;
3550: RAISE item_not_found;

Line 3547: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));

3543: CLOSE cur_get_item_rec;
3544: gme_common_pvt.log_message ('PM_INVALID_ITEM');
3545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3546: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
3547: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
3548: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
3549: END IF;
3550: RAISE item_not_found;
3551: END IF;

Line 3548: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));

3544: gme_common_pvt.log_message ('PM_INVALID_ITEM');
3545: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3546: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
3547: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
3548: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
3549: END IF;
3550: RAISE item_not_found;
3551: END IF;
3552: CLOSE cur_get_item_rec;

Line 3553: IF (g_debug <= gme_debug.g_log_statement) THEN

3549: END IF;
3550: RAISE item_not_found;
3551: END IF;
3552: CLOSE cur_get_item_rec;
3553: IF (g_debug <= gme_debug.g_log_statement) THEN
3554: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
3555: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
3556: END IF;
3557:

Line 3554: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);

3550: RAISE item_not_found;
3551: END IF;
3552: CLOSE cur_get_item_rec;
3553: IF (g_debug <= gme_debug.g_log_statement) THEN
3554: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
3555: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
3556: END IF;
3557:
3558: /* Bug 5358129 for ingredients lots should exist */

Line 3555: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);

3551: END IF;
3552: CLOSE cur_get_item_rec;
3553: IF (g_debug <= gme_debug.g_log_statement) THEN
3554: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
3555: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
3556: END IF;
3557:
3558: /* Bug 5358129 for ingredients lots should exist */
3559: 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

Line 3576: IF (g_debug <= gme_debug.g_log_statement) THEN

3572: IF l_mmti_rec.transaction_type_id IN
3573: (gme_common_pvt.g_byprod_return
3574: ,gme_common_pvt.g_prod_return
3575: ,gme_common_pvt.g_ing_return) THEN
3576: IF (g_debug <= gme_debug.g_log_statement) THEN
3577: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||
3578: 'Return transaction for : '||l_mmti_rec.transaction_type_id);
3579:
3580: END IF;

Line 3577: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||

3573: (gme_common_pvt.g_byprod_return
3574: ,gme_common_pvt.g_prod_return
3575: ,gme_common_pvt.g_ing_return) THEN
3576: IF (g_debug <= gme_debug.g_log_statement) THEN
3577: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||
3578: 'Return transaction for : '||l_mmti_rec.transaction_type_id);
3579:
3580: END IF;
3581: IF l_item_rec.lot_control_code = 1 THEN

Line 3582: IF (g_debug <= gme_debug.g_log_statement) THEN

3578: 'Return transaction for : '||l_mmti_rec.transaction_type_id);
3579:
3580: END IF;
3581: IF l_item_rec.lot_control_code = 1 THEN
3582: IF (g_debug <= gme_debug.g_log_statement) THEN
3583: gme_debug.put_line ( g_pkg_name
3584: || '.'
3585: || l_api_name
3586: || ':'

Line 3583: gme_debug.put_line ( g_pkg_name

3579:
3580: END IF;
3581: IF l_item_rec.lot_control_code = 1 THEN
3582: IF (g_debug <= gme_debug.g_log_statement) THEN
3583: gme_debug.put_line ( g_pkg_name
3584: || '.'
3585: || l_api_name
3586: || ':'
3587: || 'Item is NOT lot_control: '

Line 3600: IF (g_debug <= gme_debug.g_log_statement) THEN

3596:
3597: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
3598: RAISE fnd_api.g_exc_unexpected_error;
3599: END IF;
3600: IF (g_debug <= gme_debug.g_log_statement) THEN
3601: gme_debug.put_line ( g_pkg_name
3602: || '.'
3603: || l_api_name
3604: || ':'

Line 3601: gme_debug.put_line ( g_pkg_name

3597: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
3598: RAISE fnd_api.g_exc_unexpected_error;
3599: END IF;
3600: IF (g_debug <= gme_debug.g_log_statement) THEN
3601: gme_debug.put_line ( g_pkg_name
3602: || '.'
3603: || l_api_name
3604: || ':'
3605: || 'Returning Qty '

Line 3607: gme_debug.put_line ( g_pkg_name

3603: || l_api_name
3604: || ':'
3605: || 'Returning Qty '
3606: || l_mmti_rec.transaction_quantity);
3607: gme_debug.put_line ( g_pkg_name
3608: || '.'
3609: || l_api_name
3610: || ':'
3611: || 'Available to Return '

Line 3620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

3616: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
3617: RAISE fnd_api.g_exc_error;
3618: END IF;
3619: ELSE /* Lot Control */
3620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3621: gme_debug.put_line ( g_pkg_name
3622: || '.'
3623: || l_api_name
3624: || ':'

Line 3621: gme_debug.put_line ( g_pkg_name

3617: RAISE fnd_api.g_exc_error;
3618: END IF;
3619: ELSE /* Lot Control */
3620: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3621: gme_debug.put_line ( g_pkg_name
3622: || '.'
3623: || l_api_name
3624: || ':'
3625: || 'Item is lot control: '

Line 3641: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

3637:
3638: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
3639: RAISE fnd_api.g_exc_unexpected_error;
3640: END IF;
3641: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3642: gme_debug.put_line ( g_pkg_name
3643: || '.'
3644: || l_api_name
3645: || ':'

Line 3642: gme_debug.put_line ( g_pkg_name

3638: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
3639: RAISE fnd_api.g_exc_unexpected_error;
3640: END IF;
3641: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3642: gme_debug.put_line ( g_pkg_name
3643: || '.'
3644: || l_api_name
3645: || ':'
3646: || 'Returning qty: '|| get_rec.l_mtli_lot_qty);

Line 3647: gme_debug.put_line ( g_pkg_name

3643: || '.'
3644: || l_api_name
3645: || ':'
3646: || 'Returning qty: '|| get_rec.l_mtli_lot_qty);
3647: gme_debug.put_line ( g_pkg_name
3648: || '.'
3649: || l_api_name
3650: || ':'
3651: || 'Available to Return '

Line 3664: IF (g_debug <= gme_debug.g_log_statement) THEN

3660: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */
3661: END IF; /* IF transaction_type_id in RETURNS */
3662: END IF; /* update_inventory_ind = 'Y' */
3663:
3664: IF (g_debug <= gme_debug.g_log_statement) THEN
3665: gme_debug.put_line ( g_pkg_name
3666: || '.'
3667: || l_api_name
3668: || ':'

Line 3665: gme_debug.put_line ( g_pkg_name

3661: END IF; /* IF transaction_type_id in RETURNS */
3662: END IF; /* update_inventory_ind = 'Y' */
3663:
3664: IF (g_debug <= gme_debug.g_log_statement) THEN
3665: gme_debug.put_line ( g_pkg_name
3666: || '.'
3667: || l_api_name
3668: || ':'
3669: || 'Exiting with '

Line 3687: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

3683: WHEN OTHERS THEN
3684: x_return_status := fnd_api.g_ret_sts_unexp_error;
3685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3686:
3687: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3688: gme_debug.put_line ( g_pkg_name
3689: || '.'
3690: || l_api_name
3691: || ':'

Line 3688: gme_debug.put_line ( g_pkg_name

3684: x_return_status := fnd_api.g_ret_sts_unexp_error;
3685: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3686:
3687: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
3688: gme_debug.put_line ( g_pkg_name
3689: || '.'
3690: || l_api_name
3691: || ':'
3692: || 'WHEN OTHERS:'

Line 3737: IF (g_debug <= gme_debug.g_log_statement) THEN

3733: -- Initially let us assign the return status to success
3734:
3735: l_transaction_interface_id := p_transaction_interface_id;
3736:
3737: IF (g_debug <= gme_debug.g_log_statement) THEN
3738: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3739: || 'Entering');
3740: END IF;
3741:

Line 3738: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

3734:
3735: l_transaction_interface_id := p_transaction_interface_id;
3736:
3737: IF (g_debug <= gme_debug.g_log_statement) THEN
3738: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3739: || 'Entering');
3740: END IF;
3741:
3742: -- based on message call count and get

Line 3754: IF (g_debug <= gme_debug.g_log_statement) THEN

3750: ,error_explanation = SUBSTR(NVL (x_message_list, l_errm), 1, 240)
3751: ,process_flag = 3 -- we can make it a constant in gme common
3752: WHERE transaction_interface_id = l_transaction_interface_id;
3753:
3754: IF (g_debug <= gme_debug.g_log_statement) THEN
3755: gme_debug.put_line ('Full error message is: '||NVL (x_message_list, l_errm));
3756:
3757: gme_debug.put_line ( g_pkg_name
3758: || '.'

Line 3755: gme_debug.put_line ('Full error message is: '||NVL (x_message_list, l_errm));

3751: ,process_flag = 3 -- we can make it a constant in gme common
3752: WHERE transaction_interface_id = l_transaction_interface_id;
3753:
3754: IF (g_debug <= gme_debug.g_log_statement) THEN
3755: gme_debug.put_line ('Full error message is: '||NVL (x_message_list, l_errm));
3756:
3757: gme_debug.put_line ( g_pkg_name
3758: || '.'
3759: || l_api_name

Line 3757: gme_debug.put_line ( g_pkg_name

3753:
3754: IF (g_debug <= gme_debug.g_log_statement) THEN
3755: gme_debug.put_line ('Full error message is: '||NVL (x_message_list, l_errm));
3756:
3757: gme_debug.put_line ( g_pkg_name
3758: || '.'
3759: || l_api_name
3760: || ':'
3761: || 'Exiting'

Line 3768: IF g_debug <= gme_debug.g_log_unexpected THEN

3764: EXCEPTION
3765: WHEN OTHERS THEN
3766: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3767:
3768: IF g_debug <= gme_debug.g_log_unexpected THEN
3769: gme_debug.put_line ( 'When others exception in '
3770: || g_pkg_name
3771: || '.'
3772: || l_api_name

Line 3769: gme_debug.put_line ( 'When others exception in '

3765: WHEN OTHERS THEN
3766: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3767:
3768: IF g_debug <= gme_debug.g_log_unexpected THEN
3769: gme_debug.put_line ( 'When others exception in '
3770: || g_pkg_name
3771: || '.'
3772: || l_api_name
3773: || ' Error is '

Line 3892: IF (g_debug <= gme_debug.g_log_statement) THEN

3888: BEGIN
3889: -- Initially let us assign the return status to success
3890: x_return_status := fnd_api.g_ret_sts_success;
3891:
3892: IF (g_debug <= gme_debug.g_log_statement) THEN
3893: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3894: || 'Entering with trans id: '||p_transaction_id);
3895:
3896: END IF;

Line 3893: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

3889: -- Initially let us assign the return status to success
3890: x_return_status := fnd_api.g_ret_sts_success;
3891:
3892: IF (g_debug <= gme_debug.g_log_statement) THEN
3893: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3894: || 'Entering with trans id: '||p_transaction_id);
3895:
3896: END IF;
3897:

Line 3916: IF (g_debug <= gme_debug.g_log_statement) THEN

3912: p_material_dtl_id => l_trx_source_line_id,
3913: p_transaction_id => l_transaction_id,
3914: x_return_status => x_return_status);
3915:
3916: IF (g_debug <= gme_debug.g_log_statement) THEN
3917: gme_debug.put_line ( g_pkg_name
3918: || '.'
3919: || l_api_name
3920: || ':'

Line 3917: gme_debug.put_line ( g_pkg_name

3913: p_transaction_id => l_transaction_id,
3914: x_return_status => x_return_status);
3915:
3916: IF (g_debug <= gme_debug.g_log_statement) THEN
3917: gme_debug.put_line ( g_pkg_name
3918: || '.'
3919: || l_api_name
3920: || ':'
3921: || 'transaction_id: '

Line 3923: gme_debug.put_line ( g_pkg_name

3919: || l_api_name
3920: || ':'
3921: || 'transaction_id: '
3922: || l_transaction_id);
3923: gme_debug.put_line ( g_pkg_name
3924: || '.'
3925: || l_api_name
3926: || ':'
3927: || 'transaction_source_id: '

Line 3929: gme_debug.put_line ( g_pkg_name

3925: || l_api_name
3926: || ':'
3927: || 'transaction_source_id: '
3928: || l_transaction_source_id);
3929: gme_debug.put_line ( g_pkg_name
3930: || '.'
3931: || l_api_name
3932: || ':'
3933: || 'trx_source_line_id: '

Line 3935: gme_debug.put_line ( g_pkg_name

3931: || l_api_name
3932: || ':'
3933: || 'trx_source_line_id: '
3934: || l_trx_source_line_id);
3935: gme_debug.put_line ( g_pkg_name
3936: || '.'
3937: || l_api_name
3938: || ':'
3939: || 'source_line_id: '

Line 3941: gme_debug.put_line ( g_pkg_name

3937: || l_api_name
3938: || ':'
3939: || 'source_line_id: '
3940: || l_source_line_id);
3941: gme_debug.put_line ( g_pkg_name
3942: || '.'
3943: || l_api_name
3944: || ':'
3945: || 'inventory_item_id: '

Line 3947: gme_debug.put_line ( g_pkg_name

3943: || l_api_name
3944: || ':'
3945: || 'inventory_item_id: '
3946: || l_inventory_item_id);
3947: gme_debug.put_line ( g_pkg_name
3948: || '.'
3949: || l_api_name
3950: || ':'
3951: || 'transaction refernce: '

Line 3956: IF (g_debug <= gme_debug.g_log_statement) THEN

3952: || l_transaction_reference);
3953: END IF;
3954:
3955: IF l_source_line_id <> -99 THEN
3956: IF (g_debug <= gme_debug.g_log_statement) THEN
3957: gme_debug.put_line ( g_pkg_name
3958: || '.'
3959: || l_api_name
3960: || ':'

Line 3957: gme_debug.put_line ( g_pkg_name

3953: END IF;
3954:
3955: IF l_source_line_id <> -99 THEN
3956: IF (g_debug <= gme_debug.g_log_statement) THEN
3957: gme_debug.put_line ( g_pkg_name
3958: || '.'
3959: || l_api_name
3960: || ':'
3961: || 'for inserting reverse transaction_id: '

Line 3963: gme_debug.put_line ( g_pkg_name

3959: || l_api_name
3960: || ':'
3961: || 'for inserting reverse transaction_id: '
3962: || l_transaction_id);
3963: gme_debug.put_line ( g_pkg_name
3964: || '.'
3965: || l_api_name
3966: || ':'
3967: || 'for inserting reverse source_line_id: '

Line 3987: IF (g_debug <= gme_debug.g_log_statement) THEN

3983: VALUES (l_transaction_source_id, l_trx_source_line_id
3984: ,l_transaction_id, l_source_line_id
3985: ,gme_common_pvt.g_pairs_reversal_type);
3986:
3987: IF (g_debug <= gme_debug.g_log_statement) THEN
3988: gme_debug.put_line ( g_pkg_name
3989: || '.'
3990: || l_api_name
3991: || ':'

Line 3988: gme_debug.put_line ( g_pkg_name

3984: ,l_transaction_id, l_source_line_id
3985: ,gme_common_pvt.g_pairs_reversal_type);
3986:
3987: IF (g_debug <= gme_debug.g_log_statement) THEN
3988: gme_debug.put_line ( g_pkg_name
3989: || '.'
3990: || l_api_name
3991: || ':'
3992: || 'after inserting reverse transaction_id: '

Line 3994: gme_debug.put_line ( g_pkg_name

3990: || l_api_name
3991: || ':'
3992: || 'after inserting reverse transaction_id: '
3993: || l_transaction_id);
3994: gme_debug.put_line ( g_pkg_name
3995: || '.'
3996: || l_api_name
3997: || ':'
3998: || 'after inserting reverse source_line_id: '

Line 4011: IF (g_debug <= gme_debug.g_log_statement) THEN

4007: (p_material_detail => l_mat_dtl_rec
4008: ,x_material_detail => l_mat_dtl_rec) THEN
4009: RAISE fnd_api.g_exc_error;
4010: END IF;
4011: IF (g_debug <= gme_debug.g_log_statement) THEN
4012: gme_debug.put_line
4013: ( g_pkg_name
4014: || '.'
4015: || l_api_name

Line 4012: gme_debug.put_line

4008: ,x_material_detail => l_mat_dtl_rec) THEN
4009: RAISE fnd_api.g_exc_error;
4010: END IF;
4011: IF (g_debug <= gme_debug.g_log_statement) THEN
4012: gme_debug.put_line
4013: ( g_pkg_name
4014: || '.'
4015: || l_api_name
4016: || ':'

Line 4023: IF (g_debug <= gme_debug.g_log_statement) THEN

4019: END IF;
4020:
4021:
4022: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL THEN
4023: IF (g_debug <= gme_debug.g_log_statement) THEN
4024: gme_debug.put_line
4025: ( g_pkg_name
4026: || '.'
4027: || l_api_name

Line 4024: gme_debug.put_line

4020:
4021:
4022: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL THEN
4023: IF (g_debug <= gme_debug.g_log_statement) THEN
4024: gme_debug.put_line
4025: ( g_pkg_name
4026: || '.'
4027: || l_api_name
4028: || '.'

Line 4031: gme_debug.put_line

4027: || l_api_name
4028: || '.'
4029: || 'update row -phantom in pairs having l_trans_ref: '
4030: || l_transaction_reference);
4031: gme_debug.put_line
4032: ( g_pkg_name
4033: || '.'
4034: || l_api_name
4035: || '.'

Line 4062: IF (g_debug <= gme_debug.g_log_statement) THEN

4058: FROM gme_transaction_pairs
4059: WHERE transaction_id2 = l_transaction_id
4060: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
4061:
4062: IF (g_debug <= gme_debug.g_log_statement) THEN
4063: gme_debug.put_line
4064: ( g_pkg_name
4065: || '.'
4066: || l_api_name

Line 4063: gme_debug.put_line

4059: WHERE transaction_id2 = l_transaction_id
4060: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
4061:
4062: IF (g_debug <= gme_debug.g_log_statement) THEN
4063: gme_debug.put_line
4064: ( g_pkg_name
4065: || '.'
4066: || l_api_name
4067: || '.'

Line 4070: gme_debug.put_line ( g_pkg_name

4066: || l_api_name
4067: || '.'
4068: || 'after update row -phantom l_trans_id1: '
4069: || l_gme_pairs_rec.transaction_id1);
4070: gme_debug.put_line ( g_pkg_name
4071: || '.'
4072: || l_api_name
4073: || '.'
4074: || 'after update row-phantom l_trans_ID2: '

Line 4076: gme_debug.put_line

4072: || l_api_name
4073: || '.'
4074: || 'after update row-phantom l_trans_ID2: '
4075: || l_gme_pairs_rec.transaction_id1);
4076: gme_debug.put_line
4077: ( g_pkg_name
4078: || '.'
4079: || l_api_name
4080: || '.'

Line 4083: gme_debug.put_line

4079: || l_api_name
4080: || '.'
4081: || 'insert row- after update -transaction_id1: '
4082: || l_gme_pairs_rec.transaction_id1);
4083: gme_debug.put_line
4084: ( g_pkg_name
4085: || '.'
4086: || l_api_name
4087: || '.'

Line 4090: gme_debug.put_line ( g_pkg_name

4086: || l_api_name
4087: || '.'
4088: || 'insert row- after update -transaction_id2: '
4089: || l_gme_pairs_rec.transaction_id2);
4090: gme_debug.put_line ( g_pkg_name
4091: || '.'
4092: || l_api_name
4093: || '.'
4094: || 'insert row- after update -batch_id:'

Line 4096: gme_debug.put_line ( g_pkg_name

4092: || l_api_name
4093: || '.'
4094: || 'insert row- after update -batch_id:'
4095: || l_transaction_source_id);
4096: gme_debug.put_line ( g_pkg_name
4097: || '.'
4098: || l_api_name
4099: || '.'
4100: || 'insert row- after update -mat_det_id: '

Line 4115: IF (g_debug <= gme_debug.g_log_statement) THEN

4111:
4112:
4113: EXCEPTION
4114: WHEN NO_DATA_FOUND THEN
4115: IF (g_debug <= gme_debug.g_log_statement) THEN
4116: gme_debug.put_line ( g_pkg_name
4117: || '.'
4118: || l_api_name
4119: || '.'

Line 4116: gme_debug.put_line ( g_pkg_name

4112:
4113: EXCEPTION
4114: WHEN NO_DATA_FOUND THEN
4115: IF (g_debug <= gme_debug.g_log_statement) THEN
4116: gme_debug.put_line ( g_pkg_name
4117: || '.'
4118: || l_api_name
4119: || '.'
4120: || 'No_data_found');

Line 4121: gme_debug.put_line ( g_pkg_name

4117: || '.'
4118: || l_api_name
4119: || '.'
4120: || 'No_data_found');
4121: gme_debug.put_line ( g_pkg_name
4122: || '.'
4123: || l_api_name
4124: || '.'
4125: || 'insert row-transaction_id1: '

Line 4127: gme_debug.put_line ( g_pkg_name

4123: || l_api_name
4124: || '.'
4125: || 'insert row-transaction_id1: '
4126: || l_transaction_id);
4127: gme_debug.put_line ( g_pkg_name
4128: || '.'
4129: || l_api_name
4130: || '.'
4131: || 'insert row-transaction_id2: '

Line 4133: gme_debug.put_line ( g_pkg_name

4129: || l_api_name
4130: || '.'
4131: || 'insert row-transaction_id2: '
4132: || l_transaction_reference);
4133: gme_debug.put_line ( g_pkg_name
4134: || '.'
4135: || l_api_name
4136: || '.'
4137: || 'insert row-batch_id: '

Line 4139: gme_debug.put_line ( g_pkg_name

4135: || l_api_name
4136: || '.'
4137: || 'insert row-batch_id: '
4138: || l_transaction_source_id);
4139: gme_debug.put_line ( g_pkg_name
4140: || '.'
4141: || l_api_name
4142: || '.'
4143: || 'insert row-material_detail_id: '

Line 4206: IF (g_debug <= gme_debug.g_log_statement) THEN

4202: l_trx_source_line_id);
4203: FETCH check_event_batchmtl_removed INTO l_exists;
4204: CLOSE check_event_batchmtl_removed;
4205:
4206: IF (g_debug <= gme_debug.g_log_statement) THEN
4207: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': '||'l_exists = '||
4208: TO_CHAR (l_exists));
4209: END IF;
4210:

Line 4207: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': '||'l_exists = '||

4203: FETCH check_event_batchmtl_removed INTO l_exists;
4204: CLOSE check_event_batchmtl_removed;
4205:
4206: IF (g_debug <= gme_debug.g_log_statement) THEN
4207: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': '||'l_exists = '||
4208: TO_CHAR (l_exists));
4209: END IF;
4210:
4211: -- Bug 5763818

Line 4224: IF (g_debug <= gme_debug.g_log_statement) THEN

4220: ,x_material_detail => l_mat_dtl_rec) THEN
4221: RAISE fnd_api.g_exc_error;
4222: END IF;
4223:
4224: IF (g_debug <= gme_debug.g_log_statement) THEN
4225: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' mat_id '|| l_mat_dtl_rec.material_detail_id );
4226: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' DTL_UM '|| l_mat_dtl_rec.dtl_um );
4227:
4228: END IF;

Line 4225: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' mat_id '|| l_mat_dtl_rec.material_detail_id );

4221: RAISE fnd_api.g_exc_error;
4222: END IF;
4223:
4224: IF (g_debug <= gme_debug.g_log_statement) THEN
4225: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' mat_id '|| l_mat_dtl_rec.material_detail_id );
4226: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' DTL_UM '|| l_mat_dtl_rec.dtl_um );
4227:
4228: END IF;
4229: --sum for material_detail line

Line 4226: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' DTL_UM '|| l_mat_dtl_rec.dtl_um );

4222: END IF;
4223:
4224: IF (g_debug <= gme_debug.g_log_statement) THEN
4225: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' mat_id '|| l_mat_dtl_rec.material_detail_id );
4226: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' DTL_UM '|| l_mat_dtl_rec.dtl_um );
4227:
4228: END IF;
4229: --sum for material_detail line
4230: /* Bug 5903208 Instead of directly getting sum now we get 1 lot at a time and also the sum */

Line 4237: IF (g_debug <= gme_debug.g_log_statement) THEN

4233: p_qty_tbl(get_rec.transaction_id||'@'||get_rec.lot_number).doc_qty := get_rec.doc_qty;
4234: END LOOP;
4235:
4236: -- Now update the qty to material_detail
4237: IF (g_debug <= gme_debug.g_log_statement) THEN
4238: gme_debug.put_line ( g_pkg_name
4239: || '.'
4240: || l_api_name
4241: || ':Actual Quantity '

Line 4238: gme_debug.put_line ( g_pkg_name

4234: END LOOP;
4235:
4236: -- Now update the qty to material_detail
4237: IF (g_debug <= gme_debug.g_log_statement) THEN
4238: gme_debug.put_line ( g_pkg_name
4239: || '.'
4240: || l_api_name
4241: || ':Actual Quantity '
4242: || l_actual_qty);

Line 4243: gme_debug.put_line ( g_pkg_name

4239: || '.'
4240: || l_api_name
4241: || ':Actual Quantity '
4242: || l_actual_qty);
4243: gme_debug.put_line ( g_pkg_name
4244: || '.'
4245: || l_api_name
4246: || ': TRX_SOURCE_LINE_ID '
4247: || l_trx_source_line_id);

Line 4271: IF (g_debug <= gme_debug.g_log_statement) THEN

4267: -- Pawan Kumar add bug 5709186
4268: -- in case transaction added from transaction form, l_source_line_id is null.
4269: AND nvl(l_source_line_id, -99) < 0 THEN
4270:
4271: IF (g_debug <= gme_debug.g_log_statement) THEN
4272: gme_debug.put_line ( g_pkg_name
4273: || '.'
4274: || l_api_name
4275: || ' Invoke transfer_reservation_to_inv ');

Line 4272: gme_debug.put_line ( g_pkg_name

4268: -- in case transaction added from transaction form, l_source_line_id is null.
4269: AND nvl(l_source_line_id, -99) < 0 THEN
4270:
4271: IF (g_debug <= gme_debug.g_log_statement) THEN
4272: gme_debug.put_line ( g_pkg_name
4273: || '.'
4274: || l_api_name
4275: || ' Invoke transfer_reservation_to_inv ');
4276: END IF;

Line 4284: IF (g_debug <= gme_debug.g_log_statement) THEN

4280: ,x_message_count => x_msg_count
4281: ,x_message_list => x_msg_data
4282: ,x_return_status => x_return_status);
4283:
4284: IF (g_debug <= gme_debug.g_log_statement) THEN
4285: gme_debug.put_line ( g_pkg_name
4286: || '.'
4287: || l_api_name
4288: || ' transfer_reservation_to_inv returns '

Line 4285: gme_debug.put_line ( g_pkg_name

4281: ,x_message_list => x_msg_data
4282: ,x_return_status => x_return_status);
4283:
4284: IF (g_debug <= gme_debug.g_log_statement) THEN
4285: gme_debug.put_line ( g_pkg_name
4286: || '.'
4287: || l_api_name
4288: || ' transfer_reservation_to_inv returns '
4289: || x_return_status);

Line 4298: IF (g_debug <= gme_debug.g_log_statement) THEN

4294: END IF;
4295: -- B4944024 END
4296:
4297: -- Now check for negative qty
4298: IF (g_debug <= gme_debug.g_log_statement) THEN
4299: gme_debug.put_line ( g_pkg_name
4300: || '.'
4301: || l_api_name
4302: || ':'

Line 4299: gme_debug.put_line ( g_pkg_name

4295: -- B4944024 END
4296:
4297: -- Now check for negative qty
4298: IF (g_debug <= gme_debug.g_log_statement) THEN
4299: gme_debug.put_line ( g_pkg_name
4300: || '.'
4301: || l_api_name
4302: || ':'
4303: || 'Exiting with '

Line 4318: IF g_debug <= gme_debug.g_log_unexpected THEN

4314: x_return_status := fnd_api.g_ret_sts_unexp_error;
4315: WHEN OTHERS THEN
4316: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4317:
4318: IF g_debug <= gme_debug.g_log_unexpected THEN
4319: gme_debug.put_line ( 'When others exception in '
4320: || g_pkg_name
4321: || '.'
4322: || l_api_name

Line 4319: gme_debug.put_line ( 'When others exception in '

4315: WHEN OTHERS THEN
4316: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4317:
4318: IF g_debug <= gme_debug.g_log_unexpected THEN
4319: gme_debug.put_line ( 'When others exception in '
4320: || g_pkg_name
4321: || '.'
4322: || l_api_name
4323: || ' Error is '

Line 4359: IF (g_debug <= gme_debug.g_log_statement) THEN

4355: BEGIN
4356: -- Initially let us assign the return status to success
4357: x_return_status := fnd_api.g_ret_sts_success;
4358:
4359: IF (g_debug <= gme_debug.g_log_statement) THEN
4360: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4361: || 'Entering');
4362: END IF;
4363:

Line 4360: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

4356: -- Initially let us assign the return status to success
4357: x_return_status := fnd_api.g_ret_sts_success;
4358:
4359: IF (g_debug <= gme_debug.g_log_statement) THEN
4360: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4361: || 'Entering');
4362: END IF;
4363:
4364: IF p_batch_id IS NULL AND p_material_detail_id IS NULL THEN

Line 4374: IF (g_debug <= gme_debug.g_log_statement) THEN

4370:
4371: l_batch_id := p_batch_id;
4372: l_material_detail_id := p_material_detail_id;
4373:
4374: IF (g_debug <= gme_debug.g_log_statement) THEN
4375: gme_debug.put_line ( g_pkg_name
4376: || '.'
4377: || l_api_name
4378: || ':'

Line 4375: gme_debug.put_line ( g_pkg_name

4371: l_batch_id := p_batch_id;
4372: l_material_detail_id := p_material_detail_id;
4373:
4374: IF (g_debug <= gme_debug.g_log_statement) THEN
4375: gme_debug.put_line ( g_pkg_name
4376: || '.'
4377: || l_api_name
4378: || ':'
4379: || 'batch_id:'

Line 4381: gme_debug.put_line ( g_pkg_name

4377: || l_api_name
4378: || ':'
4379: || 'batch_id:'
4380: || l_batch_id);
4381: gme_debug.put_line ( g_pkg_name
4382: || '.'
4383: || l_api_name
4384: || ':'
4385: || 'material_detail_id:'

Line 4401: IF (g_debug <= gme_debug.g_log_statement) THEN

4397: WHERE batch_id = l_batch_id
4398: AND material_detail_id = l_material_detail_id;
4399: END IF;
4400:
4401: IF (g_debug <= gme_debug.g_log_statement) THEN
4402: gme_debug.put_line ( g_pkg_name
4403: || '.'
4404: || l_api_name
4405: || ':'

Line 4402: gme_debug.put_line ( g_pkg_name

4398: AND material_detail_id = l_material_detail_id;
4399: END IF;
4400:
4401: IF (g_debug <= gme_debug.g_log_statement) THEN
4402: gme_debug.put_line ( g_pkg_name
4403: || '.'
4404: || l_api_name
4405: || ':'
4406: || 'Exiting with '

Line 4417: IF g_debug <= gme_debug.g_log_unexpected THEN

4413: x_return_status := fnd_api.g_ret_sts_unexp_error;
4414: WHEN OTHERS THEN
4415: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4416:
4417: IF g_debug <= gme_debug.g_log_unexpected THEN
4418: gme_debug.put_line ( 'When others exception in '
4419: || g_pkg_name
4420: || '.'
4421: || l_api_name

Line 4418: gme_debug.put_line ( 'When others exception in '

4414: WHEN OTHERS THEN
4415: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4416:
4417: IF g_debug <= gme_debug.g_log_unexpected THEN
4418: gme_debug.put_line ( 'When others exception in '
4419: || g_pkg_name
4420: || '.'
4421: || l_api_name
4422: || ' Error is '

Line 4522: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4518: int_rec_count number;
4519:
4520: BEGIN
4521: IF (NVL (g_debug, 0) IN
4522: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4523: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4524: || 'Entering');
4525: END IF;
4526:

Line 4523: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

4519:
4520: BEGIN
4521: IF (NVL (g_debug, 0) IN
4522: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4523: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4524: || 'Entering');
4525: END IF;
4526:
4527: --

Line 4545: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4541: WHERE transaction_header_id = p_header_id
4542: AND process_flag = 1
4543: );
4544:
4545: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4546: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || ' count of records from MTI :'||int_rec_count);
4547: END IF;
4548:
4549: --

Line 4546: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || ' count of records from MTI :'||int_rec_count);

4542: AND process_flag = 1
4543: );
4544:
4545: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4546: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || ' count of records from MTI :'||int_rec_count);
4547: END IF;
4548:
4549: --
4550: -- Bug 10306577

Line 4561: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4557: free the quantity tree */
4558: /* Bug 5255959 added p_clear_qty_cache condition */
4559: --Bug#5584699
4560: IF (p_table = 2 AND p_clear_qty_cache = fnd_api.g_true) THEN
4561: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4562: gme_debug.put_line
4563: ( g_pkg_name
4564: || '.'
4565: || l_api_name

Line 4562: gme_debug.put_line

4558: /* Bug 5255959 added p_clear_qty_cache condition */
4559: --Bug#5584699
4560: IF (p_table = 2 AND p_clear_qty_cache = fnd_api.g_true) THEN
4561: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4562: gme_debug.put_line
4563: ( g_pkg_name
4564: || '.'
4565: || l_api_name
4566: || ':'

Line 4572: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4568: END IF;
4569: inv_quantity_tree_pub.clear_quantity_cache;
4570: END IF;
4571:
4572: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4573: gme_debug.put_line
4574: ( g_pkg_name
4575: || '.'
4576: || l_api_name

Line 4573: gme_debug.put_line

4569: inv_quantity_tree_pub.clear_quantity_cache;
4570: END IF;
4571:
4572: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4573: gme_debug.put_line
4574: ( g_pkg_name
4575: || '.'
4576: || l_api_name
4577: || ':'

Line 4579: gme_debug.put_line ( g_pkg_name

4575: || '.'
4576: || l_api_name
4577: || ':'
4578: || 'Calling INV_TXN_MANAGER_PUB.process_transactions');
4579: gme_debug.put_line ( g_pkg_name
4580: || '.'
4581: || l_api_name
4582: || ':'
4583: || 'Transaction Header ID = '

Line 4585: gme_debug.put_line

4581: || l_api_name
4582: || ':'
4583: || 'Transaction Header ID = '
4584: || p_header_id);
4585: gme_debug.put_line
4586: ( g_pkg_name
4587: || '.'
4588: || l_api_name
4589: || ':'

Line 4647: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4643: ,x_msg_count => x_msg_count
4644: ,x_msg_data => x_msg_data
4645: ,x_trans_count => x_trans_count);
4646:
4647: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4648: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'After calling INV_TXN_MANAGER_PUB.process_transactions l_return= '
4649: || l_return || ' x_return_status= '|| x_return_status
4650: || ' x_msg_data = '|| x_msg_data);
4651: END IF;

Line 4648: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'After calling INV_TXN_MANAGER_PUB.process_transactions l_return= '

4644: ,x_msg_data => x_msg_data
4645: ,x_trans_count => x_trans_count);
4646:
4647: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4648: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'After calling INV_TXN_MANAGER_PUB.process_transactions l_return= '
4649: || l_return || ' x_return_status= '|| x_return_status
4650: || ' x_msg_data = '|| x_msg_data);
4651: END IF;
4652:

Line 4675: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4671: ,p_token1_name => 'MESSAGE'
4672: ,p_token1_value => rec.error_explanation);
4673: --fnd_message.set_encoded (rec.error_explanation);
4674:
4675: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4676: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
4677: END IF;
4678: x_msg_count := x_msg_count + 1;
4679: x_msg_data := rec.error_explanation;

Line 4676: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);

4672: ,p_token1_value => rec.error_explanation);
4673: --fnd_message.set_encoded (rec.error_explanation);
4674:
4675: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4676: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
4677: END IF;
4678: x_msg_count := x_msg_count + 1;
4679: x_msg_data := rec.error_explanation;
4680: END LOOP;

Line 4691: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4687: ,p_token1_name => 'MESSAGE'
4688: ,p_token1_value => rec.error_explanation);
4689: --fnd_message.set_encoded (rec.error_explanation);
4690:
4691: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4692: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
4693: END IF;
4694: x_msg_count := x_msg_count + 1;
4695: x_msg_data := rec.error_explanation;

Line 4692: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);

4688: ,p_token1_value => rec.error_explanation);
4689: --fnd_message.set_encoded (rec.error_explanation);
4690:
4691: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4692: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
4693: END IF;
4694: x_msg_count := x_msg_count + 1;
4695: x_msg_data := rec.error_explanation;
4696: END LOOP;

Line 4796: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4792: l_trans_rec.created_by := trans_rec.created_by;
4793: l_trans_rec.last_update_login := trans_rec.last_update_login;
4794:
4795: IF trans_rec.transaction_action_id in (1, 27) THEN
4796: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4797: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers'); --xxxremove
4798: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers');
4799: END IF;
4800:

Line 4797: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers'); --xxxremove

4793: l_trans_rec.last_update_login := trans_rec.last_update_login;
4794:
4795: IF trans_rec.transaction_action_id in (1, 27) THEN
4796: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4797: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers'); --xxxremove
4798: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers');
4799: END IF;
4800:
4801: l_trans_rec.doc_qty := -1 * l_trans_rec.doc_qty;

Line 4798: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers');

4794:
4795: IF trans_rec.transaction_action_id in (1, 27) THEN
4796: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4797: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers'); --xxxremove
4798: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers');
4799: END IF;
4800:
4801: l_trans_rec.doc_qty := -1 * l_trans_rec.doc_qty;
4802:

Line 4811: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4807: x_return_status => x_return_status,
4808: x_msg_count => x_msg_count,
4809: x_msg_data => x_msg_data);
4810: ELSIF trans_rec.transaction_action_id in (31, 32) THEN
4811: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4812: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...calling GMF incoming layers');
4813: END IF;
4814:
4815: --Bug#6322202 Added the below condition for byproducts

Line 4812: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...calling GMF incoming layers');

4808: x_msg_count => x_msg_count,
4809: x_msg_data => x_msg_data);
4810: ELSIF trans_rec.transaction_action_id in (31, 32) THEN
4811: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4812: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...calling GMF incoming layers');
4813: END IF;
4814:
4815: --Bug#6322202 Added the below condition for byproducts
4816: IF trans_rec.line_type <> 1 THEN

Line 4833: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4829: x_return_status => x_return_status,
4830: x_msg_count => x_msg_count,
4831: x_msg_data => x_msg_data);
4832: END IF;
4833: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4834: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...after calling GMF incoming layers...status: ' || x_return_status); --xxxremove
4835: END IF;
4836: ELSIF trans_rec.transaction_action_id in (33, 34) THEN
4837: NULL;

Line 4834: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...after calling GMF incoming layers...status: ' || x_return_status); --xxxremove

4830: x_msg_count => x_msg_count,
4831: x_msg_data => x_msg_data);
4832: END IF;
4833: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4834: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...after calling GMF incoming layers...status: ' || x_return_status); --xxxremove
4835: END IF;
4836: ELSIF trans_rec.transaction_action_id in (33, 34) THEN
4837: NULL;
4838: END IF;

Line 4852: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4848: /* end temporary */
4849:
4850: IF (l_return = 0) AND (fnd_api.to_boolean (p_commit) ) THEN
4851: --empty the quantity tree cache
4852: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4853: gme_debug.put_line
4854: ( g_pkg_name
4855: || '.'
4856: || l_api_name

Line 4853: gme_debug.put_line

4849:
4850: IF (l_return = 0) AND (fnd_api.to_boolean (p_commit) ) THEN
4851: --empty the quantity tree cache
4852: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4853: gme_debug.put_line
4854: ( g_pkg_name
4855: || '.'
4856: || l_api_name
4857: || ':'

Line 4870: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4866: -- Bug 8751983 - Reset global IB timestamp to NULL.
4867: gme_common_pvt.g_ib_timestamp_set := 0;
4868:
4869: IF (NVL (g_debug, 0) IN
4870: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4871: gme_debug.put_line ( g_pkg_name
4872: || '.'
4873: || l_api_name
4874: || ':'

Line 4871: gme_debug.put_line ( g_pkg_name

4867: gme_common_pvt.g_ib_timestamp_set := 0;
4868:
4869: IF (NVL (g_debug, 0) IN
4870: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4871: gme_debug.put_line ( g_pkg_name
4872: || '.'
4873: || l_api_name
4874: || ':'
4875: || 'Exiting with '

Line 4888: gme_debug.put_line ( g_pkg_name

4884: WHEN fnd_api.g_exc_unexpected_error THEN
4885: x_return_status := fnd_api.g_ret_sts_unexp_error;
4886:
4887: IF (NVL (g_debug, 0) > 0) THEN
4888: gme_debug.put_line ( g_pkg_name
4889: || '.'
4890: || l_api_name
4891: || ':'
4892: || 'UNEXPECTED:'

Line 4902: gme_debug.put_line ( g_pkg_name

4898: WHEN OTHERS THEN
4899: x_return_status := fnd_api.g_ret_sts_unexp_error;
4900:
4901: IF (NVL (g_debug, 0) > 0) THEN
4902: gme_debug.put_line ( g_pkg_name
4903: || '.'
4904: || l_api_name
4905: || ':'
4906: || 'OTHERS:'

Line 4985: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

4981: l_is_revision_control BOOLEAN := FALSE;
4982: l_is_lot_control BOOLEAN := FALSE;
4983: BEGIN
4984: IF (NVL (g_debug, 0) IN
4985: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4986: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4987: || 'Entering');
4988: END IF;
4989:

Line 4986: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

4982: l_is_lot_control BOOLEAN := FALSE;
4983: BEGIN
4984: IF (NVL (g_debug, 0) IN
4985: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4986: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4987: || 'Entering');
4988: END IF;
4989:
4990: IF (p_revision IS NOT NULL) THEN

Line 4998: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

4994: IF (p_lot_number IS NOT NULL) THEN
4995: l_is_lot_control := TRUE;
4996: END IF;
4997:
4998: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4999: gme_debug.put_line ( g_pkg_name
5000: || '.'
5001: || l_api_name
5002: || ':'

Line 4999: gme_debug.put_line ( g_pkg_name

4995: l_is_lot_control := TRUE;
4996: END IF;
4997:
4998: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4999: gme_debug.put_line ( g_pkg_name
5000: || '.'
5001: || l_api_name
5002: || ':'
5003: || 'Calling Inv_Quantity_Tree_Pub.Query_Quantities');

Line 5004: gme_debug.put_line ( g_pkg_name

5000: || '.'
5001: || l_api_name
5002: || ':'
5003: || 'Calling Inv_Quantity_Tree_Pub.Query_Quantities');
5004: gme_debug.put_line ( g_pkg_name
5005: || '.'
5006: || l_api_name
5007: || ':'
5008: || 'Organization ID = '

Line 5010: gme_debug.put_line ( g_pkg_name

5006: || l_api_name
5007: || ':'
5008: || 'Organization ID = '
5009: || p_organization_id);
5010: gme_debug.put_line ( g_pkg_name
5011: || '.'
5012: || l_api_name
5013: || ':'
5014: || 'Inventory Item ID = '

Line 5016: gme_debug.put_line ( g_pkg_name

5012: || l_api_name
5013: || ':'
5014: || 'Inventory Item ID = '
5015: || p_inventory_item_id);
5016: gme_debug.put_line ( g_pkg_name
5017: || '.'
5018: || l_api_name
5019: || ':'
5020: || 'Subinventory = '

Line 5022: gme_debug.put_line ( g_pkg_name

5018: || l_api_name
5019: || ':'
5020: || 'Subinventory = '
5021: || p_subinventory_code);
5022: gme_debug.put_line ( g_pkg_name
5023: || '.'
5024: || l_api_name
5025: || ':'
5026: || 'Lot Number = '

Line 5028: gme_debug.put_line ( g_pkg_name

5024: || l_api_name
5025: || ':'
5026: || 'Lot Number = '
5027: || p_lot_number);
5028: gme_debug.put_line ( g_pkg_name
5029: || '.'
5030: || l_api_name
5031: || ':'
5032: || 'Locator ID = '

Line 5034: gme_debug.put_line ( g_pkg_name

5030: || l_api_name
5031: || ':'
5032: || 'Locator ID = '
5033: || p_locator_id);
5034: gme_debug.put_line ( g_pkg_name
5035: || '.'
5036: || l_api_name
5037: || ':'
5038: || 'Item Revision = '

Line 5040: gme_debug.put_line ( g_pkg_name

5036: || l_api_name
5037: || ':'
5038: || 'Item Revision = '
5039: || p_revision);
5040: gme_debug.put_line ( g_pkg_name
5041: || '.'
5042: || l_api_name
5043: || ':'
5044: || 'Tree Mode = '

Line 5046: gme_debug.put_line ( g_pkg_name

5042: || l_api_name
5043: || ':'
5044: || 'Tree Mode = '
5045: || p_tree_mode);
5046: gme_debug.put_line ( g_pkg_name
5047: || '.'
5048: || l_api_name
5049: || ':'
5050: || 'Grade = '

Line 5052: gme_debug.put_line ( g_pkg_name

5048: || l_api_name
5049: || ':'
5050: || 'Grade = '
5051: || p_grade_code);
5052: gme_debug.put_line ( g_pkg_name
5053: || '.'
5054: || l_api_name
5055: || ':'
5056: || 'Lot Expiration Date = '

Line 5107: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

5103: ,p_lpn_id => p_lpn_id
5104: ,p_transfer_locator_id => p_transfer_locator_id);
5105:
5106: IF (NVL (g_debug, 0) IN
5107: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5108: gme_debug.put_line ( g_pkg_name
5109: || '.'
5110: || l_api_name
5111: || ':'

Line 5108: gme_debug.put_line ( g_pkg_name

5104: ,p_transfer_locator_id => p_transfer_locator_id);
5105:
5106: IF (NVL (g_debug, 0) IN
5107: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5108: gme_debug.put_line ( g_pkg_name
5109: || '.'
5110: || l_api_name
5111: || ':'
5112: || 'Exiting with '

Line 5124: gme_debug.put_line ( g_pkg_name

5120: WHEN fnd_api.g_exc_unexpected_error THEN
5121: x_return_status := fnd_api.g_ret_sts_unexp_error;
5122:
5123: IF (NVL (g_debug, 0) > 0) THEN
5124: gme_debug.put_line ( g_pkg_name
5125: || '.'
5126: || l_api_name
5127: || ':'
5128: || 'UNEXPECTED:'

Line 5138: gme_debug.put_line ( g_pkg_name

5134: WHEN OTHERS THEN
5135: x_return_status := fnd_api.g_ret_sts_unexp_error;
5136:
5137: IF (NVL (g_debug, 0) > 0) THEN
5138: gme_debug.put_line ( g_pkg_name
5139: || '.'
5140: || l_api_name
5141: || ':'
5142: || 'OTHERS:'

Line 5223: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

5219: l_is_revision_control BOOLEAN := FALSE;
5220: l_is_lot_control BOOLEAN := FALSE;
5221: BEGIN
5222: IF (NVL (g_debug, 0) IN
5223: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5224: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
5225: || 'Entering');
5226: END IF;
5227:

Line 5224: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

5220: l_is_lot_control BOOLEAN := FALSE;
5221: BEGIN
5222: IF (NVL (g_debug, 0) IN
5223: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5224: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
5225: || 'Entering');
5226: END IF;
5227:
5228: IF (p_revision IS NOT NULL) THEN

Line 5236: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

5232: IF (p_lot_number IS NOT NULL) THEN
5233: l_is_lot_control := TRUE;
5234: END IF;
5235:
5236: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
5237: gme_debug.put_line
5238: ( g_pkg_name
5239: || '.'
5240: || l_api_name

Line 5237: gme_debug.put_line

5233: l_is_lot_control := TRUE;
5234: END IF;
5235:
5236: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
5237: gme_debug.put_line
5238: ( g_pkg_name
5239: || '.'
5240: || l_api_name
5241: || ':'

Line 5243: gme_debug.put_line ( g_pkg_name

5239: || '.'
5240: || l_api_name
5241: || ':'
5242: || 'Calling Inv_Quantity_Tree_Pub.Update_Quantities');
5243: gme_debug.put_line ( g_pkg_name
5244: || '.'
5245: || l_api_name
5246: || ':'
5247: || 'Organization ID = '

Line 5249: gme_debug.put_line ( g_pkg_name

5245: || l_api_name
5246: || ':'
5247: || 'Organization ID = '
5248: || p_organization_id);
5249: gme_debug.put_line ( g_pkg_name
5250: || '.'
5251: || l_api_name
5252: || ':'
5253: || 'Inventory Item ID = '

Line 5255: gme_debug.put_line ( g_pkg_name

5251: || l_api_name
5252: || ':'
5253: || 'Inventory Item ID = '
5254: || p_inventory_item_id);
5255: gme_debug.put_line ( g_pkg_name
5256: || '.'
5257: || l_api_name
5258: || ':'
5259: || 'Subinventory = '

Line 5261: gme_debug.put_line ( g_pkg_name

5257: || l_api_name
5258: || ':'
5259: || 'Subinventory = '
5260: || p_subinventory_code);
5261: gme_debug.put_line ( g_pkg_name
5262: || '.'
5263: || l_api_name
5264: || ':'
5265: || 'Lot Number = '

Line 5267: gme_debug.put_line ( g_pkg_name

5263: || l_api_name
5264: || ':'
5265: || 'Lot Number = '
5266: || p_lot_number);
5267: gme_debug.put_line ( g_pkg_name
5268: || '.'
5269: || l_api_name
5270: || ':'
5271: || 'Locator ID = '

Line 5273: gme_debug.put_line ( g_pkg_name

5269: || l_api_name
5270: || ':'
5271: || 'Locator ID = '
5272: || p_locator_id);
5273: gme_debug.put_line ( g_pkg_name
5274: || '.'
5275: || l_api_name
5276: || ':'
5277: || 'Item Revision = '

Line 5279: gme_debug.put_line ( g_pkg_name

5275: || l_api_name
5276: || ':'
5277: || 'Item Revision = '
5278: || p_revision);
5279: gme_debug.put_line ( g_pkg_name
5280: || '.'
5281: || l_api_name
5282: || ':'
5283: || 'Tree Mode = '

Line 5285: gme_debug.put_line ( g_pkg_name

5281: || l_api_name
5282: || ':'
5283: || 'Tree Mode = '
5284: || p_tree_mode);
5285: gme_debug.put_line ( g_pkg_name
5286: || '.'
5287: || l_api_name
5288: || ':'
5289: || 'Grade = '

Line 5291: gme_debug.put_line ( g_pkg_name

5287: || l_api_name
5288: || ':'
5289: || 'Grade = '
5290: || p_grade_code);
5291: gme_debug.put_line ( g_pkg_name
5292: || '.'
5293: || l_api_name
5294: || ':'
5295: || 'Lot Expiration Date = '

Line 5298: gme_debug.put_line ( g_pkg_name

5294: || ':'
5295: || 'Lot Expiration Date = '
5296: || TO_CHAR (p_lot_expiration_date
5297: ,'MM/DD/YYYY HH24:MI:SS') );
5298: gme_debug.put_line ( g_pkg_name
5299: || '.'
5300: || l_api_name
5301: || ':'
5302: || 'Quantity Type = '

Line 5304: gme_debug.put_line ( g_pkg_name

5300: || l_api_name
5301: || ':'
5302: || 'Quantity Type = '
5303: || p_quantity_type);
5304: gme_debug.put_line ( g_pkg_name
5305: || '.'
5306: || l_api_name
5307: || ':'
5308: || 'Primary Quantity = '

Line 5310: gme_debug.put_line ( g_pkg_name

5306: || l_api_name
5307: || ':'
5308: || 'Primary Quantity = '
5309: || p_primary_quantity);
5310: gme_debug.put_line ( g_pkg_name
5311: || '.'
5312: || l_api_name
5313: || ':'
5314: || 'Secondary Quantity = '

Line 5363: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

5359: ,p_transfer_locator_id => p_transfer_locator_id
5360: ,p_containerized => p_containerized);
5361:
5362: IF (NVL (g_debug, 0) IN
5363: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5364: gme_debug.put_line ( g_pkg_name
5365: || '.'
5366: || l_api_name
5367: || ':'

Line 5364: gme_debug.put_line ( g_pkg_name

5360: ,p_containerized => p_containerized);
5361:
5362: IF (NVL (g_debug, 0) IN
5363: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5364: gme_debug.put_line ( g_pkg_name
5365: || '.'
5366: || l_api_name
5367: || ':'
5368: || 'Exiting with '

Line 5380: gme_debug.put_line ( g_pkg_name

5376: WHEN fnd_api.g_exc_unexpected_error THEN
5377: x_return_status := fnd_api.g_ret_sts_unexp_error;
5378:
5379: IF (NVL (g_debug, 0) > 0) THEN
5380: gme_debug.put_line ( g_pkg_name
5381: || '.'
5382: || l_api_name
5383: || ':'
5384: || 'UNEXPECTED:'

Line 5394: gme_debug.put_line ( g_pkg_name

5390: WHEN OTHERS THEN
5391: x_return_status := fnd_api.g_ret_sts_unexp_error;
5392:
5393: IF (NVL (g_debug, 0) > 0) THEN
5394: gme_debug.put_line ( g_pkg_name
5395: || '.'
5396: || l_api_name
5397: || ':'
5398: || 'OTHERS:'

Line 5454: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

5450: RETURN FALSE;
5451: EXCEPTION
5452: WHEN OTHERS THEN
5453: IF (NVL (g_debug, 0) > 0) THEN
5454: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5455: END IF;
5456: RETURN FALSE;
5457: END is_lot_expired;
5458:

Line 5463: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

5459: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
5460: x_return_status OUT NOCOPY VARCHAR2) IS
5461: l_api_name CONSTANT VARCHAR2 (30) := 'insert_txn_inter_hdr';
5462: BEGIN
5463: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5464: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
5465: END IF;
5466: x_return_status := fnd_api.g_ret_sts_success;
5467: INSERT INTO mtl_transactions_interface

Line 5464: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');

5460: x_return_status OUT NOCOPY VARCHAR2) IS
5461: l_api_name CONSTANT VARCHAR2 (30) := 'insert_txn_inter_hdr';
5462: BEGIN
5463: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5464: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
5465: END IF;
5466: x_return_status := fnd_api.g_ret_sts_success;
5467: INSERT INTO mtl_transactions_interface
5468: (transaction_interface_id

Line 5590: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

5586: ,p_mmti_rec.attribute15
5587: ,p_mmti_rec.attribute_category -- Bug 12881196 Add missing attribute columns so that they get saved.
5588: ,p_mmti_rec.transfer_lpn_id
5589: ,p_mmti_rec.lpn_id); -- Bug 6437252 LPN support
5590: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5591: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Exiting');
5592: END IF;
5593: EXCEPTION
5594: WHEN OTHERS THEN

Line 5591: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Exiting');

5587: ,p_mmti_rec.attribute_category -- Bug 12881196 Add missing attribute columns so that they get saved.
5588: ,p_mmti_rec.transfer_lpn_id
5589: ,p_mmti_rec.lpn_id); -- Bug 6437252 LPN support
5590: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
5591: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Exiting');
5592: END IF;
5593: EXCEPTION
5594: WHEN OTHERS THEN
5595: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 5597: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

5593: EXCEPTION
5594: WHEN OTHERS THEN
5595: x_return_status := fnd_api.g_ret_sts_unexp_error;
5596: IF (NVL (g_debug, 0) > 0) THEN
5597: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5598: END IF;
5599: END insert_txn_inter_hdr;
5600:
5601: -- nsinghi bug#5176319. Added this proc.

Line 5649: IF (g_debug <= gme_debug.g_log_statement) THEN

5645:
5646: BEGIN
5647: x_return_status := fnd_api.g_ret_sts_success;
5648:
5649: IF (g_debug <= gme_debug.g_log_statement) THEN
5650: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
5651: || 'Entering with transaction '||p_transaction_id);
5652: END IF;
5653:

Line 5650: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

5646: BEGIN
5647: x_return_status := fnd_api.g_ret_sts_success;
5648:
5649: IF (g_debug <= gme_debug.g_log_statement) THEN
5650: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
5651: || 'Entering with transaction '||p_transaction_id);
5652: END IF;
5653:
5654: IF p_transaction_id IS NULL THEN

Line 5657: IF (g_debug <= gme_debug.g_log_statement) THEN

5653:
5654: IF p_transaction_id IS NULL THEN
5655: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
5656:
5657: IF (g_debug <= gme_debug.g_log_statement) THEN
5658: gme_debug.put_line ( g_pkg_name
5659: || '.'
5660: || l_api_name
5661: || ':'

Line 5658: gme_debug.put_line ( g_pkg_name

5654: IF p_transaction_id IS NULL THEN
5655: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
5656:
5657: IF (g_debug <= gme_debug.g_log_statement) THEN
5658: gme_debug.put_line ( g_pkg_name
5659: || '.'
5660: || l_api_name
5661: || ':'
5662: || 'TRANSACTION ID NEEDED FOR RETRIEVAL');

Line 5671: IF (g_debug <= gme_debug.g_log_statement) THEN

5667: OPEN cur_get_transaction (l_transaction_id);
5668: FETCH cur_get_transaction
5669: INTO x_mmt_rec;
5670: IF cur_get_transaction%FOUND THEN
5671: IF (g_debug <= gme_debug.g_log_statement) THEN
5672: gme_debug.put_line ( g_pkg_name
5673: || '.'
5674: || l_api_name
5675: || ':'

Line 5672: gme_debug.put_line ( g_pkg_name

5668: FETCH cur_get_transaction
5669: INTO x_mmt_rec;
5670: IF cur_get_transaction%FOUND THEN
5671: IF (g_debug <= gme_debug.g_log_statement) THEN
5672: gme_debug.put_line ( g_pkg_name
5673: || '.'
5674: || l_api_name
5675: || ':'
5676: || 'TRANSACTIONS found for '

Line 5684: IF (g_debug <= gme_debug.g_log_statement) THEN

5680: ,x_mmln_tbl => x_mmln_tbl
5681: ,x_return_status => l_return_status);
5682:
5683: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5684: IF (g_debug <= gme_debug.g_log_statement) THEN
5685: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
5686: || 'error from get lot trans');
5687: END IF;
5688: RAISE fnd_api.g_exc_error;

Line 5685: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

5681: ,x_return_status => l_return_status);
5682:
5683: IF l_return_status <> fnd_api.g_ret_sts_success THEN
5684: IF (g_debug <= gme_debug.g_log_statement) THEN
5685: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
5686: || 'error from get lot trans');
5687: END IF;
5688: RAISE fnd_api.g_exc_error;
5689: END IF;

Line 5697: IF (g_debug <= gme_debug.g_log_statement) THEN

5693: RAISE fnd_api.g_exc_error;
5694: END IF;
5695: CLOSE cur_get_transaction;
5696:
5697: IF (g_debug <= gme_debug.g_log_statement) THEN
5698: gme_debug.put_line ( g_pkg_name
5699: || '.'
5700: || l_api_name
5701: || ':'

Line 5698: gme_debug.put_line ( g_pkg_name

5694: END IF;
5695: CLOSE cur_get_transaction;
5696:
5697: IF (g_debug <= gme_debug.g_log_statement) THEN
5698: gme_debug.put_line ( g_pkg_name
5699: || '.'
5700: || l_api_name
5701: || ':'
5702: || 'TRANSACTION '

Line 5706: IF (g_debug <= gme_debug.g_log_statement) THEN

5702: || 'TRANSACTION '
5703: || x_mmt_rec.transaction_id);
5704: END IF;
5705:
5706: IF (g_debug <= gme_debug.g_log_statement) THEN
5707: gme_debug.put_line ( g_pkg_name
5708: || '.'
5709: || l_api_name
5710: || ':'

Line 5707: gme_debug.put_line ( g_pkg_name

5703: || x_mmt_rec.transaction_id);
5704: END IF;
5705:
5706: IF (g_debug <= gme_debug.g_log_statement) THEN
5707: gme_debug.put_line ( g_pkg_name
5708: || '.'
5709: || l_api_name
5710: || ':'
5711: || 'Exiting with '

Line 5723: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

5719: WHEN OTHERS THEN
5720: x_return_status := fnd_api.g_ret_sts_unexp_error;
5721: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5722:
5723: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5724: gme_debug.put_line ( g_pkg_name
5725: || '.'
5726: || l_api_name
5727: || ':'

Line 5724: gme_debug.put_line ( g_pkg_name

5720: x_return_status := fnd_api.g_ret_sts_unexp_error;
5721: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5722:
5723: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5724: gme_debug.put_line ( g_pkg_name
5725: || '.'
5726: || l_api_name
5727: || ':'
5728: || 'WHEN OTHERS:'

Line 5750: IF (g_debug <= gme_debug.g_log_procedure) THEN

5746: l_date DATE := NULL ; /* Bug 15879394 Initialized the variable */
5747: expired_lot EXCEPTION;
5748: invalid_lot EXCEPTION;
5749: BEGIN
5750: IF (g_debug <= gme_debug.g_log_procedure) THEN
5751: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering with organization_id = '||p_organization_id
5752: ||' inventory_item_id = '||p_inventory_item_id||' lot_number = '||p_lot_number);
5753: END IF;
5754: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 5751: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering with organization_id = '||p_organization_id

5747: expired_lot EXCEPTION;
5748: invalid_lot EXCEPTION;
5749: BEGIN
5750: IF (g_debug <= gme_debug.g_log_procedure) THEN
5751: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering with organization_id = '||p_organization_id
5752: ||' inventory_item_id = '||p_inventory_item_id||' lot_number = '||p_lot_number);
5753: END IF;
5754: x_return_status := FND_API.G_RET_STS_SUCCESS;
5755: OPEN Cur_get_lot;

Line 5768: IF (g_debug <= gme_debug.g_log_procedure) THEN

5764: CLOSE Cur_get_lot;
5765: IF (l_date IS NOT NULL AND l_date < sysdate) THEN
5766: RAISE expired_lot;
5767: END IF;
5768: IF (g_debug <= gme_debug.g_log_procedure) THEN
5769: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Normal Exiting');
5770: END IF;
5771: EXCEPTION
5772: WHEN expired_lot THEN

Line 5769: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Normal Exiting');

5765: IF (l_date IS NOT NULL AND l_date < sysdate) THEN
5766: RAISE expired_lot;
5767: END IF;
5768: IF (g_debug <= gme_debug.g_log_procedure) THEN
5769: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Normal Exiting');
5770: END IF;
5771: EXCEPTION
5772: WHEN expired_lot THEN
5773: gme_common_pvt.log_message(p_message_code => 'INV_LOT_EXPIRED',

Line 5783: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

5779: p_product_code => 'INV');
5780: WHEN OTHERS THEN
5781: x_return_status := fnd_api.g_ret_sts_unexp_error;
5782: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5783: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5784: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5785: END IF;
5786: END validate_lot_for_ing;
5787:

Line 5784: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

5780: WHEN OTHERS THEN
5781: x_return_status := fnd_api.g_ret_sts_unexp_error;
5782: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5783: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5784: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5785: END IF;
5786: END validate_lot_for_ing;
5787:
5788: /* Added for bug 5597385 */

Line 5816: IF (g_debug <= gme_debug.g_log_statement) THEN

5812: l_api_name CONSTANT VARCHAR2(30) := 'GMO_PRE_PROCESS_VAL';
5813: BEGIN
5814: -- Initially let us assign the return status to success
5815: x_return_status := fnd_api.g_ret_sts_success;
5816: IF (g_debug <= gme_debug.g_log_statement) THEN
5817: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
5818: END IF;
5819: IF (g_debug <= gme_debug.g_log_statement) THEN
5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);

Line 5817: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');

5813: BEGIN
5814: -- Initially let us assign the return status to success
5815: x_return_status := fnd_api.g_ret_sts_success;
5816: IF (g_debug <= gme_debug.g_log_statement) THEN
5817: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
5818: END IF;
5819: IF (g_debug <= gme_debug.g_log_statement) THEN
5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);

Line 5819: IF (g_debug <= gme_debug.g_log_statement) THEN

5815: x_return_status := fnd_api.g_ret_sts_success;
5816: IF (g_debug <= gme_debug.g_log_statement) THEN
5817: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
5818: END IF;
5819: IF (g_debug <= gme_debug.g_log_statement) THEN
5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);

Line 5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);

5816: IF (g_debug <= gme_debug.g_log_statement) THEN
5817: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
5818: END IF;
5819: IF (g_debug <= gme_debug.g_log_statement) THEN
5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);

Line 5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);

5817: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
5818: END IF;
5819: IF (g_debug <= gme_debug.g_log_statement) THEN
5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);

Line 5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);

5818: END IF;
5819: IF (g_debug <= gme_debug.g_log_statement) THEN
5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);

Line 5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);

5819: IF (g_debug <= gme_debug.g_log_statement) THEN
5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
5827: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);

Line 5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);

5820: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
5827: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
5828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);

Line 5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);

5821: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
5827: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
5828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
5829: END IF;

Line 5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);

5822: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
5827: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
5828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
5829: END IF;
5830: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN

Line 5827: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);

5823: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
5827: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
5828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
5829: END IF;
5830: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN
5831: l_batch_hdr_rec.batch_id := p_mmti_rec.transaction_source_id;

Line 5828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);

5824: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
5825: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
5826: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
5827: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
5828: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
5829: END IF;
5830: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN
5831: l_batch_hdr_rec.batch_id := p_mmti_rec.transaction_source_id;
5832: IF NOT gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec) THEN

Line 5886: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

5882: FETCH cur_get_item_rec INTO l_item_rec;
5883: IF cur_get_item_rec%NOTFOUND THEN
5884: CLOSE cur_get_item_rec;
5885: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5886: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5887: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
5888: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
5889: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
5890: END IF;

Line 5887: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');

5883: IF cur_get_item_rec%NOTFOUND THEN
5884: CLOSE cur_get_item_rec;
5885: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5886: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5887: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
5888: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
5889: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
5890: END IF;
5891: RAISE item_not_found;

Line 5888: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));

5884: CLOSE cur_get_item_rec;
5885: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5886: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5887: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
5888: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
5889: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
5890: END IF;
5891: RAISE item_not_found;
5892: END IF;

Line 5889: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));

5885: gme_common_pvt.log_message ('PM_INVALID_ITEM');
5886: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5887: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
5888: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
5889: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
5890: END IF;
5891: RAISE item_not_found;
5892: END IF;
5893: CLOSE cur_get_item_rec;

Line 5894: IF (g_debug <= gme_debug.g_log_statement) THEN

5890: END IF;
5891: RAISE item_not_found;
5892: END IF;
5893: CLOSE cur_get_item_rec;
5894: IF (g_debug <= gme_debug.g_log_statement) THEN
5895: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
5896: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
5897: END IF;
5898:

Line 5895: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);

5891: RAISE item_not_found;
5892: END IF;
5893: CLOSE cur_get_item_rec;
5894: IF (g_debug <= gme_debug.g_log_statement) THEN
5895: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
5896: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
5897: END IF;
5898:
5899: /* Bug 5358129 for ingredients lots should exist */

Line 5896: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);

5892: END IF;
5893: CLOSE cur_get_item_rec;
5894: IF (g_debug <= gme_debug.g_log_statement) THEN
5895: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
5896: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
5897: END IF;
5898:
5899: /* Bug 5358129 for ingredients lots should exist */
5900: 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

Line 5913: IF (g_debug <= gme_debug.g_log_statement) THEN

5909: END LOOP;
5910: END IF;
5911: -- if return transaction then check qty was issued and return not more than issued qty
5912: 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
5913: IF (g_debug <= gme_debug.g_log_statement) THEN
5914: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);
5915: END IF;
5916: IF l_item_rec.lot_control_code = 1 THEN
5917: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 5914: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);

5910: END IF;
5911: -- if return transaction then check qty was issued and return not more than issued qty
5912: 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
5913: IF (g_debug <= gme_debug.g_log_statement) THEN
5914: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);
5915: END IF;
5916: IF l_item_rec.lot_control_code = 1 THEN
5917: IF (g_debug <= gme_debug.g_log_statement) THEN
5918: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is NOT lot_control: '|| l_item_rec.lot_control_code);

Line 5917: IF (g_debug <= gme_debug.g_log_statement) THEN

5913: IF (g_debug <= gme_debug.g_log_statement) THEN
5914: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);
5915: END IF;
5916: IF l_item_rec.lot_control_code = 1 THEN
5917: IF (g_debug <= gme_debug.g_log_statement) THEN
5918: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is NOT lot_control: '|| l_item_rec.lot_control_code);
5919: END IF;
5920: get_returnable_qty(p_mmti_rec => p_mmti_rec
5921: ,p_lot_number => NULL

Line 5918: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is NOT lot_control: '|| l_item_rec.lot_control_code);

5914: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);
5915: END IF;
5916: IF l_item_rec.lot_control_code = 1 THEN
5917: IF (g_debug <= gme_debug.g_log_statement) THEN
5918: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is NOT lot_control: '|| l_item_rec.lot_control_code);
5919: END IF;
5920: get_returnable_qty(p_mmti_rec => p_mmti_rec
5921: ,p_lot_number => NULL
5922: ,p_lot_control => l_item_rec.lot_control_code

Line 5928: IF (g_debug <= gme_debug.g_log_statement) THEN

5924: ,x_return_status => x_return_status);
5925: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5926: RAISE fnd_api.g_exc_unexpected_error;
5927: END IF;
5928: IF (g_debug <= gme_debug.g_log_statement) THEN
5929: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);
5930: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
5931: END IF;
5932: IF ABS (l_available_qty) < ABS (p_mmti_rec.transaction_quantity) THEN

Line 5929: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);

5925: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5926: RAISE fnd_api.g_exc_unexpected_error;
5927: END IF;
5928: IF (g_debug <= gme_debug.g_log_statement) THEN
5929: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);
5930: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
5931: END IF;
5932: IF ABS (l_available_qty) < ABS (p_mmti_rec.transaction_quantity) THEN
5933: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

Line 5930: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);

5926: RAISE fnd_api.g_exc_unexpected_error;
5927: END IF;
5928: IF (g_debug <= gme_debug.g_log_statement) THEN
5929: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);
5930: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
5931: END IF;
5932: IF ABS (l_available_qty) < ABS (p_mmti_rec.transaction_quantity) THEN
5933: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
5934: RAISE fnd_api.g_exc_error;

Line 5937: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

5933: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
5934: RAISE fnd_api.g_exc_error;
5935: END IF;
5936: ELSE /* Lot Control */
5937: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5938: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is lot control: '|| l_item_rec.lot_control_code);
5939: END IF;
5940: FOR i IN 1..p_mmli_tbl.COUNT LOOP
5941: get_returnable_qty(p_mmti_rec => p_mmti_rec

Line 5938: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is lot control: '|| l_item_rec.lot_control_code);

5934: RAISE fnd_api.g_exc_error;
5935: END IF;
5936: ELSE /* Lot Control */
5937: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5938: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is lot control: '|| l_item_rec.lot_control_code);
5939: END IF;
5940: FOR i IN 1..p_mmli_tbl.COUNT LOOP
5941: get_returnable_qty(p_mmti_rec => p_mmti_rec
5942: ,p_lot_number => p_mmli_tbl(i).lot_number

Line 5949: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

5945: ,x_return_status => x_return_status);
5946: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
5947: RAISE fnd_api.g_exc_unexpected_error;
5948: END IF;
5949: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5950: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);
5951: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
5952: END IF;
5953: IF ABS(l_available_qty) < ABS(p_mmli_tbl(i).transaction_quantity) THEN

Line 5950: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);

5946: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
5947: RAISE fnd_api.g_exc_unexpected_error;
5948: END IF;
5949: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5950: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);
5951: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
5952: END IF;
5953: IF ABS(l_available_qty) < ABS(p_mmli_tbl(i).transaction_quantity) THEN
5954: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

Line 5951: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);

5947: RAISE fnd_api.g_exc_unexpected_error;
5948: END IF;
5949: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
5950: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);
5951: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
5952: END IF;
5953: IF ABS(l_available_qty) < ABS(p_mmli_tbl(i).transaction_quantity) THEN
5954: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
5955: RAISE fnd_api.g_exc_error;

Line 5961: IF (g_debug <= gme_debug.g_log_statement) THEN

5957: END LOOP;
5958: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */
5959: END IF; /* IF transaction_type_id in RETURNS */
5960: END IF; /* update_inventory_ind = 'Y' */
5961: IF (g_debug <= gme_debug.g_log_statement) THEN
5962: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Exiting with '|| x_return_status);
5963: END IF;
5964: EXCEPTION
5965: WHEN lot_val_err THEN

Line 5962: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Exiting with '|| x_return_status);

5958: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */
5959: END IF; /* IF transaction_type_id in RETURNS */
5960: END IF; /* update_inventory_ind = 'Y' */
5961: IF (g_debug <= gme_debug.g_log_statement) THEN
5962: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Exiting with '|| x_return_status);
5963: END IF;
5964: EXCEPTION
5965: WHEN lot_val_err THEN
5966: x_return_status := l_return_status;

Line 5974: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

5970: x_return_status := fnd_api.g_ret_sts_unexp_error;
5971: WHEN OTHERS THEN
5972: x_return_status := fnd_api.g_ret_sts_unexp_error;
5973: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5974: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5975: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5976: END IF;
5977: END gmo_pre_process_val;
5978: END gme_transactions_pvt;

Line 5975: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);

5971: WHEN OTHERS THEN
5972: x_return_status := fnd_api.g_ret_sts_unexp_error;
5973: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
5974: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
5975: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
5976: END IF;
5977: END gmo_pre_process_val;
5978: END gme_transactions_pvt;
5979: