APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on FND_LOG

Line 9: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;

5: ------------------------------------------------------------------------------
6: g_pkg_name CONSTANT VARCHAR2 (200)
7: := 'OKS_CUSTOMER_ACCEPTANCE_PVT';
8: g_app_name CONSTANT VARCHAR2 (3) := 'OKS';
9: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
10: g_module CONSTANT VARCHAR2 (250)
11: := 'oks.plsql.' ||
12: g_pkg_name ||
13: '.';

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

48: WHERE ch.ID = sh.chr_id
49: AND ch.ID = p_chr_id;
50: BEGIN
51: -- start debug log
52: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
53: fnd_log.STRING (fnd_log.level_procedure,
54: g_module ||
55: l_api_name,
56: '100: Entered ' ||

Line 53: fnd_log.STRING (fnd_log.level_procedure,

49: AND ch.ID = p_chr_id;
50: BEGIN
51: -- start debug log
52: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
53: fnd_log.STRING (fnd_log.level_procedure,
54: g_module ||
55: l_api_name,
56: '100: Entered ' ||
57: g_pkg_name ||

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

67:
68: CLOSE csr_k_amt;
69:
70: -- end debug log
71: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
72: fnd_log.STRING (fnd_log.level_procedure,
73: g_module ||
74: l_api_name,
75: '1000: Leaving ' ||

Line 72: fnd_log.STRING (fnd_log.level_procedure,

68: CLOSE csr_k_amt;
69:
70: -- end debug log
71: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
72: fnd_log.STRING (fnd_log.level_procedure,
73: g_module ||
74: l_api_name,
75: '1000: Leaving ' ||
76: g_pkg_name ||

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

81:
82: RETURN l_k_amount;
83: EXCEPTION
84: WHEN OTHERS THEN
85: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
86: fnd_log.STRING (fnd_log.level_procedure,
87: g_module ||
88: l_api_name,
89: '4000: Leaving ' ||

Line 86: fnd_log.STRING (fnd_log.level_procedure,

82: RETURN l_k_amount;
83: EXCEPTION
84: WHEN OTHERS THEN
85: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
86: fnd_log.STRING (fnd_log.level_procedure,
87: g_module ||
88: l_api_name,
89: '4000: Leaving ' ||
90: g_pkg_name ||

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

117: FROM okc_k_headers_all_b ch
118: WHERE ch.ID = p_chr_id;
119: BEGIN
120: -- start debug log
121: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
122: fnd_log.STRING (fnd_log.level_procedure,
123: g_module ||
124: l_api_name,
125: '100: Entered ' ||

Line 122: fnd_log.STRING (fnd_log.level_procedure,

118: WHERE ch.ID = p_chr_id;
119: BEGIN
120: -- start debug log
121: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
122: fnd_log.STRING (fnd_log.level_procedure,
123: g_module ||
124: l_api_name,
125: '100: Entered ' ||
126: g_pkg_name ||

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

136:
137: CLOSE csr_k_subtotal;
138:
139: -- end debug log
140: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
141: fnd_log.STRING (fnd_log.level_procedure,
142: g_module ||
143: l_api_name,
144: '1000: Leaving ' ||

Line 141: fnd_log.STRING (fnd_log.level_procedure,

137: CLOSE csr_k_subtotal;
138:
139: -- end debug log
140: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
141: fnd_log.STRING (fnd_log.level_procedure,
142: g_module ||
143: l_api_name,
144: '1000: Leaving ' ||
145: g_pkg_name ||

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

150:
151: RETURN l_k_subtotal;
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
155: fnd_log.STRING (fnd_log.level_procedure,
156: g_module ||
157: l_api_name,
158: '4000: Leaving ' ||

Line 155: fnd_log.STRING (fnd_log.level_procedure,

151: RETURN l_k_subtotal;
152: EXCEPTION
153: WHEN OTHERS THEN
154: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
155: fnd_log.STRING (fnd_log.level_procedure,
156: g_module ||
157: l_api_name,
158: '4000: Leaving ' ||
159: g_pkg_name ||

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

187: AND ch.ID = p_chr_id;
188:
189: BEGIN
190: -- start debug log
191: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
192: fnd_log.STRING (fnd_log.level_procedure,
193: g_module ||
194: l_api_name,
195: '100: Entered ' ||

Line 192: fnd_log.STRING (fnd_log.level_procedure,

188:
189: BEGIN
190: -- start debug log
191: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
192: fnd_log.STRING (fnd_log.level_procedure,
193: g_module ||
194: l_api_name,
195: '100: Entered ' ||
196: g_pkg_name ||

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

206:
207: CLOSE csr_k_tax;
208:
209: -- end debug log
210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
211: fnd_log.STRING (fnd_log.level_procedure,
212: g_module ||
213: l_api_name,
214: '1000: Leaving ' ||

Line 211: fnd_log.STRING (fnd_log.level_procedure,

207: CLOSE csr_k_tax;
208:
209: -- end debug log
210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
211: fnd_log.STRING (fnd_log.level_procedure,
212: g_module ||
213: l_api_name,
214: '1000: Leaving ' ||
215: g_pkg_name ||

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

220:
221: RETURN l_k_tax;
222: EXCEPTION
223: WHEN OTHERS THEN
224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
225: fnd_log.STRING (fnd_log.level_procedure,
226: g_module ||
227: l_api_name,
228: '4000: Leaving ' ||

Line 225: fnd_log.STRING (fnd_log.level_procedure,

221: RETURN l_k_tax;
222: EXCEPTION
223: WHEN OTHERS THEN
224: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
225: fnd_log.STRING (fnd_log.level_procedure,
226: g_module ||
227: l_api_name,
228: '4000: Leaving ' ||
229: g_pkg_name ||

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

290: 'c'
291: );
292: BEGIN
293: -- start debug log
294: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
295: fnd_log.STRING (fnd_log.level_procedure,
296: g_module ||
297: l_api_name,
298: '100: Entered ' ||

Line 295: fnd_log.STRING (fnd_log.level_procedure,

291: );
292: BEGIN
293: -- start debug log
294: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
295: fnd_log.STRING (fnd_log.level_procedure,
296: g_module ||
297: l_api_name,
298: '100: Entered ' ||
299: g_pkg_name ||

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

357:
358: l_contract_accept_clause := fnd_message.get;
359:
360: -- end debug log
361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
362: fnd_log.STRING (fnd_log.level_procedure,
363: g_module ||
364: l_api_name,
365: '1000: Leaving ' ||

Line 362: fnd_log.STRING (fnd_log.level_procedure,

358: l_contract_accept_clause := fnd_message.get;
359:
360: -- end debug log
361: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
362: fnd_log.STRING (fnd_log.level_procedure,
363: g_module ||
364: l_api_name,
365: '1000: Leaving ' ||
366: g_pkg_name ||

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

371:
372: RETURN l_contract_accept_clause;
373: EXCEPTION
374: WHEN OTHERS THEN
375: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
376: fnd_log.STRING (fnd_log.level_procedure,
377: g_module ||
378: l_api_name,
379: '4000: Leaving ' ||

Line 376: fnd_log.STRING (fnd_log.level_procedure,

372: RETURN l_contract_accept_clause;
373: EXCEPTION
374: WHEN OTHERS THEN
375: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
376: fnd_log.STRING (fnd_log.level_procedure,
377: g_module ||
378: l_api_name,
379: '4000: Leaving ' ||
380: g_pkg_name ||

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

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

Line 446: fnd_log.STRING (fnd_log.level_procedure,

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

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

508:
509: l_contract_decline_clause := fnd_message.get;
510:
511: -- end debug log
512: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
513: fnd_log.STRING (fnd_log.level_procedure,
514: g_module ||
515: l_api_name,
516: '1000: Leaving ' ||

Line 513: fnd_log.STRING (fnd_log.level_procedure,

509: l_contract_decline_clause := fnd_message.get;
510:
511: -- end debug log
512: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
513: fnd_log.STRING (fnd_log.level_procedure,
514: g_module ||
515: l_api_name,
516: '1000: Leaving ' ||
517: g_pkg_name ||

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

522:
523: RETURN l_contract_decline_clause;
524: EXCEPTION
525: WHEN OTHERS THEN
526: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
527: fnd_log.STRING (fnd_log.level_procedure,
528: g_module ||
529: l_api_name,
530: '4000: Leaving ' ||

Line 527: fnd_log.STRING (fnd_log.level_procedure,

523: RETURN l_contract_decline_clause;
524: EXCEPTION
525: WHEN OTHERS THEN
526: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
527: fnd_log.STRING (fnd_log.level_procedure,
528: g_module ||
529: l_api_name,
530: '4000: Leaving ' ||
531: g_pkg_name ||

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

556: AND r.cle_id IS NULL
557: AND r.chr_id = p_chr_id;
558: BEGIN
559: -- start debug log
560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
561: fnd_log.STRING (fnd_log.level_procedure,
562: g_module ||
563: l_api_name,
564: '100: Entered ' ||

Line 561: fnd_log.STRING (fnd_log.level_procedure,

557: AND r.chr_id = p_chr_id;
558: BEGIN
559: -- start debug log
560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
561: fnd_log.STRING (fnd_log.level_procedure,
562: g_module ||
563: l_api_name,
564: '100: Entered ' ||
565: g_pkg_name ||

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

575:
576: CLOSE csr_vendor_name;
577:
578: -- end debug log
579: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
580: fnd_log.STRING (fnd_log.level_procedure,
581: g_module ||
582: l_api_name,
583: '1000: Leaving ' ||

Line 580: fnd_log.STRING (fnd_log.level_procedure,

576: CLOSE csr_vendor_name;
577:
578: -- end debug log
579: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
580: fnd_log.STRING (fnd_log.level_procedure,
581: g_module ||
582: l_api_name,
583: '1000: Leaving ' ||
584: g_pkg_name ||

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

589:
590: RETURN l_vendor_name;
591: EXCEPTION
592: WHEN OTHERS THEN
593: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
594: fnd_log.STRING (fnd_log.level_procedure,
595: g_module ||
596: l_api_name,
597: '4000: Leaving ' ||

Line 594: fnd_log.STRING (fnd_log.level_procedure,

590: RETURN l_vendor_name;
591: EXCEPTION
592: WHEN OTHERS THEN
593: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
594: fnd_log.STRING (fnd_log.level_procedure,
595: g_module ||
596: l_api_name,
597: '4000: Leaving ' ||
598: g_pkg_name ||

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

625: AND r.dnz_chr_id = p_chr_id; /* changed chr_id to dnz_chr_id for
626: bug6439795 */
627: BEGIN
628: -- start debug log
629: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
630: fnd_log.STRING (fnd_log.level_procedure,
631: g_module ||
632: l_api_name,
633: '100: Entered ' ||

Line 630: fnd_log.STRING (fnd_log.level_procedure,

626: bug6439795 */
627: BEGIN
628: -- start debug log
629: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
630: fnd_log.STRING (fnd_log.level_procedure,
631: g_module ||
632: l_api_name,
633: '100: Entered ' ||
634: g_pkg_name ||

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

644:
645: CLOSE csr_customer_name;
646:
647: -- end debug log
648: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.STRING (fnd_log.level_procedure,
650: g_module ||
651: l_api_name,
652: '1000: Leaving ' ||

Line 649: fnd_log.STRING (fnd_log.level_procedure,

645: CLOSE csr_customer_name;
646:
647: -- end debug log
648: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
649: fnd_log.STRING (fnd_log.level_procedure,
650: g_module ||
651: l_api_name,
652: '1000: Leaving ' ||
653: g_pkg_name ||

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

658:
659: RETURN l_customer_name;
660: EXCEPTION
661: WHEN OTHERS THEN
662: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
663: fnd_log.STRING (fnd_log.level_procedure,
664: g_module ||
665: l_api_name,
666: '4000: Leaving ' ||

Line 663: fnd_log.STRING (fnd_log.level_procedure,

659: RETURN l_customer_name;
660: EXCEPTION
661: WHEN OTHERS THEN
662: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
663: fnd_log.STRING (fnd_log.level_procedure,
664: g_module ||
665: l_api_name,
666: '4000: Leaving ' ||
667: g_pkg_name ||

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

691: AND jtot_object1_code = 'OKX_PARTY'
692: AND rle_code = 'CUSTOMER';
693: BEGIN
694: -- start debug log
695: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
696: fnd_log.STRING (fnd_log.level_procedure,
697: g_module ||
698: l_api_name,
699: '100: Entered ' ||

Line 696: fnd_log.STRING (fnd_log.level_procedure,

692: AND rle_code = 'CUSTOMER';
693: BEGIN
694: -- start debug log
695: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
696: fnd_log.STRING (fnd_log.level_procedure,
697: g_module ||
698: l_api_name,
699: '100: Entered ' ||
700: g_pkg_name ||

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

710:
711: CLOSE csr_k_party;
712:
713: -- end debug log
714: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
715: fnd_log.STRING (fnd_log.level_procedure,
716: g_module ||
717: l_api_name,
718: '1000: Leaving ' ||

Line 715: fnd_log.STRING (fnd_log.level_procedure,

711: CLOSE csr_k_party;
712:
713: -- end debug log
714: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
715: fnd_log.STRING (fnd_log.level_procedure,
716: g_module ||
717: l_api_name,
718: '1000: Leaving ' ||
719: g_pkg_name ||

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

724:
725: RETURN l_party_id;
726: EXCEPTION
727: WHEN OTHERS THEN
728: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
729: fnd_log.STRING (fnd_log.level_procedure,
730: g_module ||
731: l_api_name,
732: '4000: Leaving ' ||

Line 729: fnd_log.STRING (fnd_log.level_procedure,

725: RETURN l_party_id;
726: EXCEPTION
727: WHEN OTHERS THEN
728: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
729: fnd_log.STRING (fnd_log.level_procedure,
730: g_module ||
731: l_api_name,
732: '4000: Leaving ' ||
733: g_pkg_name ||

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

754: FROM okc_k_headers_all_b
755: WHERE ID = p_chr_id;
756: BEGIN
757: -- start debug log
758: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
759: fnd_log.STRING (fnd_log.level_procedure,
760: g_module ||
761: l_api_name,
762: '100: Entered ' ||

Line 759: fnd_log.STRING (fnd_log.level_procedure,

755: WHERE ID = p_chr_id;
756: BEGIN
757: -- start debug log
758: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
759: fnd_log.STRING (fnd_log.level_procedure,
760: g_module ||
761: l_api_name,
762: '100: Entered ' ||
763: g_pkg_name ||

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

773:
774: CLOSE csr_k_organization;
775:
776: -- end debug log
777: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
778: fnd_log.STRING (fnd_log.level_procedure,
779: g_module ||
780: l_api_name,
781: '1000: Leaving ' ||

Line 778: fnd_log.STRING (fnd_log.level_procedure,

774: CLOSE csr_k_organization;
775:
776: -- end debug log
777: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
778: fnd_log.STRING (fnd_log.level_procedure,
779: g_module ||
780: l_api_name,
781: '1000: Leaving ' ||
782: g_pkg_name ||

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

787:
788: RETURN l_organization_id;
789: EXCEPTION
790: WHEN OTHERS THEN
791: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
792: fnd_log.STRING (fnd_log.level_procedure,
793: g_module ||
794: l_api_name,
795: '4000: Leaving ' ||

Line 792: fnd_log.STRING (fnd_log.level_procedure,

788: RETURN l_organization_id;
789: EXCEPTION
790: WHEN OTHERS THEN
791: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
792: fnd_log.STRING (fnd_log.level_procedure,
793: g_module ||
794: l_api_name,
795: '4000: Leaving ' ||
796: g_pkg_name ||

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

910: AND gcd.cdt_type = 'MDT';
911: */
912: BEGIN
913: -- start debug log
914: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
915: fnd_log.STRING (fnd_log.level_procedure,
916: g_module ||
917: l_api_name,
918: '100: Entered ' ||

Line 915: fnd_log.STRING (fnd_log.level_procedure,

911: */
912: BEGIN
913: -- start debug log
914: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
915: fnd_log.STRING (fnd_log.level_procedure,
916: g_module ||
917: l_api_name,
918: '100: Entered ' ||
919: g_pkg_name ||

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

974:
975: CLOSE csr_global_helpdesk;
976:
977: -- end debug log
978: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
979: fnd_log.STRING (fnd_log.level_procedure,
980: g_module ||
981: l_api_name,
982: '1000: Leaving ' ||

Line 979: fnd_log.STRING (fnd_log.level_procedure,

975: CLOSE csr_global_helpdesk;
976:
977: -- end debug log
978: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
979: fnd_log.STRING (fnd_log.level_procedure,
980: g_module ||
981: l_api_name,
982: '1000: Leaving ' ||
983: g_pkg_name ||

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

988:
989: RETURN l_salesrep_email;
990: EXCEPTION
991: WHEN OTHERS THEN
992: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
993: fnd_log.STRING (fnd_log.level_procedure,
994: g_module ||
995: l_api_name,
996: '4000: Leaving ' ||

Line 993: fnd_log.STRING (fnd_log.level_procedure,

989: RETURN l_salesrep_email;
990: EXCEPTION
991: WHEN OTHERS THEN
992: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
993: fnd_log.STRING (fnd_log.level_procedure,
994: g_module ||
995: l_api_name,
996: '4000: Leaving ' ||
997: g_pkg_name ||

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

1030:
1031: l_csr_cust_account_id_rec csr_cust_account_dtls%ROWTYPE;
1032: BEGIN
1033: -- start debug log
1034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1035: fnd_log.STRING (fnd_log.level_procedure,
1036: g_module ||
1037: l_api_name,
1038: '100: Entered ' ||

Line 1035: fnd_log.STRING (fnd_log.level_procedure,

1031: l_csr_cust_account_id_rec csr_cust_account_dtls%ROWTYPE;
1032: BEGIN
1033: -- start debug log
1034: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1035: fnd_log.STRING (fnd_log.level_procedure,
1036: g_module ||
1037: l_api_name,
1038: '100: Entered ' ||
1039: g_pkg_name ||

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

1055: l_cust_account_id :=
1056: l_csr_cust_account_id_rec.customer_account_id;
1057:
1058: -- end debug log
1059: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1060: fnd_log.STRING (fnd_log.level_procedure,
1061: g_module ||
1062: l_api_name,
1063: '1000: Leaving ' ||

Line 1060: fnd_log.STRING (fnd_log.level_procedure,

1056: l_csr_cust_account_id_rec.customer_account_id;
1057:
1058: -- end debug log
1059: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1060: fnd_log.STRING (fnd_log.level_procedure,
1061: g_module ||
1062: l_api_name,
1063: '1000: Leaving ' ||
1064: g_pkg_name ||

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

1069:
1070: RETURN l_cust_account_id;
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1074: fnd_log.STRING (fnd_log.level_procedure,
1075: g_module ||
1076: l_api_name,
1077: '4000: Leaving ' ||

Line 1074: fnd_log.STRING (fnd_log.level_procedure,

1070: RETURN l_cust_account_id;
1071: EXCEPTION
1072: WHEN OTHERS THEN
1073: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1074: fnd_log.STRING (fnd_log.level_procedure,
1075: g_module ||
1076: l_api_name,
1077: '4000: Leaving ' ||
1078: g_pkg_name ||

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

1105: FROM okc_k_headers_all_b kc
1106: WHERE kc.ID = p_chr_id;
1107: BEGIN
1108: -- start debug log
1109: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1110: fnd_log.STRING (fnd_log.level_procedure,
1111: g_module ||
1112: l_api_name,
1113: '100: Entered ' ||

Line 1110: fnd_log.STRING (fnd_log.level_procedure,

1106: WHERE kc.ID = p_chr_id;
1107: BEGIN
1108: -- start debug log
1109: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1110: fnd_log.STRING (fnd_log.level_procedure,
1111: g_module ||
1112: l_api_name,
1113: '100: Entered ' ||
1114: g_pkg_name ||

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

1130: fnd_message.set_token ('CONTRACT_NUM', l_contract_number);
1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1135: fnd_log.STRING (fnd_log.level_procedure,
1136: g_module ||
1137: l_api_name,
1138: '1000: Leaving ' ||

Line 1135: fnd_log.STRING (fnd_log.level_procedure,

1131: l_email_subject := fnd_message.get;
1132:
1133: -- end debug log
1134: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1135: fnd_log.STRING (fnd_log.level_procedure,
1136: g_module ||
1137: l_api_name,
1138: '1000: Leaving ' ||
1139: g_pkg_name ||

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

1144:
1145: RETURN l_email_subject;
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1149: fnd_log.STRING (fnd_log.level_procedure,
1150: g_module ||
1151: l_api_name,
1152: '4000: Leaving ' ||

Line 1149: fnd_log.STRING (fnd_log.level_procedure,

1145: RETURN l_email_subject;
1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1149: fnd_log.STRING (fnd_log.level_procedure,
1150: g_module ||
1151: l_api_name,
1152: '4000: Leaving ' ||
1153: g_pkg_name ||

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

1182: WHERE uom_code = p_code
1183: AND active_flag = 'Y';
1184: BEGIN
1185: -- start debug log
1186: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1187: fnd_log.STRING (fnd_log.level_procedure,
1188: g_module ||
1189: l_api_name,
1190: '100: Entered ' ||

Line 1187: fnd_log.STRING (fnd_log.level_procedure,

1183: AND active_flag = 'Y';
1184: BEGIN
1185: -- start debug log
1186: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1187: fnd_log.STRING (fnd_log.level_procedure,
1188: g_module ||
1189: l_api_name,
1190: '100: Entered ' ||
1191: g_pkg_name ||

Line 1195: fnd_log.STRING (fnd_log.level_procedure,

1191: g_pkg_name ||
1192: '.' ||
1193: l_api_name
1194: );
1195: fnd_log.STRING (fnd_log.level_procedure,
1196: g_module ||
1197: l_api_name,
1198: '100: Parameters : p_start_date : ' ||
1199: p_start_date

Line 1201: fnd_log.STRING (fnd_log.level_procedure,

1197: l_api_name,
1198: '100: Parameters : p_start_date : ' ||
1199: p_start_date
1200: );
1201: fnd_log.STRING (fnd_log.level_procedure,
1202: g_module ||
1203: l_api_name,
1204: '100: p_end_date : ' ||
1205: p_end_date

Line 1207: fnd_log.STRING (fnd_log.level_procedure,

1203: l_api_name,
1204: '100: p_end_date : ' ||
1205: p_end_date
1206: );
1207: fnd_log.STRING (fnd_log.level_procedure,
1208: g_module ||
1209: l_api_name,
1210: '100: Calling OKC_TIME_UTIL_PUB.get_duration'
1211: );

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

1218: x_return_status => l_return_status
1219: );
1220:
1221: -- debug log
1222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1223: fnd_log.STRING (fnd_log.level_procedure,
1224: g_module ||
1225: l_api_name,
1226: '150: After Calling OKC_TIME_UTIL_PUB.get_duration'

Line 1223: fnd_log.STRING (fnd_log.level_procedure,

1219: );
1220:
1221: -- debug log
1222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1223: fnd_log.STRING (fnd_log.level_procedure,
1224: g_module ||
1225: l_api_name,
1226: '150: After Calling OKC_TIME_UTIL_PUB.get_duration'
1227: );

Line 1228: fnd_log.STRING (fnd_log.level_procedure,

1224: g_module ||
1225: l_api_name,
1226: '150: After Calling OKC_TIME_UTIL_PUB.get_duration'
1227: );
1228: fnd_log.STRING (fnd_log.level_procedure,
1229: g_module ||
1230: l_api_name,
1231: '150: x_return_status : ' ||
1232: l_return_status

Line 1234: fnd_log.STRING (fnd_log.level_procedure,

1230: l_api_name,
1231: '150: x_return_status : ' ||
1232: l_return_status
1233: );
1234: fnd_log.STRING (fnd_log.level_procedure,
1235: g_module ||
1236: l_api_name,
1237: '150: x_duration : ' ||
1238: l_duration

Line 1240: fnd_log.STRING (fnd_log.level_procedure,

1236: l_api_name,
1237: '150: x_duration : ' ||
1238: l_duration
1239: );
1240: fnd_log.STRING (fnd_log.level_procedure,
1241: g_module ||
1242: l_api_name,
1243: '150: x_timeunit : ' ||
1244: l_timeunit

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

1252:
1253: CLOSE csr_timeunit_desc;
1254:
1255: -- debug log
1256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1257: fnd_log.STRING (fnd_log.level_procedure,
1258: g_module ||
1259: l_api_name,
1260: '200: l_timeunit_desc : ' ||

Line 1257: fnd_log.STRING (fnd_log.level_procedure,

1253: CLOSE csr_timeunit_desc;
1254:
1255: -- debug log
1256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1257: fnd_log.STRING (fnd_log.level_procedure,
1258: g_module ||
1259: l_api_name,
1260: '200: l_timeunit_desc : ' ||
1261: l_timeunit_desc

Line 1263: fnd_log.STRING (fnd_log.level_procedure,

1259: l_api_name,
1260: '200: l_timeunit_desc : ' ||
1261: l_timeunit_desc
1262: );
1263: fnd_log.STRING (fnd_log.level_procedure,
1264: g_module ||
1265: l_api_name,
1266: '1000: Leaving ' ||
1267: g_pkg_name ||

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

1275: l_timeunit_desc;
1276: RETURN l_duration_period;
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1280: fnd_log.STRING (fnd_log.level_procedure,
1281: g_module ||
1282: l_api_name,
1283: '4000: Leaving ' ||

Line 1280: fnd_log.STRING (fnd_log.level_procedure,

1276: RETURN l_duration_period;
1277: EXCEPTION
1278: WHEN OTHERS THEN
1279: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1280: fnd_log.STRING (fnd_log.level_procedure,
1281: g_module ||
1282: l_api_name,
1283: '4000: Leaving ' ||
1284: g_pkg_name ||

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

1309: FROM iby_trxn_extensions_v ibyt
1310: WHERE ibyt.trxn_extension_id = p_trxn_extension_id;
1311: BEGIN
1312: -- start debug log
1313: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1314: fnd_log.STRING (fnd_log.level_procedure,
1315: g_module ||
1316: l_api_name,
1317: '100: Entered ' ||

Line 1314: fnd_log.STRING (fnd_log.level_procedure,

1310: WHERE ibyt.trxn_extension_id = p_trxn_extension_id;
1311: BEGIN
1312: -- start debug log
1313: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1314: fnd_log.STRING (fnd_log.level_procedure,
1315: g_module ||
1316: l_api_name,
1317: '100: Entered ' ||
1318: g_pkg_name ||

Line 1322: fnd_log.STRING (fnd_log.level_procedure,

1318: g_pkg_name ||
1319: '.' ||
1320: l_api_name
1321: );
1322: fnd_log.STRING (fnd_log.level_procedure,
1323: g_module ||
1324: l_api_name,
1325: '100: Parameters : p_trxn_extension_id : ' ||
1326: p_trxn_extension_id

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

1334:
1335: CLOSE csr_cc_dtls;
1336:
1337: -- debug log
1338: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1339: fnd_log.STRING (fnd_log.level_procedure,
1340: g_module ||
1341: l_api_name,
1342: '200: l_cc_detail : ' ||

Line 1339: fnd_log.STRING (fnd_log.level_procedure,

1335: CLOSE csr_cc_dtls;
1336:
1337: -- debug log
1338: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1339: fnd_log.STRING (fnd_log.level_procedure,
1340: g_module ||
1341: l_api_name,
1342: '200: l_cc_detail : ' ||
1343: l_cc_detail

Line 1345: fnd_log.STRING (fnd_log.level_procedure,

1341: l_api_name,
1342: '200: l_cc_detail : ' ||
1343: l_cc_detail
1344: );
1345: fnd_log.STRING (fnd_log.level_procedure,
1346: g_module ||
1347: l_api_name,
1348: '1000: Leaving ' ||
1349: g_pkg_name ||

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

1354:
1355: RETURN l_cc_detail;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1359: fnd_log.STRING (fnd_log.level_procedure,
1360: g_module ||
1361: l_api_name,
1362: '4000: Leaving ' ||

Line 1359: fnd_log.STRING (fnd_log.level_procedure,

1355: RETURN l_cc_detail;
1356: EXCEPTION
1357: WHEN OTHERS THEN
1358: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1359: fnd_log.STRING (fnd_log.level_procedure,
1360: g_module ||
1361: l_api_name,
1362: '4000: Leaving ' ||
1363: g_pkg_name ||

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

1384: FROM iby_trxn_extensions_v ibyt
1385: WHERE ibyt.trxn_extension_id = p_trxn_extension_id;
1386: BEGIN
1387: -- start debug log
1388: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1389: fnd_log.STRING (fnd_log.level_procedure,
1390: g_module ||
1391: l_api_name,
1392: '100: Entered ' ||

Line 1389: fnd_log.STRING (fnd_log.level_procedure,

1385: WHERE ibyt.trxn_extension_id = p_trxn_extension_id;
1386: BEGIN
1387: -- start debug log
1388: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1389: fnd_log.STRING (fnd_log.level_procedure,
1390: g_module ||
1391: l_api_name,
1392: '100: Entered ' ||
1393: g_pkg_name ||

Line 1397: fnd_log.STRING (fnd_log.level_procedure,

1393: g_pkg_name ||
1394: '.' ||
1395: l_api_name
1396: );
1397: fnd_log.STRING (fnd_log.level_procedure,
1398: g_module ||
1399: l_api_name,
1400: '100: Parameters : p_trxn_extension_id : ' ||
1401: p_trxn_extension_id

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

1409:
1410: CLOSE csr_cc_dtls;
1411:
1412: -- debug log
1413: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1414: fnd_log.STRING (fnd_log.level_procedure,
1415: g_module ||
1416: l_api_name,
1417: '200: l_cc_cvv2 : ' ||

Line 1414: fnd_log.STRING (fnd_log.level_procedure,

1410: CLOSE csr_cc_dtls;
1411:
1412: -- debug log
1413: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1414: fnd_log.STRING (fnd_log.level_procedure,
1415: g_module ||
1416: l_api_name,
1417: '200: l_cc_cvv2 : ' ||
1418: l_cc_cvv2

Line 1420: fnd_log.STRING (fnd_log.level_procedure,

1416: l_api_name,
1417: '200: l_cc_cvv2 : ' ||
1418: l_cc_cvv2
1419: );
1420: fnd_log.STRING (fnd_log.level_procedure,
1421: g_module ||
1422: l_api_name,
1423: '1000: Leaving ' ||
1424: g_pkg_name ||

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

1429:
1430: RETURN l_cc_cvv2;
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1434: fnd_log.STRING (fnd_log.level_procedure,
1435: g_module ||
1436: l_api_name,
1437: '4000: Leaving ' ||

Line 1434: fnd_log.STRING (fnd_log.level_procedure,

1430: RETURN l_cc_cvv2;
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1434: fnd_log.STRING (fnd_log.level_procedure,
1435: g_module ||
1436: l_api_name,
1437: '4000: Leaving ' ||
1438: g_pkg_name ||

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

1464: AND f.LANGUAGE = USERENV ('LANG')
1465: AND k.ID = p_chr_id;
1466: BEGIN
1467: -- start debug log
1468: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1469: fnd_log.STRING (fnd_log.level_procedure,
1470: g_module ||
1471: l_api_name,
1472: '100: Entered ' ||

Line 1469: fnd_log.STRING (fnd_log.level_procedure,

1465: AND k.ID = p_chr_id;
1466: BEGIN
1467: -- start debug log
1468: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1469: fnd_log.STRING (fnd_log.level_procedure,
1470: g_module ||
1471: l_api_name,
1472: '100: Entered ' ||
1473: g_pkg_name ||

Line 1477: fnd_log.STRING (fnd_log.level_procedure,

1473: g_pkg_name ||
1474: '.' ||
1475: l_api_name
1476: );
1477: fnd_log.STRING (fnd_log.level_procedure,
1478: g_module ||
1479: l_api_name,
1480: '100: Parameters : p_chr_id : ' ||
1481: p_chr_id

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

1489:
1490: CLOSE csr_currency_tip;
1491:
1492: -- debug log
1493: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1494: fnd_log.STRING (fnd_log.level_procedure,
1495: g_module ||
1496: l_api_name,
1497: '200: l_currency_code_tip : ' ||

Line 1494: fnd_log.STRING (fnd_log.level_procedure,

1490: CLOSE csr_currency_tip;
1491:
1492: -- debug log
1493: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1494: fnd_log.STRING (fnd_log.level_procedure,
1495: g_module ||
1496: l_api_name,
1497: '200: l_currency_code_tip : ' ||
1498: l_currency_code_tip

Line 1500: fnd_log.STRING (fnd_log.level_procedure,

1496: l_api_name,
1497: '200: l_currency_code_tip : ' ||
1498: l_currency_code_tip
1499: );
1500: fnd_log.STRING (fnd_log.level_procedure,
1501: g_module ||
1502: l_api_name,
1503: '1000: Leaving ' ||
1504: g_pkg_name ||

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

1509:
1510: RETURN l_currency_code_tip;
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1514: fnd_log.STRING (fnd_log.level_procedure,
1515: g_module ||
1516: l_api_name,
1517: '4000: Leaving ' ||

Line 1514: fnd_log.STRING (fnd_log.level_procedure,

1510: RETURN l_currency_code_tip;
1511: EXCEPTION
1512: WHEN OTHERS THEN
1513: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1514: fnd_log.STRING (fnd_log.level_procedure,
1515: g_module ||
1516: l_api_name,
1517: '4000: Leaving ' ||
1518: g_pkg_name ||

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

1540: l_api_name CONSTANT VARCHAR2 (30)
1541: := 'decline_contract';
1542: BEGIN
1543: -- start debug log
1544: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1545: fnd_log.STRING (fnd_log.level_procedure,
1546: g_module ||
1547: l_api_name,
1548: '100: Entered ' ||

Line 1545: fnd_log.STRING (fnd_log.level_procedure,

1541: := 'decline_contract';
1542: BEGIN
1543: -- start debug log
1544: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1545: fnd_log.STRING (fnd_log.level_procedure,
1546: g_module ||
1547: l_api_name,
1548: '100: Entered ' ||
1549: g_pkg_name ||

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

1596: p_data => x_msg_data
1597: );
1598:
1599: -- end debug log
1600: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1601: fnd_log.STRING (fnd_log.level_procedure,
1602: g_module ||
1603: l_api_name,
1604: '1000: Leaving ' ||

Line 1601: fnd_log.STRING (fnd_log.level_procedure,

1597: );
1598:
1599: -- end debug log
1600: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1601: fnd_log.STRING (fnd_log.level_procedure,
1602: g_module ||
1603: l_api_name,
1604: '1000: Leaving ' ||
1605: g_pkg_name ||

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

1608: );
1609: END IF;
1610: EXCEPTION
1611: WHEN fnd_api.g_exc_error THEN
1612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1613: fnd_log.STRING (fnd_log.level_procedure,
1614: g_module ||
1615: l_api_name,
1616: '2000: Leaving ' ||

Line 1613: fnd_log.STRING (fnd_log.level_procedure,

1609: END IF;
1610: EXCEPTION
1611: WHEN fnd_api.g_exc_error THEN
1612: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1613: fnd_log.STRING (fnd_log.level_procedure,
1614: g_module ||
1615: l_api_name,
1616: '2000: Leaving ' ||
1617: g_pkg_name ||

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

1625: p_count => x_msg_count,
1626: p_data => x_msg_data
1627: );
1628: WHEN fnd_api.g_exc_unexpected_error THEN
1629: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1630: fnd_log.STRING (fnd_log.level_procedure,
1631: g_module ||
1632: l_api_name,
1633: '3000: Leaving ' ||

Line 1630: fnd_log.STRING (fnd_log.level_procedure,

1626: p_data => x_msg_data
1627: );
1628: WHEN fnd_api.g_exc_unexpected_error THEN
1629: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1630: fnd_log.STRING (fnd_log.level_procedure,
1631: g_module ||
1632: l_api_name,
1633: '3000: Leaving ' ||
1634: g_pkg_name ||

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

1642: p_count => x_msg_count,
1643: p_data => x_msg_data
1644: );
1645: WHEN OTHERS THEN
1646: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1647: fnd_log.STRING (fnd_log.level_procedure,
1648: g_module ||
1649: l_api_name,
1650: '4000: Leaving ' ||

Line 1647: fnd_log.STRING (fnd_log.level_procedure,

1643: p_data => x_msg_data
1644: );
1645: WHEN OTHERS THEN
1646: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1647: fnd_log.STRING (fnd_log.level_procedure,
1648: g_module ||
1649: l_api_name,
1650: '4000: Leaving ' ||
1651: g_pkg_name ||

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

1674: l_api_name CONSTANT VARCHAR2 (30)
1675: := 'accept_contract';
1676: BEGIN
1677: -- start debug log
1678: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1679: fnd_log.STRING (fnd_log.level_procedure,
1680: g_module ||
1681: l_api_name,
1682: '100: Entered ' ||

Line 1679: fnd_log.STRING (fnd_log.level_procedure,

1675: := 'accept_contract';
1676: BEGIN
1677: -- start debug log
1678: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1679: fnd_log.STRING (fnd_log.level_procedure,
1680: g_module ||
1681: l_api_name,
1682: '100: Entered ' ||
1683: g_pkg_name ||

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

1727: p_data => x_msg_data
1728: );
1729:
1730: -- end debug log
1731: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1732: fnd_log.STRING (fnd_log.level_procedure,
1733: g_module ||
1734: l_api_name,
1735: '1000: Leaving ' ||

Line 1732: fnd_log.STRING (fnd_log.level_procedure,

1728: );
1729:
1730: -- end debug log
1731: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1732: fnd_log.STRING (fnd_log.level_procedure,
1733: g_module ||
1734: l_api_name,
1735: '1000: Leaving ' ||
1736: g_pkg_name ||

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

1739: );
1740: END IF;
1741: EXCEPTION
1742: WHEN fnd_api.g_exc_error THEN
1743: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1744: fnd_log.STRING (fnd_log.level_procedure,
1745: g_module ||
1746: l_api_name,
1747: '2000: Leaving ' ||

Line 1744: fnd_log.STRING (fnd_log.level_procedure,

1740: END IF;
1741: EXCEPTION
1742: WHEN fnd_api.g_exc_error THEN
1743: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1744: fnd_log.STRING (fnd_log.level_procedure,
1745: g_module ||
1746: l_api_name,
1747: '2000: Leaving ' ||
1748: g_pkg_name ||

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

1756: p_count => x_msg_count,
1757: p_data => x_msg_data
1758: );
1759: WHEN fnd_api.g_exc_unexpected_error THEN
1760: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1761: fnd_log.STRING (fnd_log.level_procedure,
1762: g_module ||
1763: l_api_name,
1764: '3000: Leaving ' ||

Line 1761: fnd_log.STRING (fnd_log.level_procedure,

1757: p_data => x_msg_data
1758: );
1759: WHEN fnd_api.g_exc_unexpected_error THEN
1760: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1761: fnd_log.STRING (fnd_log.level_procedure,
1762: g_module ||
1763: l_api_name,
1764: '3000: Leaving ' ||
1765: g_pkg_name ||

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

1773: p_count => x_msg_count,
1774: p_data => x_msg_data
1775: );
1776: WHEN OTHERS THEN
1777: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1778: fnd_log.STRING (fnd_log.level_procedure,
1779: g_module ||
1780: l_api_name,
1781: '4000: Leaving ' ||

Line 1778: fnd_log.STRING (fnd_log.level_procedure,

1774: p_data => x_msg_data
1775: );
1776: WHEN OTHERS THEN
1777: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1778: fnd_log.STRING (fnd_log.level_procedure,
1779: g_module ||
1780: l_api_name,
1781: '4000: Leaving ' ||
1782: g_pkg_name ||

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

1846: l_payer l_payer_type;
1847: l_response iby_fndcpt_common_pub.result_rec_type;
1848: BEGIN
1849: -- start debug log
1850: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1851: fnd_log.STRING (fnd_log.level_procedure,
1852: g_module ||
1853: l_api_name,
1854: '100: Entered ' ||

Line 1851: fnd_log.STRING (fnd_log.level_procedure,

1847: l_response iby_fndcpt_common_pub.result_rec_type;
1848: BEGIN
1849: -- start debug log
1850: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1851: fnd_log.STRING (fnd_log.level_procedure,
1852: g_module ||
1853: l_api_name,
1854: '100: Entered ' ||
1855: g_pkg_name ||

Line 1859: fnd_log.STRING (fnd_log.level_procedure,

1855: g_pkg_name ||
1856: '.' ||
1857: l_api_name
1858: );
1859: fnd_log.STRING (fnd_log.level_procedure,
1860: g_module ||
1861: l_api_name,
1862: '100: Parameters p_chr_id : ' ||
1863: p_chr_id

Line 1865: fnd_log.STRING (fnd_log.level_procedure,

1861: l_api_name,
1862: '100: Parameters p_chr_id : ' ||
1863: p_chr_id
1864: );
1865: fnd_log.STRING (fnd_log.level_procedure,
1866: g_module ||
1867: l_api_name,
1868: '100: p_payment_type : ' ||
1869: p_payment_type

Line 1871: fnd_log.STRING (fnd_log.level_procedure,

1867: l_api_name,
1868: '100: p_payment_type : ' ||
1869: p_payment_type
1870: );
1871: fnd_log.STRING (fnd_log.level_procedure,
1872: g_module ||
1873: l_api_name,
1874: '100: p_payment_details : ' ||
1875: p_payment_details

Line 1877: fnd_log.STRING (fnd_log.level_procedure,

1873: l_api_name,
1874: '100: p_payment_details : ' ||
1875: p_payment_details
1876: );
1877: fnd_log.STRING (fnd_log.level_procedure,
1878: g_module ||
1879: l_api_name,
1880: '100: p_party_id : ' ||
1881: p_party_id

Line 1883: fnd_log.STRING (fnd_log.level_procedure,

1879: l_api_name,
1880: '100: p_party_id : ' ||
1881: p_party_id
1882: );
1883: fnd_log.STRING (fnd_log.level_procedure,
1884: g_module ||
1885: l_api_name,
1886: '100: p_cust_account_id : ' ||
1887: p_cust_account_id

Line 1889: fnd_log.STRING (fnd_log.level_procedure,

1885: l_api_name,
1886: '100: p_cust_account_id : ' ||
1887: p_cust_account_id
1888: );
1889: fnd_log.STRING (fnd_log.level_procedure,
1890: g_module ||
1891: l_api_name,
1892: '100: p_expiration_month : ' ||
1893: p_expiration_month

Line 1895: fnd_log.STRING (fnd_log.level_procedure,

1891: l_api_name,
1892: '100: p_expiration_month : ' ||
1893: p_expiration_month
1894: );
1895: fnd_log.STRING (fnd_log.level_procedure,
1896: g_module ||
1897: l_api_name,
1898: '100: p_expiration_year : ' ||
1899: p_expiration_year

Line 1901: fnd_log.STRING (fnd_log.level_procedure,

1897: l_api_name,
1898: '100: p_expiration_year : ' ||
1899: p_expiration_year
1900: );
1901: fnd_log.STRING (fnd_log.level_procedure,
1902: g_module ||
1903: l_api_name,
1904: '100: p_cvv_code : ' ||
1905: p_cvv_code

Line 1907: fnd_log.STRING (fnd_log.level_procedure,

1903: l_api_name,
1904: '100: p_cvv_code : ' ||
1905: p_cvv_code
1906: );
1907: fnd_log.STRING (fnd_log.level_procedure,
1908: g_module ||
1909: l_api_name,
1910: '100: p_instr_assignment_id : ' ||
1911: p_instr_assignment_id

Line 1913: fnd_log.STRING (fnd_log.level_procedure,

1909: l_api_name,
1910: '100: p_instr_assignment_id : ' ||
1911: p_instr_assignment_id
1912: );
1913: fnd_log.STRING (fnd_log.level_procedure,
1914: g_module ||
1915: l_api_name,
1916: '100: p_old_txn_entension_id : ' ||
1917: p_old_txn_entension_id

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

1956: END IF;
1957:
1958: -- Get the payment_terms_id1 from GCD
1959: -- debug log
1960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1961: fnd_log.STRING (fnd_log.level_procedure,
1962: g_module ||
1963: l_api_name,
1964: '210: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'

Line 1961: fnd_log.STRING (fnd_log.level_procedure,

1957:
1958: -- Get the payment_terms_id1 from GCD
1959: -- debug log
1960: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1961: fnd_log.STRING (fnd_log.level_procedure,
1962: g_module ||
1963: l_api_name,
1964: '210: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
1965: );

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

1979: x_msg_data => x_msg_data
1980: );
1981:
1982: -- debug log
1983: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1984: fnd_log.STRING (fnd_log.level_procedure,
1985: g_module ||
1986: l_api_name,
1987: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'

Line 1984: fnd_log.STRING (fnd_log.level_procedure,

1980: );
1981:
1982: -- debug log
1983: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
1984: fnd_log.STRING (fnd_log.level_procedure,
1985: g_module ||
1986: l_api_name,
1987: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
1988: );

Line 1989: fnd_log.STRING (fnd_log.level_procedure,

1985: g_module ||
1986: l_api_name,
1987: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
1988: );
1989: fnd_log.STRING (fnd_log.level_procedure,
1990: g_module ||
1991: l_api_name,
1992: '250: x_return_status : ' ||
1993: x_return_status

Line 1995: fnd_log.STRING (fnd_log.level_procedure,

1991: l_api_name,
1992: '250: x_return_status : ' ||
1993: x_return_status
1994: );
1995: fnd_log.STRING (fnd_log.level_procedure,
1996: g_module ||
1997: l_api_name,
1998: '250:x_rnrl_rec.payment_terms_id1 : ' ||
1999: x_rnrl_rec.payment_terms_id1

Line 2001: fnd_log.STRING (fnd_log.level_procedure,

1997: l_api_name,
1998: '250:x_rnrl_rec.payment_terms_id1 : ' ||
1999: x_rnrl_rec.payment_terms_id1
2000: );
2001: fnd_log.STRING (fnd_log.level_procedure,
2002: g_module ||
2003: l_api_name,
2004: '250:x_rnrl_rec.payment_terms_id2 : ' ||
2005: x_rnrl_rec.payment_terms_id2

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

2035:
2036: CLOSE csr_billing_address_id;
2037:
2038: -- debug log
2039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2040: fnd_log.STRING (fnd_log.level_statement,
2041: g_module ||
2042: l_api_name,
2043: '300: l_billing_address_id : ' ||

Line 2040: fnd_log.STRING (fnd_log.level_statement,

2036: CLOSE csr_billing_address_id;
2037:
2038: -- debug log
2039: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2040: fnd_log.STRING (fnd_log.level_statement,
2041: g_module ||
2042: l_api_name,
2043: '300: l_billing_address_id : ' ||
2044: l_billing_address_id

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

2058: l_expiration_date := LAST_DAY (TO_DATE (p_expiration_month ||'/' ||p_expiration_year, 'MM/YYYY'));
2059: END IF;
2060:
2061: -- debug log
2062: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2063: fnd_log.STRING (fnd_log.level_statement,
2064: g_module ||
2065: l_api_name,
2066: '300: l_expiration_date : ' ||

Line 2063: fnd_log.STRING (fnd_log.level_statement,

2059: END IF;
2060:
2061: -- debug log
2062: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2063: fnd_log.STRING (fnd_log.level_statement,
2064: g_module ||
2065: l_api_name,
2066: '300: l_expiration_date : ' ||
2067: TO_CHAR (l_expiration_date)

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

2069: END IF;
2070:
2071: -- call process_credit_card
2072: -- debug log
2073: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2074: fnd_log.STRING (fnd_log.level_statement,
2075: g_module ||
2076: l_api_name,
2077: '350: Calling process_credit_card '

Line 2074: fnd_log.STRING (fnd_log.level_statement,

2070:
2071: -- call process_credit_card
2072: -- debug log
2073: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2074: fnd_log.STRING (fnd_log.level_statement,
2075: g_module ||
2076: l_api_name,
2077: '350: Calling process_credit_card '
2078: );

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

2097: x_msg_count => x_msg_count
2098: );
2099:
2100: -- debug log
2101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2102: fnd_log.STRING
2103: (fnd_log.level_statement,
2104: g_module ||
2105: l_api_name,

Line 2102: fnd_log.STRING

2098: );
2099:
2100: -- debug log
2101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2102: fnd_log.STRING
2103: (fnd_log.level_statement,
2104: g_module ||
2105: l_api_name,
2106: '450: After Calling process_credit_card x_return_status : ' ||

Line 2103: (fnd_log.level_statement,

2099:
2100: -- debug log
2101: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2102: fnd_log.STRING
2103: (fnd_log.level_statement,
2104: g_module ||
2105: l_api_name,
2106: '450: After Calling process_credit_card x_return_status : ' ||
2107: x_return_status

Line 2109: fnd_log.STRING (fnd_log.level_statement,

2105: l_api_name,
2106: '450: After Calling process_credit_card x_return_status : ' ||
2107: x_return_status
2108: );
2109: fnd_log.STRING (fnd_log.level_statement,
2110: g_module ||
2111: l_api_name,
2112: '450: l_trxn_extension_id : ' ||
2113: l_trxn_extension_id

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

2206: p_data => x_msg_data
2207: );
2208:
2209: -- end debug log
2210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2211: fnd_log.STRING (fnd_log.level_procedure,
2212: g_module ||
2213: l_api_name,
2214: '1000: Leaving ' ||

Line 2211: fnd_log.STRING (fnd_log.level_procedure,

2207: );
2208:
2209: -- end debug log
2210: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2211: fnd_log.STRING (fnd_log.level_procedure,
2212: g_module ||
2213: l_api_name,
2214: '1000: Leaving ' ||
2215: g_pkg_name ||

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

2218: );
2219: END IF;
2220: EXCEPTION
2221: WHEN fnd_api.g_exc_error THEN
2222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2223: fnd_log.STRING (fnd_log.level_procedure,
2224: g_module ||
2225: l_api_name,
2226: '2000: Leaving ' ||

Line 2223: fnd_log.STRING (fnd_log.level_procedure,

2219: END IF;
2220: EXCEPTION
2221: WHEN fnd_api.g_exc_error THEN
2222: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2223: fnd_log.STRING (fnd_log.level_procedure,
2224: g_module ||
2225: l_api_name,
2226: '2000: Leaving ' ||
2227: g_pkg_name ||

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

2235: p_count => x_msg_count,
2236: p_data => x_msg_data
2237: );
2238: WHEN fnd_api.g_exc_unexpected_error THEN
2239: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2240: fnd_log.STRING (fnd_log.level_procedure,
2241: g_module ||
2242: l_api_name,
2243: '3000: Leaving ' ||

Line 2240: fnd_log.STRING (fnd_log.level_procedure,

2236: p_data => x_msg_data
2237: );
2238: WHEN fnd_api.g_exc_unexpected_error THEN
2239: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2240: fnd_log.STRING (fnd_log.level_procedure,
2241: g_module ||
2242: l_api_name,
2243: '3000: Leaving ' ||
2244: g_pkg_name ||

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

2252: p_count => x_msg_count,
2253: p_data => x_msg_data
2254: );
2255: WHEN OTHERS THEN
2256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2257: fnd_log.STRING (fnd_log.level_procedure,
2258: g_module ||
2259: l_api_name,
2260: '4000: Leaving ' ||

Line 2257: fnd_log.STRING (fnd_log.level_procedure,

2253: p_data => x_msg_data
2254: );
2255: WHEN OTHERS THEN
2256: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2257: fnd_log.STRING (fnd_log.level_procedure,
2258: g_module ||
2259: l_api_name,
2260: '4000: Leaving ' ||
2261: g_pkg_name ||

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

2287: l_api_version CONSTANT NUMBER := 1;
2288: l_api_name CONSTANT VARCHAR2 (30) := 'send_email';
2289: BEGIN
2290: -- start debug log
2291: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2292: fnd_log.STRING (fnd_log.level_procedure,
2293: g_module ||
2294: l_api_name,
2295: '100: Entered ' ||

Line 2292: fnd_log.STRING (fnd_log.level_procedure,

2288: l_api_name CONSTANT VARCHAR2 (30) := 'send_email';
2289: BEGIN
2290: -- start debug log
2291: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2292: fnd_log.STRING (fnd_log.level_procedure,
2293: g_module ||
2294: l_api_name,
2295: '100: Entered ' ||
2296: g_pkg_name ||

Line 2300: fnd_log.STRING (fnd_log.level_procedure,

2296: g_pkg_name ||
2297: '.' ||
2298: l_api_name
2299: );
2300: fnd_log.STRING (fnd_log.level_procedure,
2301: g_module ||
2302: l_api_name,
2303: '100: Parameters p_chr_id : ' ||
2304: p_chr_id

Line 2306: fnd_log.STRING (fnd_log.level_procedure,

2302: l_api_name,
2303: '100: Parameters p_chr_id : ' ||
2304: p_chr_id
2305: );
2306: fnd_log.STRING (fnd_log.level_procedure,
2307: g_module ||
2308: l_api_name,
2309: '100: p_send_to : ' ||
2310: p_send_to

Line 2312: fnd_log.STRING (fnd_log.level_procedure,

2308: l_api_name,
2309: '100: p_send_to : ' ||
2310: p_send_to
2311: );
2312: fnd_log.STRING (fnd_log.level_procedure,
2313: g_module ||
2314: l_api_name,
2315: '100: p_api_version : ' ||
2316: p_api_version

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

2326: RAISE fnd_api.g_exc_unexpected_error;
2327: END IF;
2328:
2329: -- debug log
2330: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2331: fnd_log.STRING (fnd_log.level_procedure,
2332: g_module ||
2333: l_api_name,
2334: '110: Calling FND_MSG_PUB.initialize'

Line 2331: fnd_log.STRING (fnd_log.level_procedure,

2327: END IF;
2328:
2329: -- debug log
2330: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2331: fnd_log.STRING (fnd_log.level_procedure,
2332: g_module ||
2333: l_api_name,
2334: '110: Calling FND_MSG_PUB.initialize'
2335: );

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

2345: -- set context to multi org
2346: -- mo_global.init ('OKC');
2347:
2348: -- debug log
2349: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2350: fnd_log.STRING
2351: (fnd_log.level_procedure,
2352: g_module ||
2353: l_api_name,

Line 2350: fnd_log.STRING

2346: -- mo_global.init ('OKC');
2347:
2348: -- debug log
2349: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2350: fnd_log.STRING
2351: (fnd_log.level_procedure,
2352: g_module ||
2353: l_api_name,
2354: '140: Calling OKS_WF_K_PROCESS_PVT.customer_request_assistance '

Line 2351: (fnd_log.level_procedure,

2347:
2348: -- debug log
2349: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2350: fnd_log.STRING
2351: (fnd_log.level_procedure,
2352: g_module ||
2353: l_api_name,
2354: '140: Calling OKS_WF_K_PROCESS_PVT.customer_request_assistance '
2355: );

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

2370: x_msg_count => x_msg_count
2371: );
2372:
2373: -- debug log
2374: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2375: fnd_log.STRING
2376: (fnd_log.level_procedure,
2377: g_module ||
2378: l_api_name,

Line 2375: fnd_log.STRING

2371: );
2372:
2373: -- debug log
2374: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2375: fnd_log.STRING
2376: (fnd_log.level_procedure,
2377: g_module ||
2378: l_api_name,
2379: '150: After Calling customer_request_assistance x_return_status : ' ||

Line 2376: (fnd_log.level_procedure,

2372:
2373: -- debug log
2374: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2375: fnd_log.STRING
2376: (fnd_log.level_procedure,
2377: g_module ||
2378: l_api_name,
2379: '150: After Calling customer_request_assistance x_return_status : ' ||
2380: x_return_status

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

2394: p_data => x_msg_data
2395: );
2396:
2397: -- end debug log
2398: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2399: fnd_log.STRING (fnd_log.level_procedure,
2400: g_module ||
2401: l_api_name,
2402: '1000: Leaving ' ||

Line 2399: fnd_log.STRING (fnd_log.level_procedure,

2395: );
2396:
2397: -- end debug log
2398: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2399: fnd_log.STRING (fnd_log.level_procedure,
2400: g_module ||
2401: l_api_name,
2402: '1000: Leaving ' ||
2403: g_pkg_name ||

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

2406: );
2407: END IF;
2408: EXCEPTION
2409: WHEN fnd_api.g_exc_error THEN
2410: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2411: fnd_log.STRING (fnd_log.level_procedure,
2412: g_module ||
2413: l_api_name,
2414: '2000: Leaving ' ||

Line 2411: fnd_log.STRING (fnd_log.level_procedure,

2407: END IF;
2408: EXCEPTION
2409: WHEN fnd_api.g_exc_error THEN
2410: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2411: fnd_log.STRING (fnd_log.level_procedure,
2412: g_module ||
2413: l_api_name,
2414: '2000: Leaving ' ||
2415: g_pkg_name ||

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

2423: p_count => x_msg_count,
2424: p_data => x_msg_data
2425: );
2426: WHEN fnd_api.g_exc_unexpected_error THEN
2427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2428: fnd_log.STRING (fnd_log.level_procedure,
2429: g_module ||
2430: l_api_name,
2431: '3000: Leaving ' ||

Line 2428: fnd_log.STRING (fnd_log.level_procedure,

2424: p_data => x_msg_data
2425: );
2426: WHEN fnd_api.g_exc_unexpected_error THEN
2427: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2428: fnd_log.STRING (fnd_log.level_procedure,
2429: g_module ||
2430: l_api_name,
2431: '3000: Leaving ' ||
2432: g_pkg_name ||

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

2440: p_count => x_msg_count,
2441: p_data => x_msg_data
2442: );
2443: WHEN OTHERS THEN
2444: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2445: fnd_log.STRING (fnd_log.level_procedure,
2446: g_module ||
2447: l_api_name,
2448: '4000: Leaving ' ||

Line 2445: fnd_log.STRING (fnd_log.level_procedure,

2441: p_data => x_msg_data
2442: );
2443: WHEN OTHERS THEN
2444: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2445: fnd_log.STRING (fnd_log.level_procedure,
2446: g_module ||
2447: l_api_name,
2448: '4000: Leaving ' ||
2449: g_pkg_name ||

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

2502: FROM oks_k_headers_b
2503: WHERE chr_id = p_chr_id;
2504: BEGIN
2505: -- start debug log
2506: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2507: fnd_log.STRING (fnd_log.level_procedure,
2508: g_module ||
2509: l_api_name,
2510: '100: Entered ' ||

Line 2507: fnd_log.STRING (fnd_log.level_procedure,

2503: WHERE chr_id = p_chr_id;
2504: BEGIN
2505: -- start debug log
2506: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2507: fnd_log.STRING (fnd_log.level_procedure,
2508: g_module ||
2509: l_api_name,
2510: '100: Entered ' ||
2511: g_pkg_name ||

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

2533: -- set context to multi org
2534: -- mo_global.init ('OKC');
2535:
2536: -- debug log
2537: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2538: fnd_log.STRING (fnd_log.level_procedure,
2539: g_module ||
2540: l_api_name,
2541: '200: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'

Line 2538: fnd_log.STRING (fnd_log.level_procedure,

2534: -- mo_global.init ('OKC');
2535:
2536: -- debug log
2537: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2538: fnd_log.STRING (fnd_log.level_procedure,
2539: g_module ||
2540: l_api_name,
2541: '200: Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
2542: );

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

2556: x_msg_data => x_msg_data
2557: );
2558:
2559: -- debug log
2560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2561: fnd_log.STRING (fnd_log.level_procedure,
2562: g_module ||
2563: l_api_name,
2564: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'

Line 2561: fnd_log.STRING (fnd_log.level_procedure,

2557: );
2558:
2559: -- debug log
2560: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2561: fnd_log.STRING (fnd_log.level_procedure,
2562: g_module ||
2563: l_api_name,
2564: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
2565: );

Line 2566: fnd_log.STRING (fnd_log.level_procedure,

2562: g_module ||
2563: l_api_name,
2564: '250: After Calling OKS_RENEW_UTIL_PVT.get_renew_rules'
2565: );
2566: fnd_log.STRING (fnd_log.level_procedure,
2567: g_module ||
2568: l_api_name,
2569: '250: x_return_status : ' ||
2570: x_return_status

Line 2572: fnd_log.STRING (fnd_log.level_procedure,

2568: l_api_name,
2569: '250: x_return_status : ' ||
2570: x_return_status
2571: );
2572: fnd_log.STRING (fnd_log.level_procedure,
2573: g_module ||
2574: l_api_name,
2575: '250:x_rnrl_rec.credit_card_flag : ' ||
2576: x_rnrl_rec.credit_card_flag

Line 2578: fnd_log.STRING (fnd_log.level_procedure,

2574: l_api_name,
2575: '250:x_rnrl_rec.credit_card_flag : ' ||
2576: x_rnrl_rec.credit_card_flag
2577: );
2578: fnd_log.STRING (fnd_log.level_procedure,
2579: g_module ||
2580: l_api_name,
2581: '250:x_rnrl_rec.commitment_number_flag : ' ||
2582: x_rnrl_rec.commitment_number_flag

Line 2584: fnd_log.STRING (fnd_log.level_procedure,

2580: l_api_name,
2581: '250:x_rnrl_rec.commitment_number_flag : ' ||
2582: x_rnrl_rec.commitment_number_flag
2583: );
2584: fnd_log.STRING (fnd_log.level_procedure,
2585: g_module ||
2586: l_api_name,
2587: '250:x_rnrl_rec.purchase_order_flag : ' ||
2588: x_rnrl_rec.purchase_order_flag

Line 2590: fnd_log.STRING (fnd_log.level_procedure,

2586: l_api_name,
2587: '250:x_rnrl_rec.purchase_order_flag : ' ||
2588: x_rnrl_rec.purchase_order_flag
2589: );
2590: fnd_log.STRING (fnd_log.level_procedure,
2591: g_module ||
2592: l_api_name,
2593: '250:x_rnrl_rec.check_flag : ' ||
2594: x_rnrl_rec.check_flag

Line 2596: fnd_log.STRING (fnd_log.level_procedure,

2592: l_api_name,
2593: '250:x_rnrl_rec.check_flag : ' ||
2594: x_rnrl_rec.check_flag
2595: );
2596: fnd_log.STRING (fnd_log.level_procedure,
2597: g_module ||
2598: l_api_name,
2599: '250:x_rnrl_rec.wire_flag : ' ||
2600: x_rnrl_rec.wire_flag

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

2620:
2621: CLOSE csr_k_amt_curr;
2622:
2623: -- debug log
2624: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2625: fnd_log.STRING (fnd_log.level_procedure,
2626: g_module ||
2627: l_api_name,
2628: '300: l_k_amount : ' ||

Line 2625: fnd_log.STRING (fnd_log.level_procedure,

2621: CLOSE csr_k_amt_curr;
2622:
2623: -- debug log
2624: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2625: fnd_log.STRING (fnd_log.level_procedure,
2626: g_module ||
2627: l_api_name,
2628: '300: l_k_amount : ' ||
2629: l_k_amount

Line 2631: fnd_log.STRING (fnd_log.level_procedure,

2627: l_api_name,
2628: '300: l_k_amount : ' ||
2629: l_k_amount
2630: );
2631: fnd_log.STRING (fnd_log.level_procedure,
2632: g_module ||
2633: l_api_name,
2634: '300:l_k_curr : ' ||
2635: l_k_curr

Line 2637: fnd_log.STRING (fnd_log.level_procedure,

2633: l_api_name,
2634: '300:l_k_curr : ' ||
2635: l_k_curr
2636: );
2637: fnd_log.STRING (fnd_log.level_procedure,
2638: g_module ||
2639: l_api_name,
2640: '300:l_curr_instrument : ' ||
2641: l_curr_instrument

Line 2643: fnd_log.STRING (fnd_log.level_procedure,

2639: l_api_name,
2640: '300:l_curr_instrument : ' ||
2641: l_curr_instrument
2642: );
2643: fnd_log.STRING (fnd_log.level_procedure,
2644: g_module ||
2645: l_api_name,
2646: '300: x_rnrl_rec.payment_threshold_amt : ' ||
2647: x_rnrl_rec.payment_threshold_amt

Line 2649: fnd_log.STRING (fnd_log.level_procedure,

2645: l_api_name,
2646: '300: x_rnrl_rec.payment_threshold_amt : ' ||
2647: x_rnrl_rec.payment_threshold_amt
2648: );
2649: fnd_log.STRING (fnd_log.level_procedure,
2650: g_module ||
2651: l_api_name,
2652: '300: x_rnrl_rec.base_currency : ' ||
2653: x_rnrl_rec.base_currency

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

2664:
2665: CLOSE csr_curr_payment;
2666: */
2667: -- debug log
2668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2669: fnd_log.STRING (fnd_log.level_procedure,
2670: g_module ||
2671: l_api_name,
2672: '300: l_curr_payment : ' ||

Line 2669: fnd_log.STRING (fnd_log.level_procedure,

2665: CLOSE csr_curr_payment;
2666: */
2667: -- debug log
2668: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2669: fnd_log.STRING (fnd_log.level_procedure,
2670: g_module ||
2671: l_api_name,
2672: '300: l_curr_payment : ' ||
2673: l_curr_payment

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

2729: END IF; -- credit card is the only payment option
2730: END IF; -- currency of K and base curr same
2731:
2732: -- debug log
2733: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2734: fnd_log.STRING (fnd_log.level_procedure,
2735: g_module ||
2736: l_api_name,
2737: '350: l_k_current_payments : ' ||

Line 2734: fnd_log.STRING (fnd_log.level_procedure,

2730: END IF; -- currency of K and base curr same
2731:
2732: -- debug log
2733: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2734: fnd_log.STRING (fnd_log.level_procedure,
2735: g_module ||
2736: l_api_name,
2737: '350: l_k_current_payments : ' ||
2738: l_k_current_payments

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

2817: END IF;
2818: END IF;
2819:
2820: -- debug log
2821: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2822: fnd_log.STRING (fnd_log.level_procedure,
2823: g_module ||
2824: l_api_name,
2825: '500: x_valid_payments : ' ||

Line 2822: fnd_log.STRING (fnd_log.level_procedure,

2818: END IF;
2819:
2820: -- debug log
2821: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2822: fnd_log.STRING (fnd_log.level_procedure,
2823: g_module ||
2824: l_api_name,
2825: '500: x_valid_payments : ' ||
2826: l_valid_payments

Line 2828: fnd_log.STRING (fnd_log.level_procedure,

2824: l_api_name,
2825: '500: x_valid_payments : ' ||
2826: l_valid_payments
2827: );
2828: fnd_log.STRING (fnd_log.level_procedure,
2829: g_module ||
2830: l_api_name,
2831: '500: x_default_payment : ' ||
2832: l_default_payment

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

2836: x_valid_payments := l_valid_payments;
2837: x_default_payment := l_default_payment;
2838:
2839: -- end debug log
2840: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2841: fnd_log.STRING (fnd_log.level_procedure,
2842: g_module ||
2843: l_api_name,
2844: '1000: Leaving ' ||

Line 2841: fnd_log.STRING (fnd_log.level_procedure,

2837: x_default_payment := l_default_payment;
2838:
2839: -- end debug log
2840: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2841: fnd_log.STRING (fnd_log.level_procedure,
2842: g_module ||
2843: l_api_name,
2844: '1000: Leaving ' ||
2845: g_pkg_name ||

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

2848: );
2849: END IF;
2850: EXCEPTION
2851: WHEN fnd_api.g_exc_error THEN
2852: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2853: fnd_log.STRING (fnd_log.level_procedure,
2854: g_module ||
2855: l_api_name,
2856: '2000: Leaving ' ||

Line 2853: fnd_log.STRING (fnd_log.level_procedure,

2849: END IF;
2850: EXCEPTION
2851: WHEN fnd_api.g_exc_error THEN
2852: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2853: fnd_log.STRING (fnd_log.level_procedure,
2854: g_module ||
2855: l_api_name,
2856: '2000: Leaving ' ||
2857: g_pkg_name ||

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

2865: p_count => x_msg_count,
2866: p_data => x_msg_data
2867: );
2868: WHEN fnd_api.g_exc_unexpected_error THEN
2869: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2870: fnd_log.STRING (fnd_log.level_procedure,
2871: g_module ||
2872: l_api_name,
2873: '3000: Leaving ' ||

Line 2870: fnd_log.STRING (fnd_log.level_procedure,

2866: p_data => x_msg_data
2867: );
2868: WHEN fnd_api.g_exc_unexpected_error THEN
2869: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2870: fnd_log.STRING (fnd_log.level_procedure,
2871: g_module ||
2872: l_api_name,
2873: '3000: Leaving ' ||
2874: g_pkg_name ||

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

2882: p_count => x_msg_count,
2883: p_data => x_msg_data
2884: );
2885: WHEN OTHERS THEN
2886: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2887: fnd_log.STRING (fnd_log.level_procedure,
2888: g_module ||
2889: l_api_name,
2890: '4000: Leaving ' ||

Line 2887: fnd_log.STRING (fnd_log.level_procedure,

2883: p_data => x_msg_data
2884: );
2885: WHEN OTHERS THEN
2886: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2887: fnd_log.STRING (fnd_log.level_procedure,
2888: g_module ||
2889: l_api_name,
2890: '4000: Leaving ' ||
2891: g_pkg_name ||

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

2939: l_response iby_fndcpt_common_pub.result_rec_type;
2940: l_trxnextension l_trxnextension_type;
2941: BEGIN
2942: -- start debug log
2943: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2944: fnd_log.STRING (fnd_log.level_procedure,
2945: g_module ||
2946: l_api_name,
2947: '100: Entered ' ||

Line 2944: fnd_log.STRING (fnd_log.level_procedure,

2940: l_trxnextension l_trxnextension_type;
2941: BEGIN
2942: -- start debug log
2943: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
2944: fnd_log.STRING (fnd_log.level_procedure,
2945: g_module ||
2946: l_api_name,
2947: '100: Entered ' ||
2948: g_pkg_name ||

Line 2952: fnd_log.STRING (fnd_log.level_procedure,

2948: g_pkg_name ||
2949: '.' ||
2950: l_api_name
2951: );
2952: fnd_log.STRING (fnd_log.level_procedure,
2953: g_module ||
2954: l_api_name,
2955: '100: ******* Parameters ********'
2956: );

Line 2957: fnd_log.STRING (fnd_log.level_procedure,

2953: g_module ||
2954: l_api_name,
2955: '100: ******* Parameters ********'
2956: );
2957: fnd_log.STRING (fnd_log.level_procedure,
2958: g_module ||
2959: l_api_name,
2960: '100: p_init_msg_list : ' ||
2961: p_init_msg_list

Line 2963: fnd_log.STRING (fnd_log.level_procedure,

2959: l_api_name,
2960: '100: p_init_msg_list : ' ||
2961: p_init_msg_list
2962: );
2963: fnd_log.STRING (fnd_log.level_procedure,
2964: g_module ||
2965: l_api_name,
2966: '100: p_order_id : ' ||
2967: p_order_id

Line 2969: fnd_log.STRING (fnd_log.level_procedure,

2965: l_api_name,
2966: '100: p_order_id : ' ||
2967: p_order_id
2968: );
2969: fnd_log.STRING (fnd_log.level_procedure,
2970: g_module ||
2971: l_api_name,
2972: '100: p_party_id : ' ||
2973: p_party_id

Line 2975: fnd_log.STRING (fnd_log.level_procedure,

2971: l_api_name,
2972: '100: p_party_id : ' ||
2973: p_party_id
2974: );
2975: fnd_log.STRING (fnd_log.level_procedure,
2976: g_module ||
2977: l_api_name,
2978: '100: p_cust_account_id : ' ||
2979: p_cust_account_id

Line 2981: fnd_log.STRING (fnd_log.level_procedure,

2977: l_api_name,
2978: '100: p_cust_account_id : ' ||
2979: p_cust_account_id
2980: );
2981: fnd_log.STRING (fnd_log.level_procedure,
2982: g_module ||
2983: l_api_name,
2984: '100: p_card_number : ' ||
2985: p_card_number

Line 2987: fnd_log.STRING (fnd_log.level_procedure,

2983: l_api_name,
2984: '100: p_card_number : ' ||
2985: p_card_number
2986: );
2987: fnd_log.STRING (fnd_log.level_procedure,
2988: g_module ||
2989: l_api_name,
2990: '100: p_expiration_date : ' ||
2991: TO_CHAR (p_expiration_date)

Line 2993: fnd_log.STRING (fnd_log.level_procedure,

2989: l_api_name,
2990: '100: p_expiration_date : ' ||
2991: TO_CHAR (p_expiration_date)
2992: );
2993: fnd_log.STRING (fnd_log.level_procedure,
2994: g_module ||
2995: l_api_name,
2996: '100: p_billing_address_id : ' ||
2997: p_billing_address_id

Line 2999: fnd_log.STRING (fnd_log.level_procedure,

2995: l_api_name,
2996: '100: p_billing_address_id : ' ||
2997: p_billing_address_id
2998: );
2999: fnd_log.STRING (fnd_log.level_procedure,
3000: g_module ||
3001: l_api_name,
3002: '100: p_cvv_code : ' ||
3003: p_cvv_code

Line 3005: fnd_log.STRING (fnd_log.level_procedure,

3001: l_api_name,
3002: '100: p_cvv_code : ' ||
3003: p_cvv_code
3004: );
3005: fnd_log.STRING (fnd_log.level_procedure,
3006: g_module ||
3007: l_api_name,
3008: '100: p_instr_assignment_id : ' ||
3009: p_instr_assignment_id

Line 3011: fnd_log.STRING (fnd_log.level_procedure,

3007: l_api_name,
3008: '100: p_instr_assignment_id : ' ||
3009: p_instr_assignment_id
3010: );
3011: fnd_log.STRING (fnd_log.level_procedure,
3012: g_module ||
3013: l_api_name,
3014: '100: p_old_txn_entension_id : ' ||
3015: p_old_txn_entension_id

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

3039:
3040: -- Delete any old transaction extension id
3041: IF (p_old_txn_entension_id IS NOT NULL) THEN
3042: -- debug log
3043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3044: fnd_log.STRING (fnd_log.level_statement,
3045: g_module ||
3046: l_api_name,
3047: '150: Found old txn extension id : ' ||

Line 3044: fnd_log.STRING (fnd_log.level_statement,

3040: -- Delete any old transaction extension id
3041: IF (p_old_txn_entension_id IS NOT NULL) THEN
3042: -- debug log
3043: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3044: fnd_log.STRING (fnd_log.level_statement,
3045: g_module ||
3046: l_api_name,
3047: '150: Found old txn extension id : ' ||
3048: p_old_txn_entension_id

Line 3050: fnd_log.STRING

3046: l_api_name,
3047: '150: Found old txn extension id : ' ||
3048: p_old_txn_entension_id
3049: );
3050: fnd_log.STRING
3051: (fnd_log.level_statement,
3052: g_module ||
3053: l_api_name,
3054: '150: ***** Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'

Line 3051: (fnd_log.level_statement,

3047: '150: Found old txn extension id : ' ||
3048: p_old_txn_entension_id
3049: );
3050: fnd_log.STRING
3051: (fnd_log.level_statement,
3052: g_module ||
3053: l_api_name,
3054: '150: ***** Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3055: );

Line 3056: fnd_log.STRING (fnd_log.level_statement,

3052: g_module ||
3053: l_api_name,
3054: '150: ***** Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3055: );
3056: fnd_log.STRING (fnd_log.level_statement,
3057: g_module ||
3058: l_api_name,
3059: '150: ***** Parameters *****'
3060: );

Line 3061: fnd_log.STRING (fnd_log.level_statement,

3057: g_module ||
3058: l_api_name,
3059: '150: ***** Parameters *****'
3060: );
3061: fnd_log.STRING (fnd_log.level_statement,
3062: g_module ||
3063: l_api_name,
3064: '150: l_payer.Payment_Function : ' ||
3065: 'CUSTOMER_PAYMENT'

Line 3067: fnd_log.STRING (fnd_log.level_statement,

3063: l_api_name,
3064: '150: l_payer.Payment_Function : ' ||
3065: 'CUSTOMER_PAYMENT'
3066: );
3067: fnd_log.STRING (fnd_log.level_statement,
3068: g_module ||
3069: l_api_name,
3070: '150: l_payer.Party_Id : ' ||
3071: l_payer.party_id

Line 3073: fnd_log.STRING (fnd_log.level_statement,

3069: l_api_name,
3070: '150: l_payer.Party_Id : ' ||
3071: l_payer.party_id
3072: );
3073: fnd_log.STRING (fnd_log.level_statement,
3074: g_module ||
3075: l_api_name,
3076: '150: l_payer.cust_account_id : ' ||
3077: l_payer.cust_account_id

Line 3079: fnd_log.STRING (fnd_log.level_statement,

3075: l_api_name,
3076: '150: l_payer.cust_account_id : ' ||
3077: l_payer.cust_account_id
3078: );
3079: fnd_log.STRING (fnd_log.level_statement,
3080: g_module ||
3081: l_api_name,
3082: '150: p_commit : ' ||
3083: p_commit

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

3107: dbms_output.put_line(' l_response.result_message : '|| l_response.result_message);
3108: */
3109:
3110: -- debug log
3111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3112: fnd_log.STRING
3113: (fnd_log.level_statement,
3114: g_module ||
3115: l_api_name,

Line 3112: fnd_log.STRING

3108: */
3109:
3110: -- debug log
3111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3112: fnd_log.STRING
3113: (fnd_log.level_statement,
3114: g_module ||
3115: l_api_name,
3116: '200: ***** After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'

Line 3113: (fnd_log.level_statement,

3109:
3110: -- debug log
3111: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3112: fnd_log.STRING
3113: (fnd_log.level_statement,
3114: g_module ||
3115: l_api_name,
3116: '200: ***** After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3117: );

Line 3118: fnd_log.STRING (fnd_log.level_statement,

3114: g_module ||
3115: l_api_name,
3116: '200: ***** After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3117: );
3118: fnd_log.STRING (fnd_log.level_statement,
3119: g_module ||
3120: l_api_name,
3121: '200: x_return_status : ' ||
3122: x_return_status

Line 3124: fnd_log.STRING (fnd_log.level_statement,

3120: l_api_name,
3121: '200: x_return_status : ' ||
3122: x_return_status
3123: );
3124: fnd_log.STRING (fnd_log.level_statement,
3125: g_module ||
3126: l_api_name,
3127: '200: x_msg_count : ' ||
3128: x_msg_count

Line 3130: fnd_log.STRING (fnd_log.level_statement,

3126: l_api_name,
3127: '200: x_msg_count : ' ||
3128: x_msg_count
3129: );
3130: fnd_log.STRING (fnd_log.level_statement,
3131: g_module ||
3132: l_api_name,
3133: '200: x_response.result_code : ' ||
3134: l_response.result_code

Line 3136: fnd_log.STRING (fnd_log.level_statement,

3132: l_api_name,
3133: '200: x_response.result_code : ' ||
3134: l_response.result_code
3135: );
3136: fnd_log.STRING (fnd_log.level_statement,
3137: g_module ||
3138: l_api_name,
3139: '200: x_response.result_category : ' ||
3140: l_response.result_category

Line 3142: fnd_log.STRING (fnd_log.level_statement,

3138: l_api_name,
3139: '200: x_response.result_category : ' ||
3140: l_response.result_category
3141: );
3142: fnd_log.STRING (fnd_log.level_statement,
3143: g_module ||
3144: l_api_name,
3145: '200: x_response.result_message : ' ||
3146: l_response.result_message

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

3183: l_credit_card.card_number := p_card_number;
3184: l_credit_card.expiration_date := p_expiration_date;
3185:
3186: -- debug log
3187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3188: fnd_log.STRING (fnd_log.level_statement,
3189: g_module ||
3190: l_api_name,
3191: '300: p_instr_assignment_id IS NULL'

Line 3188: fnd_log.STRING (fnd_log.level_statement,

3184: l_credit_card.expiration_date := p_expiration_date;
3185:
3186: -- debug log
3187: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3188: fnd_log.STRING (fnd_log.level_statement,
3189: g_module ||
3190: l_api_name,
3191: '300: p_instr_assignment_id IS NULL'
3192: );

Line 3193: fnd_log.STRING

3189: g_module ||
3190: l_api_name,
3191: '300: p_instr_assignment_id IS NULL'
3192: );
3193: fnd_log.STRING
3194: (fnd_log.level_statement,
3195: g_module ||
3196: l_api_name,
3197: '300: ***** Calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card *****'

Line 3194: (fnd_log.level_statement,

3190: l_api_name,
3191: '300: p_instr_assignment_id IS NULL'
3192: );
3193: fnd_log.STRING
3194: (fnd_log.level_statement,
3195: g_module ||
3196: l_api_name,
3197: '300: ***** Calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card *****'
3198: );

Line 3199: fnd_log.STRING (fnd_log.level_statement,

3195: g_module ||
3196: l_api_name,
3197: '300: ***** Calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card *****'
3198: );
3199: fnd_log.STRING (fnd_log.level_statement,
3200: g_module ||
3201: l_api_name,
3202: '300: ***** Parameters *****'
3203: );

Line 3204: fnd_log.STRING (fnd_log.level_statement,

3200: g_module ||
3201: l_api_name,
3202: '300: ***** Parameters *****'
3203: );
3204: fnd_log.STRING (fnd_log.level_statement,
3205: g_module ||
3206: l_api_name,
3207: '300: l_credit_card.Owner_Id : ' ||
3208: l_credit_card.owner_id

Line 3210: fnd_log.STRING (fnd_log.level_statement,

3206: l_api_name,
3207: '300: l_credit_card.Owner_Id : ' ||
3208: l_credit_card.owner_id
3209: );
3210: fnd_log.STRING (fnd_log.level_statement,
3211: g_module ||
3212: l_api_name,
3213: '300: l_credit_card.Billing_Address_Id : ' ||
3214: l_credit_card.billing_address_id

Line 3216: fnd_log.STRING (fnd_log.level_statement,

3212: l_api_name,
3213: '300: l_credit_card.Billing_Address_Id : ' ||
3214: l_credit_card.billing_address_id
3215: );
3216: fnd_log.STRING (fnd_log.level_statement,
3217: g_module ||
3218: l_api_name,
3219: '300: l_credit_card.Card_Number : ' ||
3220: l_credit_card.card_number

Line 3222: fnd_log.STRING (fnd_log.level_statement,

3218: l_api_name,
3219: '300: l_credit_card.Card_Number : ' ||
3220: l_credit_card.card_number
3221: );
3222: fnd_log.STRING (fnd_log.level_statement,
3223: g_module ||
3224: l_api_name,
3225: '300: l_credit_card.Expiration_Date : ' ||
3226: l_credit_card.expiration_date

Line 3228: fnd_log.STRING (fnd_log.level_statement,

3224: l_api_name,
3225: '300: l_credit_card.Expiration_Date : ' ||
3226: l_credit_card.expiration_date
3227: );
3228: fnd_log.STRING (fnd_log.level_statement,
3229: g_module ||
3230: l_api_name,
3231: '300: l_payer.Payment_Function : ' ||
3232: 'CUSTOMER_PAYMENT'

Line 3234: fnd_log.STRING (fnd_log.level_statement,

3230: l_api_name,
3231: '300: l_payer.Payment_Function : ' ||
3232: 'CUSTOMER_PAYMENT'
3233: );
3234: fnd_log.STRING (fnd_log.level_statement,
3235: g_module ||
3236: l_api_name,
3237: '300: l_payer.Party_Id : ' ||
3238: l_payer.party_id

Line 3240: fnd_log.STRING (fnd_log.level_statement,

3236: l_api_name,
3237: '300: l_payer.Party_Id : ' ||
3238: l_payer.party_id
3239: );
3240: fnd_log.STRING (fnd_log.level_statement,
3241: g_module ||
3242: l_api_name,
3243: '300: l_payer.cust_account_id : ' ||
3244: l_payer.cust_account_id

Line 3246: fnd_log.STRING (fnd_log.level_statement,

3242: l_api_name,
3243: '300: l_payer.cust_account_id : ' ||
3244: l_payer.cust_account_id
3245: );
3246: fnd_log.STRING (fnd_log.level_statement,
3247: g_module ||
3248: l_api_name,
3249: '300: p_commit : ' ||
3250: p_commit

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

3275: dbms_output.put_line(' l_response.result_message : '|| l_response.result_message);
3276: */
3277:
3278: -- debug log
3279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3280: fnd_log.STRING
3281: (fnd_log.level_statement,
3282: g_module ||
3283: l_api_name,

Line 3280: fnd_log.STRING

3276: */
3277:
3278: -- debug log
3279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3280: fnd_log.STRING
3281: (fnd_log.level_statement,
3282: g_module ||
3283: l_api_name,
3284: '350: After Calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card'

Line 3281: (fnd_log.level_statement,

3277:
3278: -- debug log
3279: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3280: fnd_log.STRING
3281: (fnd_log.level_statement,
3282: g_module ||
3283: l_api_name,
3284: '350: After Calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card'
3285: );

Line 3286: fnd_log.STRING (fnd_log.level_statement,

3282: g_module ||
3283: l_api_name,
3284: '350: After Calling IBY_FNDCPT_SETUP_PUB.Process_Credit_Card'
3285: );
3286: fnd_log.STRING (fnd_log.level_statement,
3287: g_module ||
3288: l_api_name,
3289: '350: x_return_status : ' ||
3290: x_return_status

Line 3292: fnd_log.STRING (fnd_log.level_statement,

3288: l_api_name,
3289: '350: x_return_status : ' ||
3290: x_return_status
3291: );
3292: fnd_log.STRING (fnd_log.level_statement,
3293: g_module ||
3294: l_api_name,
3295: '350: l_instr_assignment_id : ' ||
3296: l_instr_assignment_id

Line 3298: fnd_log.STRING (fnd_log.level_statement,

3294: l_api_name,
3295: '350: l_instr_assignment_id : ' ||
3296: l_instr_assignment_id
3297: );
3298: fnd_log.STRING (fnd_log.level_statement,
3299: g_module ||
3300: l_api_name,
3301: '350: x_msg_count : ' ||
3302: x_msg_count

Line 3304: fnd_log.STRING (fnd_log.level_statement,

3300: l_api_name,
3301: '350: x_msg_count : ' ||
3302: x_msg_count
3303: );
3304: fnd_log.STRING (fnd_log.level_statement,
3305: g_module ||
3306: l_api_name,
3307: '350: x_response.result_code : ' ||
3308: l_response.result_code

Line 3310: fnd_log.STRING (fnd_log.level_statement,

3306: l_api_name,
3307: '350: x_response.result_code : ' ||
3308: l_response.result_code
3309: );
3310: fnd_log.STRING (fnd_log.level_statement,
3311: g_module ||
3312: l_api_name,
3313: '350: x_response.result_category : ' ||
3314: l_response.result_category

Line 3316: fnd_log.STRING (fnd_log.level_statement,

3312: l_api_name,
3313: '350: x_response.result_category : ' ||
3314: l_response.result_category
3315: );
3316: fnd_log.STRING (fnd_log.level_statement,
3317: g_module ||
3318: l_api_name,
3319: '350: x_response.result_message : ' ||
3320: l_response.result_message

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

3347: l_trxnextension.instrument_security_code := p_cvv_code;
3348: l_trxnextension.trxn_ref_number1 := to_char(SYSDATE,'ddmmyyyyhhmmssss');
3349:
3350: -- debug log
3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3352: fnd_log.STRING
3353: (fnd_log.level_statement,
3354: g_module ||
3355: l_api_name,

Line 3352: fnd_log.STRING

3348: l_trxnextension.trxn_ref_number1 := to_char(SYSDATE,'ddmmyyyyhhmmssss');
3349:
3350: -- debug log
3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3352: fnd_log.STRING
3353: (fnd_log.level_statement,
3354: g_module ||
3355: l_api_name,
3356: '500: ***** Calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension *****'

Line 3353: (fnd_log.level_statement,

3349:
3350: -- debug log
3351: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3352: fnd_log.STRING
3353: (fnd_log.level_statement,
3354: g_module ||
3355: l_api_name,
3356: '500: ***** Calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension *****'
3357: );

Line 3358: fnd_log.STRING (fnd_log.level_statement,

3354: g_module ||
3355: l_api_name,
3356: '500: ***** Calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension *****'
3357: );
3358: fnd_log.STRING (fnd_log.level_statement,
3359: g_module ||
3360: l_api_name,
3361: '500: ***** Parameters *****'
3362: );

Line 3363: fnd_log.STRING (fnd_log.level_statement,

3359: g_module ||
3360: l_api_name,
3361: '500: ***** Parameters *****'
3362: );
3363: fnd_log.STRING (fnd_log.level_statement,
3364: g_module ||
3365: l_api_name,
3366: '500: l_TrxnExtension.Originating_Application_Id : ' ||
3367: l_trxnextension.originating_application_id

Line 3369: fnd_log.STRING (fnd_log.level_statement,

3365: l_api_name,
3366: '500: l_TrxnExtension.Originating_Application_Id : ' ||
3367: l_trxnextension.originating_application_id
3368: );
3369: fnd_log.STRING (fnd_log.level_statement,
3370: g_module ||
3371: l_api_name,
3372: '500: l_TrxnExtension.Order_Id : ' ||
3373: l_trxnextension.order_id

Line 3375: fnd_log.STRING (fnd_log.level_statement,

3371: l_api_name,
3372: '500: l_TrxnExtension.Order_Id : ' ||
3373: l_trxnextension.order_id
3374: );
3375: fnd_log.STRING (fnd_log.level_statement,
3376: g_module ||
3377: l_api_name,
3378: '500: l_TrxnExtension.instrument_security_code : ' ||
3379: l_trxnextension.instrument_security_code

Line 3381: fnd_log.STRING (fnd_log.level_statement,

3377: l_api_name,
3378: '500: l_TrxnExtension.instrument_security_code : ' ||
3379: l_trxnextension.instrument_security_code
3380: );
3381: fnd_log.STRING (fnd_log.level_statement,
3382: g_module ||
3383: l_api_name,
3384: '500: l_payer.Payment_Function : ' ||
3385: 'CUSTOMER_PAYMENT'

Line 3387: fnd_log.STRING (fnd_log.level_statement,

3383: l_api_name,
3384: '500: l_payer.Payment_Function : ' ||
3385: 'CUSTOMER_PAYMENT'
3386: );
3387: fnd_log.STRING (fnd_log.level_statement,
3388: g_module ||
3389: l_api_name,
3390: '500: l_payer.Party_Id : ' ||
3391: l_payer.party_id

Line 3393: fnd_log.STRING (fnd_log.level_statement,

3389: l_api_name,
3390: '500: l_payer.Party_Id : ' ||
3391: l_payer.party_id
3392: );
3393: fnd_log.STRING (fnd_log.level_statement,
3394: g_module ||
3395: l_api_name,
3396: '500: l_payer.cust_account_id : ' ||
3397: l_payer.cust_account_id

Line 3399: fnd_log.STRING (fnd_log.level_statement,

3395: l_api_name,
3396: '500: l_payer.cust_account_id : ' ||
3397: l_payer.cust_account_id
3398: );
3399: fnd_log.STRING (fnd_log.level_statement,
3400: g_module ||
3401: l_api_name,
3402: '500: p_commit : ' ||
3403: p_commit

Line 3405: fnd_log.STRING (fnd_log.level_statement,

3401: l_api_name,
3402: '500: p_commit : ' ||
3403: p_commit
3404: );
3405: fnd_log.STRING (fnd_log.level_statement,
3406: g_module ||
3407: l_api_name,
3408: '500: p_payer_equivalency : ' ||
3409: iby_fndcpt_common_pub.g_payer_equiv_full

Line 3411: fnd_log.STRING (fnd_log.level_statement,

3407: l_api_name,
3408: '500: p_payer_equivalency : ' ||
3409: iby_fndcpt_common_pub.g_payer_equiv_full
3410: );
3411: fnd_log.STRING (fnd_log.level_statement,
3412: g_module ||
3413: l_api_name,
3414: '500: p_pmt_channel : ' ||
3415: iby_fndcpt_setup_pub.g_channel_credit_card

Line 3417: fnd_log.STRING (fnd_log.level_statement,

3413: l_api_name,
3414: '500: p_pmt_channel : ' ||
3415: iby_fndcpt_setup_pub.g_channel_credit_card
3416: );
3417: fnd_log.STRING (fnd_log.level_statement,
3418: g_module ||
3419: l_api_name,
3420: '500: p_instr_assignment : ' ||
3421: l_instr_assignment_id

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

3451: dbms_output.put_line(' l_response.result_message : '|| l_response.result_message);
3452: */
3453:
3454: -- debug log
3455: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3456: fnd_log.STRING
3457: (fnd_log.level_statement,
3458: g_module ||
3459: l_api_name,

Line 3456: fnd_log.STRING

3452: */
3453:
3454: -- debug log
3455: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3456: fnd_log.STRING
3457: (fnd_log.level_statement,
3458: g_module ||
3459: l_api_name,
3460: '600: After Calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension'

Line 3457: (fnd_log.level_statement,

3453:
3454: -- debug log
3455: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3456: fnd_log.STRING
3457: (fnd_log.level_statement,
3458: g_module ||
3459: l_api_name,
3460: '600: After Calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension'
3461: );

Line 3462: fnd_log.STRING (fnd_log.level_statement,

3458: g_module ||
3459: l_api_name,
3460: '600: After Calling IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension'
3461: );
3462: fnd_log.STRING (fnd_log.level_statement,
3463: g_module ||
3464: l_api_name,
3465: '600: x_return_status : ' ||
3466: x_return_status

Line 3468: fnd_log.STRING (fnd_log.level_statement,

3464: l_api_name,
3465: '600: x_return_status : ' ||
3466: x_return_status
3467: );
3468: fnd_log.STRING (fnd_log.level_statement,
3469: g_module ||
3470: l_api_name,
3471: '600: x_new_txn_entension_id : ' ||
3472: x_new_txn_entension_id

Line 3474: fnd_log.STRING (fnd_log.level_statement,

3470: l_api_name,
3471: '600: x_new_txn_entension_id : ' ||
3472: x_new_txn_entension_id
3473: );
3474: fnd_log.STRING (fnd_log.level_statement,
3475: g_module ||
3476: l_api_name,
3477: '600: x_msg_count : ' ||
3478: x_msg_count

Line 3480: fnd_log.STRING (fnd_log.level_statement,

3476: l_api_name,
3477: '600: x_msg_count : ' ||
3478: x_msg_count
3479: );
3480: fnd_log.STRING (fnd_log.level_statement,
3481: g_module ||
3482: l_api_name,
3483: '600: x_response.result_code : ' ||
3484: l_response.result_code

Line 3486: fnd_log.STRING (fnd_log.level_statement,

3482: l_api_name,
3483: '600: x_response.result_code : ' ||
3484: l_response.result_code
3485: );
3486: fnd_log.STRING (fnd_log.level_statement,
3487: g_module ||
3488: l_api_name,
3489: '600: x_response.result_category : ' ||
3490: l_response.result_category

Line 3492: fnd_log.STRING (fnd_log.level_statement,

3488: l_api_name,
3489: '600: x_response.result_category : ' ||
3490: l_response.result_category
3491: );
3492: fnd_log.STRING (fnd_log.level_statement,
3493: g_module ||
3494: l_api_name,
3495: '600: x_response.result_message : ' ||
3496: l_response.result_message

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

3515: RAISE fnd_api.g_exc_error;
3516: END IF;
3517:
3518: -- end debug log
3519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3520: fnd_log.STRING (fnd_log.level_procedure,
3521: g_module ||
3522: l_api_name,
3523: '1000: Leaving ' ||

Line 3520: fnd_log.STRING (fnd_log.level_procedure,

3516: END IF;
3517:
3518: -- end debug log
3519: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3520: fnd_log.STRING (fnd_log.level_procedure,
3521: g_module ||
3522: l_api_name,
3523: '1000: Leaving ' ||
3524: g_pkg_name ||

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

3527: );
3528: END IF;
3529: EXCEPTION
3530: WHEN fnd_api.g_exc_error THEN
3531: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3532: fnd_log.STRING (fnd_log.level_procedure,
3533: g_module ||
3534: l_api_name,
3535: '2000: Leaving ' ||

Line 3532: fnd_log.STRING (fnd_log.level_procedure,

3528: END IF;
3529: EXCEPTION
3530: WHEN fnd_api.g_exc_error THEN
3531: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3532: fnd_log.STRING (fnd_log.level_procedure,
3533: g_module ||
3534: l_api_name,
3535: '2000: Leaving ' ||
3536: g_pkg_name ||

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

3544: p_count => x_msg_count,
3545: p_data => x_msg_data
3546: );
3547: WHEN fnd_api.g_exc_unexpected_error THEN
3548: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3549: fnd_log.STRING (fnd_log.level_procedure,
3550: g_module ||
3551: l_api_name,
3552: '3000: Leaving ' ||

Line 3549: fnd_log.STRING (fnd_log.level_procedure,

3545: p_data => x_msg_data
3546: );
3547: WHEN fnd_api.g_exc_unexpected_error THEN
3548: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3549: fnd_log.STRING (fnd_log.level_procedure,
3550: g_module ||
3551: l_api_name,
3552: '3000: Leaving ' ||
3553: g_pkg_name ||

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

3561: p_count => x_msg_count,
3562: p_data => x_msg_data
3563: );
3564: WHEN OTHERS THEN
3565: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3566: fnd_log.STRING (fnd_log.level_procedure,
3567: g_module ||
3568: l_api_name,
3569: '4000: Leaving ' ||

Line 3566: fnd_log.STRING (fnd_log.level_procedure,

3562: p_data => x_msg_data
3563: );
3564: WHEN OTHERS THEN
3565: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3566: fnd_log.STRING (fnd_log.level_procedure,
3567: g_module ||
3568: l_api_name,
3569: '4000: Leaving ' ||
3570: g_pkg_name ||

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

3644: WHERE gcd.user_id = fnd.user_id
3645: AND gcd.cdt_type = 'MDT';
3646: BEGIN
3647: -- start debug log
3648: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3649: fnd_log.STRING (fnd_log.level_procedure,
3650: g_module ||
3651: l_api_name,
3652: '100: Entered ' ||

Line 3649: fnd_log.STRING (fnd_log.level_procedure,

3645: AND gcd.cdt_type = 'MDT';
3646: BEGIN
3647: -- start debug log
3648: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3649: fnd_log.STRING (fnd_log.level_procedure,
3650: g_module ||
3651: l_api_name,
3652: '100: Entered ' ||
3653: g_pkg_name ||

Line 3657: fnd_log.STRING (fnd_log.level_procedure,

3653: g_pkg_name ||
3654: '.' ||
3655: l_api_name
3656: );
3657: fnd_log.STRING (fnd_log.level_procedure,
3658: g_module ||
3659: l_api_name,
3660: '100: ******* Parameters ********'
3661: );

Line 3662: fnd_log.STRING (fnd_log.level_procedure,

3658: g_module ||
3659: l_api_name,
3660: '100: ******* Parameters ********'
3661: );
3662: fnd_log.STRING (fnd_log.level_procedure,
3663: g_module ||
3664: l_api_name,
3665: '100: p_chr_id : ' ||
3666: p_chr_id

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

3726:
3727: CLOSE csr_global_helpdesk;
3728:
3729: -- end debug log
3730: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3731: fnd_log.STRING (fnd_log.level_procedure,
3732: g_module ||
3733: l_api_name,
3734: '1000: Leaving ' ||

Line 3731: fnd_log.STRING (fnd_log.level_procedure,

3727: CLOSE csr_global_helpdesk;
3728:
3729: -- end debug log
3730: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3731: fnd_log.STRING (fnd_log.level_procedure,
3732: g_module ||
3733: l_api_name,
3734: '1000: Leaving ' ||
3735: g_pkg_name ||

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

3738: );
3739: END IF;
3740: EXCEPTION
3741: WHEN fnd_api.g_exc_error THEN
3742: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3743: fnd_log.STRING (fnd_log.level_procedure,
3744: g_module ||
3745: l_api_name,
3746: '2000: Leaving ' ||

Line 3743: fnd_log.STRING (fnd_log.level_procedure,

3739: END IF;
3740: EXCEPTION
3741: WHEN fnd_api.g_exc_error THEN
3742: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3743: fnd_log.STRING (fnd_log.level_procedure,
3744: g_module ||
3745: l_api_name,
3746: '2000: Leaving ' ||
3747: g_pkg_name ||

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

3755: p_count => x_msg_count,
3756: p_data => x_msg_data
3757: );
3758: WHEN fnd_api.g_exc_unexpected_error THEN
3759: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3760: fnd_log.STRING (fnd_log.level_procedure,
3761: g_module ||
3762: l_api_name,
3763: '3000: Leaving ' ||

Line 3760: fnd_log.STRING (fnd_log.level_procedure,

3756: p_data => x_msg_data
3757: );
3758: WHEN fnd_api.g_exc_unexpected_error THEN
3759: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3760: fnd_log.STRING (fnd_log.level_procedure,
3761: g_module ||
3762: l_api_name,
3763: '3000: Leaving ' ||
3764: g_pkg_name ||

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

3772: p_count => x_msg_count,
3773: p_data => x_msg_data
3774: );
3775: WHEN OTHERS THEN
3776: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3777: fnd_log.STRING (fnd_log.level_procedure,
3778: g_module ||
3779: l_api_name,
3780: '4000: Leaving ' ||

Line 3777: fnd_log.STRING (fnd_log.level_procedure,

3773: p_data => x_msg_data
3774: );
3775: WHEN OTHERS THEN
3776: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3777: fnd_log.STRING (fnd_log.level_procedure,
3778: g_module ||
3779: l_api_name,
3780: '4000: Leaving ' ||
3781: g_pkg_name ||

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

3827: l_payer l_payer_type;
3828: l_response iby_fndcpt_common_pub.result_rec_type;
3829: BEGIN
3830: -- start debug log
3831: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3832: fnd_log.STRING (fnd_log.level_procedure,
3833: g_module ||
3834: l_api_name,
3835: '100: Entered ' ||

Line 3832: fnd_log.STRING (fnd_log.level_procedure,

3828: l_response iby_fndcpt_common_pub.result_rec_type;
3829: BEGIN
3830: -- start debug log
3831: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
3832: fnd_log.STRING (fnd_log.level_procedure,
3833: g_module ||
3834: l_api_name,
3835: '100: Entered ' ||
3836: g_pkg_name ||

Line 3840: fnd_log.STRING (fnd_log.level_procedure,

3836: g_pkg_name ||
3837: '.' ||
3838: l_api_name
3839: );
3840: fnd_log.STRING (fnd_log.level_procedure,
3841: g_module ||
3842: l_api_name,
3843: '100: ******* Parameters ********'
3844: );

Line 3845: fnd_log.STRING (fnd_log.level_procedure,

3841: g_module ||
3842: l_api_name,
3843: '100: ******* Parameters ********'
3844: );
3845: fnd_log.STRING (fnd_log.level_procedure,
3846: g_module ||
3847: l_api_name,
3848: '100: p_chr_id : ' ||
3849: p_chr_id

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

3868: l_payer.party_id := l_party_id;
3869: l_payer.cust_account_id := l_cust_account_id;
3870:
3871: -- debug log
3872: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3873: fnd_log.STRING (fnd_log.level_statement,
3874: g_module ||
3875: l_api_name,
3876: '150: Found old txn extension id : ' ||

Line 3873: fnd_log.STRING (fnd_log.level_statement,

3869: l_payer.cust_account_id := l_cust_account_id;
3870:
3871: -- debug log
3872: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3873: fnd_log.STRING (fnd_log.level_statement,
3874: g_module ||
3875: l_api_name,
3876: '150: Found old txn extension id : ' ||
3877: l_trxn_extension_id

Line 3879: fnd_log.STRING

3875: l_api_name,
3876: '150: Found old txn extension id : ' ||
3877: l_trxn_extension_id
3878: );
3879: fnd_log.STRING
3880: (fnd_log.level_statement,
3881: g_module ||
3882: l_api_name,
3883: '150: ***** Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'

Line 3880: (fnd_log.level_statement,

3876: '150: Found old txn extension id : ' ||
3877: l_trxn_extension_id
3878: );
3879: fnd_log.STRING
3880: (fnd_log.level_statement,
3881: g_module ||
3882: l_api_name,
3883: '150: ***** Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3884: );

Line 3885: fnd_log.STRING (fnd_log.level_statement,

3881: g_module ||
3882: l_api_name,
3883: '150: ***** Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3884: );
3885: fnd_log.STRING (fnd_log.level_statement,
3886: g_module ||
3887: l_api_name,
3888: '150: ***** Parameters *****'
3889: );

Line 3890: fnd_log.STRING (fnd_log.level_statement,

3886: g_module ||
3887: l_api_name,
3888: '150: ***** Parameters *****'
3889: );
3890: fnd_log.STRING (fnd_log.level_statement,
3891: g_module ||
3892: l_api_name,
3893: '150: l_payer.Payment_Function : ' ||
3894: 'CUSTOMER_PAYMENT'

Line 3896: fnd_log.STRING (fnd_log.level_statement,

3892: l_api_name,
3893: '150: l_payer.Payment_Function : ' ||
3894: 'CUSTOMER_PAYMENT'
3895: );
3896: fnd_log.STRING (fnd_log.level_statement,
3897: g_module ||
3898: l_api_name,
3899: '150: l_payer.Party_Id : ' ||
3900: l_payer.party_id

Line 3902: fnd_log.STRING (fnd_log.level_statement,

3898: l_api_name,
3899: '150: l_payer.Party_Id : ' ||
3900: l_payer.party_id
3901: );
3902: fnd_log.STRING (fnd_log.level_statement,
3903: g_module ||
3904: l_api_name,
3905: '150: l_payer.cust_account_id : ' ||
3906: l_payer.cust_account_id

Line 3908: fnd_log.STRING (fnd_log.level_statement,

3904: l_api_name,
3905: '150: l_payer.cust_account_id : ' ||
3906: l_payer.cust_account_id
3907: );
3908: fnd_log.STRING (fnd_log.level_statement,
3909: g_module ||
3910: l_api_name,
3911: '150: l_trxn_extension_id : ' ||
3912: l_trxn_extension_id

Line 3914: fnd_log.STRING (fnd_log.level_statement,

3910: l_api_name,
3911: '150: l_trxn_extension_id : ' ||
3912: l_trxn_extension_id
3913: );
3914: fnd_log.STRING (fnd_log.level_statement,
3915: g_module ||
3916: l_api_name,
3917: '150: p_commit : ' ||
3918: p_commit

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

3932: x_response => l_response
3933: );
3934:
3935: -- debug log
3936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3937: fnd_log.STRING
3938: (fnd_log.level_statement,
3939: g_module ||
3940: l_api_name,

Line 3937: fnd_log.STRING

3933: );
3934:
3935: -- debug log
3936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3937: fnd_log.STRING
3938: (fnd_log.level_statement,
3939: g_module ||
3940: l_api_name,
3941: '200: ***** After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'

Line 3938: (fnd_log.level_statement,

3934:
3935: -- debug log
3936: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
3937: fnd_log.STRING
3938: (fnd_log.level_statement,
3939: g_module ||
3940: l_api_name,
3941: '200: ***** After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3942: );

Line 3943: fnd_log.STRING (fnd_log.level_statement,

3939: g_module ||
3940: l_api_name,
3941: '200: ***** After Calling IBY_FNDCPT_TRXN_PUB.Delete_Transaction_Extension *****'
3942: );
3943: fnd_log.STRING (fnd_log.level_statement,
3944: g_module ||
3945: l_api_name,
3946: '200: x_return_status : ' ||
3947: x_return_status

Line 3949: fnd_log.STRING (fnd_log.level_statement,

3945: l_api_name,
3946: '200: x_return_status : ' ||
3947: x_return_status
3948: );
3949: fnd_log.STRING (fnd_log.level_statement,
3950: g_module ||
3951: l_api_name,
3952: '200: x_msg_count : ' ||
3953: x_msg_count

Line 3955: fnd_log.STRING (fnd_log.level_statement,

3951: l_api_name,
3952: '200: x_msg_count : ' ||
3953: x_msg_count
3954: );
3955: fnd_log.STRING (fnd_log.level_statement,
3956: g_module ||
3957: l_api_name,
3958: '200: x_response.result_code : ' ||
3959: l_response.result_code

Line 3961: fnd_log.STRING (fnd_log.level_statement,

3957: l_api_name,
3958: '200: x_response.result_code : ' ||
3959: l_response.result_code
3960: );
3961: fnd_log.STRING (fnd_log.level_statement,
3962: g_module ||
3963: l_api_name,
3964: '200: x_response.result_category : ' ||
3965: l_response.result_category

Line 3967: fnd_log.STRING (fnd_log.level_statement,

3963: l_api_name,
3964: '200: x_response.result_category : ' ||
3965: l_response.result_category
3966: );
3967: fnd_log.STRING (fnd_log.level_statement,
3968: g_module ||
3969: l_api_name,
3970: '200: x_response.result_message : ' ||
3971: l_response.result_message

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

4003:
4004: CLOSE csr_old_txn_id;
4005:
4006: -- end debug log
4007: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4008: fnd_log.STRING (fnd_log.level_procedure,
4009: g_module ||
4010: l_api_name,
4011: '1000: Leaving ' ||

Line 4008: fnd_log.STRING (fnd_log.level_procedure,

4004: CLOSE csr_old_txn_id;
4005:
4006: -- end debug log
4007: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4008: fnd_log.STRING (fnd_log.level_procedure,
4009: g_module ||
4010: l_api_name,
4011: '1000: Leaving ' ||
4012: g_pkg_name ||

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

4015: );
4016: END IF;
4017: EXCEPTION
4018: WHEN fnd_api.g_exc_error THEN
4019: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4020: fnd_log.STRING (fnd_log.level_procedure,
4021: g_module ||
4022: l_api_name,
4023: '2000: Leaving ' ||

Line 4020: fnd_log.STRING (fnd_log.level_procedure,

4016: END IF;
4017: EXCEPTION
4018: WHEN fnd_api.g_exc_error THEN
4019: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4020: fnd_log.STRING (fnd_log.level_procedure,
4021: g_module ||
4022: l_api_name,
4023: '2000: Leaving ' ||
4024: g_pkg_name ||

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

4032: p_count => x_msg_count,
4033: p_data => x_msg_data
4034: );
4035: WHEN fnd_api.g_exc_unexpected_error THEN
4036: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4037: fnd_log.STRING (fnd_log.level_procedure,
4038: g_module ||
4039: l_api_name,
4040: '3000: Leaving ' ||

Line 4037: fnd_log.STRING (fnd_log.level_procedure,

4033: p_data => x_msg_data
4034: );
4035: WHEN fnd_api.g_exc_unexpected_error THEN
4036: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4037: fnd_log.STRING (fnd_log.level_procedure,
4038: g_module ||
4039: l_api_name,
4040: '3000: Leaving ' ||
4041: g_pkg_name ||

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

4049: p_count => x_msg_count,
4050: p_data => x_msg_data
4051: );
4052: WHEN OTHERS THEN
4053: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4054: fnd_log.STRING (fnd_log.level_procedure,
4055: g_module ||
4056: l_api_name,
4057: '4000: Leaving ' ||

Line 4054: fnd_log.STRING (fnd_log.level_procedure,

4050: p_data => x_msg_data
4051: );
4052: WHEN OTHERS THEN
4053: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
4054: fnd_log.STRING (fnd_log.level_procedure,
4055: g_module ||
4056: l_api_name,
4057: '4000: Leaving ' ||
4058: g_pkg_name ||