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_LISTING_PKG dependencies on JE_IT_LISTING_PKG

Line 1: PACKAGE BODY JE_IT_LISTING_PKG AS

1: PACKAGE BODY JE_IT_LISTING_PKG AS
2: /* $Header: jeitlstb.pls 120.6.12010000.3 2009/02/23 07:36:29 rahulkum ship $ */
3:
4: -------------------------------------------------------------------------------
5: --Global Variables

Line 26: gt_party_id JE_IT_LISTING_PKG.tab_party_id;

22: g_rec_per_eft NUMBER;
23:
24:
25:
26: gt_party_id JE_IT_LISTING_PKG.tab_party_id;
27: gt_trx_type_code JE_IT_LISTING_PKG.tab_trx_type_code;
28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;
29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;

Line 27: gt_trx_type_code JE_IT_LISTING_PKG.tab_trx_type_code;

23:
24:
25:
26: gt_party_id JE_IT_LISTING_PKG.tab_party_id;
27: gt_trx_type_code JE_IT_LISTING_PKG.tab_trx_type_code;
28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;
29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;

Line 28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;

24:
25:
26: gt_party_id JE_IT_LISTING_PKG.tab_party_id;
27: gt_trx_type_code JE_IT_LISTING_PKG.tab_trx_type_code;
28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;
29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;

Line 29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;

25:
26: gt_party_id JE_IT_LISTING_PKG.tab_party_id;
27: gt_trx_type_code JE_IT_LISTING_PKG.tab_trx_type_code;
28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;
29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;

Line 30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;

26: gt_party_id JE_IT_LISTING_PKG.tab_party_id;
27: gt_trx_type_code JE_IT_LISTING_PKG.tab_trx_type_code;
28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;
29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;

Line 31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;

27: gt_trx_type_code JE_IT_LISTING_PKG.tab_trx_type_code;
28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;
29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;

Line 32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;

28: gt_trx_type_id JE_IT_LISTING_PKG.tab_trx_type_id;
29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;

Line 33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;

29: gt_doc_seq_num JE_IT_LISTING_PKG.tab_doc_seq_num;
30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;

Line 34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;

30: gt_doc_seq_val JE_IT_LISTING_PKG.tab_doc_seq_val;
31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;

Line 35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;

31: gt_trx_date JE_IT_LISTING_PKG.tab_trx_date;
32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;

Line 36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;

32: gt_trx_id JE_IT_LISTING_PKG.tab_trx_id;
33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;

Line 37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;

33: gt_trx_num JE_IT_LISTING_PKG.tab_trx_num;
34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;

Line 38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;

34: gt_trx_line_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;

Line 39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;

35: gt_trx_tax_dist_id JE_IT_LISTING_PKG.tab_trx_dist_id;
36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;

Line 40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;

36: gt_trx_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;
44: gt_party_vat_reg_num JE_IT_LISTING_PKG.tab_party_vat_reg_num;

Line 41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;

37: gt_trx_tax_line_type_code JE_IT_LISTING_PKG.tab_trx_line_type_code;
38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;
44: gt_party_vat_reg_num JE_IT_LISTING_PKG.tab_party_vat_reg_num;
45: gt_party_fiscal_id_num JE_IT_LISTING_PKG.tab_party_fiscal_id_num;

Line 42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;

38: gt_trx_line_tax_rate_id JE_IT_LISTING_PKG.tab_trx_line_tax_rate_id;
39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;
44: gt_party_vat_reg_num JE_IT_LISTING_PKG.tab_party_vat_reg_num;
45: gt_party_fiscal_id_num JE_IT_LISTING_PKG.tab_party_fiscal_id_num;
46:

Line 43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;

39: gt_inv_tax_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;
44: gt_party_vat_reg_num JE_IT_LISTING_PKG.tab_party_vat_reg_num;
45: gt_party_fiscal_id_num JE_IT_LISTING_PKG.tab_party_fiscal_id_num;
46:
47: g_created_by NUMBER(15);

Line 44: gt_party_vat_reg_num JE_IT_LISTING_PKG.tab_party_vat_reg_num;

40: gt_inv_line_amount JE_IT_LISTING_PKG.tab_inv_line_amount;
41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;
44: gt_party_vat_reg_num JE_IT_LISTING_PKG.tab_party_vat_reg_num;
45: gt_party_fiscal_id_num JE_IT_LISTING_PKG.tab_party_fiscal_id_num;
46:
47: g_created_by NUMBER(15);
48: g_creation_date DATE;

Line 45: gt_party_fiscal_id_num JE_IT_LISTING_PKG.tab_party_fiscal_id_num;

41: gt_inv_tax_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
42: gt_inv_line_amount_cm JE_IT_LISTING_PKG.tab_inv_line_amount;
43: gt_trx_type JE_IT_LISTING_PKG.tab_inv_type;
44: gt_party_vat_reg_num JE_IT_LISTING_PKG.tab_party_vat_reg_num;
45: gt_party_fiscal_id_num JE_IT_LISTING_PKG.tab_party_fiscal_id_num;
46:
47: g_created_by NUMBER(15);
48: g_creation_date DATE;
49: g_last_updated_by NUMBER(15);

Line 191: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Start PROCEDURE Extract_Data');

187:
188: BEGIN
189:
190: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
191: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Start PROCEDURE Extract_Data');
192: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data','Parameters are :');
193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);

Line 192: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data','Parameters are :');

188: BEGIN
189:
190: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
191: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Start PROCEDURE Extract_Data');
192: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data','Parameters are :');
193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);

Line 193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);

189:
190: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
191: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Start PROCEDURE Extract_Data');
192: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data','Parameters are :');
193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);

Line 194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);

190: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
191: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Start PROCEDURE Extract_Data');
192: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data','Parameters are :');
193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);

Line 195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);

191: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Start PROCEDURE Extract_Data');
192: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data','Parameters are :');
193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);
199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);

Line 196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);

192: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data','Parameters are :');
193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);
199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);
200: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VEND_SORT_COL = '||P_VEND_SORT_COL);

Line 197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);

193: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);
199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);
200: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VEND_SORT_COL = '||P_VEND_SORT_COL);
201: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_GROUP_PARTIES_FLAG = '||P_GROUP_PARTIES_FLAG);

Line 198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);

194: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);
199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);
200: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VEND_SORT_COL = '||P_VEND_SORT_COL);
201: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_GROUP_PARTIES_FLAG = '||P_GROUP_PARTIES_FLAG);
202: END IF;

Line 199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);

195: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_TYPE ='||P_REPORT_TYPE);
196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);
199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);
200: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VEND_SORT_COL = '||P_VEND_SORT_COL);
201: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_GROUP_PARTIES_FLAG = '||P_GROUP_PARTIES_FLAG);
202: END IF;
203: g_retcode :=0;

Line 200: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VEND_SORT_COL = '||P_VEND_SORT_COL);

196: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VAT ='||P_VAT);
197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);
199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);
200: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VEND_SORT_COL = '||P_VEND_SORT_COL);
201: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_GROUP_PARTIES_FLAG = '||P_GROUP_PARTIES_FLAG);
202: END IF;
203: g_retcode :=0;
204: l_appln_name := 'JE';

Line 201: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_GROUP_PARTIES_FLAG = '||P_GROUP_PARTIES_FLAG);

197: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_REPORT_MODEL = '||P_REPORT_MODE);
198: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_EFT = '||P_EFT);
199: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_CUST_SORT_COL = '||P_CUST_SORT_COL);
200: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_VEND_SORT_COL = '||P_VEND_SORT_COL);
201: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Extract_Data',' P_GROUP_PARTIES_FLAG = '||P_GROUP_PARTIES_FLAG);
202: END IF;
203: g_retcode :=0;
204: l_appln_name := 'JE';
205: l_con_cp_list := 'JEITLSTR_XMLP';

Line 229: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in fetching legal vat reporting entity id');

225: WHEN OTHERS THEN
226: g_errbuf :='Exception in fetching legal vat reporting entity id';
227: g_retcode := 2;
228: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
229: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in fetching legal vat reporting entity id');
230: END IF;
231: errbuf := g_errbuf;
232: retcode:= g_retcode;
233: RETURN;

Line 243: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Not Setup vailable for the reporting entity and year:');

239: CLOSE cur_frozen;
240:
241: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
242: IF p_status_code IS NULL THEN
243: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Not Setup vailable for the reporting entity and year:');
244: END IF;
245: END IF;
246:
247: EXCEPTION

Line 252: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in fetching cur_frozen - p_status_code');

248: WHEN OTHERS THEN
249: g_errbuf :='Exception in fetching Freeze Status';
250: g_retcode := 2;
251: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
252: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in fetching cur_frozen - p_status_code');
253: END IF;
254: errbuf := g_errbuf;
255: retcode:= g_retcode;
256: RETURN;

Line 276: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in fetching cur_status - p_status_code');

272: WHEN OTHERS THEN
273: g_errbuf :='Exception in fetching Status Code';
274: g_retcode := 2;
275: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
276: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in fetching cur_status - p_status_code');
277: END IF;
278: errbuf := g_errbuf;
279: retcode:= g_retcode;
280: RETURN;

Line 302: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','p_status_code = '||p_status_code);

298: END IF;
299: END IF;
300:
301: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
302: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','p_status_code = '||p_status_code);
303: END IF;
304:
305: IF P_REPORT_TYPE = 'P' THEN
306:

Line 308: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Purge_trx_data');

304:
305: IF P_REPORT_TYPE = 'P' THEN
306:
307: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
308: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Purge_trx_data');
309: END IF;
310:
311: Purge_trx_data(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION);
312:

Line 320: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Initialize_proc_var');

316: RETURN;
317: END IF;
318:
319: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
320: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Initialize_proc_var');
321: END IF;
322:
323: Initialize_proc_var(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION);
324:

Line 332: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Fetch_trx_data_ap');

328: RETURN;
329: END IF;
330:
331: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
332: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Fetch_trx_data_ap');
333: END IF;
334:
335: Fetch_trx_data_ap(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,P_VAT);
336:

Line 344: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Fetch_trx_data_ar');

340: RETURN;
341: END IF;
342:
343: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
344: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Fetch_trx_data_ar');
345: END IF;
346:
347: Fetch_trx_data_ar(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,P_VAT);
348:

Line 356: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Generate_trx_headers');

352: RETURN;
353: END IF;
354:
355: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
356: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Calling PROCEDURE Generate_trx_headers');
357: END IF;
358:
359: Generate_trx_headers(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,P_CUST_SORT_COL,P_VEND_SORT_COL,P_GROUP_PARTIES_FLAG);
360:

Line 392: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','l_request_id = '||l_request_id);

388: RAISE e_request_submit_error;
389: END IF;
390:
391: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
392: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','l_request_id = '||l_request_id);
393: END IF;
394: retcode := 0; -- CP completed successfully
395:
396: IF l_gen_efile THEN

Line 407: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Date','Exception in fetching l_eft_count');

403: EXCEPTION
404: WHEN OTHERS THEN
405: g_retcode :=1;
406: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
407: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Date','Exception in fetching l_eft_count');
408: END IF;
409: END;
410:
411: IF g_retcode = 1 THEN

Line 417: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','l_eft_count = '||l_eft_count);

413: RAISE e_request_submit_error;
414: END IF;
415:
416: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
417: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','l_eft_count = '||l_eft_count);
418: END IF;
419:
420: FOR i IN 1..l_eft_count LOOP
421: l_xml_layout := FND_REQUEST.ADD_LAYOUT(l_appln_name,'JEITLSTE','en','US','ETEXT');

Line 439: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','l_request_id,'||i||' = '||l_request_id);

435: RAISE e_request_submit_error;
436: END IF;
437:
438: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
439: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','l_request_id,'||i||' = '||l_request_id);
440: END IF;
441: END LOOP;
442: END IF;
443:

Line 458: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','End PROCEDURE Extract_Data');

454: END IF;
455:
456:
457: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
458: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','End PROCEDURE Extract_Data');
459: END IF;
460:
461: EXCEPTION
462: WHEN l_setup_not_frozen THEN

Line 464: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - l_setup_not_frozen');

460:
461: EXCEPTION
462: WHEN l_setup_not_frozen THEN
463: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
464: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - l_setup_not_frozen');
465: END IF;
466: FND_MESSAGE.SET_NAME('JE','JE_IT_SETUP_NOT_FROZEN');
467: FND_MESSAGE.SET_TOKEN('VAT_REP',l_entity_identifier);
468: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);

Line 475: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - Not setup_available');

471: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
472: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
473: WHEN l_setup_not_available THEN
474: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
475: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - Not setup_available');
476: END IF;
477: FND_MESSAGE.SET_NAME('JE','JE_IT_SETUP_NOT_AVAILABLE');
478: FND_MESSAGE.SET_TOKEN('VAT_REP',l_entity_identifier);
479: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);

Line 485: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - l_final_already_run');

481: retcode := 2; -- Error
482: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
483: WHEN l_final_already_run THEN
484: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
485: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - l_final_already_run');
486: END IF;
487: FND_MESSAGE.SET_NAME('JE','JE_IT_FINAL_LISTING');
488: FND_MESSAGE.SET_TOKEN('VAT_REP',l_entity_identifier);
489: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);

Line 496: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Extract_Data - l_prelim_not_run ');

492: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
493: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
494: WHEN l_prelim_not_run THEN
495: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
496: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Extract_Data - l_prelim_not_run ');
497: END IF;
498: FND_MESSAGE.SET_NAME('JE','JE_IT_PRELIMINARY_LISTING');
499: FND_MESSAGE.SET_TOKEN('VAT_REP',l_entity_identifier);
500: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);

Line 507: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Extract_Data - l_final_not_run ');

503: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
504: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
505: WHEN l_final_not_run THEN
506: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Extract_Data - l_final_not_run ');
508: END IF;
509: FND_MESSAGE.SET_NAME('JE','JE_IT_FINAL_NOT_RUN');
510: FND_MESSAGE.SET_TOKEN('VAT_REP',l_entity_identifier);
511: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);

Line 518: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - e_request_submit_error');

514: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
515: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
516: WHEN e_request_submit_error THEN
517: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
518: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - e_request_submit_error');
519: END IF;
520: errbuf := g_errbuf;
521: retcode := 1; -- Warning
522: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 528: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data ');

524: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
525: END IF;
526: WHEN OTHERS THEN
527: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
528: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data ');
529: END IF;
530: errbuf :='Unknown exception occured in JE_IT_LISTING_PKG.Extract_Data';
531: retcode := 2; -- Error
532: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 530: errbuf :='Unknown exception occured in JE_IT_LISTING_PKG.Extract_Data';

526: WHEN OTHERS THEN
527: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
528: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data ');
529: END IF;
530: errbuf :='Unknown exception occured in JE_IT_LISTING_PKG.Extract_Data';
531: retcode := 2; -- Error
532: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
533: IF g_debug_flag = 'Y' THEN
534: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 589: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Start PROCEDURE Final_data');

585: ANd year_of_declaration = p_year_of_declaration;
586:
587: BEGIN
588: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
589: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Start PROCEDURE Final_data');
590: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data','Parameters are :');
591: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
592: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
593:

Line 590: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data','Parameters are :');

586:
587: BEGIN
588: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
589: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Start PROCEDURE Final_data');
590: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data','Parameters are :');
591: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
592: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
593:
594: END IF;

Line 591: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);

587: BEGIN
588: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
589: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Start PROCEDURE Final_data');
590: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data','Parameters are :');
591: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
592: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
593:
594: END IF;
595:

Line 592: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);

588: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
589: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Start PROCEDURE Final_data');
590: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data','Parameters are :');
591: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
592: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Final_data',' P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
593:
594: END IF;
595:
596:

Line 607: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in fetching p_status_code for cur_status');

603: WHEN OTHERS THEN
604: g_retcode:=2;
605: g_errbuf:='Exception in fetching Status Code';
606: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
607: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in fetching p_status_code for cur_status');
608: END IF;
609: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
610: IF g_debug_flag = 'Y' THEN
611: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 622: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','cur_status - p_status_code = '||p_status_code);

618: RETURN;
619: END IF;
620:
621: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
622: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','cur_status - p_status_code = '||p_status_code);
623: END IF;
624:
625: IF p_status_code = 'P' THEN
626:

Line 644: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_setup_not_frozen ');

640:
641: EXCEPTION
642: WHEN l_setup_not_frozen THEN
643: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
644: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_setup_not_frozen ');
645: END IF;
646: FND_MESSAGE.SET_NAME('JE','JE_IT_SETUP_NOT_FROZEN');
647: errbuf :=FND_MESSAGE.get;
648: retcode := 2; --Error

Line 655: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_prelim_not_run ');

651: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
652: END IF;
653: WHEN l_prelim_not_run THEN
654: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
655: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_prelim_not_run ');
656: END IF;
657: FND_MESSAGE.SET_NAME('JE','JE_IT_PRELIMINARY_LISTING');
658: errbuf :=FND_MESSAGE.get;
659: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

Line 665: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_final_already_run ');

661: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
662: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
663: WHEN l_final_already_run THEN
664: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
665: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_final_already_run ');
666: END IF;
667: errbuf :='Final mode is already run for this Fiscal Period.';
668: retcode := 2; --Error
669: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 673: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data');

669: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
670: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
671: WHEN OTHERS THEN
672: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
673: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data');
674: END IF;
675: errbuf :='Unknown Exception Occured in the package JE_IT_LISTING_PKG in PROCEDURE Final_data';
676: retcode := 2; --Error
677: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 675: errbuf :='Unknown Exception Occured in the package JE_IT_LISTING_PKG in PROCEDURE Final_data';

671: WHEN OTHERS THEN
672: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
673: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data');
674: END IF;
675: errbuf :='Unknown Exception Occured in the package JE_IT_LISTING_PKG in PROCEDURE Final_data';
676: retcode := 2; --Error
677: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
678: IF g_debug_flag = 'Y' THEN
679: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 705: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Purge_trx_data');

701: +===========================================================================*/
702: PROCEDURE Purge_trx_data(p_vat_reporting_entity_id IN NUMBER,P_YEAR_OF_DECLARATION IN NUMBER) IS
703: BEGIN
704: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
705: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Purge_trx_data');
706: END IF;
707: g_retcode :=0;
708:
709: DELETE JE_IT_LIST_LINES_ALL

Line 723: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','End PROCEDURE Purge_trx_data');

719: AND year_of_declaration = p_year_of_declaration;
720:
721: COMMIT;
722: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
723: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','End PROCEDURE Purge_trx_data');
724: END IF;
725: EXCEPTION
726: WHEN OTHERS THEN
727: g_retcode :=2;

Line 728: g_errbuf :='Exception in JE_IT_LISTING_PKG.Purge_trx_data';

724: END IF;
725: EXCEPTION
726: WHEN OTHERS THEN
727: g_retcode :=2;
728: g_errbuf :='Exception in JE_IT_LISTING_PKG.Purge_trx_data';
729: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
730: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Purge_trx_data');
731: END IF;
732: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 730: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Purge_trx_data');

726: WHEN OTHERS THEN
727: g_retcode :=2;
728: g_errbuf :='Exception in JE_IT_LISTING_PKG.Purge_trx_data';
729: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
730: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Purge_trx_data');
731: END IF;
732: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
733: IF g_debug_flag = 'Y' THEN
734: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 749: | Called from JE_IT_LISTING_PKG.Extract_Data() |

745: | DESCRIPTION |
746: | This procedure fetches the distribution lines from the AP |
747: | using bulk fetch and calls the procedure insert_tax_data |
748: | to insert data into the JE_IT_LIST_LINES table |
749: | Called from JE_IT_LISTING_PKG.Extract_Data() |
750: | |
751: | SCOPE - Private |
752: | |
753: | NOTES |

Line 869: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Start PROCEDURE Fetch_trx_data_ap');

865: l_record_count NUMBER :=0;
866:
867: BEGIN
868: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
869: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Start PROCEDURE Fetch_trx_data_ap');
870: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Parameters are :');
871: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REPORTING_ENTITY_ID'||P_VAT_REPORTING_ENTITY_ID);
872: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_YEAR_OF_DECLARATION'||P_YEAR_OF_DECLARATION);
873:

Line 870: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Parameters are :');

866:
867: BEGIN
868: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
869: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Start PROCEDURE Fetch_trx_data_ap');
870: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Parameters are :');
871: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REPORTING_ENTITY_ID'||P_VAT_REPORTING_ENTITY_ID);
872: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_YEAR_OF_DECLARATION'||P_YEAR_OF_DECLARATION);
873:
874: IF P_VAT_REG= 'Y' THEN

Line 871: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REPORTING_ENTITY_ID'||P_VAT_REPORTING_ENTITY_ID);

867: BEGIN
868: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
869: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Start PROCEDURE Fetch_trx_data_ap');
870: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Parameters are :');
871: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REPORTING_ENTITY_ID'||P_VAT_REPORTING_ENTITY_ID);
872: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_YEAR_OF_DECLARATION'||P_YEAR_OF_DECLARATION);
873:
874: IF P_VAT_REG= 'Y' THEN
875: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is TRUE' );

Line 872: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_YEAR_OF_DECLARATION'||P_YEAR_OF_DECLARATION);

868: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
869: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Start PROCEDURE Fetch_trx_data_ap');
870: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Parameters are :');
871: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REPORTING_ENTITY_ID'||P_VAT_REPORTING_ENTITY_ID);
872: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_YEAR_OF_DECLARATION'||P_YEAR_OF_DECLARATION);
873:
874: IF P_VAT_REG= 'Y' THEN
875: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is TRUE' );
876: ELSE

Line 875: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is TRUE' );

871: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REPORTING_ENTITY_ID'||P_VAT_REPORTING_ENTITY_ID);
872: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_YEAR_OF_DECLARATION'||P_YEAR_OF_DECLARATION);
873:
874: IF P_VAT_REG= 'Y' THEN
875: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is TRUE' );
876: ELSE
877: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is FALSE' );
878: END IF;
879: END IF;

Line 877: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is FALSE' );

873:
874: IF P_VAT_REG= 'Y' THEN
875: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is TRUE' );
876: ELSE
877: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','P_VAT_REG is FALSE' );
878: END IF;
879: END IF;
880:
881: g_retcode :=0;

Line 908: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Calling insert_tax_data');

904:
905: l_record_count := l_record_count+ gt_trx_id.count;
906:
907: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
908: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Calling insert_tax_data');
909: END IF;
910:
911: SAVEPOINT before_insert_lines;
912: insert_tax_data(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,gn_ap_app_id);

Line 915: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Calling init_gt_variables');

911: SAVEPOINT before_insert_lines;
912: insert_tax_data(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,gn_ap_app_id);
913: COMMIT;
914: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
915: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Calling init_gt_variables');
916: END IF;
917: init_gt_variables;
918: EXIT WHEN trl_tax_data_csr%NOTFOUND;
919: END LOOP;

Line 923: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Number of AP records inserted into JE_IT_LIST_LINES :'||l_record_count);

919: END LOOP;
920:
921:
922: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
923: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Number of AP records inserted into JE_IT_LIST_LINES :'||l_record_count);
924: END IF;
925:
926: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
927: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','End PROCEDURE Fetch_trx_data_ap');

Line 927: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','End PROCEDURE Fetch_trx_data_ap');

923: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Number of AP records inserted into JE_IT_LIST_LINES :'||l_record_count);
924: END IF;
925:
926: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
927: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','End PROCEDURE Fetch_trx_data_ap');
928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: g_retcode :=2;

Line 932: g_errbuf :='Exception in JE_IT_LISTING_PKG.Fetch_trx_data_ap';

928: END IF;
929: EXCEPTION
930: WHEN OTHERS THEN
931: g_retcode :=2;
932: g_errbuf :='Exception in JE_IT_LISTING_PKG.Fetch_trx_data_ap';
933: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
934: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Exception in PROCEDURE Fetch_trx_data_ap');
935: END IF;
936: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 934: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Exception in PROCEDURE Fetch_trx_data_ap');

930: WHEN OTHERS THEN
931: g_retcode :=2;
932: g_errbuf :='Exception in JE_IT_LISTING_PKG.Fetch_trx_data_ap';
933: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
934: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Exception in PROCEDURE Fetch_trx_data_ap');
935: END IF;
936: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
937: IF g_debug_flag = 'Y' THEN
938: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 952: | Called from JE_IT_LISTING_PKG.Extract_Data() |

948: | DESCRIPTION |
949: | This procedure fetches the distribution lines from the AR |
950: | using bulk fetch and calls the procedure insert_tax_data |
951: | to insert data into the JE_IT_LIST_LINES table |
952: | Called from JE_IT_LISTING_PKG.Extract_Data() |
953: | |
954: | SCOPE - Private |
955: | |
956: | NOTES |

Line 1064: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Start PROCEDURE Fetch_trx_data_ar');

1060: l_record_count NUMBER := 0;
1061:
1062: BEGIN
1063: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1064: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Start PROCEDURE Fetch_trx_data_ar');
1065: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Parameters are :');
1066: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VATRE_REPORTING_ENTITY_ID='||P_VAT_REPORTING_ENTITY_ID);
1067: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_YEAR_OF_DECLARATION='||P_YEAR_OF_DECLARATION);
1068:

Line 1065: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Parameters are :');

1061:
1062: BEGIN
1063: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1064: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Start PROCEDURE Fetch_trx_data_ar');
1065: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Parameters are :');
1066: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VATRE_REPORTING_ENTITY_ID='||P_VAT_REPORTING_ENTITY_ID);
1067: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_YEAR_OF_DECLARATION='||P_YEAR_OF_DECLARATION);
1068:
1069: IF P_VAT_REG = 'Y' THEN

Line 1066: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VATRE_REPORTING_ENTITY_ID='||P_VAT_REPORTING_ENTITY_ID);

1062: BEGIN
1063: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1064: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Start PROCEDURE Fetch_trx_data_ar');
1065: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Parameters are :');
1066: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VATRE_REPORTING_ENTITY_ID='||P_VAT_REPORTING_ENTITY_ID);
1067: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_YEAR_OF_DECLARATION='||P_YEAR_OF_DECLARATION);
1068:
1069: IF P_VAT_REG = 'Y' THEN
1070: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is TRUE');

Line 1067: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_YEAR_OF_DECLARATION='||P_YEAR_OF_DECLARATION);

1063: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1064: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Start PROCEDURE Fetch_trx_data_ar');
1065: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Parameters are :');
1066: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VATRE_REPORTING_ENTITY_ID='||P_VAT_REPORTING_ENTITY_ID);
1067: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_YEAR_OF_DECLARATION='||P_YEAR_OF_DECLARATION);
1068:
1069: IF P_VAT_REG = 'Y' THEN
1070: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is TRUE');
1071: ELSE

Line 1070: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is TRUE');

1066: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VATRE_REPORTING_ENTITY_ID='||P_VAT_REPORTING_ENTITY_ID);
1067: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_YEAR_OF_DECLARATION='||P_YEAR_OF_DECLARATION);
1068:
1069: IF P_VAT_REG = 'Y' THEN
1070: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is TRUE');
1071: ELSE
1072: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is FALSE');
1073: END IF;
1074:

Line 1072: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is FALSE');

1068:
1069: IF P_VAT_REG = 'Y' THEN
1070: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is TRUE');
1071: ELSE
1072: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','P_VAT_REG is FALSE');
1073: END IF;
1074:
1075: END IF;
1076: g_retcode :=0;

Line 1105: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Calling insert_tax_data');

1101:
1102: l_record_count := l_record_count + gt_trx_id.count;
1103:
1104: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1105: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Calling insert_tax_data');
1106: END IF;
1107:
1108: SAVEPOINT before_insert_lines;
1109: insert_tax_data(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,gn_ar_app_id);

Line 1116: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Number of AR records inserted into JE_IT_LIST_LINES :'||l_record_count);

1112: EXIT WHEN trl_tax_data_csr%NOTFOUND;
1113: END LOOP;
1114:
1115: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1116: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Number of AR records inserted into JE_IT_LIST_LINES :'||l_record_count);
1117: END IF;
1118:
1119:
1120: EXCEPTION

Line 1123: g_errbuf :='Exception in JE_IT_LISTING_PKG.Fetch_trx_data_ar';

1119:
1120: EXCEPTION
1121: WHEN OTHERS THEN
1122: g_retcode :=2;
1123: g_errbuf :='Exception in JE_IT_LISTING_PKG.Fetch_trx_data_ar';
1124: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1125: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Exception in PROCEDURE Fetch_trx_data_ar');
1126: END IF;
1127: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 1125: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Exception in PROCEDURE Fetch_trx_data_ar');

1121: WHEN OTHERS THEN
1122: g_retcode :=2;
1123: g_errbuf :='Exception in JE_IT_LISTING_PKG.Fetch_trx_data_ar';
1124: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1125: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Exception in PROCEDURE Fetch_trx_data_ar');
1126: END IF;
1127: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1128: IF g_debug_flag = 'Y' THEN
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 1141: | Called from JE_IT_LISTING_PKG.Fetch_trx_data_ap() and |

1137: | Fetch_trx_data_ap |
1138: | |
1139: | DESCRIPTION |
1140: | This procedure inserts data into the JE_IT_LIST_LINES table |
1141: | Called from JE_IT_LISTING_PKG.Fetch_trx_data_ap() and |
1142: | JE_IT_LISTING_PKG.Fetch_trx_data_ar() |
1143: | SCOPE - Private |
1144: | |
1145: | NOTES |

Line 1142: | JE_IT_LISTING_PKG.Fetch_trx_data_ar() |

1138: | |
1139: | DESCRIPTION |
1140: | This procedure inserts data into the JE_IT_LIST_LINES table |
1141: | Called from JE_IT_LISTING_PKG.Fetch_trx_data_ap() and |
1142: | JE_IT_LISTING_PKG.Fetch_trx_data_ar() |
1143: | SCOPE - Private |
1144: | |
1145: | NOTES |
1146: | |

Line 1202: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Insert_tax_data');

1198: AND application_id = P_APP_ID
1199: AND tax_rate_id = P_TAX_RATE_ID;
1200: BEGIN
1201: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1202: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Insert_tax_data');
1203: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Parameters are :');
1204: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_vat_reporting_entity_id ='||p_vat_reporting_entity_id);
1205: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_year_of_declaration ='||p_year_of_declaration);
1206: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_app_id ='||p_app_id);

Line 1203: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Parameters are :');

1199: AND tax_rate_id = P_TAX_RATE_ID;
1200: BEGIN
1201: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1202: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Insert_tax_data');
1203: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Parameters are :');
1204: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_vat_reporting_entity_id ='||p_vat_reporting_entity_id);
1205: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_year_of_declaration ='||p_year_of_declaration);
1206: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_app_id ='||p_app_id);
1207: END IF;

Line 1204: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_vat_reporting_entity_id ='||p_vat_reporting_entity_id);

1200: BEGIN
1201: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1202: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Insert_tax_data');
1203: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Parameters are :');
1204: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_vat_reporting_entity_id ='||p_vat_reporting_entity_id);
1205: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_year_of_declaration ='||p_year_of_declaration);
1206: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_app_id ='||p_app_id);
1207: END IF;
1208: g_retcode :=0;

Line 1205: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_year_of_declaration ='||p_year_of_declaration);

1201: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1202: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Insert_tax_data');
1203: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Parameters are :');
1204: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_vat_reporting_entity_id ='||p_vat_reporting_entity_id);
1205: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_year_of_declaration ='||p_year_of_declaration);
1206: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_app_id ='||p_app_id);
1207: END IF;
1208: g_retcode :=0;
1209:

Line 1206: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_app_id ='||p_app_id);

1202: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Start PROCEDURE Insert_tax_data');
1203: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Parameters are :');
1204: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_vat_reporting_entity_id ='||p_vat_reporting_entity_id);
1205: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_year_of_declaration ='||p_year_of_declaration);
1206: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Insert_tax_data','p_app_id ='||p_app_id);
1207: END IF;
1208: g_retcode :=0;
1209:
1210: FOR i IN 1 .. g_lines_per_commit

Line 1510: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','End PROCEDURE Insert_tax_data');

1506: END LOOP;
1507:
1508:
1509: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1510: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','End PROCEDURE Insert_tax_data');
1511: END IF;
1512: EXCEPTION
1513: WHEN OTHERS THEN
1514: g_retcode :=2;

Line 1515: g_errbuf :='Exception in JE_IT_LISTING_PKG.Insert_tax_data';

1511: END IF;
1512: EXCEPTION
1513: WHEN OTHERS THEN
1514: g_retcode :=2;
1515: g_errbuf :='Exception in JE_IT_LISTING_PKG.Insert_tax_data';
1516: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1517: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Insert_tax_data');
1518: END IF;
1519: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 1517: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Insert_tax_data');

1513: WHEN OTHERS THEN
1514: g_retcode :=2;
1515: g_errbuf :='Exception in JE_IT_LISTING_PKG.Insert_tax_data';
1516: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1517: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Insert_tax_data');
1518: END IF;
1519: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1520: IF g_debug_flag = 'Y' THEN
1521: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 1545: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','Start PROCEDURE Init_gt_variables');

1541: +===========================================================================*/
1542: PROCEDURE Init_gt_variables IS
1543: BEGIN
1544: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1545: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','Start PROCEDURE Init_gt_variables');
1546: END IF;
1547: g_retcode :=0;
1548: gt_party_id.DELETE;
1549: gt_trx_type_code.DELETE;

Line 1570: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','End PROCEDURE Init_gt_variables');

1566: gt_party_vat_reg_num.DELETE;
1567: gt_party_fiscal_id_num.DELETE;
1568:
1569: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1570: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','End PROCEDURE Init_gt_variables');
1571: END IF;
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: g_retcode :=2;

Line 1575: g_errbuf :='Exception in JE_IT_LISTING_PKG.Init_gt_variables';

1571: END IF;
1572: EXCEPTION
1573: WHEN OTHERS THEN
1574: g_retcode :=2;
1575: g_errbuf :='Exception in JE_IT_LISTING_PKG.Init_gt_variables';
1576: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1577: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','Exception in PROCEDURE Insert_tax_data');
1578: END IF;
1579: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 1577: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','Exception in PROCEDURE Insert_tax_data');

1573: WHEN OTHERS THEN
1574: g_retcode :=2;
1575: g_errbuf :='Exception in JE_IT_LISTING_PKG.Init_gt_variables';
1576: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
1577: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','Exception in PROCEDURE Insert_tax_data');
1578: END IF;
1579: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1580: IF g_debug_flag = 'Y' THEN
1581: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 1811: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Start PROCEDURE Generate_trx_headers');

1807:
1808:
1809: BEGIN
1810: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1811: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Start PROCEDURE Generate_trx_headers');
1812: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Parameters are :');
1813: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
1814: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
1815: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VEND_SORT_COL ='||P_VEND_SORT_COL);

Line 1812: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Parameters are :');

1808:
1809: BEGIN
1810: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1811: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Start PROCEDURE Generate_trx_headers');
1812: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Parameters are :');
1813: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
1814: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
1815: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VEND_SORT_COL ='||P_VEND_SORT_COL);
1816: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_CUST_SORT_COL ='||P_CUST_SORT_COL);

Line 1813: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);

1809: BEGIN
1810: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1811: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Start PROCEDURE Generate_trx_headers');
1812: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Parameters are :');
1813: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
1814: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
1815: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VEND_SORT_COL ='||P_VEND_SORT_COL);
1816: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_CUST_SORT_COL ='||P_CUST_SORT_COL);
1817: END IF;

Line 1814: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);

1810: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1811: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Start PROCEDURE Generate_trx_headers');
1812: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Parameters are :');
1813: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
1814: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
1815: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VEND_SORT_COL ='||P_VEND_SORT_COL);
1816: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_CUST_SORT_COL ='||P_CUST_SORT_COL);
1817: END IF;
1818:

Line 1815: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VEND_SORT_COL ='||P_VEND_SORT_COL);

1811: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Start PROCEDURE Generate_trx_headers');
1812: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Parameters are :');
1813: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
1814: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
1815: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VEND_SORT_COL ='||P_VEND_SORT_COL);
1816: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_CUST_SORT_COL ='||P_CUST_SORT_COL);
1817: END IF;
1818:
1819: g_retcode :=0;

Line 1816: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_CUST_SORT_COL ='||P_CUST_SORT_COL);

1812: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Parameters are :');
1813: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VAT_REPORTING_ENTITY_ID ='||P_VAT_REPORTING_ENTITY_ID);
1814: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_YEAR_OF_DECLARATION ='||P_YEAR_OF_DECLARATION);
1815: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_VEND_SORT_COL ='||P_VEND_SORT_COL);
1816: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JL.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','P_CUST_SORT_COL ='||P_CUST_SORT_COL);
1817: END IF;
1818:
1819: g_retcode :=0;
1820: l_transnum :=1;

Line 1831: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');

1827:
1828: FOR rec_lines IN cur_trx_lines(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,P_CUST_SORT_COL ,P_VEND_SORT_COL ) LOOP
1829:
1830: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1831: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');
1832: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);
1833: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);
1834: END IF;
1835:

Line 1832: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);

1828: FOR rec_lines IN cur_trx_lines(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,P_CUST_SORT_COL ,P_VEND_SORT_COL ) LOOP
1829:
1830: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1831: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');
1832: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);
1833: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);
1834: END IF;
1835:
1836: IF l_count > nvl(g_rec_per_eft,l_count) THEN

Line 1833: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);

1829:
1830: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1831: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');
1832: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);
1833: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);
1834: END IF;
1835:
1836: IF l_count > nvl(g_rec_per_eft,l_count) THEN
1837: l_transnum := l_transnum + 1;

Line 1905: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');

1901:
1902: FOR rec_lines IN cur_trx_lines_group(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,P_CUST_SORT_COL ,P_VEND_SORT_COL ) LOOP
1903:
1904: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1905: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');
1906: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);
1907: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);
1908: END IF;
1909:

Line 1906: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);

1902: FOR rec_lines IN cur_trx_lines_group(P_VAT_REPORTING_ENTITY_ID,P_YEAR_OF_DECLARATION,P_CUST_SORT_COL ,P_VEND_SORT_COL ) LOOP
1903:
1904: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1905: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');
1906: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);
1907: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);
1908: END IF;
1909:
1910: IF l_count > nvl(g_rec_per_eft,l_count) THEN

Line 1907: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);

1903:
1904: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL ) THEN
1905: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Inside FOR rec_lines IN cur_trx_lines');
1906: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_transnum = '||l_transnum);
1907: FND_LOG.STRING(G_LEVEL_STATEMENT, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','l_count = '||l_count);
1908: END IF;
1909:
1910: IF l_count > nvl(g_rec_per_eft,l_count) THEN
1911: l_transnum := l_transnum + 1;

Line 1997: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','End PROCEDURE Generate_trx_headers');

1993:
1994: COMMIT;
1995:
1996: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
1997: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','End PROCEDURE Generate_trx_headers');
1998: END IF;
1999: EXCEPTION
2000: WHEN OTHERS THEN
2001: g_retcode :=2;

Line 2002: g_errbuf :='Exception in JE_IT_LISTING_PKG.Generate_trx_headers';

1998: END IF;
1999: EXCEPTION
2000: WHEN OTHERS THEN
2001: g_retcode :=2;
2002: g_errbuf :='Exception in JE_IT_LISTING_PKG.Generate_trx_headers';
2003: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2004: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Exception in PROCEDURE Generate_trx_headers');
2005: END IF;
2006: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 2004: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Exception in PROCEDURE Generate_trx_headers');

2000: WHEN OTHERS THEN
2001: g_retcode :=2;
2002: g_errbuf :='Exception in JE_IT_LISTING_PKG.Generate_trx_headers';
2003: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2004: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Exception in PROCEDURE Generate_trx_headers');
2005: END IF;
2006: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2007: IF g_debug_flag = 'Y' THEN
2008: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 2113: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_ledger_id = '||gv_ledger_id);

2109: gv_chart_of_accounts_id;
2110: CLOSE entity_details;
2111:
2112: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2113: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_ledger_id = '||gv_ledger_id);
2114: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_balancing_segment_value = '||gv_balancing_segment_value);
2115: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_chart_of_accounts_id = '||gv_chart_of_accounts_id);
2116: END IF;
2117:

Line 2114: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_balancing_segment_value = '||gv_balancing_segment_value);

2110: CLOSE entity_details;
2111:
2112: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2113: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_ledger_id = '||gv_ledger_id);
2114: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_balancing_segment_value = '||gv_balancing_segment_value);
2115: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_chart_of_accounts_id = '||gv_chart_of_accounts_id);
2116: END IF;
2117:
2118: EXCEPTION

Line 2115: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_chart_of_accounts_id = '||gv_chart_of_accounts_id);

2111:
2112: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2113: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_ledger_id = '||gv_ledger_id);
2114: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_balancing_segment_value = '||gv_balancing_segment_value);
2115: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_chart_of_accounts_id = '||gv_chart_of_accounts_id);
2116: END IF;
2117:
2118: EXCEPTION
2119: WHEN OTHERS THEN

Line 2121: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in Fetching ledger id,balancing segment value and chart of account id');

2117:
2118: EXCEPTION
2119: WHEN OTHERS THEN
2120: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2121: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in Fetching ledger id,balancing segment value and chart of account id');
2122: END IF;
2123: g_retcode :=2;
2124: g_errbuf :='Exception in Fetching ledger id,balancing segment value and chart of account id';
2125: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 2141: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gn_legal_entity_id = '||gn_legal_entity_id);

2137: ,gd_period_end_date;
2138: CLOSE c_get_le_and_period_dates;
2139:
2140: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2141: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gn_legal_entity_id = '||gn_legal_entity_id);
2142: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_repent_trn = '||gv_repent_trn);
2143: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_start_date = '||gd_period_start_date);
2144: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_end_date = '||gd_period_end_date);
2145: END IF;

Line 2142: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_repent_trn = '||gv_repent_trn);

2138: CLOSE c_get_le_and_period_dates;
2139:
2140: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2141: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gn_legal_entity_id = '||gn_legal_entity_id);
2142: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_repent_trn = '||gv_repent_trn);
2143: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_start_date = '||gd_period_start_date);
2144: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_end_date = '||gd_period_end_date);
2145: END IF;
2146:

Line 2143: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_start_date = '||gd_period_start_date);

2139:
2140: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2141: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gn_legal_entity_id = '||gn_legal_entity_id);
2142: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_repent_trn = '||gv_repent_trn);
2143: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_start_date = '||gd_period_start_date);
2144: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_end_date = '||gd_period_end_date);
2145: END IF;
2146:
2147: EXCEPTION

Line 2144: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_end_date = '||gd_period_end_date);

2140: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2141: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gn_legal_entity_id = '||gn_legal_entity_id);
2142: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_repent_trn = '||gv_repent_trn);
2143: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_start_date = '||gd_period_start_date);
2144: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gd_period_end_date = '||gd_period_end_date);
2145: END IF;
2146:
2147: EXCEPTION
2148: WHEN OTHERS THEN

Line 2150: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in Fetching start and end date of the declaration year');

2146:
2147: EXCEPTION
2148: WHEN OTHERS THEN
2149: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2150: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in Fetching start and end date of the declaration year');
2151: END IF;
2152: g_retcode :=2;
2153: g_errbuf :='Exception in Fetching start and end date of the declaration year';
2154: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 2170: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_currency_code = '||gv_currency_code);

2166: ,gv_vat_country_code ;
2167: CLOSE c_currency_vat_reg_num;
2168:
2169: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2170: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_currency_code = '||gv_currency_code);
2171: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_vat_country_code = '||gv_vat_country_code);
2172: END IF;
2173:
2174:

Line 2171: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_vat_country_code = '||gv_vat_country_code);

2167: CLOSE c_currency_vat_reg_num;
2168:
2169: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2170: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_currency_code = '||gv_currency_code);
2171: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','gv_vat_country_code = '||gv_vat_country_code);
2172: END IF;
2173:
2174:
2175: EXCEPTION

Line 2178: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in Fetching start and end date of the declaration year');

2174:
2175: EXCEPTION
2176: WHEN OTHERS THEN
2177: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2178: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in Fetching start and end date of the declaration year');
2179: END IF;
2180: g_retcode :=2;
2181: g_errbuf :='Exception in Fetching start and end date of the declaration year';
2182: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 2201: g_errbuf :='Exception in JE_IT_LISTING_PKG.Initialize_proc_var';

2197:
2198: EXCEPTION
2199: WHEN OTHERS THEN
2200: g_retcode :=2;
2201: g_errbuf :='Exception in JE_IT_LISTING_PKG.Initialize_proc_var';
2202: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2203: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in PROCEDURE Initialize_proc_var');
2204: END IF;
2205: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 2203: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in PROCEDURE Initialize_proc_var');

2199: WHEN OTHERS THEN
2200: g_retcode :=2;
2201: g_errbuf :='Exception in JE_IT_LISTING_PKG.Initialize_proc_var';
2202: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2203: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in PROCEDURE Initialize_proc_var');
2204: END IF;
2205: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2206: IF g_debug_flag = 'Y' THEN
2207: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 2253: g_errbuf :='Exception in JE_IT_LISTING_PKG.get_bsv';

2249:
2250: EXCEPTION
2251: WHEN NO_DATA_FOUND THEN
2252: g_retcode :=2;
2253: g_errbuf :='Exception in JE_IT_LISTING_PKG.get_bsv';
2254: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2255: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.get_bsv','Exception in FUNCTIONI get_bsv');
2256: END IF;
2257: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);

Line 2255: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.get_bsv','Exception in FUNCTIONI get_bsv');

2251: WHEN NO_DATA_FOUND THEN
2252: g_retcode :=2;
2253: g_errbuf :='Exception in JE_IT_LISTING_PKG.get_bsv';
2254: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
2255: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.get_bsv','Exception in FUNCTIONI get_bsv');
2256: END IF;
2257: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2258: IF g_debug_flag = 'Y' THEN
2259: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 2264: END JE_IT_LISTING_PKG;

2260: END IF;
2261: RETURN NULL;
2262: END get_bsv;
2263:
2264: END JE_IT_LISTING_PKG;
2265: