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

APPS.AR_GTA_CONC_PROG dependencies on FND_LOG

Line 59: --| Item_Eport for adding fnd log |

55: --| 01-Dec-2005: Qiang Li Use function Get_AR_Batch_Source_Name
56: --| to translate source id to source name
57: --| in Run_AR_GT_Mapping procedure |
58: --| 06-Mar-2006: Donghai Wang Update Discrepancy_Report and |
59: --| Item_Eport for adding fnd log |
60: --| 26-Apr-2006: Qiang Li Update the PROCEDURE Purge_Invoice |
61: --| 14-Sep-2006: Qiang Li Update the PROCEDURE Purge_Invoice |
62: --| 20-Jul-2009: Yao Zhang Add procedure Consolidate_Invoices |
63: --| |

Line 146: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

142: l_org_id NUMBER := mo_global.get_current_org_id;
143:
144: BEGIN
145: --begin procedure
146: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
147: THEN
148: fnd_log.STRING(fnd_log.level_procedure
149: ,g_module_prefix || l_procedure_name
150: ,'Begin Procedure. ');

Line 148: fnd_log.STRING(fnd_log.level_procedure

144: BEGIN
145: --begin procedure
146: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
147: THEN
148: fnd_log.STRING(fnd_log.level_procedure
149: ,g_module_prefix || l_procedure_name
150: ,'Begin Procedure. ');
151: END IF;
152:

Line 179: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

175: ,p_org_id => l_org_id
176: ,p_transfer_id => p_transfer_id
177: ,p_conc_parameters => l_parameters);
178:
179: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
180: THEN
181: fnd_log.STRING(fnd_log.level_procedure
182: ,g_module_prefix || l_procedure_name
183: ,'errbuf is : ' || l_errbuf || ' retcode is :' ||

Line 181: fnd_log.STRING(fnd_log.level_procedure

177: ,p_conc_parameters => l_parameters);
178:
179: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
180: THEN
181: fnd_log.STRING(fnd_log.level_procedure
182: ,g_module_prefix || l_procedure_name
183: ,'errbuf is : ' || l_errbuf || ' retcode is :' ||
184: l_retcode);
185: END IF;

Line 208: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

204: ,message => l_ar_gta_gta_not_enabled);
205: RETURN;
206: END IF;
207: -- end procedure
208: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
209: THEN
210: fnd_log.STRING(fnd_log.level_procedure
211: ,g_module_prefix || l_procedure_name
212: ,'End Procedure. ');

Line 210: fnd_log.STRING(fnd_log.level_procedure

206: END IF;
207: -- end procedure
208: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
209: THEN
210: fnd_log.STRING(fnd_log.level_procedure
211: ,g_module_prefix || l_procedure_name
212: ,'End Procedure. ');
213: END IF;
214:

Line 217: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

213: END IF;
214:
215: EXCEPTION
216: WHEN OTHERS THEN
217: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
218: THEN
219: fnd_log.STRING(fnd_log.level_unexpected
220: ,g_module_prefix || l_procedure_name ||
221: '. OTHER_EXCEPTION '

Line 219: fnd_log.STRING(fnd_log.level_unexpected

215: EXCEPTION
216: WHEN OTHERS THEN
217: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
218: THEN
219: fnd_log.STRING(fnd_log.level_unexpected
220: ,g_module_prefix || l_procedure_name ||
221: '. OTHER_EXCEPTION '
222: ,SQLCODE || SQLERRM);
223: END IF;

Line 293: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

289: l_parameter xmltype;
290: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
291: l_ar_gta_gta_not_enabled VARCHAR2(500);
292: l_no_data_message VARCHAR2(500);
293: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
294: l_proc_level NUMBER := fnd_log.level_procedure;
295: l_conc_succ BOOLEAN;
296:
297:

Line 294: l_proc_level NUMBER := fnd_log.level_procedure;

290: l_ar_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
291: l_ar_gta_gta_not_enabled VARCHAR2(500);
292: l_no_data_message VARCHAR2(500);
293: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
294: l_proc_level NUMBER := fnd_log.level_procedure;
295: l_conc_succ BOOLEAN;
296:
297:
298:

Line 320: fnd_log.STRING(l_proc_level

316:
317: --logging for debug
318: IF (l_proc_level >= l_dbg_level)
319: THEN
320: fnd_log.STRING(l_proc_level
321: ,g_module_prefix || l_procedure_name || '.begin'
322: ,'enter procedure');
323: END IF; /*IF (l_proc_level>=l_dbg_level)*/
324:

Line 444: fnd_log.STRING(l_proc_level

440:
441: --logging for debug
442: IF (l_proc_level >= l_dbg_level)
443: THEN
444: fnd_log.STRING(l_proc_level
445: ,g_module_prefix || l_procedure_name || '.end'
446: ,'end procedure');
447: END IF; /*IF (l_proc_level>=l_dbg_level)*/
448:

Line 452: IF fnd_log.level_unexpected >= l_dbg_level

448:
449: COMMIT;
450: EXCEPTION
451: WHEN OTHERS THEN
452: IF fnd_log.level_unexpected >= l_dbg_level
453: THEN
454: fnd_log.STRING(fnd_log.level_unexpected
455: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
456: ,SQLCODE || SQLERRM);

Line 454: fnd_log.STRING(fnd_log.level_unexpected

450: EXCEPTION
451: WHEN OTHERS THEN
452: IF fnd_log.level_unexpected >= l_dbg_level
453: THEN
454: fnd_log.STRING(fnd_log.level_unexpected
455: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
456: ,SQLCODE || SQLERRM);
457: END IF;
458: RAISE;

Line 524: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

520: l_ar_gta_gta_not_enabled VARCHAR2(500);
521: l_report xmltype;
522: l_parameter xmltype;
523: l_dbg_msg VARCHAR2(500);
524: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
525: l_proc_level NUMBER := fnd_log.level_procedure;
526: l_org_id NUMBER := mo_global.get_current_org_id;
527: l_conc_succ BOOLEAN;
528: BEGIN

Line 525: l_proc_level NUMBER := fnd_log.level_procedure;

521: l_report xmltype;
522: l_parameter xmltype;
523: l_dbg_msg VARCHAR2(500);
524: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
525: l_proc_level NUMBER := fnd_log.level_procedure;
526: l_org_id NUMBER := mo_global.get_current_org_id;
527: l_conc_succ BOOLEAN;
528: BEGIN
529: --logging for debug

Line 532: fnd_log.STRING(l_proc_level

528: BEGIN
529: --logging for debug
530: IF (l_proc_level >= l_dbg_level)
531: THEN
532: fnd_log.STRING(l_proc_level
533: ,g_module_prefix || l_procedure_name || '.begin'
534: ,'enter procedure');
535: END IF;
536:

Line 619: fnd_log.STRING(l_proc_level

615:
616: --logging for debug
617: IF (l_proc_level >= l_dbg_level)
618: THEN
619: fnd_log.STRING(l_proc_level
620: ,g_module_prefix || l_procedure_name || '.end'
621: ,'end procedure');
622: END IF;
623:

Line 626: IF fnd_log.level_unexpected >= l_dbg_level

622: END IF;
623:
624: EXCEPTION
625: WHEN OTHERS THEN
626: IF fnd_log.level_unexpected >= l_dbg_level
627: THEN
628: fnd_log.STRING(fnd_log.level_unexpected
629: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
630: ,SQLCODE || SQLERRM);

Line 628: fnd_log.STRING(fnd_log.level_unexpected

624: EXCEPTION
625: WHEN OTHERS THEN
626: IF fnd_log.level_unexpected >= l_dbg_level
627: THEN
628: fnd_log.STRING(fnd_log.level_unexpected
629: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
630: ,SQLCODE || SQLERRM);
631: END IF;
632: RAISE;

Line 678: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

674: l_conc_succ BOOLEAN;
675:
676: BEGIN
677: --procedure begin
678: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
679: THEN
680: fnd_log.STRING(fnd_log.level_procedure
681: ,g_module_prefix || l_procedure_name || '.begin'
682: ,'Procedure begin');

Line 680: fnd_log.STRING(fnd_log.level_procedure

676: BEGIN
677: --procedure begin
678: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
679: THEN
680: fnd_log.STRING(fnd_log.level_procedure
681: ,g_module_prefix || l_procedure_name || '.begin'
682: ,'Procedure begin');
683: END IF;
684:

Line 713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

709:
710: ar_gta_txt_operator_proc.Clear_Imp_Temp_Table;
711:
712: --procedure end
713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
714: THEN
715: fnd_log.STRING(fnd_log.level_procedure
716: ,g_module_prefix || l_procedure_name || '.end'
717: ,'Procedure end');

Line 715: fnd_log.STRING(fnd_log.level_procedure

711:
712: --procedure end
713: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
714: THEN
715: fnd_log.STRING(fnd_log.level_procedure
716: ,g_module_prefix || l_procedure_name || '.end'
717: ,'Procedure end');
718: END IF;
719:

Line 722: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

718: END IF;
719:
720: EXCEPTION
721: WHEN OTHERS THEN
722: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
723: THEN
724: fnd_log.STRING(fnd_log.level_unexpected
725: ,g_module_prefix || l_procedure_name ||
726: '.OTHER_EXCEPTION '

Line 724: fnd_log.STRING(fnd_log.level_unexpected

720: EXCEPTION
721: WHEN OTHERS THEN
722: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
723: THEN
724: fnd_log.STRING(fnd_log.level_unexpected
725: ,g_module_prefix || l_procedure_name ||
726: '.OTHER_EXCEPTION '
727: ,SQLCODE || SQLERRM);
728: END IF;

Line 817: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

813: l_conc_succ BOOLEAN;
814:
815: BEGIN
816: --procedure begin
817: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
818: THEN
819: fnd_log.STRING(fnd_log.level_procedure
820: ,g_module_prefix || l_procedure_name || '.begin'
821: ,'Procedure begin');

Line 819: fnd_log.STRING(fnd_log.level_procedure

815: BEGIN
816: --procedure begin
817: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
818: THEN
819: fnd_log.STRING(fnd_log.level_procedure
820: ,g_module_prefix || l_procedure_name || '.begin'
821: ,'Procedure begin');
822: END IF;
823:

Line 865: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

861: ,p_trx_class => p_trx_class
862: ,p_batch_id => p_batch_id
863: ,p_invoice_type_id => p_invoice_type
864: );
865: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
866: THEN
867: fnd_log.STRING(fnd_log.level_procedure
868: ,g_module_prefix || l_procedure_name || '.end'
869: ,'Procedure end');

Line 867: fnd_log.STRING(fnd_log.level_procedure

863: ,p_invoice_type_id => p_invoice_type
864: );
865: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
866: THEN
867: fnd_log.STRING(fnd_log.level_procedure
868: ,g_module_prefix || l_procedure_name || '.end'
869: ,'Procedure end');
870: END IF;
871:

Line 874: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

870: END IF;
871:
872: EXCEPTION
873: WHEN OTHERS THEN
874: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
875: THEN
876: fnd_log.STRING(fnd_log.level_unexpected
877: ,g_module_prefix || l_procedure_name ||
878: '.OTHER_EXCEPTION '

Line 876: fnd_log.STRING(fnd_log.level_unexpected

872: EXCEPTION
873: WHEN OTHERS THEN
874: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
875: THEN
876: fnd_log.STRING(fnd_log.level_unexpected
877: ,g_module_prefix || l_procedure_name ||
878: '.OTHER_EXCEPTION '
879: ,SQLCODE || SQLERRM);
880: END IF;

Line 925: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

921: l_conc_succ BOOLEAN;
922:
923: BEGIN
924: --procedure begin
925: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
926: THEN
927: fnd_log.STRING(fnd_log.level_procedure
928: ,g_module_prefix || l_procedure_name || '.begin'
929: ,'Procedure begin');

Line 927: fnd_log.STRING(fnd_log.level_procedure

923: BEGIN
924: --procedure begin
925: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
926: THEN
927: fnd_log.STRING(fnd_log.level_procedure
928: ,g_module_prefix || l_procedure_name || '.begin'
929: ,'Procedure begin');
930: END IF;
931:

Line 951: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

947: ,p_generator_id => p_generator_id
948: ,p_batch_id => p_batch_number);
949:
950: --procedure end
951: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
952: THEN
953: fnd_log.STRING(fnd_log.level_procedure
954: ,g_module_prefix || l_procedure_name || '.end'
955: ,'Procedure end');

Line 953: fnd_log.STRING(fnd_log.level_procedure

949:
950: --procedure end
951: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
952: THEN
953: fnd_log.STRING(fnd_log.level_procedure
954: ,g_module_prefix || l_procedure_name || '.end'
955: ,'Procedure end');
956: END IF;
957:

Line 960: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

956: END IF;
957:
958: EXCEPTION
959: WHEN OTHERS THEN
960: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.STRING(fnd_log.level_unexpected
963: ,g_module_prefix || l_procedure_name ||
964: '.OTHER_EXCEPTION '

Line 962: fnd_log.STRING(fnd_log.level_unexpected

958: EXCEPTION
959: WHEN OTHERS THEN
960: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
961: THEN
962: fnd_log.STRING(fnd_log.level_unexpected
963: ,g_module_prefix || l_procedure_name ||
964: '.OTHER_EXCEPTION '
965: ,SQLCODE || SQLERRM);
966: END IF;

Line 1010: -- 06-Mar-2006: Donghai Wang Add fnd log

1006: --
1007: -- CHANGE HISTORY:
1008: --
1009: -- 13-Jun-2005: Donghai Wang Created
1010: -- 06-Mar-2006: Donghai Wang Add fnd log
1011: --
1012: --==========================================================================
1013: PROCEDURE discrepancy_report
1014: (errbuf OUT NOCOPY VARCHAR2

Line 1042: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1038: l_dbg_msg VARCHAR2(500);
1039: l_ar_gta_not_enabled_msg VARCHAR2(1000);
1040: l_report_xml XMLTYPE;
1041: l_procedure_name VARCHAR2(50);
1042: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1043: l_proc_level NUMBER := fnd_log.level_procedure;
1044: l_org_id hr_all_organization_units.organization_id%TYPE;
1045: l_conc_succ BOOLEAN;
1046: BEGIN

Line 1043: l_proc_level NUMBER := fnd_log.level_procedure;

1039: l_ar_gta_not_enabled_msg VARCHAR2(1000);
1040: l_report_xml XMLTYPE;
1041: l_procedure_name VARCHAR2(50);
1042: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1043: l_proc_level NUMBER := fnd_log.level_procedure;
1044: l_org_id hr_all_organization_units.organization_id%TYPE;
1045: l_conc_succ BOOLEAN;
1046: BEGIN
1047:

Line 1055: fnd_log.STRING(l_proc_level

1051:
1052: --log for debug
1053: IF (l_proc_level >= l_dbg_level)
1054: THEN
1055: fnd_log.STRING(l_proc_level
1056: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1057: ,'Enter procedure');
1058:
1059: fnd_log.STRING(l_proc_level

Line 1059: fnd_log.STRING(l_proc_level

1055: fnd_log.STRING(l_proc_level
1056: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1057: ,'Enter procedure');
1058:
1059: fnd_log.STRING(l_proc_level
1060: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1061: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
1062:
1063: fnd_log.STRING(l_proc_level

Line 1063: fnd_log.STRING(l_proc_level

1059: fnd_log.STRING(l_proc_level
1060: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1061: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
1062:
1063: fnd_log.STRING(l_proc_level
1064: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1065: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
1066:
1067: fnd_log.STRING(l_proc_level

Line 1067: fnd_log.STRING(l_proc_level

1063: fnd_log.STRING(l_proc_level
1064: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1065: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
1066:
1067: fnd_log.STRING(l_proc_level
1068: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1069: ,'p_ar_transaction_type '||p_ar_transaction_type);
1070:
1071: fnd_log.STRING(l_proc_level

Line 1071: fnd_log.STRING(l_proc_level

1067: fnd_log.STRING(l_proc_level
1068: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1069: ,'p_ar_transaction_type '||p_ar_transaction_type);
1070:
1071: fnd_log.STRING(l_proc_level
1072: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1073: ,'p_cust_num_from '||p_cust_num_from);
1074:
1075: fnd_log.STRING(l_proc_level

Line 1075: fnd_log.STRING(l_proc_level

1071: fnd_log.STRING(l_proc_level
1072: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1073: ,'p_cust_num_from '||p_cust_num_from);
1074:
1075: fnd_log.STRING(l_proc_level
1076: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1077: ,'p_cust_num_to '||p_cust_num_to);
1078:
1079: fnd_log.STRING(l_proc_level

Line 1079: fnd_log.STRING(l_proc_level

1075: fnd_log.STRING(l_proc_level
1076: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1077: ,'p_cust_num_to '||p_cust_num_to);
1078:
1079: fnd_log.STRING(l_proc_level
1080: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1081: ,'p_cust_name_id '||p_cust_name_id);
1082:
1083: fnd_log.STRING(l_proc_level

Line 1083: fnd_log.STRING(l_proc_level

1079: fnd_log.STRING(l_proc_level
1080: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1081: ,'p_cust_name_id '||p_cust_name_id);
1082:
1083: fnd_log.STRING(l_proc_level
1084: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1085: ,'p_gl_period '||p_gl_period);
1086:
1087: fnd_log.STRING(l_proc_level

Line 1087: fnd_log.STRING(l_proc_level

1083: fnd_log.STRING(l_proc_level
1084: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1085: ,'p_gl_period '||p_gl_period);
1086:
1087: fnd_log.STRING(l_proc_level
1088: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1089: ,'p_gl_date_from '||p_gl_date_from);
1090:
1091: fnd_log.STRING(l_proc_level

Line 1091: fnd_log.STRING(l_proc_level

1087: fnd_log.STRING(l_proc_level
1088: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1089: ,'p_gl_date_from '||p_gl_date_from);
1090:
1091: fnd_log.STRING(l_proc_level
1092: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1093: ,'p_gl_date_to '||p_gl_date_to);
1094:
1095: fnd_log.STRING(l_proc_level

Line 1095: fnd_log.STRING(l_proc_level

1091: fnd_log.STRING(l_proc_level
1092: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1093: ,'p_gl_date_to '||p_gl_date_to);
1094:
1095: fnd_log.STRING(l_proc_level
1096: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1097: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
1098:
1099: fnd_log.STRING(l_proc_level

Line 1099: fnd_log.STRING(l_proc_level

1095: fnd_log.STRING(l_proc_level
1096: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1097: ,'p_ar_trx_batch_from '||p_ar_trx_batch_from);
1098:
1099: fnd_log.STRING(l_proc_level
1100: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1101: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
1102:
1103: fnd_log.STRING(l_proc_level

Line 1103: fnd_log.STRING(l_proc_level

1099: fnd_log.STRING(l_proc_level
1100: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1101: ,'p_ar_trx_batch_to '||p_ar_trx_batch_to);
1102:
1103: fnd_log.STRING(l_proc_level
1104: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1105: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
1106:
1107: fnd_log.STRING(l_proc_level

Line 1107: fnd_log.STRING(l_proc_level

1103: fnd_log.STRING(l_proc_level
1104: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1105: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
1106:
1107: fnd_log.STRING(l_proc_level
1108: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1109: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
1110:
1111: fnd_log.STRING(l_proc_level

Line 1111: fnd_log.STRING(l_proc_level

1107: fnd_log.STRING(l_proc_level
1108: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1109: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
1110:
1111: fnd_log.STRING(l_proc_level
1112: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1113: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
1114:
1115: fnd_log.STRING(l_proc_level

Line 1115: fnd_log.STRING(l_proc_level

1111: fnd_log.STRING(l_proc_level
1112: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1113: ,'p_ar_trx_date_from '||p_ar_trx_date_from);
1114:
1115: fnd_log.STRING(l_proc_level
1116: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1117: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
1118:
1119: fnd_log.STRING(l_proc_level

Line 1119: fnd_log.STRING(l_proc_level

1115: fnd_log.STRING(l_proc_level
1116: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1117: ,'p_ar_trx_date_to '||p_ar_trx_date_to);
1118:
1119: fnd_log.STRING(l_proc_level
1120: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1121: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
1122:
1123: fnd_log.STRING(l_proc_level

Line 1123: fnd_log.STRING(l_proc_level

1119: fnd_log.STRING(l_proc_level
1120: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1121: ,'p_ar_doc_num_from '||p_ar_doc_num_from);
1122:
1123: fnd_log.STRING(l_proc_level
1124: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1125: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
1126:
1127: fnd_log.STRING(l_proc_level

Line 1127: fnd_log.STRING(l_proc_level

1123: fnd_log.STRING(l_proc_level
1124: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1125: ,'p_ar_doc_num_to '||p_ar_doc_num_to);
1126:
1127: fnd_log.STRING(l_proc_level
1128: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1129: ,'p_original_curr_code '||p_original_curr_code);
1130:
1131: fnd_log.STRING(l_proc_level

Line 1131: fnd_log.STRING(l_proc_level

1127: fnd_log.STRING(l_proc_level
1128: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1129: ,'p_original_curr_code '||p_original_curr_code);
1130:
1131: fnd_log.STRING(l_proc_level
1132: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1133: ,'p_primary_sales '||p_primary_sales);
1134: END IF; --( l_proc_level >= l_dbg_level )
1135:

Line 1194: fnd_log.STRING(l_proc_level

1190:
1191: --log for debug
1192: IF (l_proc_level >= l_dbg_level)
1193: THEN
1194: fnd_log.STRING(l_proc_level
1195: ,g_module_prefix || '.' || l_procedure_name || '.end'
1196: ,'Exit procedure');
1197: END IF; --( l_proc_level >= l_dbg_level )
1198:

Line 1201: IF (fnd_log.level_unexpected >= l_dbg_level)

1197: END IF; --( l_proc_level >= l_dbg_level )
1198:
1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: IF (fnd_log.level_unexpected >= l_dbg_level)
1202: THEN
1203: fnd_log.STRING(fnd_log.level_unexpected
1204: ,g_module_prefix || l_procedure_name ||
1205: '.OTHER_EXCEPTION '

Line 1203: fnd_log.STRING(fnd_log.level_unexpected

1199: EXCEPTION
1200: WHEN OTHERS THEN
1201: IF (fnd_log.level_unexpected >= l_dbg_level)
1202: THEN
1203: fnd_log.STRING(fnd_log.level_unexpected
1204: ,g_module_prefix || l_procedure_name ||
1205: '.OTHER_EXCEPTION '
1206: ,SQLCODE || SQLERRM);
1207: END IF;

Line 1246: -- 06-Mar-2006: Donghai Wang Add fnd log

1242: --
1243: -- CHANGE HISTORY:
1244: --
1245: -- 13-Jun-2005: Donghai Wang Created
1246: -- 06-Mar-2006: Donghai Wang Add fnd log
1247: --
1248: --==========================================================================
1249: PROCEDURE item_export
1250: (errbuf OUT NOCOPY VARCHAR2

Line 1271: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1267: l_procedure_name VARCHAR2(50);
1268: l_ar_gta_enabled VARCHAR2(10);
1269: l_dbg_msg VARCHAR2(500);
1270: l_ar_gta_not_enabled_msg VARCHAR2(1000);
1271: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1272: l_proc_level NUMBER := fnd_log.level_procedure;
1273: l_org_id hr_all_organization_units.organization_id%TYPE;
1274: l_conc_succ BOOLEAN;
1275:

Line 1272: l_proc_level NUMBER := fnd_log.level_procedure;

1268: l_ar_gta_enabled VARCHAR2(10);
1269: l_dbg_msg VARCHAR2(500);
1270: l_ar_gta_not_enabled_msg VARCHAR2(1000);
1271: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1272: l_proc_level NUMBER := fnd_log.level_procedure;
1273: l_org_id hr_all_organization_units.organization_id%TYPE;
1274: l_conc_succ BOOLEAN;
1275:
1276: BEGIN

Line 1281: fnd_log.STRING(l_proc_level

1277: l_procedure_name := 'Item_Export';
1278: --log for debug
1279: IF (l_proc_level >= l_dbg_level)
1280: THEN
1281: fnd_log.STRING(l_proc_level
1282: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1283: ,'Enter procedure');
1284:
1285: fnd_log.STRING(l_proc_level

Line 1285: fnd_log.STRING(l_proc_level

1281: fnd_log.STRING(l_proc_level
1282: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1283: ,'Enter procedure');
1284:
1285: fnd_log.STRING(l_proc_level
1286: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1287: ,'p_master_org_id '||p_master_org_id);
1288:
1289: fnd_log.STRING(l_proc_level

Line 1289: fnd_log.STRING(l_proc_level

1285: fnd_log.STRING(l_proc_level
1286: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1287: ,'p_master_org_id '||p_master_org_id);
1288:
1289: fnd_log.STRING(l_proc_level
1290: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1291: ,'p_item_num_from '||p_item_num_from);
1292:
1293: fnd_log.STRING(l_proc_level

Line 1293: fnd_log.STRING(l_proc_level

1289: fnd_log.STRING(l_proc_level
1290: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1291: ,'p_item_num_from '||p_item_num_from);
1292:
1293: fnd_log.STRING(l_proc_level
1294: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1295: ,'p_item_num_to '||p_item_num_to);
1296:
1297: fnd_log.STRING(l_proc_level

Line 1297: fnd_log.STRING(l_proc_level

1293: fnd_log.STRING(l_proc_level
1294: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1295: ,'p_item_num_to '||p_item_num_to);
1296:
1297: fnd_log.STRING(l_proc_level
1298: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1299: ,'p_category_set_id '||p_category_set_id);
1300:
1301: fnd_log.STRING(l_proc_level

Line 1301: fnd_log.STRING(l_proc_level

1297: fnd_log.STRING(l_proc_level
1298: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1299: ,'p_category_set_id '||p_category_set_id);
1300:
1301: fnd_log.STRING(l_proc_level
1302: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1303: ,'p_category_structure_id '||p_category_structure_id);
1304:
1305: fnd_log.STRING(l_proc_level

Line 1305: fnd_log.STRING(l_proc_level

1301: fnd_log.STRING(l_proc_level
1302: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1303: ,'p_category_structure_id '||p_category_structure_id);
1304:
1305: fnd_log.STRING(l_proc_level
1306: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1307: ,'p_item_category_from '||p_item_category_from);
1308:
1309: fnd_log.STRING(l_proc_level

Line 1309: fnd_log.STRING(l_proc_level

1305: fnd_log.STRING(l_proc_level
1306: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1307: ,'p_item_category_from '||p_item_category_from);
1308:
1309: fnd_log.STRING(l_proc_level
1310: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1311: ,'p_item_category_to '||p_item_category_to);
1312:
1313: fnd_log.STRING(l_proc_level

Line 1313: fnd_log.STRING(l_proc_level

1309: fnd_log.STRING(l_proc_level
1310: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1311: ,'p_item_category_to '||p_item_category_to);
1312:
1313: fnd_log.STRING(l_proc_level
1314: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1315: ,'p_item_name_source '||p_item_name_source);
1316:
1317: fnd_log.STRING(l_proc_level

Line 1317: fnd_log.STRING(l_proc_level

1313: fnd_log.STRING(l_proc_level
1314: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1315: ,'p_item_name_source '||p_item_name_source);
1316:
1317: fnd_log.STRING(l_proc_level
1318: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1319: ,'p_dummy '||p_dummy);
1320:
1321: fnd_log.STRING(l_proc_level

Line 1321: fnd_log.STRING(l_proc_level

1317: fnd_log.STRING(l_proc_level
1318: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1319: ,'p_dummy '||p_dummy);
1320:
1321: fnd_log.STRING(l_proc_level
1322: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1323: ,'p_cross_reference_type '||p_cross_reference_type);
1324:
1325: fnd_log.STRING(l_proc_level

Line 1325: fnd_log.STRING(l_proc_level

1321: fnd_log.STRING(l_proc_level
1322: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1323: ,'p_cross_reference_type '||p_cross_reference_type);
1324:
1325: fnd_log.STRING(l_proc_level
1326: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1327: ,'p_item_status '||p_item_status);
1328:
1329: fnd_log.STRING(l_proc_level

Line 1329: fnd_log.STRING(l_proc_level

1325: fnd_log.STRING(l_proc_level
1326: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1327: ,'p_item_status '||p_item_status);
1328:
1329: fnd_log.STRING(l_proc_level
1330: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1331: ,'p_creation_date_from '||p_creation_date_from);
1332:
1333: fnd_log.STRING(l_proc_level

Line 1333: fnd_log.STRING(l_proc_level

1329: fnd_log.STRING(l_proc_level
1330: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1331: ,'p_creation_date_from '||p_creation_date_from);
1332:
1333: fnd_log.STRING(l_proc_level
1334: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1335: ,'p_creation_date_to '||p_creation_date_to);
1336:
1337:

Line 1382: fnd_log.STRING(l_proc_level

1378:
1379: --log for debug
1380: IF (l_proc_level >= l_dbg_level)
1381: THEN
1382: fnd_log.STRING(l_proc_level
1383: ,g_module_prefix || '.' || l_procedure_name || '.end'
1384: ,'Exit procedure');
1385: END IF; --( l_proc_level >= l_dbg_level )
1386:

Line 1389: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1385: END IF; --( l_proc_level >= l_dbg_level )
1386:
1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1390: THEN
1391: fnd_log.STRING(fnd_log.level_unexpected
1392: ,g_module_prefix || l_procedure_name ||
1393: '. OTHER_EXCEPTION '

Line 1391: fnd_log.STRING(fnd_log.level_unexpected

1387: EXCEPTION
1388: WHEN OTHERS THEN
1389: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1390: THEN
1391: fnd_log.STRING(fnd_log.level_unexpected
1392: ,g_module_prefix || l_procedure_name ||
1393: '. OTHER_EXCEPTION '
1394: ,'Unknown error' || SQLCODE || SQLERRM);
1395:

Line 1450: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1446: l_conc_succ BOOLEAN;
1447: l_org_id NUMBER := mo_global.get_current_org_id;
1448: BEGIN
1449: -- procedure begin
1450: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1451: THEN
1452: fnd_log.STRING(fnd_log.level_procedure
1453: ,g_module_prefix || l_procedure_name
1454: ,'Begin Procedure. ');

Line 1452: fnd_log.STRING(fnd_log.level_procedure

1448: BEGIN
1449: -- procedure begin
1450: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1451: THEN
1452: fnd_log.STRING(fnd_log.level_procedure
1453: ,g_module_prefix || l_procedure_name
1454: ,'Begin Procedure. ');
1455: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1456:

Line 1455: END IF; /FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL/

1451: THEN
1452: fnd_log.STRING(fnd_log.level_procedure
1453: ,g_module_prefix || l_procedure_name
1454: ,'Begin Procedure. ');
1455: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1456:
1457: IF (fnd_profile.VALUE('AR_GTA_ENABLED') = 'Y')
1458: THEN
1459: ar_gta_txt_operator_proc.export_customers(p_org_id => l_org_id

Line 1484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1480: ,message => l_ar_gta_gta_not_enabled);
1481: RETURN;
1482: END IF; /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1483: -- procedure end
1484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1485: THEN
1486: fnd_log.STRING(fnd_log.level_procedure
1487: ,g_module_prefix || l_procedure_name
1488: ,'End Procedure. ');

Line 1486: fnd_log.STRING(fnd_log.level_procedure

1482: END IF; /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1483: -- procedure end
1484: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1485: THEN
1486: fnd_log.STRING(fnd_log.level_procedure
1487: ,g_module_prefix || l_procedure_name
1488: ,'End Procedure. ');
1489: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1490:

Line 1489: END IF; /FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL/

1485: THEN
1486: fnd_log.STRING(fnd_log.level_procedure
1487: ,g_module_prefix || l_procedure_name
1488: ,'End Procedure. ');
1489: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1490:
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 1493: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1489: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1490:
1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1494: THEN
1495: fnd_log.STRING(fnd_log.level_unexpected
1496: ,g_module_prefix || l_procedure_name ||
1497: '. OTHER_EXCEPTION '

Line 1495: fnd_log.STRING(fnd_log.level_unexpected

1491: EXCEPTION
1492: WHEN OTHERS THEN
1493: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1494: THEN
1495: fnd_log.STRING(fnd_log.level_unexpected
1496: ,g_module_prefix || l_procedure_name ||
1497: '. OTHER_EXCEPTION '
1498: ,'Unknown error' || SQLCODE || SQLERRM);
1499:

Line 1541: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1537:
1538:
1539: BEGIN
1540: fnd_file.PUT_LINE(fnd_file.LOG,'Begin Procedure.'||l_procedure_name);
1541: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1542: THEN
1543: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1544: , G_MODULE_PREFIX ||'.'|| l_procedure_name
1545: ,'Begin Procedure. ');

Line 1543: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1539: BEGIN
1540: fnd_file.PUT_LINE(fnd_file.LOG,'Begin Procedure.'||l_procedure_name);
1541: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1542: THEN
1543: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1544: , G_MODULE_PREFIX ||'.'|| l_procedure_name
1545: ,'Begin Procedure. ');
1546: END IF;
1547: IF (fnd_profile.VALUE('AR_GTA_ENABLED') = 'Y')

Line 1561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1557: AR_GTA_CONSOLIDATE_PROC.Create_consol_inv(p_consolidation_paras=>l_consol_paras);
1558: --generate xml output
1559: AR_GTA_CONSOLIDATE_PROC.Generate_XML_Output(p_consolidation_paras=>l_consol_paras);
1560:
1561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1562: THEN
1563: fnd_log.STRING(fnd_log.level_procedure
1564: ,g_module_prefix || l_procedure_name
1565: ||'. OTHER_EXCEPTION ',

Line 1563: fnd_log.STRING(fnd_log.level_procedure

1559: AR_GTA_CONSOLIDATE_PROC.Generate_XML_Output(p_consolidation_paras=>l_consol_paras);
1560:
1561: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1562: THEN
1563: fnd_log.STRING(fnd_log.level_procedure
1564: ,g_module_prefix || l_procedure_name
1565: ||'. OTHER_EXCEPTION ',
1566: 'Unknown error' || SQLCODE || SQLERRM);
1567: END IF;

Line 1590: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1586: ,message => l_ar_gta_gta_not_enabled);
1587: RETURN;
1588: END IF;
1589:
1590: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1591: THEN
1592: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1593: , G_MODULE_PREFIX ||'.'|| l_procedure_name
1594: ,'End Procedure. ');

Line 1592: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1588: END IF;
1589:
1590: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1591: THEN
1592: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1593: , G_MODULE_PREFIX ||'.'|| l_procedure_name
1594: ,'End Procedure. ');
1595: END IF;
1596: EXCEPTION

Line 1598: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1594: ,'End Procedure. ');
1595: END IF;
1596: EXCEPTION
1597: WHEN OTHERS THEN
1598: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1599: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
1600: G_MODULE_PREFIX || l_procedure_name ||
1601: '. OTHER_EXCEPTION ',
1602: 'Unknown error' || SQLCODE || SQLERRM);

Line 1599: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,

1595: END IF;
1596: EXCEPTION
1597: WHEN OTHERS THEN
1598: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1599: FND_LOG.String(FND_LOG.LEVEL_UNEXPECTED,
1600: G_MODULE_PREFIX || l_procedure_name ||
1601: '. OTHER_EXCEPTION ',
1602: 'Unknown error' || SQLCODE || SQLERRM);
1603:

Line 1649: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1645: l_ar_gta_gta_not_enabled VARCHAR2(500);
1646: l_report xmltype;
1647: l_parameter xmltype;
1648: l_dbg_msg VARCHAR2(500);
1649: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1650: l_proc_level NUMBER := fnd_log.level_procedure;
1651: l_org_id NUMBER := mo_global.get_current_org_id;
1652: l_conc_succ BOOLEAN;
1653:

Line 1650: l_proc_level NUMBER := fnd_log.level_procedure;

1646: l_report xmltype;
1647: l_parameter xmltype;
1648: l_dbg_msg VARCHAR2(500);
1649: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1650: l_proc_level NUMBER := fnd_log.level_procedure;
1651: l_org_id NUMBER := mo_global.get_current_org_id;
1652: l_conc_succ BOOLEAN;
1653:
1654:

Line 1659: fnd_log.STRING(l_proc_level

1655: BEGIN
1656: --logging for debug
1657: IF (l_proc_level >= l_dbg_level)
1658: THEN
1659: fnd_log.STRING(l_proc_level
1660: ,g_module_prefix || l_procedure_name || '.begin'
1661: ,'enter procedure');
1662: END IF;
1663:

Line 1728: fnd_log.STRING(l_proc_level

1724:
1725: --logging for debug
1726: IF (l_proc_level >= l_dbg_level)
1727: THEN
1728: fnd_log.STRING(l_proc_level
1729: ,g_module_prefix || l_procedure_name || '.end'
1730: ,'end procedure');
1731: END IF;
1732:

Line 1735: IF fnd_log.level_unexpected >= l_dbg_level

1731: END IF;
1732:
1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: IF fnd_log.level_unexpected >= l_dbg_level
1736: THEN
1737: fnd_log.STRING(fnd_log.level_unexpected
1738: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
1739: ,SQLCODE || SQLERRM);

Line 1737: fnd_log.STRING(fnd_log.level_unexpected

1733: EXCEPTION
1734: WHEN OTHERS THEN
1735: IF fnd_log.level_unexpected >= l_dbg_level
1736: THEN
1737: fnd_log.STRING(fnd_log.level_unexpected
1738: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
1739: ,SQLCODE || SQLERRM);
1740: END IF;
1741: RAISE;

Line 1784: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1780: l_org_id NUMBER := mo_global.get_current_org_id;
1781:
1782: BEGIN
1783: --procedure begin
1784: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1785: THEN
1786: fnd_log.STRING(fnd_log.level_procedure
1787: ,g_module_prefix || l_procedure_name || '.begin'
1788: ,'Procedure begin');

Line 1786: fnd_log.STRING(fnd_log.level_procedure

1782: BEGIN
1783: --procedure begin
1784: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1785: THEN
1786: fnd_log.STRING(fnd_log.level_procedure
1787: ,g_module_prefix || l_procedure_name || '.begin'
1788: ,'Procedure begin');
1789: END IF;
1790:

Line 1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1806:
1807: ar_gta_trx_util.Populate_Invoice_Type(l_org_id);
1808:
1809: --procedure end
1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1811: THEN
1812: fnd_log.STRING(fnd_log.level_procedure
1813: ,g_module_prefix || l_procedure_name || '.end'
1814: ,'Procedure end');

Line 1812: fnd_log.STRING(fnd_log.level_procedure

1808:
1809: --procedure end
1810: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1811: THEN
1812: fnd_log.STRING(fnd_log.level_procedure
1813: ,g_module_prefix || l_procedure_name || '.end'
1814: ,'Procedure end');
1815: END IF;
1816:

Line 1819: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1815: END IF;
1816:
1817: EXCEPTION
1818: WHEN OTHERS THEN
1819: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1820: THEN
1821: fnd_log.STRING(fnd_log.level_unexpected
1822: ,g_module_prefix || l_procedure_name ||
1823: '.OTHER_EXCEPTION '

Line 1821: fnd_log.STRING(fnd_log.level_unexpected

1817: EXCEPTION
1818: WHEN OTHERS THEN
1819: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1820: THEN
1821: fnd_log.STRING(fnd_log.level_unexpected
1822: ,g_module_prefix || l_procedure_name ||
1823: '.OTHER_EXCEPTION '
1824: ,SQLCODE || SQLERRM);
1825: END IF;

Line 1869: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1865: l_org_id NUMBER := mo_global.get_current_org_id;
1866:
1867: BEGIN
1868: --procedure begin
1869: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1870: THEN
1871: fnd_log.STRING(fnd_log.level_procedure
1872: ,g_module_prefix || l_procedure_name || '.begin'
1873: ,'Procedure begin');

Line 1871: fnd_log.STRING(fnd_log.level_procedure

1867: BEGIN
1868: --procedure begin
1869: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1870: THEN
1871: fnd_log.STRING(fnd_log.level_procedure
1872: ,g_module_prefix || l_procedure_name || '.begin'
1873: ,'Procedure begin');
1874: END IF;
1875:

Line 1895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

1891:
1892: ar_gta_trx_util.Populate_Invoice_Type_Header(l_org_id);
1893:
1894: --procedure end
1895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1896: THEN
1897: fnd_log.STRING(fnd_log.level_procedure
1898: ,g_module_prefix || l_procedure_name || '.end'
1899: ,'Procedure end');

Line 1897: fnd_log.STRING(fnd_log.level_procedure

1893:
1894: --procedure end
1895: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1896: THEN
1897: fnd_log.STRING(fnd_log.level_procedure
1898: ,g_module_prefix || l_procedure_name || '.end'
1899: ,'Procedure end');
1900: END IF;
1901:

Line 1904: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

1900: END IF;
1901:
1902: EXCEPTION
1903: WHEN OTHERS THEN
1904: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1905: THEN
1906: fnd_log.STRING(fnd_log.level_unexpected
1907: ,g_module_prefix || l_procedure_name ||
1908: '.OTHER_EXCEPTION '

Line 1906: fnd_log.STRING(fnd_log.level_unexpected

1902: EXCEPTION
1903: WHEN OTHERS THEN
1904: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1905: THEN
1906: fnd_log.STRING(fnd_log.level_unexpected
1907: ,g_module_prefix || l_procedure_name ||
1908: '.OTHER_EXCEPTION '
1909: ,SQLCODE || SQLERRM);
1910: END IF;