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 JE_IT_INVOICES_ABOVE_THRESHOLD

Line 1: PACKAGE BODY JE_IT_INVOICES_ABOVE_THRESHOLD AS

1: PACKAGE BODY JE_IT_INVOICES_ABOVE_THRESHOLD AS
2: /* $Header: jeitiatb.pls 120.18.12020000.2 2012/07/16 12:03:52 rshergil noship $ */
3:
4: PROCEDURE purge_trx_data (p_vat_reporting_entity_id NUMBER,
5: p_year NUMBER,

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 530: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Purge_trx_data';

526: END IF;
527: EXCEPTION
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);

Line 828: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AP_Trx_data while updating tax lines GDF';

824:
825: EXCEPTION
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);

Line 877: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AP_Trx_data while updating record_type';

873:
874: EXCEPTION
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);

Line 891: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AP_Trx_data';

887:
888: EXCEPTION
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);

Line 947: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.is_cm_dm_line_consistent for parent_trx_id '||p_parent_trx_id;

943: END IF;
944: EXCEPTION
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);

Line 1001: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.get_orig_trx_id for parent_trx_id '||p_cust_trx_id;

997:
998: EXCEPTION
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);

Line 1338: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data';

1334:
1335: EXCEPTION
1336: WHEN OTHERS THEN
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;

Line 1415: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data while updating tax lines GDF';

1411:
1412: EXCEPTION
1413: WHEN OTHERS THEN
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;

Line 1443: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data, While updating GL Date';

1439:
1440: EXCEPTION
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);

Line 1500: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Extract_AR_Trx_data, While updating record type';

1496: debug_message('After record type update in Extract_AR_Trx_data');
1497: EXCEPTION
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);

Line 1548: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_payment_mode_error';

1544:
1545: EXCEPTION
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);

Line 1574: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_payment_mode_error';

1570:
1571: EXCEPTION
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);

Line 1607: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_payment_mode_error';

1603:
1604: EXCEPTION
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);

Line 1670: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.check_missing_invoice';

1666: debug_message('End of Check_missing_invoice');
1667: EXCEPTION
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);

Line 1988: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';

1984: debug_message('In between of Insert_Above_Threshold_Lines');
1985: EXCEPTION
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);

Line 2014: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';

2010:
2011: EXCEPTION
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);

Line 2041: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';

2037:
2038: EXCEPTION
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);

Line 2108: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';

2104:
2105: EXCEPTION
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);

Line 2241: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';

2237: debug_message('in between-2 of Insert_Above_Threshold_Lines');
2238: EXCEPTION
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);

Line 2272: g_errbuf :='Exception in JE_IT_INVOICES_ABOVE_THRESHOLD.Insert_Above_Threshold_Lines';

2268:
2269: EXCEPTION
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);

Line 2368: END JE_IT_INVOICES_ABOVE_THRESHOLD;

2364: fnd_file.put_line(fnd_file.log,p_message_str);
2365: END IF;
2366: END debug_message;
2367:
2368: END JE_IT_INVOICES_ABOVE_THRESHOLD;
2369: