eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_SHIKYU_RPT_CFR_PVT dependencies on FND_LOG

Line 51: --| 16-JAN-2006 shu using FND_LOG.STRING for logging standard |

47: --| warning if SHIKYU profile is disable |
48: --| 05-DEC-2005 shu Fixed some no data issue due to null columns |
49: --| 07-DEC-2005 shu added procedures rpt_get_xxx for report data |
50: --| 21-DEC-2005 shu tuning SQLperformance in get_onhand_components|
51: --| 16-JAN-2006 shu using FND_LOG.STRING for logging standard |
52: --| 19-JAN-2006 shu changed parameter p_currency_conversion_date |
53: --| from date to varchar2; |
54: --| added rpt_debug_show_mid_data procedure |
55: --| added rpt_debug_show_temp_data procedure |

Line 283: p_output_to => 'FND_LOG.STRING'

279:
280: -- **** for debug information in readonly UT environment.--- begin ****
281: JMF_SHIKYU_RPT_UTIL.debug_output
282: (
283: p_output_to => 'FND_LOG.STRING'
284: ,p_api_name => G_MODULE_PREFIX || l_api_name || '.begin'
285: ,p_message => 'CVS Version(v 2.26 2006/02/14):' ||
286: ',p_rpt_mode:' || p_rpt_mode ||
287: ',p_ou_id :' || g_ou_id ||

Line 334: p_output_to => 'FND_LOG.STRING'

330: END IF;
331: -- **** for debug information in readonly UT environment.--- begin ****
332: JMF_SHIKYU_RPT_UTIL.debug_output
333: (
334: p_output_to => 'FND_LOG.STRING'
335: ,p_api_name => G_MODULE_PREFIX || l_api_name
336: ,p_message => 'l_functional_currency:' || l_functional_currency ||
337: ',l_currency_conversion_date:' || l_currency_conversion_date
338: );

Line 342: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

338: );
339: -- **** for debug information in readonly UT environment.--- end ****
340:
341: IF g_fnd_debug = 'Y' AND
342: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
343: THEN
344: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
345: , g_module_prefix || l_api_name || '.begin'
346: , NULL);

Line 344: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

340:
341: IF g_fnd_debug = 'Y' AND
342: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
343: THEN
344: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
345: , g_module_prefix || l_api_name || '.begin'
346: , NULL);
347: END IF;
348:

Line 361: FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

357: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
358: ,message => l_jmf_shk_not_enabled);
359:
360: IF g_fnd_debug = 'Y' AND
361: FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
362: THEN
363: IF l_conc_succ
364: THEN
365: fnd_log.STRING( FND_LOG.LEVEL_ERROR

Line 365: fnd_log.STRING( FND_LOG.LEVEL_ERROR

361: FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
362: THEN
363: IF l_conc_succ
364: THEN
365: fnd_log.STRING( FND_LOG.LEVEL_ERROR
366: ,g_module_prefix || l_api_name || '.Warning'
367: ,l_jmf_shk_not_enabled);
368: END IF;
369: END IF;

Line 385: p_output_to => 'FND_LOG.STRING'

381: --get the on hand components information,with inv_org,item_id
382: -- **** for debug information in readonly UT environment.--- begin ****
383: JMF_SHIKYU_RPT_UTIL.debug_output
384: (
385: p_output_to => 'FND_LOG.STRING'
386: ,p_api_name => G_MODULE_PREFIX || l_api_name
387: ,p_message => 'begin, p_rpt_mode:' || p_rpt_mode || ',p_ou_id:' || p_ou_id
388: );
389: -- **** for debug information in readonly UT environment.--- end ****

Line 405: p_output_to => 'FND_LOG.STRING'

401: -- for each record in the onhand information (inv_org, item), get the confirmation data
402: -- **** for debug information in readonly UT environment.--- begin ****
403: JMF_SHIKYU_RPT_UTIL.debug_output
404: (
405: p_output_to => 'FND_LOG.STRING'
406: ,p_api_name => G_MODULE_PREFIX || l_api_name
407: ,p_message => 'begin, p_rpt_mode:' || p_rpt_mode || ',p_ou_id:' || p_ou_id
408: );
409: -- **** for debug information in readonly UT environment.--- end ****

Line 428: p_output_to => 'FND_LOG.STRING'

424: -- add the find data to temporary table for report, with the UOM Currency conversion
425: -- **** for debug information in readonly UT environment.--- begin ****
426: JMF_SHIKYU_RPT_UTIL.debug_output
427: (
428: p_output_to => 'FND_LOG.STRING'
429: ,p_api_name => G_MODULE_PREFIX || l_api_name
430: ,p_message => 'begin, p_rpt_mode:' || p_rpt_mode || ',p_ou_id:' || p_ou_id
431: );
432: -- **** for debug information in readonly UT environment.--- end ****

Line 452: p_output_to => 'FND_LOG.STRING'

448:
449: -- **** for debug information in readonly UT environment.--- begin ****
450: JMF_SHIKYU_RPT_UTIL.debug_output
451: (
452: p_output_to => 'FND_LOG.STRING'
453: ,p_api_name => G_MODULE_PREFIX || l_api_name
454: ,p_message => 'end, p_rpt_mode:' || p_rpt_mode || ',p_ou_id:' || p_ou_id
455: );
456: -- **** for debug information in readonly UT environment.--- end ****

Line 463: ,p_output_to => 'FND_LOG.STRING'

459:
460: --print the data in mid temp table for debug.
461: rpt_debug_show_mid_data(
462: p_row_type => NULL
463: ,p_output_to => 'FND_LOG.STRING'
464: );
465: rpt_debug_show_temp_data
466: (
467: p_rpt_data_type => NULL

Line 468: ,p_output_to => 'FND_LOG.STRING'

464: );
465: rpt_debug_show_temp_data
466: (
467: p_rpt_data_type => NULL
468: ,p_output_to => 'FND_LOG.STRING'
469: );
470:
471: EXCEPTION
472: WHEN NO_DATA_FOUND THEN

Line 478: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

474: FND_MESSAGE.set_name('JMF', 'JMF_SHK_RPT_NO_DATA');
475: fnd_msg_pub.Add;
476:
477: IF g_fnd_debug = 'Y' AND
478: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
479: THEN
480: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION
481: , G_MODULE_PREFIX || l_api_name || '.no_data'
482: , 'JMF_SHK_RPT_NO_DATA');

Line 480: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION

476:
477: IF g_fnd_debug = 'Y' AND
478: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
479: THEN
480: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION
481: , G_MODULE_PREFIX || l_api_name || '.no_data'
482: , 'JMF_SHK_RPT_NO_DATA');
483: END IF;
484:

Line 487: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

483: END IF;
484:
485: WHEN OTHERS THEN
486: IF g_fnd_debug = 'Y' AND
487: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
488: THEN
489: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
490: , G_MODULE_PREFIX || l_api_name || '.exception'
491: , 'EXCEPTION:WHEN OTHERS THEN');

Line 489: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

485: WHEN OTHERS THEN
486: IF g_fnd_debug = 'Y' AND
487: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
488: THEN
489: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
490: , G_MODULE_PREFIX || l_api_name || '.exception'
491: , 'EXCEPTION:WHEN OTHERS THEN');
492: END IF;
493:

Line 612: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

608:
609: BEGIN
610:
611: IF g_fnd_debug = 'Y' AND
612: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
613: THEN
614: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
615: , g_module_prefix || l_api_name || '.begin'
616: , NULL);

Line 614: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

610:
611: IF g_fnd_debug = 'Y' AND
612: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
613: THEN
614: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
615: , g_module_prefix || l_api_name || '.begin'
616: , NULL);
617: END IF;
618: -- **** for debug information in readonly UT environment.--- begin ****

Line 621: p_output_to => 'FND_LOG.STRING'

617: END IF;
618: -- **** for debug information in readonly UT environment.--- begin ****
619: JMF_SHIKYU_RPT_UTIL.debug_output
620: (
621: p_output_to => 'FND_LOG.STRING'
622: ,p_api_name => G_MODULE_PREFIX || l_api_name
623: ,p_message => 'begin:' ||
624: ',p_onhand_row_type:' || p_onhand_row_type ||
625: ',p_ou_id :' || p_ou_id ||

Line 653: p_output_to => 'FND_LOG.STRING'

649: EXIT WHEN l_cur_get_oem_inv_org_info%NOTFOUND; -- no more oem organiztions
650: -- **** for debug information in readonly UT environment.--- begin ****
651: JMF_SHIKYU_RPT_UTIL.debug_output
652: (
653: p_output_to => 'FND_LOG.STRING'
654: ,p_api_name => G_MODULE_PREFIX || l_api_name
655: ,p_message => ',l_oem_inv_org_id:' || l_oem_inv_org_id ||
656: ',l_oem_inv_org_code :' || l_oem_inv_org_code ||
657: ',l_oem_inv_org_name:' || l_oem_inv_org_name

Line 677: p_output_to => 'FND_LOG.STRING'

673: EXIT WHEN l_cur_get_tp_inv_org_info%NOTFOUND; -- no more tp organiztions
674: -- **** for debug information in readonly UT environment.--- begin ****
675: JMF_SHIKYU_RPT_UTIL.debug_output
676: (
677: p_output_to => 'FND_LOG.STRING'
678: ,p_api_name => G_MODULE_PREFIX || l_api_name
679: ,p_message => ',l_tp_inv_org_id:' || l_tp_inv_org_id ||
680: ',l_tp_inv_org_code :' || l_tp_inv_org_code ||
681: ',l_supplier_id:' || l_supplier_id ||

Line 738: ,p_output_to => 'FND_LOG.STRING'

734: COMMIT; -- for debug on UT ?????
735: --print the data in mid temp table for debug.
736: rpt_debug_show_mid_data(
737: p_row_type => p_onhand_row_type
738: ,p_output_to => 'FND_LOG.STRING'
739: );
740: EXCEPTION
741: WHEN NO_DATA_FOUND THEN
742: --Set message name;

Line 748: p_output_to => 'FND_LOG.STRING'

744: fnd_msg_pub.Add;
745: -- **** for debug information in readonly UT environment.--- begin ****
746: JMF_SHIKYU_RPT_UTIL.debug_output
747: (
748: p_output_to => 'FND_LOG.STRING'
749: ,p_api_name => G_MODULE_PREFIX || l_api_name
750: ,p_message => 'NO_DATA_FOUND'
751: );
752: -- **** for debug information in readonly UT environment.--- end ****

Line 758: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

754: WHEN OTHERS THEN
755: -- raise log message;
756:
757: IF g_fnd_debug = 'Y' AND
758: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
759: THEN
760: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
761: , G_MODULE_PREFIX || l_api_name || '.exception'
762: , NULL);

Line 760: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

756:
757: IF g_fnd_debug = 'Y' AND
758: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
759: THEN
760: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
761: , G_MODULE_PREFIX || l_api_name || '.exception'
762: , NULL);
763: END IF;
764: -- **** for debug information in readonly UT environment.--- begin ****

Line 767: p_output_to => 'FND_LOG.STRING'

763: END IF;
764: -- **** for debug information in readonly UT environment.--- begin ****
765: JMF_SHIKYU_RPT_UTIL.debug_output
766: (
767: p_output_to => 'FND_LOG.STRING'
768: ,p_api_name => G_MODULE_PREFIX || l_api_name
769: ,p_message => 'OTHERS'
770: );
771: -- **** for debug information in readonly UT environment.--- end ****

Line 830: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

826: WHERE row_type = p_onhand_row_type;
827:
828: BEGIN
829: IF g_fnd_debug = 'Y' AND
830: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
831: THEN
832: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
833: , g_module_prefix || l_api_name || '.begin'
834: , NULL);

Line 832: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

828: BEGIN
829: IF g_fnd_debug = 'Y' AND
830: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
831: THEN
832: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
833: , g_module_prefix || l_api_name || '.begin'
834: , NULL);
835: END IF;
836: -- **** for debug information in readonly UT environment.--- begin ****

Line 839: p_output_to => 'FND_LOG.STRING'

835: END IF;
836: -- **** for debug information in readonly UT environment.--- begin ****
837: JMF_SHIKYU_RPT_UTIL.debug_output
838: (
839: p_output_to => 'FND_LOG.STRING'
840: ,p_api_name => G_MODULE_PREFIX || l_api_name
841: ,p_message => 'begin:' ||
842: ',p_onhand_row_type:' || p_onhand_row_type ||
843: ',p_rep_po_unalloc_row_type :' || p_rep_po_unalloc_row_type ||

Line 866: p_output_to => 'FND_LOG.STRING'

862: EXIT WHEN l_cur_get_onhand_components%NOTFOUND;
863: -- **** for debug information in readonly UT environment.--- begin ****
864: JMF_SHIKYU_RPT_UTIL.debug_output
865: (
866: p_output_to => 'FND_LOG.STRING'
867: ,p_api_name => G_MODULE_PREFIX || l_api_name
868: ,p_message => ',l_supplier_id:' || l_supplier_id ||
869: ',l_supplier_site_id :' || l_supplier_site_id ||
870: ',l_oem_inv_org_id:' || l_oem_inv_org_id ||

Line 927: p_output_to => 'FND_LOG.STRING'

923: -- the found onhand quantity has no matched rcv_transactions
924: -- **** for debug information in readonly UT environment.--- begin ****
925: JMF_SHIKYU_RPT_UTIL.debug_output
926: (
927: p_output_to => 'FND_LOG.STRING'
928: ,p_api_name => G_MODULE_PREFIX || l_api_name
929: ,p_message => '** onhand quantity :' || l_onhand_quantity ||', has no matched rcv_transactions'
930: );
931: -- **** for debug information in readonly UT environment.--- end ****

Line 939: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

935: CLOSE l_cur_get_onhand_components;
936:
937: COMMIT; -- for debug on UT ?????
938: IF g_fnd_debug = 'Y' AND
939: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
940: THEN
941: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
942: , g_module_prefix || l_api_name || '.end'
943: , NULL);

Line 941: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

937: COMMIT; -- for debug on UT ?????
938: IF g_fnd_debug = 'Y' AND
939: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
940: THEN
941: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
942: , g_module_prefix || l_api_name || '.end'
943: , NULL);
944: END IF;
945: EXCEPTION

Line 954: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

950:
951: WHEN OTHERS THEN
952:
953: IF g_fnd_debug = 'Y' AND
954: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
955: THEN
956: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
957: , G_MODULE_PREFIX || l_api_name || '.execption'
958: , NULL);

Line 956: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

952:
953: IF g_fnd_debug = 'Y' AND
954: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
955: THEN
956: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
957: , G_MODULE_PREFIX || l_api_name || '.execption'
958: , NULL);
959: END IF;
960: -- **** for debug information in readonly UT environment.--- begin ****

Line 963: p_output_to => 'FND_LOG.STRING'

959: END IF;
960: -- **** for debug information in readonly UT environment.--- begin ****
961: JMF_SHIKYU_RPT_UTIL.debug_output
962: (
963: p_output_to => 'FND_LOG.STRING'
964: ,p_api_name => G_MODULE_PREFIX || l_api_name
965: ,p_message => 'WHEN OTHERS THEN'
966: );
967: -- **** for debug information in readonly UT environment.--- end ****

Line 1051: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1047: l_rcv_unallocated_pri rcv_transactions.primary_quantity%TYPE;
1048:
1049: BEGIN
1050: IF g_fnd_debug = 'Y' AND
1051: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1052: THEN
1053: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1054: , g_module_prefix || l_api_name || '.begin'
1055: , NULL);

Line 1053: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1049: BEGIN
1050: IF g_fnd_debug = 'Y' AND
1051: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1052: THEN
1053: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1054: , g_module_prefix || l_api_name || '.begin'
1055: , NULL);
1056: END IF;
1057: -- **** for debug information in readonly UT environment.--- begin ****

Line 1060: p_output_to => 'FND_LOG.STRING'

1056: END IF;
1057: -- **** for debug information in readonly UT environment.--- begin ****
1058: JMF_SHIKYU_RPT_UTIL.debug_output
1059: (
1060: p_output_to => 'FND_LOG.STRING'
1061: ,p_api_name => G_MODULE_PREFIX || l_api_name
1062: ,p_message => 'begin:' ||
1063: ',p_rep_po_unalloc_row_type :' || p_rep_po_unalloc_row_type ||
1064: ',p_rcv_transaction_row_type :' || p_rcv_transaction_row_type ||

Line 1106: p_output_to => 'FND_LOG.STRING'

1102: EXIT WHEN l_cur_get_rcv_transaction_info%NOTFOUND;
1103: -- **** for debug information in readonly UT environment.--- begin ****
1104: JMF_SHIKYU_RPT_UTIL.debug_output
1105: (
1106: p_output_to => 'FND_LOG.STRING'
1107: ,p_api_name => G_MODULE_PREFIX || l_api_name
1108: ,p_message => 'begin:' ||
1109: ',x_need_to_find_pri_qty :' || x_need_to_find_pri_qty ||
1110: ',l_rcv_transaction_id :' || l_rcv_transaction_id ||

Line 1185: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1181:
1182: --step4:update the get_rcv_flags for the rep_po lines, move to above, need the sucess status
1183: COMMIT; -- for debug on UT ?????
1184: IF g_fnd_debug = 'Y' AND
1185: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1186: THEN
1187: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1188: , g_module_prefix || l_api_name || '.end'
1189: , NULL);

Line 1187: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1183: COMMIT; -- for debug on UT ?????
1184: IF g_fnd_debug = 'Y' AND
1185: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1186: THEN
1187: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1188: , g_module_prefix || l_api_name || '.end'
1189: , NULL);
1190: END IF;
1191: EXCEPTION

Line 1197: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1193: FND_MESSAGE.set_name('JMF', 'JMF_SHK_RPT_NO_DATA');
1194: fnd_msg_pub.Add;
1195: WHEN OTHERS THEN
1196: IF g_fnd_debug = 'Y' AND
1197: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1198: THEN
1199: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1200: , G_MODULE_PREFIX || l_api_name || '.exception'
1201: , NULL);

Line 1199: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1195: WHEN OTHERS THEN
1196: IF g_fnd_debug = 'Y' AND
1197: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1198: THEN
1199: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1200: , G_MODULE_PREFIX || l_api_name || '.exception'
1201: , NULL);
1202: END IF;
1203: -- **** for debug information in readonly UT environment.--- begin ****

Line 1206: p_output_to => 'FND_LOG.STRING'

1202: END IF;
1203: -- **** for debug information in readonly UT environment.--- begin ****
1204: JMF_SHIKYU_RPT_UTIL.debug_output
1205: (
1206: p_output_to => 'FND_LOG.STRING'
1207: ,p_api_name => G_MODULE_PREFIX || l_api_name
1208: ,p_message => 'WHEN OTHERS THEN'
1209: );
1210: -- **** for debug information in readonly UT environment.--- end ****

Line 1245: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1241: l_api_name CONSTANT VARCHAR2(30) := 'get_unallocated_rep_po';
1242:
1243: BEGIN
1244: IF g_fnd_debug = 'Y' AND
1245: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1246: THEN
1247: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1248: , g_module_prefix || l_api_name || '.begin'
1249: , NULL);

Line 1247: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1243: BEGIN
1244: IF g_fnd_debug = 'Y' AND
1245: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1246: THEN
1247: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1248: , g_module_prefix || l_api_name || '.begin'
1249: , NULL);
1250: END IF;
1251: -- **** for debug information in readonly UT environment.--- begin ****

Line 1254: p_output_to => 'FND_LOG.STRING'

1250: END IF;
1251: -- **** for debug information in readonly UT environment.--- begin ****
1252: JMF_SHIKYU_RPT_UTIL.debug_output
1253: (
1254: p_output_to => 'FND_LOG.STRING'
1255: ,p_api_name => G_MODULE_PREFIX || l_api_name
1256: ,p_message => 'begin:' ||
1257: ',p_rep_po_unalloc_row_type:' || p_rep_po_unalloc_row_type ||
1258: ',p_ou_id :' || p_ou_id ||

Line 1411: ,p_output_to => 'FND_LOG.STRING'

1407:
1408: --print the data in mid temp table for debug.
1409: rpt_debug_show_mid_data(
1410: p_row_type => p_rep_po_unalloc_row_type
1411: ,p_output_to => 'FND_LOG.STRING'
1412: );
1413: IF g_fnd_debug = 'Y' AND
1414: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1415: THEN

Line 1414: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1410: p_row_type => p_rep_po_unalloc_row_type
1411: ,p_output_to => 'FND_LOG.STRING'
1412: );
1413: IF g_fnd_debug = 'Y' AND
1414: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1415: THEN
1416: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1417: , g_module_prefix || l_api_name || '.end'
1418: , NULL);

Line 1416: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1412: );
1413: IF g_fnd_debug = 'Y' AND
1414: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1415: THEN
1416: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1417: , g_module_prefix || l_api_name || '.end'
1418: , NULL);
1419: END IF;
1420: EXCEPTION

Line 1429: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1425:
1426: WHEN OTHERS THEN
1427:
1428: IF g_fnd_debug = 'Y' AND
1429: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1430: THEN
1431: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1432: , G_MODULE_PREFIX || l_api_name || '.execption'
1433: , NULL);

Line 1431: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1427:
1428: IF g_fnd_debug = 'Y' AND
1429: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1430: THEN
1431: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1432: , G_MODULE_PREFIX || l_api_name || '.execption'
1433: , NULL);
1434: END IF;
1435: -- **** for debug information in readonly UT environment.--- begin ****

Line 1438: p_output_to => 'FND_LOG.STRING'

1434: END IF;
1435: -- **** for debug information in readonly UT environment.--- begin ****
1436: JMF_SHIKYU_RPT_UTIL.debug_output
1437: (
1438: p_output_to => 'FND_LOG.STRING'
1439: ,p_api_name => G_MODULE_PREFIX || l_api_name
1440: ,p_message => 'WHEN OTHERS THEN'
1441: );
1442: -- **** for debug information in readonly UT environment.--- end ****

Line 1480: p_output_to => 'FND_LOG.STRING'

1476: BEGIN
1477: -- **** for debug information in readonly UT environment.--- begin ****
1478: JMF_SHIKYU_RPT_UTIL.debug_output
1479: (
1480: p_output_to => 'FND_LOG.STRING'
1481: ,p_api_name => G_MODULE_PREFIX || l_api_name
1482: ,p_message => 'begin:' ||
1483: ',p_rep_po_unalloc_row_type:' || p_rep_po_unalloc_row_type ||
1484: ',p_ou_id :' || p_ou_id ||

Line 1497: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1493: );
1494: -- **** for debug information in readonly UT environment.--- end ****
1495:
1496: IF g_fnd_debug = 'Y' AND
1497: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1498: THEN
1499: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1500: , g_module_prefix || l_api_name || '.begin'
1501: , NULL);

Line 1499: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1495:
1496: IF g_fnd_debug = 'Y' AND
1497: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1498: THEN
1499: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1500: , g_module_prefix || l_api_name || '.begin'
1501: , NULL);
1502: END IF;
1503:

Line 1526: ,p_output_to => 'FND_LOG.STRING'

1522: COMMIT; -- for debug on UT ?????
1523: --print the data in mid temp table for debug.
1524: rpt_debug_show_mid_data(
1525: p_row_type => p_rep_po_unalloc_row_type
1526: ,p_output_to => 'FND_LOG.STRING'
1527: );
1528:
1529: IF g_fnd_debug = 'Y' AND
1530: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

Line 1530: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1526: ,p_output_to => 'FND_LOG.STRING'
1527: );
1528:
1529: IF g_fnd_debug = 'Y' AND
1530: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1531: THEN
1532: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1533: , g_module_prefix || l_api_name || '.end'
1534: , NULL);

Line 1532: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1528:
1529: IF g_fnd_debug = 'Y' AND
1530: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1531: THEN
1532: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1533: , g_module_prefix || l_api_name || '.end'
1534: , NULL);
1535: END IF;
1536: RETURN l_rep_po_unallocated_pri;

Line 1548: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1544: RETURN l_rep_po_unallocated_pri;
1545:
1546: WHEN OTHERS THEN
1547: IF g_fnd_debug = 'Y' AND
1548: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1549: THEN
1550: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1551: , G_MODULE_PREFIX || l_api_name || '.execption'
1552: , NULL);

Line 1550: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1546: WHEN OTHERS THEN
1547: IF g_fnd_debug = 'Y' AND
1548: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1549: THEN
1550: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1551: , G_MODULE_PREFIX || l_api_name || '.execption'
1552: , NULL);
1553: END IF;
1554: -- **** for debug information in readonly UT environment.--- begin ****

Line 1557: p_output_to => 'FND_LOG.STRING'

1553: END IF;
1554: -- **** for debug information in readonly UT environment.--- begin ****
1555: JMF_SHIKYU_RPT_UTIL.debug_output
1556: (
1557: p_output_to => 'FND_LOG.STRING'
1558: ,p_api_name => G_MODULE_PREFIX || l_api_name
1559: ,p_message => 'Exception: ' || SQLERRM
1560: );
1561: -- **** for debug information in readonly UT environment.--- end ****

Line 1603: p_output_to => 'FND_LOG.STRING'

1599: BEGIN
1600: -- **** for debug information in readonly UT environment.--- begin ****
1601: JMF_SHIKYU_RPT_UTIL.debug_output
1602: (
1603: p_output_to => 'FND_LOG.STRING'
1604: ,p_api_name => G_MODULE_PREFIX || l_api_name
1605: ,p_message => 'begin:' ||
1606: ',p_rep_po_unalloc_row_type:' || p_rep_po_unalloc_row_type ||
1607: ',p_rcv_transaction_row_type:' || p_rcv_transaction_row_type ||

Line 1622: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1618: );
1619: -- **** for debug information in readonly UT environment.--- end ****
1620:
1621: IF g_fnd_debug = 'Y' AND
1622: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1623: THEN
1624: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1625: , g_module_prefix || l_api_name || '.begin'
1626: , NULL);

Line 1624: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1620:
1621: IF g_fnd_debug = 'Y' AND
1622: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1623: THEN
1624: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1625: , g_module_prefix || l_api_name || '.begin'
1626: , NULL);
1627: END IF;
1628:

Line 1663: ,p_output_to => 'FND_LOG.STRING'

1659: COMMIT; -- for debug on UT ?????
1660: --print the data in mid temp table for debug.
1661: rpt_debug_show_mid_data(
1662: p_row_type => p_rep_po_unalloc_row_type
1663: ,p_output_to => 'FND_LOG.STRING'
1664: );
1665: IF g_fnd_debug = 'Y' AND
1666: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1667: THEN

Line 1666: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1662: p_row_type => p_rep_po_unalloc_row_type
1663: ,p_output_to => 'FND_LOG.STRING'
1664: );
1665: IF g_fnd_debug = 'Y' AND
1666: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1667: THEN
1668: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1669: , g_module_prefix || l_api_name || '.end'
1670: , NULL);

Line 1668: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1664: );
1665: IF g_fnd_debug = 'Y' AND
1666: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1667: THEN
1668: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1669: , g_module_prefix || l_api_name || '.end'
1670: , NULL);
1671: END IF;
1672: EXCEPTION

Line 1680: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1676: fnd_msg_pub.Add;
1677:
1678: WHEN OTHERS THEN
1679: IF g_fnd_debug = 'Y' AND
1680: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1681: THEN
1682: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1683: , G_MODULE_PREFIX || l_api_name || '.execption'
1684: , NULL);

Line 1682: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1678: WHEN OTHERS THEN
1679: IF g_fnd_debug = 'Y' AND
1680: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1681: THEN
1682: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1683: , G_MODULE_PREFIX || l_api_name || '.execption'
1684: , NULL);
1685: END IF;
1686: -- **** for debug information in readonly UT environment.--- begin ****

Line 1689: p_output_to => 'FND_LOG.STRING'

1685: END IF;
1686: -- **** for debug information in readonly UT environment.--- begin ****
1687: JMF_SHIKYU_RPT_UTIL.debug_output
1688: (
1689: p_output_to => 'FND_LOG.STRING'
1690: ,p_api_name => G_MODULE_PREFIX || l_api_name
1691: ,p_message => 'WHEN OTHERS THEN'
1692: );
1693: -- **** for debug information in readonly UT environment.--- end ****

Line 1732: p_output_to => 'FND_LOG.STRING'

1728: BEGIN
1729: -- **** for debug information in readonly UT environment.--- begin ****
1730: JMF_SHIKYU_RPT_UTIL.debug_output
1731: (
1732: p_output_to => 'FND_LOG.STRING'
1733: ,p_api_name => G_MODULE_PREFIX || l_api_name
1734: ,p_message => 'begin:' ||
1735: ',p_rcv_row_type:' || p_rcv_row_type ||
1736: ',p_ou_id :' || p_ou_id ||

Line 1750: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1746: );
1747: -- **** for debug information in readonly UT environment.--- end ****
1748:
1749: IF g_fnd_debug = 'Y' AND
1750: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1751: THEN
1752: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1753: , g_module_prefix || l_api_name || '.begin'
1754: , NULL);

Line 1752: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1748:
1749: IF g_fnd_debug = 'Y' AND
1750: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1751: THEN
1752: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1753: , g_module_prefix || l_api_name || '.begin'
1754: , NULL);
1755: END IF;
1756:

Line 1802: ,p_output_to => 'FND_LOG.STRING'

1798: COMMIT; -- for debug on UT ?????
1799: --print the data in mid temp table for debug.
1800: rpt_debug_show_mid_data(
1801: p_row_type => p_rcv_row_type
1802: ,p_output_to => 'FND_LOG.STRING'
1803: );
1804: IF g_fnd_debug = 'Y' AND
1805: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1806: THEN

Line 1805: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1801: p_row_type => p_rcv_row_type
1802: ,p_output_to => 'FND_LOG.STRING'
1803: );
1804: IF g_fnd_debug = 'Y' AND
1805: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1806: THEN
1807: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1808: , g_module_prefix || l_api_name || '.end'
1809: , NULL);

Line 1807: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1803: );
1804: IF g_fnd_debug = 'Y' AND
1805: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1806: THEN
1807: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1808: , g_module_prefix || l_api_name || '.end'
1809: , NULL);
1810: END IF;
1811: EXCEPTION

Line 1819: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1815: fnd_msg_pub.Add;
1816:
1817: WHEN OTHERS THEN
1818: IF g_fnd_debug = 'Y' AND
1819: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1820: THEN
1821: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1822: , G_MODULE_PREFIX || l_api_name || '.execption'
1823: , NULL);

Line 1821: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1817: WHEN OTHERS THEN
1818: IF g_fnd_debug = 'Y' AND
1819: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1820: THEN
1821: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1822: , G_MODULE_PREFIX || l_api_name || '.execption'
1823: , NULL);
1824: END IF;
1825: -- **** for debug information in readonly UT environment.--- begin ****

Line 1828: p_output_to => 'FND_LOG.STRING'

1824: END IF;
1825: -- **** for debug information in readonly UT environment.--- begin ****
1826: JMF_SHIKYU_RPT_UTIL.debug_output
1827: (
1828: p_output_to => 'FND_LOG.STRING'
1829: ,p_api_name => G_MODULE_PREFIX || l_api_name
1830: ,p_message => 'WHEN OTHERS THEN'
1831: );
1832: -- **** for debug information in readonly UT environment.--- end ****

Line 1914: p_output_to => 'FND_LOG.STRING'

1910: BEGIN
1911: -- **** for debug information in readonly UT environment.--- begin ****
1912: JMF_SHIKYU_RPT_UTIL.debug_output
1913: (
1914: p_output_to => 'FND_LOG.STRING'
1915: ,p_api_name => G_MODULE_PREFIX || l_api_name
1916: ,p_message => 'begin:' ||
1917: ',p_sub_po_unconsumed_row_type:' || p_sub_po_unconsumed_row_type ||
1918: ',p_rep_po_unconsumed_row_type:' || p_rep_po_unconsumed_row_type ||

Line 1933: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1929: );
1930: -- **** for debug information in readonly UT environment.--- end ****
1931:
1932: IF g_fnd_debug = 'Y' AND
1933: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1934: THEN
1935: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1936: , g_module_prefix || l_api_name || '.begin'
1937: , NULL);

Line 1935: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

1931:
1932: IF g_fnd_debug = 'Y' AND
1933: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1934: THEN
1935: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
1936: , g_module_prefix || l_api_name || '.begin'
1937: , NULL);
1938: END IF;
1939:

Line 1966: p_output_to => 'FND_LOG.STRING'

1962: EXIT WHEN l_cur_get_rcv_transaction_info%NOTFOUND;
1963: -- **** for debug information in readonly UT environment.--- begin ****
1964: JMF_SHIKYU_RPT_UTIL.debug_output
1965: (
1966: p_output_to => 'FND_LOG.STRING'
1967: ,p_api_name => G_MODULE_PREFIX || l_api_name
1968: ,p_message => 'begin:' ||
1969: ',x_need_to_find_pri_qty:' || x_need_to_find_pri_qty ||
1970: ',l_rcv_transaction_id:' || l_rcv_transaction_id ||

Line 2032: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2028:
2029: --step4:update the get_rcv_flags for the rep_po lines
2030: COMMIT; -- for debug on UT ?????
2031: IF g_fnd_debug = 'Y' AND
2032: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2033: THEN
2034: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2035: , g_module_prefix || l_api_name || '.end'
2036: , NULL);

Line 2034: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2030: COMMIT; -- for debug on UT ?????
2031: IF g_fnd_debug = 'Y' AND
2032: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2033: THEN
2034: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2035: , g_module_prefix || l_api_name || '.end'
2036: , NULL);
2037: END IF;
2038: EXCEPTION

Line 2046: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2042: fnd_msg_pub.Add;
2043:
2044: WHEN OTHERS THEN
2045: IF g_fnd_debug = 'Y' AND
2046: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2047: THEN
2048: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2049: , G_MODULE_PREFIX || l_api_name || '.execption'
2050: , NULL);

Line 2048: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2044: WHEN OTHERS THEN
2045: IF g_fnd_debug = 'Y' AND
2046: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2047: THEN
2048: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2049: , G_MODULE_PREFIX || l_api_name || '.execption'
2050: , NULL);
2051: END IF;
2052: -- **** for debug information in readonly UT environment.--- begin ****

Line 2055: p_output_to => 'FND_LOG.STRING'

2051: END IF;
2052: -- **** for debug information in readonly UT environment.--- begin ****
2053: JMF_SHIKYU_RPT_UTIL.debug_output
2054: (
2055: p_output_to => 'FND_LOG.STRING'
2056: ,p_api_name => G_MODULE_PREFIX || l_api_name
2057: ,p_message => 'WHEN OTHERS THEN'
2058: );
2059: -- **** for debug information in readonly UT environment.--- end ****

Line 2095: p_output_to => 'FND_LOG.STRING'

2091: BEGIN
2092: -- **** for debug information in readonly UT environment.--- begin ****
2093: JMF_SHIKYU_RPT_UTIL.debug_output
2094: (
2095: p_output_to => 'FND_LOG.STRING'
2096: ,p_api_name => G_MODULE_PREFIX || l_api_name
2097: ,p_message => 'begin:' ||
2098: ',p_sub_po_unconsumed_row_type:' || p_sub_po_unconsumed_row_type ||
2099: ',p_ou_id :' || p_ou_id ||

Line 2111: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2107: );
2108: -- **** for debug information in readonly UT environment.--- end ****
2109:
2110: IF g_fnd_debug = 'Y' AND
2111: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2112: THEN
2113: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2114: , g_module_prefix || l_api_name || '.begin'
2115: , NULL);

Line 2113: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2109:
2110: IF g_fnd_debug = 'Y' AND
2111: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2112: THEN
2113: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2114: , g_module_prefix || l_api_name || '.begin'
2115: , NULL);
2116: END IF;
2117:

Line 2212: ,p_output_to => 'FND_LOG.STRING'

2208: COMMIT; -- for debug on UT ?????
2209: --print the data in mid temp table for debug.
2210: rpt_debug_show_mid_data(
2211: p_row_type => p_sub_po_unconsumed_row_type
2212: ,p_output_to => 'FND_LOG.STRING'
2213: );
2214: IF g_fnd_debug = 'Y' AND
2215: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2216: THEN

Line 2215: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2211: p_row_type => p_sub_po_unconsumed_row_type
2212: ,p_output_to => 'FND_LOG.STRING'
2213: );
2214: IF g_fnd_debug = 'Y' AND
2215: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2216: THEN
2217: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2218: , g_module_prefix || l_api_name || '.end'
2219: , NULL);

Line 2217: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2213: );
2214: IF g_fnd_debug = 'Y' AND
2215: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2216: THEN
2217: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2218: , g_module_prefix || l_api_name || '.end'
2219: , NULL);
2220: END IF;
2221: EXCEPTION

Line 2229: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2225: fnd_msg_pub.Add;
2226:
2227: WHEN OTHERS THEN
2228: IF g_fnd_debug = 'Y' AND
2229: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2230: THEN
2231: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2232: , G_MODULE_PREFIX || l_api_name || '.execption'
2233: , NULL);

Line 2231: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2227: WHEN OTHERS THEN
2228: IF g_fnd_debug = 'Y' AND
2229: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2230: THEN
2231: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2232: , G_MODULE_PREFIX || l_api_name || '.execption'
2233: , NULL);
2234: END IF;
2235: -- **** for debug information in readonly UT environment.--- begin ****

Line 2238: p_output_to => 'FND_LOG.STRING'

2234: END IF;
2235: -- **** for debug information in readonly UT environment.--- begin ****
2236: JMF_SHIKYU_RPT_UTIL.debug_output
2237: (
2238: p_output_to => 'FND_LOG.STRING'
2239: ,p_api_name => G_MODULE_PREFIX || l_api_name
2240: ,p_message => 'WHEN OTHERS THEN'
2241: );
2242: -- **** for debug information in readonly UT environment.--- end ****

Line 2280: p_output_to => 'FND_LOG.STRING'

2276: BEGIN
2277: -- **** for debug information in readonly UT environment.--- begin ****
2278: JMF_SHIKYU_RPT_UTIL.debug_output
2279: (
2280: p_output_to => 'FND_LOG.STRING'
2281: ,p_api_name => G_MODULE_PREFIX || l_api_name
2282: ,p_message => 'begin:' ||
2283: ',p_sub_po_unconsumed_row_type:' || p_sub_po_unconsumed_row_type ||
2284: ',p_rep_po_unconsumed_row_type:' || p_rep_po_unconsumed_row_type ||

Line 2297: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2293: );
2294: -- **** for debug information in readonly UT environment.--- end ****
2295:
2296: IF g_fnd_debug = 'Y' AND
2297: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2298: THEN
2299: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2300: , g_module_prefix || l_api_name || '.begin'
2301: , NULL);

Line 2299: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2295:
2296: IF g_fnd_debug = 'Y' AND
2297: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2298: THEN
2299: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2300: , g_module_prefix || l_api_name || '.begin'
2301: , NULL);
2302: END IF;
2303:

Line 2397: ,p_output_to => 'FND_LOG.STRING'

2393: COMMIT; -- for debug on UT ?????
2394: --print the data in mid temp table for debug.
2395: rpt_debug_show_mid_data(
2396: p_row_type => p_rep_po_unconsumed_row_type
2397: ,p_output_to => 'FND_LOG.STRING'
2398: );
2399: IF g_fnd_debug = 'Y' AND
2400: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2401: THEN

Line 2400: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2396: p_row_type => p_rep_po_unconsumed_row_type
2397: ,p_output_to => 'FND_LOG.STRING'
2398: );
2399: IF g_fnd_debug = 'Y' AND
2400: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2401: THEN
2402: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2403: , g_module_prefix || l_api_name || '.end'
2404: , NULL);

Line 2402: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2398: );
2399: IF g_fnd_debug = 'Y' AND
2400: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2401: THEN
2402: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2403: , g_module_prefix || l_api_name || '.end'
2404: , NULL);
2405: END IF;
2406: EXCEPTION

Line 2414: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2410: fnd_msg_pub.Add;
2411:
2412: WHEN OTHERS THEN
2413: IF g_fnd_debug = 'Y' AND
2414: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2415: THEN
2416: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2417: , G_MODULE_PREFIX || l_api_name || '.execption'
2418: , NULL);

Line 2416: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2412: WHEN OTHERS THEN
2413: IF g_fnd_debug = 'Y' AND
2414: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2415: THEN
2416: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2417: , G_MODULE_PREFIX || l_api_name || '.execption'
2418: , NULL);
2419: END IF;
2420: -- **** for debug information in readonly UT environment.--- begin ****

Line 2423: p_output_to => 'FND_LOG.STRING'

2419: END IF;
2420: -- **** for debug information in readonly UT environment.--- begin ****
2421: JMF_SHIKYU_RPT_UTIL.debug_output
2422: (
2423: p_output_to => 'FND_LOG.STRING'
2424: ,p_api_name => G_MODULE_PREFIX || l_api_name
2425: ,p_message => 'WHEN OTHERS THEN'
2426: );
2427: -- **** for debug information in readonly UT environment.--- end ****

Line 2465: p_output_to => 'FND_LOG.STRING'

2461: BEGIN
2462: -- **** for debug information in readonly UT environment.--- begin ****
2463: JMF_SHIKYU_RPT_UTIL.debug_output
2464: (
2465: p_output_to => 'FND_LOG.STRING'
2466: ,p_api_name => G_MODULE_PREFIX || l_api_name
2467: ,p_message => 'begin:' ||
2468: ',p_sub_po_unconsumed_row_type:' || p_sub_po_unconsumed_row_type ||
2469: ',p_rcv_transaction_id:' || p_rcv_transaction_id ||

Line 2482: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2478: );
2479: -- **** for debug information in readonly UT environment.--- end ****
2480:
2481: IF g_fnd_debug = 'Y' AND
2482: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2483: THEN
2484: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2485: , g_module_prefix || l_api_name || '.begin'
2486: , NULL);

Line 2484: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2480:
2481: IF g_fnd_debug = 'Y' AND
2482: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2483: THEN
2484: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2485: , g_module_prefix || l_api_name || '.begin'
2486: , NULL);
2487: END IF;
2488:

Line 2511: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2507: AND cfr_mid.item_id = alloc.shikyu_component_id
2508: AND alloc.replenishment_so_line_id = jsr.replenishment_so_line_id
2509: AND jsr.replenishment_po_shipment_id = rcv.po_line_location_id;
2510: IF g_fnd_debug = 'Y' AND
2511: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2512: THEN
2513: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2514: , g_module_prefix || l_api_name || '.end'
2515: , NULL);

Line 2513: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2509: AND jsr.replenishment_po_shipment_id = rcv.po_line_location_id;
2510: IF g_fnd_debug = 'Y' AND
2511: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2512: THEN
2513: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2514: , g_module_prefix || l_api_name || '.end'
2515: , NULL);
2516: END IF;
2517: RETURN l_sub_po_residual_pri;

Line 2527: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2523: RETURN 0;
2524:
2525: WHEN OTHERS THEN
2526: IF g_fnd_debug = 'Y' AND
2527: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2528: THEN
2529: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2530: , G_MODULE_PREFIX || l_api_name || '.execption'
2531: , NULL);

Line 2529: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2525: WHEN OTHERS THEN
2526: IF g_fnd_debug = 'Y' AND
2527: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2528: THEN
2529: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2530: , G_MODULE_PREFIX || l_api_name || '.execption'
2531: , NULL);
2532: END IF;
2533: RETURN -1;

Line 2537: p_output_to => 'FND_LOG.STRING'

2533: RETURN -1;
2534: -- **** for debug information in readonly UT environment.--- begin ****
2535: JMF_SHIKYU_RPT_UTIL.debug_output
2536: (
2537: p_output_to => 'FND_LOG.STRING'
2538: ,p_api_name => G_MODULE_PREFIX || l_api_name
2539: ,p_message => 'WHEN OTHERS THEN'
2540: );
2541: -- **** for debug information in readonly UT environment.--- end ****

Line 2608: p_output_to => 'FND_LOG.STRING'

2604: BEGIN
2605: -- **** for debug information in readonly UT environment.--- begin ****
2606: JMF_SHIKYU_RPT_UTIL.debug_output
2607: (
2608: p_output_to => 'FND_LOG.STRING'
2609: ,p_api_name => G_MODULE_PREFIX || l_api_name
2610: ,p_message => 'begin:' ||
2611: ',p_sub_po_unconsumed_row_type:' || p_sub_po_unconsumed_row_type ||
2612: ',p_rcv_transaction_row_type:' || p_rcv_transaction_row_type ||

Line 2627: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2623: );
2624: -- **** for debug information in readonly UT environment.--- end ****
2625:
2626: IF g_fnd_debug = 'Y' AND
2627: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2628: THEN
2629: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2630: , g_module_prefix || l_api_name || '.begin'
2631: , NULL);

Line 2629: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2625:
2626: IF g_fnd_debug = 'Y' AND
2627: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2628: THEN
2629: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2630: , g_module_prefix || l_api_name || '.begin'
2631: , NULL);
2632: END IF;
2633:

Line 2651: p_output_to => 'FND_LOG.STRING'

2647:
2648: -- **** for debug information in readonly UT environment.--- begin ****
2649: JMF_SHIKYU_RPT_UTIL.debug_output
2650: (
2651: p_output_to => 'FND_LOG.STRING'
2652: ,p_api_name => G_MODULE_PREFIX || l_api_name
2653: ,p_message => 'begin:' ||
2654: ',l_residual_new_consumed_pri:' || l_residual_new_consumed_pri ||
2655: ',l_sub_po_id:' || l_sub_po_id ||

Line 2691: ,p_output_to => 'FND_LOG.STRING'

2687: -- if l_residual_new_consumed_pri > 0 then ---
2688: COMMIT; -- for debug on UT ?????
2689: rpt_debug_show_mid_data(
2690: p_row_type => p_sub_po_unconsumed_row_type
2691: ,p_output_to => 'FND_LOG.STRING'
2692: );
2693: IF g_fnd_debug = 'Y' AND
2694: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2695: THEN

Line 2694: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2690: p_row_type => p_sub_po_unconsumed_row_type
2691: ,p_output_to => 'FND_LOG.STRING'
2692: );
2693: IF g_fnd_debug = 'Y' AND
2694: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2695: THEN
2696: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2697: , g_module_prefix || l_api_name || '.end'
2698: , NULL);

Line 2696: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2692: );
2693: IF g_fnd_debug = 'Y' AND
2694: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2695: THEN
2696: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2697: , g_module_prefix || l_api_name || '.end'
2698: , NULL);
2699: END IF;
2700: EXCEPTION

Line 2708: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2704: fnd_msg_pub.Add;
2705:
2706: WHEN OTHERS THEN
2707: IF g_fnd_debug = 'Y' AND
2708: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2709: THEN
2710: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2711: , G_MODULE_PREFIX || l_api_name || '.execption'
2712: , NULL);

Line 2710: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2706: WHEN OTHERS THEN
2707: IF g_fnd_debug = 'Y' AND
2708: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2709: THEN
2710: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2711: , G_MODULE_PREFIX || l_api_name || '.execption'
2712: , NULL);
2713: END IF;
2714: -- **** for debug information in readonly UT environment.--- begin ****

Line 2717: p_output_to => 'FND_LOG.STRING'

2713: END IF;
2714: -- **** for debug information in readonly UT environment.--- begin ****
2715: JMF_SHIKYU_RPT_UTIL.debug_output
2716: (
2717: p_output_to => 'FND_LOG.STRING'
2718: ,p_api_name => G_MODULE_PREFIX || l_api_name
2719: ,p_message => 'WHEN OTHERS THEN'
2720: );
2721: -- **** for debug information in readonly UT environment.--- end ****

Line 2761: p_output_to => 'FND_LOG.STRING'

2757: BEGIN
2758: -- **** for debug information in readonly UT environment.--- begin ****
2759: JMF_SHIKYU_RPT_UTIL.debug_output
2760: (
2761: p_output_to => 'FND_LOG.STRING'
2762: ,p_api_name => G_MODULE_PREFIX || l_api_name
2763: ,p_message => 'begin:' ||
2764: ',p_rcv_row_type:' || p_rcv_row_type ||
2765: ',p_rcv_transaction_id:' || p_rcv_transaction_id ||

Line 2779: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2775: );
2776: -- **** for debug information in readonly UT environment.--- end ****
2777:
2778: IF g_fnd_debug = 'Y' AND
2779: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2780: THEN
2781: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2782: , g_module_prefix || l_api_name || '.begin'
2783: , NULL);

Line 2781: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2777:
2778: IF g_fnd_debug = 'Y' AND
2779: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2780: THEN
2781: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2782: , g_module_prefix || l_api_name || '.begin'
2783: , NULL);
2784: END IF;
2785:

Line 2829: ,p_output_to => 'FND_LOG.STRING'

2825: END IF; --IF l_jmf_cfr_mid_temp_rcv_rows = 1
2826: COMMIT; -- for debug on UT ?????
2827: rpt_debug_show_mid_data(
2828: p_row_type => p_rcv_row_type
2829: ,p_output_to => 'FND_LOG.STRING'
2830: );
2831: IF g_fnd_debug = 'Y' AND
2832: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2833: THEN

Line 2832: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2828: p_row_type => p_rcv_row_type
2829: ,p_output_to => 'FND_LOG.STRING'
2830: );
2831: IF g_fnd_debug = 'Y' AND
2832: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2833: THEN
2834: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2835: , g_module_prefix || l_api_name || '.end'
2836: , NULL);

Line 2834: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2830: );
2831: IF g_fnd_debug = 'Y' AND
2832: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2833: THEN
2834: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2835: , g_module_prefix || l_api_name || '.end'
2836: , NULL);
2837: END IF;
2838: EXCEPTION

Line 2847: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2843:
2844: WHEN OTHERS THEN
2845:
2846: IF g_fnd_debug = 'Y' AND
2847: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2848: THEN
2849: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2850: , G_MODULE_PREFIX || l_api_name || '.execption'
2851: , NULL);

Line 2849: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2845:
2846: IF g_fnd_debug = 'Y' AND
2847: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2848: THEN
2849: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2850: , G_MODULE_PREFIX || l_api_name || '.execption'
2851: , NULL);
2852: END IF;
2853: -- **** for debug information in readonly UT environment.--- begin ****

Line 2856: p_output_to => 'FND_LOG.STRING'

2852: END IF;
2853: -- **** for debug information in readonly UT environment.--- begin ****
2854: JMF_SHIKYU_RPT_UTIL.debug_output
2855: (
2856: p_output_to => 'FND_LOG.STRING'
2857: ,p_api_name => G_MODULE_PREFIX || l_api_name
2858: ,p_message => 'WHEN OTHERS THEN'
2859: );
2860: -- **** for debug information in readonly UT environment.--- end ****

Line 2879: p_output_to => 'FND_LOG.STRING'

2875: BEGIN
2876: -- **** for debug information in readonly UT environment.--- begin ****
2877: JMF_SHIKYU_RPT_UTIL.debug_output
2878: (
2879: p_output_to => 'FND_LOG.STRING'
2880: ,p_api_name => G_MODULE_PREFIX || l_api_name
2881: ,p_message => 'begin:' ||
2882: ',p_rcv_row_type:' || p_rcv_row_type
2883: );

Line 2887: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2883: );
2884: -- **** for debug information in readonly UT environment.--- end ****
2885:
2886: IF g_fnd_debug = 'Y' AND
2887: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2888: THEN
2889: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2890: , g_module_prefix || l_api_name || '.begin'
2891: , 'p_rcv_row_type:' || p_rcv_row_type);

Line 2889: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2885:
2886: IF g_fnd_debug = 'Y' AND
2887: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2888: THEN
2889: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2890: , g_module_prefix || l_api_name || '.begin'
2891: , 'p_rcv_row_type:' || p_rcv_row_type);
2892: END IF;
2893:

Line 2918: ,p_output_to => 'FND_LOG.STRING'

2914: WHERE row_type = CFR_TMP_RCV_ROW;
2915: COMMIT; -- for debug on UT ?????
2916: rpt_debug_show_mid_data(
2917: p_row_type => CFR_TMP_RCV_ROW
2918: ,p_output_to => 'FND_LOG.STRING'
2919: );
2920: IF g_fnd_debug = 'Y' AND
2921: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2922: THEN

Line 2921: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2917: p_row_type => CFR_TMP_RCV_ROW
2918: ,p_output_to => 'FND_LOG.STRING'
2919: );
2920: IF g_fnd_debug = 'Y' AND
2921: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2922: THEN
2923: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2924: , g_module_prefix || l_api_name || '.end'
2925: , NULL);

Line 2923: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2919: );
2920: IF g_fnd_debug = 'Y' AND
2921: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2922: THEN
2923: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2924: , g_module_prefix || l_api_name || '.end'
2925: , NULL);
2926: END IF;
2927: EXCEPTION

Line 2935: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2931: fnd_msg_pub.Add;
2932:
2933: WHEN OTHERS THEN
2934: IF g_fnd_debug = 'Y' AND
2935: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2936: THEN
2937: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2938: , G_MODULE_PREFIX || l_api_name || '.execption'
2939: , NULL);

Line 2937: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2933: WHEN OTHERS THEN
2934: IF g_fnd_debug = 'Y' AND
2935: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2936: THEN
2937: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2938: , G_MODULE_PREFIX || l_api_name || '.execption'
2939: , NULL);
2940: END IF;
2941: -- **** for debug information in readonly UT environment.--- begin ****

Line 2944: p_output_to => 'FND_LOG.STRING'

2940: END IF;
2941: -- **** for debug information in readonly UT environment.--- begin ****
2942: JMF_SHIKYU_RPT_UTIL.debug_output
2943: (
2944: p_output_to => 'FND_LOG.STRING'
2945: ,p_api_name => G_MODULE_PREFIX || l_api_name
2946: ,p_message => 'WHEN OTHERS THEN'
2947: );
2948: -- **** for debug information in readonly UT environment.--- end ****

Line 2982: p_output_to => 'FND_LOG.STRING'

2978: BEGIN
2979: -- **** for debug information in readonly UT environment.--- begin ****
2980: JMF_SHIKYU_RPT_UTIL.debug_output
2981: (
2982: p_output_to => 'FND_LOG.STRING'
2983: ,p_api_name => G_MODULE_PREFIX || l_api_name
2984: ,p_message => 'begin:' ||
2985: ',p_rcv_row_type:' || p_rcv_row_type ||
2986: ',p_rpt_mode:' || p_rpt_mode ||

Line 2995: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

2991: );
2992: -- **** for debug information in readonly UT environment.--- end ****
2993:
2994: IF g_fnd_debug = 'Y' AND
2995: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2996: THEN
2997: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2998: , g_module_prefix || l_api_name || '.begin'
2999: , NULL);

Line 2997: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

2993:
2994: IF g_fnd_debug = 'Y' AND
2995: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
2996: THEN
2997: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
2998: , g_module_prefix || l_api_name || '.begin'
2999: , NULL);
3000: END IF;
3001:

Line 3011: p_output_to => 'FND_LOG.STRING'

3007: END IF;
3008: -- **** for debug information in readonly UT environment.--- begin ****
3009: JMF_SHIKYU_RPT_UTIL.debug_output
3010: (
3011: p_output_to => 'FND_LOG.STRING'
3012: ,p_api_name => G_MODULE_PREFIX || l_api_name
3013: ,p_message => 'begin:' ||
3014: ',l_p_currency_conversion_date:' || l_p_currency_conversion_date
3015: );

Line 3055: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3051: -- get data for internal report
3052: rpt_get_Int_data(p_rpt_mode => p_rpt_mode);
3053:
3054: IF g_fnd_debug = 'Y' AND
3055: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3056: THEN
3057: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3058: , g_module_prefix || l_api_name || '.end'
3059: , NULL);

Line 3057: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

3053:
3054: IF g_fnd_debug = 'Y' AND
3055: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3056: THEN
3057: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3058: , g_module_prefix || l_api_name || '.end'
3059: , NULL);
3060: END IF;
3061: EXCEPTION

Line 3070: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3066: fnd_msg_pub.Add;
3067:
3068: WHEN OTHERS THEN
3069: IF g_fnd_debug = 'Y' AND
3070: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3071: THEN
3072: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3073: , G_MODULE_PREFIX || l_api_name || '.execption'
3074: , SQLERRM);

Line 3072: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

3068: WHEN OTHERS THEN
3069: IF g_fnd_debug = 'Y' AND
3070: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3071: THEN
3072: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
3073: , G_MODULE_PREFIX || l_api_name || '.execption'
3074: , SQLERRM);
3075: END IF;
3076: -- **** for debug information in readonly UT environment.--- begin ****

Line 3079: p_output_to => 'FND_LOG.STRING'

3075: END IF;
3076: -- **** for debug information in readonly UT environment.--- begin ****
3077: JMF_SHIKYU_RPT_UTIL.debug_output
3078: (
3079: p_output_to => 'FND_LOG.STRING'
3080: ,p_api_name => G_MODULE_PREFIX || l_api_name
3081: ,p_message => 'WHEN OTHERS THEN:' || SQLERRM
3082: );
3083: -- **** for debug information in readonly UT environment.--- end ****

Line 3105: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3101: l_api_name CONSTANT VARCHAR2(30) := 'rpt_get_data';
3102:
3103: BEGIN
3104: -- **** for debug information in readonly UT environment.--- begin ****
3105: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
3106: ,p_api_name => G_MODULE_PREFIX || l_api_name
3107: ,p_message => 'begin:');
3108: -- **** for debug information in readonly UT environment.--- end ****
3109:

Line 3111: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3107: ,p_message => 'begin:');
3108: -- **** for debug information in readonly UT environment.--- end ****
3109:
3110: IF g_fnd_debug = 'Y'
3111: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3112: THEN
3113: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3114: ,g_module_prefix || l_api_name
3115: ,'.begin');

Line 3113: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

3109:
3110: IF g_fnd_debug = 'Y'
3111: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3112: THEN
3113: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3114: ,g_module_prefix || l_api_name
3115: ,'.begin');
3116: END IF;
3117:

Line 3357: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3353: */
3354:
3355: COMMIT; -- for debug on UT ?????
3356: IF g_fnd_debug = 'Y' AND
3357: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3358: THEN
3359: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3360: , g_module_prefix || l_api_name || '.end'
3361: , NULL);

Line 3359: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

3355: COMMIT; -- for debug on UT ?????
3356: IF g_fnd_debug = 'Y' AND
3357: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3358: THEN
3359: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3360: , g_module_prefix || l_api_name || '.end'
3361: , NULL);
3362: END IF;
3363: EXCEPTION

Line 3370: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3366: NULL;
3367:
3368: WHEN OTHERS THEN
3369: IF g_fnd_debug = 'Y'
3370: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3371: THEN
3372: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3373: ,G_MODULE_PREFIX || l_api_name || '.execption'
3374: ,NULL);

Line 3372: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED

3368: WHEN OTHERS THEN
3369: IF g_fnd_debug = 'Y'
3370: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3371: THEN
3372: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3373: ,G_MODULE_PREFIX || l_api_name || '.execption'
3374: ,NULL);
3375: END IF;
3376: -- **** for debug information in readonly UT environment.--- begin ****

Line 3377: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3373: ,G_MODULE_PREFIX || l_api_name || '.execption'
3374: ,NULL);
3375: END IF;
3376: -- **** for debug information in readonly UT environment.--- begin ****
3377: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
3378: ,p_api_name => G_MODULE_PREFIX || l_api_name
3379: ,p_message => 'WHEN OTHERS THEN');
3380: -- **** for debug information in readonly UT environment.--- end ****
3381:

Line 3397: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3393: l_api_name CONSTANT VARCHAR2(30) := 'rpt_get_Comp_Estimated_data';
3394:
3395: BEGIN
3396: -- **** for debug information in readonly UT environment.--- begin ****
3397: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
3398: ,p_api_name => G_MODULE_PREFIX || l_api_name
3399: ,p_message => 'begin:');
3400: -- **** for debug information in readonly UT environment.--- end ****
3401:

Line 3403: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3399: ,p_message => 'begin:');
3400: -- **** for debug information in readonly UT environment.--- end ****
3401:
3402: IF g_fnd_debug = 'Y'
3403: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3404: THEN
3405: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3406: ,g_module_prefix || l_api_name
3407: ,'.begin');

Line 3405: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

3401:
3402: IF g_fnd_debug = 'Y'
3403: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3404: THEN
3405: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3406: ,g_module_prefix || l_api_name
3407: ,'.begin');
3408: END IF;
3409:

Line 3621: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3617: msibk.inventory_item_id)
3618: WHERE temp.rpt_DATA_TYPE = CFR_EXT_COMPONENT;
3619: COMMIT; -- for debug on UT ?????
3620: IF g_fnd_debug = 'Y' AND
3621: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3622: THEN
3623: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3624: , g_module_prefix || l_api_name || '.end'
3625: , NULL);

Line 3623: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

3619: COMMIT; -- for debug on UT ?????
3620: IF g_fnd_debug = 'Y' AND
3621: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3622: THEN
3623: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3624: , g_module_prefix || l_api_name || '.end'
3625: , NULL);
3626: END IF;
3627: EXCEPTION

Line 3634: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3630: NULL;
3631:
3632: WHEN OTHERS THEN
3633: IF g_fnd_debug = 'Y'
3634: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3635: THEN
3636: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3637: ,G_MODULE_PREFIX || l_api_name || '.execption'
3638: ,NULL);

Line 3636: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED

3632: WHEN OTHERS THEN
3633: IF g_fnd_debug = 'Y'
3634: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3635: THEN
3636: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3637: ,G_MODULE_PREFIX || l_api_name || '.execption'
3638: ,NULL);
3639: END IF;
3640: -- **** for debug information in readonly UT environment.--- begin ****

Line 3641: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3637: ,G_MODULE_PREFIX || l_api_name || '.execption'
3638: ,NULL);
3639: END IF;
3640: -- **** for debug information in readonly UT environment.--- begin ****
3641: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
3642: ,p_api_name => G_MODULE_PREFIX || l_api_name
3643: ,p_message => 'WHEN OTHERS THEN');
3644: -- **** for debug information in readonly UT environment.--- end ****
3645:

Line 3663: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3659: l_api_name CONSTANT VARCHAR2(30) := 'rpt_get_SubPO_data';
3660:
3661: BEGIN
3662: -- **** for debug information in readonly UT environment.--- begin ****
3663: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
3664: ,p_api_name => G_MODULE_PREFIX || l_api_name
3665: ,p_message => 'begin:');
3666: -- **** for debug information in readonly UT environment.--- end ****
3667:

Line 3669: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3665: ,p_message => 'begin:');
3666: -- **** for debug information in readonly UT environment.--- end ****
3667:
3668: IF g_fnd_debug = 'Y'
3669: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3670: THEN
3671: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3672: ,g_module_prefix || l_api_name
3673: ,'.begin');

Line 3671: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

3667:
3668: IF g_fnd_debug = 'Y'
3669: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3670: THEN
3671: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3672: ,g_module_prefix || l_api_name
3673: ,'.begin');
3674: END IF;
3675:

Line 3801: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3797:
3798: COMMIT; -- for debug on UT ?????
3799:
3800: IF g_fnd_debug = 'Y' AND
3801: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3802: THEN
3803: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3804: , g_module_prefix || l_api_name || '.end'
3805: , NULL);

Line 3803: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

3799:
3800: IF g_fnd_debug = 'Y' AND
3801: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3802: THEN
3803: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3804: , g_module_prefix || l_api_name || '.end'
3805: , NULL);
3806: END IF;
3807: EXCEPTION

Line 3814: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3810: NULL;
3811:
3812: WHEN OTHERS THEN
3813: IF g_fnd_debug = 'Y'
3814: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3815: THEN
3816: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3817: ,G_MODULE_PREFIX || l_api_name || '.execption'
3818: ,NULL);

Line 3816: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED

3812: WHEN OTHERS THEN
3813: IF g_fnd_debug = 'Y'
3814: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3815: THEN
3816: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3817: ,G_MODULE_PREFIX || l_api_name || '.execption'
3818: ,NULL);
3819: END IF;
3820: -- **** for debug information in readonly UT environment.--- begin ****

Line 3821: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3817: ,G_MODULE_PREFIX || l_api_name || '.execption'
3818: ,NULL);
3819: END IF;
3820: -- **** for debug information in readonly UT environment.--- begin ****
3821: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
3822: ,p_api_name => G_MODULE_PREFIX || l_api_name
3823: ,p_message => 'WHEN OTHERS THEN');
3824: -- **** for debug information in readonly UT environment.--- end ****
3825:

Line 3852: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3848: l_api_name CONSTANT VARCHAR2(30) := 'rpt_get_UnReceived_data';
3849:
3850: BEGIN
3851: -- **** for debug information in readonly UT environment.--- begin ****
3852: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
3853: ,p_api_name => G_MODULE_PREFIX || l_api_name
3854: ,p_message => 'begin:');
3855: -- **** for debug information in readonly UT environment.--- end ****
3856:

Line 3858: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3854: ,p_message => 'begin:');
3855: -- **** for debug information in readonly UT environment.--- end ****
3856:
3857: IF g_fnd_debug = 'Y'
3858: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3859: THEN
3860: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3861: ,g_module_prefix || l_api_name
3862: ,'.begin');

Line 3860: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

3856:
3857: IF g_fnd_debug = 'Y'
3858: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3859: THEN
3860: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
3861: ,g_module_prefix || l_api_name
3862: ,'.begin');
3863: END IF;
3864:

Line 3980: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3976: ,0)),0);
3977: -- Amy updated to fix bug 5583680 end
3978: COMMIT; -- for debug on UT ?????
3979: IF g_fnd_debug = 'Y' AND
3980: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3981: THEN
3982: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3983: , g_module_prefix || l_api_name || '.end'
3984: , NULL);

Line 3982: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

3978: COMMIT; -- for debug on UT ?????
3979: IF g_fnd_debug = 'Y' AND
3980: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3981: THEN
3982: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
3983: , g_module_prefix || l_api_name || '.end'
3984: , NULL);
3985: END IF;
3986: EXCEPTION

Line 3993: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

3989: NULL;
3990:
3991: WHEN OTHERS THEN
3992: IF g_fnd_debug = 'Y'
3993: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3994: THEN
3995: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3996: ,G_MODULE_PREFIX || l_api_name || '.execption'
3997: ,NULL);

Line 3995: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED

3991: WHEN OTHERS THEN
3992: IF g_fnd_debug = 'Y'
3993: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
3994: THEN
3995: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
3996: ,G_MODULE_PREFIX || l_api_name || '.execption'
3997: ,NULL);
3998: END IF;
3999: -- **** for debug information in readonly UT environment.--- begin ****

Line 4000: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

3996: ,G_MODULE_PREFIX || l_api_name || '.execption'
3997: ,NULL);
3998: END IF;
3999: -- **** for debug information in readonly UT environment.--- begin ****
4000: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
4001: ,p_api_name => G_MODULE_PREFIX || l_api_name
4002: ,p_message => 'WHEN OTHERS THEN');
4003: -- **** for debug information in readonly UT environment.--- end ****
4004:

Line 4023: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

4019: l_api_name CONSTANT VARCHAR2(30) := 'rpt_get_Received_data';
4020:
4021: BEGIN
4022: -- **** for debug information in readonly UT environment.--- begin ****
4023: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
4024: ,p_api_name => G_MODULE_PREFIX || l_api_name
4025: ,p_message => 'begin:');
4026: -- **** for debug information in readonly UT environment.--- end ****
4027:

Line 4029: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4025: ,p_message => 'begin:');
4026: -- **** for debug information in readonly UT environment.--- end ****
4027:
4028: IF g_fnd_debug = 'Y'
4029: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4030: THEN
4031: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4032: ,g_module_prefix || l_api_name
4033: ,'.begin');

Line 4031: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

4027:
4028: IF g_fnd_debug = 'Y'
4029: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4030: THEN
4031: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4032: ,g_module_prefix || l_api_name
4033: ,'.begin');
4034: END IF;
4035:

Line 4125: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4121: ,NVL(plla.quantity_received
4122: ,0)),0);
4123: COMMIT; -- for debug on UT ?????
4124: IF g_fnd_debug = 'Y' AND
4125: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4126: THEN
4127: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4128: , g_module_prefix || l_api_name || '.end'
4129: , NULL);

Line 4127: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

4123: COMMIT; -- for debug on UT ?????
4124: IF g_fnd_debug = 'Y' AND
4125: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4126: THEN
4127: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4128: , g_module_prefix || l_api_name || '.end'
4129: , NULL);
4130: END IF;
4131: EXCEPTION

Line 4138: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4134: NULL;
4135:
4136: WHEN OTHERS THEN
4137: IF g_fnd_debug = 'Y'
4138: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4139: THEN
4140: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
4141: ,G_MODULE_PREFIX || l_api_name || '.execption'
4142: ,NULL);

Line 4140: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED

4136: WHEN OTHERS THEN
4137: IF g_fnd_debug = 'Y'
4138: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4139: THEN
4140: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
4141: ,G_MODULE_PREFIX || l_api_name || '.execption'
4142: ,NULL);
4143: END IF;
4144: -- **** for debug information in readonly UT environment.--- begin ****

Line 4145: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

4141: ,G_MODULE_PREFIX || l_api_name || '.execption'
4142: ,NULL);
4143: END IF;
4144: -- **** for debug information in readonly UT environment.--- begin ****
4145: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
4146: ,p_api_name => G_MODULE_PREFIX || l_api_name
4147: ,p_message => 'WHEN OTHERS THEN');
4148: -- **** for debug information in readonly UT environment.--- end ****
4149:

Line 4165: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

4161: l_api_name CONSTANT VARCHAR2(30) := 'rpt_get_Int_data';
4162:
4163: BEGIN
4164: -- **** for debug information in readonly UT environment.--- begin ****
4165: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
4166: ,p_api_name => G_MODULE_PREFIX || l_api_name
4167: ,p_message => 'begin:');
4168: -- **** for debug information in readonly UT environment.--- end ****
4169:

Line 4171: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4167: ,p_message => 'begin:');
4168: -- **** for debug information in readonly UT environment.--- end ****
4169:
4170: IF g_fnd_debug = 'Y'
4171: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4172: THEN
4173: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4174: ,g_module_prefix || l_api_name
4175: ,'.begin');

Line 4173: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

4169:
4170: IF g_fnd_debug = 'Y'
4171: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4172: THEN
4173: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4174: ,g_module_prefix || l_api_name
4175: ,'.begin');
4176: END IF;
4177:

Line 4447: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4443: --add for fix bug 4997302 Begin
4444:
4445: COMMIT; -- for debug on UT ?????
4446: IF g_fnd_debug = 'Y' AND
4447: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4448: THEN
4449: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4450: , g_module_prefix || l_api_name || '.end'
4451: , NULL);

Line 4449: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

4445: COMMIT; -- for debug on UT ?????
4446: IF g_fnd_debug = 'Y' AND
4447: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4448: THEN
4449: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4450: , g_module_prefix || l_api_name || '.end'
4451: , NULL);
4452: END IF;
4453: EXCEPTION

Line 4460: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4456: NULL;
4457:
4458: WHEN OTHERS THEN
4459: IF g_fnd_debug = 'Y'
4460: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4461: THEN
4462: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
4463: ,G_MODULE_PREFIX || l_api_name || '.execption'
4464: ,NULL);

Line 4462: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED

4458: WHEN OTHERS THEN
4459: IF g_fnd_debug = 'Y'
4460: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4461: THEN
4462: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
4463: ,G_MODULE_PREFIX || l_api_name || '.execption'
4464: ,NULL);
4465: END IF;
4466: -- **** for debug information in readonly UT environment.--- begin ****

Line 4467: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

4463: ,G_MODULE_PREFIX || l_api_name || '.execption'
4464: ,NULL);
4465: END IF;
4466: -- **** for debug information in readonly UT environment.--- begin ****
4467: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
4468: ,p_api_name => G_MODULE_PREFIX || l_api_name
4469: ,p_message => SQLERRM);
4470: -- **** for debug information in readonly UT environment.--- end ****
4471:

Line 4488: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

4484: l_api_name CONSTANT VARCHAR2(30) := 'rpt_get_SubPO_data_Onhand';
4485:
4486: BEGIN
4487: -- **** for debug information in readonly UT environment.--- begin ****
4488: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
4489: ,p_api_name => G_MODULE_PREFIX || l_api_name
4490: ,p_message => 'begin:');
4491: -- **** for debug information in readonly UT environment.--- end ****
4492:

Line 4494: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4490: ,p_message => 'begin:');
4491: -- **** for debug information in readonly UT environment.--- end ****
4492:
4493: IF g_fnd_debug = 'Y'
4494: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4495: THEN
4496: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4497: ,g_module_prefix || l_api_name
4498: ,'.begin');

Line 4496: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

4492:
4493: IF g_fnd_debug = 'Y'
4494: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4495: THEN
4496: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4497: ,g_module_prefix || l_api_name
4498: ,'.begin');
4499: END IF;
4500:

Line 4563: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4559: AND wro.repetitive_schedule_id IS NULL
4560: AND temp.item_id = wro.inventory_item_id;
4561: COMMIT; -- for debug on UT ?????
4562: IF g_fnd_debug = 'Y' AND
4563: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4564: THEN
4565: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4566: , g_module_prefix || l_api_name || '.end'
4567: , NULL);

Line 4565: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

4561: COMMIT; -- for debug on UT ?????
4562: IF g_fnd_debug = 'Y' AND
4563: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4564: THEN
4565: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4566: , g_module_prefix || l_api_name || '.end'
4567: , NULL);
4568: END IF;
4569: EXCEPTION

Line 4576: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4572: NULL;
4573:
4574: WHEN OTHERS THEN
4575: IF g_fnd_debug = 'Y'
4576: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4577: THEN
4578: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
4579: ,G_MODULE_PREFIX || l_api_name || '.execption'
4580: ,NULL);

Line 4578: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED

4574: WHEN OTHERS THEN
4575: IF g_fnd_debug = 'Y'
4576: AND FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4577: THEN
4578: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED
4579: ,G_MODULE_PREFIX || l_api_name || '.execption'
4580: ,NULL);
4581: END IF;
4582: -- **** for debug information in readonly UT environment.--- begin ****

Line 4583: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'

4579: ,G_MODULE_PREFIX || l_api_name || '.execption'
4580: ,NULL);
4581: END IF;
4582: -- **** for debug information in readonly UT environment.--- begin ****
4583: JMF_SHIKYU_RPT_UTIL.debug_output(p_output_to => 'FND_LOG.STRING'
4584: ,p_api_name => G_MODULE_PREFIX || l_api_name
4585: ,p_message => 'WHEN OTHERS THEN');
4586: -- **** for debug information in readonly UT environment.--- end ****
4587:

Line 4716: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4712: ,p_message => '==jmf_shikyu_cfr_mid_temp data end==');
4713: -- **** for debug information in readonly UT environment.--- end ****
4714:
4715: IF g_fnd_debug = 'Y' AND
4716: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4717: THEN
4718: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4719: , g_module_prefix || l_api_name || '.end'
4720: , NULL);

Line 4718: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE

4714:
4715: IF g_fnd_debug = 'Y' AND
4716: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4717: THEN
4718: fnd_log.STRING( FND_LOG.LEVEL_PROCEDURE
4719: , g_module_prefix || l_api_name || '.end'
4720: , NULL);
4721: END IF;
4722: EXCEPTION

Line 4943: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

4939: ,p_message => '==jmf_shikyu_cfr_rpt_temp data end==');
4940: -- **** for debug information in readonly UT environment.--- end ****
4941:
4942: IF g_fnd_debug = 'Y'
4943: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4944: THEN
4945: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4946: ,g_module_prefix || l_api_name || '.end'
4947: ,NULL);

Line 4945: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

4941:
4942: IF g_fnd_debug = 'Y'
4943: AND FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
4944: THEN
4945: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4946: ,g_module_prefix || l_api_name || '.end'
4947: ,NULL);
4948: END IF;
4949: EXCEPTION