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

Line 122: fnd_file.put_line( fnd_file.log,'Application short name : ' || argument1 );

118: BEGIN
119:
120: -- Log All the Parameters received by the program.
121:
122: fnd_file.put_line( fnd_file.log,'Application short name : ' || argument1 );
123: fnd_file.put_line( fnd_file.log,'Set of Books ID : ' || argument2 );
124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );
125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );

Line 123: fnd_file.put_line( fnd_file.log,'Set of Books ID : ' || argument2 );

119:
120: -- Log All the Parameters received by the program.
121:
122: fnd_file.put_line( fnd_file.log,'Application short name : ' || argument1 );
123: fnd_file.put_line( fnd_file.log,'Set of Books ID : ' || argument2 );
124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );
125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );

Line 124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );

120: -- Log All the Parameters received by the program.
121:
122: fnd_file.put_line( fnd_file.log,'Application short name : ' || argument1 );
123: fnd_file.put_line( fnd_file.log,'Set of Books ID : ' || argument2 );
124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );
125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );

Line 125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );

121:
122: fnd_file.put_line( fnd_file.log,'Application short name : ' || argument1 );
123: fnd_file.put_line( fnd_file.log,'Set of Books ID : ' || argument2 );
124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );
125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );

Line 126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );

122: fnd_file.put_line( fnd_file.log,'Application short name : ' || argument1 );
123: fnd_file.put_line( fnd_file.log,'Set of Books ID : ' || argument2 );
124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );
125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );

Line 127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );

123: fnd_file.put_line( fnd_file.log,'Set of Books ID : ' || argument2 );
124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );
125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );

Line 128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );

124: fnd_file.put_line( fnd_file.log,'GL Period From : ' || argument3 );
125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );

Line 129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );

125: fnd_file.put_line( fnd_file.log,'GL Period To : ' || argument4 );
126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );
133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );

Line 130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );

126: fnd_file.put_line( fnd_file.log,'Range Type : ' || argument5 );
127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );
133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );
134: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || argument13);

Line 131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );

127: fnd_file.put_line( fnd_file.log,'Cust/Sup Name From : ' || argument6 );
128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );
133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );
134: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || argument13);
135: fnd_file.put_line( fnd_file.log,'Rule id : ' || argument14 );

Line 132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );

128: fnd_file.put_line( fnd_file.log,'Cust/Sup Name To : ' || argument7 );
129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );
133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );
134: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || argument13);
135: fnd_file.put_line( fnd_file.log,'Rule id : ' || argument14 );
136: -- Assign parameters doing any necessary mappings

Line 133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );

129: fnd_file.put_line( fnd_file.log,'Cust/Sup Number From : ' || argument8 );
130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );
133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );
134: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || argument13);
135: fnd_file.put_line( fnd_file.log,'Rule id : ' || argument14 );
136: -- Assign parameters doing any necessary mappings
137: -- e.g. date/number conversion

Line 134: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || argument13);

130: fnd_file.put_line( fnd_file.log,'Cust/Sup Number To : ' || argument9 );
131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );
133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );
134: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || argument13);
135: fnd_file.put_line( fnd_file.log,'Rule id : ' || argument14 );
136: -- Assign parameters doing any necessary mappings
137: -- e.g. date/number conversion
138:

Line 135: fnd_file.put_line( fnd_file.log,'Rule id : ' || argument14 );

131: fnd_file.put_line( fnd_file.log,'Currency Code : ' || argument10 );
132: fnd_file.put_line( fnd_file.log,'Amount Lower Limit : ' || argument11 );
133: fnd_file.put_line( fnd_file.log,'Amount Sign : ' || argument12 );
134: fnd_file.put_line( fnd_file.log,'Legal Entity id : ' || argument13);
135: fnd_file.put_line( fnd_file.log,'Rule id : ' || argument14 );
136: -- Assign parameters doing any necessary mappings
137: -- e.g. date/number conversion
138:
139: l_conc_request_id := fnd_global.conc_request_id;

Line 153: fnd_file.put_line(FND_FILE.log,'Parent Request ID :'||to_char(l_conc_request_id));

149: WHERE request_id = l_stage_request_id;
150:
151: l_conc_request_id := l_set_request_id;
152:
153: fnd_file.put_line(FND_FILE.log,'Parent Request ID :'||to_char(l_conc_request_id));
154:
155: -- Get GL Period start date and end date.
156:
157: select to_char(gps.start_date,'DD/MM/YYYY')||' 00:00:00',

Line 190: fnd_file.put_line( fnd_file.log,'Period Start date : '|| l_period_start_date);

186: -- Validate Year. Year should be same for start year and end year.
187:
188: IF ( substr(l_period_start_date,7,4) <> substr(l_period_end_date,7,4)) then
189:
190: fnd_file.put_line( fnd_file.log,'Period Start date : '|| l_period_start_date);
191: fnd_file.put_line( fnd_file.log,'Period End date : '|| l_period_end_date);
192: fnd_file.put_line( fnd_file.log,'From Period and To Period should be in the same year');
193: retcode := 2;
194: RETURN;

Line 191: fnd_file.put_line( fnd_file.log,'Period End date : '|| l_period_end_date);

187:
188: IF ( substr(l_period_start_date,7,4) <> substr(l_period_end_date,7,4)) then
189:
190: fnd_file.put_line( fnd_file.log,'Period Start date : '|| l_period_start_date);
191: fnd_file.put_line( fnd_file.log,'Period End date : '|| l_period_end_date);
192: fnd_file.put_line( fnd_file.log,'From Period and To Period should be in the same year');
193: retcode := 2;
194: RETURN;
195:

Line 192: fnd_file.put_line( fnd_file.log,'From Period and To Period should be in the same year');

188: IF ( substr(l_period_start_date,7,4) <> substr(l_period_end_date,7,4)) then
189:
190: fnd_file.put_line( fnd_file.log,'Period Start date : '|| l_period_start_date);
191: fnd_file.put_line( fnd_file.log,'Period End date : '|| l_period_end_date);
192: fnd_file.put_line( fnd_file.log,'From Period and To Period should be in the same year');
193: retcode := 2;
194: RETURN;
195:
196: END IF;

Line 267: fnd_file.put_line( fnd_file.log,'An application level exception occured in JERX_C_TO package.');

263:
264: EXCEPTION
265: WHEN app_exceptions.application_exception THEN
266: retcode := 2;
267: fnd_file.put_line( fnd_file.log,'An application level exception occured in JERX_C_TO package.');
268: WHEN OTHERS THEN
269: retcode := 2;
270: fnd_file.put_line( fnd_file.log,'Trapped other exception occured in JERX_C_TO package.');
271: fnd_file.put_line( fnd_file.log, SQLERRM );

Line 270: fnd_file.put_line( fnd_file.log,'Trapped other exception occured in JERX_C_TO package.');

266: retcode := 2;
267: fnd_file.put_line( fnd_file.log,'An application level exception occured in JERX_C_TO package.');
268: WHEN OTHERS THEN
269: retcode := 2;
270: fnd_file.put_line( fnd_file.log,'Trapped other exception occured in JERX_C_TO package.');
271: fnd_file.put_line( fnd_file.log, SQLERRM );
272:
273: END GET_TRNOVR_DATA;
274:

Line 271: fnd_file.put_line( fnd_file.log, SQLERRM );

267: fnd_file.put_line( fnd_file.log,'An application level exception occured in JERX_C_TO package.');
268: WHEN OTHERS THEN
269: retcode := 2;
270: fnd_file.put_line( fnd_file.log,'Trapped other exception occured in JERX_C_TO package.');
271: fnd_file.put_line( fnd_file.log, SQLERRM );
272:
273: END GET_TRNOVR_DATA;
274:
275: END JERX_C_TO;