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.JG_ZZ_JOURNAL_AP_PKG dependencies on FND_FILE

Line 84: fnd_file.put_line(fnd_file.log,' Inside BeforeReport ');

80: l_tax_regime VARCHAR2(240);
81: l_vat_register_name VARCHAR2(240);
82: l_start_seq NUMBER(15);
83: BEGIN
84: fnd_file.put_line(fnd_file.log,' ** Inside BeforeReport ** ');
85: p_debug_flag := 'Y' ;
86:
87: IF P_REPORT_NAME IN ('JEITAPSR', 'JEITAPPV') THEN
88: BEGIN

Line 89: fnd_file.put_line(fnd_file.log,'Fetching Register name...');

85: p_debug_flag := 'Y' ;
86:
87: IF P_REPORT_NAME IN ('JEITAPSR', 'JEITAPPV') THEN
88: BEGIN
89: fnd_file.put_line(fnd_file.log,'Fetching Register name...');
90: SELECT register_name
91: INTO l_vat_register_name
92: FROM jg_zz_vat_registers_vl
93: WHERE vat_register_id = p_vat_register_id ;

Line 96: fnd_file.put_line(fnd_file.log,'Cannot derive VAT Register Name for Register ID:'||p_vat_register_id) ;

92: FROM jg_zz_vat_registers_vl
93: WHERE vat_register_id = p_vat_register_id ;
94: EXCEPTION
95: WHEN NO_DATA_FOUND THEN
96: fnd_file.put_line(fnd_file.log,'Cannot derive VAT Register Name for Register ID:'||p_vat_register_id) ;
97: l_rec_count := 0;
98: RAISE ;
99: END ;
100: END IF ;

Line 102: fnd_file.put_line(fnd_file.log,'**********************************************************');

98: RAISE ;
99: END ;
100: END IF ;
101: IF p_debug_flag = 'Y' THEN
102: fnd_file.put_line(fnd_file.log,'**********************************************************');
103: IF P_REPORT_NAME = 'JEITAPSR' THEN
104: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
105: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
106: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');

Line 104: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');

100: END IF ;
101: IF p_debug_flag = 'Y' THEN
102: fnd_file.put_line(fnd_file.log,'**********************************************************');
103: IF P_REPORT_NAME = 'JEITAPSR' THEN
104: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
105: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
106: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
107: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
108: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');

Line 106: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');

102: fnd_file.put_line(fnd_file.log,'**********************************************************');
103: IF P_REPORT_NAME = 'JEITAPSR' THEN
104: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
105: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
106: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
107: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
108: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
109: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
110: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');

Line 108: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');

104: fnd_file.put_line(fnd_file.log,' Italian Sales VAT Register ');
105: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
106: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
107: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
108: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
109: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
110: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
111: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
112: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');

Line 110: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');

106: fnd_file.put_line(fnd_file.log,' Italian Purchase VAT Register ');
107: ELSIF P_REPORT_NAME = 'JEBEDV08' THEN
108: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
109: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
110: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
111: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
112: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
113: END IF;
114: fnd_file.put_line(fnd_file.log,'**********************************************************');

Line 112: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');

108: fnd_file.put_line(fnd_file.log,' Belgian VAT Purchases Journal ');
109: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
110: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
111: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
112: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
113: END IF;
114: fnd_file.put_line(fnd_file.log,'**********************************************************');
115: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );

Line 114: fnd_file.put_line(fnd_file.log,'**********************************************************');

110: fnd_file.put_line(fnd_file.log,' Spanish Inter-EU Invoices Journal Report ');
111: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
112: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
113: END IF;
114: fnd_file.put_line(fnd_file.log,'**********************************************************');
115: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);

Line 115: fnd_file.put_line(fnd_file.log,' Report Paramters ');

111: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
112: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
113: END IF;
114: fnd_file.put_line(fnd_file.log,'**********************************************************');
115: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );

Line 116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );

112: fnd_file.put_line(fnd_file.log,' Spanish Input VAT Journal Report ');
113: END IF;
114: fnd_file.put_line(fnd_file.log,'**********************************************************');
115: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );

Line 117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );

113: END IF;
114: fnd_file.put_line(fnd_file.log,'**********************************************************');
115: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );

Line 118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);

114: fnd_file.put_line(fnd_file.log,'**********************************************************');
115: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );

Line 119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );

115: fnd_file.put_line(fnd_file.log,' ** Report Paramters ** ');
116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );

Line 120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );

116: fnd_file.put_line(fnd_file.log,'P_VAT_REP_ENTITY_ID :'|| P_VAT_REP_ENTITY_ID );
117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );

Line 121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );

117: fnd_file.put_line(fnd_file.log,'P_PERIOD :'|| P_PERIOD );
118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );

Line 122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );

118: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_FROM:'|| P_DOCUMENT_SEQUENCE_NAME_FROM);
119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );

Line 123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );

119: fnd_file.put_line(fnd_file.log,'P_DOCUMENT_SEQUENCE_NAME_TO :'|| P_DOCUMENT_SEQUENCE_NAME_TO );
120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );

Line 124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );

120: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_FROM :'|| P_VENDOR_NAME_FROM );
121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );

Line 125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );

121: fnd_file.put_line(fnd_file.log,'P_VENDOR_NAME_TO :'|| P_VENDOR_NAME_TO );
122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
129: fnd_file.put_line(fnd_file.log,' ');

Line 126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );

122: fnd_file.put_line(fnd_file.log,'P_DETAIL_SUMMARY :'|| P_DETAIL_SUMMARY );
123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
129: fnd_file.put_line(fnd_file.log,' ');
130: END IF ;

Line 127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );

123: fnd_file.put_line(fnd_file.log,'P_VAT_REGISTER_ID :'|| P_VAT_REGISTER_ID );
124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
129: fnd_file.put_line(fnd_file.log,' ');
130: END IF ;
131:

Line 128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );

124: fnd_file.put_line(fnd_file.log,'P_TAX_TYPE :'|| P_TAX_TYPE );
125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
129: fnd_file.put_line(fnd_file.log,' ');
130: END IF ;
131:
132: fnd_file.put_line(fnd_file.log,'Before Report Trigger');

Line 129: fnd_file.put_line(fnd_file.log,' ');

125: fnd_file.put_line(fnd_file.log,'P_REGISTER_TYPE :'|| P_REGISTER_TYPE );
126: fnd_file.put_line(fnd_file.log,'P_START_INV_SEQUENCE :'|| P_START_INV_SEQUENCE );
127: fnd_file.put_line(fnd_file.log,'P_BALANCING_SEGMENT :'|| P_BALANCING_SEGMENT );
128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
129: fnd_file.put_line(fnd_file.log,' ');
130: END IF ;
131:
132: fnd_file.put_line(fnd_file.log,'Before Report Trigger');
133: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr

Line 132: fnd_file.put_line(fnd_file.log,'Before Report Trigger');

128: fnd_file.put_line(fnd_file.log,'P_REPORT_NAME :'|| P_REPORT_NAME );
129: fnd_file.put_line(fnd_file.log,' ');
130: END IF ;
131:
132: fnd_file.put_line(fnd_file.log,'Before Report Trigger');
133: jg_zz_common_pkg.funct_curr_legal(x_func_curr_code => l_func_curr
134: ,x_rep_entity_name => l_legal_entity_name
135: ,x_legal_entity_id => l_legal_entity_id
136: ,x_taxpayer_id => l_tax_payer_id

Line 140: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );

136: ,x_taxpayer_id => l_tax_payer_id
137: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
138: ,pv_period_name => p_period);
139: IF p_debug_flag = 'Y' THEN
140: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
141: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
142: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
143: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
144: fnd_file.put_line(fnd_file.log,' ');

Line 141: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );

137: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
138: ,pv_period_name => p_period);
139: IF p_debug_flag = 'Y' THEN
140: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
141: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
142: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
143: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
144: fnd_file.put_line(fnd_file.log,' ');
145: END IF ;

Line 142: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );

138: ,pv_period_name => p_period);
139: IF p_debug_flag = 'Y' THEN
140: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
141: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
142: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
143: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
144: fnd_file.put_line(fnd_file.log,' ');
145: END IF ;
146:

Line 143: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );

139: IF p_debug_flag = 'Y' THEN
140: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
141: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
142: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
143: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
144: fnd_file.put_line(fnd_file.log,' ');
145: END IF ;
146:
147: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');

Line 144: fnd_file.put_line(fnd_file.log,' ');

140: fnd_file.put_line(fnd_file.log,'l_func_curr :'|| l_func_curr );
141: fnd_file.put_line(fnd_file.log,'l_legal_entity_name :'|| l_legal_entity_name );
142: fnd_file.put_line(fnd_file.log,'l_legal_entity_id :'|| l_legal_entity_id );
143: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
144: fnd_file.put_line(fnd_file.log,' ');
145: END IF ;
146:
147: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
148: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num

Line 147: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');

143: fnd_file.put_line(fnd_file.log,'l_tax_payer_id :'|| l_tax_payer_id );
144: fnd_file.put_line(fnd_file.log,' ');
145: END IF ;
146:
147: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.tax_registration');
148: jg_zz_common_pkg.tax_registration(x_tax_registration => l_tax_registration_num
149: ,x_period_start_date => l_period_start_date
150: ,x_period_end_date => l_period_end_date
151: ,x_status => l_reporting_status

Line 156: fnd_file.put_line(fnd_file.log,'JG_ZZ_VAT_REP_UTILITY.get_period_status');

152: ,pn_vat_rep_entity_id => p_vat_rep_entity_id
153: ,pv_period_name => p_period
154: ,pv_source => 'ALL');
155:
156: fnd_file.put_line(fnd_file.log,'JG_ZZ_VAT_REP_UTILITY.get_period_status');
157: IF P_REPORT_NAME = 'JEITAPSR' OR P_REPORT_NAME = 'JEITAPPV' THEN
158: -- Get the Start Sequence Number for the Previous Finally Reported period for same report and vat register.
159: l_start_seq := get_start_sequence;
160:

Line 195: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );

191: ,pv_report_name => p_report_name);
192: END IF;
193:
194: IF p_debug_flag = 'Y' THEN
195: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
196: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
197: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
198: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
199: fnd_file.put_line(fnd_file.log,' ');

Line 196: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );

192: END IF;
193:
194: IF p_debug_flag = 'Y' THEN
195: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
196: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
197: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
198: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
199: fnd_file.put_line(fnd_file.log,' ');
200: END IF ;

Line 197: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );

193:
194: IF p_debug_flag = 'Y' THEN
195: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
196: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
197: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
198: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
199: fnd_file.put_line(fnd_file.log,' ');
200: END IF ;
201: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');

Line 198: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );

194: IF p_debug_flag = 'Y' THEN
195: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
196: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
197: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
198: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
199: fnd_file.put_line(fnd_file.log,' ');
200: END IF ;
201: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
202: jg_zz_common_pkg.company_detail(x_company_name => l_company_name

Line 199: fnd_file.put_line(fnd_file.log,' ');

195: fnd_file.put_line(fnd_file.log,'l_tax_registration_num:'|| l_tax_registration_num );
196: fnd_file.put_line(fnd_file.log,'l_period_start_date :'|| l_period_start_date );
197: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
198: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
199: fnd_file.put_line(fnd_file.log,' ');
200: END IF ;
201: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
202: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
203: ,x_registration_number => l_registration_num

Line 201: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');

197: fnd_file.put_line(fnd_file.log,'l_period_end_date :'|| l_period_end_date );
198: fnd_file.put_line(fnd_file.log,'l_reporting_status :'|| l_reporting_status );
199: fnd_file.put_line(fnd_file.log,' ');
200: END IF ;
201: fnd_file.put_line(fnd_file.log,'Calling jg_zz_common_pkg.company_detail');
202: jg_zz_common_pkg.company_detail(x_company_name => l_company_name
203: ,x_registration_number => l_registration_num
204: ,x_country => l_country
205: ,x_address1 => l_address_line_1

Line 220: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );

216: ,pn_legal_entity_id => l_legal_entity_id
217: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
221: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );

Line 221: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );

217: ,p_vat_reporting_entity_id => P_VAT_REP_ENTITY_ID);
218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
221: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );

Line 222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );

218:
219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
221: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );

Line 223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );

219: IF p_debug_flag = 'Y' THEN
220: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
221: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );

Line 224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );

220: fnd_file.put_line(fnd_file.log,'l_company_name :'|| l_company_name );
221: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );

Line 225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );

221: fnd_file.put_line(fnd_file.log,'l_registration_num:'|| l_registration_num );
222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );

Line 226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );

222: fnd_file.put_line(fnd_file.log,'l_country :'|| l_country );
223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
230: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );

Line 227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );

223: fnd_file.put_line(fnd_file.log,'l_address_line_1 :'|| l_address_line_1 );
224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
230: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
231: fnd_file.put_line(fnd_file.log,' ');

Line 228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );

224: fnd_file.put_line(fnd_file.log,'l_address_line_2 :'|| l_address_line_2 );
225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
230: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
231: fnd_file.put_line(fnd_file.log,' ');
232: END IF ;

Line 229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );

225: fnd_file.put_line(fnd_file.log,'l_address_line_3 :'|| l_address_line_3 );
226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
230: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
231: fnd_file.put_line(fnd_file.log,' ');
232: END IF ;
233:

Line 230: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );

226: fnd_file.put_line(fnd_file.log,'l_address_line_4 :'|| l_address_line_4 );
227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
230: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
231: fnd_file.put_line(fnd_file.log,' ');
232: END IF ;
233:
234:

Line 231: fnd_file.put_line(fnd_file.log,' ');

227: fnd_file.put_line(fnd_file.log,'l_city :'|| l_city );
228: fnd_file.put_line(fnd_file.log,'l_postal_code :'|| l_postal_code );
229: fnd_file.put_line(fnd_file.log,'l_contact_name :'|| l_contact_name );
230: fnd_file.put_line(fnd_file.log,'l_phone_number :'|| l_phone_number );
231: fnd_file.put_line(fnd_file.log,' ');
232: END IF ;
233:
234:
235:

Line 237: fnd_file.put_line(fnd_file.log,'Calling JEBEDV08');

233:
234:
235:
236: IF P_REPORT_NAME = 'JEBEDV08' THEN
237: fnd_file.put_line(fnd_file.log,'Calling JEBEDV08');
238: jebedv08(p_vat_rep_entity_id => p_vat_rep_entity_id
239: ,p_period => p_period
240: ,p_document_sequence_name_from => p_document_sequence_name_from
241: ,p_document_sequence_name_to => p_document_sequence_name_to

Line 246: fnd_file.put_line(fnd_file.log,'After Calling JEBEDV08');

242: ,p_vendor_name_from => p_vendor_name_from
243: ,p_vendor_name_to => p_vendor_name_to
244: ,p_detail_summary => p_detail_summary
245: ,x_err_msg => l_err_msg);
246: fnd_file.put_line(fnd_file.log,'After Calling JEBEDV08');
247: ELSIF P_REPORT_NAME = 'JEITAPSR' THEN
248: fnd_file.put_line(fnd_file.log,'Calling JEITAPSR');
249: jeitapsr(p_vat_rep_entity_id => p_vat_rep_entity_id
250: ,p_period => p_period

Line 248: fnd_file.put_line(fnd_file.log,'Calling JEITAPSR');

244: ,p_detail_summary => p_detail_summary
245: ,x_err_msg => l_err_msg);
246: fnd_file.put_line(fnd_file.log,'After Calling JEBEDV08');
247: ELSIF P_REPORT_NAME = 'JEITAPSR' THEN
248: fnd_file.put_line(fnd_file.log,'Calling JEITAPSR');
249: jeitapsr(p_vat_rep_entity_id => p_vat_rep_entity_id
250: ,p_period => p_period
251: ,p_vat_register_id => p_vat_register_id
252: ,x_err_msg => l_err_msg);

Line 253: fnd_file.put_line(fnd_file.log,'After Calling JEITAPSR');

249: jeitapsr(p_vat_rep_entity_id => p_vat_rep_entity_id
250: ,p_period => p_period
251: ,p_vat_register_id => p_vat_register_id
252: ,x_err_msg => l_err_msg);
253: fnd_file.put_line(fnd_file.log,'After Calling JEITAPSR');
254: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
255: fnd_file.put_line(fnd_file.log,'Calling JEITAPPV');
256: jeitappv(p_vat_rep_entity_id => p_vat_rep_entity_id
257: ,p_period => p_period

Line 255: fnd_file.put_line(fnd_file.log,'Calling JEITAPPV');

251: ,p_vat_register_id => p_vat_register_id
252: ,x_err_msg => l_err_msg);
253: fnd_file.put_line(fnd_file.log,'After Calling JEITAPSR');
254: ELSIF P_REPORT_NAME = 'JEITAPPV' THEN
255: fnd_file.put_line(fnd_file.log,'Calling JEITAPPV');
256: jeitappv(p_vat_rep_entity_id => p_vat_rep_entity_id
257: ,p_period => p_period
258: ,p_vat_register_id => p_vat_register_id
259: ,x_err_msg => l_err_msg);

Line 260: fnd_file.put_line(fnd_file.log,'After Calling JEITAPPV');

256: jeitappv(p_vat_rep_entity_id => p_vat_rep_entity_id
257: ,p_period => p_period
258: ,p_vat_register_id => p_vat_register_id
259: ,x_err_msg => l_err_msg);
260: fnd_file.put_line(fnd_file.log,'After Calling JEITAPPV');
261: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
262: fnd_file.put_line(fnd_file.log,'Calling JEESRVAR');
263: jeesrvar(p_vat_rep_entity_id => p_vat_rep_entity_id
264: ,p_period => p_period

Line 262: fnd_file.put_line(fnd_file.log,'Calling JEESRVAR');

258: ,p_vat_register_id => p_vat_register_id
259: ,x_err_msg => l_err_msg);
260: fnd_file.put_line(fnd_file.log,'After Calling JEITAPPV');
261: ELSIF P_REPORT_NAME = 'JEESRVAR' THEN
262: fnd_file.put_line(fnd_file.log,'Calling JEESRVAR');
263: jeesrvar(p_vat_rep_entity_id => p_vat_rep_entity_id
264: ,p_period => p_period
265: ,p_tax_type => p_tax_type
266: ,p_balancing_segment => p_balancing_segment

Line 269: fnd_file.put_line(fnd_file.log,'After Calling JEESRVAR');

265: ,p_tax_type => p_tax_type
266: ,p_balancing_segment => p_balancing_segment
267: ,p_start_inv_sequence => p_start_inv_sequence
268: ,x_err_msg => l_err_msg);
269: fnd_file.put_line(fnd_file.log,'After Calling JEESRVAR');
270: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
271: fnd_file.put_line(fnd_file.log,'Calling Procedure JEESRPVP');
272: jeesrpvp(p_vat_rep_entity_id => p_vat_rep_entity_id
273: ,p_period => p_period

Line 271: fnd_file.put_line(fnd_file.log,'Calling Procedure JEESRPVP');

267: ,p_start_inv_sequence => p_start_inv_sequence
268: ,x_err_msg => l_err_msg);
269: fnd_file.put_line(fnd_file.log,'After Calling JEESRVAR');
270: ELSIF P_REPORT_NAME = 'JEESRPVP' THEN
271: fnd_file.put_line(fnd_file.log,'Calling Procedure JEESRPVP');
272: jeesrpvp(p_vat_rep_entity_id => p_vat_rep_entity_id
273: ,p_period => p_period
274: ,p_tax_type => p_tax_type
275: ,p_register_type => p_register_type

Line 279: fnd_file.put_line(fnd_file.log,'After Calling JEESRPVP');

275: ,p_register_type => p_register_type
276: ,p_balancing_segment => p_balancing_segment
277: ,p_start_inv_sequence => p_start_inv_sequence
278: ,x_err_msg => l_err_msg);
279: fnd_file.put_line(fnd_file.log,'After Calling JEESRPVP');
280: ELSIF P_REPORT_NAME is null THEN
281: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');
282: journal_ap(p_vat_rep_entity_id => p_vat_rep_entity_id
283: ,p_period => p_period

Line 281: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');

277: ,p_start_inv_sequence => p_start_inv_sequence
278: ,x_err_msg => l_err_msg);
279: fnd_file.put_line(fnd_file.log,'After Calling JEESRPVP');
280: ELSIF P_REPORT_NAME is null THEN
281: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');
282: journal_ap(p_vat_rep_entity_id => p_vat_rep_entity_id
283: ,p_period => p_period
284: ,x_err_msg => l_err_msg);
285: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');

Line 285: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');

281: fnd_file.put_line(fnd_file.log,'Calling JOURNAL_AP');
282: journal_ap(p_vat_rep_entity_id => p_vat_rep_entity_id
283: ,p_period => p_period
284: ,x_err_msg => l_err_msg);
285: fnd_file.put_line(fnd_file.log,'After Calling JOURNAL_AP');
286: END IF;
287:
288: INSERT INTO jg_zz_vat_trx_gt
289: ( jg_info_n1

Line 346: fnd_file.put_line(fnd_file.log,'Error occurred in beforeReport.' || SQLERRM || SQLCODE);

342:
343: RETURN (TRUE);
344: EXCEPTION
345: WHEN OTHERS THEN
346: fnd_file.put_line(fnd_file.log,'Error occurred in beforeReport.' || SQLERRM || SQLCODE);
347: RETURN (FALSE);
348: END beforeReport;
349:
350: --

Line 551: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

547: FROM jg_zz_vat_trx_gt
548: WHERE jg_info_v30='JEBEDV08';
549:
550: IF p_debug_flag = 'Y' THEN
551: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
552: END IF ;
553:
554: EXCEPTION
555: WHEN OTHERS THEN

Line 556: fnd_file.put_line(fnd_file.log,'Error occurred in jebedv08 procedure.' || SQLERRM || SQLCODE);

552: END IF ;
553:
554: EXCEPTION
555: WHEN OTHERS THEN
556: fnd_file.put_line(fnd_file.log,'Error occurred in jebedv08 procedure.' || SQLERRM || SQLCODE);
557: END jebedv08;
558:
559: --
560: -- +======================================================================+

Line 719: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

715: FROM jg_zz_vat_trx_gt
716: WHERE jg_info_v30='JEITAPSR';
717:
718: IF p_debug_flag = 'Y' THEN
719: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
720: END IF ;
721:
722: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
723: IF lv_reporting_status = 'FINAL' THEN

Line 763: fnd_file.put_line(fnd_file.log,'Error in procedure jeitapsr.' || SQLERRM || SQLCODE);

759: END IF;
760:
761: EXCEPTION
762: WHEN OTHERS THEN
763: fnd_file.put_line(fnd_file.log,'Error in procedure jeitapsr.' || SQLERRM || SQLCODE);
764: END jeitapsr;
765:
766: --
767: -- +======================================================================+

Line 935: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

931: FROM jg_zz_vat_trx_gt
932: WHERE jg_info_v30='JEITAPPV';
933:
934: IF p_debug_flag = 'Y' THEN
935: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
936: END IF ;
937:
938: -- Update teh jg_zz_vat_final_reports table for print sequence numbers if lv_reporting_status = 'FINAL'
939: IF lv_reporting_status = 'FINAL' THEN

Line 983: fnd_file.put_line(fnd_file.log,'Error occurred in procedure jeitappv.' || SQLERRM || SQLCODE);

979: END IF;
980:
981: EXCEPTION
982: WHEN OTHERS THEN
983: fnd_file.put_line(fnd_file.log,'Error occurred in procedure jeitappv.' || SQLERRM || SQLCODE);
984: END jeitappv;
985:
986: --
987: -- +======================================================================+

Line 1084: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1080: FROM jg_zz_vat_trx_gt
1081: WHERE jg_info_v30='JEESRVAR';
1082:
1083: IF p_debug_flag = 'Y' THEN
1084: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1085: END IF ;
1086:
1087: EXCEPTION
1088: WHEN OTHERS THEN

Line 1089: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1085: END IF ;
1086:
1087: EXCEPTION
1088: WHEN OTHERS THEN
1089: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1090: END jeesrvar;
1091:
1092: --
1093: -- +======================================================================+

Line 1248: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1244: FROM jg_zz_vat_trx_gt
1245: WHERE jg_info_v30='JEESRPVP';
1246:
1247: IF p_debug_flag = 'Y' THEN
1248: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1249: END IF ;
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN

Line 1253: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1249: END IF ;
1250:
1251: EXCEPTION
1252: WHEN OTHERS THEN
1253: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1254: END jeesrpvp;
1255:
1256: --
1257: -- +======================================================================+

Line 1458: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );

1454: FROM jg_zz_vat_trx_gt
1455: WHERE jg_info_v30='JOURNAL_AP';
1456:
1457: IF p_debug_flag = 'Y' THEN
1458: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1459: END IF ;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

Line 1462: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1458: fnd_file.put_line(fnd_file.log,'Number of records inserted into jg_zz_vat_trx_gt table: ' || l_rec_count );
1459: END IF ;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1463: END journal_ap;
1464:
1465: FUNCTION lcu_trans_line_tax_amt (P_TRX_ID IN NUMBER) RETURN NUMBER IS
1466: ln_tax_amt_funcl_curr NUMBER;

Line 1480: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1476: RETURN ln_tax_amt_funcl_curr;
1477:
1478: EXCEPTION
1479: WHEN OTHERS THEN
1480: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1481: RETURN 0;
1482: END lcu_trans_line_tax_amt;
1483:
1484:

Line 1500: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1496: RETURN ln_taxable_amt_funcl_curr;
1497:
1498: EXCEPTION
1499: WHEN OTHERS THEN
1500: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1501: RETURN 0;
1502: END lcu_trans_line_taxable_amt;
1503:
1504: FUNCTION lcu_trans_line_tax_taxable_amt (p_trx_id IN NUMBER) RETURN NUMBER IS

Line 1520: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);

1516: RETURN ln_taxable_amt_funcl_curr;
1517:
1518: EXCEPTION
1519: WHEN OTHERS THEN
1520: fnd_file.put_line(fnd_file.log,'EXCEPTION' || SQLERRM || SQLCODE);
1521: RETURN 0;
1522: END lcu_trans_line_tax_taxable_amt;
1523:
1524:

Line 1528: fnd_file.put_line(fnd_file.log,'Calling Current Date Conversions');

1524:
1525: FUNCTION get_current_date RETURN VARCHAR2
1526: IS
1527: BEGIN
1528: fnd_file.put_line(fnd_file.log,'Calling Current Date Conversions');
1529: RETURN fnd_date.date_to_charDT(sysdate);
1530: END get_current_date;
1531:
1532: