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.

[Home] [Help]

APPS.CS_SR_COST_CP dependencies on FND_LOG

Line 114: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

110: x_return_status := FND_API.G_RET_STS_SUCCESS;
111:
112: --logging the input parameters
113:
114: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
115: THEN
116: FND_LOG.String
117: (
118: FND_LOG.level_procedure

Line 116: FND_LOG.String

112: --logging the input parameters
113:
114: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
115: THEN
116: FND_LOG.String
117: (
118: FND_LOG.level_procedure
119: , L_LOG_MODULE || 'start_time'
120: , 'The start time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')

Line 118: FND_LOG.level_procedure

114: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
115: THEN
116: FND_LOG.String
117: (
118: FND_LOG.level_procedure
119: , L_LOG_MODULE || 'start_time'
120: , 'The start time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
121: );
122: FND_LOG.String

Line 122: FND_LOG.String

118: FND_LOG.level_procedure
119: , L_LOG_MODULE || 'start_time'
120: , 'The start time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
121: );
122: FND_LOG.String
123: (
124: FND_LOG.level_procedure
125: , L_LOG_MODULE || 'start'
126: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'

Line 124: FND_LOG.level_procedure

120: , 'The start time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
121: );
122: FND_LOG.String
123: (
124: FND_LOG.level_procedure
125: , L_LOG_MODULE || 'start'
126: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
127: );
128: FND_LOG.String

Line 128: FND_LOG.String

124: FND_LOG.level_procedure
125: , L_LOG_MODULE || 'start'
126: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
127: );
128: FND_LOG.String
129: (
130: FND_LOG.level_procedure
131: , L_LOG_MODULE || 'param 1'
132: , 'errbuf:' || errbuf

Line 130: FND_LOG.level_procedure

126: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
127: );
128: FND_LOG.String
129: (
130: FND_LOG.level_procedure
131: , L_LOG_MODULE || 'param 1'
132: , 'errbuf:' || errbuf
133: );
134: FND_LOG.String

Line 134: FND_LOG.String

130: FND_LOG.level_procedure
131: , L_LOG_MODULE || 'param 1'
132: , 'errbuf:' || errbuf
133: );
134: FND_LOG.String
135: (
136: FND_LOG.level_procedure
137: , L_LOG_MODULE || 'param 2'
138: , 'errcode:' || errcode

Line 136: FND_LOG.level_procedure

132: , 'errbuf:' || errbuf
133: );
134: FND_LOG.String
135: (
136: FND_LOG.level_procedure
137: , L_LOG_MODULE || 'param 2'
138: , 'errcode:' || errcode
139: );
140: FND_LOG.String

Line 140: FND_LOG.String

136: FND_LOG.level_procedure
137: , L_LOG_MODULE || 'param 2'
138: , 'errcode:' || errcode
139: );
140: FND_LOG.String
141: (
142: FND_LOG.level_procedure
143: , L_LOG_MODULE || 'param 3'
144: , 'p_api_version_number:' || p_api_version_number

Line 142: FND_LOG.level_procedure

138: , 'errcode:' || errcode
139: );
140: FND_LOG.String
141: (
142: FND_LOG.level_procedure
143: , L_LOG_MODULE || 'param 3'
144: , 'p_api_version_number:' || p_api_version_number
145: );
146: FND_LOG.String

Line 146: FND_LOG.String

142: FND_LOG.level_procedure
143: , L_LOG_MODULE || 'param 3'
144: , 'p_api_version_number:' || p_api_version_number
145: );
146: FND_LOG.String
147: (
148: FND_LOG.level_procedure
149: , L_LOG_MODULE || 'param 4'
150: , 'p_init_msg_list:' || p_init_msg_list

Line 148: FND_LOG.level_procedure

144: , 'p_api_version_number:' || p_api_version_number
145: );
146: FND_LOG.String
147: (
148: FND_LOG.level_procedure
149: , L_LOG_MODULE || 'param 4'
150: , 'p_init_msg_list:' || p_init_msg_list
151: );
152: FND_LOG.String

Line 152: FND_LOG.String

148: FND_LOG.level_procedure
149: , L_LOG_MODULE || 'param 4'
150: , 'p_init_msg_list:' || p_init_msg_list
151: );
152: FND_LOG.String
153: (
154: FND_LOG.level_procedure
155: , L_LOG_MODULE || 'param 5'
156: , 'p_commit:' || p_commit

Line 154: FND_LOG.level_procedure

150: , 'p_init_msg_list:' || p_init_msg_list
151: );
152: FND_LOG.String
153: (
154: FND_LOG.level_procedure
155: , L_LOG_MODULE || 'param 5'
156: , 'p_commit:' || p_commit
157: );
158: FND_LOG.String

Line 158: FND_LOG.String

154: FND_LOG.level_procedure
155: , L_LOG_MODULE || 'param 5'
156: , 'p_commit:' || p_commit
157: );
158: FND_LOG.String
159: (
160: FND_LOG.level_procedure
161: , L_LOG_MODULE || 'param 6'
162: , 'p_validation_level:' || p_validation_level

Line 160: FND_LOG.level_procedure

156: , 'p_commit:' || p_commit
157: );
158: FND_LOG.String
159: (
160: FND_LOG.level_procedure
161: , L_LOG_MODULE || 'param 6'
162: , 'p_validation_level:' || p_validation_level
163: );
164: FND_LOG.String

Line 164: FND_LOG.String

160: FND_LOG.level_procedure
161: , L_LOG_MODULE || 'param 6'
162: , 'p_validation_level:' || p_validation_level
163: );
164: FND_LOG.String
165: (
166: FND_LOG.level_procedure
167: , L_LOG_MODULE || 'param 7'
168: , 'p_creation_from_date' ||p_creation_from_date

Line 166: FND_LOG.level_procedure

162: , 'p_validation_level:' || p_validation_level
163: );
164: FND_LOG.String
165: (
166: FND_LOG.level_procedure
167: , L_LOG_MODULE || 'param 7'
168: , 'p_creation_from_date' ||p_creation_from_date
169: );
170: FND_LOG.String

Line 170: FND_LOG.String

166: FND_LOG.level_procedure
167: , L_LOG_MODULE || 'param 7'
168: , 'p_creation_from_date' ||p_creation_from_date
169: );
170: FND_LOG.String
171: (
172: FND_LOG.level_procedure
173: , L_LOG_MODULE || 'param 8'
174: , 'p_creation_to_date' ||p_creation_to_date

Line 172: FND_LOG.level_procedure

168: , 'p_creation_from_date' ||p_creation_from_date
169: );
170: FND_LOG.String
171: (
172: FND_LOG.level_procedure
173: , L_LOG_MODULE || 'param 8'
174: , 'p_creation_to_date' ||p_creation_to_date
175: );
176: FND_LOG.String

Line 176: FND_LOG.String

172: FND_LOG.level_procedure
173: , L_LOG_MODULE || 'param 8'
174: , 'p_creation_to_date' ||p_creation_to_date
175: );
176: FND_LOG.String
177: (
178: FND_LOG.level_procedure
179: , L_LOG_MODULE || 'param 9'
180: , 'p_sr_status:' || p_sr_status

Line 178: FND_LOG.level_procedure

174: , 'p_creation_to_date' ||p_creation_to_date
175: );
176: FND_LOG.String
177: (
178: FND_LOG.level_procedure
179: , L_LOG_MODULE || 'param 9'
180: , 'p_sr_status:' || p_sr_status
181: );
182: FND_LOG.String

Line 182: FND_LOG.String

178: FND_LOG.level_procedure
179: , L_LOG_MODULE || 'param 9'
180: , 'p_sr_status:' || p_sr_status
181: );
182: FND_LOG.String
183: (
184: FND_LOG.level_procedure
185: , L_LOG_MODULE || 'param 10'
186: , 'p_number_of_workers:' || p_number_of_workers

Line 184: FND_LOG.level_procedure

180: , 'p_sr_status:' || p_sr_status
181: );
182: FND_LOG.String
183: (
184: FND_LOG.level_procedure
185: , L_LOG_MODULE || 'param 10'
186: , 'p_number_of_workers:' || p_number_of_workers
187: );
188: FND_LOG.String

Line 188: FND_LOG.String

184: FND_LOG.level_procedure
185: , L_LOG_MODULE || 'param 10'
186: , 'p_number_of_workers:' || p_number_of_workers
187: );
188: FND_LOG.String
189: (
190: FND_LOG.level_procedure
191: , L_LOG_MODULE || 'param 11'
192: , 'p_cost_batch_size:' ||p_cost_batch_size

Line 190: FND_LOG.level_procedure

186: , 'p_number_of_workers:' || p_number_of_workers
187: );
188: FND_LOG.String
189: (
190: FND_LOG.level_procedure
191: , L_LOG_MODULE || 'param 11'
192: , 'p_cost_batch_size:' ||p_cost_batch_size
193: );
194: END IF;

Line 220: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

216: END IF ;
217:
218: ---
219:
220: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
221: THEN
222: FND_LOG.String
223: (
224: FND_LOG.level_statement

Line 222: FND_LOG.String

218: ---
219:
220: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
221: THEN
222: FND_LOG.String
223: (
224: FND_LOG.level_statement
225: , L_LOG_MODULE || 'get_request_info_start'
226: , 'Getting Current Concurrent Request ID '

Line 224: FND_LOG.level_statement

220: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
221: THEN
222: FND_LOG.String
223: (
224: FND_LOG.level_statement
225: , L_LOG_MODULE || 'get_request_info_start'
226: , 'Getting Current Concurrent Request ID '
227: );
228: END IF;

Line 253: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

249: -- that the request is started newly.
250:
251:
252:
253: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
254: THEN
255: FND_LOG.String
256: (
257: FND_LOG.level_statement

Line 255: FND_LOG.String

251:
252:
253: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
254: THEN
255: FND_LOG.String
256: (
257: FND_LOG.level_statement
258: , L_LOG_MODULE || 'cleanup_start'
259: , 'deleting rows in staging table that were not cleared earlier'

Line 257: FND_LOG.level_statement

253: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
254: THEN
255: FND_LOG.String
256: (
257: FND_LOG.level_statement
258: , L_LOG_MODULE || 'cleanup_start'
259: , 'deleting rows in staging table that were not cleared earlier'
260: );
261: END IF;

Line 289: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

285:
286: l_row_count := SQL%ROWCOUNT;
287:
288:
289: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
290: THEN
291: FND_LOG.String
292: (
293: FND_LOG.level_statement

Line 291: FND_LOG.String

287:
288:
289: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
290: THEN
291: FND_LOG.String
292: (
293: FND_LOG.level_statement
294: , L_LOG_MODULE || 'cleanup_end'
295: , 'after deleting rows in staging table that were not cleared earlier '

Line 293: FND_LOG.level_statement

289: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
290: THEN
291: FND_LOG.String
292: (
293: FND_LOG.level_statement
294: , L_LOG_MODULE || 'cleanup_end'
295: , 'after deleting rows in staging table that were not cleared earlier '
296: || l_row_count || ' rows'
297: );

Line 307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

303:
304:
305:
306:
307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
308: THEN
309: FND_LOG.String
310: (
311: FND_LOG.level_statement

Line 309: FND_LOG.String

305:
306:
307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
308: THEN
309: FND_LOG.String
310: (
311: FND_LOG.level_statement
312: , L_LOG_MODULE || 'call_validate_param_start'
313: , 'Calling procedure to validate cost parameters'

Line 311: FND_LOG.level_statement

307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
308: THEN
309: FND_LOG.String
310: (
311: FND_LOG.level_statement
312: , L_LOG_MODULE || 'call_validate_param_start'
313: , 'Calling procedure to validate cost parameters'
314: );
315: END IF;

Line 336: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

332: );
333:
334:
335:
336: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
337: THEN
338: FND_LOG.String
339: (
340: FND_LOG.level_statement

Line 338: FND_LOG.String

334:
335:
336: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
337: THEN
338: FND_LOG.String
339: (
340: FND_LOG.level_statement
341: , L_LOG_MODULE || 'call_validate_param_end'
342: , 'After calling procedure to validate cost parameters'

Line 340: FND_LOG.level_statement

336: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
337: THEN
338: FND_LOG.String
339: (
340: FND_LOG.level_statement
341: , L_LOG_MODULE || 'call_validate_param_end'
342: , 'After calling procedure to validate cost parameters'
343: );
344: END IF;

Line 353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

349: ----------------------------------------------------------------------------
350: -- Preparation of Staging Table Data and Submission of Child Requests
351: ----------------------------------------------------------------------------
352:
353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
354: THEN
355: FND_LOG.String
356: (
357: FND_LOG.level_statement

Line 355: FND_LOG.String

351: ----------------------------------------------------------------------------
352:
353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
354: THEN
355: FND_LOG.String
356: (
357: FND_LOG.level_statement
358: , L_LOG_MODULE || 'call_form_and_exec_statement_start'
359: , 'Calling procedure to form and execute statement to fill staging table'

Line 357: FND_LOG.level_statement

353: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
354: THEN
355: FND_LOG.String
356: (
357: FND_LOG.level_statement
358: , L_LOG_MODULE || 'call_form_and_exec_statement_start'
359: , 'Calling procedure to form and execute statement to fill staging table'
360: );
361: END IF;

Line 376: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

372: , p_request_id => l_request_id
373: , p_row_count => l_row_count
374: );
375:
376: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
377: THEN
378: FND_LOG.String
379: (
380: FND_LOG.level_statement

Line 378: FND_LOG.String

374: );
375:
376: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
377: THEN
378: FND_LOG.String
379: (
380: FND_LOG.level_statement
381: , L_LOG_MODULE || 'call_form_and_exec_statement_end'
382: , 'After calling procedure to form and execute statement to '

Line 380: FND_LOG.level_statement

376: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
377: THEN
378: FND_LOG.String
379: (
380: FND_LOG.level_statement
381: , L_LOG_MODULE || 'call_form_and_exec_statement_end'
382: , 'After calling procedure to form and execute statement to '
383: || 'fill staging table ' || l_row_count
384: );

Line 394: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

390: THEN
391: -- If there were no SRs selected, return
392: -- from the concurrent program with a warning
393:
394: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
395: THEN
396: FND_LOG.String
397: (
398: FND_LOG.level_unexpected

Line 396: FND_LOG.String

392: -- from the concurrent program with a warning
393:
394: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
395: THEN
396: FND_LOG.String
397: (
398: FND_LOG.level_unexpected
399: , L_LOG_MODULE || 'no_rows'
400: , 'There were no rows picked up. Row count was ' || l_row_count

Line 398: FND_LOG.level_unexpected

394: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
395: THEN
396: FND_LOG.String
397: (
398: FND_LOG.level_unexpected
399: , L_LOG_MODULE || 'no_rows'
400: , 'There were no rows picked up. Row count was ' || l_row_count
401: );
402: END IF ;

Line 440: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

436: -- If the worker request was not created successfully
437: -- raise an unexpected exception and terminate the
438: -- process.
439:
440: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
441: THEN
442: FND_LOG.String
443: (
444: FND_LOG.level_unexpected

Line 442: FND_LOG.String

438: -- process.
439:
440: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
441: THEN
442: FND_LOG.String
443: (
444: FND_LOG.level_unexpected
445: , L_LOG_MODULE || 'create_workers_error'
446: , 'Failed while starting worker concurrent request'

Line 444: FND_LOG.level_unexpected

440: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
441: THEN
442: FND_LOG.String
443: (
444: FND_LOG.level_unexpected
445: , L_LOG_MODULE || 'create_workers_error'
446: , 'Failed while starting worker concurrent request'
447: );
448: END IF;

Line 456: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

452:
453: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
457: THEN
458: FND_LOG.String
459: (
460: FND_LOG.level_statement

Line 458: FND_LOG.String

454: END IF;
455:
456: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
457: THEN
458: FND_LOG.String
459: (
460: FND_LOG.level_statement
461: , L_LOG_MODULE || 'create_workers_doing'
462: , 'After starting worker ' || l_worker_conc_req_arr(j)

Line 460: FND_LOG.level_statement

456: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
457: THEN
458: FND_LOG.String
459: (
460: FND_LOG.level_statement
461: , L_LOG_MODULE || 'create_workers_doing'
462: , 'After starting worker ' || l_worker_conc_req_arr(j)
463: );
464: END IF;

Line 474: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

470: COMMIT;
471:
472:
473:
474: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
475: THEN
476: FND_LOG.String
477: (
478: FND_LOG.level_statement

Line 476: FND_LOG.String

472:
473:
474: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
475: THEN
476: FND_LOG.String
477: (
478: FND_LOG.level_statement
479: , L_LOG_MODULE || 'create_workers_end'
480: , 'After starting all worker concurrent requests'

Line 478: FND_LOG.level_statement

474: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
475: THEN
476: FND_LOG.String
477: (
478: FND_LOG.level_statement
479: , L_LOG_MODULE || 'create_workers_end'
480: , 'After starting all worker concurrent requests'
481: );
482: END IF;

Line 486: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

482: END IF;
483:
484: ---
485:
486: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
487: THEN
488: FND_LOG.String
489: (
490: FND_LOG.level_statement

Line 488: FND_LOG.String

484: ---
485:
486: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
487: THEN
488: FND_LOG.String
489: (
490: FND_LOG.level_statement
491: , L_LOG_MODULE || 'move_parent_to_paused_start'
492: , 'Moving parent concurrent request to paused status'

Line 490: FND_LOG.level_statement

486: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
487: THEN
488: FND_LOG.String
489: (
490: FND_LOG.level_statement
491: , L_LOG_MODULE || 'move_parent_to_paused_start'
492: , 'Moving parent concurrent request to paused status'
493: );
494: END IF;

Line 498: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

494: END IF;
495:
496: COMMIT;
497:
498: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
499: THEN
500: FND_LOG.String
501: (
502: FND_LOG.level_statement

Line 500: FND_LOG.String

496: COMMIT;
497:
498: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
499: THEN
500: FND_LOG.String
501: (
502: FND_LOG.level_statement
503: , L_LOG_MODULE || 'move_parent_to_paused_end'
504: , 'After moving parent concurrent request to paused status'

Line 502: FND_LOG.level_statement

498: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
499: THEN
500: FND_LOG.String
501: (
502: FND_LOG.level_statement
503: , L_LOG_MODULE || 'move_parent_to_paused_end'
504: , 'After moving parent concurrent request to paused status'
505: );
506: END IF;

Line 538: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

534: -- completion status
535:
536: FOR r_child_request IN c_child_request(l_request_id)
537: LOOP
538: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
539: THEN
540: FND_LOG.String
541: (
542: FND_LOG.level_statement

Line 540: FND_LOG.String

536: FOR r_child_request IN c_child_request(l_request_id)
537: LOOP
538: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
539: THEN
540: FND_LOG.String
541: (
542: FND_LOG.level_statement
543: , L_LOG_MODULE || 'collect_a_child_status'
544: , 'Worker Concurrent Request No : ' || r_child_request.request_id

Line 542: FND_LOG.level_statement

538: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
539: THEN
540: FND_LOG.String
541: (
542: FND_LOG.level_statement
543: , L_LOG_MODULE || 'collect_a_child_status'
544: , 'Worker Concurrent Request No : ' || r_child_request.request_id
545: );
546: END IF;

Line 558: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

554: , dev_status => l_worker_conc_req_dev_status
555: , message => l_worker_conc_req_message
556: )
557: THEN
558: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
559: THEN
560: FND_LOG.String
561: (
562: FND_LOG.level_statement

Line 560: FND_LOG.String

556: )
557: THEN
558: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
559: THEN
560: FND_LOG.String
561: (
562: FND_LOG.level_statement
563: , L_LOG_MODULE || 'child_return_status'
564: , 'l_worker_conc_req_phase:' || l_worker_conc_req_phase

Line 562: FND_LOG.level_statement

558: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
559: THEN
560: FND_LOG.String
561: (
562: FND_LOG.level_statement
563: , L_LOG_MODULE || 'child_return_status'
564: , 'l_worker_conc_req_phase:' || l_worker_conc_req_phase
565: );
566: FND_LOG.String

Line 566: FND_LOG.String

562: FND_LOG.level_statement
563: , L_LOG_MODULE || 'child_return_status'
564: , 'l_worker_conc_req_phase:' || l_worker_conc_req_phase
565: );
566: FND_LOG.String
567: (
568: FND_LOG.level_statement
569: , L_LOG_MODULE || 'child_return_status'
570: , 'l_worker_conc_req_status:' || l_worker_conc_req_status

Line 568: FND_LOG.level_statement

564: , 'l_worker_conc_req_phase:' || l_worker_conc_req_phase
565: );
566: FND_LOG.String
567: (
568: FND_LOG.level_statement
569: , L_LOG_MODULE || 'child_return_status'
570: , 'l_worker_conc_req_status:' || l_worker_conc_req_status
571: );
572: FND_LOG.String

Line 572: FND_LOG.String

568: FND_LOG.level_statement
569: , L_LOG_MODULE || 'child_return_status'
570: , 'l_worker_conc_req_status:' || l_worker_conc_req_status
571: );
572: FND_LOG.String
573: (
574: FND_LOG.level_statement
575: , L_LOG_MODULE || 'child_return_status'
576: , 'l_worker_conc_req_dev_phase:' || l_worker_conc_req_dev_phase

Line 574: FND_LOG.level_statement

570: , 'l_worker_conc_req_status:' || l_worker_conc_req_status
571: );
572: FND_LOG.String
573: (
574: FND_LOG.level_statement
575: , L_LOG_MODULE || 'child_return_status'
576: , 'l_worker_conc_req_dev_phase:' || l_worker_conc_req_dev_phase
577: );
578: FND_LOG.String

Line 578: FND_LOG.String

574: FND_LOG.level_statement
575: , L_LOG_MODULE || 'child_return_status'
576: , 'l_worker_conc_req_dev_phase:' || l_worker_conc_req_dev_phase
577: );
578: FND_LOG.String
579: (
580: FND_LOG.level_statement
581: , L_LOG_MODULE || 'child_return_status'
582: , 'l_worker_conc_req_dev_status:' || l_worker_conc_req_dev_status

Line 580: FND_LOG.level_statement

576: , 'l_worker_conc_req_dev_phase:' || l_worker_conc_req_dev_phase
577: );
578: FND_LOG.String
579: (
580: FND_LOG.level_statement
581: , L_LOG_MODULE || 'child_return_status'
582: , 'l_worker_conc_req_dev_status:' || l_worker_conc_req_dev_status
583: );
584: FND_LOG.String

Line 584: FND_LOG.String

580: FND_LOG.level_statement
581: , L_LOG_MODULE || 'child_return_status'
582: , 'l_worker_conc_req_dev_status:' || l_worker_conc_req_dev_status
583: );
584: FND_LOG.String
585: (
586: FND_LOG.level_statement
587: , L_LOG_MODULE || 'child_return_status'
588: , 'l_worker_conc_req_message:' || l_worker_conc_req_message

Line 586: FND_LOG.level_statement

582: , 'l_worker_conc_req_dev_status:' || l_worker_conc_req_dev_status
583: );
584: FND_LOG.String
585: (
586: FND_LOG.level_statement
587: , L_LOG_MODULE || 'child_return_status'
588: , 'l_worker_conc_req_message:' || l_worker_conc_req_message
589: );
590: END IF;

Line 592: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

588: , 'l_worker_conc_req_message:' || l_worker_conc_req_message
589: );
590: END IF;
591:
592: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
593: THEN
594: FND_LOG.String
595: (
596: FND_LOG.level_statement

Line 594: FND_LOG.String

590: END IF;
591:
592: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
593: THEN
594: FND_LOG.String
595: (
596: FND_LOG.level_statement
597: , L_LOG_MODULE || 'resolve_main_dev_status_start'
598: , 'Resolving l_main_conc_req_dev_status'

Line 596: FND_LOG.level_statement

592: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
593: THEN
594: FND_LOG.String
595: (
596: FND_LOG.level_statement
597: , L_LOG_MODULE || 'resolve_main_dev_status_start'
598: , 'Resolving l_main_conc_req_dev_status'
599: );
600: END IF;

Line 621: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

617: l_child_message := l_worker_conc_req_message;
618: END IF;
619: END IF;
620:
621: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
622: THEN
623: FND_LOG.String
624: (
625: FND_LOG.level_statement

Line 623: FND_LOG.String

619: END IF;
620:
621: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
622: THEN
623: FND_LOG.String
624: (
625: FND_LOG.level_statement
626: , L_LOG_MODULE || 'resolve_main_dev_status_end'
627: , 'After resolving l_main_conc_req_dev_status:'

Line 625: FND_LOG.level_statement

621: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
622: THEN
623: FND_LOG.String
624: (
625: FND_LOG.level_statement
626: , L_LOG_MODULE || 'resolve_main_dev_status_end'
627: , 'After resolving l_main_conc_req_dev_status:'
628: || l_main_conc_req_dev_status
629: );

Line 630: FND_LOG.String

626: , L_LOG_MODULE || 'resolve_main_dev_status_end'
627: , 'After resolving l_main_conc_req_dev_status:'
628: || l_main_conc_req_dev_status
629: );
630: FND_LOG.String
631: (
632: FND_LOG.level_statement
633: , L_LOG_MODULE || 'resolve_main_dev_status_end'
634: , 'After resolving l_main_conc_req_dev_status - child_message :'

Line 632: FND_LOG.level_statement

628: || l_main_conc_req_dev_status
629: );
630: FND_LOG.String
631: (
632: FND_LOG.level_statement
633: , L_LOG_MODULE || 'resolve_main_dev_status_end'
634: , 'After resolving l_main_conc_req_dev_status - child_message :'
635: || l_child_message
636: );

Line 644: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

640:
641: -- There was a failure while collecting a child request
642: -- status, raising an unexpected exception
643:
644: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
645: THEN
646: FND_LOG.String
647: (
648: FND_LOG.level_unexpected

Line 646: FND_LOG.String

642: -- status, raising an unexpected exception
643:
644: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
645: THEN
646: FND_LOG.String
647: (
648: FND_LOG.level_unexpected
649: , L_LOG_MODULE || 'collect_child_status_failed'
650: , 'Call to function fnd_concurrent.get_request_status failed. '

Line 648: FND_LOG.level_unexpected

644: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
645: THEN
646: FND_LOG.String
647: (
648: FND_LOG.level_unexpected
649: , L_LOG_MODULE || 'collect_child_status_failed'
650: , 'Call to function fnd_concurrent.get_request_status failed. '
651: || l_main_conc_req_message
652: );

Line 665: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

661:
662: END LOOP;
663:
664:
665: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
666: THEN
667: FND_LOG.String
668: (
669: FND_LOG.level_statement

Line 667: FND_LOG.String

663:
664:
665: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
666: THEN
667: FND_LOG.String
668: (
669: FND_LOG.level_statement
670: , L_LOG_MODULE || 'collect_child_status_end'
671: , 'After collecting child completion status'

Line 669: FND_LOG.level_statement

665: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
666: THEN
667: FND_LOG.String
668: (
669: FND_LOG.level_statement
670: , L_LOG_MODULE || 'collect_child_status_end'
671: , 'After collecting child completion status'
672: );
673: END IF;

Line 679: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

675:
676:
677:
678:
679: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
680: THEN
681: FND_LOG.String
682: (
683: FND_LOG.level_statement

Line 681: FND_LOG.String

677:
678:
679: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
680: THEN
681: FND_LOG.String
682: (
683: FND_LOG.level_statement
684: , L_LOG_MODULE || 'Write_cost_Output_start'
685: , 'Calling procedure to Write_cost_Output'

Line 683: FND_LOG.level_statement

679: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
680: THEN
681: FND_LOG.String
682: (
683: FND_LOG.level_statement
684: , L_LOG_MODULE || 'Write_cost_Output_start'
685: , 'Calling procedure to Write_cost_Output'
686: );
687: END IF;

Line 707: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

703: concurrent_request_id = l_request_id;
704:
705: l_row_count := SQL%ROWCOUNT;*/
706:
707: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
708: THEN
709: FND_LOG.String
710: (
711: FND_LOG.level_statement

Line 709: FND_LOG.String

705: l_row_count := SQL%ROWCOUNT;*/
706:
707: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
708: THEN
709: FND_LOG.String
710: (
711: FND_LOG.level_statement
712: , L_LOG_MODULE || 'staging_table_cleanup_end'
713: , 'After cleaning up staging table ' || l_row_count

Line 711: FND_LOG.level_statement

707: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
708: THEN
709: FND_LOG.String
710: (
711: FND_LOG.level_statement
712: , L_LOG_MODULE || 'staging_table_cleanup_end'
713: , 'After cleaning up staging table ' || l_row_count
714: );
715: END IF;

Line 719: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

715: END IF;
716:
717: ---
718:
719: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
720: THEN
721: FND_LOG.String
722: (
723: FND_LOG.level_statement

Line 721: FND_LOG.String

717: ---
718:
719: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
720: THEN
721: FND_LOG.String
722: (
723: FND_LOG.level_statement
724: , L_LOG_MODULE || 'act_on_ret_status_start'
725: , 'Acting on the main concurrent request return status:'

Line 723: FND_LOG.level_statement

719: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
720: THEN
721: FND_LOG.String
722: (
723: FND_LOG.level_statement
724: , L_LOG_MODULE || 'act_on_ret_status_start'
725: , 'Acting on the main concurrent request return status:'
726: || l_main_conc_req_dev_status
727: );

Line 762: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

758: RAISE FND_API.G_EXC_ERROR;
759: END IF;
760:
761:
762: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
763: THEN
764: FND_LOG.String
765: (
766: FND_LOG.level_statement

Line 764: FND_LOG.String

760:
761:
762: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
763: THEN
764: FND_LOG.String
765: (
766: FND_LOG.level_statement
767: , L_LOG_MODULE || 'act_on_ret_status_end'
768: , 'after Acting on the main concurrent request return status:'

Line 766: FND_LOG.level_statement

762: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
763: THEN
764: FND_LOG.String
765: (
766: FND_LOG.level_statement
767: , L_LOG_MODULE || 'act_on_ret_status_end'
768: , 'after Acting on the main concurrent request return status:'
769: || l_main_conc_req_dev_status
770: );

Line 775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

771: END IF;
772:
773: ---
774:
775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
776: THEN
777: FND_LOG.String
778: (
779: FND_LOG.level_statement

Line 777: FND_LOG.String

773: ---
774:
775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
776: THEN
777: FND_LOG.String
778: (
779: FND_LOG.level_statement
780: , L_LOG_MODULE || 'set_comp_stat_normal_start'
781: , 'Setting completion status for parent concurrent request as NORMAL'

Line 779: FND_LOG.level_statement

775: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
776: THEN
777: FND_LOG.String
778: (
779: FND_LOG.level_statement
780: , L_LOG_MODULE || 'set_comp_stat_normal_start'
781: , 'Setting completion status for parent concurrent request as NORMAL'
782: );
783: END IF;

Line 795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

791: 'NORMAL'
792: , ' '
793: );
794:
795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: (
799: FND_LOG.level_statement

Line 797: FND_LOG.String

793: );
794:
795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: (
799: FND_LOG.level_statement
800: , L_LOG_MODULE || 'set_comp_stat_normal_end'
801: , 'After setting completion status for parent concurrent '

Line 799: FND_LOG.level_statement

795: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
796: THEN
797: FND_LOG.String
798: (
799: FND_LOG.level_statement
800: , L_LOG_MODULE || 'set_comp_stat_normal_end'
801: , 'After setting completion status for parent concurrent '
802: || 'request as NORMAL'
803: );

Line 811: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

807:
808: end if;
809:
810:
811: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
812: THEN
813: IF FND_CONCURRENT.Get_Request_Status
814: (
815: request_id => l_request_id

Line 823: FND_LOG.String

819: , dev_status => l_main_conc_req_dev_status
820: , message => l_main_conc_req_message
821: )
822: THEN
823: FND_LOG.String
824: (
825: FND_LOG.level_procedure
826: , L_LOG_MODULE || 'request_status_1'
827: , 'l_main_conc_req_phase:' || l_main_conc_req_phase

Line 825: FND_LOG.level_procedure

821: )
822: THEN
823: FND_LOG.String
824: (
825: FND_LOG.level_procedure
826: , L_LOG_MODULE || 'request_status_1'
827: , 'l_main_conc_req_phase:' || l_main_conc_req_phase
828: );
829: FND_LOG.String

Line 829: FND_LOG.String

825: FND_LOG.level_procedure
826: , L_LOG_MODULE || 'request_status_1'
827: , 'l_main_conc_req_phase:' || l_main_conc_req_phase
828: );
829: FND_LOG.String
830: (
831: FND_LOG.level_procedure
832: , L_LOG_MODULE || 'request_status_2'
833: , 'l_main_conc_req_status:' || l_main_conc_req_status

Line 831: FND_LOG.level_procedure

827: , 'l_main_conc_req_phase:' || l_main_conc_req_phase
828: );
829: FND_LOG.String
830: (
831: FND_LOG.level_procedure
832: , L_LOG_MODULE || 'request_status_2'
833: , 'l_main_conc_req_status:' || l_main_conc_req_status
834: );
835: FND_LOG.String

Line 835: FND_LOG.String

831: FND_LOG.level_procedure
832: , L_LOG_MODULE || 'request_status_2'
833: , 'l_main_conc_req_status:' || l_main_conc_req_status
834: );
835: FND_LOG.String
836: (
837: FND_LOG.level_procedure
838: , L_LOG_MODULE || 'request_status_3'
839: , 'l_main_conc_req_dev_phase:' || l_main_conc_req_dev_phase

Line 837: FND_LOG.level_procedure

833: , 'l_main_conc_req_status:' || l_main_conc_req_status
834: );
835: FND_LOG.String
836: (
837: FND_LOG.level_procedure
838: , L_LOG_MODULE || 'request_status_3'
839: , 'l_main_conc_req_dev_phase:' || l_main_conc_req_dev_phase
840: );
841: FND_LOG.String

Line 841: FND_LOG.String

837: FND_LOG.level_procedure
838: , L_LOG_MODULE || 'request_status_3'
839: , 'l_main_conc_req_dev_phase:' || l_main_conc_req_dev_phase
840: );
841: FND_LOG.String
842: (
843: FND_LOG.level_procedure
844: , L_LOG_MODULE || 'request_status_4'
845: , 'l_main_conc_req_dev_status:' || l_main_conc_req_dev_status

Line 843: FND_LOG.level_procedure

839: , 'l_main_conc_req_dev_phase:' || l_main_conc_req_dev_phase
840: );
841: FND_LOG.String
842: (
843: FND_LOG.level_procedure
844: , L_LOG_MODULE || 'request_status_4'
845: , 'l_main_conc_req_dev_status:' || l_main_conc_req_dev_status
846: );
847: FND_LOG.String

Line 847: FND_LOG.String

843: FND_LOG.level_procedure
844: , L_LOG_MODULE || 'request_status_4'
845: , 'l_main_conc_req_dev_status:' || l_main_conc_req_dev_status
846: );
847: FND_LOG.String
848: (
849: FND_LOG.level_procedure
850: , L_LOG_MODULE || 'request_status_5'
851: , 'l_main_conc_req_message:' || l_main_conc_req_message

Line 849: FND_LOG.level_procedure

845: , 'l_main_conc_req_dev_status:' || l_main_conc_req_dev_status
846: );
847: FND_LOG.String
848: (
849: FND_LOG.level_procedure
850: , L_LOG_MODULE || 'request_status_5'
851: , 'l_main_conc_req_message:' || l_main_conc_req_message
852: );
853: END IF;

Line 858: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

854: END IF ;
855:
856: ---
857:
858: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
859: THEN
860: FND_LOG.String
861: (
862: FND_LOG.level_procedure

Line 860: FND_LOG.String

856: ---
857:
858: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
859: THEN
860: FND_LOG.String
861: (
862: FND_LOG.level_procedure
863: , L_LOG_MODULE || 'end'
864: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '

Line 862: FND_LOG.level_procedure

858: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
859: THEN
860: FND_LOG.String
861: (
862: FND_LOG.level_procedure
863: , L_LOG_MODULE || 'end'
864: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
865: || x_return_status
866: );

Line 867: FND_LOG.String

863: , L_LOG_MODULE || 'end'
864: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
865: || x_return_status
866: );
867: FND_LOG.String
868: (
869: FND_LOG.level_procedure
870: , L_LOG_MODULE || 'end_time'
871: , 'The end time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')

Line 869: FND_LOG.level_procedure

865: || x_return_status
866: );
867: FND_LOG.String
868: (
869: FND_LOG.level_procedure
870: , L_LOG_MODULE || 'end_time'
871: , 'The end time is ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
872: );
873: END IF ;

Line 908: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

904: --Added for bug 7168775
905: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
906:
907:
908: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
909: THEN
910: FND_LOG.String
911: (
912: FND_LOG.level_unexpected

Line 910: FND_LOG.String

906:
907:
908: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
909: THEN
910: FND_LOG.String
911: (
912: FND_LOG.level_unexpected
913: , L_LOG_MODULE || 'error'
914: , 'Inside WHEN L_EXC_COST_WARNING of ' || L_API_NAME_FULL

Line 912: FND_LOG.level_unexpected

908: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
909: THEN
910: FND_LOG.String
911: (
912: FND_LOG.level_unexpected
913: , L_LOG_MODULE || 'error'
914: , 'Inside WHEN L_EXC_COST_WARNING of ' || L_API_NAME_FULL
915: );
916:

Line 931: FND_LOG.String

927: , p_encoded => 'F'
928: , p_data => x_msg_data
929: , p_msg_index_out => x_msg_index_out
930: );
931: FND_LOG.String
932: (
933: FND_LOG.level_unexpected
934: , L_LOG_MODULE || 'error'
935: , 'Error encountered is : ' || x_msg_data || ' [Index:'

Line 933: FND_LOG.level_unexpected

929: , p_msg_index_out => x_msg_index_out
930: );
931: FND_LOG.String
932: (
933: FND_LOG.level_unexpected
934: , L_LOG_MODULE || 'error'
935: , 'Error encountered is : ' || x_msg_data || ' [Index:'
936: || x_msg_index_out || ']'
937: );

Line 970: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

966:
967: --Added for bug 7168775
968: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
969:
970: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
971: THEN
972: FND_LOG.String
973: (
974: FND_LOG.level_unexpected

Line 972: FND_LOG.String

968: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
969:
970: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
971: THEN
972: FND_LOG.String
973: (
974: FND_LOG.level_unexpected
975: , L_LOG_MODULE || 'error'
976: , 'Inside WHEN FND_API.G_EXC_ERROR of ' || L_API_NAME_FULL

Line 974: FND_LOG.level_unexpected

970: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
971: THEN
972: FND_LOG.String
973: (
974: FND_LOG.level_unexpected
975: , L_LOG_MODULE || 'error'
976: , 'Inside WHEN FND_API.G_EXC_ERROR of ' || L_API_NAME_FULL
977: );
978:

Line 993: FND_LOG.String

989: , p_encoded => 'F'
990: , p_data => x_msg_data
991: , p_msg_index_out => x_msg_index_out
992: );
993: FND_LOG.String
994: (
995: FND_LOG.level_unexpected
996: , L_LOG_MODULE || 'error'
997: , 'Error encountered is : ' || x_msg_data || ' [Index:'

Line 995: FND_LOG.level_unexpected

991: , p_msg_index_out => x_msg_index_out
992: );
993: FND_LOG.String
994: (
995: FND_LOG.level_unexpected
996: , L_LOG_MODULE || 'error'
997: , 'Error encountered is : ' || x_msg_data || ' [Index:'
998: || x_msg_index_out || ']'
999: );

Line 1033: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1029: --Added for bug 7168775
1030: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
1031:
1032:
1033: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1034: THEN
1035: FND_LOG.String
1036: (
1037: FND_LOG.level_unexpected

Line 1035: FND_LOG.String

1031:
1032:
1033: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1034: THEN
1035: FND_LOG.String
1036: (
1037: FND_LOG.level_unexpected
1038: , L_LOG_MODULE || 'unexpected_error'
1039: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL

Line 1037: FND_LOG.level_unexpected

1033: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1034: THEN
1035: FND_LOG.String
1036: (
1037: FND_LOG.level_unexpected
1038: , L_LOG_MODULE || 'unexpected_error'
1039: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
1040: );
1041:

Line 1056: FND_LOG.String

1052: , p_encoded => 'F'
1053: , p_data => x_msg_data
1054: , p_msg_index_out => x_msg_index_out
1055: );
1056: FND_LOG.String
1057: (
1058: FND_LOG.level_unexpected
1059: , L_LOG_MODULE || 'unexpected_error'
1060: , 'Error encountered is : ' || x_msg_data || ' [Index:'

Line 1058: FND_LOG.level_unexpected

1054: , p_msg_index_out => x_msg_index_out
1055: );
1056: FND_LOG.String
1057: (
1058: FND_LOG.level_unexpected
1059: , L_LOG_MODULE || 'unexpected_error'
1060: , 'Error encountered is : ' || x_msg_data || ' [Index:'
1061: || x_msg_index_out || ']'
1062: );

Line 1101: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1097: --Added for bug 7168775
1098: fnd_file.put_line(fnd_file.log, 'Error encountered is : ' || x_msg_data || ' [Index:' || x_msg_index_out || ']');
1099:
1100:
1101: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1102: THEN
1103: FND_LOG.String
1104: (
1105: FND_LOG.level_unexpected

Line 1103: FND_LOG.String

1099:
1100:
1101: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1102: THEN
1103: FND_LOG.String
1104: (
1105: FND_LOG.level_unexpected
1106: , L_LOG_MODULE || 'when_others'
1107: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'

Line 1105: FND_LOG.level_unexpected

1101: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1102: THEN
1103: FND_LOG.String
1104: (
1105: FND_LOG.level_unexpected
1106: , L_LOG_MODULE || 'when_others'
1107: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
1108: );
1109: FND_LOG.String

Line 1109: FND_LOG.String

1105: FND_LOG.level_unexpected
1106: , L_LOG_MODULE || 'when_others'
1107: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
1108: );
1109: FND_LOG.String
1110: (
1111: FND_LOG.level_unexpected
1112: , L_LOG_MODULE || 'when_others'
1113: , SQLERRM

Line 1111: FND_LOG.level_unexpected

1107: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
1108: );
1109: FND_LOG.String
1110: (
1111: FND_LOG.level_unexpected
1112: , L_LOG_MODULE || 'when_others'
1113: , SQLERRM
1114: );
1115: END IF ;

Line 1150: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1146:
1147: BEGIN
1148:
1149:
1150: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1151: THEN
1152: FND_LOG.String
1153: (
1154: FND_LOG.level_statement

Line 1152: FND_LOG.String

1148:
1149:
1150: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1151: THEN
1152: FND_LOG.String
1153: (
1154: FND_LOG.level_statement
1155: , L_LOG_MODULE || 'check_blind_cost_start'
1156: , 'checking for blind search'

Line 1154: FND_LOG.level_statement

1150: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1151: THEN
1152: FND_LOG.String
1153: (
1154: FND_LOG.level_statement
1155: , L_LOG_MODULE || 'check_blind_cost_start'
1156: , 'checking for blind search'
1157: );
1158: END IF;

Line 1165: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1161: IF p_creation_from_date IS NULL
1162: OR p_creation_to_date IS NULL
1163: OR p_sr_status IS NULL
1164: THEN
1165: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1166: THEN
1167: FND_LOG.String
1168: (
1169: FND_LOG.level_unexpected

Line 1167: FND_LOG.String

1163: OR p_sr_status IS NULL
1164: THEN
1165: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1166: THEN
1167: FND_LOG.String
1168: (
1169: FND_LOG.level_unexpected
1170: , L_LOG_MODULE || 'no_params'
1171: , 'no parameters were supplied to the Concurrent program'

Line 1169: FND_LOG.level_unexpected

1165: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1166: THEN
1167: FND_LOG.String
1168: (
1169: FND_LOG.level_unexpected
1170: , L_LOG_MODULE || 'no_params'
1171: , 'no parameters were supplied to the Concurrent program'
1172: );
1173: END IF ;

Line 1185: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1181:
1182: END IF;
1183:
1184:
1185: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1186: THEN
1187: FND_LOG.String
1188: (
1189: FND_LOG.level_statement

Line 1187: FND_LOG.String

1183:
1184:
1185: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1186: THEN
1187: FND_LOG.String
1188: (
1189: FND_LOG.level_statement
1190: , L_LOG_MODULE || 'check_blind_cost_end'
1191: , 'after checking for blind search'

Line 1189: FND_LOG.level_statement

1185: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1186: THEN
1187: FND_LOG.String
1188: (
1189: FND_LOG.level_statement
1190: , L_LOG_MODULE || 'check_blind_cost_end'
1191: , 'after checking for blind search'
1192: );
1193: END IF;

Line 1197: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1193: END IF;
1194:
1195: IF p_creation_from_date IS NOT NULL
1196: THEN
1197: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1198: THEN
1199: FND_LOG.String
1200: (
1201: FND_LOG.level_statement

Line 1199: FND_LOG.String

1195: IF p_creation_from_date IS NOT NULL
1196: THEN
1197: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1198: THEN
1199: FND_LOG.String
1200: (
1201: FND_LOG.level_statement
1202: , L_LOG_MODULE || 'check_date_format_start_1'
1203: , 'checking if p_creation_from_date is in the format '

Line 1201: FND_LOG.level_statement

1197: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1198: THEN
1199: FND_LOG.String
1200: (
1201: FND_LOG.level_statement
1202: , L_LOG_MODULE || 'check_date_format_start_1'
1203: , 'checking if p_creation_from_date is in the format '
1204: || fnd_date.user_mask
1205: );

Line 1221: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1217: );
1218:
1219: IF x_creation_from_date IS NULL
1220: THEN
1221: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1222: THEN
1223: FND_LOG.String
1224: (
1225: FND_LOG.level_unexpected

Line 1223: FND_LOG.String

1219: IF x_creation_from_date IS NULL
1220: THEN
1221: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1222: THEN
1223: FND_LOG.String
1224: (
1225: FND_LOG.level_unexpected
1226: , L_LOG_MODULE || 'crtfrmdt_format_invalid'
1227: , 'format of field p_creation_from_date is invalid. should be '

Line 1225: FND_LOG.level_unexpected

1221: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1222: THEN
1223: FND_LOG.String
1224: (
1225: FND_LOG.level_unexpected
1226: , L_LOG_MODULE || 'crtfrmdt_format_invalid'
1227: , 'format of field p_creation_from_date is invalid. should be '
1228: || fnd_date.user_mask
1229: );

Line 1256: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1252:
1253:
1254: END IF;
1255:
1256: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1257: THEN
1258: FND_LOG.String
1259: (
1260: FND_LOG.level_statement

Line 1258: FND_LOG.String

1254: END IF;
1255:
1256: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1257: THEN
1258: FND_LOG.String
1259: (
1260: FND_LOG.level_statement
1261: , L_LOG_MODULE || 'check_date_format_end_1'
1262: , 'after checking if p_creation_from_date is in the format '

Line 1260: FND_LOG.level_statement

1256: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1257: THEN
1258: FND_LOG.String
1259: (
1260: FND_LOG.level_statement
1261: , L_LOG_MODULE || 'check_date_format_end_1'
1262: , 'after checking if p_creation_from_date is in the format '
1263: || fnd_date.user_mask
1264: );

Line 1272: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1268: ------------------------------------------------------
1269:
1270: IF p_creation_to_date IS NOT NULL
1271: THEN
1272: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1273: THEN
1274: FND_LOG.String
1275: (
1276: FND_LOG.level_statement

Line 1274: FND_LOG.String

1270: IF p_creation_to_date IS NOT NULL
1271: THEN
1272: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1273: THEN
1274: FND_LOG.String
1275: (
1276: FND_LOG.level_statement
1277: , L_LOG_MODULE || 'check_date_format_start_2'
1278: , 'checking if p_creation_to_date is in the format '

Line 1276: FND_LOG.level_statement

1272: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1273: THEN
1274: FND_LOG.String
1275: (
1276: FND_LOG.level_statement
1277: , L_LOG_MODULE || 'check_date_format_start_2'
1278: , 'checking if p_creation_to_date is in the format '
1279: || fnd_date.user_mask
1280: );

Line 1295: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1291: );
1292:
1293: IF x_creation_to_date IS NULL
1294: THEN
1295: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1296: THEN
1297: FND_LOG.String
1298: (
1299: FND_LOG.level_unexpected

Line 1297: FND_LOG.String

1293: IF x_creation_to_date IS NULL
1294: THEN
1295: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1296: THEN
1297: FND_LOG.String
1298: (
1299: FND_LOG.level_unexpected
1300: , L_LOG_MODULE || 'crttodt_format_invalid'
1301: , 'format of field p_creation_to_date is invalid. should be ' ||

Line 1299: FND_LOG.level_unexpected

1295: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1296: THEN
1297: FND_LOG.String
1298: (
1299: FND_LOG.level_unexpected
1300: , L_LOG_MODULE || 'crttodt_format_invalid'
1301: , 'format of field p_creation_to_date is invalid. should be ' ||
1302: fnd_date.user_mask
1303: );

Line 1328: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1324:
1325:
1326: END IF;
1327:
1328: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1329: THEN
1330: FND_LOG.String
1331: (
1332: FND_LOG.level_statement

Line 1330: FND_LOG.String

1326: END IF;
1327:
1328: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1329: THEN
1330: FND_LOG.String
1331: (
1332: FND_LOG.level_statement
1333: , L_LOG_MODULE || 'check_date_format_end_2'
1334: , 'after checking if p_creation_to_date is in the format ' ||

Line 1332: FND_LOG.level_statement

1328: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1329: THEN
1330: FND_LOG.String
1331: (
1332: FND_LOG.level_statement
1333: , L_LOG_MODULE || 'check_date_format_end_2'
1334: , 'after checking if p_creation_to_date is in the format ' ||
1335: fnd_date.user_mask
1336: );

Line 1357: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1353: -- satisfied.
1354:
1355: IF TRUNC(x_creation_to_date) = x_creation_to_date
1356: THEN
1357: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1358: THEN
1359: FND_LOG.String
1360: (
1361: FND_LOG.level_statement

Line 1359: FND_LOG.String

1355: IF TRUNC(x_creation_to_date) = x_creation_to_date
1356: THEN
1357: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1358: THEN
1359: FND_LOG.String
1360: (
1361: FND_LOG.level_statement
1362: , L_LOG_MODULE || 'add_time_to_todate_start'
1363: , 'adding time to x_creation_to_date if it does not have time'

Line 1361: FND_LOG.level_statement

1357: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1358: THEN
1359: FND_LOG.String
1360: (
1361: FND_LOG.level_statement
1362: , L_LOG_MODULE || 'add_time_to_todate_start'
1363: , 'adding time to x_creation_to_date if it does not have time'
1364: );
1365: END IF;

Line 1369: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1365: END IF;
1366:
1367: x_creation_to_date := x_creation_to_date + TIME_23_59_59;
1368:
1369: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1370: THEN
1371: FND_LOG.String
1372: (
1373: FND_LOG.level_statement

Line 1371: FND_LOG.String

1367: x_creation_to_date := x_creation_to_date + TIME_23_59_59;
1368:
1369: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1370: THEN
1371: FND_LOG.String
1372: (
1373: FND_LOG.level_statement
1374: , L_LOG_MODULE || 'add_time_to_todate_end'
1375: , 'adding time to x_creation_to_date if it does not have time ' ||

Line 1373: FND_LOG.level_statement

1369: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1370: THEN
1371: FND_LOG.String
1372: (
1373: FND_LOG.level_statement
1374: , L_LOG_MODULE || 'add_time_to_todate_end'
1375: , 'adding time to x_creation_to_date if it does not have time ' ||
1376: TO_CHAR(x_creation_to_date, 'DD-MON-YYYY HH24:MI:SS')
1377: );

Line 1389: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1385:
1386: IF x_creation_from_date IS NOT NULL
1387: AND x_creation_to_date IS NOT NULL
1388: THEN
1389: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1390: THEN
1391: FND_LOG.String
1392: (
1393: FND_LOG.level_statement

Line 1391: FND_LOG.String

1387: AND x_creation_to_date IS NOT NULL
1388: THEN
1389: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1390: THEN
1391: FND_LOG.String
1392: (
1393: FND_LOG.level_statement
1394: , L_LOG_MODULE || 'date_crossvalid_start_1'
1395: , 'doing cross field validations x_creation_from_date '

Line 1393: FND_LOG.level_statement

1389: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1390: THEN
1391: FND_LOG.String
1392: (
1393: FND_LOG.level_statement
1394: , L_LOG_MODULE || 'date_crossvalid_start_1'
1395: , 'doing cross field validations x_creation_from_date '
1396: || '> x_creation_to_date '
1397: );

Line 1406: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1402: -- x_creation_to_date
1403:
1404: IF x_creation_from_date > x_creation_to_date
1405: THEN
1406: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1407: THEN
1408: FND_LOG.String
1409: (
1410: FND_LOG.level_unexpected

Line 1408: FND_LOG.String

1404: IF x_creation_from_date > x_creation_to_date
1405: THEN
1406: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1407: THEN
1408: FND_LOG.String
1409: (
1410: FND_LOG.level_unexpected
1411: , L_LOG_MODULE || 'crtfrmdt_after_crttodt'
1412: , 'it is invalid to have x_creation_from_date > x_creation_to_date'

Line 1410: FND_LOG.level_unexpected

1406: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1407: THEN
1408: FND_LOG.String
1409: (
1410: FND_LOG.level_unexpected
1411: , L_LOG_MODULE || 'crtfrmdt_after_crttodt'
1412: , 'it is invalid to have x_creation_from_date > x_creation_to_date'
1413: );
1414: END IF ;

Line 1448: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1444:
1445: RAISE FND_API.G_EXC_ERROR;
1446: END IF;
1447:
1448: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1449: THEN
1450: FND_LOG.String
1451: (
1452: FND_LOG.level_statement

Line 1450: FND_LOG.String

1446: END IF;
1447:
1448: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1449: THEN
1450: FND_LOG.String
1451: (
1452: FND_LOG.level_statement
1453: , L_LOG_MODULE || 'date_crossvalid_end_1'
1454: , 'after doing cross field validations x_creation_from_date > '

Line 1452: FND_LOG.level_statement

1448: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1449: THEN
1450: FND_LOG.String
1451: (
1452: FND_LOG.level_statement
1453: , L_LOG_MODULE || 'date_crossvalid_end_1'
1454: , 'after doing cross field validations x_creation_from_date > '
1455: || 'x_creation_to_date '
1456: );

Line 1696: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1692: OR p_cost_batch_size IS NULL
1693:
1694:
1695: THEN
1696: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1697: THEN
1698: FND_LOG.String
1699: (
1700: FND_LOG.level_unexpected

Line 1698: FND_LOG.String

1694:
1695: THEN
1696: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1697: THEN
1698: FND_LOG.String
1699: (
1700: FND_LOG.level_unexpected
1701: , L_LOG_MODULE || 'worker_params_not_enuf'
1702: , 'no parameters were supplied to the cost worker program'

Line 1700: FND_LOG.level_unexpected

1696: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1697: THEN
1698: FND_LOG.String
1699: (
1700: FND_LOG.level_unexpected
1701: , L_LOG_MODULE || 'worker_params_not_enuf'
1702: , 'no parameters were supplied to the cost worker program'
1703: );
1704: END IF ;

Line 1729: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level

1725: AND r.status_code <> 'C';
1726:
1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN
1729: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1730: THEN
1731: FND_LOG.String
1732: (
1733: FND_LOG.level_unexpected

Line 1731: FND_LOG.String

1727: EXCEPTION
1728: WHEN NO_DATA_FOUND THEN
1729: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1730: THEN
1731: FND_LOG.String
1732: (
1733: FND_LOG.level_unexpected
1734: , L_LOG_MODULE || 'worker_purgset_invalid'
1735: , 'invalid cost set id supplied to the worker concurrent program'

Line 1733: FND_LOG.level_unexpected

1729: IF FND_LOG.level_unexpected >= FND_LOG.g_current_runtime_level
1730: THEN
1731: FND_LOG.String
1732: (
1733: FND_LOG.level_unexpected
1734: , L_LOG_MODULE || 'worker_purgset_invalid'
1735: , 'invalid cost set id supplied to the worker concurrent program'
1736: );
1737: END IF ;

Line 1919: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

1915: BEGIN
1916:
1917:
1918:
1919: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1920: THEN
1921: FND_LOG.String
1922: (
1923: FND_LOG.level_statement

Line 1921: FND_LOG.String

1917:
1918:
1919: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1920: THEN
1921: FND_LOG.String
1922: (
1923: FND_LOG.level_statement
1924: , L_LOG_MODULE || 'sr_submit_count_start'
1925: , 'Getting number of SRs submitted for Cost Creation'

Line 1923: FND_LOG.level_statement

1919: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
1920: THEN
1921: FND_LOG.String
1922: (
1923: FND_LOG.level_statement
1924: , L_LOG_MODULE || 'sr_submit_count_start'
1925: , 'Getting number of SRs submitted for Cost Creation'
1926: );
1927: END IF;

Line 2039: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2035: , '' || l_report_caption
2036: || ''
2037: || l_row_count || ''
2038: );
2039: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2040: THEN
2041: FND_LOG.String
2042: (
2043: FND_LOG.level_statement

Line 2041: FND_LOG.String

2037: || l_row_count || ''
2038: );
2039: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2040: THEN
2041: FND_LOG.String
2042: (
2043: FND_LOG.level_statement
2044: , L_LOG_MODULE || 'html_output_5'
2045: , '' || l_report_caption

Line 2043: FND_LOG.level_statement

2039: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2040: THEN
2041: FND_LOG.String
2042: (
2043: FND_LOG.level_statement
2044: , L_LOG_MODULE || 'html_output_5'
2045: , '' || l_report_caption
2046: || '' || l_row_count
2047: || ''

Line 2088: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2084: , '' || l_report_caption
2085: || '' || l_row_count
2086: || ''
2087: );
2088: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2089: THEN
2090: FND_LOG.String
2091: (
2092: FND_LOG.level_statement

Line 2090: FND_LOG.String

2086: || ''
2087: );
2088: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2089: THEN
2090: FND_LOG.String
2091: (
2092: FND_LOG.level_statement
2093: , L_LOG_MODULE || 'html_output_6'
2094: , '' || l_report_caption

Line 2092: FND_LOG.level_statement

2088: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2089: THEN
2090: FND_LOG.String
2091: (
2092: FND_LOG.level_statement
2093: , L_LOG_MODULE || 'html_output_6'
2094: , '' || l_report_caption
2095: || '' || l_row_count
2096: || ''

Line 2109: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2105: -- if there are any rows in the staging
2106: -- table with cost_status = E
2107:
2108: THEN
2109: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2110: THEN
2111: FND_LOG.String
2112: (
2113: FND_LOG.level_statement

Line 2111: FND_LOG.String

2107:
2108: THEN
2109: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2110: THEN
2111: FND_LOG.String
2112: (
2113: FND_LOG.level_statement
2114: , L_LOG_MODULE || 'sr_failure_report_start'
2115: , 'Listing all SRs that failed with details and error message'

Line 2113: FND_LOG.level_statement

2109: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2110: THEN
2111: FND_LOG.String
2112: (
2113: FND_LOG.level_statement
2114: , L_LOG_MODULE || 'sr_failure_report_start'
2115: , 'Listing all SRs that failed with details and error message'
2116: );
2117: END IF;

Line 2127: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2123: (
2124: FND_FILE.OUTPUT
2125: , '
'
2126: );
2127: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2128: THEN
2129: FND_LOG.String
2130: (
2131: FND_LOG.level_statement

Line 2129: FND_LOG.String

2125: , '
'
2126: );
2127: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2128: THEN
2129: FND_LOG.String
2130: (
2131: FND_LOG.level_statement
2132: , L_LOG_MODULE || 'html_output_7'
2133: , '
'

Line 2131: FND_LOG.level_statement

2127: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2128: THEN
2129: FND_LOG.String
2130: (
2131: FND_LOG.level_statement
2132: , L_LOG_MODULE || 'html_output_7'
2133: , '
'
2134: );
2135: END IF;

Line 2147: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2143: (
2144: FND_FILE.OUTPUT
2145: , l_report_caption
2146: );
2147: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2148: THEN
2149: FND_LOG.String
2150: (
2151: FND_LOG.level_statement

Line 2149: FND_LOG.String

2145: , l_report_caption
2146: );
2147: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2148: THEN
2149: FND_LOG.String
2150: (
2151: FND_LOG.level_statement
2152: , L_LOG_MODULE || 'html_output_8'
2153: , l_report_caption

Line 2151: FND_LOG.level_statement

2147: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2148: THEN
2149: FND_LOG.String
2150: (
2151: FND_LOG.level_statement
2152: , L_LOG_MODULE || 'html_output_8'
2153: , l_report_caption
2154: );
2155: END IF;

Line 2162: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2158: (
2159: FND_FILE.OUTPUT
2160: , ''
2161: );
2162: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2163: THEN
2164: FND_LOG.String
2165: (
2166: FND_LOG.level_statement

Line 2164: FND_LOG.String

2160: , ''
2161: );
2162: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2163: THEN
2164: FND_LOG.String
2165: (
2166: FND_LOG.level_statement
2167: , L_LOG_MODULE || 'html_output_9'
2168: , ''

Line 2166: FND_LOG.level_statement

2162: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2163: THEN
2164: FND_LOG.String
2165: (
2166: FND_LOG.level_statement
2167: , L_LOG_MODULE || 'html_output_9'
2168: , ''
2169: );
2170: END IF;

Line 2180: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2176: (
2177: FND_FILE.OUTPUT
2178: , ''
2179: );
2180: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2181: THEN
2182: FND_LOG.String
2183: (
2184: FND_LOG.level_statement
Line 2182: FND_LOG.String

2178: , '

'
2179: );
2180: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2181: THEN
2182: FND_LOG.String
2183: (
2184: FND_LOG.level_statement
2185: , L_LOG_MODULE || 'html_output_10'
2186: , '

'
Line 2184: FND_LOG.level_statement

2180: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2181: THEN
2182: FND_LOG.String
2183: (
2184: FND_LOG.level_statement
2185: , L_LOG_MODULE || 'html_output_10'
2186: , '

'
2187: );
2188: END IF;
Line 2200: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2196: (
2197: FND_FILE.OUTPUT
2198: , l_report_caption
2199: );
2200: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2201: THEN
2202: FND_LOG.String
2203: (
2204: FND_LOG.level_statement

Line 2202: FND_LOG.String

2198: , l_report_caption
2199: );
2200: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2201: THEN
2202: FND_LOG.String
2203: (
2204: FND_LOG.level_statement
2205: , L_LOG_MODULE || 'html_output_11'
2206: , l_report_caption

Line 2204: FND_LOG.level_statement

2200: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2201: THEN
2202: FND_LOG.String
2203: (
2204: FND_LOG.level_statement
2205: , L_LOG_MODULE || 'html_output_11'
2206: , l_report_caption
2207: );
2208: END IF;

Line 2215: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2211: (
2212: FND_FILE.OUTPUT
2213: , '
'
2214: );
2215: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2216: THEN
2217: FND_LOG.String
2218: (
2219: FND_LOG.level_statement
Line 2217: FND_LOG.String

2213: , ''
2214: );
2215: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2216: THEN
2217: FND_LOG.String
2218: (
2219: FND_LOG.level_statement
2220: , L_LOG_MODULE || 'html_output_12'
2221: , ''

Line 2219: FND_LOG.level_statement

2215: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2216: THEN
2217: FND_LOG.String
2218: (
2219: FND_LOG.level_statement
2220: , L_LOG_MODULE || 'html_output_12'
2221: , ''
2222: );
2223: END IF;

Line 2244: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2240: --, l_summary_arr
2241: , l_cost_error_message_arr
2242: LIMIT p_cost_batch_size;
2243:
2244: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2245: THEN
2246: FND_LOG.String
2247: (
2248: FND_LOG.level_statement

Line 2246: FND_LOG.String

2242: LIMIT p_cost_batch_size;
2243:
2244: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2245: THEN
2246: FND_LOG.String
2247: (
2248: FND_LOG.level_statement
2249: , L_LOG_MODULE || 'report_fetch_count'
2250: , 'Fetched ' || l_incident_number_arr.COUNT

Line 2248: FND_LOG.level_statement

2244: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2245: THEN
2246: FND_LOG.String
2247: (
2248: FND_LOG.level_statement
2249: , L_LOG_MODULE || 'report_fetch_count'
2250: , 'Fetched ' || l_incident_number_arr.COUNT
2251: || ' rows during this execution'
2252: );

Line 2274: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2270: FND_FILE.OUTPUT
2271: , '
'
2272: );
2273:
2274: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2275: THEN
2276: FND_LOG.String
2277: (
2278: FND_LOG.level_statement
Line 2276: FND_LOG.String

2272: );
2273:
2274: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2275: THEN
2276: FND_LOG.String
2277: (
2278: FND_LOG.level_statement
2279: , L_LOG_MODULE || 'html_output_13'
2280: , '
'
Line 2278: FND_LOG.level_statement

2274: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2275: THEN
2276: FND_LOG.String
2277: (
2278: FND_LOG.level_statement
2279: , L_LOG_MODULE || 'html_output_13'
2280: , '
'
2281: );
2282: END IF;
Line 2290: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2286: || '
'
2420: );
2421:
2422: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2423: THEN
2424: FND_LOG.String
2425: (
2426: FND_LOG.level_statement
Line 2424: FND_LOG.String

2420: );
2421:
2422: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2423: THEN
2424: FND_LOG.String
2425: (
2426: FND_LOG.level_statement
2427: , L_LOG_MODULE || 'html_output_15'
2428: , ''

Line 2426: FND_LOG.level_statement

2422: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2423: THEN
2424: FND_LOG.String
2425: (
2426: FND_LOG.level_statement
2427: , L_LOG_MODULE || 'html_output_15'
2428: , ''
2429: );
2430: END IF;

Line 2441: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2437: CLOSE c_cost_staging_err;
2438:
2439:
2440:
2441: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2442: THEN
2443: FND_LOG.String
2444: (
2445: FND_LOG.level_statement

Line 2443: FND_LOG.String

2439:
2440:
2441: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2442: THEN
2443: FND_LOG.String
2444: (
2445: FND_LOG.level_statement
2446: , L_LOG_MODULE || 'sr_failure_report_end'
2447: , 'After listing all SRs that failed with details and error message'

Line 2445: FND_LOG.level_statement

2441: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2442: THEN
2443: FND_LOG.String
2444: (
2445: FND_LOG.level_statement
2446: , L_LOG_MODULE || 'sr_failure_report_end'
2447: , 'After listing all SRs that failed with details and error message'
2448: );
2449: END IF;

Line 2457: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2453: (
2454: FND_FILE.OUTPUT
2455: , '

' || NVL(l_line_number_arr(j), '-')
2287: -- || ' ' || l_summary_arr(j)
2288: || ' ';
2289:
2290: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2291: THEN
2292: FND_LOG.String
2293: (
2294: FND_LOG.level_statement

Line 2292: FND_LOG.String

2288: || '
';
2289:
2290: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2291: THEN
2292: FND_LOG.String
2293: (
2294: FND_LOG.level_statement
2295: , L_LOG_MODULE || 'compute_text'
2296: , 'framing l_text = ' || l_text

Line 2294: FND_LOG.level_statement

2290: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2291: THEN
2292: FND_LOG.String
2293: (
2294: FND_LOG.level_statement
2295: , L_LOG_MODULE || 'compute_text'
2296: , 'framing l_text = ' || l_text
2297: );
2298: END IF;

Line 2307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2303: , ':'
2304: , 1
2305: );
2306:
2307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2308: THEN
2309: FND_LOG.String
2310: (
2311: FND_LOG.level_statement

Line 2309: FND_LOG.String

2305: );
2306:
2307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2308: THEN
2309: FND_LOG.String
2310: (
2311: FND_LOG.level_statement
2312: , L_LOG_MODULE || 'compute_text_1'
2313: , 'getting l_error_code_loc = ' || l_error_code_loc

Line 2311: FND_LOG.level_statement

2307: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2308: THEN
2309: FND_LOG.String
2310: (
2311: FND_LOG.level_statement
2312: , L_LOG_MODULE || 'compute_text_1'
2313: , 'getting l_error_code_loc = ' || l_error_code_loc
2314: );
2315: END IF;

Line 2325: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2321: , 1
2322: );
2323:
2324:
2325: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2326: THEN
2327: FND_LOG.String
2328: (
2329: FND_LOG.level_statement

Line 2327: FND_LOG.String

2323:
2324:
2325: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2326: THEN
2327: FND_LOG.String
2328: (
2329: FND_LOG.level_statement
2330: , L_LOG_MODULE || 'compute_text_2'
2331: , 'getting l_error_message_loc = ' || l_error_message_loc

Line 2329: FND_LOG.level_statement

2325: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2326: THEN
2327: FND_LOG.String
2328: (
2329: FND_LOG.level_statement
2330: , L_LOG_MODULE || 'compute_text_2'
2331: , 'getting l_error_message_loc = ' || l_error_message_loc
2332: );
2333: END IF;

Line 2361: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2357: l_cost_error_message_arr(j)
2358: , l_error_message_loc + 1
2359: );
2360:
2361: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2362: THEN
2363: FND_LOG.String
2364: (
2365: FND_LOG.level_statement

Line 2363: FND_LOG.String

2359: );
2360:
2361: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2362: THEN
2363: FND_LOG.String
2364: (
2365: FND_LOG.level_statement
2366: , L_LOG_MODULE || 'compute_text_3.1'
2367: , 'getting l_error_message_text = ' || l_error_message_text

Line 2365: FND_LOG.level_statement

2361: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2362: THEN
2363: FND_LOG.String
2364: (
2365: FND_LOG.level_statement
2366: , L_LOG_MODULE || 'compute_text_3.1'
2367: , 'getting l_error_message_text = ' || l_error_message_text
2368: );
2369: END IF;

Line 2387: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2383: , l_error_code_loc + 1
2384: )
2385: );
2386:
2387: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2388: THEN
2389: FND_LOG.String
2390: (
2391: FND_LOG.level_statement

Line 2389: FND_LOG.String

2385: );
2386:
2387: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2388: THEN
2389: FND_LOG.String
2390: (
2391: FND_LOG.level_statement
2392: , L_LOG_MODULE || 'compute_text_3.2'
2393: , 'getting l_error_message_text = ' || l_error_message_text

Line 2391: FND_LOG.level_statement

2387: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2388: THEN
2389: FND_LOG.String
2390: (
2391: FND_LOG.level_statement
2392: , L_LOG_MODULE || 'compute_text_3.2'
2393: , 'getting l_error_message_text = ' || l_error_message_text
2394: );
2395: END IF;

Line 2406: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2402: FND_FILE.OUTPUT
2403: , l_text
2404: );
2405:
2406: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2407: THEN
2408: FND_LOG.String
2409: (
2410: FND_LOG.level_statement

Line 2408: FND_LOG.String

2404: );
2405:
2406: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2407: THEN
2408: FND_LOG.String
2409: (
2410: FND_LOG.level_statement
2411: , L_LOG_MODULE || 'html_output_14'
2412: , l_text

Line 2410: FND_LOG.level_statement

2406: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2407: THEN
2408: FND_LOG.String
2409: (
2410: FND_LOG.level_statement
2411: , L_LOG_MODULE || 'html_output_14'
2412: , l_text
2413: );
2414: END IF;

Line 2422: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level

2418: FND_FILE.OUTPUT
2419: , '

'
2456: );
2457: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2458: THEN
2459: FND_LOG.String
2460: (
2461: FND_LOG.level_statement

Line 2459: FND_LOG.String

2455: , ''
2456: );
2457: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2458: THEN
2459: FND_LOG.String
2460: (
2461: FND_LOG.level_statement
2462: , L_LOG_MODULE || 'html_output_16'
2463: , ''

Line 2461: FND_LOG.level_statement

2457: IF FND_LOG.level_statement >= FND_LOG.g_current_runtime_level
2458: THEN
2459: FND_LOG.String
2460: (
2461: FND_LOG.level_statement
2462: , L_LOG_MODULE || 'html_output_16'
2463: , ''
2464: );
2465: END IF;

Line 2469: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level

2465: END IF;
2466:
2467: ---
2468:
2469: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2470: THEN
2471: FND_LOG.String
2472: (
2473: FND_LOG.level_procedure

Line 2471: FND_LOG.String

2467: ---
2468:
2469: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2470: THEN
2471: FND_LOG.String
2472: (
2473: FND_LOG.level_procedure
2474: , L_LOG_MODULE || 'end'
2475: , 'Completed work in ' || L_API_NAME_FULL || ' with Success'

Line 2473: FND_LOG.level_procedure

2469: IF FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level
2470: THEN
2471: FND_LOG.String
2472: (
2473: FND_LOG.level_procedure
2474: , L_LOG_MODULE || 'end'
2475: , 'Completed work in ' || L_API_NAME_FULL || ' with Success'
2476: );
2477: END IF ;