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.OKS_REPRICE_PVT dependencies on FND_LOG

Line 49: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

45: FROM oks_k_headers_b
46: WHERE chr_id = p_chr_id;
47: BEGIN
48: -- start debug log
49: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
50: fnd_log.STRING (fnd_log.level_procedure,
51: g_module ||
52: l_api_name,
53: '100: Entered ' ||

Line 50: fnd_log.STRING (fnd_log.level_procedure,

46: WHERE chr_id = p_chr_id;
47: BEGIN
48: -- start debug log
49: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
50: fnd_log.STRING (fnd_log.level_procedure,
51: g_module ||
52: l_api_name,
53: '100: Entered ' ||
54: g_pkg_name ||

Line 105: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

101:
102: x_return_status := l_return_status;
103:
104: -- end debug log
105: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
106: fnd_log.STRING (fnd_log.level_procedure,
107: g_module ||
108: l_api_name,
109: '1000: Leaving ' ||

Line 106: fnd_log.STRING (fnd_log.level_procedure,

102: x_return_status := l_return_status;
103:
104: -- end debug log
105: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
106: fnd_log.STRING (fnd_log.level_procedure,
107: g_module ||
108: l_api_name,
109: '1000: Leaving ' ||
110: g_pkg_name ||

Line 118: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

114: END IF;
115: EXCEPTION
116: WHEN invalid_uom_exception THEN
117: -- end debug log
118: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
119: fnd_log.STRING (fnd_log.level_procedure,
120: g_module ||
121: l_api_name,
122: '9500: Leaving ' ||

Line 119: fnd_log.STRING (fnd_log.level_procedure,

115: EXCEPTION
116: WHEN invalid_uom_exception THEN
117: -- end debug log
118: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
119: fnd_log.STRING (fnd_log.level_procedure,
120: g_module ||
121: l_api_name,
122: '9500: Leaving ' ||
123: g_pkg_name ||

Line 138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

134: p_token2 => 'UOM_CODE',
135: p_token2_value => p_price_uom);
136: WHEN OTHERS THEN
137: -- end debug log
138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
139: fnd_log.STRING (fnd_log.level_procedure,
140: g_module ||
141: l_api_name,
142: '4000: Leaving ' ||

Line 139: fnd_log.STRING (fnd_log.level_procedure,

135: p_token2_value => p_price_uom);
136: WHEN OTHERS THEN
137: -- end debug log
138: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
139: fnd_log.STRING (fnd_log.level_procedure,
140: g_module ||
141: l_api_name,
142: '4000: Leaving ' ||
143: g_pkg_name ||

Line 199: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

195: l_old_tce_code VARCHAR2 (25);
196: l_new_tce_code VARCHAR2 (25);
197: BEGIN
198: -- start debug log
199: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
200: fnd_log.STRING (fnd_log.level_procedure,
201: g_module ||
202: l_api_name,
203: '100: Entered ' ||

Line 200: fnd_log.STRING (fnd_log.level_procedure,

196: l_new_tce_code VARCHAR2 (25);
197: BEGIN
198: -- start debug log
199: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
200: fnd_log.STRING (fnd_log.level_procedure,
201: g_module ||
202: l_api_name,
203: '100: Entered ' ||
204: g_pkg_name ||

Line 232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

228: INTO l_old_tce_code;
229: CLOSE l_time_csr;
230: */
231:
232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
233: fnd_log.STRING (fnd_log.level_statement,
234: g_module ||
235: l_api_name,
236: '100:Old Tce Code: ' ||

Line 233: fnd_log.STRING (fnd_log.level_statement,

229: CLOSE l_time_csr;
230: */
231:
232: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
233: fnd_log.STRING (fnd_log.level_statement,
234: g_module ||
235: l_api_name,
236: '100:Old Tce Code: ' ||
237: l_old_tce_code

Line 264: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

260: END IF;
261: CLOSE l_time_csr;
262: */
263:
264: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
265: fnd_log.STRING (fnd_log.level_statement,
266: g_module ||
267: l_api_name,
268: '101:New Tce Code: ' ||

Line 265: fnd_log.STRING (fnd_log.level_statement,

261: CLOSE l_time_csr;
262: */
263:
264: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
265: fnd_log.STRING (fnd_log.level_statement,
266: g_module ||
267: l_api_name,
268: '101:New Tce Code: ' ||
269: l_new_tce_code

Line 332: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

328: l_new_start_date +
329: 1;
330: END IF;
331:
332: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
333: fnd_log.STRING (fnd_log.level_statement,
334: g_module ||
335: l_api_name,
336: '102:Amount: ' ||

Line 333: fnd_log.STRING (fnd_log.level_statement,

329: 1;
330: END IF;
331:
332: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
333: fnd_log.STRING (fnd_log.level_statement,
334: g_module ||
335: l_api_name,
336: '102:Amount: ' ||
337: p_amount

Line 339: fnd_log.STRING (fnd_log.level_statement,

335: l_api_name,
336: '102:Amount: ' ||
337: p_amount
338: );
339: fnd_log.STRING (fnd_log.level_statement,
340: g_module ||
341: l_api_name,
342: '103:Old Duration: ' ||
343: l_old_duration

Line 345: fnd_log.STRING (fnd_log.level_statement,

341: l_api_name,
342: '103:Old Duration: ' ||
343: l_old_duration
344: );
345: fnd_log.STRING (fnd_log.level_statement,
346: g_module ||
347: l_api_name,
348: '104:New Duration: ' ||
349: l_new_duration

Line 361: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

357: (l_new_duration *
358: NVL (p_amount, 0)) /
359: NVL (l_old_duration, 1);
360:
361: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
362: fnd_log.STRING (fnd_log.level_statement,
363: g_module ||
364: l_api_name,
365: '105:Prorated Amount' ||

Line 362: fnd_log.STRING (fnd_log.level_statement,

358: NVL (p_amount, 0)) /
359: NVL (l_old_duration, 1);
360:
361: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
362: fnd_log.STRING (fnd_log.level_statement,
363: g_module ||
364: l_api_name,
365: '105:Prorated Amount' ||
366: l_prorated_amount

Line 373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

369:
370: ------------errorout_ad('Prorated Amount' || l_prorated_amount);
371:
372: -- end debug log
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.STRING (fnd_log.level_procedure,
375: g_module ||
376: l_api_name,
377: '1000: Leaving ' ||

Line 374: fnd_log.STRING (fnd_log.level_procedure,

370: ------------errorout_ad('Prorated Amount' || l_prorated_amount);
371:
372: -- end debug log
373: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
374: fnd_log.STRING (fnd_log.level_procedure,
375: g_module ||
376: l_api_name,
377: '1000: Leaving ' ||
378: g_pkg_name ||

Line 443: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

439: l_orig_system_id NUMBER;
440:
441: BEGIN
442: -- start debug log
443: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
444: fnd_log.STRING (fnd_log.level_procedure,
445: g_module ||
446: l_api_name,
447: '100: Entered ' ||

Line 444: fnd_log.STRING (fnd_log.level_procedure,

440:
441: BEGIN
442: -- start debug log
443: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
444: fnd_log.STRING (fnd_log.level_procedure,
445: g_module ||
446: l_api_name,
447: '100: Entered ' ||
448: g_pkg_name ||

Line 539: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

535: NVL (p_amount, 0)) /
536: NVL (l_old_duration, 1);
537: END IF;
538: -- end debug log
539: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
540: fnd_log.STRING (fnd_log.level_procedure,
541: g_module ||
542: l_api_name,
543: '1000: Leaving ' ||

Line 540: fnd_log.STRING (fnd_log.level_procedure,

536: NVL (l_old_duration, 1);
537: END IF;
538: -- end debug log
539: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
540: fnd_log.STRING (fnd_log.level_procedure,
541: g_module ||
542: l_api_name,
543: '1000: Leaving ' ||
544: g_pkg_name ||

Line 578: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

574: AND ool.subject_cle_id = p_cle_id
575: AND ROWNUM < 2);
576: BEGIN
577: -- start debug log
578: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
579: fnd_log.STRING (fnd_log.level_procedure,
580: g_module ||
581: l_api_name,
582: '100: Entered ' ||

Line 579: fnd_log.STRING (fnd_log.level_procedure,

575: AND ROWNUM < 2);
576: BEGIN
577: -- start debug log
578: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
579: fnd_log.STRING (fnd_log.level_procedure,
580: g_module ||
581: l_api_name,
582: '100: Entered ' ||
583: g_pkg_name ||

Line 598: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

594:
595: CLOSE l_olddates_csr;
596:
597: -- end debug log
598: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
599: fnd_log.STRING (fnd_log.level_procedure,
600: g_module ||
601: l_api_name,
602: '1000: Leaving ' ||

Line 599: fnd_log.STRING (fnd_log.level_procedure,

595: CLOSE l_olddates_csr;
596:
597: -- end debug log
598: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
599: fnd_log.STRING (fnd_log.level_procedure,
600: g_module ||
601: l_api_name,
602: '1000: Leaving ' ||
603: g_pkg_name ||

Line 626: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

622: l_msg_count NUMBER;
623: l_msg_data VARCHAR2 (2000);
624: BEGIN
625: -- start debug log
626: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
627: fnd_log.STRING (fnd_log.level_procedure,
628: g_module ||
629: l_api_name,
630: '100: Entered ' ||

Line 627: fnd_log.STRING (fnd_log.level_procedure,

623: l_msg_data VARCHAR2 (2000);
624: BEGIN
625: -- start debug log
626: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
627: fnd_log.STRING (fnd_log.level_procedure,
628: g_module ||
629: l_api_name,
630: '100: Entered ' ||
631: g_pkg_name ||

Line 655: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

651:
652: x_return_status := l_return_status;
653:
654: -- end debug log
655: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
656: fnd_log.STRING (fnd_log.level_procedure,
657: g_module ||
658: l_api_name,
659: '1000: Leaving ' ||

Line 656: fnd_log.STRING (fnd_log.level_procedure,

652: x_return_status := l_return_status;
653:
654: -- end debug log
655: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
656: fnd_log.STRING (fnd_log.level_procedure,
657: g_module ||
658: l_api_name,
659: '1000: Leaving ' ||
660: g_pkg_name ||

Line 668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

664: END IF;
665: EXCEPTION
666: WHEN g_error THEN
667: -- end debug log
668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
669: fnd_log.STRING (fnd_log.level_procedure,
670: g_module ||
671: l_api_name,
672: '2500: Leaving ' ||

Line 669: fnd_log.STRING (fnd_log.level_procedure,

665: EXCEPTION
666: WHEN g_error THEN
667: -- end debug log
668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
669: fnd_log.STRING (fnd_log.level_procedure,
670: g_module ||
671: l_api_name,
672: '2500: Leaving ' ||
673: g_pkg_name ||

Line 682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

678:
679: x_return_status := l_return_status;
680: WHEN OTHERS THEN
681: -- end debug log
682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
683: fnd_log.STRING (fnd_log.level_procedure,
684: g_module ||
685: l_api_name,
686: '4000: Leaving ' ||

Line 683: fnd_log.STRING (fnd_log.level_procedure,

679: x_return_status := l_return_status;
680: WHEN OTHERS THEN
681: -- end debug log
682: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
683: fnd_log.STRING (fnd_log.level_procedure,
684: g_module ||
685: l_api_name,
686: '4000: Leaving ' ||
687: g_pkg_name ||

Line 720: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

716: l_msg_count NUMBER;
717: l_msg_data VARCHAR2 (2000);
718: BEGIN
719: -- start debug log
720: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
721: fnd_log.STRING (fnd_log.level_procedure,
722: g_module ||
723: l_api_name,
724: '100: Entered ' ||

Line 721: fnd_log.STRING (fnd_log.level_procedure,

717: l_msg_data VARCHAR2 (2000);
718: BEGIN
719: -- start debug log
720: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
721: fnd_log.STRING (fnd_log.level_procedure,
722: g_module ||
723: l_api_name,
724: '100: Entered ' ||
725: g_pkg_name ||

Line 748: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

744:
745: x_return_status := l_return_status;
746:
747: -- end debug log
748: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
749: fnd_log.STRING (fnd_log.level_procedure,
750: g_module ||
751: l_api_name,
752: '1000: Leaving ' ||

Line 749: fnd_log.STRING (fnd_log.level_procedure,

745: x_return_status := l_return_status;
746:
747: -- end debug log
748: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
749: fnd_log.STRING (fnd_log.level_procedure,
750: g_module ||
751: l_api_name,
752: '1000: Leaving ' ||
753: g_pkg_name ||

Line 761: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

757: END IF;
758: EXCEPTION
759: WHEN g_error THEN
760: -- end debug log
761: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
762: fnd_log.STRING (fnd_log.level_procedure,
763: g_module ||
764: l_api_name,
765: '2500: Leaving ' ||

Line 762: fnd_log.STRING (fnd_log.level_procedure,

758: EXCEPTION
759: WHEN g_error THEN
760: -- end debug log
761: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
762: fnd_log.STRING (fnd_log.level_procedure,
763: g_module ||
764: l_api_name,
765: '2500: Leaving ' ||
766: g_pkg_name ||

Line 775: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

771:
772: x_return_status := l_return_status;
773: WHEN OTHERS THEN
774: -- end debug log
775: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
776: fnd_log.STRING (fnd_log.level_procedure,
777: g_module ||
778: l_api_name,
779: '4000: Leaving ' ||

Line 776: fnd_log.STRING (fnd_log.level_procedure,

772: x_return_status := l_return_status;
773: WHEN OTHERS THEN
774: -- end debug log
775: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
776: fnd_log.STRING (fnd_log.level_procedure,
777: g_module ||
778: l_api_name,
779: '4000: Leaving ' ||
780: g_pkg_name ||

Line 868: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

864: l_tot_topline_tax NUMBER;
865:
866: BEGIN
867: -- start debug log
868: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
869: fnd_log.STRING (fnd_log.level_procedure,
870: g_module ||
871: l_api_name,
872: '100: Entered ' ||

Line 869: fnd_log.STRING (fnd_log.level_procedure,

865:
866: BEGIN
867: -- start debug log
868: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
869: fnd_log.STRING (fnd_log.level_procedure,
870: g_module ||
871: l_api_name,
872: '100: Entered ' ||
873: g_pkg_name ||

Line 898: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

894: --Update Line With the Amounts from Pricing Engine(Price Negotiated and Unit Price)
895: l_clev_rec.ID := l_line_id;
896: l_clev_rec.price_negotiated := l_tot_subline_amt;
897:
898: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
899: fnd_log.STRING (fnd_log.level_statement,
900: g_module ||
901: l_api_name,
902: '106:In Update Amounts: TopLine Id: ' ||

Line 899: fnd_log.STRING (fnd_log.level_statement,

895: l_clev_rec.ID := l_line_id;
896: l_clev_rec.price_negotiated := l_tot_subline_amt;
897:
898: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
899: fnd_log.STRING (fnd_log.level_statement,
900: g_module ||
901: l_api_name,
902: '106:In Update Amounts: TopLine Id: ' ||
903: l_line_id

Line 905: fnd_log.STRING (fnd_log.level_statement,

901: l_api_name,
902: '106:In Update Amounts: TopLine Id: ' ||
903: l_line_id
904: );
905: fnd_log.STRING (fnd_log.level_statement,
906: g_module ||
907: l_api_name,
908: '107:In Update Amounts: Total Of Subline Amount: ' ||
909: l_tot_subline_amt

Line 918: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

914: --errorout_urp('In Update Amounts: Total Of Subline Amount: ' || l_tot_subline_amt);
915: update_line (p_clev_rec => l_clev_rec,
916: x_return_status => l_return_status);
917:
918: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
919: fnd_log.STRING
920: (fnd_log.level_statement,
921: g_module ||
922: l_api_name,

Line 919: fnd_log.STRING

915: update_line (p_clev_rec => l_clev_rec,
916: x_return_status => l_return_status);
917:
918: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
919: fnd_log.STRING
920: (fnd_log.level_statement,
921: g_module ||
922: l_api_name,
923: '108:In Update Amounts After Update Line: Status: ' ||

Line 920: (fnd_log.level_statement,

916: x_return_status => l_return_status);
917:
918: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
919: fnd_log.STRING
920: (fnd_log.level_statement,
921: g_module ||
922: l_api_name,
923: '108:In Update Amounts After Update Line: Status: ' ||
924: l_return_status

Line 969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

965: --errorout_urp('Header Amount: ' || l_chrv_rec.estimated_amount);
966: update_header (p_chrv_rec => l_chrv_rec,
967: x_return_status => l_return_status);
968:
969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970: fnd_log.STRING
971: (fnd_log.level_statement,
972: g_module ||
973: l_api_name,

Line 970: fnd_log.STRING

966: update_header (p_chrv_rec => l_chrv_rec,
967: x_return_status => l_return_status);
968:
969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970: fnd_log.STRING
971: (fnd_log.level_statement,
972: g_module ||
973: l_api_name,
974: '109:In Update Amounts After Update Header: Status: ' ||

Line 971: (fnd_log.level_statement,

967: x_return_status => l_return_status);
968:
969: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
970: fnd_log.STRING
971: (fnd_log.level_statement,
972: g_module ||
973: l_api_name,
974: '109:In Update Amounts After Update Header: Status: ' ||
975: l_return_status

Line 1001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

997: */
998:
999:
1000: -- end debug log
1001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1002: fnd_log.STRING (fnd_log.level_procedure,
1003: g_module ||
1004: l_api_name,
1005: '1000: Leaving ' ||

Line 1002: fnd_log.STRING (fnd_log.level_procedure,

998:
999:
1000: -- end debug log
1001: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1002: fnd_log.STRING (fnd_log.level_procedure,
1003: g_module ||
1004: l_api_name,
1005: '1000: Leaving ' ||
1006: g_pkg_name ||

Line 1014: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1010: END IF;
1011: EXCEPTION
1012: WHEN g_error THEN
1013: -- end debug log
1014: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1015: fnd_log.STRING (fnd_log.level_procedure,
1016: g_module ||
1017: l_api_name,
1018: '2500: Leaving ' ||

Line 1015: fnd_log.STRING (fnd_log.level_procedure,

1011: EXCEPTION
1012: WHEN g_error THEN
1013: -- end debug log
1014: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1015: fnd_log.STRING (fnd_log.level_procedure,
1016: g_module ||
1017: l_api_name,
1018: '2500: Leaving ' ||
1019: g_pkg_name ||

Line 1028: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1024:
1025: x_return_status := l_return_status;
1026: WHEN OTHERS THEN
1027: -- end debug log
1028: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1029: fnd_log.STRING (fnd_log.level_procedure,
1030: g_module ||
1031: l_api_name,
1032: '4000: Leaving ' ||

Line 1029: fnd_log.STRING (fnd_log.level_procedure,

1025: x_return_status := l_return_status;
1026: WHEN OTHERS THEN
1027: -- end debug log
1028: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1029: fnd_log.STRING (fnd_log.level_procedure,
1030: g_module ||
1031: l_api_name,
1032: '4000: Leaving ' ||
1033: g_pkg_name ||

Line 1070: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1066: l_msg_count NUMBER;
1067: l_msg_data VARCHAR2 (2000);
1068: BEGIN
1069: -- start debug log
1070: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.STRING (fnd_log.level_procedure,
1072: g_module ||
1073: l_api_name,
1074: '100: Entered ' ||

Line 1071: fnd_log.STRING (fnd_log.level_procedure,

1067: l_msg_data VARCHAR2 (2000);
1068: BEGIN
1069: -- start debug log
1070: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1071: fnd_log.STRING (fnd_log.level_procedure,
1072: g_module ||
1073: l_api_name,
1074: '100: Entered ' ||
1075: g_pkg_name ||

Line 1097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1093: x_return_status => l_return_status
1094: );
1095:
1096: IF l_return_status <> g_ret_sts_success THEN
1097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1098: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1099: '105: Call to oks_tax_util_pvt.get_tax FAILED, l_return_status: ' ||l_return_status
1100: );
1101: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

Line 1098: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

1094: );
1095:
1096: IF l_return_status <> g_ret_sts_success THEN
1097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1098: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1099: '105: Call to oks_tax_util_pvt.get_tax FAILED, l_return_status: ' ||l_return_status
1100: );
1101: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1102: '105: l_msg_data '||l_msg_data

Line 1101: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,

1097: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1098: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1099: '105: Call to oks_tax_util_pvt.get_tax FAILED, l_return_status: ' ||l_return_status
1100: );
1101: fnd_log.STRING (fnd_log.level_statement, g_module ||l_api_name,
1102: '105: l_msg_data '||l_msg_data
1103: );
1104: END IF;
1105: -- bug 5001677 even if tax api has error, proceed with renewal

Line 1117: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1113:
1114: l_tax_value := l_rail_rec.tax_value;
1115: l_tax_flag := l_rail_rec.amount_includes_tax_flag;
1116:
1117: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1118: fnd_log.STRING (fnd_log.level_statement,
1119: g_module ||
1120: l_api_name,
1121: '110:Inside Calculate Tax: l_tax_value: ' ||

Line 1118: fnd_log.STRING (fnd_log.level_statement,

1114: l_tax_value := l_rail_rec.tax_value;
1115: l_tax_flag := l_rail_rec.amount_includes_tax_flag;
1116:
1117: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1118: fnd_log.STRING (fnd_log.level_statement,
1119: g_module ||
1120: l_api_name,
1121: '110:Inside Calculate Tax: l_tax_value: ' ||
1122: l_tax_value

Line 1124: fnd_log.STRING (fnd_log.level_statement,

1120: l_api_name,
1121: '110:Inside Calculate Tax: l_tax_value: ' ||
1122: l_tax_value
1123: );
1124: fnd_log.STRING (fnd_log.level_statement,
1125: g_module ||
1126: l_api_name,
1127: '111:Inside Calculate Tax: l_tax_flag: ' ||
1128: l_tax_flag

Line 1166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1162: x_klnv_rec => l_kln_rec_out,
1163: p_validate_yn => 'N'
1164: );
1165:
1166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1167: fnd_log.STRING (fnd_log.level_statement,
1168: g_module ||
1169: l_api_name,
1170: '112:Status AFter update rule in calculate_tax: ' ||

Line 1167: fnd_log.STRING (fnd_log.level_statement,

1163: p_validate_yn => 'N'
1164: );
1165:
1166: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1167: fnd_log.STRING (fnd_log.level_statement,
1168: g_module ||
1169: l_api_name,
1170: '112:Status AFter update rule in calculate_tax: ' ||
1171: l_return_status

Line 1178: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1174:
1175: --errorout_urp('Status AFter update rule in calculate_tax: ' || l_return_status);
1176: -- IF x_return_status <> g_ret_sts_success THEN
1177: IF l_return_status <> g_ret_sts_success THEN -- bug 5138920
1178: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1179: fnd_log.STRING (fnd_log.level_statement,
1180: g_module ||
1181: l_api_name,
1182: '113:Update line details at Calc Tax'

Line 1179: fnd_log.STRING (fnd_log.level_statement,

1175: --errorout_urp('Status AFter update rule in calculate_tax: ' || l_return_status);
1176: -- IF x_return_status <> g_ret_sts_success THEN
1177: IF l_return_status <> g_ret_sts_success THEN -- bug 5138920
1178: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1179: fnd_log.STRING (fnd_log.level_statement,
1180: g_module ||
1181: l_api_name,
1182: '113:Update line details at Calc Tax'
1183: );

Line 1193: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1189:
1190: x_return_status := l_return_status;
1191:
1192: -- end debug log
1193: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1194: fnd_log.STRING (fnd_log.level_procedure,
1195: g_module ||
1196: l_api_name,
1197: '1000: Leaving ' ||

Line 1194: fnd_log.STRING (fnd_log.level_procedure,

1190: x_return_status := l_return_status;
1191:
1192: -- end debug log
1193: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1194: fnd_log.STRING (fnd_log.level_procedure,
1195: g_module ||
1196: l_api_name,
1197: '1000: Leaving ' ||
1198: g_pkg_name ||

Line 1206: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1202: END IF;
1203: EXCEPTION
1204: WHEN g_error THEN
1205: -- end debug log
1206: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1207: fnd_log.STRING (fnd_log.level_procedure,
1208: g_module ||
1209: l_api_name,
1210: '2500: Leaving ' ||

Line 1207: fnd_log.STRING (fnd_log.level_procedure,

1203: EXCEPTION
1204: WHEN g_error THEN
1205: -- end debug log
1206: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1207: fnd_log.STRING (fnd_log.level_procedure,
1208: g_module ||
1209: l_api_name,
1210: '2500: Leaving ' ||
1211: g_pkg_name ||

Line 1220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1216:
1217: x_return_status := l_return_status;
1218: WHEN OTHERS THEN
1219: -- end debug log
1220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1221: fnd_log.STRING (fnd_log.level_procedure,
1222: g_module ||
1223: l_api_name,
1224: '4000: Leaving ' ||

Line 1221: fnd_log.STRING (fnd_log.level_procedure,

1217: x_return_status := l_return_status;
1218: WHEN OTHERS THEN
1219: -- end debug log
1220: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1221: fnd_log.STRING (fnd_log.level_procedure,
1222: g_module ||
1223: l_api_name,
1224: '4000: Leaving ' ||
1225: g_pkg_name ||

Line 1260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1256: l_msg_count NUMBER;
1257: l_msg_data VARCHAR2 (2000);
1258: BEGIN
1259: -- start debug log
1260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1261: fnd_log.STRING (fnd_log.level_procedure,
1262: g_module ||
1263: l_api_name,
1264: '100: Entered ' ||

Line 1261: fnd_log.STRING (fnd_log.level_procedure,

1257: l_msg_data VARCHAR2 (2000);
1258: BEGIN
1259: -- start debug log
1260: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1261: fnd_log.STRING (fnd_log.level_procedure,
1262: g_module ||
1263: l_api_name,
1264: '100: Entered ' ||
1265: g_pkg_name ||

Line 1357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1353:
1354: x_return_status := l_return_status;
1355:
1356: -- end debug log
1357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1358: fnd_log.STRING (fnd_log.level_procedure,
1359: g_module ||
1360: l_api_name,
1361: '1000: Leaving ' ||

Line 1358: fnd_log.STRING (fnd_log.level_procedure,

1354: x_return_status := l_return_status;
1355:
1356: -- end debug log
1357: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1358: fnd_log.STRING (fnd_log.level_procedure,
1359: g_module ||
1360: l_api_name,
1361: '1000: Leaving ' ||
1362: g_pkg_name ||

Line 1370: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1366: END IF;
1367: EXCEPTION
1368: WHEN g_error THEN
1369: -- end debug log
1370: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1371: fnd_log.STRING (fnd_log.level_procedure,
1372: g_module ||
1373: l_api_name,
1374: '2500: Leaving ' ||

Line 1371: fnd_log.STRING (fnd_log.level_procedure,

1367: EXCEPTION
1368: WHEN g_error THEN
1369: -- end debug log
1370: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1371: fnd_log.STRING (fnd_log.level_procedure,
1372: g_module ||
1373: l_api_name,
1374: '2500: Leaving ' ||
1375: g_pkg_name ||

Line 1384: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1380:
1381: x_return_status := l_return_status;
1382: WHEN OTHERS THEN
1383: -- end debug log
1384: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1385: fnd_log.STRING (fnd_log.level_procedure,
1386: g_module ||
1387: l_api_name,
1388: '4000: Leaving ' ||

Line 1385: fnd_log.STRING (fnd_log.level_procedure,

1381: x_return_status := l_return_status;
1382: WHEN OTHERS THEN
1383: -- end debug log
1384: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1385: fnd_log.STRING (fnd_log.level_procedure,
1386: g_module ||
1387: l_api_name,
1388: '4000: Leaving ' ||
1389: g_pkg_name ||

Line 1457: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1453: l_msg_count NUMBER;
1454: l_msg_data VARCHAR2 (2000);
1455: BEGIN
1456: -- start debug log
1457: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1458: fnd_log.STRING (fnd_log.level_procedure,
1459: g_module ||
1460: l_api_name,
1461: '100: Entered ' ||

Line 1458: fnd_log.STRING (fnd_log.level_procedure,

1454: l_msg_data VARCHAR2 (2000);
1455: BEGIN
1456: -- start debug log
1457: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1458: fnd_log.STRING (fnd_log.level_procedure,
1459: g_module ||
1460: l_api_name,
1461: '100: Entered ' ||
1462: g_pkg_name ||

Line 1479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1475:
1476: l_detail_rec.intent := p_intent;
1477: l_detail_rec.price_list := p_price_list;
1478:
1479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1480: fnd_log.STRING (fnd_log.level_statement,
1481: g_module ||
1482: l_api_name,
1483: '114:l_detail_rec.line_id: ' ||

Line 1480: fnd_log.STRING (fnd_log.level_statement,

1476: l_detail_rec.intent := p_intent;
1477: l_detail_rec.price_list := p_price_list;
1478:
1479: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1480: fnd_log.STRING (fnd_log.level_statement,
1481: g_module ||
1482: l_api_name,
1483: '114:l_detail_rec.line_id: ' ||
1484: l_detail_rec.line_id

Line 1486: fnd_log.STRING (fnd_log.level_statement,

1482: l_api_name,
1483: '114:l_detail_rec.line_id: ' ||
1484: l_detail_rec.line_id
1485: );
1486: fnd_log.STRING (fnd_log.level_statement,
1487: g_module ||
1488: l_api_name,
1489: '115:l_detail_rec.subline_id: ' ||
1490: l_detail_rec.subline_id

Line 1492: fnd_log.STRING (fnd_log.level_statement,

1488: l_api_name,
1489: '115:l_detail_rec.subline_id: ' ||
1490: l_detail_rec.subline_id
1491: );
1492: fnd_log.STRING (fnd_log.level_statement,
1493: g_module ||
1494: l_api_name,
1495: '116:l_detail_rec.intent: ' ||
1496: l_detail_rec.intent

Line 1498: fnd_log.STRING (fnd_log.level_statement,

1494: l_api_name,
1495: '116:l_detail_rec.intent: ' ||
1496: l_detail_rec.intent
1497: );
1498: fnd_log.STRING (fnd_log.level_statement,
1499: g_module ||
1500: l_api_name,
1501: '117:l_detail_rec.price_list: ' ||
1502: l_detail_rec.price_list

Line 1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1515: x_msg_count => l_msg_count,
1516: x_msg_data => l_msg_data
1517: );
1518:
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1520: fnd_log.STRING
1521: (fnd_log.level_statement,
1522: g_module ||
1523: l_api_name,

Line 1520: fnd_log.STRING

1516: x_msg_data => l_msg_data
1517: );
1518:
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1520: fnd_log.STRING
1521: (fnd_log.level_statement,
1522: g_module ||
1523: l_api_name,
1524: '118:In Calculate Price Status after OKS_QP_PKG.calc_price: ' ||

Line 1521: (fnd_log.level_statement,

1517: );
1518:
1519: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1520: fnd_log.STRING
1521: (fnd_log.level_statement,
1522: g_module ||
1523: l_api_name,
1524: '118:In Calculate Price Status after OKS_QP_PKG.calc_price: ' ||
1525: l_return_status

Line 1534: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1530: IF l_return_status <> g_ret_sts_success THEN
1531: RAISE g_error;
1532: END IF;
1533:
1534: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1535: fnd_log.STRING (fnd_log.level_statement,
1536: g_module ||
1537: l_api_name,
1538: '119:Markup/down amount: ' ||

Line 1535: fnd_log.STRING (fnd_log.level_statement,

1531: RAISE g_error;
1532: END IF;
1533:
1534: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1535: fnd_log.STRING (fnd_log.level_statement,
1536: g_module ||
1537: l_api_name,
1538: '119:Markup/down amount: ' ||
1539: p_amount

Line 1541: fnd_log.STRING (fnd_log.level_statement,

1537: l_api_name,
1538: '119:Markup/down amount: ' ||
1539: p_amount
1540: );
1541: fnd_log.STRING (fnd_log.level_statement,
1542: g_module ||
1543: l_api_name,
1544: '120:l_price_details.serv_ext_amount: ' ||
1545: l_price_details.serv_ext_amount

Line 1547: fnd_log.STRING (fnd_log.level_statement,

1543: l_api_name,
1544: '120:l_price_details.serv_ext_amount: ' ||
1545: l_price_details.serv_ext_amount
1546: );
1547: fnd_log.STRING (fnd_log.level_statement,
1548: g_module ||
1549: l_api_name,
1550: '120:l_price_details.prod_ext_amount: ' ||
1551: l_price_details.serv_ext_amount

Line 1553: fnd_log.STRING (fnd_log.level_statement,

1549: l_api_name,
1550: '120:l_price_details.prod_ext_amount: ' ||
1551: l_price_details.serv_ext_amount
1552: );
1553: fnd_log.STRING (fnd_log.level_statement,
1554: g_module ||
1555: l_api_name,
1556: '121:l_price_details.status_text: ' ||
1557: l_price_details.status_text

Line 1595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1591: l_price_details.status_text :=
1592: l_price_details.status_text ||
1593: ' Price derived using price index';
1594:
1595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1596: fnd_log.STRING (fnd_log.level_statement,
1597: g_module ||
1598: l_api_name,
1599: '122:In Calulate Price : l_price_type: ' ||

Line 1596: fnd_log.STRING (fnd_log.level_statement,

1592: l_price_details.status_text ||
1593: ' Price derived using price index';
1594:
1595: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1596: fnd_log.STRING (fnd_log.level_statement,
1597: g_module ||
1598: l_api_name,
1599: '122:In Calulate Price : l_price_type: ' ||
1600: l_price_type

Line 1602: fnd_log.STRING (fnd_log.level_statement,

1598: l_api_name,
1599: '122:In Calulate Price : l_price_type: ' ||
1600: l_price_type
1601: );
1602: fnd_log.STRING (fnd_log.level_statement,
1603: g_module ||
1604: l_api_name,
1605: '123:Amount Goes to OKC_K_LINES_B: ' ||
1606: l_new_amount

Line 1628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1624: l_clev_rec.price_unit := l_price_details.serv_adj_unit_price;
1625: END IF;
1626: END IF; -- bug 5511211, p_lse_id = 46
1627:
1628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.STRING
1630: (fnd_log.level_statement,
1631: g_module ||
1632: l_api_name,

Line 1629: fnd_log.STRING

1625: END IF;
1626: END IF; -- bug 5511211, p_lse_id = 46
1627:
1628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.STRING
1630: (fnd_log.level_statement,
1631: g_module ||
1632: l_api_name,
1633: '124:Before update line in calculate_price: l_clev_rec.id: ' ||

Line 1630: (fnd_log.level_statement,

1626: END IF; -- bug 5511211, p_lse_id = 46
1627:
1628: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1629: fnd_log.STRING
1630: (fnd_log.level_statement,
1631: g_module ||
1632: l_api_name,
1633: '124:Before update line in calculate_price: l_clev_rec.id: ' ||
1634: l_clev_rec.ID

Line 1636: fnd_log.STRING

1632: l_api_name,
1633: '124:Before update line in calculate_price: l_clev_rec.id: ' ||
1634: l_clev_rec.ID
1635: );
1636: fnd_log.STRING
1637: (fnd_log.level_statement,
1638: g_module ||
1639: l_api_name,
1640: '125:Before update line in calculate_price: l_clev_rec.price_negotiated: ' ||

Line 1637: (fnd_log.level_statement,

1633: '124:Before update line in calculate_price: l_clev_rec.id: ' ||
1634: l_clev_rec.ID
1635: );
1636: fnd_log.STRING
1637: (fnd_log.level_statement,
1638: g_module ||
1639: l_api_name,
1640: '125:Before update line in calculate_price: l_clev_rec.price_negotiated: ' ||
1641: l_clev_rec.price_negotiated

Line 1643: fnd_log.STRING

1639: l_api_name,
1640: '125:Before update line in calculate_price: l_clev_rec.price_negotiated: ' ||
1641: l_clev_rec.price_negotiated
1642: );
1643: fnd_log.STRING
1644: (fnd_log.level_statement,
1645: g_module ||
1646: l_api_name,
1647: '126:Before update line in calculate_price: l_clev_rec.price_unit: ' ||

Line 1644: (fnd_log.level_statement,

1640: '125:Before update line in calculate_price: l_clev_rec.price_negotiated: ' ||
1641: l_clev_rec.price_negotiated
1642: );
1643: fnd_log.STRING
1644: (fnd_log.level_statement,
1645: g_module ||
1646: l_api_name,
1647: '126:Before update line in calculate_price: l_clev_rec.price_unit: ' ||
1648: l_clev_rec.price_unit

Line 1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1654: --errorout_urp('Before update line in calculate_price: l_clev_rec.price_unit: ' || l_clev_rec.price_unit);
1655: update_line (p_clev_rec => l_clev_rec,
1656: x_return_status => l_return_status);
1657:
1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1659: fnd_log.STRING (fnd_log.level_statement,
1660: g_module ||
1661: l_api_name,
1662: '127:Status after update line in calculate_price: ' ||

Line 1659: fnd_log.STRING (fnd_log.level_statement,

1655: update_line (p_clev_rec => l_clev_rec,
1656: x_return_status => l_return_status);
1657:
1658: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1659: fnd_log.STRING (fnd_log.level_statement,
1660: g_module ||
1661: l_api_name,
1662: '127:Status after update line in calculate_price: ' ||
1663: l_return_status

Line 1672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1668: IF l_return_status <> g_ret_sts_success THEN
1669: RAISE g_error;
1670: END IF;
1671:
1672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1673: fnd_log.STRING
1674: (fnd_log.level_statement,
1675: g_module ||
1676: l_api_name,

Line 1673: fnd_log.STRING

1669: RAISE g_error;
1670: END IF;
1671:
1672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1673: fnd_log.STRING
1674: (fnd_log.level_statement,
1675: g_module ||
1676: l_api_name,
1677: '128:In Calulate Price : l_price_details.status_text: ' ||

Line 1674: (fnd_log.level_statement,

1670: END IF;
1671:
1672: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1673: fnd_log.STRING
1674: (fnd_log.level_statement,
1675: g_module ||
1676: l_api_name,
1677: '128:In Calulate Price : l_price_details.status_text: ' ||
1678: l_price_details.status_text

Line 1691: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1687: p_price_details => l_price_details,
1688: x_return_status => l_return_status
1689: );
1690:
1691: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1692: fnd_log.STRING
1693: (fnd_log.level_statement,
1694: g_module ||
1695: l_api_name,

Line 1692: fnd_log.STRING

1688: x_return_status => l_return_status
1689: );
1690:
1691: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1692: fnd_log.STRING
1693: (fnd_log.level_statement,
1694: g_module ||
1695: l_api_name,
1696: '129:Status after Handle Pdl Rule in calculate_price: ' ||

Line 1693: (fnd_log.level_statement,

1689: );
1690:
1691: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1692: fnd_log.STRING
1693: (fnd_log.level_statement,
1694: g_module ||
1695: l_api_name,
1696: '129:Status after Handle Pdl Rule in calculate_price: ' ||
1697: l_return_status

Line 1737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

1733: p_amount => l_new_amount,
1734: x_return_status => l_return_status
1735: );
1736:
1737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1738: fnd_log.STRING
1739: (fnd_log.level_statement,
1740: g_module ||
1741: l_api_name,

Line 1738: fnd_log.STRING

1734: x_return_status => l_return_status
1735: );
1736:
1737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1738: fnd_log.STRING
1739: (fnd_log.level_statement,
1740: g_module ||
1741: l_api_name,
1742: '130:Status after calculate_tax in calculate_price: ' ||

Line 1739: (fnd_log.level_statement,

1735: );
1736:
1737: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1738: fnd_log.STRING
1739: (fnd_log.level_statement,
1740: g_module ||
1741: l_api_name,
1742: '130:Status after calculate_tax in calculate_price: ' ||
1743: l_return_status

Line 1755: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1751:
1752: x_return_status := l_return_status;
1753:
1754: -- end debug log
1755: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1756: fnd_log.STRING (fnd_log.level_procedure,
1757: g_module ||
1758: l_api_name,
1759: '1000: Leaving ' ||

Line 1756: fnd_log.STRING (fnd_log.level_procedure,

1752: x_return_status := l_return_status;
1753:
1754: -- end debug log
1755: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1756: fnd_log.STRING (fnd_log.level_procedure,
1757: g_module ||
1758: l_api_name,
1759: '1000: Leaving ' ||
1760: g_pkg_name ||

Line 1768: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1764: END IF;
1765: EXCEPTION
1766: WHEN g_error THEN
1767: -- end debug log
1768: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1769: fnd_log.STRING (fnd_log.level_procedure,
1770: g_module ||
1771: l_api_name,
1772: '2500: Leaving ' ||

Line 1769: fnd_log.STRING (fnd_log.level_procedure,

1765: EXCEPTION
1766: WHEN g_error THEN
1767: -- end debug log
1768: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1769: fnd_log.STRING (fnd_log.level_procedure,
1770: g_module ||
1771: l_api_name,
1772: '2500: Leaving ' ||
1773: g_pkg_name ||

Line 1782: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1778:
1779: x_return_status := l_return_status;
1780: WHEN OTHERS THEN
1781: -- end debug log
1782: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1783: fnd_log.STRING (fnd_log.level_procedure,
1784: g_module ||
1785: l_api_name,
1786: '4000: Leaving ' ||

Line 1783: fnd_log.STRING (fnd_log.level_procedure,

1779: x_return_status := l_return_status;
1780: WHEN OTHERS THEN
1781: -- end debug log
1782: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1783: fnd_log.STRING (fnd_log.level_procedure,
1784: g_module ||
1785: l_api_name,
1786: '4000: Leaving ' ||
1787: g_pkg_name ||

Line 1824: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1820: l_msg_count NUMBER;
1821: l_msg_data VARCHAR2 (2000);
1822: BEGIN
1823: -- start debug log
1824: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1825: fnd_log.STRING (fnd_log.level_procedure,
1826: g_module ||
1827: l_api_name,
1828: '100: Entered ' ||

Line 1825: fnd_log.STRING (fnd_log.level_procedure,

1821: l_msg_data VARCHAR2 (2000);
1822: BEGIN
1823: -- start debug log
1824: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1825: fnd_log.STRING (fnd_log.level_procedure,
1826: g_module ||
1827: l_api_name,
1828: '100: Entered ' ||
1829: g_pkg_name ||

Line 1872: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1868:
1869: x_return_status := l_return_status;
1870:
1871: -- end debug log
1872: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1873: fnd_log.STRING (fnd_log.level_procedure,
1874: g_module ||
1875: l_api_name,
1876: '1000: Leaving ' ||

Line 1873: fnd_log.STRING (fnd_log.level_procedure,

1869: x_return_status := l_return_status;
1870:
1871: -- end debug log
1872: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1873: fnd_log.STRING (fnd_log.level_procedure,
1874: g_module ||
1875: l_api_name,
1876: '1000: Leaving ' ||
1877: g_pkg_name ||

Line 1885: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1881: END IF;
1882: EXCEPTION
1883: WHEN g_error THEN
1884: -- end debug log
1885: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1886: fnd_log.STRING (fnd_log.level_procedure,
1887: g_module ||
1888: l_api_name,
1889: '2500: Leaving ' ||

Line 1886: fnd_log.STRING (fnd_log.level_procedure,

1882: EXCEPTION
1883: WHEN g_error THEN
1884: -- end debug log
1885: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1886: fnd_log.STRING (fnd_log.level_procedure,
1887: g_module ||
1888: l_api_name,
1889: '2500: Leaving ' ||
1890: g_pkg_name ||

Line 1899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

1895:
1896: x_return_status := l_return_status;
1897: WHEN OTHERS THEN
1898: -- end debug log
1899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1900: fnd_log.STRING (fnd_log.level_procedure,
1901: g_module ||
1902: l_api_name,
1903: '4000: Leaving ' ||

Line 1900: fnd_log.STRING (fnd_log.level_procedure,

1896: x_return_status := l_return_status;
1897: WHEN OTHERS THEN
1898: -- end debug log
1899: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1900: fnd_log.STRING (fnd_log.level_procedure,
1901: g_module ||
1902: l_api_name,
1903: '4000: Leaving ' ||
1904: g_pkg_name ||

Line 2078: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2074:
2075:
2076: BEGIN
2077: -- start debug log
2078: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2079: fnd_log.STRING (fnd_log.level_procedure,
2080: g_module ||
2081: l_api_name,
2082: '100: Entered ' ||

Line 2079: fnd_log.STRING (fnd_log.level_procedure,

2075:
2076: BEGIN
2077: -- start debug log
2078: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2079: fnd_log.STRING (fnd_log.level_procedure,
2080: g_module ||
2081: l_api_name,
2082: '100: Entered ' ||
2083: g_pkg_name ||

Line 2544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level

2540: l_price_details.serv_ext_amount := l_prorated_price_neg;
2541: l_price_details.status_text :=
2542: 'Price derived using manual pricing';
2543:
2544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
2545: ) THEN
2546: fnd_log.STRING (fnd_log.level_statement,
2547: g_module ||
2548: l_api_name,

Line 2546: fnd_log.STRING (fnd_log.level_statement,

2542: 'Price derived using manual pricing';
2543:
2544: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
2545: ) THEN
2546: fnd_log.STRING (fnd_log.level_statement,
2547: g_module ||
2548: l_api_name,
2549: '131:l_price_details.status_text: ' ||
2550: l_price_details.status_text

Line 2552: fnd_log.STRING (fnd_log.level_statement,

2548: l_api_name,
2549: '131:l_price_details.status_text: ' ||
2550: l_price_details.status_text
2551: );
2552: fnd_log.STRING (fnd_log.level_statement,
2553: g_module ||
2554: l_api_name,
2555: '132:l_price_details.serv_ext_amount: ' ||
2556: l_price_details.serv_ext_amount

Line 2722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level

2718: l_price_details.serv_ext_amount := l_prorated_price_neg;
2719: l_price_details.status_text :=
2720: 'Price derived using markup pricing';
2721:
2722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
2723: ) THEN
2724: fnd_log.STRING (fnd_log.level_statement,
2725: g_module ||
2726: l_api_name,

Line 2724: fnd_log.STRING (fnd_log.level_statement,

2720: 'Price derived using markup pricing';
2721:
2722: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level
2723: ) THEN
2724: fnd_log.STRING (fnd_log.level_statement,
2725: g_module ||
2726: l_api_name,
2727: '133:l_price_details.status_text: ' ||
2728: l_price_details.status_text

Line 2730: fnd_log.STRING (fnd_log.level_statement,

2726: l_api_name,
2727: '133:l_price_details.status_text: ' ||
2728: l_price_details.status_text
2729: );
2730: fnd_log.STRING (fnd_log.level_statement,
2731: g_module ||
2732: l_api_name,
2733: '134:l_price_details.serv_ext_amount: ' ||
2734: l_price_details.serv_ext_amount

Line 2820: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2816: END IF; -- Lse If check within price type <> 'MAN'
2817: END IF; -- Price Type
2818:
2819: -- end debug log
2820: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2821: fnd_log.STRING (fnd_log.level_procedure,
2822: g_module ||
2823: l_api_name,
2824: '1000: Leaving ' ||

Line 2821: fnd_log.STRING (fnd_log.level_procedure,

2817: END IF; -- Price Type
2818:
2819: -- end debug log
2820: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2821: fnd_log.STRING (fnd_log.level_procedure,
2822: g_module ||
2823: l_api_name,
2824: '1000: Leaving ' ||
2825: g_pkg_name ||

Line 2833: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2829: END IF;
2830: EXCEPTION
2831: WHEN g_skip_proration THEN
2832: -- end debug log
2833: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2834: fnd_log.STRING (fnd_log.level_procedure,
2835: g_module ||
2836: l_api_name,
2837: '9200: Leaving ' ||

Line 2834: fnd_log.STRING (fnd_log.level_procedure,

2830: EXCEPTION
2831: WHEN g_skip_proration THEN
2832: -- end debug log
2833: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2834: fnd_log.STRING (fnd_log.level_procedure,
2835: g_module ||
2836: l_api_name,
2837: '9200: Leaving ' ||
2838: g_pkg_name ||

Line 2870: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2866: p_perf_msg => 'Final Status: ' ||
2867: l_return_status);
2868:
2869: -- end debug log
2870: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2871: fnd_log.STRING (fnd_log.level_procedure,
2872: g_module ||
2873: l_api_name,
2874: '1000: Leaving ' ||

Line 2871: fnd_log.STRING (fnd_log.level_procedure,

2867: l_return_status);
2868:
2869: -- end debug log
2870: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2871: fnd_log.STRING (fnd_log.level_procedure,
2872: g_module ||
2873: l_api_name,
2874: '1000: Leaving ' ||
2875: g_pkg_name ||

Line 2883: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2879: END IF;
2880: EXCEPTION
2881: WHEN g_error THEN
2882: -- end debug log
2883: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2884: fnd_log.STRING (fnd_log.level_procedure,
2885: g_module ||
2886: l_api_name,
2887: '2500: Leaving ' ||

Line 2884: fnd_log.STRING (fnd_log.level_procedure,

2880: EXCEPTION
2881: WHEN g_error THEN
2882: -- end debug log
2883: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2884: fnd_log.STRING (fnd_log.level_procedure,
2885: g_module ||
2886: l_api_name,
2887: '2500: Leaving ' ||
2888: g_pkg_name ||

Line 2903: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

2899:
2900: x_return_status := l_return_status;
2901: WHEN OTHERS THEN
2902: -- end debug log
2903: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2904: fnd_log.STRING (fnd_log.level_procedure,
2905: g_module ||
2906: l_api_name,
2907: '4000: Leaving ' ||

Line 2904: fnd_log.STRING (fnd_log.level_procedure,

2900: x_return_status := l_return_status;
2901: WHEN OTHERS THEN
2902: -- end debug log
2903: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2904: fnd_log.STRING (fnd_log.level_procedure,
2905: g_module ||
2906: l_api_name,
2907: '4000: Leaving ' ||
2908: g_pkg_name ||

Line 3047: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3043: l_period_type_orig VARCHAR2 (30);
3044: l_period_start_orig VARCHAR2 (30);
3045: BEGIN
3046: -- start debug log
3047: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3048: fnd_log.STRING (fnd_log.level_procedure,
3049: g_module ||
3050: l_api_name,
3051: '100: Entered ' ||

Line 3048: fnd_log.STRING (fnd_log.level_procedure,

3044: l_period_start_orig VARCHAR2 (30);
3045: BEGIN
3046: -- start debug log
3047: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3048: fnd_log.STRING (fnd_log.level_procedure,
3049: g_module ||
3050: l_api_name,
3051: '100: Entered ' ||
3052: g_pkg_name ||

Line 3698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3694: END IF; -- Price Type Check End IF
3695:
3696:
3697: -- end debug log
3698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3699: fnd_log.STRING (fnd_log.level_procedure,
3700: g_module ||
3701: l_api_name,
3702: '1000: Leaving ' ||

Line 3699: fnd_log.STRING (fnd_log.level_procedure,

3695:
3696:
3697: -- end debug log
3698: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3699: fnd_log.STRING (fnd_log.level_procedure,
3700: g_module ||
3701: l_api_name,
3702: '1000: Leaving ' ||
3703: g_pkg_name ||

Line 3711: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level

3707: END IF;
3708: EXCEPTION
3709: WHEN g_skip_proration THEN
3710: -- end debug log
3711: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3712: ) THEN
3713: fnd_log.STRING (fnd_log.level_procedure,
3714: g_module ||
3715: l_api_name,

Line 3713: fnd_log.STRING (fnd_log.level_procedure,

3709: WHEN g_skip_proration THEN
3710: -- end debug log
3711: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3712: ) THEN
3713: fnd_log.STRING (fnd_log.level_procedure,
3714: g_module ||
3715: l_api_name,
3716: '9200: Leaving ' ||
3717: g_pkg_name ||

Line 3756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3752: fnd_file.put_line(FND_FILE.LOG,'********************************************************** ');
3753: fnd_file.put_line(FND_FILE.LOG,' ');
3754:
3755: -- end debug log
3756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3757: fnd_log.STRING (fnd_log.level_procedure,
3758: g_module ||
3759: l_api_name,
3760: '1000: Leaving ' ||

Line 3757: fnd_log.STRING (fnd_log.level_procedure,

3753: fnd_file.put_line(FND_FILE.LOG,' ');
3754:
3755: -- end debug log
3756: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3757: fnd_log.STRING (fnd_log.level_procedure,
3758: g_module ||
3759: l_api_name,
3760: '1000: Leaving ' ||
3761: g_pkg_name ||

Line 3769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3765: END IF;
3766: EXCEPTION
3767: WHEN g_error THEN
3768: -- end debug log
3769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3770: fnd_log.STRING (fnd_log.level_procedure,
3771: g_module ||
3772: l_api_name,
3773: '2500: Leaving ' ||

Line 3770: fnd_log.STRING (fnd_log.level_procedure,

3766: EXCEPTION
3767: WHEN g_error THEN
3768: -- end debug log
3769: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3770: fnd_log.STRING (fnd_log.level_procedure,
3771: g_module ||
3772: l_api_name,
3773: '2500: Leaving ' ||
3774: g_pkg_name ||

Line 3784: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

3780: DBMS_TRANSACTION.rollback_savepoint ('REPRICE_OKS');
3781: x_return_status := l_return_status;
3782: WHEN OTHERS THEN
3783: -- end debug log
3784: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3785: fnd_log.STRING (fnd_log.level_procedure,
3786: g_module ||
3787: l_api_name,
3788: '4000: Leaving ' ||

Line 3785: fnd_log.STRING (fnd_log.level_procedure,

3781: x_return_status := l_return_status;
3782: WHEN OTHERS THEN
3783: -- end debug log
3784: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3785: fnd_log.STRING (fnd_log.level_procedure,
3786: g_module ||
3787: l_api_name,
3788: '4000: Leaving ' ||
3789: g_pkg_name ||