DBA Data[Home] [Help]

APPS.JMF_SHIKYU_ADJUSTMENT_PROC dependencies on FND_LOG

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

50: --| 12-DEC-2005 vchu Modified the queries in the adjust_negative |
51: --| procedure for getting the WIP consumed qty |
52: --| and total allocated qty for the |
53: --| Subcontracting Component being adjusted |
54: --| 16-JAN-2006 shu using FND_LOG.STRING for logging standard |
55: --| 27-JAN-2006 shu update the message according to seed data file|
56: --| 13-MAR-2006 the remove Commented code |
57: --| 13-MAR-2006 the added code for update the last_update_date |
58: --| column with sysdate. |

Line 157: p_output_to => 'FND_LOG.STRING'

153:
154: -- **** for debug information in readonly UT environment.--- begin ****
155: JMF_SHIKYU_RPT_UTIL.debug_output
156: (
157: p_output_to => 'FND_LOG.STRING'
158: ,p_api_name => G_MODULE_PREFIX || l_api_name || '.begin'
159: ,p_message => '========(p_batch_size: ' || p_batch_size ||
160: ' , p_max_workers: ' || p_max_workers || ' ) ========'
161: );

Line 173: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

169:
170: fnd_file.PUT_LINE(fnd_file.LOG, l_jmf_shk_not_enabled);
171:
172: IF g_fnd_debug = 'Y' AND
173: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
174: THEN
175: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
176: ,g_module_prefix || l_api_name || '.warning'
177: ,l_jmf_shk_not_enabled);

Line 175: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

171:
172: IF g_fnd_debug = 'Y' AND
173: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
174: THEN
175: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
176: ,g_module_prefix || l_api_name || '.warning'
177: ,l_jmf_shk_not_enabled);
178: END IF;
179:

Line 210: p_output_to => 'FND_LOG.STRING'

206: END IF;
207: -- **** for debug information in readonly UT environment.--- begin ****
208: JMF_SHIKYU_UTIL.debug_output
209: (
210: p_output_to => 'FND_LOG.STRING'
211: ,p_api_name => G_MODULE_PREFIX || l_api_name
212: ,p_message => 'begin, l_p_batch_size:' || l_p_batch_size ||
213: ',l_p_max_workers:' || l_p_max_workers
214: );

Line 218: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

214: );
215: -- **** for debug information in readonly UT environment.--- end ****
216:
217: IF g_fnd_debug = 'Y' AND
218: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
219: THEN
220: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
221: ,g_module_prefix || l_api_name || '.begin'
222: ,NULL);

Line 220: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

216:
217: IF g_fnd_debug = 'Y' AND
218: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
219: THEN
220: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
221: ,g_module_prefix || l_api_name || '.begin'
222: ,NULL);
223: END IF;
224:

Line 273: p_output_to => 'FND_LOG.STRING'

269: l_counter := l_counter + 1;
270: -- **** for debug information in readonly UT environment.--- begin ****
271: JMF_SHIKYU_RPT_UTIL.debug_output
272: (
273: p_output_to => 'FND_LOG.STRING'
274: ,p_api_name => G_MODULE_PREFIX || l_api_name
275: ,p_message => 'c_negative_adj%ROWCOUNT:' || c_negative_adj%ROWCOUNT ||
276: ' l_counter:' || l_counter || ',l_cur_cons_adj_id_index:' ||
277: l_cur_cons_adj_id_index

Line 318: p_output_to => 'FND_LOG.STRING'

314:
315: -- **** for debug information in readonly UT environment.--- begin ****
316: JMF_SHIKYU_RPT_UTIL.debug_output
317: (
318: p_output_to => 'FND_LOG.STRING'
319: ,p_api_name => G_MODULE_PREFIX || l_api_name
320: ,p_message => 'c_negative_adj%ROWCOUNT:' || c_negative_adj%ROWCOUNT ||
321: 'jmf_shikyu_util.submit_worker, l_return_status:' ||
322: l_return_status || ',l_request_id:' || l_request_id

Line 342: p_output_to => 'FND_LOG.STRING'

338:
339: -- **** for debug information in readonly UT environment.--- begin ****
340: JMF_SHIKYU_RPT_UTIL.debug_output
341: (
342: p_output_to => 'FND_LOG.STRING'
343: ,p_api_name => G_MODULE_PREFIX || l_api_name
344: ,p_message => 'Negative Adjustment: l_batch_id: ' || l_batch_id ||
345: ' ,l_batch_request_id_tbl.COUNT: ' || l_batch_request_id_tbl.COUNT ||
346: ' ,l_request_id: ' || l_request_id

Line 403: p_output_to => 'FND_LOG.STRING'

399: l_counter := l_counter + 1;
400: -- **** for debug information in readonly UT environment.--- begin ****
401: JMF_SHIKYU_RPT_UTIL.debug_output
402: (
403: p_output_to => 'FND_LOG.STRING'
404: ,p_api_name => G_MODULE_PREFIX || l_api_name
405: ,p_message => 'c_positive_adj%ROWCOUNT:' || c_positive_adj%ROWCOUNT ||
406: ' l_counter:' || l_counter || ',l_cur_cons_adj_id_index:' ||
407: l_cur_cons_adj_id_index

Line 448: p_output_to => 'FND_LOG.STRING'

444:
445: -- **** for debug information in readonly UT environment.--- begin ****
446: JMF_SHIKYU_RPT_UTIL.debug_output
447: (
448: p_output_to => 'FND_LOG.STRING'
449: ,p_api_name => G_MODULE_PREFIX || l_api_name
450: ,p_message => 'c_positive_adj%ROWCOUNT:' || c_positive_adj%ROWCOUNT ||
451: 'jmf_shikyu_util.submit_worker, l_return_status:' ||
452: l_return_status || ',l_request_id:' || l_request_id

Line 470: p_output_to => 'FND_LOG.STRING'

466: ;
467: -- **** for debug information in readonly UT environment.--- begin ****
468: JMF_SHIKYU_RPT_UTIL.debug_output
469: (
470: p_output_to => 'FND_LOG.STRING'
471: ,p_api_name => G_MODULE_PREFIX || l_api_name
472: ,p_message => 'Positive Adjustment: l_batch_id: ' || l_batch_id ||
473: ' ,l_batch_request_id_tbl.COUNT: ' || l_batch_request_id_tbl.COUNT ||
474: ' ,l_request_id: ' || l_request_id

Line 504: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

500: --Wait for all the workers submitted for the positive adjustmemt data to complete;
501: jmf_shikyu_util.wait_for_all_workers(p_workers => l_workers);
502:
503: IF g_fnd_debug = 'Y' AND
504: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
505: THEN
506: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
507: ,g_module_prefix || l_api_name || '.end'
508: ,NULL);

Line 506: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

502:
503: IF g_fnd_debug = 'Y' AND
504: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
505: THEN
506: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
507: ,g_module_prefix || l_api_name || '.end'
508: ,NULL);
509: END IF;
510:

Line 514: p_output_to => 'FND_LOG.STRING'

510:
511: -- **** for debug information in readonly UT environment.--- begin ****
512: JMF_SHIKYU_RPT_UTIL.debug_output
513: (
514: p_output_to => 'FND_LOG.STRING'
515: ,p_api_name => G_MODULE_PREFIX || l_api_name
516: ,p_message => 'Update jmf_shikyu_adjustments'
517: );
518: JMF_SHIKYU_RPT_UTIL.debug_output

Line 520: p_output_to => 'FND_LOG.STRING'

516: ,p_message => 'Update jmf_shikyu_adjustments'
517: );
518: JMF_SHIKYU_RPT_UTIL.debug_output
519: (
520: p_output_to => 'FND_LOG.STRING'
521: ,p_api_name => G_MODULE_PREFIX || l_api_name
522: ,p_message => 'l_batch_request_id_tbl.COUNT: ' || l_batch_request_id_tbl.COUNT
523: );
524: -- **** for debug information in readonly UT environment.--- end ****

Line 534: p_output_to => 'FND_LOG.STRING'

530:
531: -- **** for debug information in readonly UT environment.--- begin ****
532: JMF_SHIKYU_RPT_UTIL.debug_output
533: (
534: p_output_to => 'FND_LOG.STRING'
535: ,p_api_name => G_MODULE_PREFIX || l_api_name
536: ,p_message => 'l_cur_batch_id_index: ' || l_cur_batch_id_index ||
537: ' ,l_batch_request_id_tbl(' || l_cur_batch_id_index || ': ' || l_batch_request_id_tbl(l_cur_batch_id_index) ||
538: ' ,l_request_id: ' || l_request_id

Line 591: p_output_to => 'FND_LOG.STRING'

587:
588: -- **** for debug information in readonly UT environment.--- begin ****
589: JMF_SHIKYU_RPT_UTIL.debug_output
590: (
591: p_output_to => 'FND_LOG.STRING'
592: ,p_api_name => G_MODULE_PREFIX || l_api_name || '.end'
593: ,p_message => 'Adjustment Manager End at'
594: || to_char(SYSDATE,'YYYY-MM-DD HH:MM:SS')
595: );

Line 603: p_output_to => 'FND_LOG.STRING'

599: WHEN no_data_found THEN
600: -- **** for debug information in readonly UT environment.--- begin ****
601: JMF_SHIKYU_RPT_UTIL.debug_output
602: (
603: p_output_to => 'FND_LOG.STRING'
604: ,p_api_name => G_MODULE_PREFIX || l_api_name
605: ,p_message => 'no_data_found.EXCEPTION:' || SQLERRM
606: );
607: -- **** for debug information in readonly UT environment.--- end ****

Line 618: p_output_to => 'FND_LOG.STRING'

614: WHEN OTHERS THEN
615: -- **** for debug information in readonly UT environment.--- begin ****
616: JMF_SHIKYU_RPT_UTIL.debug_output
617: (
618: p_output_to => 'FND_LOG.STRING'
619: ,p_api_name => G_MODULE_PREFIX || l_api_name
620: ,p_message => ' WHEN OTHERS.EXCEPTION:' || SQLERRM
621: );
622: -- **** for debug information in readonly UT environment.--- end ****

Line 672: p_output_to => 'FND_LOG.STRING'

668: BEGIN
669: -- **** for debug information in readonly UT environment.--- begin ****
670: JMF_SHIKYU_RPT_UTIL.debug_output
671: (
672: p_output_to => 'FND_LOG.STRING'
673: ,p_api_name => G_MODULE_PREFIX || l_api_name
674: ,p_message => 'Begin'
675: );
676: -- **** for debug information in readonly UT environment.--- end ****

Line 679: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

675: );
676: -- **** for debug information in readonly UT environment.--- end ****
677:
678: IF g_fnd_debug = 'Y' AND
679: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
680: THEN
681: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
682: ,g_module_prefix || l_api_name || '.begin'
683: ,NULL);

Line 681: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

677:
678: IF g_fnd_debug = 'Y' AND
679: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
680: THEN
681: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
682: ,g_module_prefix || l_api_name || '.begin'
683: ,NULL);
684: END IF;
685:

Line 697: p_output_to => 'FND_LOG.STRING'

693: WHERE request_id = l_request_id;
694: -- **** for debug information in readonly UT environment.--- begin ****
695: JMF_SHIKYU_RPT_UTIL.debug_output
696: (
697: p_output_to => 'FND_LOG.STRING'
698: ,p_api_name => G_MODULE_PREFIX || l_api_name
699: ,p_message => '***-------------Consumption adjustment request:' ||
700: ' l_parent_request_id' || '--------------***.'
701: );

Line 707: p_output_to => 'FND_LOG.STRING'

703:
704: -- **** for debug information in readonly UT environment.--- begin ****
705: JMF_SHIKYU_RPT_UTIL.debug_output
706: (
707: p_output_to => 'FND_LOG.STRING'
708: ,p_api_name => G_MODULE_PREFIX || l_api_name
709: ,p_message => '***-------------Begin of worker request information--------------***.'
710: );
711: -- **** for debug information in readonly UT environment.--- end ****

Line 738: p_output_to => 'FND_LOG.STRING'

734: END IF;
735: -- **** for debug information in readonly UT environment.--- begin ****
736: JMF_SHIKYU_RPT_UTIL.debug_output
737: (
738: p_output_to => 'FND_LOG.STRING'
739: ,p_api_name => G_MODULE_PREFIX || l_api_name
740: ,p_message => 'Worker status, request_id:' || l_request_id
741: || ',phase:' || l_phase
742: || ',status:' || l_status

Line 755: p_output_to => 'FND_LOG.STRING'

751:
752: -- **** for debug information in readonly UT environment.--- begin ****
753: JMF_SHIKYU_RPT_UTIL.debug_output
754: (
755: p_output_to => 'FND_LOG.STRING'
756: ,p_api_name => G_MODULE_PREFIX || l_api_name
757: ,p_message => '***-------------End of worker request information--------------***.'
758: );
759: -- **** for debug information in readonly UT environment.--- end ****

Line 765: p_output_to => 'FND_LOG.STRING'

761: ELSE
762: -- **** for debug information in readonly UT environment.--- begin ****
763: JMF_SHIKYU_RPT_UTIL.debug_output
764: (
765: p_output_to => 'FND_LOG.STRING'
766: ,p_api_name => G_MODULE_PREFIX || l_api_name
767: ,p_message => 'No workers submit.'
768: );
769: -- **** for debug information in readonly UT environment.--- end ****

Line 773: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

769: -- **** for debug information in readonly UT environment.--- end ****
770: END IF;
771:
772: IF g_fnd_debug = 'Y' AND
773: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
774: THEN
775: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
776: ,g_module_prefix || l_api_name || '.end'
777: ,NULL);

Line 775: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

771:
772: IF g_fnd_debug = 'Y' AND
773: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
774: THEN
775: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
776: ,g_module_prefix || l_api_name || '.end'
777: ,NULL);
778: END IF;
779: -- **** for debug information in readonly UT environment.--- begin ****

Line 782: p_output_to => 'FND_LOG.STRING'

778: END IF;
779: -- **** for debug information in readonly UT environment.--- begin ****
780: JMF_SHIKYU_RPT_UTIL.debug_output
781: (
782: p_output_to => 'FND_LOG.STRING'
783: ,p_api_name => G_MODULE_PREFIX || l_api_name
784: ,p_message => 'End'
785: );
786: -- **** for debug information in readonly UT environment.--- end ****

Line 813: p_output_to => 'FND_LOG.STRING'

809: BEGIN
810: -- **** for debug information in readonly UT environment.--- begin ****
811: JMF_SHIKYU_RPT_UTIL.debug_output
812: (
813: p_output_to => 'FND_LOG.STRING'
814: ,p_api_name => G_MODULE_PREFIX || l_api_name
815: ,p_message => 'Begin, p_batch_id:' || p_batch_id
816: );
817: -- **** for debug information in readonly UT environment.--- end ****

Line 820: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

816: );
817: -- **** for debug information in readonly UT environment.--- end ****
818:
819: IF g_fnd_debug = 'Y' AND
820: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
821: THEN
822: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
823: ,g_module_prefix || l_api_name || '.begin'
824: ,NULL);

Line 822: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

818:
819: IF g_fnd_debug = 'Y' AND
820: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
821: THEN
822: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
823: ,g_module_prefix || l_api_name || '.begin'
824: ,NULL);
825: END IF;
826:

Line 832: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

828: adjust_consumption(p_batch_id => p_batch_id
829: ,x_return_status => l_return_status);
830:
831: IF g_fnd_debug = 'Y' AND
832: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
833: THEN
834: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
835: ,g_module_prefix || l_api_name || '.end'
836: ,l_return_status);

Line 834: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

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

Line 841: p_output_to => 'FND_LOG.STRING'

837: END IF;
838: -- **** for debug information in readonly UT environment.--- begin ****
839: JMF_SHIKYU_RPT_UTIL.debug_output
840: (
841: p_output_to => 'FND_LOG.STRING'
842: ,p_api_name => G_MODULE_PREFIX || l_api_name
843: ,p_message => 'End, p_batch_id:' || p_batch_id
844: || ',x_chr_errbuff:' || x_chr_errbuff
845: || ',x_chr_retcode:' || x_chr_retcode

Line 891: p_output_to => 'FND_LOG.STRING'

887: BEGIN
888: -- **** for debug information in readonly UT environment.--- begin ****
889: JMF_SHIKYU_RPT_UTIL.debug_output
890: (
891: p_output_to => 'FND_LOG.STRING'
892: ,p_api_name => G_MODULE_PREFIX || l_api_name
893: ,p_message => 'Begin, p_batch_id:' || p_batch_id
894: );
895: -- **** for debug information in readonly UT environment.--- end ****

Line 898: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

894: );
895: -- **** for debug information in readonly UT environment.--- end ****
896:
897: IF g_fnd_debug = 'Y' AND
898: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
899: THEN
900: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
901: ,g_module_prefix || l_api_name || '.begin'
902: ,NULL);

Line 900: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

896:
897: IF g_fnd_debug = 'Y' AND
898: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
899: THEN
900: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
901: ,g_module_prefix || l_api_name || '.begin'
902: ,NULL);
903: END IF;
904:

Line 934: p_output_to => 'FND_LOG.STRING'

930:
931: -- **** for debug information in readonly UT environment.--- begin ****
932: JMF_SHIKYU_RPT_UTIL.debug_output
933: (
934: p_output_to => 'FND_LOG.STRING'
935: ,p_api_name => G_MODULE_PREFIX || l_api_name
936: ,p_message => 'x_return_status: ' || x_return_status
937: );
938: -- **** for debug information in readonly UT environment.--- end ****

Line 944: p_output_to => 'FND_LOG.STRING'

940: THEN
941: -- **** for debug information in readonly UT environment.--- begin ****
942: JMF_SHIKYU_RPT_UTIL.debug_output
943: (
944: p_output_to => 'FND_LOG.STRING'
945: ,p_api_name => G_MODULE_PREFIX || l_api_name
946: ,p_message => 'l_adjustment_id: ' || l_adjustment_id
947: );
948: -- **** for debug information in readonly UT environment.--- end ****

Line 961: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

957: END LOOP;
958: CLOSE c_adj;
959:
960: IF g_fnd_debug = 'Y' AND
961: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
962: THEN
963: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
964: ,g_module_prefix || l_api_name || '.end'
965: ,NULL);

Line 963: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

959:
960: IF g_fnd_debug = 'Y' AND
961: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
962: THEN
963: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
964: ,g_module_prefix || l_api_name || '.end'
965: ,NULL);
966: END IF;
967: -- **** for debug information in readonly UT environment.--- begin ****

Line 970: p_output_to => 'FND_LOG.STRING'

966: END IF;
967: -- **** for debug information in readonly UT environment.--- begin ****
968: JMF_SHIKYU_RPT_UTIL.debug_output
969: (
970: p_output_to => 'FND_LOG.STRING'
971: ,p_api_name => G_MODULE_PREFIX || l_api_name
972: ,p_message => 'End, p_batch_id:' || p_batch_id
973: );
974: -- **** for debug information in readonly UT environment.--- end ****

Line 980: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

976:
977: EXCEPTION
978: WHEN no_data_found THEN
979: IF g_fnd_debug = 'Y' AND
980: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
981: THEN
982:
983: --Set message name;
984: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');

Line 985: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_EXCEPTION

981: THEN
982:
983: --Set message name;
984: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');
985: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_EXCEPTION
986: ,MODULE => g_module_prefix || l_api_name ||
987: '.no_data_found'
988: ,POP_MESSAGE => FALSE);
989: END IF;

Line 996: p_output_to => 'FND_LOG.STRING'

992: x_return_status := fnd_api.g_ret_sts_error;
993: -- **** for debug information in readonly UT environment.--- begin ****
994: JMF_SHIKYU_RPT_UTIL.debug_output
995: (
996: p_output_to => 'FND_LOG.STRING'
997: ,p_api_name => G_MODULE_PREFIX || l_api_name
998: ,p_message => 'no_data_found.EXCEPTION:' || SQLERRM
999: );
1000: -- **** for debug information in readonly UT environment.--- end ****

Line 1004: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1000: -- **** for debug information in readonly UT environment.--- end ****
1001:
1002: WHEN OTHERS THEN
1003: IF g_fnd_debug = 'Y' AND
1004: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1005: THEN
1006: --Set message name;
1007: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');
1008: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_UNEXPECTED

Line 1008: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_UNEXPECTED

1004: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1005: THEN
1006: --Set message name;
1007: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');
1008: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_UNEXPECTED
1009: ,MODULE => g_module_prefix || l_api_name || '.others'
1010: ,POP_MESSAGE => FALSE);
1011: END IF;
1012: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1016: p_output_to => 'FND_LOG.STRING'

1012: x_return_status := fnd_api.g_ret_sts_unexp_error;
1013: -- **** for debug information in readonly UT environment.--- begin ****
1014: JMF_SHIKYU_RPT_UTIL.debug_output
1015: (
1016: p_output_to => 'FND_LOG.STRING'
1017: ,p_api_name => G_MODULE_PREFIX || l_api_name
1018: ,p_message => 'WHEN OTHERS.EXCEPTION:' || SQLERRM
1019: );
1020: -- **** for debug information in readonly UT environment.--- end ****

Line 1073: p_output_to => 'FND_LOG.STRING'

1069:
1070: -- **** for debug information in readonly UT environment.--- begin ****
1071: JMF_SHIKYU_RPT_UTIL.debug_output
1072: (
1073: p_output_to => 'FND_LOG.STRING'
1074: ,p_api_name => G_MODULE_PREFIX || l_api_name
1075: ,p_message => 'Begin, p_subcontract_po_shipment_id:' || p_subcontract_po_shipment_id
1076: || ',p_component_id:' || p_component_id
1077: || ',p_adjustment_amount:' || p_adjustment_amount

Line 1082: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1078: || ',p_uom:' || p_uom
1079: );
1080: -- **** for debug information in readonly UT environment.--- end ****
1081: IF g_fnd_debug = 'Y' AND
1082: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1083: THEN
1084: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1085: ,g_module_prefix || l_api_name || '.begin'
1086: ,NULL);

Line 1084: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

1080: -- **** for debug information in readonly UT environment.--- end ****
1081: IF g_fnd_debug = 'Y' AND
1082: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1083: THEN
1084: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1085: ,g_module_prefix || l_api_name || '.begin'
1086: ,NULL);
1087: END IF;
1088:

Line 1106: p_output_to => 'FND_LOG.STRING'

1102: ,x_remaining_qty => l_remaining_qty);
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 => 'end of jmf_shikyu_allocation_pvt.get_available_replenishment_so, x_return_status:' || x_return_status
1109: || ',x_remaining_qty:' || l_remaining_qty
1110: || ',x_msg_data:' || l_msg_data

Line 1120: p_output_to => 'FND_LOG.STRING'

1116: THEN
1117: -- **** for debug information in readonly UT environment.--- begin ****
1118: JMF_SHIKYU_RPT_UTIL.debug_output
1119: (
1120: p_output_to => 'FND_LOG.STRING'
1121: ,p_api_name => G_MODULE_PREFIX || l_api_name
1122: ,p_message => 'RAISE g_not_enough_replen_exc:'
1123: || 'l_remaining_qty:' || l_remaining_qty
1124: );

Line 1142: p_output_to => 'FND_LOG.STRING'

1138: ,x_qty_allocated => l_qty_allocated);
1139: -- **** for debug information in readonly UT environment.--- begin ****
1140: JMF_SHIKYU_RPT_UTIL.debug_output
1141: (
1142: p_output_to => 'FND_LOG.STRING'
1143: ,p_api_name => G_MODULE_PREFIX || l_api_name
1144: ,p_message => 'end of jmf_shikyu_allocation_pvt.allocate_quantity, x_return_status:' || x_return_status
1145: || ',x_qty_allocated:' || l_qty_allocated
1146: || ',x_msg_data:' || l_msg_data

Line 1161: p_output_to => 'FND_LOG.STRING'

1157: ,x_return_status => x_return_status);
1158: -- **** for debug information in readonly UT environment.--- begin ****
1159: JMF_SHIKYU_RPT_UTIL.debug_output
1160: (
1161: p_output_to => 'FND_LOG.STRING'
1162: ,p_api_name => G_MODULE_PREFIX || l_api_name
1163: ,p_message => 'end of jmf_shikyu_inv_pvt.process_wip_component_issue, x_return_status:' || x_return_status
1164: || ',p_subcontract_po_shipment_id:' || p_subcontract_po_shipment_id
1165: || ',p_component_id:' || p_component_id

Line 1186: p_output_to => 'FND_LOG.STRING'

1182: ,x_reduced_allocations_tbl => l_deallocated_rep_so_qty_tbl);
1183: -- **** for debug information in readonly UT environment.--- begin ****
1184: JMF_SHIKYU_RPT_UTIL.debug_output
1185: (
1186: p_output_to => 'FND_LOG.STRING'
1187: ,p_api_name => G_MODULE_PREFIX || l_api_name
1188: ,p_message => 'end of reduce the allocation, x_return_status:' || x_return_status
1189: || ',x_actual_reduced_qty:' || l_actual_reduced_qty
1190: || ',x_msg_data:' || l_msg_data

Line 1198: p_output_to => 'FND_LOG.STRING'

1194: THEN
1195: -- **** for debug information in readonly UT environment.--- begin ****
1196: JMF_SHIKYU_RPT_UTIL.debug_output
1197: (
1198: p_output_to => 'FND_LOG.STRING'
1199: ,p_api_name => G_MODULE_PREFIX || l_api_name
1200: ,p_message => 'RAISE g_allocation_exc:'
1201: || 'reduce_allocations failed '
1202: || 'when the return status of '

Line 1214: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1210: END IF; -- end of x_return_status = FND_API.G_RET_STS_SUCCESS for allocate_quantity
1211: END IF; -- end of l_remaining_qty > 0
1212:
1213: IF g_fnd_debug = 'Y' AND
1214: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1215: THEN
1216: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1217: ,g_module_prefix || l_api_name || '.end'
1218: ,NULL);

Line 1216: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

1212:
1213: IF g_fnd_debug = 'Y' AND
1214: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1215: THEN
1216: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1217: ,g_module_prefix || l_api_name || '.end'
1218: ,NULL);
1219: END IF;
1220: -- **** for debug information in readonly UT environment.--- begin ****

Line 1223: p_output_to => 'FND_LOG.STRING'

1219: END IF;
1220: -- **** for debug information in readonly UT environment.--- begin ****
1221: JMF_SHIKYU_RPT_UTIL.debug_output
1222: (
1223: p_output_to => 'FND_LOG.STRING'
1224: ,p_api_name => G_MODULE_PREFIX || l_api_name
1225: ,p_message => 'End, p_subcontract_po_shipment_id:' || p_subcontract_po_shipment_id
1226: || ',p_component_id:' || p_component_id
1227: || ',p_adjustment_amount:' || p_adjustment_amount

Line 1236: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1232: EXCEPTION
1233: WHEN no_data_found THEN
1234:
1235: IF g_fnd_debug = 'Y' AND
1236: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1237: THEN
1238:
1239: --Set message name;
1240: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');

Line 1241: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_EXCEPTION

1237: THEN
1238:
1239: --Set message name;
1240: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');
1241: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_EXCEPTION
1242: ,MODULE => g_module_prefix || l_api_name ||
1243: '.no_data_found'
1244: ,POP_MESSAGE => FALSE);
1245: --Call FND_LOG.string;

Line 1245: --Call FND_LOG.string;

1241: fnd_log.MESSAGE(LOG_LEVEL => FND_LOG.LEVEL_EXCEPTION
1242: ,MODULE => g_module_prefix || l_api_name ||
1243: '.no_data_found'
1244: ,POP_MESSAGE => FALSE);
1245: --Call FND_LOG.string;
1246: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1247: ,g_module_prefix || l_api_name || '.no_data_found'
1248: ,'JMF_SHIKYU_ADJ_MGR_ERROR');
1249: END IF;

Line 1246: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

1242: ,MODULE => g_module_prefix || l_api_name ||
1243: '.no_data_found'
1244: ,POP_MESSAGE => FALSE);
1245: --Call FND_LOG.string;
1246: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1247: ,g_module_prefix || l_api_name || '.no_data_found'
1248: ,'JMF_SHIKYU_ADJ_MGR_ERROR');
1249: END IF;
1250:

Line 1259: p_output_to => 'FND_LOG.STRING'

1255: x_return_status := fnd_api.g_ret_sts_error;
1256: -- **** for debug information in readonly UT environment.--- begin ****
1257: JMF_SHIKYU_RPT_UTIL.debug_output
1258: (
1259: p_output_to => 'FND_LOG.STRING'
1260: ,p_api_name => G_MODULE_PREFIX || l_api_name
1261: ,p_message => 'no_data_found Exception:' || SQLERRM
1262: );
1263: -- **** for debug information in readonly UT environment.--- end ****

Line 1313: p_output_to => 'FND_LOG.STRING'

1309:
1310: -- **** for debug information in readonly UT environment.--- begin ****
1311: JMF_SHIKYU_RPT_UTIL.debug_output
1312: (
1313: p_output_to => 'FND_LOG.STRING'
1314: ,p_api_name => G_MODULE_PREFIX || l_api_name
1315: ,p_message => 'g_not_enough_replen_exc: message: ' || l_jmf_shk_exception
1316: );
1317: -- **** for debug information in readonly UT environment.--- end ****

Line 1321: --Call FND_LOG.string;

1317: -- **** for debug information in readonly UT environment.--- end ****
1318:
1319: x_return_status := fnd_api.g_ret_sts_error;
1320:
1321: --Call FND_LOG.string;
1322: --Print the FND Error Message 'JMF_SHIKYU_POS_ADJ_ERROR' to the concurrent request log file;
1323: IF g_fnd_debug = 'Y' AND
1324: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1325: THEN

Line 1324: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1320:
1321: --Call FND_LOG.string;
1322: --Print the FND Error Message 'JMF_SHIKYU_POS_ADJ_ERROR' to the concurrent request log file;
1323: IF g_fnd_debug = 'Y' AND
1324: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1325: THEN
1326: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1327: ,g_module_prefix || l_api_name || '.g_excep_level'
1328: ,'g_not_enough_replen_exc');

Line 1326: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

1322: --Print the FND Error Message 'JMF_SHIKYU_POS_ADJ_ERROR' to the concurrent request log file;
1323: IF g_fnd_debug = 'Y' AND
1324: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1325: THEN
1326: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1327: ,g_module_prefix || l_api_name || '.g_excep_level'
1328: ,'g_not_enough_replen_exc');
1329: END IF;
1330: -- **** for debug information in readonly UT environment.--- begin ****

Line 1333: p_output_to => 'FND_LOG.STRING'

1329: END IF;
1330: -- **** for debug information in readonly UT environment.--- begin ****
1331: JMF_SHIKYU_RPT_UTIL.debug_output
1332: (
1333: p_output_to => 'FND_LOG.STRING'
1334: ,p_api_name => G_MODULE_PREFIX || l_api_name
1335: ,p_message => 'EXCEPTION:g_not_enough_replen_exc ,l_po_num' || l_po_num
1336: || ',l_po_line_num:' || l_po_line_num
1337: || ',l_allocable_qty:' || l_allocable_qty

Line 1346: --Call FND_LOG.string;

1342:
1343: WHEN OTHERS THEN
1344: --Set message name;
1345: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');
1346: --Call FND_LOG.string;
1347: IF g_fnd_debug = 'Y' AND
1348: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1349: THEN
1350: fnd_log.STRING(FND_LOG.LEVEL_UNEXPECTED

Line 1348: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1344: --Set message name;
1345: fnd_message.set_name('JMF', 'JMF_SHK_ADJ_MGR_ERROR');
1346: --Call FND_LOG.string;
1347: IF g_fnd_debug = 'Y' AND
1348: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1349: THEN
1350: fnd_log.STRING(FND_LOG.LEVEL_UNEXPECTED
1351: ,g_module_prefix || l_api_name ||
1352: '.JMF_SHIKYU_ADJ_MGR_ERROR'

Line 1350: fnd_log.STRING(FND_LOG.LEVEL_UNEXPECTED

1346: --Call FND_LOG.string;
1347: IF g_fnd_debug = 'Y' AND
1348: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1349: THEN
1350: fnd_log.STRING(FND_LOG.LEVEL_UNEXPECTED
1351: ,g_module_prefix || l_api_name ||
1352: '.JMF_SHIKYU_ADJ_MGR_ERROR'
1353: ,'JMF_SHIKYU_ADJ_MGR_ERROR');
1354: END IF;

Line 1359: p_output_to => 'FND_LOG.STRING'

1355: x_return_status := fnd_api.g_ret_sts_unexp_error;
1356: -- **** for debug information in readonly UT environment.--- begin ****
1357: JMF_SHIKYU_RPT_UTIL.debug_output
1358: (
1359: p_output_to => 'FND_LOG.STRING'
1360: ,p_api_name => G_MODULE_PREFIX || l_api_name
1361: ,p_message => 'WHEN OTHERS:' || SQLERRM
1362: );
1363: -- **** for debug information in readonly UT environment.--- end ****

Line 1415: p_output_to => 'FND_LOG.STRING'

1411:
1412: -- **** for debug information in readonly UT environment.--- begin ****
1413: JMF_SHIKYU_RPT_UTIL.debug_output
1414: (
1415: p_output_to => 'FND_LOG.STRING'
1416: ,p_api_name => G_MODULE_PREFIX || l_api_name
1417: ,p_message => 'Begin, p_subcontract_po_shipment_id:' || p_subcontract_po_shipment_id
1418: || ',p_component_id:' || p_component_id
1419: || ',p_adjustment_amount:' || p_adjustment_amount

Line 1424: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1420: || ',p_uom:' || p_uom
1421: );
1422: -- **** for debug information in readonly UT environment.--- end ****
1423: IF g_fnd_debug = 'Y' AND
1424: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1425: THEN
1426: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1427: ,g_module_prefix || l_api_name || '.begin'
1428: ,NULL);

Line 1426: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

1422: -- **** for debug information in readonly UT environment.--- end ****
1423: IF g_fnd_debug = 'Y' AND
1424: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1425: THEN
1426: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1427: ,g_module_prefix || l_api_name || '.begin'
1428: ,NULL);
1429: END IF;
1430:

Line 1462: p_output_to => 'FND_LOG.STRING'

1458: THEN
1459: -- **** for debug information in readonly UT environment.--- begin ****
1460: JMF_SHIKYU_RPT_UTIL.debug_output
1461: (
1462: p_output_to => 'FND_LOG.STRING'
1463: ,p_api_name => G_MODULE_PREFIX || l_api_name
1464: ,p_message => 'RAISE g_wip_issued_less_alloc_exc:'
1465: || 'l_wip_consumed_qty:' || l_wip_consumed_qty
1466: || '> l_total_allocated_qty:' || l_total_allocated_qty

Line 1489: p_output_to => 'FND_LOG.STRING'

1485: ,x_reduced_allocations_tbl => l_deallocated_rep_so_qty_tbl);
1486: -- **** for debug information in readonly UT environment.--- begin ****
1487: JMF_SHIKYU_RPT_UTIL.debug_output
1488: (
1489: p_output_to => 'FND_LOG.STRING'
1490: ,p_api_name => G_MODULE_PREFIX || l_api_name
1491: ,p_message => 'end of reduce the allocation, x_return_status:' || x_return_status
1492: || ',x_actual_reduced_qty:' || l_actual_reduced_qty
1493: || ',x_msg_data:' || l_msg_data

Line 1509: p_output_to => 'FND_LOG.STRING'

1505: ,x_return_status => x_return_status);
1506: -- **** for debug information in readonly UT environment.--- begin ****
1507: JMF_SHIKYU_RPT_UTIL.debug_output
1508: (
1509: p_output_to => 'FND_LOG.STRING'
1510: ,p_api_name => G_MODULE_PREFIX || l_api_name
1511: ,p_message => 'end of component for the WIP, x_return_status:' || x_return_status
1512: );
1513: -- **** for debug information in readonly UT environment.--- end ****

Line 1532: p_output_to => 'FND_LOG.STRING'

1528: ,x_remaining_qty => l_remaining_qty);
1529: -- **** for debug information in readonly UT environment.--- begin ****
1530: JMF_SHIKYU_RPT_UTIL.debug_output
1531: (
1532: p_output_to => 'FND_LOG.STRING'
1533: ,p_api_name => G_MODULE_PREFIX || l_api_name
1534: ,p_message => 'end of jmf_shikyu_allocation_pvt.get_available_replenishment_so, x_return_status:' || x_return_status
1535: || ',x_remaining_qty:' || l_remaining_qty
1536: || ',x_msg_data:' || l_msg_data

Line 1546: p_output_to => 'FND_LOG.STRING'

1542: THEN
1543: -- **** for debug information in readonly UT environment.--- begin ****
1544: JMF_SHIKYU_RPT_UTIL.debug_output
1545: (
1546: p_output_to => 'FND_LOG.STRING'
1547: ,p_api_name => G_MODULE_PREFIX || l_api_name
1548: ,p_message => 'RAISE g_not_enough_replen_exc:'
1549: || 'l_remaining_qty:' || l_remaining_qty
1550: );

Line 1568: p_output_to => 'FND_LOG.STRING'

1564: ,x_qty_allocated => l_qty_allocated);
1565: -- **** for debug information in readonly UT environment.--- begin ****
1566: JMF_SHIKYU_RPT_UTIL.debug_output
1567: (
1568: p_output_to => 'FND_LOG.STRING'
1569: ,p_api_name => G_MODULE_PREFIX || l_api_name
1570: ,p_message => 'end of jmf_shikyu_allocation_pvt.allocate_quantity, x_return_status:' || x_return_status
1571: || ',x_qty_allocated:' || l_qty_allocated
1572: || ',x_msg_data:' || l_msg_data

Line 1580: p_output_to => 'FND_LOG.STRING'

1576: THEN
1577: -- **** for debug information in readonly UT environment.--- begin ****
1578: JMF_SHIKYU_RPT_UTIL.debug_output
1579: (
1580: p_output_to => 'FND_LOG.STRING'
1581: ,p_api_name => G_MODULE_PREFIX || l_api_name
1582: ,p_message => 'RAISE g_allocation_exc:'
1583: || 'allocate_quantity failed '
1584: || 'when the return status of '

Line 1597: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1593: END IF; -- end of x_return_status = FND_API.G_RET_STS_SUCCESS for reduce_allocations
1594: END IF; --end of l_WIP_consumed_qty > l_total_allocated_qty
1595:
1596: IF g_fnd_debug = 'Y' AND
1597: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1598: THEN
1599: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1600: ,g_module_prefix || l_api_name || '.end'
1601: ,NULL);

Line 1599: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE

1595:
1596: IF g_fnd_debug = 'Y' AND
1597: FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1598: THEN
1599: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
1600: ,g_module_prefix || l_api_name || '.end'
1601: ,NULL);
1602: END IF;
1603: -- **** for debug information in readonly UT environment.--- begin ****

Line 1606: p_output_to => 'FND_LOG.STRING'

1602: END IF;
1603: -- **** for debug information in readonly UT environment.--- begin ****
1604: JMF_SHIKYU_RPT_UTIL.debug_output
1605: (
1606: p_output_to => 'FND_LOG.STRING'
1607: ,p_api_name => G_MODULE_PREFIX || l_api_name
1608: ,p_message => 'End, p_subcontract_po_shipment_id:' || p_subcontract_po_shipment_id
1609: || ',p_component_id:' || p_component_id
1610: || ',p_adjustment_amount:' || p_adjustment_amount

Line 1617: --Call FND_LOG.string;

1613: -- **** for debug information in readonly UT environment.--- end ****
1614:
1615: EXCEPTION
1616: WHEN no_data_found THEN
1617: --Call FND_LOG.string;
1618: IF g_fnd_debug = 'Y' AND
1619: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1620: THEN
1621: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

Line 1619: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1615: EXCEPTION
1616: WHEN no_data_found THEN
1617: --Call FND_LOG.string;
1618: IF g_fnd_debug = 'Y' AND
1619: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1620: THEN
1621: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1622: ,g_module_prefix || l_api_name || '.no_data_found'
1623: ,'NO_DATA_FOUND:' || SQLERRM);

Line 1621: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

1617: --Call FND_LOG.string;
1618: IF g_fnd_debug = 'Y' AND
1619: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1620: THEN
1621: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1622: ,g_module_prefix || l_api_name || '.no_data_found'
1623: ,'NO_DATA_FOUND:' || SQLERRM);
1624: END IF;
1625: x_return_status := fnd_api.g_ret_sts_error;

Line 1629: p_output_to => 'FND_LOG.STRING'

1625: x_return_status := fnd_api.g_ret_sts_error;
1626: -- **** for debug information in readonly UT environment.--- begin ****
1627: JMF_SHIKYU_RPT_UTIL.debug_output
1628: (
1629: p_output_to => 'FND_LOG.STRING'
1630: ,p_api_name => G_MODULE_PREFIX || l_api_name
1631: ,p_message => 'NO_DATA.' || SQLERRM
1632: );
1633: -- **** for debug information in readonly UT environment.--- end ****

Line 1644: --Call FND_LOG.string;

1640: l_jmf_shk_exception := 'Exception: WIP job consumed qty(' || l_wip_consumed_qty ||
1641: ') is more than total allocated qty(' ||
1642: l_total_allocated_qty || '), UOM :'
1643: || l_wip_consumed_uom;
1644: --Call FND_LOG.string;
1645: IF g_fnd_debug = 'Y' AND
1646: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1647: THEN
1648: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

Line 1646: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1642: l_total_allocated_qty || '), UOM :'
1643: || l_wip_consumed_uom;
1644: --Call FND_LOG.string;
1645: IF g_fnd_debug = 'Y' AND
1646: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1647: THEN
1648: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1649: ,g_module_prefix || l_api_name ||
1650: '.g_wip_issued_less_alloc_exc'

Line 1648: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION

1644: --Call FND_LOG.string;
1645: IF g_fnd_debug = 'Y' AND
1646: FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1647: THEN
1648: fnd_log.STRING(FND_LOG.LEVEL_EXCEPTION
1649: ,g_module_prefix || l_api_name ||
1650: '.g_wip_issued_less_alloc_exc'
1651: ,l_jmf_shk_exception);
1652: END IF;

Line 1658: p_output_to => 'FND_LOG.STRING'

1654: x_return_status := fnd_api.g_ret_sts_error;
1655: -- **** for debug information in readonly UT environment.--- begin ****
1656: JMF_SHIKYU_RPT_UTIL.debug_output
1657: (
1658: p_output_to => 'FND_LOG.STRING'
1659: ,p_api_name => G_MODULE_PREFIX || l_api_name
1660: ,p_message => l_jmf_shk_exception || '.' || SQLERRM
1661: );
1662: -- **** for debug information in readonly UT environment.--- end ****

Line 1671: --Call FND_LOG.string;

1667: l_conc_succ := fnd_concurrent.set_completion_status(status => 'WARNING'
1668: ,message => l_jmf_shk_exception);
1669:
1670: WHEN OTHERS THEN
1671: --Call FND_LOG.string;
1672: IF g_fnd_debug = 'Y' AND
1673: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1674:
1675: THEN

Line 1673: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL

1669:
1670: WHEN OTHERS THEN
1671: --Call FND_LOG.string;
1672: IF g_fnd_debug = 'Y' AND
1673: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1674:
1675: THEN
1676: fnd_log.STRING(FND_LOG.LEVEL_UNEXPECTED
1677: ,g_module_prefix || l_api_name || '.unexp_error'

Line 1676: fnd_log.STRING(FND_LOG.LEVEL_UNEXPECTED

1672: IF g_fnd_debug = 'Y' AND
1673: FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL
1674:
1675: THEN
1676: fnd_log.STRING(FND_LOG.LEVEL_UNEXPECTED
1677: ,g_module_prefix || l_api_name || '.unexp_error'
1678: ,'unexpected error' || SQLERRM);
1679: END IF;
1680: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1684: p_output_to => 'FND_LOG.STRING'

1680: x_return_status := fnd_api.g_ret_sts_unexp_error;
1681: -- **** for debug information in readonly UT environment.--- begin ****
1682: JMF_SHIKYU_RPT_UTIL.debug_output
1683: (
1684: p_output_to => 'FND_LOG.STRING'
1685: ,p_api_name => G_MODULE_PREFIX || l_api_name
1686: ,p_message => 'WHEN OTHERS: ' || SQLERRM
1687: );
1688: -- **** for debug information in readonly UT environment.--- end ****