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

APPS.JMF_GTA_CONC_PROG dependencies on FND_LOG

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

51: --| 01-Dec-2005: Qiang Li Use function Get_AR_Batch_Source_Name
52: --| to translate source id to source name
53: --| in Run_AR_GT_Mapping procedure |
54: --| 06-Mar-2006: Donghai Wang Update Discrepancy_Report and |
55: --| Item_Eport for adding fnd log |
56: --| 26-Apr-2006: Qiang Li Update the PROCEDURE Purge_Invoice |
57: --| 14-Sep-2006: Qiang Li Update the PROCEDURE Purge_Invoice | |
58: --+======================================================================*/
59:

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

123: l_org_id NUMBER := mo_global.get_current_org_id;
124:
125: BEGIN
126: --begin procedure
127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
128: THEN
129: fnd_log.STRING(fnd_log.level_procedure
130: ,g_module_prefix || l_procedure_name
131: ,'Begin Procedure. ');

Line 129: fnd_log.STRING(fnd_log.level_procedure

125: BEGIN
126: --begin procedure
127: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
128: THEN
129: fnd_log.STRING(fnd_log.level_procedure
130: ,g_module_prefix || l_procedure_name
131: ,'Begin Procedure. ');
132: END IF;
133:

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

156: ,p_org_id => l_org_id
157: ,p_transfer_id => p_transfer_id
158: ,p_conc_parameters => l_parameters);
159:
160: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
161: THEN
162: fnd_log.STRING(fnd_log.level_procedure
163: ,g_module_prefix || l_procedure_name
164: ,'errbuf is : ' || l_errbuf || ' retcode is :' ||

Line 162: fnd_log.STRING(fnd_log.level_procedure

158: ,p_conc_parameters => l_parameters);
159:
160: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
161: THEN
162: fnd_log.STRING(fnd_log.level_procedure
163: ,g_module_prefix || l_procedure_name
164: ,'errbuf is : ' || l_errbuf || ' retcode is :' ||
165: l_retcode);
166: END IF;

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

185: ,message => l_jmf_gta_gta_not_enabled);
186: RETURN;
187: END IF;
188: -- end procedure
189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
190: THEN
191: fnd_log.STRING(fnd_log.level_procedure
192: ,g_module_prefix || l_procedure_name
193: ,'End Procedure. ');

Line 191: fnd_log.STRING(fnd_log.level_procedure

187: END IF;
188: -- end procedure
189: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
190: THEN
191: fnd_log.STRING(fnd_log.level_procedure
192: ,g_module_prefix || l_procedure_name
193: ,'End Procedure. ');
194: END IF;
195:

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

194: END IF;
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
199: THEN
200: fnd_log.STRING(fnd_log.level_unexpected
201: ,g_module_prefix || l_procedure_name ||
202: '. OTHER_EXCEPTION '

Line 200: fnd_log.STRING(fnd_log.level_unexpected

196: EXCEPTION
197: WHEN OTHERS THEN
198: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
199: THEN
200: fnd_log.STRING(fnd_log.level_unexpected
201: ,g_module_prefix || l_procedure_name ||
202: '. OTHER_EXCEPTION '
203: ,SQLCODE || SQLERRM);
204: END IF;

Line 274: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

270: l_parameter xmltype;
271: l_jmf_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
272: l_jmf_gta_gta_not_enabled VARCHAR2(500);
273: l_no_data_message VARCHAR2(500);
274: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
275: l_proc_level NUMBER := fnd_log.level_procedure;
276: l_conc_succ BOOLEAN;
277:
278:

Line 275: l_proc_level NUMBER := fnd_log.level_procedure;

271: l_jmf_gta_enabled fnd_profile_option_values.profile_option_value%TYPE := NULL;
272: l_jmf_gta_gta_not_enabled VARCHAR2(500);
273: l_no_data_message VARCHAR2(500);
274: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
275: l_proc_level NUMBER := fnd_log.level_procedure;
276: l_conc_succ BOOLEAN;
277:
278:
279:

Line 301: fnd_log.STRING(l_proc_level

297:
298: --logging for debug
299: IF (l_proc_level >= l_dbg_level)
300: THEN
301: fnd_log.STRING(l_proc_level
302: ,g_module_prefix || l_procedure_name || '.begin'
303: ,'enter procedure');
304: END IF; /*IF (l_proc_level>=l_dbg_level)*/
305:

Line 425: fnd_log.STRING(l_proc_level

421:
422: --logging for debug
423: IF (l_proc_level >= l_dbg_level)
424: THEN
425: fnd_log.STRING(l_proc_level
426: ,g_module_prefix || l_procedure_name || '.end'
427: ,'end procedure');
428: END IF; /*IF (l_proc_level>=l_dbg_level)*/
429:

Line 433: IF fnd_log.level_unexpected >= l_dbg_level

429:
430: COMMIT;
431: EXCEPTION
432: WHEN OTHERS THEN
433: IF fnd_log.level_unexpected >= l_dbg_level
434: THEN
435: fnd_log.STRING(fnd_log.level_unexpected
436: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
437: ,SQLCODE || SQLERRM);

Line 435: fnd_log.STRING(fnd_log.level_unexpected

431: EXCEPTION
432: WHEN OTHERS THEN
433: IF fnd_log.level_unexpected >= l_dbg_level
434: THEN
435: fnd_log.STRING(fnd_log.level_unexpected
436: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
437: ,SQLCODE || SQLERRM);
438: END IF;
439: RAISE;

Line 505: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

501: l_jmf_gta_gta_not_enabled VARCHAR2(500);
502: l_report xmltype;
503: l_parameter xmltype;
504: l_dbg_msg VARCHAR2(500);
505: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
506: l_proc_level NUMBER := fnd_log.level_procedure;
507: l_org_id NUMBER := mo_global.get_current_org_id;
508: l_conc_succ BOOLEAN;
509: BEGIN

Line 506: l_proc_level NUMBER := fnd_log.level_procedure;

502: l_report xmltype;
503: l_parameter xmltype;
504: l_dbg_msg VARCHAR2(500);
505: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
506: l_proc_level NUMBER := fnd_log.level_procedure;
507: l_org_id NUMBER := mo_global.get_current_org_id;
508: l_conc_succ BOOLEAN;
509: BEGIN
510: --logging for debug

Line 513: fnd_log.STRING(l_proc_level

509: BEGIN
510: --logging for debug
511: IF (l_proc_level >= l_dbg_level)
512: THEN
513: fnd_log.STRING(l_proc_level
514: ,g_module_prefix || l_procedure_name || '.begin'
515: ,'enter procedure');
516: END IF;
517:

Line 600: fnd_log.STRING(l_proc_level

596:
597: --logging for debug
598: IF (l_proc_level >= l_dbg_level)
599: THEN
600: fnd_log.STRING(l_proc_level
601: ,g_module_prefix || l_procedure_name || '.end'
602: ,'end procedure');
603: END IF;
604:

Line 607: IF fnd_log.level_unexpected >= l_dbg_level

603: END IF;
604:
605: EXCEPTION
606: WHEN OTHERS THEN
607: IF fnd_log.level_unexpected >= l_dbg_level
608: THEN
609: fnd_log.STRING(fnd_log.level_unexpected
610: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
611: ,SQLCODE || SQLERRM);

Line 609: fnd_log.STRING(fnd_log.level_unexpected

605: EXCEPTION
606: WHEN OTHERS THEN
607: IF fnd_log.level_unexpected >= l_dbg_level
608: THEN
609: fnd_log.STRING(fnd_log.level_unexpected
610: ,g_module_prefix || l_procedure_name || '.OTHER_EXCEPTION'
611: ,SQLCODE || SQLERRM);
612: END IF;
613: RAISE;

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

650: l_conc_succ BOOLEAN;
651:
652: BEGIN
653: --procedure begin
654: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
655: THEN
656: fnd_log.STRING(fnd_log.level_procedure
657: ,g_module_prefix || l_procedure_name || '.begin'
658: ,'Procedure begin');

Line 656: fnd_log.STRING(fnd_log.level_procedure

652: BEGIN
653: --procedure begin
654: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
655: THEN
656: fnd_log.STRING(fnd_log.level_procedure
657: ,g_module_prefix || l_procedure_name || '.begin'
658: ,'Procedure begin');
659: END IF;
660:

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

685:
686: jmf_gta_txt_operator_proc.Clear_Imp_Temp_Table;
687:
688: --procedure end
689: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
690: THEN
691: fnd_log.STRING(fnd_log.level_procedure
692: ,g_module_prefix || l_procedure_name || '.end'
693: ,'Procedure end');

Line 691: fnd_log.STRING(fnd_log.level_procedure

687:
688: --procedure end
689: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
690: THEN
691: fnd_log.STRING(fnd_log.level_procedure
692: ,g_module_prefix || l_procedure_name || '.end'
693: ,'Procedure end');
694: END IF;
695:

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

694: END IF;
695:
696: EXCEPTION
697: WHEN OTHERS THEN
698: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
699: THEN
700: fnd_log.STRING(fnd_log.level_unexpected
701: ,g_module_prefix || l_procedure_name ||
702: '.OTHER_EXCEPTION '

Line 700: fnd_log.STRING(fnd_log.level_unexpected

696: EXCEPTION
697: WHEN OTHERS THEN
698: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
699: THEN
700: fnd_log.STRING(fnd_log.level_unexpected
701: ,g_module_prefix || l_procedure_name ||
702: '.OTHER_EXCEPTION '
703: ,SQLCODE || SQLERRM);
704: END IF;

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

789: l_conc_succ BOOLEAN;
790:
791: BEGIN
792: --procedure begin
793: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
794: THEN
795: fnd_log.STRING(fnd_log.level_procedure
796: ,g_module_prefix || l_procedure_name || '.begin'
797: ,'Procedure begin');

Line 795: fnd_log.STRING(fnd_log.level_procedure

791: BEGIN
792: --procedure begin
793: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
794: THEN
795: fnd_log.STRING(fnd_log.level_procedure
796: ,g_module_prefix || l_procedure_name || '.begin'
797: ,'Procedure begin');
798: END IF;
799:

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

837: ,p_trx_class => p_trx_class
838: ,p_batch_id => p_batch_id
839: ,p_invoice_type_id => p_invoice_type
840: );
841: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
842: THEN
843: fnd_log.STRING(fnd_log.level_procedure
844: ,g_module_prefix || l_procedure_name || '.end'
845: ,'Procedure end');

Line 843: fnd_log.STRING(fnd_log.level_procedure

839: ,p_invoice_type_id => p_invoice_type
840: );
841: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
842: THEN
843: fnd_log.STRING(fnd_log.level_procedure
844: ,g_module_prefix || l_procedure_name || '.end'
845: ,'Procedure end');
846: END IF;
847:

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

846: END IF;
847:
848: EXCEPTION
849: WHEN OTHERS THEN
850: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
851: THEN
852: fnd_log.STRING(fnd_log.level_unexpected
853: ,g_module_prefix || l_procedure_name ||
854: '.OTHER_EXCEPTION '

Line 852: fnd_log.STRING(fnd_log.level_unexpected

848: EXCEPTION
849: WHEN OTHERS THEN
850: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
851: THEN
852: fnd_log.STRING(fnd_log.level_unexpected
853: ,g_module_prefix || l_procedure_name ||
854: '.OTHER_EXCEPTION '
855: ,SQLCODE || SQLERRM);
856: END IF;

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

897: l_conc_succ BOOLEAN;
898:
899: BEGIN
900: --procedure begin
901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
902: THEN
903: fnd_log.STRING(fnd_log.level_procedure
904: ,g_module_prefix || l_procedure_name || '.begin'
905: ,'Procedure begin');

Line 903: fnd_log.STRING(fnd_log.level_procedure

899: BEGIN
900: --procedure begin
901: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
902: THEN
903: fnd_log.STRING(fnd_log.level_procedure
904: ,g_module_prefix || l_procedure_name || '.begin'
905: ,'Procedure begin');
906: END IF;
907:

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

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

Line 929: fnd_log.STRING(fnd_log.level_procedure

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

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

932: END IF;
933:
934: EXCEPTION
935: WHEN OTHERS THEN
936: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
937: THEN
938: fnd_log.STRING(fnd_log.level_unexpected
939: ,g_module_prefix || l_procedure_name ||
940: '.OTHER_EXCEPTION '

Line 938: fnd_log.STRING(fnd_log.level_unexpected

934: EXCEPTION
935: WHEN OTHERS THEN
936: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
937: THEN
938: fnd_log.STRING(fnd_log.level_unexpected
939: ,g_module_prefix || l_procedure_name ||
940: '.OTHER_EXCEPTION '
941: ,SQLCODE || SQLERRM);
942: END IF;

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

982: --
983: -- CHANGE HISTORY:
984: --
985: -- 13-Jun-2005: Donghai Wang Created
986: -- 06-Mar-2006: Donghai Wang Add fnd log
987: --
988: --==========================================================================
989: PROCEDURE discrepancy_report
990: (errbuf OUT NOCOPY VARCHAR2

Line 1018: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1014: l_dbg_msg VARCHAR2(500);
1015: l_jmf_gta_not_enabled_msg VARCHAR2(1000);
1016: l_report_xml XMLTYPE;
1017: l_procedure_name VARCHAR2(50);
1018: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1019: l_proc_level NUMBER := fnd_log.level_procedure;
1020: l_org_id hr_all_organization_units.organization_id%TYPE;
1021: l_conc_succ BOOLEAN;
1022: BEGIN

Line 1019: l_proc_level NUMBER := fnd_log.level_procedure;

1015: l_jmf_gta_not_enabled_msg VARCHAR2(1000);
1016: l_report_xml XMLTYPE;
1017: l_procedure_name VARCHAR2(50);
1018: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1019: l_proc_level NUMBER := fnd_log.level_procedure;
1020: l_org_id hr_all_organization_units.organization_id%TYPE;
1021: l_conc_succ BOOLEAN;
1022: BEGIN
1023:

Line 1031: fnd_log.STRING(l_proc_level

1027:
1028: --log for debug
1029: IF (l_proc_level >= l_dbg_level)
1030: THEN
1031: fnd_log.STRING(l_proc_level
1032: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1033: ,'Enter procedure');
1034:
1035: fnd_log.STRING(l_proc_level

Line 1035: fnd_log.STRING(l_proc_level

1031: fnd_log.STRING(l_proc_level
1032: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1033: ,'Enter procedure');
1034:
1035: fnd_log.STRING(l_proc_level
1036: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1037: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
1038:
1039: fnd_log.STRING(l_proc_level

Line 1039: fnd_log.STRING(l_proc_level

1035: fnd_log.STRING(l_proc_level
1036: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1037: ,'p_gta_batch_num_from '||p_gta_batch_num_from);
1038:
1039: fnd_log.STRING(l_proc_level
1040: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1041: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
1042:
1043: fnd_log.STRING(l_proc_level

Line 1043: fnd_log.STRING(l_proc_level

1039: fnd_log.STRING(l_proc_level
1040: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1041: ,'p_gta_batch_num_to '||p_gta_batch_num_to);
1042:
1043: fnd_log.STRING(l_proc_level
1044: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1045: ,'p_ar_transaction_type '||p_ar_transaction_type);
1046:
1047: fnd_log.STRING(l_proc_level

Line 1047: fnd_log.STRING(l_proc_level

1043: fnd_log.STRING(l_proc_level
1044: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1045: ,'p_ar_transaction_type '||p_ar_transaction_type);
1046:
1047: fnd_log.STRING(l_proc_level
1048: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1049: ,'p_cust_num_from '||p_cust_num_from);
1050:
1051: fnd_log.STRING(l_proc_level

Line 1051: fnd_log.STRING(l_proc_level

1047: fnd_log.STRING(l_proc_level
1048: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1049: ,'p_cust_num_from '||p_cust_num_from);
1050:
1051: fnd_log.STRING(l_proc_level
1052: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1053: ,'p_cust_num_to '||p_cust_num_to);
1054:
1055: fnd_log.STRING(l_proc_level

Line 1055: fnd_log.STRING(l_proc_level

1051: fnd_log.STRING(l_proc_level
1052: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1053: ,'p_cust_num_to '||p_cust_num_to);
1054:
1055: fnd_log.STRING(l_proc_level
1056: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1057: ,'p_cust_name_id '||p_cust_name_id);
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 || '.parameters'
1057: ,'p_cust_name_id '||p_cust_name_id);
1058:
1059: fnd_log.STRING(l_proc_level
1060: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1061: ,'p_gl_period '||p_gl_period);
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_gl_period '||p_gl_period);
1062:
1063: fnd_log.STRING(l_proc_level
1064: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1065: ,'p_gl_date_from '||p_gl_date_from);
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_gl_date_from '||p_gl_date_from);
1066:
1067: fnd_log.STRING(l_proc_level
1068: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1069: ,'p_gl_date_to '||p_gl_date_to);
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_gl_date_to '||p_gl_date_to);
1070:
1071: fnd_log.STRING(l_proc_level
1072: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1073: ,'p_ar_trx_batch_from '||p_ar_trx_batch_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_ar_trx_batch_from '||p_ar_trx_batch_from);
1074:
1075: fnd_log.STRING(l_proc_level
1076: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1077: ,'p_ar_trx_batch_to '||p_ar_trx_batch_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_ar_trx_batch_to '||p_ar_trx_batch_to);
1078:
1079: fnd_log.STRING(l_proc_level
1080: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1081: ,'p_ar_trx_num_from '||p_ar_trx_num_from);
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_ar_trx_num_from '||p_ar_trx_num_from);
1082:
1083: fnd_log.STRING(l_proc_level
1084: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1085: ,'p_ar_trx_num_to '||p_ar_trx_num_to);
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_ar_trx_num_to '||p_ar_trx_num_to);
1086:
1087: fnd_log.STRING(l_proc_level
1088: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1089: ,'p_ar_trx_date_from '||p_ar_trx_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_ar_trx_date_from '||p_ar_trx_date_from);
1090:
1091: fnd_log.STRING(l_proc_level
1092: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1093: ,'p_ar_trx_date_to '||p_ar_trx_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_ar_trx_date_to '||p_ar_trx_date_to);
1094:
1095: fnd_log.STRING(l_proc_level
1096: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1097: ,'p_ar_doc_num_from '||p_ar_doc_num_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_doc_num_from '||p_ar_doc_num_from);
1098:
1099: fnd_log.STRING(l_proc_level
1100: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1101: ,'p_ar_doc_num_to '||p_ar_doc_num_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_doc_num_to '||p_ar_doc_num_to);
1102:
1103: fnd_log.STRING(l_proc_level
1104: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1105: ,'p_original_curr_code '||p_original_curr_code);
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_original_curr_code '||p_original_curr_code);
1106:
1107: fnd_log.STRING(l_proc_level
1108: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1109: ,'p_primary_sales '||p_primary_sales);
1110: END IF; --( l_proc_level >= l_dbg_level )
1111:

Line 1170: fnd_log.STRING(l_proc_level

1166:
1167: --log for debug
1168: IF (l_proc_level >= l_dbg_level)
1169: THEN
1170: fnd_log.STRING(l_proc_level
1171: ,g_module_prefix || '.' || l_procedure_name || '.end'
1172: ,'Exit procedure');
1173: END IF; --( l_proc_level >= l_dbg_level )
1174:

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

1173: END IF; --( l_proc_level >= l_dbg_level )
1174:
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: IF (fnd_log.level_unexpected >= l_dbg_level)
1178: THEN
1179: fnd_log.STRING(fnd_log.level_unexpected
1180: ,g_module_prefix || l_procedure_name ||
1181: '.OTHER_EXCEPTION '

Line 1179: fnd_log.STRING(fnd_log.level_unexpected

1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: IF (fnd_log.level_unexpected >= l_dbg_level)
1178: THEN
1179: fnd_log.STRING(fnd_log.level_unexpected
1180: ,g_module_prefix || l_procedure_name ||
1181: '.OTHER_EXCEPTION '
1182: ,SQLCODE || SQLERRM);
1183: END IF;

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

1218: --
1219: -- CHANGE HISTORY:
1220: --
1221: -- 13-Jun-2005: Donghai Wang Created
1222: -- 06-Mar-2006: Donghai Wang Add fnd log
1223: --
1224: --==========================================================================
1225: PROCEDURE item_export
1226: (errbuf OUT NOCOPY VARCHAR2

Line 1247: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;

1243: l_procedure_name VARCHAR2(50);
1244: l_jmf_gta_enabled VARCHAR2(10);
1245: l_dbg_msg VARCHAR2(500);
1246: l_jmf_gta_not_enabled_msg VARCHAR2(1000);
1247: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1248: l_proc_level NUMBER := fnd_log.level_procedure;
1249: l_org_id hr_all_organization_units.organization_id%TYPE;
1250: l_conc_succ BOOLEAN;
1251:

Line 1248: l_proc_level NUMBER := fnd_log.level_procedure;

1244: l_jmf_gta_enabled VARCHAR2(10);
1245: l_dbg_msg VARCHAR2(500);
1246: l_jmf_gta_not_enabled_msg VARCHAR2(1000);
1247: l_dbg_level NUMBER := fnd_log.g_current_runtime_level;
1248: l_proc_level NUMBER := fnd_log.level_procedure;
1249: l_org_id hr_all_organization_units.organization_id%TYPE;
1250: l_conc_succ BOOLEAN;
1251:
1252: BEGIN

Line 1257: fnd_log.STRING(l_proc_level

1253: l_procedure_name := 'Item_Export';
1254: --log for debug
1255: IF (l_proc_level >= l_dbg_level)
1256: THEN
1257: fnd_log.STRING(l_proc_level
1258: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1259: ,'Enter procedure');
1260:
1261: fnd_log.STRING(l_proc_level

Line 1261: fnd_log.STRING(l_proc_level

1257: fnd_log.STRING(l_proc_level
1258: ,g_module_prefix || '.' || l_procedure_name || '.begin'
1259: ,'Enter procedure');
1260:
1261: fnd_log.STRING(l_proc_level
1262: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1263: ,'p_master_org_id '||p_master_org_id);
1264:
1265: fnd_log.STRING(l_proc_level

Line 1265: fnd_log.STRING(l_proc_level

1261: fnd_log.STRING(l_proc_level
1262: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1263: ,'p_master_org_id '||p_master_org_id);
1264:
1265: fnd_log.STRING(l_proc_level
1266: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1267: ,'p_item_num_from '||p_item_num_from);
1268:
1269: fnd_log.STRING(l_proc_level

Line 1269: fnd_log.STRING(l_proc_level

1265: fnd_log.STRING(l_proc_level
1266: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1267: ,'p_item_num_from '||p_item_num_from);
1268:
1269: fnd_log.STRING(l_proc_level
1270: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1271: ,'p_item_num_to '||p_item_num_to);
1272:
1273: fnd_log.STRING(l_proc_level

Line 1273: fnd_log.STRING(l_proc_level

1269: fnd_log.STRING(l_proc_level
1270: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1271: ,'p_item_num_to '||p_item_num_to);
1272:
1273: fnd_log.STRING(l_proc_level
1274: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1275: ,'p_category_set_id '||p_category_set_id);
1276:
1277: fnd_log.STRING(l_proc_level

Line 1277: fnd_log.STRING(l_proc_level

1273: fnd_log.STRING(l_proc_level
1274: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1275: ,'p_category_set_id '||p_category_set_id);
1276:
1277: fnd_log.STRING(l_proc_level
1278: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1279: ,'p_category_structure_id '||p_category_structure_id);
1280:
1281: fnd_log.STRING(l_proc_level

Line 1281: fnd_log.STRING(l_proc_level

1277: fnd_log.STRING(l_proc_level
1278: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1279: ,'p_category_structure_id '||p_category_structure_id);
1280:
1281: fnd_log.STRING(l_proc_level
1282: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1283: ,'p_item_category_from '||p_item_category_from);
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 || '.parameters'
1283: ,'p_item_category_from '||p_item_category_from);
1284:
1285: fnd_log.STRING(l_proc_level
1286: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1287: ,'p_item_category_to '||p_item_category_to);
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_item_category_to '||p_item_category_to);
1288:
1289: fnd_log.STRING(l_proc_level
1290: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1291: ,'p_item_name_source '||p_item_name_source);
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_name_source '||p_item_name_source);
1292:
1293: fnd_log.STRING(l_proc_level
1294: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1295: ,'p_dummy '||p_dummy);
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_dummy '||p_dummy);
1296:
1297: fnd_log.STRING(l_proc_level
1298: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1299: ,'p_cross_reference_type '||p_cross_reference_type);
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_cross_reference_type '||p_cross_reference_type);
1300:
1301: fnd_log.STRING(l_proc_level
1302: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1303: ,'p_item_status '||p_item_status);
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_item_status '||p_item_status);
1304:
1305: fnd_log.STRING(l_proc_level
1306: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1307: ,'p_creation_date_from '||p_creation_date_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_creation_date_from '||p_creation_date_from);
1308:
1309: fnd_log.STRING(l_proc_level
1310: ,g_module_prefix || '.' || l_procedure_name || '.parameters'
1311: ,'p_creation_date_to '||p_creation_date_to);
1312:
1313:

Line 1358: fnd_log.STRING(l_proc_level

1354:
1355: --log for debug
1356: IF (l_proc_level >= l_dbg_level)
1357: THEN
1358: fnd_log.STRING(l_proc_level
1359: ,g_module_prefix || '.' || l_procedure_name || '.end'
1360: ,'Exit procedure');
1361: END IF; --( l_proc_level >= l_dbg_level )
1362:

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

1361: END IF; --( l_proc_level >= l_dbg_level )
1362:
1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1366: THEN
1367: fnd_log.STRING(fnd_log.level_unexpected
1368: ,g_module_prefix || l_procedure_name ||
1369: '. OTHER_EXCEPTION '

Line 1367: fnd_log.STRING(fnd_log.level_unexpected

1363: EXCEPTION
1364: WHEN OTHERS THEN
1365: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1366: THEN
1367: fnd_log.STRING(fnd_log.level_unexpected
1368: ,g_module_prefix || l_procedure_name ||
1369: '. OTHER_EXCEPTION '
1370: ,'Unknown error' || SQLCODE || SQLERRM);
1371:

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

1422: l_conc_succ BOOLEAN;
1423: l_org_id NUMBER := mo_global.get_current_org_id;
1424: BEGIN
1425: -- procedure begin
1426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1427: THEN
1428: fnd_log.STRING(fnd_log.level_procedure
1429: ,g_module_prefix || l_procedure_name
1430: ,'Begin Procedure. ');

Line 1428: fnd_log.STRING(fnd_log.level_procedure

1424: BEGIN
1425: -- procedure begin
1426: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1427: THEN
1428: fnd_log.STRING(fnd_log.level_procedure
1429: ,g_module_prefix || l_procedure_name
1430: ,'Begin Procedure. ');
1431: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1432:

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

1427: THEN
1428: fnd_log.STRING(fnd_log.level_procedure
1429: ,g_module_prefix || l_procedure_name
1430: ,'Begin Procedure. ');
1431: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1432:
1433: IF (fnd_profile.VALUE('JMF_GTA_ENABLED') = 'Y')
1434: THEN
1435: jmf_gta_txt_operator_proc.export_customers(p_org_id => l_org_id

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

1456: ,message => l_jmf_gta_gta_not_enabled);
1457: RETURN;
1458: END IF; /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1459: -- procedure end
1460: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1461: THEN
1462: fnd_log.STRING(fnd_log.level_procedure
1463: ,g_module_prefix || l_procedure_name
1464: ,'End Procedure. ');

Line 1462: fnd_log.STRING(fnd_log.level_procedure

1458: END IF; /*FND_PROFILE.VALUE('GTA_ENABLED')='Y'*/
1459: -- procedure end
1460: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
1461: THEN
1462: fnd_log.STRING(fnd_log.level_procedure
1463: ,g_module_prefix || l_procedure_name
1464: ,'End Procedure. ');
1465: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1466:

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

1461: THEN
1462: fnd_log.STRING(fnd_log.level_procedure
1463: ,g_module_prefix || l_procedure_name
1464: ,'End Procedure. ');
1465: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

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

1465: END IF; /*FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL*/
1466:
1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1470: THEN
1471: fnd_log.STRING(fnd_log.level_unexpected
1472: ,g_module_prefix || l_procedure_name ||
1473: '. OTHER_EXCEPTION '

Line 1471: fnd_log.STRING(fnd_log.level_unexpected

1467: EXCEPTION
1468: WHEN OTHERS THEN
1469: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1470: THEN
1471: fnd_log.STRING(fnd_log.level_unexpected
1472: ,g_module_prefix || l_procedure_name ||
1473: '. OTHER_EXCEPTION '
1474: ,'Unknown error' || SQLCODE || SQLERRM);
1475: