APPS.GME_TRANSACTIONS_PVT dependencies on GME_DEBUG

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

68: BEGIN
69: /* Initially let us assign the return status to success */
70: x_return_status := fnd_api.g_ret_sts_success;
71:
72: IF (g_debug <= gme_debug.g_log_statement) THEN
73: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
74: || 'Entering');
75: END IF;
76:

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

69: /* Initially let us assign the return status to success */
70: x_return_status := fnd_api.g_ret_sts_success;
71:
72: IF (g_debug <= gme_debug.g_log_statement) THEN
73: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
74: || 'Entering');
75: END IF;
76:
77: l_mmti_rec := p_mmti_rec;

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

84: ,x_material_detail => l_mat_dtl_rec) THEN
85: RAISE fnd_api.g_exc_error;
86: END IF;
87:
88: IF (g_debug <= gme_debug.g_log_statement) THEN
89: gme_debug.put_line ( g_pkg_name
90: || '.'
91: || l_api_name
92: || ':'

Line 89: gme_debug.put_line ( g_pkg_name

85: RAISE fnd_api.g_exc_error;
86: END IF;
87:
88: IF (g_debug <= gme_debug.g_log_statement) THEN
89: gme_debug.put_line ( g_pkg_name
90: || '.'
91: || l_api_name
92: || ':'
93: || 'material det_id'

Line 95: gme_debug.put_line ( g_pkg_name

91: || l_api_name
92: || ':'
93: || 'material det_id'
94: || l_mat_dtl_rec.material_detail_id);
95: gme_debug.put_line ( g_pkg_name
96: || '.'
97: || l_api_name
98: || ':'
99: || 'batch_id'

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

117: RAISE build_txn_inter_err;
118: END IF;
119: l_assign_phantom := 0;
120:
121: IF (g_debug <= gme_debug.g_log_statement) THEN
122: gme_debug.put_line ( g_pkg_name
123: || '.'
124: || l_api_name
125: || ':'

Line 122: gme_debug.put_line ( g_pkg_name

118: END IF;
119: l_assign_phantom := 0;
120:
121: IF (g_debug <= gme_debug.g_log_statement) THEN
122: gme_debug.put_line ( g_pkg_name
123: || '.'
124: || l_api_name
125: || ':'
126: || 'status after build : '

Line 128: gme_debug.put_line ( g_pkg_name

124: || l_api_name
125: || ':'
126: || 'status after build : '
127: || l_return_status);
128: gme_debug.put_line ( g_pkg_name
129: || '.'
130: || l_api_name
131: || ':'
132: || 'x_mmti_rec.transaction_interface_id : '

Line 134: gme_debug.put_line ( g_pkg_name

130: || l_api_name
131: || ':'
132: || 'x_mmti_rec.transaction_interface_id : '
133: || x_mmti_rec.transaction_interface_id);
134: gme_debug.put_line ( g_pkg_name
135: || '.'
136: || l_api_name
137: || ':'
138: || 'x_mmti_rec.transaction_reference : '

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

147: m_mmli_tbl := p_mmli_tbl;
148: m_mmti_rec.trx_source_line_id := l_mat_dtl_rec.phantom_line_id;
149: m_mat_dtl_rec.material_detail_id := m_mmti_rec.trx_source_line_id;
150:
151: IF (g_debug <= gme_debug.g_log_statement) THEN
152: gme_debug.put_line ( g_pkg_name
153: || '.'
154: || l_api_name
155: || ':'

Line 152: gme_debug.put_line ( g_pkg_name

148: m_mmti_rec.trx_source_line_id := l_mat_dtl_rec.phantom_line_id;
149: m_mat_dtl_rec.material_detail_id := m_mmti_rec.trx_source_line_id;
150:
151: IF (g_debug <= gme_debug.g_log_statement) THEN
152: gme_debug.put_line ( g_pkg_name
153: || '.'
154: || l_api_name
155: || ':'
156: || 'for phantom line id:'

Line 158: gme_debug.put_line ( g_pkg_name

154: || l_api_name
155: || ':'
156: || 'for phantom line id:'
157: || l_mat_dtl_rec.phantom_line_id);
158: gme_debug.put_line ( g_pkg_name
159: || '.'
160: || l_api_name
161: || ':'
162: || ' original transaction_type_id :'

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

215: gme_common_pvt.g_byprod_comp_txn_action;
216: --(31)
217: END IF;
218:
219: IF (g_debug <= gme_debug.g_log_statement) THEN
220: gme_debug.put_line ( g_pkg_name
221: || '.'
222: || l_api_name
223: || ':'

Line 220: gme_debug.put_line ( g_pkg_name

216: --(31)
217: END IF;
218:
219: IF (g_debug <= gme_debug.g_log_statement) THEN
220: gme_debug.put_line ( g_pkg_name
221: || '.'
222: || l_api_name
223: || ':'
224: || 'calling build for phantom');

Line 225: gme_debug.put_line ( g_pkg_name

221: || '.'
222: || l_api_name
223: || ':'
224: || 'calling build for phantom');
225: gme_debug.put_line ( g_pkg_name
226: || '.'
227: || l_api_name
228: || ':'
229: || 'transaction_type_id for phantom :'

Line 231: gme_debug.put_line ( g_pkg_name

227: || l_api_name
228: || ':'
229: || 'transaction_type_id for phantom :'
230: || m_mmti_rec.transaction_type_id);
231: gme_debug.put_line ( g_pkg_name
232: || '.'
233: || l_api_name
234: || ':'
235: || 'transaction_action_id for phantom :'

Line 237: gme_debug.put_line ( g_pkg_name

233: || l_api_name
234: || ':'
235: || 'transaction_action_id for phantom :'
236: || m_mmti_rec.transaction_action_id);
237: gme_debug.put_line ( g_pkg_name
238: || '.'
239: || l_api_name
240: || ':'
241: || 'm_mat_dtl_rec.phantom_line_id :'

Line 243: gme_debug.put_line ( g_pkg_name

239: || l_api_name
240: || ':'
241: || 'm_mat_dtl_rec.phantom_line_id :'
242: || m_mat_dtl_rec.phantom_line_id);
243: gme_debug.put_line ( g_pkg_name
244: || '.'
245: || l_api_name
246: || ':'
247: || 'x_mmti_rec.transaction_interface_id :'

Line 249: gme_debug.put_line ( g_pkg_name

245: || l_api_name
246: || ':'
247: || 'x_mmti_rec.transaction_interface_id :'
248: || x_mmti_rec.transaction_interface_id);
249: gme_debug.put_line ( g_pkg_name
250: || '.'
251: || l_api_name
252: || ':'
253: || 'x_mmti_rec.transaction_reference :'

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

273: IF l_return_status <> fnd_api.g_ret_sts_success THEN
274: RAISE build_txn_inter_err;
275: END IF;
276:
277: IF (g_debug <= gme_debug.g_log_statement) THEN
278: gme_debug.put_line ( g_pkg_name
279: || '.'
280: || l_api_name
281: || ':'

Line 278: gme_debug.put_line ( g_pkg_name

274: RAISE build_txn_inter_err;
275: END IF;
276:
277: IF (g_debug <= gme_debug.g_log_statement) THEN
278: gme_debug.put_line ( g_pkg_name
279: || '.'
280: || l_api_name
281: || ':'
282: || 'status from build for phantom '

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

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

Line 291: gme_debug.put_line ( g_pkg_name

287:
288: -- code for moving the data to temp
289: IF gme_common_pvt.g_move_to_temp = fnd_api.g_true THEN
290: IF (g_debug <= gme_debug.g_log_statement) THEN
291: gme_debug.put_line ( g_pkg_name
292: || '.'
293: || l_api_name
294: || ':'
295: || 'calling validate transactions:'

Line 303: gme_debug.put_line ( g_pkg_name

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

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

322: ,x_msg_count => l_msg_count
323: ,x_msg_data => l_msg_data
324: ,x_trans_count => l_txn_count
325: ,p_free_tree => fnd_api.g_false);
326: IF (g_debug <= gme_debug.g_log_statement) THEN
327: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
328: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
329: select count(*) into l_cnt_temp
330: from mtl_material_transactions_temp

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

323: ,x_msg_data => l_msg_data
324: ,x_trans_count => l_txn_count
325: ,p_free_tree => fnd_api.g_false);
326: IF (g_debug <= gme_debug.g_log_statement) THEN
327: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
328: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
329: select count(*) into l_cnt_temp
330: from mtl_material_transactions_temp
331: where transaction_header_id= gme_common_pvt.g_transaction_header_id;

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

324: ,x_trans_count => l_txn_count
325: ,p_free_tree => fnd_api.g_false);
326: IF (g_debug <= gme_debug.g_log_statement) THEN
327: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'after validate transactions:'|| l_ret);
328: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'x_trans_count:'|| l_txn_count);
329: select count(*) into l_cnt_temp
330: from mtl_material_transactions_temp
331: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
332: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);

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

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

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

331: where transaction_header_id= gme_common_pvt.g_transaction_header_id;
332: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
333: END IF;
334: IF l_ret < 0 THEN
335: IF (g_debug <= gme_debug.g_log_statement) THEN
336: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');
337: END IF;
338: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
339: IF (l_msg_data IS NOT NULL) THEN

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

332: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'count from temp table:'|| l_cnt_temp);
333: END IF;
334: IF l_ret < 0 THEN
335: IF (g_debug <= gme_debug.g_log_statement) THEN
336: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');
337: END IF;
338: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
339: IF (l_msg_data IS NOT NULL) THEN
340: IF (g_debug <= gme_debug.g_log_statement) THEN

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

336: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from validate transactions');
337: END IF;
338: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
339: IF (l_msg_data IS NOT NULL) THEN
340: IF (g_debug <= gme_debug.g_log_statement) THEN
341: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_msg_data is: '||l_msg_data);
342: END IF;
343: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
344: ,p_product_code => 'FND'

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

337: END IF;
338: /* Jalaj Srivastava Bug 5001915 add msg returned to stack */
339: IF (l_msg_data IS NOT NULL) THEN
340: IF (g_debug <= gme_debug.g_log_statement) THEN
341: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'l_msg_data is: '||l_msg_data);
342: END IF;
343: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
344: ,p_product_code => 'FND'
345: ,p_token1_name => 'MESSAGE'

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

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

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

349: FOR get_msgs IN (SELECT error_explanation FROM mtl_transactions_interface
350: WHERE transaction_header_id = gme_common_pvt.g_transaction_header_id
351: AND error_explanation IS NOT NULL) LOOP
352: IF (g_debug <= gme_debug.g_log_statement) THEN
353: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'error_explanation is: '||get_msgs.error_explanation);
354: END IF;
355: gme_common_pvt.log_message(p_message_code => 'FND_GENERIC_MESSAGE'
356: ,p_product_code => 'FND'
357: ,p_token1_name => 'MESSAGE'

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

360: END IF;
361: RAISE fnd_api.g_exc_error;
362: END IF;
363: END IF;
364: IF (g_debug <= gme_debug.g_log_statement) THEN
365: gme_debug.put_line ( g_pkg_name
366: || '.'
367: || l_api_name
368: || ':'

Line 365: gme_debug.put_line ( g_pkg_name

361: RAISE fnd_api.g_exc_error;
362: END IF;
363: END IF;
364: IF (g_debug <= gme_debug.g_log_statement) THEN
365: gme_debug.put_line ( g_pkg_name
366: || '.'
367: || l_api_name
368: || ':'
369: || 'Exiting with '

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

370: || x_return_status);
371: END IF;
372: EXCEPTION
373: WHEN build_txn_inter_err THEN
374: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'
375: ||' error from build_txn_inter');
376: x_return_status := l_return_status;
377: WHEN fnd_api.g_exc_error THEN
378: x_return_status := fnd_api.g_ret_sts_error;

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

381: WHEN OTHERS THEN
382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
384:
385: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
386: gme_debug.put_line ( g_pkg_name
387: || '.'
388: || l_api_name
389: || ':'

Line 386: gme_debug.put_line ( g_pkg_name

382: x_return_status := fnd_api.g_ret_sts_unexp_error;
383: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
384:
385: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
386: gme_debug.put_line ( g_pkg_name
387: || '.'
388: || l_api_name
389: || ':'
390: || 'WHEN OTHERS:'

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

431: BEGIN
432: --Initially let us assign the return status to success
433: x_return_status := fnd_api.g_ret_sts_success;
434:
435: IF (g_debug <= gme_debug.g_log_statement) THEN
436: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
437: || 'Entering');
438: END IF;
439:

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

432: --Initially let us assign the return status to success
433: x_return_status := fnd_api.g_ret_sts_success;
434:
435: IF (g_debug <= gme_debug.g_log_statement) THEN
436: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
437: || 'Entering');
438: END IF;
439:
440: l_mmti_rec := p_mmti_rec;

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

440: l_mmti_rec := p_mmti_rec;
441: l_mmli_tbl := p_mmli_tbl;
442:
443: -- call to delete all the transactions for this transaction_id
444: IF (g_debug <= gme_debug.g_log_statement) THEN
445: gme_debug.put_line ( g_pkg_name
446: || '.'
447: || l_api_name
448: || ':'

Line 445: gme_debug.put_line ( g_pkg_name

441: l_mmli_tbl := p_mmli_tbl;
442:
443: -- call to delete all the transactions for this transaction_id
444: IF (g_debug <= gme_debug.g_log_statement) THEN
445: gme_debug.put_line ( g_pkg_name
446: || '.'
447: || l_api_name
448: || ':'
449: || 'calling delete with :'

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

453: delete_material_txn (p_transaction_id => p_transaction_id
454: ,x_return_status => l_return_status);
455:
456: IF l_return_status <> fnd_api.g_ret_sts_success THEN
457: IF (g_debug <= gme_debug.g_log_statement) THEN
458: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
459: END IF;
460: RAISE delete_material_txn_err;
461: END IF;

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

454: ,x_return_status => l_return_status);
455:
456: IF l_return_status <> fnd_api.g_ret_sts_success THEN
457: IF (g_debug <= gme_debug.g_log_statement) THEN
458: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
459: END IF;
460: RAISE delete_material_txn_err;
461: END IF;
462:

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

459: END IF;
460: RAISE delete_material_txn_err;
461: END IF;
462:
463: IF (g_debug <= gme_debug.g_log_statement) THEN
464: gme_debug.put_line ( g_pkg_name
465: || '.'
466: || l_api_name
467: || ':'

Line 464: gme_debug.put_line ( g_pkg_name

460: RAISE delete_material_txn_err;
461: END IF;
462:
463: IF (g_debug <= gme_debug.g_log_statement) THEN
464: gme_debug.put_line ( g_pkg_name
465: || '.'
466: || l_api_name
467: || ':'
468: || 'calling create in update with :'

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

477: IF l_return_status <> fnd_api.g_ret_sts_success THEN
478: RAISE create_material_txn_err;
479: END IF;
480:
481: IF (g_debug <= gme_debug.g_log_statement) THEN
482: gme_debug.put_line ( g_pkg_name
483: || '.'
484: || l_api_name
485: || ':'

Line 482: gme_debug.put_line ( g_pkg_name

478: RAISE create_material_txn_err;
479: END IF;
480:
481: IF (g_debug <= gme_debug.g_log_statement) THEN
482: gme_debug.put_line ( g_pkg_name
483: || '.'
484: || l_api_name
485: || ':'
486: || 'Exiting with '

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

487: || x_return_status);
488: END IF;
489: EXCEPTION
490: WHEN delete_material_txn_err THEN
491: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
492: x_return_status := l_return_status ;
493:
494: WHEN create_material_txn_err THEN
495: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');

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

491: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
492: x_return_status := l_return_status ;
493:
494: WHEN create_material_txn_err THEN
495: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
496: x_return_status := l_return_status ;
497: WHEN fnd_api.g_exc_error THEN
498: x_return_status := fnd_api.g_ret_sts_error;
499: WHEN fnd_api.g_exc_unexpected_error THEN

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

501: WHEN OTHERS THEN
502: x_return_status := fnd_api.g_ret_sts_unexp_error;
503: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
504:
505: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
506: gme_debug.put_line ( g_pkg_name
507: || '.'
508: || l_api_name
509: || ':'

Line 506: gme_debug.put_line ( g_pkg_name

502: x_return_status := fnd_api.g_ret_sts_unexp_error;
503: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
504:
505: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
506: gme_debug.put_line ( g_pkg_name
507: || '.'
508: || l_api_name
509: || ':'
510: || 'WHEN OTHERS:'

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

550: BEGIN
551: -- Initially let us assign the return status to success
552: x_return_status := fnd_api.g_ret_sts_success;
553:
554: IF (g_debug <= gme_debug.g_log_statement) THEN
555: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
556: || 'Entering');
557: END IF;
558:

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

551: -- Initially let us assign the return status to success
552: x_return_status := fnd_api.g_ret_sts_success;
553:
554: IF (g_debug <= gme_debug.g_log_statement) THEN
555: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
556: || 'Entering');
557: END IF;
558:
559: l_mmt_rec := p_mmt_rec;

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

561: -- get the transaction_id from the mmt record for deleting it.
562: l_transaction_id := l_mmt_rec.transaction_id;
563:
564: -- call to delete all the transactions for this transaction_id
565: IF (g_debug <= gme_debug.g_log_statement) THEN
566: gme_debug.put_line
567: ( g_pkg_name
568: || '.'
569: || l_api_name

Line 566: gme_debug.put_line

562: l_transaction_id := l_mmt_rec.transaction_id;
563:
564: -- call to delete all the transactions for this transaction_id
565: IF (g_debug <= gme_debug.g_log_statement) THEN
566: gme_debug.put_line
567: ( g_pkg_name
568: || '.'
569: || l_api_name
570: || ':'

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

575: delete_material_txn (p_transaction_id => l_transaction_id
576: ,x_return_status => l_return_status);
577:
578: IF l_return_status <> fnd_api.g_ret_sts_success THEN
579: IF (g_debug <= gme_debug.g_log_statement) THEN
580: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
581: END IF;
582: RAISE delete_material_txn_err;
583: END IF;

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

576: ,x_return_status => l_return_status);
577:
578: IF l_return_status <> fnd_api.g_ret_sts_success THEN
579: IF (g_debug <= gme_debug.g_log_statement) THEN
580: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
581: END IF;
582: RAISE delete_material_txn_err;
583: END IF;
584:

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

581: END IF;
582: RAISE delete_material_txn_err;
583: END IF;
584:
585: IF (g_debug <= gme_debug.g_log_statement) THEN
586: gme_debug.put_line ( g_pkg_name
587: || '.'
588: || l_api_name
589: || ':'

Line 586: gme_debug.put_line ( g_pkg_name

582: RAISE delete_material_txn_err;
583: END IF;
584:
585: IF (g_debug <= gme_debug.g_log_statement) THEN
586: gme_debug.put_line ( g_pkg_name
587: || '.'
588: || l_api_name
589: || ':'
590: || 'calling construct from mmt to mmti :'

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

598: ,x_mmli_tbl => l_mmli_tbl
599: ,x_return_status => l_return_status);
600:
601: IF l_return_status <> fnd_api.g_ret_sts_success THEN
602: IF (g_debug <= gme_debug.g_log_statement) THEN
603: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
604: END IF;
605: RAISE fnd_api.g_exc_error;
606: END IF;

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

599: ,x_return_status => l_return_status);
600:
601: IF l_return_status <> fnd_api.g_ret_sts_success THEN
602: IF (g_debug <= gme_debug.g_log_statement) THEN
603: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
604: END IF;
605: RAISE fnd_api.g_exc_error;
606: END IF;
607:

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

604: END IF;
605: RAISE fnd_api.g_exc_error;
606: END IF;
607:
608: IF (g_debug <= gme_debug.g_log_statement) THEN
609: gme_debug.put_line ( g_pkg_name
610: || '.'
611: || l_api_name
612: || ':'

Line 609: gme_debug.put_line ( g_pkg_name

605: RAISE fnd_api.g_exc_error;
606: END IF;
607:
608: IF (g_debug <= gme_debug.g_log_statement) THEN
609: gme_debug.put_line ( g_pkg_name
610: || '.'
611: || l_api_name
612: || ':'
613: || 'calling create trans with ='

Line 615: gme_debug.put_line ( g_pkg_name

611: || l_api_name
612: || ':'
613: || 'calling create trans with ='
614: || l_mmt_rec.transaction_id);
615: gme_debug.put_line ( g_pkg_name
616: || '.'
617: || l_api_name
618: || ':'
619: || 'calling create trans with ='

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

625: ,p_mmli_tbl => l_mmli_tbl
626: ,x_return_status => l_return_status);
627:
628: IF l_return_status <> fnd_api.g_ret_sts_success THEN
629: IF (g_debug <= gme_debug.g_log_statement) THEN
630: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
631: END IF;
632: RAISE create_material_txn_err;
633: END IF;

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

626: ,x_return_status => l_return_status);
627:
628: IF l_return_status <> fnd_api.g_ret_sts_success THEN
629: IF (g_debug <= gme_debug.g_log_statement) THEN
630: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
631: END IF;
632: RAISE create_material_txn_err;
633: END IF;
634:

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

631: END IF;
632: RAISE create_material_txn_err;
633: END IF;
634:
635: IF (g_debug <= gme_debug.g_log_statement) THEN
636: gme_debug.put_line ( g_pkg_name
637: || '.'
638: || l_api_name
639: || ':'

Line 636: gme_debug.put_line ( g_pkg_name

632: RAISE create_material_txn_err;
633: END IF;
634:
635: IF (g_debug <= gme_debug.g_log_statement) THEN
636: gme_debug.put_line ( g_pkg_name
637: || '.'
638: || l_api_name
639: || ':'
640: || 'Exiting with '

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

641: || x_return_status);
642: END IF;
643: EXCEPTION
644: WHEN delete_material_txn_err THEN
645: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
646: x_return_status := l_return_status ;
647: WHEN create_material_txn_err THEN
648: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
649: x_return_status := l_return_status ;

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

644: WHEN delete_material_txn_err THEN
645: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
646: x_return_status := l_return_status ;
647: WHEN create_material_txn_err THEN
648: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
649: x_return_status := l_return_status ;
650: WHEN fnd_api.g_exc_error THEN
651: x_return_status := fnd_api.g_ret_sts_error;
652: WHEN fnd_api.g_exc_unexpected_error THEN

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

654: WHEN OTHERS THEN
655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
657:
658: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
659: gme_debug.put_line ( g_pkg_name
660: || '.'
661: || l_api_name
662: || ':'

Line 659: gme_debug.put_line ( g_pkg_name

655: x_return_status := fnd_api.g_ret_sts_unexp_error;
656: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
657:
658: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
659: gme_debug.put_line ( g_pkg_name
660: || '.'
661: || l_api_name
662: || ':'
663: || 'WHEN OTHERS:'

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

710: BEGIN
711: -- Initially let us assign the return status to success
712: x_return_status := fnd_api.g_ret_sts_success;
713:
714: IF (g_debug <= gme_debug.g_log_statement) THEN
715: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
716: || 'Entering');
717: END IF;
718:

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

711: -- Initially let us assign the return status to success
712: x_return_status := fnd_api.g_ret_sts_success;
713:
714: IF (g_debug <= gme_debug.g_log_statement) THEN
715: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
716: || 'Entering');
717: END IF;
718:
719: l_transaction_id := p_transaction_id;

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

718:
719: l_transaction_id := p_transaction_id;
720:
721: IF l_transaction_id IS NOT NULL THEN
722: IF (g_debug <= gme_debug.g_log_statement) THEN
723: gme_debug.put_line
724: ( g_pkg_name
725: || '.'
726: || l_api_name

Line 723: gme_debug.put_line

719: l_transaction_id := p_transaction_id;
720:
721: IF l_transaction_id IS NOT NULL THEN
722: IF (g_debug <= gme_debug.g_log_statement) THEN
723: gme_debug.put_line
724: ( g_pkg_name
725: || '.'
726: || l_api_name
727: || ':'

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

734: ,x_mmln_tbl => l_mmln_tbl
735: ,x_return_status => l_return_status);
736:
737: IF l_return_status <> fnd_api.g_ret_sts_success THEN
738: IF (g_debug <= gme_debug.g_log_statement) THEN
739: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
740: END IF;
741: RAISE get_trans_err;
742: END IF;

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

735: ,x_return_status => l_return_status);
736:
737: IF l_return_status <> fnd_api.g_ret_sts_success THEN
738: IF (g_debug <= gme_debug.g_log_statement) THEN
739: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
740: END IF;
741: RAISE get_trans_err;
742: END IF;
743:

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

742: END IF;
743:
744: END IF;
745:
746: IF (g_debug <= gme_debug.g_log_statement) THEN
747: gme_debug.put_line ( g_pkg_name
748: || '.'
749: || l_api_name
750: || ':'

Line 747: gme_debug.put_line ( g_pkg_name

743:
744: END IF;
745:
746: IF (g_debug <= gme_debug.g_log_statement) THEN
747: gme_debug.put_line ( g_pkg_name
748: || '.'
749: || l_api_name
750: || ':'
751: || 'calling construct from mmt to mmti :'

Line 753: gme_debug.put_line ( g_pkg_name

749: || l_api_name
750: || ':'
751: || 'calling construct from mmt to mmti :'
752: || l_mmt_rec.transaction_id);
753: gme_debug.put_line ( g_pkg_name
754: || '.'
755: || l_api_name
756: || ':'
757: || 'the mmt record source line id(null) ='

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

764: ,x_mmli_tbl => l_mmli_tbl
765: ,x_return_status => l_return_status);
766:
767: IF l_return_status <> fnd_api.g_ret_sts_success THEN
768: IF (g_debug <= gme_debug.g_log_statement) THEN
769: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
770: END IF;
771: RAISE fnd_api.g_exc_error;
772: END IF;

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

765: ,x_return_status => l_return_status);
766:
767: IF l_return_status <> fnd_api.g_ret_sts_success THEN
768: IF (g_debug <= gme_debug.g_log_statement) THEN
769: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from construct mmti');
770: END IF;
771: RAISE fnd_api.g_exc_error;
772: END IF;
773:

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

770: END IF;
771: RAISE fnd_api.g_exc_error;
772: END IF;
773:
774: IF (g_debug <= gme_debug.g_log_statement) THEN
775: gme_debug.put_line ( g_pkg_name
776: || '.'
777: || l_api_name
778: || ':'

Line 775: gme_debug.put_line ( g_pkg_name

771: RAISE fnd_api.g_exc_error;
772: END IF;
773:
774: IF (g_debug <= gme_debug.g_log_statement) THEN
775: gme_debug.put_line ( g_pkg_name
776: || '.'
777: || l_api_name
778: || ':'
779: || 'getting material for '

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

783: -- get the material details of the transaction
784: l_mat_dtl_rec.material_detail_id := l_mmt_rec.trx_source_line_id;
785:
786: -- Now fetch the material detials for the mateiral
787: IF (g_debug <= gme_debug.g_log_statement) THEN
788: gme_debug.put_line ( g_pkg_name
789: || '.'
790: || l_api_name
791: || ':'

Line 788: gme_debug.put_line ( g_pkg_name

784: l_mat_dtl_rec.material_detail_id := l_mmt_rec.trx_source_line_id;
785:
786: -- Now fetch the material detials for the mateiral
787: IF (g_debug <= gme_debug.g_log_statement) THEN
788: gme_debug.put_line ( g_pkg_name
789: || '.'
790: || l_api_name
791: || ':'
792: || 'getting material for '

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

838: gme_common_pvt.g_byprod_comp_txn_action;
839: --(31)
840: END IF;
841:
842: IF (g_debug <= gme_debug.g_log_statement) THEN
843: gme_debug.put_line ( g_pkg_name
844: || '.'
845: || l_api_name
846: || ':'

Line 843: gme_debug.put_line ( g_pkg_name

839: --(31)
840: END IF;
841:
842: IF (g_debug <= gme_debug.g_log_statement) THEN
843: gme_debug.put_line ( g_pkg_name
844: || '.'
845: || l_api_name
846: || ':'
847: || 'sending transaction_type_id:'

Line 849: gme_debug.put_line ( g_pkg_name

845: || l_api_name
846: || ':'
847: || 'sending transaction_type_id:'
848: || l_mmti_rec.transaction_type_id);
849: gme_debug.put_line ( g_pkg_name
850: || '.'
851: || l_api_name
852: || ':'
853: || 'sending transaction_action_id:'

Line 859: gme_debug.put_line ( g_pkg_name

855: END IF;
856:
857: -- set for delete transaction
858: l_mmti_rec.source_line_id := l_mmt_rec.transaction_id;
859: gme_debug.put_line ( g_pkg_name
860: || '.'
861: || l_api_name
862: || ':'
863: || 'calling create trans with ='

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

868: ,p_phantom_trans => 1
869: ,x_return_status => l_return_status);
870:
871: IF l_return_status <> fnd_api.g_ret_sts_success THEN
872: IF (g_debug <= gme_debug.g_log_statement) THEN
873: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
874: END IF;
875: RAISE create_material_txn_err;
876: END IF;

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

869: ,x_return_status => l_return_status);
870:
871: IF l_return_status <> fnd_api.g_ret_sts_success THEN
872: IF (g_debug <= gme_debug.g_log_statement) THEN
873: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
874: END IF;
875: RAISE create_material_txn_err;
876: END IF;
877:

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

874: END IF;
875: RAISE create_material_txn_err;
876: END IF;
877:
878: IF (g_debug <= gme_debug.g_log_statement) THEN
879: gme_debug.put_line ( g_pkg_name
880: || '.'
881: || l_api_name
882: || ':'

Line 879: gme_debug.put_line ( g_pkg_name

875: RAISE create_material_txn_err;
876: END IF;
877:
878: IF (g_debug <= gme_debug.g_log_statement) THEN
879: gme_debug.put_line ( g_pkg_name
880: || '.'
881: || l_api_name
882: || ':'
883: || 'status from create :'

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

886:
887: -- Insert into gme_transactions_pairs table
888: -- code need to added for INSERT INTO GME_TRANSACTION_PAIRS tables
889: -- which column will carry the material detail ld
890: IF (g_debug <= gme_debug.g_log_statement) THEN
891: gme_debug.put_line ( g_pkg_name
892: || '.'
893: || l_api_name
894: || ':'

Line 891: gme_debug.put_line ( g_pkg_name

887: -- Insert into gme_transactions_pairs table
888: -- code need to added for INSERT INTO GME_TRANSACTION_PAIRS tables
889: -- which column will carry the material detail ld
890: IF (g_debug <= gme_debug.g_log_statement) THEN
891: gme_debug.put_line ( g_pkg_name
892: || '.'
893: || l_api_name
894: || ':'
895: || 'inserting into pairs table transaction_id:'

Line 897: gme_debug.put_line ( g_pkg_name

893: || l_api_name
894: || ':'
895: || 'inserting into pairs table transaction_id:'
896: || l_transaction_id);
897: gme_debug.put_line ( g_pkg_name
898: || '.'
899: || l_api_name
900: || ':'
901: || 'inserting into pairs table batch_id:'

Line 903: gme_debug.put_line

899: || l_api_name
900: || ':'
901: || 'inserting into pairs table batch_id:'
902: || l_mat_dtl_rec.batch_id);
903: gme_debug.put_line
904: ( g_pkg_name
905: || '.'
906: || l_api_name
907: || ':'

Line 910: gme_debug.put_line ( g_pkg_name

906: || l_api_name
907: || ':'
908: || 'inserting into pairs table material_detail_id:'
909: || l_mat_dtl_rec.material_detail_id);
910: gme_debug.put_line ( g_pkg_name
911: || '.'
912: || l_api_name
913: || ':'
914: || 'inserting into pairs table pair_type:'

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

924: ,gme_common_pvt.g_pairs_reversal_type);
925:
926: -- changes for phantom
927: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL AND p_txns_pair IS NULL THEN
928: IF (g_debug <= gme_debug.g_log_statement) THEN
929: gme_debug.put_line ( g_pkg_name
930: || '.'
931: || l_api_name
932: || ':'

Line 929: gme_debug.put_line ( g_pkg_name

925:
926: -- changes for phantom
927: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL AND p_txns_pair IS NULL THEN
928: IF (g_debug <= gme_debug.g_log_statement) THEN
929: gme_debug.put_line ( g_pkg_name
930: || '.'
931: || l_api_name
932: || ':'
933: || 'deleting for phantom:'

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

941:
942: CLOSE cur_get_ph_txns;
943:
944: IF m_transaction_id IS NOT NULL THEN
945: IF (g_debug <= gme_debug.g_log_statement) THEN
946: gme_debug.put_line ( g_pkg_name
947: || '.'
948: || l_api_name
949: || ':'

Line 946: gme_debug.put_line ( g_pkg_name

942: CLOSE cur_get_ph_txns;
943:
944: IF m_transaction_id IS NOT NULL THEN
945: IF (g_debug <= gme_debug.g_log_statement) THEN
946: gme_debug.put_line ( g_pkg_name
947: || '.'
948: || l_api_name
949: || ':'
950: || 'calling delete txns for phantom:'

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

954: delete_material_txn (p_transaction_id => m_transaction_id
955: ,p_txns_pair => 1
956: ,x_return_status => l_return_status);
957: IF l_return_status <> fnd_api.g_ret_sts_success THEN
958: IF (g_debug <= gme_debug.g_log_statement) THEN
959: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
960: END IF;
961: RAISE delete_material_txn_err;
962: END IF; -- ret status

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

955: ,p_txns_pair => 1
956: ,x_return_status => l_return_status);
957: IF l_return_status <> fnd_api.g_ret_sts_success THEN
958: IF (g_debug <= gme_debug.g_log_statement) THEN
959: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create mat txn');
960: END IF;
961: RAISE delete_material_txn_err;
962: END IF; -- ret status
963: ELSE

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

960: END IF;
961: RAISE delete_material_txn_err;
962: END IF; -- ret status
963: ELSE
964: IF (g_debug <= gme_debug.g_log_statement) THEN
965: gme_debug.put_line ( g_pkg_name
966: || '.'
967: || l_api_name
968: || ':'

Line 965: gme_debug.put_line ( g_pkg_name

961: RAISE delete_material_txn_err;
962: END IF; -- ret status
963: ELSE
964: IF (g_debug <= gme_debug.g_log_statement) THEN
965: gme_debug.put_line ( g_pkg_name
966: || '.'
967: || l_api_name
968: || ':'
969: || 'no phantom txns found for '

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

971: END IF;
972: END IF; -- m_transaction_id is not null
973: END IF;
974:
975: IF (g_debug <= gme_debug.g_log_statement) THEN
976: gme_debug.put_line ( g_pkg_name
977: || '.'
978: || l_api_name
979: || ':'

Line 976: gme_debug.put_line ( g_pkg_name

972: END IF; -- m_transaction_id is not null
973: END IF;
974:
975: IF (g_debug <= gme_debug.g_log_statement) THEN
976: gme_debug.put_line ( g_pkg_name
977: || '.'
978: || l_api_name
979: || ':'
980: || 'Exiting with '

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

981: || x_return_status);
982: END IF;
983: EXCEPTION
984: WHEN delete_material_txn_err THEN
985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
986: x_return_status := l_return_status ;
987: WHEN get_trans_err THEN
988: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
989: x_return_status := l_return_status ;

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

984: WHEN delete_material_txn_err THEN
985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from delete material txn');
986: x_return_status := l_return_status ;
987: WHEN get_trans_err THEN
988: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
989: x_return_status := l_return_status ;
990: WHEN create_material_txn_err THEN
991: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
992: x_return_status := l_return_status ;

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

987: WHEN get_trans_err THEN
988: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get_transactions');
989: x_return_status := l_return_status ;
990: WHEN create_material_txn_err THEN
991: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from create material txn');
992: x_return_status := l_return_status ;
993: WHEN fnd_api.g_exc_error THEN
994: x_return_status := fnd_api.g_ret_sts_error;
995: WHEN fnd_api.g_exc_unexpected_error THEN

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

992: x_return_status := l_return_status ;
993: WHEN fnd_api.g_exc_error THEN
994: x_return_status := fnd_api.g_ret_sts_error;
995: WHEN fnd_api.g_exc_unexpected_error THEN
996: IF (g_debug <= gme_debug.g_log_statement) THEN
997: gme_debug.put_line ( g_pkg_name
998: || '.'
999: || l_api_name
1000: || ':'

Line 997: gme_debug.put_line ( g_pkg_name

993: WHEN fnd_api.g_exc_error THEN
994: x_return_status := fnd_api.g_ret_sts_error;
995: WHEN fnd_api.g_exc_unexpected_error THEN
996: IF (g_debug <= gme_debug.g_log_statement) THEN
997: gme_debug.put_line ( g_pkg_name
998: || '.'
999: || l_api_name
1000: || ':'
1001: || 'Unexpected');

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

1005: WHEN OTHERS THEN
1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1008:
1009: IF (g_debug <= gme_debug.g_log_statement) THEN
1010: gme_debug.put_line ( g_pkg_name
1011: || '.'
1012: || l_api_name
1013: || ':'

Line 1010: gme_debug.put_line ( g_pkg_name

1006: x_return_status := fnd_api.g_ret_sts_unexp_error;
1007: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1008:
1009: IF (g_debug <= gme_debug.g_log_statement) THEN
1010: gme_debug.put_line ( g_pkg_name
1011: || '.'
1012: || l_api_name
1013: || ':'
1014: || 'WHEN OTHERS:'

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

1055: BEGIN
1056: -- Initially let us assign the return status to success
1057: x_return_status := fnd_api.g_ret_sts_success;
1058:
1059: IF (g_debug <= gme_debug.g_log_statement) THEN
1060: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1061: || 'Entering');
1062: END IF;
1063:

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

1056: -- Initially let us assign the return status to success
1057: x_return_status := fnd_api.g_ret_sts_success;
1058:
1059: IF (g_debug <= gme_debug.g_log_statement) THEN
1060: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1061: || 'Entering');
1062: END IF;
1063:
1064: l_mmti_rec := p_mmti_rec;

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

1075: ,x_return_status => l_return_status
1076: ,p_insert_hdr => l_insert_hdr);
1077:
1078: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1079: IF (g_debug <= gme_debug.g_log_statement) THEN
1080: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build inter hdr');
1081: END IF;
1082: RAISE build_txn_inter_err;
1083: END IF;

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

1076: ,p_insert_hdr => l_insert_hdr);
1077:
1078: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1079: IF (g_debug <= gme_debug.g_log_statement) THEN
1080: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build inter hdr');
1081: END IF;
1082: RAISE build_txn_inter_err;
1083: END IF;
1084:

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

1081: END IF;
1082: RAISE build_txn_inter_err;
1083: END IF;
1084:
1085: IF (g_debug <= gme_debug.g_log_statement) THEN
1086: gme_debug.put_line ( g_pkg_name
1087: || '.'
1088: || l_api_name
1089: || ':'

Line 1086: gme_debug.put_line ( g_pkg_name

1082: RAISE build_txn_inter_err;
1083: END IF;
1084:
1085: IF (g_debug <= gme_debug.g_log_statement) THEN
1086: gme_debug.put_line ( g_pkg_name
1087: || '.'
1088: || l_api_name
1089: || ':'
1090: || 'after header- inserting lot');

Line 1091: gme_debug.put_line ( g_pkg_name

1087: || '.'
1088: || l_api_name
1089: || ':'
1090: || 'after header- inserting lot');
1091: gme_debug.put_line ( g_pkg_name
1092: || '.'
1093: || l_api_name
1094: || ':'
1095: || 'after header- inter_id:'

Line 1097: gme_debug.put_line ( g_pkg_name

1093: || l_api_name
1094: || ':'
1095: || 'after header- inter_id:'
1096: || x_mmti_rec.transaction_interface_id);
1097: gme_debug.put_line ( g_pkg_name
1098: || '.'
1099: || l_api_name
1100: || ':'
1101: || 'after header- header_id:'

Line 1103: gme_debug.put_line ( g_pkg_name

1099: || l_api_name
1100: || ':'
1101: || 'after header- header_id:'
1102: || x_mmti_rec.transaction_header_id);
1103: gme_debug.put_line ( g_pkg_name
1104: || '.'
1105: || l_api_name
1106: || ':'
1107: || 'after header- trasn_type:'

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

1109: END IF;
1110:
1111: IF (l_mmli_tbl.COUNT > 0) THEN
1112: FOR i IN 1 .. l_mmli_tbl.COUNT LOOP
1113: IF (g_debug <= gme_debug.g_log_statement) THEN
1114: gme_debug.put_line ( g_pkg_name
1115: || '.'
1116: || l_api_name
1117: || ':'

Line 1114: gme_debug.put_line ( g_pkg_name

1110:
1111: IF (l_mmli_tbl.COUNT > 0) THEN
1112: FOR i IN 1 .. l_mmli_tbl.COUNT LOOP
1113: IF (g_debug <= gme_debug.g_log_statement) THEN
1114: gme_debug.put_line ( g_pkg_name
1115: || '.'
1116: || l_api_name
1117: || ':'
1118: || 'lot_number '

Line 1120: gme_debug.put_line ( g_pkg_name

1116: || l_api_name
1117: || ':'
1118: || 'lot_number '
1119: || l_mmli_tbl (i).lot_number);
1120: gme_debug.put_line ( g_pkg_name
1121: || '.'
1122: || l_api_name
1123: || ':'
1124: || 'transaction_quantity '

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

1145: ,x_mmli_rec => x_mmli_tbl (i)
1146: ,x_return_status => l_return_status);
1147:
1148: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1149: IF (g_debug <= gme_debug.g_log_statement) THEN
1150: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build lot inter');
1151: END IF;
1152: RAISE build_txn_inter_lot_err;
1153: END IF;

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

1146: ,x_return_status => l_return_status);
1147:
1148: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1149: IF (g_debug <= gme_debug.g_log_statement) THEN
1150: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from build lot inter');
1151: END IF;
1152: RAISE build_txn_inter_lot_err;
1153: END IF;
1154: END LOOP;

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

1161: RAISE insert_hdr_err;
1162: END IF;
1163: END IF;
1164:
1165: IF (g_debug <= gme_debug.g_log_statement) THEN
1166: gme_debug.put_line ( g_pkg_name
1167: || '.'
1168: || l_api_name
1169: || ':'

Line 1166: gme_debug.put_line ( g_pkg_name

1162: END IF;
1163: END IF;
1164:
1165: IF (g_debug <= gme_debug.g_log_statement) THEN
1166: gme_debug.put_line ( g_pkg_name
1167: || '.'
1168: || l_api_name
1169: || ':'
1170: || 'Exiting with '

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

1171: || x_return_status);
1172: END IF;
1173: EXCEPTION
1174: WHEN insert_hdr_err THEN
1175: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'insert_hdr_err');
1176: x_return_status := l_return_status;
1177: WHEN lot_expired_err THEN
1178: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'lot_expired_err');
1179: x_return_status := 'T';

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

1174: WHEN insert_hdr_err THEN
1175: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'insert_hdr_err');
1176: x_return_status := l_return_status;
1177: WHEN lot_expired_err THEN
1178: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'lot_expired_err');
1179: x_return_status := 'T';
1180: WHEN build_txn_inter_lot_err THEN
1181: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_lot_err');
1182: x_return_status := l_return_status;

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

1177: WHEN lot_expired_err THEN
1178: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'lot_expired_err');
1179: x_return_status := 'T';
1180: WHEN build_txn_inter_lot_err THEN
1181: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_lot_err');
1182: x_return_status := l_return_status;
1183: WHEN build_txn_inter_err THEN
1184: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_err');
1185: x_return_status := l_return_status;

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

1180: WHEN build_txn_inter_lot_err THEN
1181: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_lot_err');
1182: x_return_status := l_return_status;
1183: WHEN build_txn_inter_err THEN
1184: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_err');
1185: x_return_status := l_return_status;
1186: WHEN fnd_api.g_exc_error THEN
1187: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'user defined error');
1188: x_return_status := fnd_api.g_ret_sts_error;

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

1183: WHEN build_txn_inter_err THEN
1184: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'build_txn_inter_err');
1185: x_return_status := l_return_status;
1186: WHEN fnd_api.g_exc_error THEN
1187: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'user defined error');
1188: x_return_status := fnd_api.g_ret_sts_error;
1189: WHEN fnd_api.g_exc_unexpected_error THEN
1190: gme_debug.put_line ( g_pkg_name
1191: || '.'

Line 1190: gme_debug.put_line ( g_pkg_name

1186: WHEN fnd_api.g_exc_error THEN
1187: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'user defined error');
1188: x_return_status := fnd_api.g_ret_sts_error;
1189: WHEN fnd_api.g_exc_unexpected_error THEN
1190: gme_debug.put_line ( g_pkg_name
1191: || '.'
1192: || l_api_name
1193: || ':'
1194: || 'unexp'

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

1197: WHEN OTHERS THEN
1198: x_return_status := fnd_api.g_ret_sts_unexp_error;
1199: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1200:
1201: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1202: gme_debug.put_line ( g_pkg_name
1203: || '.'
1204: || l_api_name
1205: || ':'

Line 1202: gme_debug.put_line ( g_pkg_name

1198: x_return_status := fnd_api.g_ret_sts_unexp_error;
1199: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1200:
1201: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1202: gme_debug.put_line ( g_pkg_name
1203: || '.'
1204: || l_api_name
1205: || ':'
1206: || 'WHEN OTHERS:'

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

1254: BEGIN
1255: -- Initially let us assign the return status to success
1256: x_return_status := fnd_api.g_ret_sts_success;
1257:
1258: IF (g_debug <= gme_debug.g_log_statement) THEN
1259: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1260: || 'Entering');
1261: END IF;
1262:

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

1255: -- Initially let us assign the return status to success
1256: x_return_status := fnd_api.g_ret_sts_success;
1257:
1258: IF (g_debug <= gme_debug.g_log_statement) THEN
1259: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1260: || 'Entering');
1261: END IF;
1262:
1263: l_mmti_rec := p_mmti_rec;

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

1266: SELECT mtl_material_transactions_s.NEXTVAL
1267: INTO gme_common_pvt.g_transaction_header_id
1268: FROM DUAL;
1269:
1270: IF (g_debug <= gme_debug.g_log_statement) THEN
1271: gme_debug.put_line ( g_pkg_name
1272: || '.'
1273: || l_api_name
1274: || ':'

Line 1271: gme_debug.put_line ( g_pkg_name

1267: INTO gme_common_pvt.g_transaction_header_id
1268: FROM DUAL;
1269:
1270: IF (g_debug <= gme_debug.g_log_statement) THEN
1271: gme_debug.put_line ( g_pkg_name
1272: || '.'
1273: || l_api_name
1274: || ':'
1275: || 'GME_COMMON_PVT.g_transaction_header_id '

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

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

Line 1284: gme_debug.put_line ( g_pkg_name

1280: l_mmti_rec.transaction_header_id :=
1281: gme_common_pvt.g_transaction_header_id;
1282:
1283: IF (g_debug <= gme_debug.g_log_statement) THEN
1284: gme_debug.put_line ( g_pkg_name
1285: || '.'
1286: || l_api_name
1287: || ':'
1288: || 'l_mmti_rec.transaction_header_id '

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

1324: ,p_locator_id => l_mmti_rec.locator_id
1325: ,p_lot_number => NULL
1326: ,p_serial_number => NULL
1327: ,p_object_type => 'A') = 'N') THEN
1328: IF (g_debug <= gme_debug.g_log_statement) THEN
1329: gme_debug.put_line ( g_pkg_name
1330: || '.'
1331: || l_api_name
1332: || ':'

Line 1329: gme_debug.put_line ( g_pkg_name

1325: ,p_lot_number => NULL
1326: ,p_serial_number => NULL
1327: ,p_object_type => 'A') = 'N') THEN
1328: IF (g_debug <= gme_debug.g_log_statement) THEN
1329: gme_debug.put_line ( g_pkg_name
1330: || '.'
1331: || l_api_name
1332: || ':'
1333: || 'material status check not valid for item '

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

1335: END IF;
1336: RAISE material_status_err;
1337: END IF; /* inv_material_status_grp.is_status_applicable */
1338: -- for a phantom transaction- asssign value to transaction_refernece
1339: IF (g_debug <= gme_debug.g_log_statement) THEN
1340: gme_debug.put_line ( g_pkg_name
1341: || '.'
1342: || l_api_name
1343: || 'Material Status is VALID');

Line 1340: gme_debug.put_line ( g_pkg_name

1336: RAISE material_status_err;
1337: END IF; /* inv_material_status_grp.is_status_applicable */
1338: -- for a phantom transaction- asssign value to transaction_refernece
1339: IF (g_debug <= gme_debug.g_log_statement) THEN
1340: gme_debug.put_line ( g_pkg_name
1341: || '.'
1342: || l_api_name
1343: || 'Material Status is VALID');
1344: gme_debug.put_line ( g_pkg_name

Line 1344: gme_debug.put_line ( g_pkg_name

1340: gme_debug.put_line ( g_pkg_name
1341: || '.'
1342: || l_api_name
1343: || 'Material Status is VALID');
1344: gme_debug.put_line ( g_pkg_name
1345: || '.'
1346: || l_api_name
1347: || 'p_assign_phantom: '
1348: || p_assign_phantom);

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

1352: l_mmti_rec.transaction_reference :=
1353: (l_mmti_rec.transaction_interface_id);
1354: END IF;
1355:
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: (l_mmti_rec.transaction_interface_id);
1354: END IF;
1355:
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: || 'transaction_interface_id: '

Line 1363: gme_debug.put_line ( g_pkg_name

1359: || l_api_name
1360: || ':'
1361: || 'transaction_interface_id: '
1362: || l_mmti_rec.transaction_interface_id);
1363: gme_debug.put_line ( g_pkg_name
1364: || '.'
1365: || l_api_name
1366: || ':'
1367: || 'transaction_source_id: '

Line 1369: gme_debug.put_line ( g_pkg_name

1365: || l_api_name
1366: || ':'
1367: || 'transaction_source_id: '
1368: || l_mmti_rec.transaction_source_id);
1369: gme_debug.put_line ( g_pkg_name
1370: || '.'
1371: || l_api_name
1372: || ':'
1373: || 'transaction_type_id: '

Line 1375: gme_debug.put_line ( g_pkg_name

1371: || l_api_name
1372: || ':'
1373: || 'transaction_type_id: '
1374: || l_mmti_rec.transaction_type_id);
1375: gme_debug.put_line ( g_pkg_name
1376: || '.'
1377: || l_api_name
1378: || ':'
1379: || 'transaction_source_type_id: '

Line 1381: gme_debug.put_line ( g_pkg_name

1377: || l_api_name
1378: || ':'
1379: || 'transaction_source_type_id: '
1380: || l_mmti_rec.transaction_source_type_id);
1381: gme_debug.put_line ( g_pkg_name
1382: || '.'
1383: || l_api_name
1384: || ':'
1385: || 'transaction_quantity: '

Line 1387: gme_debug.put_line ( g_pkg_name

1383: || l_api_name
1384: || ':'
1385: || 'transaction_quantity: '
1386: || l_mmti_rec.transaction_quantity);
1387: gme_debug.put_line ( g_pkg_name
1388: || '.'
1389: || l_api_name
1390: || ':'
1391: || 'transaction_uom: '

Line 1393: gme_debug.put_line ( g_pkg_name

1389: || l_api_name
1390: || ':'
1391: || 'transaction_uom: '
1392: || l_mmti_rec.transaction_uom);
1393: gme_debug.put_line ( g_pkg_name
1394: || '.'
1395: || l_api_name
1396: || ':'
1397: || 'secondary_transaction_quantity: '

Line 1399: gme_debug.put_line ( g_pkg_name

1395: || l_api_name
1396: || ':'
1397: || 'secondary_transaction_quantity: '
1398: || l_mmti_rec.secondary_transaction_quantity);
1399: gme_debug.put_line ( g_pkg_name
1400: || '.'
1401: || l_api_name
1402: || ':'
1403: || 'secondary_uom_code: '

Line 1405: gme_debug.put_line ( g_pkg_name

1401: || l_api_name
1402: || ':'
1403: || 'secondary_uom_code: '
1404: || l_mmti_rec.secondary_uom_code);
1405: gme_debug.put_line ( g_pkg_name
1406: || '.'
1407: || l_api_name
1408: || ':'
1409: || 'primary_quantity: '

Line 1411: gme_debug.put_line ( g_pkg_name

1407: || l_api_name
1408: || ':'
1409: || 'primary_quantity: '
1410: || l_mmti_rec.primary_quantity);
1411: gme_debug.put_line ( g_pkg_name
1412: || '.'
1413: || l_api_name
1414: || ':'
1415: || 'process_flag: '

Line 1417: gme_debug.put_line ( g_pkg_name

1413: || l_api_name
1414: || ':'
1415: || 'process_flag: '
1416: || l_mmti_rec.process_flag);
1417: gme_debug.put_line ( g_pkg_name
1418: || '.'
1419: || l_api_name
1420: || ':'
1421: || 'inventory_item_id: '

Line 1423: gme_debug.put_line ( g_pkg_name

1419: || l_api_name
1420: || ':'
1421: || 'inventory_item_id: '
1422: || l_mmti_rec.inventory_item_id);
1423: gme_debug.put_line ( g_pkg_name
1424: || '.'
1425: || l_api_name
1426: || ':'
1427: || 'revision: '

Line 1429: gme_debug.put_line ( g_pkg_name

1425: || l_api_name
1426: || ':'
1427: || 'revision: '
1428: || l_mmti_rec.revision);
1429: gme_debug.put_line ( g_pkg_name
1430: || '.'
1431: || l_api_name
1432: || ':'
1433: || 'transfer_lpn_id: '

Line 1435: gme_debug.put_line ( g_pkg_name

1431: || l_api_name
1432: || ':'
1433: || 'transfer_lpn_id: '
1434: || l_mmti_rec.transfer_lpn_id);
1435: gme_debug.put_line ( g_pkg_name
1436: || '.'
1437: || l_api_name
1438: || ':'
1439: || 'organization_id: '

Line 1441: gme_debug.put_line ( g_pkg_name

1437: || l_api_name
1438: || ':'
1439: || 'organization_id: '
1440: || l_mmti_rec.organization_id);
1441: gme_debug.put_line ( g_pkg_name
1442: || '.'
1443: || l_api_name
1444: || ':'
1445: || 'subinventory_code: '

Line 1447: gme_debug.put_line ( g_pkg_name

1443: || l_api_name
1444: || ':'
1445: || 'subinventory_code: '
1446: || TO_CHAR (l_mmti_rec.subinventory_code) );
1447: gme_debug.put_line ( g_pkg_name
1448: || '.'
1449: || l_api_name
1450: || ':'
1451: || 'locator_id:'

Line 1453: gme_debug.put_line ( g_pkg_name

1449: || l_api_name
1450: || ':'
1451: || 'locator_id:'
1452: || l_mmti_rec.locator_id);
1453: gme_debug.put_line ( g_pkg_name
1454: || '.'
1455: || l_api_name
1456: || ':'
1457: || 'source_line_id: '

Line 1459: gme_debug.put_line ( g_pkg_name

1455: || l_api_name
1456: || ':'
1457: || 'source_line_id: '
1458: || l_mmti_rec.source_line_id);
1459: gme_debug.put_line ( g_pkg_name
1460: || '.'
1461: || l_api_name
1462: || ':'
1463: || 'trx_source_line_id: '

Line 1465: gme_debug.put_line ( g_pkg_name

1461: || l_api_name
1462: || ':'
1463: || 'trx_source_line_id: '
1464: || l_mmti_rec.trx_source_line_id);
1465: gme_debug.put_line ( g_pkg_name
1466: || '.'
1467: || l_api_name
1468: || ':'
1469: || 'source_header_id: '

Line 1471: gme_debug.put_line ( g_pkg_name

1467: || l_api_name
1468: || ':'
1469: || 'source_header_id: '
1470: || l_mmti_rec.source_header_id);
1471: gme_debug.put_line ( g_pkg_name
1472: || '.'
1473: || l_api_name
1474: || ':'
1475: || 'transaction_source_name: '

Line 1477: gme_debug.put_line ( g_pkg_name

1473: || l_api_name
1474: || ':'
1475: || 'transaction_source_name: '
1476: || l_mmti_rec.transaction_source_name);
1477: gme_debug.put_line ( g_pkg_name
1478: || '.'
1479: || l_api_name
1480: || ':'
1481: || 'transaction_mode: '

Line 1483: gme_debug.put_line ( g_pkg_name

1479: || l_api_name
1480: || ':'
1481: || 'transaction_mode: '
1482: || l_mmti_rec.transaction_mode);
1483: gme_debug.put_line ( g_pkg_name
1484: || '.'
1485: || l_api_name
1486: || ':'
1487: || 'last_updated_by: '

Line 1489: gme_debug.put_line ( g_pkg_name

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

Line 1495: gme_debug.put_line ( g_pkg_name

1491: || l_api_name
1492: || ':'
1493: || 'transaction_reference: '
1494: || l_mmti_rec.transaction_reference);
1495: gme_debug.put_line ( g_pkg_name
1496: || '.'
1497: || l_api_name
1498: || ':'
1499: || 'transaction_batch_id: '

Line 1501: gme_debug.put_line ( g_pkg_name

1497: || l_api_name
1498: || ':'
1499: || 'transaction_batch_id: '
1500: || l_mmti_rec.transaction_batch_id);
1501: gme_debug.put_line ( g_pkg_name
1502: || '.'
1503: || l_api_name
1504: || ':'
1505: || 'transaction_batch_seq: '

Line 1507: gme_debug.put_line ( g_pkg_name

1503: || l_api_name
1504: || ':'
1505: || 'transaction_batch_seq: '
1506: || l_mmti_rec.transaction_batch_seq);
1507: gme_debug.put_line ( g_pkg_name
1508: || '.'
1509: || l_api_name
1510: || ':'
1511: || 'reservation_quantity: '

Line 1513: gme_debug.put_line ( g_pkg_name

1509: || l_api_name
1510: || ':'
1511: || 'reservation_quantity: '
1512: || l_mmti_rec.reservation_quantity);
1513: gme_debug.put_line ( g_pkg_name
1514: || '.'
1515: || l_api_name
1516: || ':'
1517: || 'transaction_sequence_id: '

Line 1519: gme_debug.put_line ( g_pkg_name

1515: || l_api_name
1516: || ':'
1517: || 'transaction_sequence_id: '
1518: || l_mmti_rec.transaction_sequence_id);
1519: gme_debug.put_line ( g_pkg_name
1520: || '.'
1521: || l_api_name
1522: || ':'
1523: || 'reason_id: '

Line 1525: gme_debug.put_line ( g_pkg_name

1521: || l_api_name
1522: || ':'
1523: || 'reason_id: '
1524: || l_mmti_rec.reason_id);
1525: gme_debug.put_line ( g_pkg_name
1526: || '.'
1527: || l_api_name
1528: || ':'
1529: || 'transfer_lpn_id: '

Line 1531: gme_debug.put_line ( g_pkg_name

1527: || l_api_name
1528: || ':'
1529: || 'transfer_lpn_id: '
1530: || l_mmti_rec.transfer_lpn_id);
1531: gme_debug.put_line ( g_pkg_name
1532: || '.'
1533: || l_api_name
1534: || ':'
1535: || 'transaction_date: '

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

1544: END IF;
1545: END IF;
1546: x_mmti_rec := l_mmti_rec;
1547:
1548: IF (g_debug <= gme_debug.g_log_statement) THEN
1549: gme_debug.put_line ( g_pkg_name
1550: || '.'
1551: || l_api_name
1552: || ':'

Line 1549: gme_debug.put_line ( g_pkg_name

1545: END IF;
1546: x_mmti_rec := l_mmti_rec;
1547:
1548: IF (g_debug <= gme_debug.g_log_statement) THEN
1549: gme_debug.put_line ( g_pkg_name
1550: || '.'
1551: || l_api_name
1552: || ':'
1553: || 'after inserting header with status:'||x_return_status);

Line 1582: gme_debug.put_line ( g_pkg_name

1578: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_SUB'
1579: ,'TRANSTYPE',l_type,'ITEM',l_item
1580: ,'SUBINV',l_mmti_rec.subinventory_code);
1581: END IF;
1582: gme_debug.put_line ( g_pkg_name
1583: || '.'
1584: || l_api_name
1585: || ':'
1586: || 'material status invalid for item, subinventory, locator etc'

Line 1590: gme_debug.put_line ( g_pkg_name

1586: || 'material status invalid for item, subinventory, locator etc'
1587: );
1588: x_return_status := 'T';
1589: WHEN fnd_api.g_exc_unexpected_error THEN
1590: gme_debug.put_line ( g_pkg_name
1591: || '.'
1592: || l_api_name
1593: || ':'
1594: || 'unexp'

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

1597: WHEN OTHERS THEN
1598: x_return_status := fnd_api.g_ret_sts_unexp_error;
1599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1600:
1601: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1602: gme_debug.put_line ( g_pkg_name
1603: || '.'
1604: || l_api_name
1605: || ':'

Line 1602: gme_debug.put_line ( g_pkg_name

1598: x_return_status := fnd_api.g_ret_sts_unexp_error;
1599: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1600:
1601: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1602: gme_debug.put_line ( g_pkg_name
1603: || '.'
1604: || l_api_name
1605: || ':'
1606: || 'WHEN OTHERS:'

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

1650: material_status_err EXCEPTION;
1651: BEGIN
1652: x_return_status := fnd_api.g_ret_sts_success;
1653:
1654: IF (g_debug <= gme_debug.g_log_statement) THEN
1655: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1656: || 'Entering');
1657: END IF;
1658:

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

1651: BEGIN
1652: x_return_status := fnd_api.g_ret_sts_success;
1653:
1654: IF (g_debug <= gme_debug.g_log_statement) THEN
1655: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1656: || 'Entering');
1657: END IF;
1658:
1659: l_mmli_rec := p_mmli_rec;

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

1693: ,p_locator_id => p_locator_id
1694: ,p_lot_number => l_mmli_rec.lot_number
1695: ,p_serial_number => NULL
1696: ,p_object_type => 'A') = 'N') THEN
1697: IF (g_debug <= gme_debug.g_log_statement) THEN
1698: gme_debug.put_line ( g_pkg_name
1699: || '.'
1700: || l_api_name
1701: || ':'

Line 1698: gme_debug.put_line ( g_pkg_name

1694: ,p_lot_number => l_mmli_rec.lot_number
1695: ,p_serial_number => NULL
1696: ,p_object_type => 'A') = 'N') THEN
1697: IF (g_debug <= gme_debug.g_log_statement) THEN
1698: gme_debug.put_line ( g_pkg_name
1699: || '.'
1700: || l_api_name
1701: || ':'
1702: || 'material status check for lot NOT valid for lot '

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

1704: END IF;
1705: RAISE material_status_err;
1706: END IF; /* inv_material_status_grp.is_status_applicable */
1707:
1708: IF (g_debug <= gme_debug.g_log_statement) THEN
1709: gme_debug.put_line ( g_pkg_name
1710: || '.'
1711: || l_api_name
1712: || ':'

Line 1709: gme_debug.put_line ( g_pkg_name

1705: RAISE material_status_err;
1706: END IF; /* inv_material_status_grp.is_status_applicable */
1707:
1708: IF (g_debug <= gme_debug.g_log_statement) THEN
1709: gme_debug.put_line ( g_pkg_name
1710: || '.'
1711: || l_api_name
1712: || ':'
1713: || 'Material Status is VALID for lot '

Line 1715: gme_debug.put_line ( g_pkg_name

1711: || l_api_name
1712: || ':'
1713: || 'Material Status is VALID for lot '
1714: || l_mmli_rec.lot_number);
1715: gme_debug.put_line ( g_pkg_name
1716: || '.'
1717: || l_api_name
1718: || ':'
1719: || 'lot_qty is '

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

1738: ,l_mmli_rec.secondary_transaction_quantity);
1739:
1740: x_mmli_rec := l_mmli_rec;
1741:
1742: IF (g_debug <= gme_debug.g_log_statement) THEN
1743: gme_debug.put_line ( g_pkg_name
1744: || '.'
1745: || l_api_name
1746: || ':'

Line 1743: gme_debug.put_line ( g_pkg_name

1739:
1740: x_mmli_rec := l_mmli_rec;
1741:
1742: IF (g_debug <= gme_debug.g_log_statement) THEN
1743: gme_debug.put_line ( g_pkg_name
1744: || '.'
1745: || l_api_name
1746: || ':'
1747: || 'Exiting with '

Line 1764: gme_debug.put_line ( g_pkg_name

1760: WHERE transaction_type_id = p_transaction_type_id;
1761: gme_common_pvt.log_message ('GME_MATERIAL_STS_INV_LOT'
1762: ,'TRANSTYPE',l_type,'ITEM',l_item
1763: ,'LOT',l_mmli_rec.lot_number);
1764: gme_debug.put_line ( g_pkg_name
1765: || '.'
1766: || l_api_name
1767: || ':'
1768: || 'material status invalid for item, subinventory, locator etc');

Line 1771: gme_debug.put_line ( g_pkg_name

1767: || ':'
1768: || 'material status invalid for item, subinventory, locator etc');
1769: x_return_status := 'T';
1770: WHEN fnd_api.g_exc_error THEN
1771: gme_debug.put_line ( g_pkg_name
1772: || '.'
1773: || l_api_name
1774: || ':'
1775: || 'WHEN exe'

Line 1779: gme_debug.put_line ( g_pkg_name

1775: || 'WHEN exe'
1776: || SQLERRM);
1777: x_return_status := fnd_api.g_ret_sts_error;
1778: WHEN fnd_api.g_exc_unexpected_error THEN
1779: gme_debug.put_line ( g_pkg_name
1780: || '.'
1781: || l_api_name
1782: || ':'
1783: || 'unexp'

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

1786: WHEN OTHERS THEN
1787: x_return_status := fnd_api.g_ret_sts_unexp_error;
1788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1789:
1790: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1791: gme_debug.put_line ( g_pkg_name
1792: || '.'
1793: || l_api_name
1794: || ':'

Line 1791: gme_debug.put_line ( g_pkg_name

1787: x_return_status := fnd_api.g_ret_sts_unexp_error;
1788: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1789:
1790: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
1791: gme_debug.put_line ( g_pkg_name
1792: || '.'
1793: || l_api_name
1794: || ':'
1795: || 'WHEN OTHERS:'

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

1854:
1855: BEGIN
1856: x_return_status := fnd_api.g_ret_sts_success;
1857:
1858: IF (g_debug <= gme_debug.g_log_statement) THEN
1859: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1860: || 'Entering with transaction '||p_transaction_id);
1861: END IF;
1862:

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

1855: BEGIN
1856: x_return_status := fnd_api.g_ret_sts_success;
1857:
1858: IF (g_debug <= gme_debug.g_log_statement) THEN
1859: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1860: || 'Entering with transaction '||p_transaction_id);
1861: END IF;
1862:
1863: IF p_transaction_id IS NULL THEN

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

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

Line 1867: gme_debug.put_line ( g_pkg_name

1863: IF p_transaction_id IS NULL THEN
1864: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
1865:
1866: IF (g_debug <= gme_debug.g_log_statement) THEN
1867: gme_debug.put_line ( g_pkg_name
1868: || '.'
1869: || l_api_name
1870: || ':'
1871: || 'TRANSACTION ID NEEDED FOR RETRIEVAL');

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

1877: OPEN cur_get_transaction (l_transaction_id, gme_common_pvt.g_pairs_reversal_type);
1878: FETCH cur_get_transaction
1879: INTO x_mmt_rec;
1880: IF cur_get_transaction%FOUND THEN
1881: IF (g_debug <= gme_debug.g_log_statement) THEN
1882: gme_debug.put_line ( g_pkg_name
1883: || '.'
1884: || l_api_name
1885: || ':'

Line 1882: gme_debug.put_line ( g_pkg_name

1878: FETCH cur_get_transaction
1879: INTO x_mmt_rec;
1880: IF cur_get_transaction%FOUND THEN
1881: IF (g_debug <= gme_debug.g_log_statement) THEN
1882: gme_debug.put_line ( g_pkg_name
1883: || '.'
1884: || l_api_name
1885: || ':'
1886: || 'TRANSACTIONS found for '

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

1890: ,x_mmln_tbl => x_mmln_tbl
1891: ,x_return_status => l_return_status);
1892:
1893: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1894: IF (g_debug <= gme_debug.g_log_statement) THEN
1895: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1896: || 'error from get lot trans');
1897: END IF;
1898: RAISE fnd_api.g_exc_error;

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

1891: ,x_return_status => l_return_status);
1892:
1893: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1894: IF (g_debug <= gme_debug.g_log_statement) THEN
1895: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1896: || 'error from get lot trans');
1897: END IF;
1898: RAISE fnd_api.g_exc_error;
1899: END IF;

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

1903: RAISE fnd_api.g_exc_error;
1904: END IF;
1905: CLOSE cur_get_transaction;
1906:
1907: IF (g_debug <= gme_debug.g_log_statement) THEN
1908: gme_debug.put_line ( g_pkg_name
1909: || '.'
1910: || l_api_name
1911: || ':'

Line 1908: gme_debug.put_line ( g_pkg_name

1904: END IF;
1905: CLOSE cur_get_transaction;
1906:
1907: IF (g_debug <= gme_debug.g_log_statement) THEN
1908: gme_debug.put_line ( g_pkg_name
1909: || '.'
1910: || l_api_name
1911: || ':'
1912: || 'TRANSACTION '

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

1912: || 'TRANSACTION '
1913: || x_mmt_rec.transaction_id);
1914: END IF;
1915:
1916: IF (g_debug <= gme_debug.g_log_statement) THEN
1917: gme_debug.put_line ( g_pkg_name
1918: || '.'
1919: || l_api_name
1920: || ':'

Line 1917: gme_debug.put_line ( g_pkg_name

1913: || x_mmt_rec.transaction_id);
1914: END IF;
1915:
1916: IF (g_debug <= gme_debug.g_log_statement) THEN
1917: gme_debug.put_line ( g_pkg_name
1918: || '.'
1919: || l_api_name
1920: || ':'
1921: || 'Exiting with '

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

1929: WHEN OTHERS THEN
1930: x_return_status := fnd_api.g_ret_sts_unexp_error;
1931: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1932:
1933: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
1934: gme_debug.put_line ( g_pkg_name
1935: || '.'
1936: || l_api_name
1937: || ':'

Line 1934: gme_debug.put_line ( g_pkg_name

1930: x_return_status := fnd_api.g_ret_sts_unexp_error;
1931: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1932:
1933: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
1934: gme_debug.put_line ( g_pkg_name
1935: || '.'
1936: || l_api_name
1937: || ':'
1938: || 'WHEN OTHERS:'

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

1974: BEGIN
1975: -- Initially let us assign the return status to success
1976: x_return_status := fnd_api.g_ret_sts_success;
1977:
1978: IF (g_debug <= gme_debug.g_log_statement) THEN
1979: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1980: || 'Entering');
1981: END IF;
1982:

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

1975: -- Initially let us assign the return status to success
1976: x_return_status := fnd_api.g_ret_sts_success;
1977:
1978: IF (g_debug <= gme_debug.g_log_statement) THEN
1979: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
1980: || 'Entering');
1981: END IF;
1982:
1983: l_mmt_rec := p_mmt_rec;

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

2033: l_mmln_tbl (i).secondary_transaction_quantity;
2034: END LOOP;
2035: END IF; --l_mmln_tbl.count
2036:
2037: IF (g_debug <= gme_debug.g_log_statement) THEN
2038: gme_debug.put_line ( g_pkg_name
2039: || '.'
2040: || l_api_name
2041: || ':'

Line 2038: gme_debug.put_line ( g_pkg_name

2034: END LOOP;
2035: END IF; --l_mmln_tbl.count
2036:
2037: IF (g_debug <= gme_debug.g_log_statement) THEN
2038: gme_debug.put_line ( g_pkg_name
2039: || '.'
2040: || l_api_name
2041: || ':'
2042: || 'Exiting with '

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

2050: WHEN OTHERS THEN
2051: x_return_status := fnd_api.g_ret_sts_unexp_error;
2052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2053:
2054: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2055: gme_debug.put_line ( g_pkg_name
2056: || '.'
2057: || l_api_name
2058: || ':'

Line 2055: gme_debug.put_line ( g_pkg_name

2051: x_return_status := fnd_api.g_ret_sts_unexp_error;
2052: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2053:
2054: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2055: gme_debug.put_line ( g_pkg_name
2056: || '.'
2057: || l_api_name
2058: || ':'
2059: || 'WHEN OTHERS:'

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

2111: BEGIN
2112: -- Initially let us assign the return status to success
2113: x_return_status := fnd_api.g_ret_sts_success;
2114:
2115: IF (g_debug <= gme_debug.g_log_statement) THEN
2116: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2117: || 'Entering with mat/batch '||p_mat_det_id||'/'||p_batch_id);
2118: END IF;
2119:

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

2112: -- Initially let us assign the return status to success
2113: x_return_status := fnd_api.g_ret_sts_success;
2114:
2115: IF (g_debug <= gme_debug.g_log_statement) THEN
2116: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2117: || 'Entering with mat/batch '||p_mat_det_id||'/'||p_batch_id);
2118: END IF;
2119:
2120: IF p_mat_det_id IS NOT NULL AND p_batch_id IS NOT NULL THEN

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

2124: FETCH cur_get_trans
2125: BULK COLLECT INTO x_mmt_tbl;
2126: CLOSE cur_get_trans;
2127: END IF;
2128: IF (g_debug <= gme_debug.g_log_statement) THEN
2129: gme_debug.put_line ( g_pkg_name
2130: || '.'
2131: || l_api_name
2132: || ':'

Line 2129: gme_debug.put_line ( g_pkg_name

2125: BULK COLLECT INTO x_mmt_tbl;
2126: CLOSE cur_get_trans;
2127: END IF;
2128: IF (g_debug <= gme_debug.g_log_statement) THEN
2129: gme_debug.put_line ( g_pkg_name
2130: || '.'
2131: || l_api_name
2132: || ':'
2133: || 'Exiting with '

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

2141: WHEN OTHERS THEN
2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2144:
2145: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2146: gme_debug.put_line ( g_pkg_name
2147: || '.'
2148: || l_api_name
2149: || ':'

Line 2146: gme_debug.put_line ( g_pkg_name

2142: x_return_status := fnd_api.g_ret_sts_unexp_error;
2143: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2144:
2145: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2146: gme_debug.put_line ( g_pkg_name
2147: || '.'
2148: || l_api_name
2149: || ':'
2150: || 'WHEN OTHERS:'

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

2184: BEGIN
2185: -- Initially let us assign the return status to success
2186: x_return_status := fnd_api.g_ret_sts_success;
2187:
2188: IF (g_debug <= gme_debug.g_log_statement) THEN
2189: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2190: || 'Entering with transaction id '||p_transaction_id);
2191:
2192: END IF;

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

2185: -- Initially let us assign the return status to success
2186: x_return_status := fnd_api.g_ret_sts_success;
2187:
2188: IF (g_debug <= gme_debug.g_log_statement) THEN
2189: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2190: || 'Entering with transaction id '||p_transaction_id);
2191:
2192: END IF;
2193:

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

2197: BULK COLLECT INTO x_mmln_tbl;
2198: CLOSE cur_get_lot_trans;
2199: END IF;
2200:
2201: IF (g_debug <= gme_debug.g_log_statement) THEN
2202: gme_debug.put_line ( g_pkg_name
2203: || '.'
2204: || l_api_name
2205: || ':'

Line 2202: gme_debug.put_line ( g_pkg_name

2198: CLOSE cur_get_lot_trans;
2199: END IF;
2200:
2201: IF (g_debug <= gme_debug.g_log_statement) THEN
2202: gme_debug.put_line ( g_pkg_name
2203: || '.'
2204: || l_api_name
2205: || ':'
2206: || 'lot count '

Line 2208: gme_debug.put_line ( g_pkg_name

2204: || l_api_name
2205: || ':'
2206: || 'lot count '
2207: || x_mmln_tbl.COUNT);
2208: gme_debug.put_line ( g_pkg_name
2209: || '.'
2210: || l_api_name
2211: || ':'
2212: || 'Exiting with '

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

2219: x_return_status := fnd_api.g_ret_sts_unexp_error;
2220: WHEN OTHERS THEN
2221: x_return_status := fnd_api.g_ret_sts_unexp_error;
2222:
2223: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2224: gme_debug.put_line ( g_pkg_name
2225: || '.'
2226: || l_api_name
2227: || ':'

Line 2224: gme_debug.put_line ( g_pkg_name

2220: WHEN OTHERS THEN
2221: x_return_status := fnd_api.g_ret_sts_unexp_error;
2222:
2223: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2224: gme_debug.put_line ( g_pkg_name
2225: || '.'
2226: || l_api_name
2227: || ':'
2228: || 'WHEN OTHERS:'

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

2269: BEGIN
2270: -- Initially let us assign the return status to success
2271: x_return_status := fnd_api.g_ret_sts_success;
2272:
2273: IF (g_debug <= gme_debug.g_log_statement) THEN
2274: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2275: || 'Entering with p_transaction_hdr_id '||p_transaction_hdr_id);
2276: END IF;
2277:

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

2270: -- Initially let us assign the return status to success
2271: x_return_status := fnd_api.g_ret_sts_success;
2272:
2273: IF (g_debug <= gme_debug.g_log_statement) THEN
2274: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2275: || 'Entering with p_transaction_hdr_id '||p_transaction_hdr_id);
2276: END IF;
2277:
2278: IF p_transaction_hdr_id IS NOT NULL THEN

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

2287: CLOSE cur_get_trans;
2288: END IF;
2289:
2290: FOR i IN 1 .. l_number_tab.COUNT LOOP
2291: IF (g_debug <= gme_debug.g_log_statement) THEN
2292: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2293: || 'calling pre_process_val with transaction_id '||l_number_tab (i));
2294: END IF;
2295: pre_process_val (p_transaction_interface_id => l_number_tab (i)

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

2288: END IF;
2289:
2290: FOR i IN 1 .. l_number_tab.COUNT LOOP
2291: IF (g_debug <= gme_debug.g_log_statement) THEN
2292: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2293: || 'calling pre_process_val with transaction_id '||l_number_tab (i));
2294: END IF;
2295: pre_process_val (p_transaction_interface_id => l_number_tab (i)
2296: ,x_return_status => l_return_status);

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

2299: RAISE fnd_api.g_exc_error;
2300: END IF;
2301: END LOOP;
2302:
2303: IF (g_debug <= gme_debug.g_log_statement) THEN
2304: gme_debug.put_line ( g_pkg_name
2305: || '.'
2306: || l_api_name
2307: || ':'

Line 2304: gme_debug.put_line ( g_pkg_name

2300: END IF;
2301: END LOOP;
2302:
2303: IF (g_debug <= gme_debug.g_log_statement) THEN
2304: gme_debug.put_line ( g_pkg_name
2305: || '.'
2306: || l_api_name
2307: || ':'
2308: || 'Exiting with '

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

2320: x_return_status := fnd_api.g_ret_sts_unexp_error;
2321: WHEN OTHERS THEN
2322: x_return_status := fnd_api.g_ret_sts_unexp_error;
2323:
2324: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2325: gme_debug.put_line ( g_pkg_name
2326: || '.'
2327: || l_api_name
2328: || ':'

Line 2325: gme_debug.put_line ( g_pkg_name

2321: WHEN OTHERS THEN
2322: x_return_status := fnd_api.g_ret_sts_unexp_error;
2323:
2324: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2325: gme_debug.put_line ( g_pkg_name
2326: || '.'
2327: || l_api_name
2328: || ':'
2329: || 'WHEN OTHERS:'

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

2431: BEGIN
2432: -- Initially let us assign the return status to success
2433: x_return_status := fnd_api.g_ret_sts_success;
2434:
2435: IF (g_debug <= gme_debug.g_log_statement) THEN
2436: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
2437: END IF;
2438: IF (g_debug <= gme_debug.g_log_statement) THEN
2439: gme_debug.put_line ( g_pkg_name

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

2432: -- Initially let us assign the return status to success
2433: x_return_status := fnd_api.g_ret_sts_success;
2434:
2435: IF (g_debug <= gme_debug.g_log_statement) THEN
2436: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
2437: END IF;
2438: IF (g_debug <= gme_debug.g_log_statement) THEN
2439: gme_debug.put_line ( g_pkg_name
2440: || '.'

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

2434:
2435: IF (g_debug <= gme_debug.g_log_statement) THEN
2436: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
2437: END IF;
2438: IF (g_debug <= gme_debug.g_log_statement) THEN
2439: gme_debug.put_line ( g_pkg_name
2440: || '.'
2441: || l_api_name
2442: || ':'

Line 2439: gme_debug.put_line ( g_pkg_name

2435: IF (g_debug <= gme_debug.g_log_statement) THEN
2436: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
2437: END IF;
2438: IF (g_debug <= gme_debug.g_log_statement) THEN
2439: gme_debug.put_line ( g_pkg_name
2440: || '.'
2441: || l_api_name
2442: || ':'
2443: || 'p_lot_number: '

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

2479: END IF;
2480:
2481: CLOSE cur_lot_qty;
2482: END IF;
2483: IF (g_debug <= gme_debug.g_log_statement) THEN
2484: gme_debug.put_line ( g_pkg_name
2485: || '.'
2486: || l_api_name
2487: || ':'

Line 2484: gme_debug.put_line ( g_pkg_name

2480:
2481: CLOSE cur_lot_qty;
2482: END IF;
2483: IF (g_debug <= gme_debug.g_log_statement) THEN
2484: gme_debug.put_line ( g_pkg_name
2485: || '.'
2486: || l_api_name
2487: || ':'
2488: || 'Exiting with return status '

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

2494: WHEN OTHERS THEN
2495: x_return_status := fnd_api.g_ret_sts_unexp_error;
2496: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2497:
2498: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2499: gme_debug.put_line ( g_pkg_name
2500: || '.'
2501: || l_api_name
2502: || ':'

Line 2499: gme_debug.put_line ( g_pkg_name

2495: x_return_status := fnd_api.g_ret_sts_unexp_error;
2496: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2497:
2498: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2499: gme_debug.put_line ( g_pkg_name
2500: || '.'
2501: || l_api_name
2502: || ':'
2503: || 'WHEN OTHERS:'

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

2569: BEGIN
2570: -- Initially let us assign the return status to success
2571: x_return_status := fnd_api.g_ret_sts_success;
2572:
2573: IF (g_debug <= gme_debug.g_log_statement) THEN
2574: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2575: || 'Entering');
2576: END IF;
2577:

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

2570: -- Initially let us assign the return status to success
2571: x_return_status := fnd_api.g_ret_sts_success;
2572:
2573: IF (g_debug <= gme_debug.g_log_statement) THEN
2574: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2575: || 'Entering');
2576: END IF;
2577:
2578: OPEN cur_trans_detail (p_transaction_interface_id);

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

2581: INTO l_mmti_rec;
2582:
2583: CLOSE cur_trans_detail;
2584:
2585: IF (g_debug <= gme_debug.g_log_statement) THEN
2586: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);

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

2582:
2583: CLOSE cur_trans_detail;
2584:
2585: IF (g_debug <= gme_debug.g_log_statement) THEN
2586: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: 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 2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);

2583: CLOSE cur_trans_detail;
2584:
2585: IF (g_debug <= gme_debug.g_log_statement) THEN
2586: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);

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

2584:
2585: IF (g_debug <= gme_debug.g_log_statement) THEN
2586: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);

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

2585: IF (g_debug <= gme_debug.g_log_statement) THEN
2586: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
2593: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);

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

2586: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_header_id: '||l_mmti_rec.transaction_header_id);
2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
2593: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
2594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);

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

2587: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.subinventory_code: '||l_mmti_rec.subinventory_code);
2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
2593: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
2594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
2595: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);

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

2588: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_uom: '||l_mmti_rec.transaction_uom);
2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
2593: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
2594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
2595: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
2596: END IF;

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

2589: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.inventory_item_id: '||l_mmti_rec.inventory_item_id);
2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
2593: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
2594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
2595: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
2596: END IF;
2597:

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

2590: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.trx_source_line_id: '||l_mmti_rec.trx_source_line_id);
2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
2593: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
2594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
2595: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
2596: END IF;
2597:
2598: IF l_mmti_rec.transaction_source_id IS NOT NULL THEN

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

2591: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.revision: '||l_mmti_rec.revision);
2592: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_source_id: '||l_mmti_rec.transaction_source_id);
2593: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.locator_id: '||l_mmti_rec.locator_id);
2594: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'l_mmti_rec.transaction_type_id: '||l_mmti_rec.transaction_type_id);
2595: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_transaction_interface_id: '||p_transaction_interface_id);
2596: END IF;
2597:
2598: IF l_mmti_rec.transaction_source_id IS NOT NULL THEN
2599: l_batch_hdr_rec.batch_id := l_mmti_rec.transaction_source_id;

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

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

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

2689: IF cur_get_item_rec%NOTFOUND THEN
2690: CLOSE cur_get_item_rec;
2691: gme_common_pvt.log_message ('PM_INVALID_ITEM');
2692: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2693: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
2694: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
2695: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
2696: END IF;
2697: RAISE item_not_found;

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

2690: CLOSE cur_get_item_rec;
2691: gme_common_pvt.log_message ('PM_INVALID_ITEM');
2692: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2693: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
2694: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
2695: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
2696: END IF;
2697: RAISE item_not_found;
2698: END IF;

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

2691: gme_common_pvt.log_message ('PM_INVALID_ITEM');
2692: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2693: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
2694: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (l_mmti_rec.inventory_item_id));
2695: gme_debug.put_line('organization_id = '|| TO_CHAR (l_mmti_rec.organization_id));
2696: END IF;
2697: RAISE item_not_found;
2698: END IF;
2699: CLOSE cur_get_item_rec;

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

2696: END IF;
2697: RAISE item_not_found;
2698: END IF;
2699: CLOSE cur_get_item_rec;
2700: IF (g_debug <= gme_debug.g_log_statement) THEN
2701: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
2702: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
2703: END IF;
2704:

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

2697: RAISE item_not_found;
2698: END IF;
2699: CLOSE cur_get_item_rec;
2700: IF (g_debug <= gme_debug.g_log_statement) THEN
2701: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
2702: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
2703: END IF;
2704:
2705: /* Bug 5358129 for ingredients lots should exist */

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

2698: END IF;
2699: CLOSE cur_get_item_rec;
2700: IF (g_debug <= gme_debug.g_log_statement) THEN
2701: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
2702: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
2703: END IF;
2704:
2705: /* Bug 5358129 for ingredients lots should exist */
2706: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN

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

2719: IF l_mmti_rec.transaction_type_id IN
2720: (gme_common_pvt.g_byprod_return
2721: ,gme_common_pvt.g_prod_return
2722: ,gme_common_pvt.g_ing_return) THEN
2723: IF (g_debug <= gme_debug.g_log_statement) THEN
2724: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||
2725: 'Return transaction for : '||l_mmti_rec.transaction_type_id);
2726:
2727: END IF;

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

2720: (gme_common_pvt.g_byprod_return
2721: ,gme_common_pvt.g_prod_return
2722: ,gme_common_pvt.g_ing_return) THEN
2723: IF (g_debug <= gme_debug.g_log_statement) THEN
2724: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||
2725: 'Return transaction for : '||l_mmti_rec.transaction_type_id);
2726:
2727: END IF;
2728: IF l_item_rec.lot_control_code = 1 THEN

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

2725: 'Return transaction for : '||l_mmti_rec.transaction_type_id);
2726:
2727: END IF;
2728: IF l_item_rec.lot_control_code = 1 THEN
2729: IF (g_debug <= gme_debug.g_log_statement) THEN
2730: gme_debug.put_line ( g_pkg_name
2731: || '.'
2732: || l_api_name
2733: || ':'

Line 2730: gme_debug.put_line ( g_pkg_name

2726:
2727: END IF;
2728: IF l_item_rec.lot_control_code = 1 THEN
2729: IF (g_debug <= gme_debug.g_log_statement) THEN
2730: gme_debug.put_line ( g_pkg_name
2731: || '.'
2732: || l_api_name
2733: || ':'
2734: || 'Item is NOT lot_control: '

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

2743:
2744: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
2745: RAISE fnd_api.g_exc_unexpected_error;
2746: END IF;
2747: IF (g_debug <= gme_debug.g_log_statement) THEN
2748: gme_debug.put_line ( g_pkg_name
2749: || '.'
2750: || l_api_name
2751: || ':'

Line 2748: gme_debug.put_line ( g_pkg_name

2744: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
2745: RAISE fnd_api.g_exc_unexpected_error;
2746: END IF;
2747: IF (g_debug <= gme_debug.g_log_statement) THEN
2748: gme_debug.put_line ( g_pkg_name
2749: || '.'
2750: || l_api_name
2751: || ':'
2752: || 'Returning Qty '

Line 2754: gme_debug.put_line ( g_pkg_name

2750: || l_api_name
2751: || ':'
2752: || 'Returning Qty '
2753: || l_mmti_rec.transaction_quantity);
2754: gme_debug.put_line ( g_pkg_name
2755: || '.'
2756: || l_api_name
2757: || ':'
2758: || 'Available to Return '

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

2763: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
2764: RAISE fnd_api.g_exc_error;
2765: END IF;
2766: ELSE /* Lot Control */
2767: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2768: gme_debug.put_line ( g_pkg_name
2769: || '.'
2770: || l_api_name
2771: || ':'

Line 2768: gme_debug.put_line ( g_pkg_name

2764: RAISE fnd_api.g_exc_error;
2765: END IF;
2766: ELSE /* Lot Control */
2767: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2768: gme_debug.put_line ( g_pkg_name
2769: || '.'
2770: || l_api_name
2771: || ':'
2772: || 'Item is lot control: '

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

2784:
2785: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
2786: RAISE fnd_api.g_exc_unexpected_error;
2787: END IF;
2788: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2789: gme_debug.put_line ( g_pkg_name
2790: || '.'
2791: || l_api_name
2792: || ':'

Line 2789: gme_debug.put_line ( g_pkg_name

2785: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
2786: RAISE fnd_api.g_exc_unexpected_error;
2787: END IF;
2788: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
2789: gme_debug.put_line ( g_pkg_name
2790: || '.'
2791: || l_api_name
2792: || ':'
2793: || 'Returning qty: '|| get_rec.l_mtli_lot_qty);

Line 2794: gme_debug.put_line ( g_pkg_name

2790: || '.'
2791: || l_api_name
2792: || ':'
2793: || 'Returning qty: '|| get_rec.l_mtli_lot_qty);
2794: gme_debug.put_line ( g_pkg_name
2795: || '.'
2796: || l_api_name
2797: || ':'
2798: || 'Available to Return '

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

2807: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */
2808: END IF; /* IF transaction_type_id in RETURNS */
2809: END IF; /* update_inventory_ind = 'Y' */
2810:
2811: IF (g_debug <= gme_debug.g_log_statement) THEN
2812: gme_debug.put_line ( g_pkg_name
2813: || '.'
2814: || l_api_name
2815: || ':'

Line 2812: gme_debug.put_line ( g_pkg_name

2808: END IF; /* IF transaction_type_id in RETURNS */
2809: END IF; /* update_inventory_ind = 'Y' */
2810:
2811: IF (g_debug <= gme_debug.g_log_statement) THEN
2812: gme_debug.put_line ( g_pkg_name
2813: || '.'
2814: || l_api_name
2815: || ':'
2816: || 'Exiting with '

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

2830: WHEN OTHERS THEN
2831: x_return_status := fnd_api.g_ret_sts_unexp_error;
2832: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2833:
2834: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2835: gme_debug.put_line ( g_pkg_name
2836: || '.'
2837: || l_api_name
2838: || ':'

Line 2835: gme_debug.put_line ( g_pkg_name

2831: x_return_status := fnd_api.g_ret_sts_unexp_error;
2832: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2833:
2834: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
2835: gme_debug.put_line ( g_pkg_name
2836: || '.'
2837: || l_api_name
2838: || ':'
2839: || 'WHEN OTHERS:'

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

2878: -- Initially let us assign the return status to success
2879:
2880: l_transaction_interface_id := p_transaction_interface_id;
2881:
2882: IF (g_debug <= gme_debug.g_log_statement) THEN
2883: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2884: || 'Entering');
2885: END IF;
2886:

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

2879:
2880: l_transaction_interface_id := p_transaction_interface_id;
2881:
2882: IF (g_debug <= gme_debug.g_log_statement) THEN
2883: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
2884: || 'Entering');
2885: END IF;
2886:
2887: -- based on message call count and get

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

2894: ,error_explanation = NVL (x_message_list, l_errm)
2895: ,process_flag = 3 -- we can make it a constant in gme common
2896: WHERE transaction_interface_id = l_transaction_interface_id;
2897:
2898: IF (g_debug <= gme_debug.g_log_statement) THEN
2899: gme_debug.put_line ( g_pkg_name
2900: || '.'
2901: || l_api_name
2902: || ':'

Line 2899: gme_debug.put_line ( g_pkg_name

2895: ,process_flag = 3 -- we can make it a constant in gme common
2896: WHERE transaction_interface_id = l_transaction_interface_id;
2897:
2898: IF (g_debug <= gme_debug.g_log_statement) THEN
2899: gme_debug.put_line ( g_pkg_name
2900: || '.'
2901: || l_api_name
2902: || ':'
2903: || 'Exiting'

Line 2910: IF g_debug <= gme_debug.g_log_unexpected THEN

2906: EXCEPTION
2907: WHEN OTHERS THEN
2908: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2909:
2910: IF g_debug <= gme_debug.g_log_unexpected THEN
2911: gme_debug.put_line ( 'When others exception in '
2912: || g_pkg_name
2913: || '.'
2914: || l_api_name

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

2907: WHEN OTHERS THEN
2908: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2909:
2910: IF g_debug <= gme_debug.g_log_unexpected THEN
2911: gme_debug.put_line ( 'When others exception in '
2912: || g_pkg_name
2913: || '.'
2914: || l_api_name
2915: || ' Error is '

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

3023: BEGIN
3024: -- Initially let us assign the return status to success
3025: x_return_status := fnd_api.g_ret_sts_success;
3026:
3027: IF (g_debug <= gme_debug.g_log_statement) THEN
3028: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3029: || 'Entering with trans id: '||p_transaction_id);
3030:
3031: END IF;

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

3024: -- Initially let us assign the return status to success
3025: x_return_status := fnd_api.g_ret_sts_success;
3026:
3027: IF (g_debug <= gme_debug.g_log_statement) THEN
3028: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3029: || 'Entering with trans id: '||p_transaction_id);
3030:
3031: END IF;
3032:

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

3047: p_material_dtl_id => l_trx_source_line_id,
3048: p_transaction_id => l_transaction_id, -- Bug 6997483
3049: x_return_status => x_return_status);
3050:
3051: IF (g_debug <= gme_debug.g_log_statement) THEN
3052: gme_debug.put_line ( g_pkg_name
3053: || '.'
3054: || l_api_name
3055: || ':'

Line 3052: gme_debug.put_line ( g_pkg_name

3048: p_transaction_id => l_transaction_id, -- Bug 6997483
3049: x_return_status => x_return_status);
3050:
3051: IF (g_debug <= gme_debug.g_log_statement) THEN
3052: gme_debug.put_line ( g_pkg_name
3053: || '.'
3054: || l_api_name
3055: || ':'
3056: || 'transaction_id: '

Line 3058: gme_debug.put_line ( g_pkg_name

3054: || l_api_name
3055: || ':'
3056: || 'transaction_id: '
3057: || l_transaction_id);
3058: gme_debug.put_line ( g_pkg_name
3059: || '.'
3060: || l_api_name
3061: || ':'
3062: || 'transaction_source_id: '

Line 3064: gme_debug.put_line ( g_pkg_name

3060: || l_api_name
3061: || ':'
3062: || 'transaction_source_id: '
3063: || l_transaction_source_id);
3064: gme_debug.put_line ( g_pkg_name
3065: || '.'
3066: || l_api_name
3067: || ':'
3068: || 'trx_source_line_id: '

Line 3070: gme_debug.put_line ( g_pkg_name

3066: || l_api_name
3067: || ':'
3068: || 'trx_source_line_id: '
3069: || l_trx_source_line_id);
3070: gme_debug.put_line ( g_pkg_name
3071: || '.'
3072: || l_api_name
3073: || ':'
3074: || 'source_line_id: '

Line 3076: gme_debug.put_line ( g_pkg_name

3072: || l_api_name
3073: || ':'
3074: || 'source_line_id: '
3075: || l_source_line_id);
3076: gme_debug.put_line ( g_pkg_name
3077: || '.'
3078: || l_api_name
3079: || ':'
3080: || 'inventory_item_id: '

Line 3082: gme_debug.put_line ( g_pkg_name

3078: || l_api_name
3079: || ':'
3080: || 'inventory_item_id: '
3081: || l_inventory_item_id);
3082: gme_debug.put_line ( g_pkg_name
3083: || '.'
3084: || l_api_name
3085: || ':'
3086: || 'transaction refernce: '

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

3087: || l_transaction_reference);
3088: END IF;
3089:
3090: IF l_source_line_id <> -99 THEN
3091: IF (g_debug <= gme_debug.g_log_statement) THEN
3092: gme_debug.put_line ( g_pkg_name
3093: || '.'
3094: || l_api_name
3095: || ':'

Line 3092: gme_debug.put_line ( g_pkg_name

3088: END IF;
3089:
3090: IF l_source_line_id <> -99 THEN
3091: IF (g_debug <= gme_debug.g_log_statement) THEN
3092: gme_debug.put_line ( g_pkg_name
3093: || '.'
3094: || l_api_name
3095: || ':'
3096: || 'for inserting reverse transaction_id: '

Line 3098: gme_debug.put_line ( g_pkg_name

3094: || l_api_name
3095: || ':'
3096: || 'for inserting reverse transaction_id: '
3097: || l_transaction_id);
3098: gme_debug.put_line ( g_pkg_name
3099: || '.'
3100: || l_api_name
3101: || ':'
3102: || 'for inserting reverse source_line_id: '

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

3118: VALUES (l_transaction_source_id, l_trx_source_line_id
3119: ,l_transaction_id, l_source_line_id
3120: ,gme_common_pvt.g_pairs_reversal_type);
3121:
3122: IF (g_debug <= gme_debug.g_log_statement) THEN
3123: gme_debug.put_line ( g_pkg_name
3124: || '.'
3125: || l_api_name
3126: || ':'

Line 3123: gme_debug.put_line ( g_pkg_name

3119: ,l_transaction_id, l_source_line_id
3120: ,gme_common_pvt.g_pairs_reversal_type);
3121:
3122: IF (g_debug <= gme_debug.g_log_statement) THEN
3123: gme_debug.put_line ( g_pkg_name
3124: || '.'
3125: || l_api_name
3126: || ':'
3127: || 'after inserting reverse transaction_id: '

Line 3129: gme_debug.put_line ( g_pkg_name

3125: || l_api_name
3126: || ':'
3127: || 'after inserting reverse transaction_id: '
3128: || l_transaction_id);
3129: gme_debug.put_line ( g_pkg_name
3130: || '.'
3131: || l_api_name
3132: || ':'
3133: || 'after inserting reverse source_line_id: '

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

3142: (p_material_detail => l_mat_dtl_rec
3143: ,x_material_detail => l_mat_dtl_rec) THEN
3144: RAISE fnd_api.g_exc_error;
3145: END IF;
3146: IF (g_debug <= gme_debug.g_log_statement) THEN
3147: gme_debug.put_line
3148: ( g_pkg_name
3149: || '.'
3150: || l_api_name

Line 3147: gme_debug.put_line

3143: ,x_material_detail => l_mat_dtl_rec) THEN
3144: RAISE fnd_api.g_exc_error;
3145: END IF;
3146: IF (g_debug <= gme_debug.g_log_statement) THEN
3147: gme_debug.put_line
3148: ( g_pkg_name
3149: || '.'
3150: || l_api_name
3151: || ':'

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

3154: END IF;
3155:
3156:
3157: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL THEN
3158: IF (g_debug <= gme_debug.g_log_statement) THEN
3159: gme_debug.put_line
3160: ( g_pkg_name
3161: || '.'
3162: || l_api_name

Line 3159: gme_debug.put_line

3155:
3156:
3157: IF l_mat_dtl_rec.phantom_line_id IS NOT NULL THEN
3158: IF (g_debug <= gme_debug.g_log_statement) THEN
3159: gme_debug.put_line
3160: ( g_pkg_name
3161: || '.'
3162: || l_api_name
3163: || '.'

Line 3166: gme_debug.put_line

3162: || l_api_name
3163: || '.'
3164: || 'update row -phantom in pairs having l_trans_ref: '
3165: || l_transaction_reference);
3166: gme_debug.put_line
3167: ( g_pkg_name
3168: || '.'
3169: || l_api_name
3170: || '.'

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

3182: FROM gme_transaction_pairs
3183: WHERE transaction_id2 = l_transaction_id
3184: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
3185:
3186: IF (g_debug <= gme_debug.g_log_statement) THEN
3187: gme_debug.put_line
3188: ( g_pkg_name
3189: || '.'
3190: || l_api_name

Line 3187: gme_debug.put_line

3183: WHERE transaction_id2 = l_transaction_id
3184: AND pair_type = gme_common_pvt.g_pairs_phantom_type;
3185:
3186: IF (g_debug <= gme_debug.g_log_statement) THEN
3187: gme_debug.put_line
3188: ( g_pkg_name
3189: || '.'
3190: || l_api_name
3191: || '.'

Line 3194: gme_debug.put_line ( g_pkg_name

3190: || l_api_name
3191: || '.'
3192: || 'after update row -phantom l_trans_id1: '
3193: || l_gme_pairs_rec.transaction_id1);
3194: gme_debug.put_line ( g_pkg_name
3195: || '.'
3196: || l_api_name
3197: || '.'
3198: || 'after update row-phantom l_trans_ID2: '

Line 3200: gme_debug.put_line

3196: || l_api_name
3197: || '.'
3198: || 'after update row-phantom l_trans_ID2: '
3199: || l_gme_pairs_rec.transaction_id1);
3200: gme_debug.put_line
3201: ( g_pkg_name
3202: || '.'
3203: || l_api_name
3204: || '.'

Line 3207: gme_debug.put_line

3203: || l_api_name
3204: || '.'
3205: || 'insert row- after update -transaction_id1: '
3206: || l_gme_pairs_rec.transaction_id1);
3207: gme_debug.put_line
3208: ( g_pkg_name
3209: || '.'
3210: || l_api_name
3211: || '.'

Line 3214: gme_debug.put_line ( g_pkg_name

3210: || l_api_name
3211: || '.'
3212: || 'insert row- after update -transaction_id2: '
3213: || l_gme_pairs_rec.transaction_id2);
3214: gme_debug.put_line ( g_pkg_name
3215: || '.'
3216: || l_api_name
3217: || '.'
3218: || 'insert row- after update -batch_id:'

Line 3220: gme_debug.put_line ( g_pkg_name

3216: || l_api_name
3217: || '.'
3218: || 'insert row- after update -batch_id:'
3219: || l_transaction_source_id);
3220: gme_debug.put_line ( g_pkg_name
3221: || '.'
3222: || l_api_name
3223: || '.'
3224: || 'insert row- after update -mat_det_id: '

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

3235:
3236:
3237: EXCEPTION
3238: WHEN NO_DATA_FOUND THEN
3239: IF (g_debug <= gme_debug.g_log_statement) THEN
3240: gme_debug.put_line ( g_pkg_name
3241: || '.'
3242: || l_api_name
3243: || '.'

Line 3240: gme_debug.put_line ( g_pkg_name

3236:
3237: EXCEPTION
3238: WHEN NO_DATA_FOUND THEN
3239: IF (g_debug <= gme_debug.g_log_statement) THEN
3240: gme_debug.put_line ( g_pkg_name
3241: || '.'
3242: || l_api_name
3243: || '.'
3244: || 'No_data_found');

Line 3245: gme_debug.put_line ( g_pkg_name

3241: || '.'
3242: || l_api_name
3243: || '.'
3244: || 'No_data_found');
3245: gme_debug.put_line ( g_pkg_name
3246: || '.'
3247: || l_api_name
3248: || '.'
3249: || 'insert row-transaction_id1: '

Line 3251: gme_debug.put_line ( g_pkg_name

3247: || l_api_name
3248: || '.'
3249: || 'insert row-transaction_id1: '
3250: || l_transaction_id);
3251: gme_debug.put_line ( g_pkg_name
3252: || '.'
3253: || l_api_name
3254: || '.'
3255: || 'insert row-transaction_id2: '

Line 3257: gme_debug.put_line ( g_pkg_name

3253: || l_api_name
3254: || '.'
3255: || 'insert row-transaction_id2: '
3256: || l_transaction_reference);
3257: gme_debug.put_line ( g_pkg_name
3258: || '.'
3259: || l_api_name
3260: || '.'
3261: || 'insert row-batch_id: '

Line 3263: gme_debug.put_line ( g_pkg_name

3259: || l_api_name
3260: || '.'
3261: || 'insert row-batch_id: '
3262: || l_transaction_source_id);
3263: gme_debug.put_line ( g_pkg_name
3264: || '.'
3265: || l_api_name
3266: || '.'
3267: || 'insert row-material_detail_id: '

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

3326: l_trx_source_line_id);
3327: FETCH check_event_batchmtl_removed INTO l_exists;
3328: CLOSE check_event_batchmtl_removed;
3329:
3330: IF (g_debug <= gme_debug.g_log_statement) THEN
3331: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': '||'l_exists = '||
3332: TO_CHAR (l_exists));
3333: END IF;
3334:

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

3327: FETCH check_event_batchmtl_removed INTO l_exists;
3328: CLOSE check_event_batchmtl_removed;
3329:
3330: IF (g_debug <= gme_debug.g_log_statement) THEN
3331: gme_debug.put_line (g_pkg_name||'.'||l_api_name||': '||'l_exists = '||
3332: TO_CHAR (l_exists));
3333: END IF;
3334:
3335: -- Bug 5763818

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

3344: ,x_material_detail => l_mat_dtl_rec) THEN
3345: RAISE fnd_api.g_exc_error;
3346: END IF;
3347:
3348: IF (g_debug <= gme_debug.g_log_statement) THEN
3349: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' mat_id '|| l_mat_dtl_rec.material_detail_id );
3350: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' DTL_UM '|| l_mat_dtl_rec.dtl_um );
3351:
3352: END IF;

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

3345: RAISE fnd_api.g_exc_error;
3346: END IF;
3347:
3348: IF (g_debug <= gme_debug.g_log_statement) THEN
3349: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' mat_id '|| l_mat_dtl_rec.material_detail_id );
3350: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' DTL_UM '|| l_mat_dtl_rec.dtl_um );
3351:
3352: END IF;
3353: --sum for material_detail line

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

3346: END IF;
3347:
3348: IF (g_debug <= gme_debug.g_log_statement) THEN
3349: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' mat_id '|| l_mat_dtl_rec.material_detail_id );
3350: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||' DTL_UM '|| l_mat_dtl_rec.dtl_um );
3351:
3352: END IF;
3353: --sum for material_detail line
3354: /* Bug 5903208 Instead of directly getting sum now we get 1 lot at a time and also the sum */

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

3357: p_qty_tbl(get_rec.transaction_id||'@'||get_rec.lot_number).doc_qty := get_rec.doc_qty;
3358: END LOOP;
3359:
3360: -- now update the qty to material_detail
3361: IF (g_debug <= gme_debug.g_log_statement) THEN
3362: gme_debug.put_line ( g_pkg_name
3363: || '.'
3364: || l_api_name
3365: || ':Actual Quantity '

Line 3362: gme_debug.put_line ( g_pkg_name

3358: END LOOP;
3359:
3360: -- now update the qty to material_detail
3361: IF (g_debug <= gme_debug.g_log_statement) THEN
3362: gme_debug.put_line ( g_pkg_name
3363: || '.'
3364: || l_api_name
3365: || ':Actual Quantity '
3366: || l_actual_qty);

Line 3367: gme_debug.put_line ( g_pkg_name

3363: || '.'
3364: || l_api_name
3365: || ':Actual Quantity '
3366: || l_actual_qty);
3367: gme_debug.put_line ( g_pkg_name
3368: || '.'
3369: || l_api_name
3370: || ': TRX_SOURCE_LINE_ID '
3371: || l_trx_source_line_id);

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

3391: -- Pawan Kumar add bug 5709186
3392: -- in case transaction added from transaction form, l_source_line_id is null.
3393: AND nvl(l_source_line_id, -99) < 0 THEN
3394:
3395: IF (g_debug <= gme_debug.g_log_statement) THEN
3396: gme_debug.put_line ( g_pkg_name
3397: || '.'
3398: || l_api_name
3399: || ' Invoke transfer_reservation_to_inv ');

Line 3396: gme_debug.put_line ( g_pkg_name

3392: -- in case transaction added from transaction form, l_source_line_id is null.
3393: AND nvl(l_source_line_id, -99) < 0 THEN
3394:
3395: IF (g_debug <= gme_debug.g_log_statement) THEN
3396: gme_debug.put_line ( g_pkg_name
3397: || '.'
3398: || l_api_name
3399: || ' Invoke transfer_reservation_to_inv ');
3400: END IF;

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

3404: ,x_message_count => x_msg_count
3405: ,x_message_list => x_msg_data
3406: ,x_return_status => x_return_status);
3407:
3408: IF (g_debug <= gme_debug.g_log_statement) THEN
3409: gme_debug.put_line ( g_pkg_name
3410: || '.'
3411: || l_api_name
3412: || ' transfer_reservation_to_inv returns '

Line 3409: gme_debug.put_line ( g_pkg_name

3405: ,x_message_list => x_msg_data
3406: ,x_return_status => x_return_status);
3407:
3408: IF (g_debug <= gme_debug.g_log_statement) THEN
3409: gme_debug.put_line ( g_pkg_name
3410: || '.'
3411: || l_api_name
3412: || ' transfer_reservation_to_inv returns '
3413: || x_return_status);

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

3418: END IF;
3419: -- B4944024 END
3420:
3421: -- now check for negative qty
3422: IF (g_debug <= gme_debug.g_log_statement) THEN
3423: gme_debug.put_line ( g_pkg_name
3424: || '.'
3425: || l_api_name
3426: || ':'

Line 3423: gme_debug.put_line ( g_pkg_name

3419: -- B4944024 END
3420:
3421: -- now check for negative qty
3422: IF (g_debug <= gme_debug.g_log_statement) THEN
3423: gme_debug.put_line ( g_pkg_name
3424: || '.'
3425: || l_api_name
3426: || ':'
3427: || 'Exiting with '

Line 3442: IF g_debug <= gme_debug.g_log_unexpected THEN

3438: x_return_status := fnd_api.g_ret_sts_unexp_error;
3439: WHEN OTHERS THEN
3440: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3441:
3442: IF g_debug <= gme_debug.g_log_unexpected THEN
3443: gme_debug.put_line ( 'When others exception in '
3444: || g_pkg_name
3445: || '.'
3446: || l_api_name

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

3439: WHEN OTHERS THEN
3440: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3441:
3442: IF g_debug <= gme_debug.g_log_unexpected THEN
3443: gme_debug.put_line ( 'When others exception in '
3444: || g_pkg_name
3445: || '.'
3446: || l_api_name
3447: || ' Error is '

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

3478: BEGIN
3479: -- Initially let us assign the return status to success
3480: x_return_status := fnd_api.g_ret_sts_success;
3481:
3482: IF (g_debug <= gme_debug.g_log_statement) THEN
3483: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3484: || 'Entering');
3485: END IF;
3486:

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

3479: -- Initially let us assign the return status to success
3480: x_return_status := fnd_api.g_ret_sts_success;
3481:
3482: IF (g_debug <= gme_debug.g_log_statement) THEN
3483: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3484: || 'Entering');
3485: END IF;
3486:
3487: IF p_batch_id IS NULL AND p_material_detail_id IS NULL THEN

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

3493:
3494: l_batch_id := p_batch_id;
3495: l_material_detail_id := p_material_detail_id;
3496:
3497: IF (g_debug <= gme_debug.g_log_statement) THEN
3498: gme_debug.put_line ( g_pkg_name
3499: || '.'
3500: || l_api_name
3501: || ':'

Line 3498: gme_debug.put_line ( g_pkg_name

3494: l_batch_id := p_batch_id;
3495: l_material_detail_id := p_material_detail_id;
3496:
3497: IF (g_debug <= gme_debug.g_log_statement) THEN
3498: gme_debug.put_line ( g_pkg_name
3499: || '.'
3500: || l_api_name
3501: || ':'
3502: || 'batch_id:'

Line 3504: gme_debug.put_line ( g_pkg_name

3500: || l_api_name
3501: || ':'
3502: || 'batch_id:'
3503: || l_batch_id);
3504: gme_debug.put_line ( g_pkg_name
3505: || '.'
3506: || l_api_name
3507: || ':'
3508: || 'material_detail_id:'

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

3520: WHERE batch_id = l_batch_id
3521: AND material_detail_id = l_material_detail_id;
3522: END IF;
3523:
3524: IF (g_debug <= gme_debug.g_log_statement) THEN
3525: gme_debug.put_line ( g_pkg_name
3526: || '.'
3527: || l_api_name
3528: || ':'

Line 3525: gme_debug.put_line ( g_pkg_name

3521: AND material_detail_id = l_material_detail_id;
3522: END IF;
3523:
3524: IF (g_debug <= gme_debug.g_log_statement) THEN
3525: gme_debug.put_line ( g_pkg_name
3526: || '.'
3527: || l_api_name
3528: || ':'
3529: || 'Exiting with '

Line 3540: IF g_debug <= gme_debug.g_log_unexpected THEN

3536: x_return_status := fnd_api.g_ret_sts_unexp_error;
3537: WHEN OTHERS THEN
3538: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3539:
3540: IF g_debug <= gme_debug.g_log_unexpected THEN
3541: gme_debug.put_line ( 'When others exception in '
3542: || g_pkg_name
3543: || '.'
3544: || l_api_name

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

3537: WHEN OTHERS THEN
3538: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3539:
3540: IF g_debug <= gme_debug.g_log_unexpected THEN
3541: gme_debug.put_line ( 'When others exception in '
3542: || g_pkg_name
3543: || '.'
3544: || l_api_name
3545: || ' Error is '

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

3615: l_return NUMBER;
3616: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
3617: BEGIN
3618: IF (NVL (g_debug, 0) IN
3619: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
3620: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3621: || 'Entering');
3622: END IF;
3623:

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

3616: l_trans_rec GMF_LAYERS.TRANS_REC_TYPE;
3617: BEGIN
3618: IF (NVL (g_debug, 0) IN
3619: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
3620: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3621: || 'Entering');
3622: END IF;
3623:
3624: /* Jalaj Srivastava Bug 5109154

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

3626: free the quantity tree */
3627: /* Bug 5255959 added p_clear_qty_cache condition */
3628: --Bug#5584699
3629: IF (p_table = 2 AND p_clear_qty_cache = fnd_api.g_true) THEN
3630: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3631: gme_debug.put_line
3632: ( g_pkg_name
3633: || '.'
3634: || l_api_name

Line 3631: gme_debug.put_line

3627: /* Bug 5255959 added p_clear_qty_cache condition */
3628: --Bug#5584699
3629: IF (p_table = 2 AND p_clear_qty_cache = fnd_api.g_true) THEN
3630: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3631: gme_debug.put_line
3632: ( g_pkg_name
3633: || '.'
3634: || l_api_name
3635: || ':'

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

3637: END IF;
3638: inv_quantity_tree_pub.clear_quantity_cache;
3639: END IF;
3640:
3641: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3642: gme_debug.put_line
3643: ( g_pkg_name
3644: || '.'
3645: || l_api_name

Line 3642: gme_debug.put_line

3638: inv_quantity_tree_pub.clear_quantity_cache;
3639: END IF;
3640:
3641: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3642: gme_debug.put_line
3643: ( g_pkg_name
3644: || '.'
3645: || l_api_name
3646: || ':'

Line 3648: gme_debug.put_line ( g_pkg_name

3644: || '.'
3645: || l_api_name
3646: || ':'
3647: || 'Calling INV_TXN_MANAGER_PUB.process_transactions');
3648: gme_debug.put_line ( g_pkg_name
3649: || '.'
3650: || l_api_name
3651: || ':'
3652: || 'Transaction Header ID = '

Line 3654: gme_debug.put_line

3650: || l_api_name
3651: || ':'
3652: || 'Transaction Header ID = '
3653: || p_header_id);
3654: gme_debug.put_line
3655: ( g_pkg_name
3656: || '.'
3657: || l_api_name
3658: || ':'

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

3672: ,x_msg_count => x_msg_count
3673: ,x_msg_data => x_msg_data
3674: ,x_trans_count => x_trans_count);
3675:
3676: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3677: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'After calling INV_TXN_MANAGER_PUB.process_transactions l_return= '
3678: || l_return || ' x_return_status= '|| x_return_status
3679: || ' x_msg_data = '|| x_msg_data);
3680: END IF;

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

3673: ,x_msg_data => x_msg_data
3674: ,x_trans_count => x_trans_count);
3675:
3676: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3677: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'After calling INV_TXN_MANAGER_PUB.process_transactions l_return= '
3678: || l_return || ' x_return_status= '|| x_return_status
3679: || ' x_msg_data = '|| x_msg_data);
3680: END IF;
3681:

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

3700: ,p_token1_name => 'MESSAGE'
3701: ,p_token1_value => rec.error_explanation);
3702: --fnd_message.set_encoded (rec.error_explanation);
3703:
3704: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3705: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
3706: END IF;
3707: x_msg_count := x_msg_count + 1;
3708: x_msg_data := rec.error_explanation;

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

3701: ,p_token1_value => rec.error_explanation);
3702: --fnd_message.set_encoded (rec.error_explanation);
3703:
3704: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3705: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
3706: END IF;
3707: x_msg_count := x_msg_count + 1;
3708: x_msg_data := rec.error_explanation;
3709: END LOOP;

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

3716: ,p_token1_name => 'MESSAGE'
3717: ,p_token1_value => rec.error_explanation);
3718: --fnd_message.set_encoded (rec.error_explanation);
3719:
3720: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3721: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
3722: END IF;
3723: x_msg_count := x_msg_count + 1;
3724: x_msg_data := rec.error_explanation;

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

3717: ,p_token1_value => rec.error_explanation);
3718: --fnd_message.set_encoded (rec.error_explanation);
3719:
3720: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3721: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| rec.error_explanation);
3722: END IF;
3723: x_msg_count := x_msg_count + 1;
3724: x_msg_data := rec.error_explanation;
3725: END LOOP;

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

3796: l_trans_rec.created_by := trans_rec.created_by;
3797: l_trans_rec.last_update_login := trans_rec.last_update_login;
3798:
3799: IF trans_rec.transaction_action_id in (1, 27) THEN
3800: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3801: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers'); --xxxremove
3802: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers');
3803: END IF;
3804:

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

3797: l_trans_rec.last_update_login := trans_rec.last_update_login;
3798:
3799: IF trans_rec.transaction_action_id in (1, 27) THEN
3800: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3801: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers'); --xxxremove
3802: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers');
3803: END IF;
3804:
3805: l_trans_rec.doc_qty := -1 * l_trans_rec.doc_qty;

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

3798:
3799: IF trans_rec.transaction_action_id in (1, 27) THEN
3800: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3801: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers'); --xxxremove
3802: gme_debug.put_line('in process_txns for (INGR) actionID: ' || trans_rec.transaction_action_id || '...calling GMF outgoing layers');
3803: END IF;
3804:
3805: l_trans_rec.doc_qty := -1 * l_trans_rec.doc_qty;
3806:

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

3811: x_return_status => x_return_status,
3812: x_msg_count => x_msg_count,
3813: x_msg_data => x_msg_data);
3814: ELSIF trans_rec.transaction_action_id in (31, 32) THEN
3815: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3816: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...calling GMF incoming layers');
3817: END IF;
3818:
3819: --Bug#6322202 Added the below condition for byproducts

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

3812: x_msg_count => x_msg_count,
3813: x_msg_data => x_msg_data);
3814: ELSIF trans_rec.transaction_action_id in (31, 32) THEN
3815: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3816: gme_debug.put_line('in process_txns for (PROD) actionID: ' || trans_rec.transaction_action_id || '...calling GMF incoming layers');
3817: END IF;
3818:
3819: --Bug#6322202 Added the below condition for byproducts
3820: IF trans_rec.line_type <> 1 THEN

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

3833: x_return_status => x_return_status,
3834: x_msg_count => x_msg_count,
3835: x_msg_data => x_msg_data);
3836: END IF;
3837: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3838: 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
3839: END IF;
3840: ELSIF trans_rec.transaction_action_id in (33, 34) THEN
3841: NULL;

Line 3838: 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

3834: x_msg_count => x_msg_count,
3835: x_msg_data => x_msg_data);
3836: END IF;
3837: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3838: 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
3839: END IF;
3840: ELSIF trans_rec.transaction_action_id in (33, 34) THEN
3841: NULL;
3842: END IF;

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

3852: /* end temporary */
3853:
3854: IF (l_return = 0) AND (fnd_api.to_boolean (p_commit) ) THEN
3855: --empty the quantity tree cache
3856: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3857: gme_debug.put_line
3858: ( g_pkg_name
3859: || '.'
3860: || l_api_name

Line 3857: gme_debug.put_line

3853:
3854: IF (l_return = 0) AND (fnd_api.to_boolean (p_commit) ) THEN
3855: --empty the quantity tree cache
3856: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3857: gme_debug.put_line
3858: ( g_pkg_name
3859: || '.'
3860: || l_api_name
3861: || ':'

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

3867:
3868: gme_common_pvt.reset_txn_hdr_tbl; -- nsinghi bug#5176319
3869:
3870: IF (NVL (g_debug, 0) IN
3871: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
3872: gme_debug.put_line ( g_pkg_name
3873: || '.'
3874: || l_api_name
3875: || ':'

Line 3872: gme_debug.put_line ( g_pkg_name

3868: gme_common_pvt.reset_txn_hdr_tbl; -- nsinghi bug#5176319
3869:
3870: IF (NVL (g_debug, 0) IN
3871: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
3872: gme_debug.put_line ( g_pkg_name
3873: || '.'
3874: || l_api_name
3875: || ':'
3876: || 'Exiting with '

Line 3889: gme_debug.put_line ( g_pkg_name

3885: WHEN fnd_api.g_exc_unexpected_error THEN
3886: x_return_status := fnd_api.g_ret_sts_unexp_error;
3887:
3888: IF (NVL (g_debug, 0) > 0) THEN
3889: gme_debug.put_line ( g_pkg_name
3890: || '.'
3891: || l_api_name
3892: || ':'
3893: || 'UNEXPECTED:'

Line 3903: gme_debug.put_line ( g_pkg_name

3899: WHEN OTHERS THEN
3900: x_return_status := fnd_api.g_ret_sts_unexp_error;
3901:
3902: IF (NVL (g_debug, 0) > 0) THEN
3903: gme_debug.put_line ( g_pkg_name
3904: || '.'
3905: || l_api_name
3906: || ':'
3907: || 'OTHERS:'

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

3978: l_is_revision_control BOOLEAN := FALSE;
3979: l_is_lot_control BOOLEAN := FALSE;
3980: BEGIN
3981: IF (NVL (g_debug, 0) IN
3982: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
3983: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3984: || 'Entering');
3985: END IF;
3986:

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

3979: l_is_lot_control BOOLEAN := FALSE;
3980: BEGIN
3981: IF (NVL (g_debug, 0) IN
3982: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
3983: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
3984: || 'Entering');
3985: END IF;
3986:
3987: IF (p_revision IS NOT NULL) THEN

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

3991: IF (p_lot_number IS NOT NULL) THEN
3992: l_is_lot_control := TRUE;
3993: END IF;
3994:
3995: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3996: gme_debug.put_line ( g_pkg_name
3997: || '.'
3998: || l_api_name
3999: || ':'

Line 3996: gme_debug.put_line ( g_pkg_name

3992: l_is_lot_control := TRUE;
3993: END IF;
3994:
3995: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
3996: gme_debug.put_line ( g_pkg_name
3997: || '.'
3998: || l_api_name
3999: || ':'
4000: || 'Calling Inv_Quantity_Tree_Pub.Query_Quantities');

Line 4001: gme_debug.put_line ( g_pkg_name

3997: || '.'
3998: || l_api_name
3999: || ':'
4000: || 'Calling Inv_Quantity_Tree_Pub.Query_Quantities');
4001: gme_debug.put_line ( g_pkg_name
4002: || '.'
4003: || l_api_name
4004: || ':'
4005: || 'Organization ID = '

Line 4007: gme_debug.put_line ( g_pkg_name

4003: || l_api_name
4004: || ':'
4005: || 'Organization ID = '
4006: || p_organization_id);
4007: gme_debug.put_line ( g_pkg_name
4008: || '.'
4009: || l_api_name
4010: || ':'
4011: || 'Inventory Item ID = '

Line 4013: gme_debug.put_line ( g_pkg_name

4009: || l_api_name
4010: || ':'
4011: || 'Inventory Item ID = '
4012: || p_inventory_item_id);
4013: gme_debug.put_line ( g_pkg_name
4014: || '.'
4015: || l_api_name
4016: || ':'
4017: || 'Subinventory = '

Line 4019: gme_debug.put_line ( g_pkg_name

4015: || l_api_name
4016: || ':'
4017: || 'Subinventory = '
4018: || p_subinventory_code);
4019: gme_debug.put_line ( g_pkg_name
4020: || '.'
4021: || l_api_name
4022: || ':'
4023: || 'Lot Number = '

Line 4025: gme_debug.put_line ( g_pkg_name

4021: || l_api_name
4022: || ':'
4023: || 'Lot Number = '
4024: || p_lot_number);
4025: gme_debug.put_line ( g_pkg_name
4026: || '.'
4027: || l_api_name
4028: || ':'
4029: || 'Locator ID = '

Line 4031: gme_debug.put_line ( g_pkg_name

4027: || l_api_name
4028: || ':'
4029: || 'Locator ID = '
4030: || p_locator_id);
4031: gme_debug.put_line ( g_pkg_name
4032: || '.'
4033: || l_api_name
4034: || ':'
4035: || 'Item Revision = '

Line 4037: gme_debug.put_line ( g_pkg_name

4033: || l_api_name
4034: || ':'
4035: || 'Item Revision = '
4036: || p_revision);
4037: gme_debug.put_line ( g_pkg_name
4038: || '.'
4039: || l_api_name
4040: || ':'
4041: || 'Tree Mode = '

Line 4043: gme_debug.put_line ( g_pkg_name

4039: || l_api_name
4040: || ':'
4041: || 'Tree Mode = '
4042: || p_tree_mode);
4043: gme_debug.put_line ( g_pkg_name
4044: || '.'
4045: || l_api_name
4046: || ':'
4047: || 'Grade = '

Line 4049: gme_debug.put_line ( g_pkg_name

4045: || l_api_name
4046: || ':'
4047: || 'Grade = '
4048: || p_grade_code);
4049: gme_debug.put_line ( g_pkg_name
4050: || '.'
4051: || l_api_name
4052: || ':'
4053: || 'Lot Expiration Date = '

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

4095: ,p_lpn_id => p_lpn_id
4096: ,p_transfer_locator_id => p_transfer_locator_id);
4097:
4098: IF (NVL (g_debug, 0) IN
4099: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4100: gme_debug.put_line ( g_pkg_name
4101: || '.'
4102: || l_api_name
4103: || ':'

Line 4100: gme_debug.put_line ( g_pkg_name

4096: ,p_transfer_locator_id => p_transfer_locator_id);
4097:
4098: IF (NVL (g_debug, 0) IN
4099: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4100: gme_debug.put_line ( g_pkg_name
4101: || '.'
4102: || l_api_name
4103: || ':'
4104: || 'Exiting with '

Line 4116: gme_debug.put_line ( g_pkg_name

4112: WHEN fnd_api.g_exc_unexpected_error THEN
4113: x_return_status := fnd_api.g_ret_sts_unexp_error;
4114:
4115: IF (NVL (g_debug, 0) > 0) THEN
4116: gme_debug.put_line ( g_pkg_name
4117: || '.'
4118: || l_api_name
4119: || ':'
4120: || 'UNEXPECTED:'

Line 4130: gme_debug.put_line ( g_pkg_name

4126: WHEN OTHERS THEN
4127: x_return_status := fnd_api.g_ret_sts_unexp_error;
4128:
4129: IF (NVL (g_debug, 0) > 0) THEN
4130: gme_debug.put_line ( g_pkg_name
4131: || '.'
4132: || l_api_name
4133: || ':'
4134: || 'OTHERS:'

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

4211: l_is_revision_control BOOLEAN := FALSE;
4212: l_is_lot_control BOOLEAN := FALSE;
4213: BEGIN
4214: IF (NVL (g_debug, 0) IN
4215: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4216: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4217: || 'Entering');
4218: END IF;
4219:

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

4212: l_is_lot_control BOOLEAN := FALSE;
4213: BEGIN
4214: IF (NVL (g_debug, 0) IN
4215: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4216: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4217: || 'Entering');
4218: END IF;
4219:
4220: IF (p_revision IS NOT NULL) THEN

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

4224: IF (p_lot_number IS NOT NULL) THEN
4225: l_is_lot_control := TRUE;
4226: END IF;
4227:
4228: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4229: gme_debug.put_line
4230: ( g_pkg_name
4231: || '.'
4232: || l_api_name

Line 4229: gme_debug.put_line

4225: l_is_lot_control := TRUE;
4226: END IF;
4227:
4228: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
4229: gme_debug.put_line
4230: ( g_pkg_name
4231: || '.'
4232: || l_api_name
4233: || ':'

Line 4235: gme_debug.put_line ( g_pkg_name

4231: || '.'
4232: || l_api_name
4233: || ':'
4234: || 'Calling Inv_Quantity_Tree_Pub.Update_Quantities');
4235: gme_debug.put_line ( g_pkg_name
4236: || '.'
4237: || l_api_name
4238: || ':'
4239: || 'Organization ID = '

Line 4241: gme_debug.put_line ( g_pkg_name

4237: || l_api_name
4238: || ':'
4239: || 'Organization ID = '
4240: || p_organization_id);
4241: gme_debug.put_line ( g_pkg_name
4242: || '.'
4243: || l_api_name
4244: || ':'
4245: || 'Inventory Item ID = '

Line 4247: gme_debug.put_line ( g_pkg_name

4243: || l_api_name
4244: || ':'
4245: || 'Inventory Item ID = '
4246: || p_inventory_item_id);
4247: gme_debug.put_line ( g_pkg_name
4248: || '.'
4249: || l_api_name
4250: || ':'
4251: || 'Subinventory = '

Line 4253: gme_debug.put_line ( g_pkg_name

4249: || l_api_name
4250: || ':'
4251: || 'Subinventory = '
4252: || p_subinventory_code);
4253: gme_debug.put_line ( g_pkg_name
4254: || '.'
4255: || l_api_name
4256: || ':'
4257: || 'Lot Number = '

Line 4259: gme_debug.put_line ( g_pkg_name

4255: || l_api_name
4256: || ':'
4257: || 'Lot Number = '
4258: || p_lot_number);
4259: gme_debug.put_line ( g_pkg_name
4260: || '.'
4261: || l_api_name
4262: || ':'
4263: || 'Locator ID = '

Line 4265: gme_debug.put_line ( g_pkg_name

4261: || l_api_name
4262: || ':'
4263: || 'Locator ID = '
4264: || p_locator_id);
4265: gme_debug.put_line ( g_pkg_name
4266: || '.'
4267: || l_api_name
4268: || ':'
4269: || 'Item Revision = '

Line 4271: gme_debug.put_line ( g_pkg_name

4267: || l_api_name
4268: || ':'
4269: || 'Item Revision = '
4270: || p_revision);
4271: gme_debug.put_line ( g_pkg_name
4272: || '.'
4273: || l_api_name
4274: || ':'
4275: || 'Tree Mode = '

Line 4277: gme_debug.put_line ( g_pkg_name

4273: || l_api_name
4274: || ':'
4275: || 'Tree Mode = '
4276: || p_tree_mode);
4277: gme_debug.put_line ( g_pkg_name
4278: || '.'
4279: || l_api_name
4280: || ':'
4281: || 'Grade = '

Line 4283: gme_debug.put_line ( g_pkg_name

4279: || l_api_name
4280: || ':'
4281: || 'Grade = '
4282: || p_grade_code);
4283: gme_debug.put_line ( g_pkg_name
4284: || '.'
4285: || l_api_name
4286: || ':'
4287: || 'Lot Expiration Date = '

Line 4290: gme_debug.put_line ( g_pkg_name

4286: || ':'
4287: || 'Lot Expiration Date = '
4288: || TO_CHAR (p_lot_expiration_date
4289: ,'MM/DD/YYYY HH24:MI:SS') );
4290: gme_debug.put_line ( g_pkg_name
4291: || '.'
4292: || l_api_name
4293: || ':'
4294: || 'Quantity Type = '

Line 4296: gme_debug.put_line ( g_pkg_name

4292: || l_api_name
4293: || ':'
4294: || 'Quantity Type = '
4295: || p_quantity_type);
4296: gme_debug.put_line ( g_pkg_name
4297: || '.'
4298: || l_api_name
4299: || ':'
4300: || 'Primary Quantity = '

Line 4302: gme_debug.put_line ( g_pkg_name

4298: || l_api_name
4299: || ':'
4300: || 'Primary Quantity = '
4301: || p_primary_quantity);
4302: gme_debug.put_line ( g_pkg_name
4303: || '.'
4304: || l_api_name
4305: || ':'
4306: || 'Secondary Quantity = '

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

4351: ,p_transfer_locator_id => p_transfer_locator_id
4352: ,p_containerized => p_containerized);
4353:
4354: IF (NVL (g_debug, 0) IN
4355: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4356: gme_debug.put_line ( g_pkg_name
4357: || '.'
4358: || l_api_name
4359: || ':'

Line 4356: gme_debug.put_line ( g_pkg_name

4352: ,p_containerized => p_containerized);
4353:
4354: IF (NVL (g_debug, 0) IN
4355: (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4356: gme_debug.put_line ( g_pkg_name
4357: || '.'
4358: || l_api_name
4359: || ':'
4360: || 'Exiting with '

Line 4372: gme_debug.put_line ( g_pkg_name

4368: WHEN fnd_api.g_exc_unexpected_error THEN
4369: x_return_status := fnd_api.g_ret_sts_unexp_error;
4370:
4371: IF (NVL (g_debug, 0) > 0) THEN
4372: gme_debug.put_line ( g_pkg_name
4373: || '.'
4374: || l_api_name
4375: || ':'
4376: || 'UNEXPECTED:'

Line 4386: gme_debug.put_line ( g_pkg_name

4382: WHEN OTHERS THEN
4383: x_return_status := fnd_api.g_ret_sts_unexp_error;
4384:
4385: IF (NVL (g_debug, 0) > 0) THEN
4386: gme_debug.put_line ( g_pkg_name
4387: || '.'
4388: || l_api_name
4389: || ':'
4390: || 'OTHERS:'

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

4442: RETURN FALSE;
4443: EXCEPTION
4444: WHEN OTHERS THEN
4445: IF (NVL (g_debug, 0) > 0) THEN
4446: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4447: END IF;
4448: RETURN FALSE;
4449: END is_lot_expired;
4450:

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

4451: PROCEDURE insert_txn_inter_hdr(p_mmti_rec IN mtl_transactions_interface%ROWTYPE,
4452: x_return_status OUT NOCOPY VARCHAR2) IS
4453: l_api_name CONSTANT VARCHAR2 (30) := 'insert_txn_inter_hdr';
4454: BEGIN
4455: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4456: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
4457: END IF;
4458: x_return_status := fnd_api.g_ret_sts_success;
4459: INSERT INTO mtl_transactions_interface

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

4452: x_return_status OUT NOCOPY VARCHAR2) IS
4453: l_api_name CONSTANT VARCHAR2 (30) := 'insert_txn_inter_hdr';
4454: BEGIN
4455: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4456: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
4457: END IF;
4458: x_return_status := fnd_api.g_ret_sts_success;
4459: INSERT INTO mtl_transactions_interface
4460: (transaction_interface_id

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

4544: ,p_mmti_rec.transaction_batch_seq
4545: ,p_mmti_rec.reservation_quantity
4546: ,p_mmti_rec.transaction_sequence_id
4547: ,p_mmti_rec.transfer_lpn_id);
4548: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4549: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Exiting');
4550: END IF;
4551: EXCEPTION
4552: WHEN OTHERS THEN

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

4545: ,p_mmti_rec.reservation_quantity
4546: ,p_mmti_rec.transaction_sequence_id
4547: ,p_mmti_rec.transfer_lpn_id);
4548: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
4549: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Exiting');
4550: END IF;
4551: EXCEPTION
4552: WHEN OTHERS THEN
4553: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4551: EXCEPTION
4552: WHEN OTHERS THEN
4553: x_return_status := fnd_api.g_ret_sts_unexp_error;
4554: IF (NVL (g_debug, 0) > 0) THEN
4555: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4556: END IF;
4557: END insert_txn_inter_hdr;
4558:
4559: -- nsinghi bug#5176319. Added this proc.

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

4603:
4604: BEGIN
4605: x_return_status := fnd_api.g_ret_sts_success;
4606:
4607: IF (g_debug <= gme_debug.g_log_statement) THEN
4608: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4609: || 'Entering with transaction '||p_transaction_id);
4610: END IF;
4611:

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

4604: BEGIN
4605: x_return_status := fnd_api.g_ret_sts_success;
4606:
4607: IF (g_debug <= gme_debug.g_log_statement) THEN
4608: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4609: || 'Entering with transaction '||p_transaction_id);
4610: END IF;
4611:
4612: IF p_transaction_id IS NULL THEN

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

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

Line 4616: gme_debug.put_line ( g_pkg_name

4612: IF p_transaction_id IS NULL THEN
4613: gme_common_pvt.log_message ('GME_NO_KEYS', 'TABLE_NAME', l_api_name);
4614:
4615: IF (g_debug <= gme_debug.g_log_statement) THEN
4616: gme_debug.put_line ( g_pkg_name
4617: || '.'
4618: || l_api_name
4619: || ':'
4620: || 'TRANSACTION ID NEEDED FOR RETRIEVAL');

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

4625: OPEN cur_get_transaction (l_transaction_id);
4626: FETCH cur_get_transaction
4627: INTO x_mmt_rec;
4628: IF cur_get_transaction%FOUND THEN
4629: IF (g_debug <= gme_debug.g_log_statement) THEN
4630: gme_debug.put_line ( g_pkg_name
4631: || '.'
4632: || l_api_name
4633: || ':'

Line 4630: gme_debug.put_line ( g_pkg_name

4626: FETCH cur_get_transaction
4627: INTO x_mmt_rec;
4628: IF cur_get_transaction%FOUND THEN
4629: IF (g_debug <= gme_debug.g_log_statement) THEN
4630: gme_debug.put_line ( g_pkg_name
4631: || '.'
4632: || l_api_name
4633: || ':'
4634: || 'TRANSACTIONS found for '

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

4638: ,x_mmln_tbl => x_mmln_tbl
4639: ,x_return_status => l_return_status);
4640:
4641: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4642: IF (g_debug <= gme_debug.g_log_statement) THEN
4643: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4644: || 'error from get lot trans');
4645: END IF;
4646: RAISE fnd_api.g_exc_error;

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

4639: ,x_return_status => l_return_status);
4640:
4641: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4642: IF (g_debug <= gme_debug.g_log_statement) THEN
4643: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
4644: || 'error from get lot trans');
4645: END IF;
4646: RAISE fnd_api.g_exc_error;
4647: END IF;

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

4651: RAISE fnd_api.g_exc_error;
4652: END IF;
4653: CLOSE cur_get_transaction;
4654:
4655: IF (g_debug <= gme_debug.g_log_statement) THEN
4656: gme_debug.put_line ( g_pkg_name
4657: || '.'
4658: || l_api_name
4659: || ':'

Line 4656: gme_debug.put_line ( g_pkg_name

4652: END IF;
4653: CLOSE cur_get_transaction;
4654:
4655: IF (g_debug <= gme_debug.g_log_statement) THEN
4656: gme_debug.put_line ( g_pkg_name
4657: || '.'
4658: || l_api_name
4659: || ':'
4660: || 'TRANSACTION '

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

4660: || 'TRANSACTION '
4661: || x_mmt_rec.transaction_id);
4662: END IF;
4663:
4664: IF (g_debug <= gme_debug.g_log_statement) THEN
4665: gme_debug.put_line ( g_pkg_name
4666: || '.'
4667: || l_api_name
4668: || ':'

Line 4665: gme_debug.put_line ( g_pkg_name

4661: || x_mmt_rec.transaction_id);
4662: END IF;
4663:
4664: IF (g_debug <= gme_debug.g_log_statement) THEN
4665: gme_debug.put_line ( g_pkg_name
4666: || '.'
4667: || l_api_name
4668: || ':'
4669: || 'Exiting with '

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

4677: WHEN OTHERS THEN
4678: x_return_status := fnd_api.g_ret_sts_unexp_error;
4679: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4680:
4681: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4682: gme_debug.put_line ( g_pkg_name
4683: || '.'
4684: || l_api_name
4685: || ':'

Line 4682: gme_debug.put_line ( g_pkg_name

4678: x_return_status := fnd_api.g_ret_sts_unexp_error;
4679: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4680:
4681: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4682: gme_debug.put_line ( g_pkg_name
4683: || '.'
4684: || l_api_name
4685: || ':'
4686: || 'WHEN OTHERS:'

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

4703: l_date DATE;
4704: expired_lot EXCEPTION;
4705: invalid_lot EXCEPTION;
4706: BEGIN
4707: IF (g_debug <= gme_debug.g_log_procedure) THEN
4708: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering with organization_id = '||p_organization_id
4709: ||' inventory_item_id = '||p_inventory_item_id||' lot_number = '||p_lot_number);
4710: END IF;
4711: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

4704: expired_lot EXCEPTION;
4705: invalid_lot EXCEPTION;
4706: BEGIN
4707: IF (g_debug <= gme_debug.g_log_procedure) THEN
4708: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering with organization_id = '||p_organization_id
4709: ||' inventory_item_id = '||p_inventory_item_id||' lot_number = '||p_lot_number);
4710: END IF;
4711: x_return_status := FND_API.G_RET_STS_SUCCESS;
4712: OPEN Cur_get_lot;

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

4718: CLOSE Cur_get_lot;
4719: IF (l_date IS NOT NULL AND l_date < sysdate) THEN
4720: RAISE expired_lot;
4721: END IF;
4722: IF (g_debug <= gme_debug.g_log_procedure) THEN
4723: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Normal Exiting');
4724: END IF;
4725: EXCEPTION
4726: WHEN expired_lot THEN

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

4719: IF (l_date IS NOT NULL AND l_date < sysdate) THEN
4720: RAISE expired_lot;
4721: END IF;
4722: IF (g_debug <= gme_debug.g_log_procedure) THEN
4723: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Normal Exiting');
4724: END IF;
4725: EXCEPTION
4726: WHEN expired_lot THEN
4727: gme_common_pvt.log_message(p_message_code => 'INV_LOT_EXPIRED',

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

4733: p_product_code => 'INV');
4734: WHEN OTHERS THEN
4735: x_return_status := fnd_api.g_ret_sts_unexp_error;
4736: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4737: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4738: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4739: END IF;
4740: END validate_lot_for_ing;
4741:

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

4734: WHEN OTHERS THEN
4735: x_return_status := fnd_api.g_ret_sts_unexp_error;
4736: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4737: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4738: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4739: END IF;
4740: END validate_lot_for_ing;
4741:
4742: /* Added for bug 5597385 */

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

4766: l_api_name CONSTANT VARCHAR2(30) := 'GMO_PRE_PROCESS_VAL';
4767: BEGIN
4768: -- Initially let us assign the return status to success
4769: x_return_status := fnd_api.g_ret_sts_success;
4770: IF (g_debug <= gme_debug.g_log_statement) THEN
4771: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
4772: END IF;
4773: IF (g_debug <= gme_debug.g_log_statement) THEN
4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);

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

4767: BEGIN
4768: -- Initially let us assign the return status to success
4769: x_return_status := fnd_api.g_ret_sts_success;
4770: IF (g_debug <= gme_debug.g_log_statement) THEN
4771: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
4772: END IF;
4773: IF (g_debug <= gme_debug.g_log_statement) THEN
4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);

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

4769: x_return_status := fnd_api.g_ret_sts_success;
4770: IF (g_debug <= gme_debug.g_log_statement) THEN
4771: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
4772: END IF;
4773: IF (g_debug <= gme_debug.g_log_statement) THEN
4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);

Line 4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);

4770: IF (g_debug <= gme_debug.g_log_statement) THEN
4771: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
4772: END IF;
4773: IF (g_debug <= gme_debug.g_log_statement) THEN
4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: 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 4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);

4771: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| 'Entering');
4772: END IF;
4773: IF (g_debug <= gme_debug.g_log_statement) THEN
4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);

Line 4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);

4772: END IF;
4773: IF (g_debug <= gme_debug.g_log_statement) THEN
4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);

Line 4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);

4773: IF (g_debug <= gme_debug.g_log_statement) THEN
4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
4781: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);

Line 4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);

4774: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_header_id: '||p_mmti_rec.transaction_header_id);
4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
4781: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
4782: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);

Line 4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);

4775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.subinventory_code: '||p_mmti_rec.subinventory_code);
4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
4781: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
4782: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
4783: END IF;

Line 4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);

4776: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_uom: '||p_mmti_rec.transaction_uom);
4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
4781: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
4782: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
4783: END IF;
4784: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN

Line 4781: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);

4777: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.inventory_item_id: '||p_mmti_rec.inventory_item_id);
4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
4781: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
4782: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
4783: END IF;
4784: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN
4785: l_batch_hdr_rec.batch_id := p_mmti_rec.transaction_source_id;

Line 4782: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);

4778: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.trx_source_line_id: '||p_mmti_rec.trx_source_line_id);
4779: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.revision: '||p_mmti_rec.revision);
4780: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_source_id: '||p_mmti_rec.transaction_source_id);
4781: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.locator_id: '||p_mmti_rec.locator_id);
4782: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'p_mmti_rec.transaction_type_id: '||p_mmti_rec.transaction_type_id);
4783: END IF;
4784: IF p_mmti_rec.transaction_source_id IS NOT NULL THEN
4785: l_batch_hdr_rec.batch_id := p_mmti_rec.transaction_source_id;
4786: IF NOT gme_batch_header_dbl.fetch_row(l_batch_hdr_rec, l_batch_hdr_rec) THEN

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

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

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

4835: IF cur_get_item_rec%NOTFOUND THEN
4836: CLOSE cur_get_item_rec;
4837: gme_common_pvt.log_message ('PM_INVALID_ITEM');
4838: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4839: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
4840: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
4841: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
4842: END IF;
4843: RAISE item_not_found;

Line 4840: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));

4836: CLOSE cur_get_item_rec;
4837: gme_common_pvt.log_message ('PM_INVALID_ITEM');
4838: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4839: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
4840: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
4841: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
4842: END IF;
4843: RAISE item_not_found;
4844: END IF;

Line 4841: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));

4837: gme_common_pvt.log_message ('PM_INVALID_ITEM');
4838: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4839: gme_debug.put_line('Item cursor fetch no record in mtl_system_items_b: ');
4840: gme_debug.put_line('inventory_item_id = '|| TO_CHAR (p_mmti_rec.inventory_item_id));
4841: gme_debug.put_line('organization_id = '|| TO_CHAR (p_mmti_rec.organization_id));
4842: END IF;
4843: RAISE item_not_found;
4844: END IF;
4845: CLOSE cur_get_item_rec;

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

4842: END IF;
4843: RAISE item_not_found;
4844: END IF;
4845: CLOSE cur_get_item_rec;
4846: IF (g_debug <= gme_debug.g_log_statement) THEN
4847: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
4848: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
4849: END IF;
4850:

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

4843: RAISE item_not_found;
4844: END IF;
4845: CLOSE cur_get_item_rec;
4846: IF (g_debug <= gme_debug.g_log_statement) THEN
4847: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
4848: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
4849: END IF;
4850:
4851: /* Bug 5358129 for ingredients lots should exist */

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

4844: END IF;
4845: CLOSE cur_get_item_rec;
4846: IF (g_debug <= gme_debug.g_log_statement) THEN
4847: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item lot_control Code: '|| l_item_rec.lot_control_code);
4848: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item loct_control Code: '|| l_item_rec.location_control_code);
4849: END IF;
4850:
4851: /* Bug 5358129 for ingredients lots should exist */
4852: IF (l_mat_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND l_mat_dtl_rec.phantom_type = 0 AND l_item_rec.lot_control_code = 2) THEN

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

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

Line 4866: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);

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

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

4865: IF (g_debug <= gme_debug.g_log_statement) THEN
4866: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);
4867: END IF;
4868: IF l_item_rec.lot_control_code = 1 THEN
4869: IF (g_debug <= gme_debug.g_log_statement) THEN
4870: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is NOT lot_control: '|| l_item_rec.lot_control_code);
4871: END IF;
4872: get_returnable_qty(p_mmti_rec => p_mmti_rec
4873: ,p_lot_number => NULL

Line 4870: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is NOT lot_control: '|| l_item_rec.lot_control_code);

4866: gme_debug.put_line(g_pkg_name||'.'||l_api_name||':'||'Return transaction for : '||p_mmti_rec.transaction_type_id);
4867: END IF;
4868: IF l_item_rec.lot_control_code = 1 THEN
4869: IF (g_debug <= gme_debug.g_log_statement) THEN
4870: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is NOT lot_control: '|| l_item_rec.lot_control_code);
4871: END IF;
4872: get_returnable_qty(p_mmti_rec => p_mmti_rec
4873: ,p_lot_number => NULL
4874: ,p_lot_control => l_item_rec.lot_control_code

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

4876: ,x_return_status => x_return_status);
4877: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4878: RAISE fnd_api.g_exc_unexpected_error;
4879: END IF;
4880: IF (g_debug <= gme_debug.g_log_statement) THEN
4881: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);
4882: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4883: END IF;
4884: IF ABS (l_available_qty) < ABS (p_mmti_rec.transaction_quantity) THEN

Line 4881: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);

4877: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4878: RAISE fnd_api.g_exc_unexpected_error;
4879: END IF;
4880: IF (g_debug <= gme_debug.g_log_statement) THEN
4881: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);
4882: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4883: END IF;
4884: IF ABS (l_available_qty) < ABS (p_mmti_rec.transaction_quantity) THEN
4885: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

Line 4882: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);

4878: RAISE fnd_api.g_exc_unexpected_error;
4879: END IF;
4880: IF (g_debug <= gme_debug.g_log_statement) THEN
4881: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning Qty '|| p_mmti_rec.transaction_quantity);
4882: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4883: END IF;
4884: IF ABS (l_available_qty) < ABS (p_mmti_rec.transaction_quantity) THEN
4885: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
4886: RAISE fnd_api.g_exc_error;

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

4885: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
4886: RAISE fnd_api.g_exc_error;
4887: END IF;
4888: ELSE /* Lot Control */
4889: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4890: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is lot control: '|| l_item_rec.lot_control_code);
4891: END IF;
4892: FOR i IN 1..p_mmli_tbl.COUNT LOOP
4893: get_returnable_qty(p_mmti_rec => p_mmti_rec

Line 4890: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is lot control: '|| l_item_rec.lot_control_code);

4886: RAISE fnd_api.g_exc_error;
4887: END IF;
4888: ELSE /* Lot Control */
4889: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4890: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Item is lot control: '|| l_item_rec.lot_control_code);
4891: END IF;
4892: FOR i IN 1..p_mmli_tbl.COUNT LOOP
4893: get_returnable_qty(p_mmti_rec => p_mmti_rec
4894: ,p_lot_number => p_mmli_tbl(i).lot_number

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

4897: ,x_return_status => x_return_status);
4898: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
4899: RAISE fnd_api.g_exc_unexpected_error;
4900: END IF;
4901: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4902: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);
4903: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4904: END IF;
4905: IF ABS(l_available_qty) < ABS(p_mmli_tbl(i).transaction_quantity) THEN

Line 4902: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);

4898: IF x_return_Status <> fnd_api.g_ret_sts_success THEN
4899: RAISE fnd_api.g_exc_unexpected_error;
4900: END IF;
4901: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4902: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);
4903: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4904: END IF;
4905: IF ABS(l_available_qty) < ABS(p_mmli_tbl(i).transaction_quantity) THEN
4906: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');

Line 4903: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);

4899: RAISE fnd_api.g_exc_unexpected_error;
4900: END IF;
4901: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
4902: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Returning qty: '|| p_mmli_tbl(i).transaction_quantity);
4903: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Available to Return '|| l_available_qty);
4904: END IF;
4905: IF ABS(l_available_qty) < ABS(p_mmli_tbl(i).transaction_quantity) THEN
4906: gme_common_pvt.log_message ('GME_QTY_LESS_THEN_ISSUED');
4907: RAISE fnd_api.g_exc_error;

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

4909: END LOOP;
4910: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */
4911: END IF; /* IF transaction_type_id in RETURNS */
4912: END IF; /* update_inventory_ind = 'Y' */
4913: IF (g_debug <= gme_debug.g_log_statement) THEN
4914: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Exiting with '|| x_return_status);
4915: END IF;
4916: EXCEPTION
4917: WHEN lot_val_err THEN

Line 4914: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Exiting with '|| x_return_status);

4910: END IF; /* IF l_item_rec.lot_control_code = 1 THEN */
4911: END IF; /* IF transaction_type_id in RETURNS */
4912: END IF; /* update_inventory_ind = 'Y' */
4913: IF (g_debug <= gme_debug.g_log_statement) THEN
4914: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'Exiting with '|| x_return_status);
4915: END IF;
4916: EXCEPTION
4917: WHEN lot_val_err THEN
4918: x_return_status := l_return_status;

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

4922: x_return_status := fnd_api.g_ret_sts_unexp_error;
4923: WHEN OTHERS THEN
4924: x_return_status := fnd_api.g_ret_sts_unexp_error;
4925: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4926: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4927: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4928: END IF;
4929: END gmo_pre_process_val;
4930: END gme_transactions_pvt;

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

4923: WHEN OTHERS THEN
4924: x_return_status := fnd_api.g_ret_sts_unexp_error;
4925: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
4926: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
4927: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':'|| 'WHEN OTHERS:'|| SQLERRM);
4928: END IF;
4929: END gmo_pre_process_val;
4930: END gme_transactions_pvt;