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

Line 127: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_data','Exception in Fetching legal entity id ');

123:
124: EXCEPTION
125: WHEN OTHERS THEN
126: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
127: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_data','Exception in Fetching legal entity id ');
128: END IF;
129: retcode :=2;
130: errbuf :='Exception in Fetching legal entity id';
131: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 179: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in fetching frozen status of VAT Reporting Entity'||p_vat_reporting_entity_id|| 'and declaration year '||p_year);

175: errbuf :='Exception in fetching Freeze Status';
176: retcode := 2;
177: debug_message( 'Exception in fetching frozen status of VAT Reporting Entity'||p_vat_reporting_entity_id|| 'and declaration year '||p_year);
178: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
179: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in fetching frozen status of VAT Reporting Entity'||p_vat_reporting_entity_id|| 'and declaration year '||p_year);
180: END IF;
181: return;
182: END;
183: BEGIN

Line 266: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in fetching reprot mode of declaration year '||p_year||' and type of upload '||p_type_of_upload);

262: WHEN OTHERS THEN
263: errbuf :='Exception in fetching report mode';
264: retcode := 2;
265: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
266: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in fetching reprot mode of declaration year '||p_year||' and type of upload '||p_type_of_upload);
267: END IF;
268: return;
269: END;
270:

Line 291: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in fetching default payment mode');

287: errbuf :='Exception in fetching default payment mode';
288: retcode := 2;
289: debug_message(errbuf);
290: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
291: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Exception in fetching default payment mode');
292: END IF;
293: return;
294: END;
295:

Line 358: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);

354: WHEN OTHERS THEN
355: errbuf := 'Error while inserting data into JE_IT_ABOVE_THR_HDR_ALL table '||SQLCODE||'-'||SQLERRM;
356: retcode := 2;
357: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
359: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while inserting data into je_it_list_hdr_all table');
360: debug_message('Error while inserting data into hdr table'||SQLCODE||'-'||SQLERRM);
361: END IF;
362: return;

Line 359: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while inserting data into je_it_list_hdr_all table');

355: errbuf := 'Error while inserting data into JE_IT_ABOVE_THR_HDR_ALL table '||SQLCODE||'-'||SQLERRM;
356: retcode := 2;
357: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
358: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,SQLERRM);
359: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,'Error while inserting data into je_it_list_hdr_all table');
360: debug_message('Error while inserting data into hdr table'||SQLCODE||'-'||SQLERRM);
361: END IF;
362: return;
363: END;

Line 452: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.je_it_invoices_above_threhold','Audit Report Request Id = '||l_request_id);

448: IF l_request_id = 0 THEN
449: debug_message('Error occurred while generating the Audit Report');
450: END IF;
451: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
452: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.je_it_invoices_above_threhold','Audit Report Request Id = '||l_request_id);
453: END IF;
454: EXCEPTION
455: WHEN OTHERS THEN
456: debug_message('Error while generating the EFT report');

Line 480: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.je_it_invoices_above_threhold','EFT Report Request Id = '||l_request_id);

476: IF l_request_id = 0 THEN
477: debug_message('Error occurred while generating the EFT Report');
478: END IF;
479: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
480: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.je_it_invoices_above_threhold','EFT Report Request Id = '||l_request_id);
481: END IF;
482: EXCEPTION
483: WHEN OTHERS THEN
484: debug_message('Error while generating the EFT report');

Line 500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Start PROCEDURE Purge_trx_data');

496: l_conc_request_id NUMBER;
497: BEGIN
498: debug_message('in purge_trx_data1');
499: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
500: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'Start PROCEDURE Purge_trx_data');
501: END IF;
502: g_retcode :=0;
503:
504: debug_message('in purge_trx_data');

Line 525: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name,'End PROCEDURE Purge_trx_data');

521: WHERE REQUEST_ID = l_conc_request_id;
522:
523: debug_message('after delete');
524: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
525: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_api_name,'End PROCEDURE Purge_trx_data');
526: END IF;
527: EXCEPTION
528: WHEN OTHERS THEN
529: g_retcode :=2;

Line 532: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,'Exception in PROCEDURE Purge_trx_data');

528: WHEN OTHERS THEN
529: g_retcode :=2;
530: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Purge_trx_data';
531: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
532: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,'Exception in PROCEDURE Purge_trx_data');
533: END IF;
534: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
535: IF g_debug_flag = 'Y' THEN
536: debug_message( g_error_buffer);

Line 830: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AP_Trx_data while updating tax lines GDF');

826: WHEN OTHERS THEN
827: g_retcode :=2;
828: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AP_Trx_data while updating tax lines GDF';
829: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
830: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AP_Trx_data while updating tax lines GDF');
831: END IF;
832: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
833: debug_message('Error while updating tax lines GDF in extract_ap_trx_data -'||SQLERRM);
834: return;

Line 879: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AP_Trx_data while updating record_type');

875: WHEN OTHERS THEN
876: g_retcode :=2;
877: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AP_Trx_data while updating record_type';
878: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
879: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AP_Trx_data while updating record_type');
880: END IF;
881: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
882: debug_message('Error while updating record type in extract_ap_trx_data -'||SQLERRM);
883: return;

Line 893: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AP_Trx_data');

889: WHEN OTHERS THEN
890: g_retcode :=2;
891: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AP_Trx_data';
892: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
893: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AP_Trx_data');
894: END IF;
895: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
896: debug_message('Error while inserting data in extract_ap_trx_data -'||SQLERRM);
897: return;

Line 949: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE is_cm_dm_line_consistent');

945: WHEN OTHERS THEN
946: g_retcode :=2;
947: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.is_cm_dm_line_consistent for parent_trx_id '||p_parent_trx_id;
948: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
949: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE is_cm_dm_line_consistent');
950: END IF;
951: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
952: return 'Y';
953: END;

Line 1003: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE get_orig_trx_id');

999: WHEN OTHERS THEN
1000: g_retcode :=2;
1001: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.get_orig_trx_id for parent_trx_id '||p_cust_trx_id;
1002: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1003: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE get_orig_trx_id');
1004: END IF;
1005: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1006: --return 'Y';
1007:

Line 1341: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data');

1337: g_retcode :=2;
1338: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data';
1339: debug_message('Exception in Extract_AR_Trx_data :'||SQLERRM);
1340: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1341: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data');
1342: END IF;
1343: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1344: return;
1345: END;

Line 1418: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data while updating tax lines GDF');

1414: g_retcode :=2;
1415: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data while updating tax lines GDF';
1416: debug_message('Exception in Extract_AR_Trx_data while updating tax lines GDF information :'||SQLERRM);
1417: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1418: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data while updating tax lines GDF');
1419: END IF;
1420: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1421:
1422: return;

Line 1445: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data, While updating GL Date');

1441: WHEN OTHERS THEN
1442: g_retcode :=2;
1443: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data, While updating GL Date';
1444: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1445: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data, While updating GL Date');
1446: END IF;
1447: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1448: return;
1449: END;

Line 1502: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data, While updating record type');

1498: WHEN OTHERS THEN
1499: g_retcode :=2;
1500: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data, While updating record type';
1501: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1502: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Extract_AR_Trx_data, While updating record type');
1503: END IF;
1504: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1505: return;
1506: END;

Line 1550: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_payment_mode_error for Invoice check');

1546: WHEN OTHERS THEN
1547: g_retcode :=2;
1548: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_payment_mode_error';
1549: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1550: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_payment_mode_error for Invoice check');
1551: END IF;
1552: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1553: return;
1554: END;

Line 1576: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_payment_mode_error for Contract check');

1572: WHEN OTHERS THEN
1573: g_retcode :=2;
1574: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_payment_mode_error';
1575: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1576: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_payment_mode_error for Contract check');
1577: END IF;
1578: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1579: return;
1580: END;

Line 1609: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_payment_mode_error for Invoice check');

1605: WHEN OTHERS THEN
1606: g_retcode :=2;
1607: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_payment_mode_error';
1608: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1609: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_payment_mode_error for Invoice check');
1610: END IF;
1611: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1612: return;
1613: END;

Line 1672: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_missing_invoice');

1668: WHEN OTHERS THEN
1669: g_retcode :=2;
1670: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_missing_invoice';
1671: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1672: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE check_missing_invoice');
1673: END IF;
1674: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1675: return;
1676: END Check_missing_invoice;

Line 1990: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while inserting record type 1,2,3 data');

1986: WHEN OTHERS THEN
1987: g_retcode :=2;
1988: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';
1989: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1990: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while inserting record type 1,2,3 data');
1991: END IF;
1992: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1993: return;
1994: END;

Line 2016: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while updating the trx_gl_date for contract grouping');

2012: WHEN OTHERS THEN
2013: g_retcode :=2;
2014: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';
2015: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2016: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while updating the trx_gl_date for contract grouping');
2017: END IF;
2018: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2019: return;
2020: END;

Line 2043: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while updating the trx_number for contract grouping');

2039: WHEN OTHERS THEN
2040: g_retcode :=2;
2041: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';
2042: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2043: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while updating the trx_number for contract grouping');
2044: END IF;
2045: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2046: return;
2047: END;

Line 2110: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while calculating l_std_inv_cnt');

2106: WHEN OTHERS THEN
2107: g_retcode :=2;
2108: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';
2109: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2110: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while calculating l_std_inv_cnt');
2111: END IF;
2112: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2113: return;
2114: END;

Line 2243: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while inserting record type 4 and 5 data');

2239: WHEN OTHERS THEN
2240: g_retcode :=2;
2241: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';
2242: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2243: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while inserting record type 4 and 5 data');
2244: END IF;
2245: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2246: return;
2247: END;

Line 2274: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while updating cm/dm original invoice amounts.');

2270: WHEN OTHERS THEN
2271: g_retcode :=2;
2272: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';
2273: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2274: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception in PROCEDURE Insert_Above_Threshold_Lines while updating cm/dm original invoice amounts.');
2275: END IF;
2276: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2277: return;
2278: END;

Line 2322: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception while updating the report mode in Generate_next_eft proc.');

2318: WHEN OTHERS THEN
2319: g_retcode :=2;
2320: g_errbuf :='Exception while updating the report mode';
2321: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2322: FND_LOG.STRING(G_LEVEL_EXCEPTION, G_MODULE_NAME||l_api_name,SQLCODE||' - Exception while updating the report mode in Generate_next_eft proc.');
2323: END IF;
2324: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2325: return;
2326: END;*/