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_REVERSE_SALES_LIST_PKG dependencies on FND_LOG

Line 6: g_current_runtime_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

2: /*$Header: jeukrslrb.pls 120.6 2008/04/15 13:54:07 ashdas noship $*/
3: --------------------------------------------------------------------------------
4: --Global Variables
5: --------------------------------------------------------------------------------
6: g_current_runtime_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
7: g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
9: g_level_event CONSTANT NUMBER := fnd_log.level_event;
10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;

Line 7: g_level_statement CONSTANT NUMBER := fnd_log.level_statement;

3: --------------------------------------------------------------------------------
4: --Global Variables
5: --------------------------------------------------------------------------------
6: g_current_runtime_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
7: g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
9: g_level_event CONSTANT NUMBER := fnd_log.level_event;
10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
11: g_level_error CONSTANT NUMBER := fnd_log.level_error;

Line 8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;

4: --Global Variables
5: --------------------------------------------------------------------------------
6: g_current_runtime_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
7: g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
9: g_level_event CONSTANT NUMBER := fnd_log.level_event;
10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
11: g_level_error CONSTANT NUMBER := fnd_log.level_error;
12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;

Line 9: g_level_event CONSTANT NUMBER := fnd_log.level_event;

5: --------------------------------------------------------------------------------
6: g_current_runtime_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
7: g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
9: g_level_event CONSTANT NUMBER := fnd_log.level_event;
10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
11: g_level_error CONSTANT NUMBER := fnd_log.level_error;
12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
13: --------------------------------------------------------------------------------

Line 10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;

6: g_current_runtime_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
7: g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
9: g_level_event CONSTANT NUMBER := fnd_log.level_event;
10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
11: g_level_error CONSTANT NUMBER := fnd_log.level_error;
12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
13: --------------------------------------------------------------------------------
14: --Private Methods Declaration

Line 11: g_level_error CONSTANT NUMBER := fnd_log.level_error;

7: g_level_statement CONSTANT NUMBER := fnd_log.level_statement;
8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
9: g_level_event CONSTANT NUMBER := fnd_log.level_event;
10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
11: g_level_error CONSTANT NUMBER := fnd_log.level_error;
12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
13: --------------------------------------------------------------------------------
14: --Private Methods Declaration
15: --------------------------------------------------------------------------------

Line 12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;

8: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
9: g_level_event CONSTANT NUMBER := fnd_log.level_event;
10: g_level_exception CONSTANT NUMBER := fnd_log.level_exception;
11: g_level_error CONSTANT NUMBER := fnd_log.level_error;
12: g_level_unexpected CONSTANT NUMBER := fnd_log.level_unexpected;
13: --------------------------------------------------------------------------------
14: --Private Methods Declaration
15: --------------------------------------------------------------------------------
16: --PUBLIC Methods

Line 76: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Start FUNCTION beforeReport');

72: AND zl.application_id = 222
73: ORDER BY CUSTOMER_NAME;
74: BEGIN
75: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
76: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Start FUNCTION beforeReport');
77: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Parameters are :');
78: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_LEGAL_ENTITY ='||P_LEGAL_ENTITY);
79: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TAX_REG_NUM ='||P_TAX_REG_NUM);
80: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_FROM_DATE ='||P_FROM_DATE);

Line 77: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Parameters are :');

73: ORDER BY CUSTOMER_NAME;
74: BEGIN
75: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
76: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Start FUNCTION beforeReport');
77: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Parameters are :');
78: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_LEGAL_ENTITY ='||P_LEGAL_ENTITY);
79: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TAX_REG_NUM ='||P_TAX_REG_NUM);
80: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_FROM_DATE ='||P_FROM_DATE);
81: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TO_DATE ='||P_TO_DATE);

Line 78: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_LEGAL_ENTITY ='||P_LEGAL_ENTITY);

74: BEGIN
75: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
76: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Start FUNCTION beforeReport');
77: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Parameters are :');
78: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_LEGAL_ENTITY ='||P_LEGAL_ENTITY);
79: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TAX_REG_NUM ='||P_TAX_REG_NUM);
80: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_FROM_DATE ='||P_FROM_DATE);
81: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TO_DATE ='||P_TO_DATE);
82: END IF;

Line 79: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TAX_REG_NUM ='||P_TAX_REG_NUM);

75: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
76: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Start FUNCTION beforeReport');
77: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Parameters are :');
78: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_LEGAL_ENTITY ='||P_LEGAL_ENTITY);
79: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TAX_REG_NUM ='||P_TAX_REG_NUM);
80: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_FROM_DATE ='||P_FROM_DATE);
81: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TO_DATE ='||P_TO_DATE);
82: END IF;
83: FOR rec_customers IN c_customers LOOP

Line 80: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_FROM_DATE ='||P_FROM_DATE);

76: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Start FUNCTION beforeReport');
77: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Parameters are :');
78: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_LEGAL_ENTITY ='||P_LEGAL_ENTITY);
79: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TAX_REG_NUM ='||P_TAX_REG_NUM);
80: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_FROM_DATE ='||P_FROM_DATE);
81: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TO_DATE ='||P_TO_DATE);
82: END IF;
83: FOR rec_customers IN c_customers LOOP
84: lv_dynamic_sales := 'EMPTY';

Line 81: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TO_DATE ='||P_TO_DATE);

77: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Parameters are :');
78: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_LEGAL_ENTITY ='||P_LEGAL_ENTITY);
79: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TAX_REG_NUM ='||P_TAX_REG_NUM);
80: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_FROM_DATE ='||P_FROM_DATE);
81: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport',' P_TO_DATE ='||P_TO_DATE);
82: END IF;
83: FOR rec_customers IN c_customers LOOP
84: lv_dynamic_sales := 'EMPTY';
85: ln_total_sales := 0;

Line 88: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In Cursor c_customers');

84: lv_dynamic_sales := 'EMPTY';
85: ln_total_sales := 0;
86: lv_cust_vat_reg_num := NVL(SUBSTR(rec_customers.CUST_VAT_REG_NUM,3,LENGTH(rec_customers.CUST_VAT_REG_NUM)),-99);
87: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
88: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In Cursor c_customers');
89: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_ID'||rec_customers.CUSTOMER_ID);
90: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NUMBER'||rec_customers.CUSTOMER_NUMBER);
91: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NAME'||rec_customers.CUSTOMER_NAME);
92: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUST_VAT_REG_NUM'||rec_customers.CUST_VAT_REG_NUM);

Line 89: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_ID'||rec_customers.CUSTOMER_ID);

85: ln_total_sales := 0;
86: lv_cust_vat_reg_num := NVL(SUBSTR(rec_customers.CUST_VAT_REG_NUM,3,LENGTH(rec_customers.CUST_VAT_REG_NUM)),-99);
87: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
88: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In Cursor c_customers');
89: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_ID'||rec_customers.CUSTOMER_ID);
90: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NUMBER'||rec_customers.CUSTOMER_NUMBER);
91: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NAME'||rec_customers.CUSTOMER_NAME);
92: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUST_VAT_REG_NUM'||rec_customers.CUST_VAT_REG_NUM);
93: END IF;

Line 90: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NUMBER'||rec_customers.CUSTOMER_NUMBER);

86: lv_cust_vat_reg_num := NVL(SUBSTR(rec_customers.CUST_VAT_REG_NUM,3,LENGTH(rec_customers.CUST_VAT_REG_NUM)),-99);
87: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
88: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In Cursor c_customers');
89: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_ID'||rec_customers.CUSTOMER_ID);
90: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NUMBER'||rec_customers.CUSTOMER_NUMBER);
91: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NAME'||rec_customers.CUSTOMER_NAME);
92: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUST_VAT_REG_NUM'||rec_customers.CUST_VAT_REG_NUM);
93: END IF;
94: FOR rec_period_range IN c_period_range LOOP

Line 91: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NAME'||rec_customers.CUSTOMER_NAME);

87: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
88: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In Cursor c_customers');
89: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_ID'||rec_customers.CUSTOMER_ID);
90: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NUMBER'||rec_customers.CUSTOMER_NUMBER);
91: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NAME'||rec_customers.CUSTOMER_NAME);
92: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUST_VAT_REG_NUM'||rec_customers.CUST_VAT_REG_NUM);
93: END IF;
94: FOR rec_period_range IN c_period_range LOOP
95: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 92: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUST_VAT_REG_NUM'||rec_customers.CUST_VAT_REG_NUM);

88: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In Cursor c_customers');
89: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_ID'||rec_customers.CUSTOMER_ID);
90: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NUMBER'||rec_customers.CUSTOMER_NUMBER);
91: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUSTOMER_NAME'||rec_customers.CUSTOMER_NAME);
92: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUST_VAT_REG_NUM'||rec_customers.CUST_VAT_REG_NUM);
93: END IF;
94: FOR rec_period_range IN c_period_range LOOP
95: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
96: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Period Range:'||rec_period_range.PERIOD);

Line 96: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Period Range:'||rec_period_range.PERIOD);

92: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','CUST_VAT_REG_NUM'||rec_customers.CUST_VAT_REG_NUM);
93: END IF;
94: FOR rec_period_range IN c_period_range LOOP
95: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
96: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Period Range:'||rec_period_range.PERIOD);
97: END IF;
98: ln_sales_amount := 0;
99: IF TO_CHAR(TO_DATE(P_FROM_DATE,'YYYY/MM/DD HH24:MI:SS'),'Mon-YYYY')= TO_CHAR(rec_period_range.PERIOD,'Mon-YYYY') THEN
100: ld_from_date := TO_DATE(P_FROM_DATE,'YYYY/MM/DD HH24:MI:SS');

Line 110: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','From Date:'||ld_from_date);

106: ELSE
107: ld_to_date := LAST_DAY(rec_period_range.PERIOD);
108: END IF;
109: IF(G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','From Date:'||ld_from_date);
111: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','To Date:'||ld_to_date);
112: END IF;
113: BEGIN
114: SELECT ROUND(NVL(SUM(trx_lines.extended_amount),0))

Line 111: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','To Date:'||ld_to_date);

107: ld_to_date := LAST_DAY(rec_period_range.PERIOD);
108: END IF;
109: IF(G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
110: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','From Date:'||ld_from_date);
111: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','To Date:'||ld_to_date);
112: END IF;
113: BEGIN
114: SELECT ROUND(NVL(SUM(trx_lines.extended_amount),0))
115: INTO ln_sales_amount

Line 145: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Exception in getting Sales Amount');

141: AND zrt.reporting_type_code ='REVERSE_CHARGE_VAT';
142: EXCEPTION
143: WHEN others THEN
144: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
145: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Exception in getting Sales Amount');
146: END IF;
147: ln_sales_amount := 0;
148: END;
149: IF lv_dynamic_sales = 'EMPTY' THEN

Line 156: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Sales Amount'||TO_CHAR(ln_sales_amount));

152: lv_dynamic_sales := lv_dynamic_sales||','||ln_sales_amount;
153: END IF;
154: ln_total_sales := ln_total_sales + ln_sales_amount;
155: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
156: FND_LOG.STRING(G_LEVEL_PROCEDURE, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Sales Amount'||TO_CHAR(ln_sales_amount));
157: END IF;
158: BEGIN
159: INSERT INTO je_uk_sales_trx_gt
160: (

Line 184: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Exception in Inserting in GT for CL');

180: );
181: EXCEPTION
182: WHEN others THEN
183: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
184: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Exception in Inserting in GT for CL');
185: END IF;
186: END;
187: END LOOP; -- End Loop rec_period_range
188: IF ln_total_sales = 0 THEN

Line 195: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In DELETE je_uk_sales_trx_gt');

191: AND je_info_n1 = rec_customers.CUSTOMER_ID
192: AND je_info_v2 = rec_customers.CUSTOMER_NUMBER
193: AND je_info_v4 = lv_cust_vat_reg_num;
194: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
195: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In DELETE je_uk_sales_trx_gt');
196: END IF;
197: ELSE
198: BEGIN
199: INSERT INTO je_uk_sales_trx_gt

Line 213: FND_LOG.STRING(G_LEVEL_EXCEPTION,'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In INSERT je_uk_sales_trx_gt for type CS');

209: lv_dynamic_sales := 'EMPTY';
210: EXCEPTION
211: WHEN others THEN
212: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN
213: FND_LOG.STRING(G_LEVEL_EXCEPTION,'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','In INSERT je_uk_sales_trx_gt for type CS');
214: END IF;
215: NULL;
216: END;
217: END IF;

Line 220: FND_LOG.STRING(G_LEVEL_PROCEDURE,'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Exiting before Report');

216: END;
217: END IF;
218: END LOOP; --End Loop rec_customers
219: IF(G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
220: FND_LOG.STRING(G_LEVEL_PROCEDURE,'JE.plsql.JE_REVERSE_SALES_LIST_PKG.beforeReport','Exiting before Report');
221: END IF;
222: RETURN TRUE;
223: END beforeReport;
224: END JE_REVERSE_SALES_LIST_PKG;