[Home] [Help]
143:
144: BEGIN
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
148: THEN
149: fnd_log.string
150: (
151: fnd_log.level_procedure
145: x_return_status := FND_API.G_RET_STS_SUCCESS;
146:
147: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
148: THEN
149: fnd_log.string
150: (
151: fnd_log.level_procedure
152: , L_LOG_MODULE || 'start'
153: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
147: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
148: THEN
149: fnd_log.string
150: (
151: fnd_log.level_procedure
152: , L_LOG_MODULE || 'start'
153: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
154: );
155: fnd_log.string
151: fnd_log.level_procedure
152: , L_LOG_MODULE || 'start'
153: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
154: );
155: fnd_log.string
156: (
157: fnd_log.level_procedure
158: , L_LOG_MODULE || 'param 1'
159: , 'p_api_version_number:' || p_api_version_number
153: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
154: );
155: fnd_log.string
156: (
157: fnd_log.level_procedure
158: , L_LOG_MODULE || 'param 1'
159: , 'p_api_version_number:' || p_api_version_number
160: );
161: fnd_log.string
157: fnd_log.level_procedure
158: , L_LOG_MODULE || 'param 1'
159: , 'p_api_version_number:' || p_api_version_number
160: );
161: fnd_log.string
162: (
163: fnd_log.level_procedure
164: , L_LOG_MODULE || 'param 2'
165: , 'p_init_msg_list:' || p_init_msg_list
159: , 'p_api_version_number:' || p_api_version_number
160: );
161: fnd_log.string
162: (
163: fnd_log.level_procedure
164: , L_LOG_MODULE || 'param 2'
165: , 'p_init_msg_list:' || p_init_msg_list
166: );
167: fnd_log.string
163: fnd_log.level_procedure
164: , L_LOG_MODULE || 'param 2'
165: , 'p_init_msg_list:' || p_init_msg_list
166: );
167: fnd_log.string
168: (
169: fnd_log.level_procedure
170: , L_LOG_MODULE || 'param 3'
171: , 'p_commit:' || p_commit
165: , 'p_init_msg_list:' || p_init_msg_list
166: );
167: fnd_log.string
168: (
169: fnd_log.level_procedure
170: , L_LOG_MODULE || 'param 3'
171: , 'p_commit:' || p_commit
172: );
173: fnd_log.string
169: fnd_log.level_procedure
170: , L_LOG_MODULE || 'param 3'
171: , 'p_commit:' || p_commit
172: );
173: fnd_log.string
174: (
175: fnd_log.level_procedure
176: , L_LOG_MODULE || 'param 4'
177: , 'p_purge_source_with_open_task:' || p_purge_source_with_open_task
171: , 'p_commit:' || p_commit
172: );
173: fnd_log.string
174: (
175: fnd_log.level_procedure
176: , L_LOG_MODULE || 'param 4'
177: , 'p_purge_source_with_open_task:' || p_purge_source_with_open_task
178: );
179: fnd_log.string
175: fnd_log.level_procedure
176: , L_LOG_MODULE || 'param 4'
177: , 'p_purge_source_with_open_task:' || p_purge_source_with_open_task
178: );
179: fnd_log.string
180: (
181: fnd_log.level_procedure
182: , L_LOG_MODULE || 'param 5'
183: , 'p_object_type:' || p_object_type
177: , 'p_purge_source_with_open_task:' || p_purge_source_with_open_task
178: );
179: fnd_log.string
180: (
181: fnd_log.level_procedure
182: , L_LOG_MODULE || 'param 5'
183: , 'p_object_type:' || p_object_type
184: );
185: fnd_log.string
181: fnd_log.level_procedure
182: , L_LOG_MODULE || 'param 5'
183: , 'p_object_type:' || p_object_type
184: );
185: fnd_log.string
186: (
187: fnd_log.level_procedure
188: , L_LOG_MODULE || 'param 6'
189: , 'p_processing_set_id:' || p_processing_set_id
183: , 'p_object_type:' || p_object_type
184: );
185: fnd_log.string
186: (
187: fnd_log.level_procedure
188: , L_LOG_MODULE || 'param 6'
189: , 'p_processing_set_id:' || p_processing_set_id
190: );
191: END IF ;
216: ------------------------------------------------------------------------------
217:
218: IF NVL(p_object_type, 'X') <> 'SR'
219: THEN
220: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
221: THEN
222: fnd_log.string
223: (
224: fnd_log.level_unexpected
218: IF NVL(p_object_type, 'X') <> 'SR'
219: THEN
220: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
221: THEN
222: fnd_log.string
223: (
224: fnd_log.level_unexpected
225: , L_LOG_MODULE || 'object_type_invalid'
226: , 'p_object_type has to be SR.'
220: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
221: THEN
222: fnd_log.string
223: (
224: fnd_log.level_unexpected
225: , L_LOG_MODULE || 'object_type_invalid'
226: , 'p_object_type has to be SR.'
227: );
228: END IF ;
239: ---
240:
241: IF p_processing_set_id IS NULL
242: THEN
243: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
244: THEN
245: fnd_log.string
246: (
247: fnd_log.level_unexpected
241: IF p_processing_set_id IS NULL
242: THEN
243: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
244: THEN
245: fnd_log.string
246: (
247: fnd_log.level_unexpected
248: , L_LOG_MODULE || 'proc_set_id_invalid'
249: , 'p_processing_set_id should not be NULL.'
243: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
244: THEN
245: fnd_log.string
246: (
247: fnd_log.level_unexpected
248: , L_LOG_MODULE || 'proc_set_id_invalid'
249: , 'p_processing_set_id should not be NULL.'
250: );
251: END IF ;
263:
264: IF p_purge_source_with_open_task IS NULL
265: OR NVL(p_purge_source_with_open_task, 'X') NOT IN ('Y', 'N')
266: THEN
267: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
268: THEN
269: fnd_log.string
270: (
271: fnd_log.level_unexpected
265: OR NVL(p_purge_source_with_open_task, 'X') NOT IN ('Y', 'N')
266: THEN
267: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
268: THEN
269: fnd_log.string
270: (
271: fnd_log.level_unexpected
272: , L_LOG_MODULE || 'p_purge_source_with_open_task_invalid'
273: , 'p_purge_source_with_open_task value is invalid.'
267: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
268: THEN
269: fnd_log.string
270: (
271: fnd_log.level_unexpected
272: , L_LOG_MODULE || 'p_purge_source_with_open_task_invalid'
273: , 'p_purge_source_with_open_task value is invalid.'
274: );
275: END IF ;
300: ---
301:
302: IF x_return_status = FND_API.G_RET_STS_SUCCESS
303: THEN
304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
305: THEN
306: fnd_log.string
307: (
308: fnd_log.level_statement
302: IF x_return_status = FND_API.G_RET_STS_SUCCESS
303: THEN
304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
305: THEN
306: fnd_log.string
307: (
308: fnd_log.level_statement
309: , L_LOG_MODULE || 'field_service_valid_start'
310: , 'calling the Field Service validation API '
304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
305: THEN
306: fnd_log.string
307: (
308: fnd_log.level_statement
309: , L_LOG_MODULE || 'field_service_valid_start'
310: , 'calling the Field Service validation API '
311: || 'csf_maintain_grp.validate_fieldserviceobjects'
312: );
327: , x_msg_count => x_msg_count
328: , x_msg_data => x_msg_data
329: );
330:
331: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
332: THEN
333: fnd_log.string
334: (
335: fnd_log.level_statement
329: );
330:
331: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
332: THEN
333: fnd_log.string
334: (
335: fnd_log.level_statement
336: , L_LOG_MODULE || 'field_service_valid_end'
337: , 'returned from Field Service validation API with status '
331: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
332: THEN
333: fnd_log.string
334: (
335: fnd_log.level_statement
336: , L_LOG_MODULE || 'field_service_valid_end'
337: , 'returned from Field Service validation API with status '
338: || x_return_status
339: );
347: ---
348:
349: IF x_return_status = FND_API.G_RET_STS_SUCCESS
350: THEN
351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
352: THEN
353: fnd_log.string
354: (
355: fnd_log.level_statement
349: IF x_return_status = FND_API.G_RET_STS_SUCCESS
350: THEN
351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
352: THEN
353: fnd_log.string
354: (
355: fnd_log.level_statement
356: , L_LOG_MODULE || 'charges_valid_start'
357: , 'calling the Charges validation API '
351: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
352: THEN
353: fnd_log.string
354: (
355: fnd_log.level_statement
356: , L_LOG_MODULE || 'charges_valid_start'
357: , 'calling the Charges validation API '
358: || 'cs_charge_details_pvt.purge_chg_validations'
359: );
374: , x_msg_count => x_msg_count
375: , x_msg_data => x_msg_data
376: );
377:
378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
379: THEN
380: fnd_log.string
381: (
382: fnd_log.level_statement
376: );
377:
378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
379: THEN
380: fnd_log.string
381: (
382: fnd_log.level_statement
383: , L_LOG_MODULE || 'charges_valid_end'
384: , 'returned from Charges validation API with status ' || x_return_status
378: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
379: THEN
380: fnd_log.string
381: (
382: fnd_log.level_statement
383: , L_LOG_MODULE || 'charges_valid_end'
384: , 'returned from Charges validation API with status ' || x_return_status
385: );
386: END IF ;
393: ---
394:
395: IF x_return_status = FND_API.G_RET_STS_SUCCESS
396: THEN
397: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
398: THEN
399: fnd_log.string
400: (
401: fnd_log.level_statement
395: IF x_return_status = FND_API.G_RET_STS_SUCCESS
396: THEN
397: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
398: THEN
399: fnd_log.string
400: (
401: fnd_log.level_statement
402: , L_LOG_MODULE || 'task_valid_start'
403: , 'calling the Tasks validation API cac_task_purge_pub.validate_tasks'
397: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
398: THEN
399: fnd_log.string
400: (
401: fnd_log.level_statement
402: , L_LOG_MODULE || 'task_valid_start'
403: , 'calling the Tasks validation API cac_task_purge_pub.validate_tasks'
404: );
405: END IF ;
420: , x_msg_count => x_msg_count
421: , x_msg_data => x_msg_data
422: );
423:
424: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
425: THEN
426: fnd_log.string
427: (
428: fnd_log.level_statement
422: );
423:
424: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
425: THEN
426: fnd_log.string
427: (
428: fnd_log.level_statement
429: , L_LOG_MODULE || 'task_valid_end'
430: , 'returned from Tasks validation API with status ' || x_return_status
424: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
425: THEN
426: fnd_log.string
427: (
428: fnd_log.level_statement
429: , L_LOG_MODULE || 'task_valid_end'
430: , 'returned from Tasks validation API with status ' || x_return_status
431: );
432: END IF ;
437: Check_User_Termination;
438:
439: ---
440:
441: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
442: THEN
443: fnd_log.string
444: (
445: fnd_log.level_procedure
439: ---
440:
441: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
442: THEN
443: fnd_log.string
444: (
445: fnd_log.level_procedure
446: , L_LOG_MODULE || 'end'
447: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
441: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
442: THEN
443: fnd_log.string
444: (
445: fnd_log.level_procedure
446: , L_LOG_MODULE || 'end'
447: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
448: || x_return_status
449: );
453:
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456:
457: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
458: THEN
459: fnd_log.string
460: (
461: fnd_log.level_unexpected
455: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
456:
457: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
458: THEN
459: fnd_log.string
460: (
461: fnd_log.level_unexpected
462: , L_LOG_MODULE || 'unexpected_error'
463: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
457: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
458: THEN
459: fnd_log.string
460: (
461: fnd_log.level_unexpected
462: , L_LOG_MODULE || 'unexpected_error'
463: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
464: );
465:
476: , p_encoded => 'F'
477: , p_data => x_msg_data
478: , p_msg_index_out => x_msg_index_out
479: );
480: fnd_log.string
481: (
482: fnd_log.level_unexpected
483: , L_LOG_MODULE || 'unexpected_error'
484: , 'Error encountered is : ' || x_msg_data || ' [Index:'
478: , p_msg_index_out => x_msg_index_out
479: );
480: fnd_log.string
481: (
482: fnd_log.level_unexpected
483: , L_LOG_MODULE || 'unexpected_error'
484: , 'Error encountered is : ' || x_msg_data || ' [Index:'
485: || x_msg_index_out || ']'
486: );
494: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
495: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
496: FND_MSG_PUB.ADD;
497:
498: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
499: THEN
500: fnd_log.string
501: (
502: fnd_log.level_unexpected
496: FND_MSG_PUB.ADD;
497:
498: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
499: THEN
500: fnd_log.string
501: (
502: fnd_log.level_unexpected
503: , L_LOG_MODULE || 'when_others'
504: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
498: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
499: THEN
500: fnd_log.string
501: (
502: fnd_log.level_unexpected
503: , L_LOG_MODULE || 'when_others'
504: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
505: );
506: fnd_log.string
502: fnd_log.level_unexpected
503: , L_LOG_MODULE || 'when_others'
504: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
505: );
506: fnd_log.string
507: (
508: fnd_log.level_unexpected
509: , L_LOG_MODULE || 'when_others'
510: , SQLERRM
504: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
505: );
506: fnd_log.string
507: (
508: fnd_log.level_unexpected
509: , L_LOG_MODULE || 'when_others'
510: , SQLERRM
511: );
512: END IF ;
613:
614: BEGIN
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
618: THEN
619: fnd_log.string
620: (
621: fnd_log.level_procedure
615: x_return_status := FND_API.G_RET_STS_SUCCESS;
616:
617: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
618: THEN
619: fnd_log.string
620: (
621: fnd_log.level_procedure
622: , L_LOG_MODULE || 'start'
623: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
617: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
618: THEN
619: fnd_log.string
620: (
621: fnd_log.level_procedure
622: , L_LOG_MODULE || 'start'
623: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
624: );
625: fnd_log.string
621: fnd_log.level_procedure
622: , L_LOG_MODULE || 'start'
623: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
624: );
625: fnd_log.string
626: (
627: fnd_log.level_procedure
628: , L_LOG_MODULE || 'param 1'
629: , 'p_api_version_number:' || p_api_version_number
623: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
624: );
625: fnd_log.string
626: (
627: fnd_log.level_procedure
628: , L_LOG_MODULE || 'param 1'
629: , 'p_api_version_number:' || p_api_version_number
630: );
631: fnd_log.string
627: fnd_log.level_procedure
628: , L_LOG_MODULE || 'param 1'
629: , 'p_api_version_number:' || p_api_version_number
630: );
631: fnd_log.string
632: (
633: fnd_log.level_procedure
634: , L_LOG_MODULE || 'param 2'
635: , 'p_init_msg_list:' || p_init_msg_list
629: , 'p_api_version_number:' || p_api_version_number
630: );
631: fnd_log.string
632: (
633: fnd_log.level_procedure
634: , L_LOG_MODULE || 'param 2'
635: , 'p_init_msg_list:' || p_init_msg_list
636: );
637: fnd_log.string
633: fnd_log.level_procedure
634: , L_LOG_MODULE || 'param 2'
635: , 'p_init_msg_list:' || p_init_msg_list
636: );
637: fnd_log.string
638: (
639: fnd_log.level_procedure
640: , L_LOG_MODULE || 'param 3'
641: , 'p_commit:' || p_commit
635: , 'p_init_msg_list:' || p_init_msg_list
636: );
637: fnd_log.string
638: (
639: fnd_log.level_procedure
640: , L_LOG_MODULE || 'param 3'
641: , 'p_commit:' || p_commit
642: );
643: fnd_log.string
639: fnd_log.level_procedure
640: , L_LOG_MODULE || 'param 3'
641: , 'p_commit:' || p_commit
642: );
643: fnd_log.string
644: (
645: fnd_log.level_procedure
646: , L_LOG_MODULE || 'param 4'
647: , 'p_object_type:' || p_object_type
641: , 'p_commit:' || p_commit
642: );
643: fnd_log.string
644: (
645: fnd_log.level_procedure
646: , L_LOG_MODULE || 'param 4'
647: , 'p_object_type:' || p_object_type
648: );
649: fnd_log.string
645: fnd_log.level_procedure
646: , L_LOG_MODULE || 'param 4'
647: , 'p_object_type:' || p_object_type
648: );
649: fnd_log.string
650: (
651: fnd_log.level_procedure
652: , L_LOG_MODULE || 'param 5'
653: , 'p_processing_set_id:' || p_processing_set_id
647: , 'p_object_type:' || p_object_type
648: );
649: fnd_log.string
650: (
651: fnd_log.level_procedure
652: , L_LOG_MODULE || 'param 5'
653: , 'p_processing_set_id:' || p_processing_set_id
654: );
655: fnd_log.string
651: fnd_log.level_procedure
652: , L_LOG_MODULE || 'param 5'
653: , 'p_processing_set_id:' || p_processing_set_id
654: );
655: fnd_log.string
656: (
657: fnd_log.level_procedure
658: , L_LOG_MODULE || 'param 6'
659: , 'p_purge_set_id:' || p_purge_set_id
653: , 'p_processing_set_id:' || p_processing_set_id
654: );
655: fnd_log.string
656: (
657: fnd_log.level_procedure
658: , L_LOG_MODULE || 'param 6'
659: , 'p_purge_set_id:' || p_purge_set_id
660: );
661: fnd_log.string
657: fnd_log.level_procedure
658: , L_LOG_MODULE || 'param 6'
659: , 'p_purge_set_id:' || p_purge_set_id
660: );
661: fnd_log.string
662: (
663: fnd_log.level_procedure
664: , L_LOG_MODULE || 'param 7'
665: , 'p_audit_required:' || p_audit_required
659: , 'p_purge_set_id:' || p_purge_set_id
660: );
661: fnd_log.string
662: (
663: fnd_log.level_procedure
664: , L_LOG_MODULE || 'param 7'
665: , 'p_audit_required:' || p_audit_required
666: );
667: END IF ;
694:
695: IF p_audit_required IS NULL
696: OR NVL(p_audit_required, 'X') NOT IN ('Y', 'N')
697: THEN
698: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
699: THEN
700: fnd_log.string
701: (
702: fnd_log.level_unexpected
696: OR NVL(p_audit_required, 'X') NOT IN ('Y', 'N')
697: THEN
698: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
699: THEN
700: fnd_log.string
701: (
702: fnd_log.level_unexpected
703: , L_LOG_MODULE || 'audit_required_invalid'
704: , 'p_audit_required has to be Y/N.'
698: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
699: THEN
700: fnd_log.string
701: (
702: fnd_log.level_unexpected
703: , L_LOG_MODULE || 'audit_required_invalid'
704: , 'p_audit_required has to be Y/N.'
705: );
706: END IF ;
717: ---
718:
719: IF NVL(p_object_type, 'X') <> 'SR'
720: THEN
721: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
722: THEN
723: fnd_log.string
724: (
725: fnd_log.level_unexpected
719: IF NVL(p_object_type, 'X') <> 'SR'
720: THEN
721: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
722: THEN
723: fnd_log.string
724: (
725: fnd_log.level_unexpected
726: , L_LOG_MODULE || 'object_type_invalid'
727: , 'p_object_type has to be SR.'
721: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
722: THEN
723: fnd_log.string
724: (
725: fnd_log.level_unexpected
726: , L_LOG_MODULE || 'object_type_invalid'
727: , 'p_object_type has to be SR.'
728: );
729: END IF ;
740: ---
741:
742: IF p_processing_set_id IS NULL
743: THEN
744: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
745: THEN
746: fnd_log.string
747: (
748: fnd_log.level_unexpected
742: IF p_processing_set_id IS NULL
743: THEN
744: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
745: THEN
746: fnd_log.string
747: (
748: fnd_log.level_unexpected
749: , L_LOG_MODULE || 'proc_set_id_invalid'
750: , 'Processing Set Id should not be NULL.'
744: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
745: THEN
746: fnd_log.string
747: (
748: fnd_log.level_unexpected
749: , L_LOG_MODULE || 'proc_set_id_invalid'
750: , 'Processing Set Id should not be NULL.'
751: );
752: END IF ;
779: dual
780: WHERE
781: ROWNUM = 1;
782:
783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
784: THEN
785: fnd_log.string
786: (
787: fnd_log.level_statement
781: ROWNUM = 1;
782:
783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
784: THEN
785: fnd_log.string
786: (
787: fnd_log.level_statement
788: , L_LOG_MODULE || 'gen_purge_set_id'
789: , 'Generated a new purge_set_id ' || l_purge_set_id
783: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
784: THEN
785: fnd_log.string
786: (
787: fnd_log.level_statement
788: , L_LOG_MODULE || 'gen_purge_set_id'
789: , 'Generated a new purge_set_id ' || l_purge_set_id
790: );
791: END IF ;
798: ---
799:
800: IF x_return_status = FND_API.G_RET_STS_SUCCESS
801: THEN
802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
803: THEN
804: fnd_log.string
805: (
806: fnd_log.level_statement
800: IF x_return_status = FND_API.G_RET_STS_SUCCESS
801: THEN
802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
803: THEN
804: fnd_log.string
805: (
806: fnd_log.level_statement
807: , L_LOG_MODULE || 'field_service_purge_start'
808: , 'calling the Field Service purge API '
802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
803: THEN
804: fnd_log.string
805: (
806: fnd_log.level_statement
807: , L_LOG_MODULE || 'field_service_purge_start'
808: , 'calling the Field Service purge API '
809: || 'csf_maintain_grp.purge_fieldserviceobjects'
810: );
824: , x_msg_count => x_msg_count
825: , x_msg_data => x_msg_data
826: );
827:
828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
829: THEN
830: fnd_log.string
831: (
832: fnd_log.level_statement
826: );
827:
828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
829: THEN
830: fnd_log.string
831: (
832: fnd_log.level_statement
833: , L_LOG_MODULE || 'field_service_purge_end'
834: , 'returned from Field Service purge API with status '
828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
829: THEN
830: fnd_log.string
831: (
832: fnd_log.level_statement
833: , L_LOG_MODULE || 'field_service_purge_end'
834: , 'returned from Field Service purge API with status '
835: || x_return_status
836: );
844: ---
845:
846: IF x_return_status = FND_API.G_RET_STS_SUCCESS
847: THEN
848: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
849: THEN
850: fnd_log.string
851: (
852: fnd_log.level_statement
846: IF x_return_status = FND_API.G_RET_STS_SUCCESS
847: THEN
848: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
849: THEN
850: fnd_log.string
851: (
852: fnd_log.level_statement
853: , L_LOG_MODULE || 'charges_purge_start'
854: , 'calling the Charges purge API '
848: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
849: THEN
850: fnd_log.string
851: (
852: fnd_log.level_statement
853: , L_LOG_MODULE || 'charges_purge_start'
854: , 'calling the Charges purge API '
855: || 'cs_charge_details_pvt.purge_charges'
856: );
870: , x_msg_count => x_msg_count
871: , x_msg_data => x_msg_data
872: );
873:
874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
875: THEN
876: fnd_log.string
877: (
878: fnd_log.level_statement
872: );
873:
874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
875: THEN
876: fnd_log.string
877: (
878: fnd_log.level_statement
879: , L_LOG_MODULE || 'charges_purge_end'
880: , 'returned from Charges purge API with status '
874: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
875: THEN
876: fnd_log.string
877: (
878: fnd_log.level_statement
879: , L_LOG_MODULE || 'charges_purge_end'
880: , 'returned from Charges purge API with status '
881: || x_return_status
882: );
893: --Added for 12.1 Service Costing
894:
895: IF x_return_status = FND_API.G_RET_STS_SUCCESS
896: THEN
897: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
898: THEN
899: fnd_log.string
900: (
901: fnd_log.level_statement
895: IF x_return_status = FND_API.G_RET_STS_SUCCESS
896: THEN
897: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
898: THEN
899: fnd_log.string
900: (
901: fnd_log.level_statement
902: , L_LOG_MODULE || 'cost_purge_start'
903: , 'calling the Cost purge API '
897: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
898: THEN
899: fnd_log.string
900: (
901: fnd_log.level_statement
902: , L_LOG_MODULE || 'cost_purge_start'
903: , 'calling the Cost purge API '
904: || 'cs_cost_details_pvt.purge_cost'
905: );
923: , x_msg_data => x_msg_data
924: );
925:
926:
927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
928: THEN
929: fnd_log.string
930: (
931: fnd_log.level_statement
925:
926:
927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
928: THEN
929: fnd_log.string
930: (
931: fnd_log.level_statement
932: , L_LOG_MODULE || 'cost_purge_end'
933: , 'returned from cost purge API with status '
927: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
928: THEN
929: fnd_log.string
930: (
931: fnd_log.level_statement
932: , L_LOG_MODULE || 'cost_purge_end'
933: , 'returned from cost purge API with status '
934: || x_return_status
935: );
949:
950:
951: IF x_return_status = FND_API.G_RET_STS_SUCCESS
952: THEN
953: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
954: THEN
955: fnd_log.string
956: (
957: fnd_log.level_statement
951: IF x_return_status = FND_API.G_RET_STS_SUCCESS
952: THEN
953: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
954: THEN
955: fnd_log.string
956: (
957: fnd_log.level_statement
958: , L_LOG_MODULE || 'messages_purge_start'
959: , 'calling the Messages purge API cs_messages_pkg.delete_message'
953: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
954: THEN
955: fnd_log.string
956: (
957: fnd_log.level_statement
958: , L_LOG_MODULE || 'messages_purge_start'
959: , 'calling the Messages purge API cs_messages_pkg.delete_message'
960: );
961: END IF ;
974: , x_msg_count => x_msg_count
975: , x_msg_data => x_msg_data
976: );
977:
978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
979: THEN
980: fnd_log.string
981: (
982: fnd_log.level_statement
976: );
977:
978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
979: THEN
980: fnd_log.string
981: (
982: fnd_log.level_statement
983: , L_LOG_MODULE || 'messages_purge_end'
984: , 'returned from Messages purge API with status '
978: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
979: THEN
980: fnd_log.string
981: (
982: fnd_log.level_statement
983: , L_LOG_MODULE || 'messages_purge_end'
984: , 'returned from Messages purge API with status '
985: || x_return_status
986: );
994: ---
995:
996: IF x_return_status = FND_API.G_RET_STS_SUCCESS
997: THEN
998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
999: THEN
1000: fnd_log.string
1001: (
1002: fnd_log.level_statement
996: IF x_return_status = FND_API.G_RET_STS_SUCCESS
997: THEN
998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
999: THEN
1000: fnd_log.string
1001: (
1002: fnd_log.level_statement
1003: , L_LOG_MODULE || 'contacts_purge_start'
1004: , 'calling the Contacts purge API '
998: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
999: THEN
1000: fnd_log.string
1001: (
1002: fnd_log.level_statement
1003: , L_LOG_MODULE || 'contacts_purge_start'
1004: , 'calling the Contacts purge API '
1005: || 'cs_sr_delete_util.delete_contacts'
1006: );
1022: , x_msg_count => x_msg_count
1023: , x_msg_data => x_msg_data
1024: );
1025:
1026: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1027: THEN
1028: fnd_log.string
1029: (
1030: fnd_log.level_statement
1024: );
1025:
1026: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1027: THEN
1028: fnd_log.string
1029: (
1030: fnd_log.level_statement
1031: , L_LOG_MODULE || 'contacts_purge_end'
1032: , 'returned from Contacts purge API with status '
1026: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1027: THEN
1028: fnd_log.string
1029: (
1030: fnd_log.level_statement
1031: , L_LOG_MODULE || 'contacts_purge_end'
1032: , 'returned from Contacts purge API with status '
1033: || x_return_status
1034: );
1042: ---
1043:
1044: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1045: THEN
1046: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1047: THEN
1048: fnd_log.string
1049: (
1050: fnd_log.level_statement
1044: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1045: THEN
1046: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1047: THEN
1048: fnd_log.string
1049: (
1050: fnd_log.level_statement
1051: , L_LOG_MODULE || 'sr_attr_purge_start'
1052: , 'calling the SR Extended Attribs purge API '
1046: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1047: THEN
1048: fnd_log.string
1049: (
1050: fnd_log.level_statement
1051: , L_LOG_MODULE || 'sr_attr_purge_start'
1052: , 'calling the SR Extended Attribs purge API '
1053: || 'cs_sr_delete_util.delete_sr_attributes'
1054: );
1069: , x_msg_count => x_msg_count
1070: , x_msg_data => x_msg_data
1071: );
1072:
1073: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1074: THEN
1075: fnd_log.string
1076: (
1077: fnd_log.level_statement
1071: );
1072:
1073: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1074: THEN
1075: fnd_log.string
1076: (
1077: fnd_log.level_statement
1078: , L_LOG_MODULE || 'sr_attr_purge_end'
1079: , 'returned from SR Extended Attribs purge API with status '
1073: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1074: THEN
1075: fnd_log.string
1076: (
1077: fnd_log.level_statement
1078: , L_LOG_MODULE || 'sr_attr_purge_end'
1079: , 'returned from SR Extended Attribs purge API with status '
1080: || x_return_status
1081: );
1089: ---
1090:
1091: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1092: THEN
1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string
1096: (
1097: fnd_log.level_statement
1091: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1092: THEN
1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string
1096: (
1097: fnd_log.level_statement
1098: , L_LOG_MODULE || 'sr_audit_purge_start'
1099: , 'calling the SR Audit purge API '
1093: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1094: THEN
1095: fnd_log.string
1096: (
1097: fnd_log.level_statement
1098: , L_LOG_MODULE || 'sr_audit_purge_start'
1099: , 'calling the SR Audit purge API '
1100: || 'cs_sr_delete_util.delete_audit_records'
1101: );
1115: , x_msg_count => x_msg_count
1116: , x_msg_data => x_msg_data
1117: );
1118:
1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1120: THEN
1121: fnd_log.string
1122: (
1123: fnd_log.level_statement
1117: );
1118:
1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1120: THEN
1121: fnd_log.string
1122: (
1123: fnd_log.level_statement
1124: , L_LOG_MODULE || 'sr_audit_purge_end'
1125: , 'returned from SR Audit purge API with status '
1119: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1120: THEN
1121: fnd_log.string
1122: (
1123: fnd_log.level_statement
1124: , L_LOG_MODULE || 'sr_audit_purge_end'
1125: , 'returned from SR Audit purge API with status '
1126: || x_return_status
1127: );
1135: ---
1136:
1137: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1138: THEN
1139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1140: THEN
1141: fnd_log.string
1142: (
1143: fnd_log.level_statement
1137: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1138: THEN
1139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1140: THEN
1141: fnd_log.string
1142: (
1143: fnd_log.level_statement
1144: , L_LOG_MODULE || 'sr_link_purge_start'
1145: , 'calling the SR Links purge API '
1139: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1140: THEN
1141: fnd_log.string
1142: (
1143: fnd_log.level_statement
1144: , L_LOG_MODULE || 'sr_link_purge_start'
1145: , 'calling the SR Links purge API '
1146: || 'cs_incidentlinks_pvt.delete_incidentlink'
1147: );
1161: , x_msg_count => x_msg_count
1162: , x_msg_data => x_msg_data
1163: );
1164:
1165: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1166: THEN
1167: fnd_log.string
1168: (
1169: fnd_log.level_statement
1163: );
1164:
1165: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1166: THEN
1167: fnd_log.string
1168: (
1169: fnd_log.level_statement
1170: , L_LOG_MODULE || 'sr_link_purge_end'
1171: , 'returned from SR Links purge API with status '
1165: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1166: THEN
1167: fnd_log.string
1168: (
1169: fnd_log.level_statement
1170: , L_LOG_MODULE || 'sr_link_purge_end'
1171: , 'returned from SR Links purge API with status '
1172: || x_return_status
1173: );
1181: ---
1182:
1183: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1184: THEN
1185: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1186: THEN
1187: fnd_log.string
1188: (
1189: fnd_log.level_statement
1183: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1184: THEN
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 || 'km_link_purge_start'
1191: , 'calling the KM Links purge API '
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 || 'km_link_purge_start'
1191: , 'calling the KM Links purge API '
1192: || 'cs_knowledge_grp.purge_knowledge_links'
1193: );
1207: , x_msg_count => x_msg_count
1208: , x_msg_data => x_msg_data
1209: );
1210:
1211: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1212: THEN
1213: fnd_log.string
1214: (
1215: fnd_log.level_statement
1209: );
1210:
1211: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1212: THEN
1213: fnd_log.string
1214: (
1215: fnd_log.level_statement
1216: , L_LOG_MODULE || 'km_link_purge_end'
1217: , 'returned from KM Links purge API with status '
1211: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1212: THEN
1213: fnd_log.string
1214: (
1215: fnd_log.level_statement
1216: , L_LOG_MODULE || 'km_link_purge_end'
1217: , 'returned from KM Links purge API with status '
1218: || x_return_status
1219: );
1227: ---
1228:
1229: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1230: THEN
1231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1232: THEN
1233: fnd_log.string
1234: (
1235: fnd_log.level_statement
1229: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1230: THEN
1231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1232: THEN
1233: fnd_log.string
1234: (
1235: fnd_log.level_statement
1236: , L_LOG_MODULE || 'notes_purge_start'
1237: , 'calling the Notes purge API cac_note_purge_pub.purge_notes'
1231: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1232: THEN
1233: fnd_log.string
1234: (
1235: fnd_log.level_statement
1236: , L_LOG_MODULE || 'notes_purge_start'
1237: , 'calling the Notes purge API cac_note_purge_pub.purge_notes'
1238: );
1239: END IF ;
1252: , x_msg_count => x_msg_count
1253: , x_msg_data => x_msg_data
1254: );
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
1254: );
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 || 'notes_purge_end'
1262: , 'returned from Notes purge API with status ' || x_return_status
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 || 'notes_purge_end'
1262: , 'returned from Notes purge API with status ' || x_return_status
1263: );
1264: END IF ;
1271: ---
1272:
1273: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1274: THEN
1275: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1276: THEN
1277: fnd_log.string
1278: (
1279: fnd_log.level_statement
1273: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1274: THEN
1275: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1276: THEN
1277: fnd_log.string
1278: (
1279: fnd_log.level_statement
1280: , L_LOG_MODULE || 'task_purge_start'
1281: , 'calling the Tasks purge API cac_task_purge_pub.purge_task'
1275: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1276: THEN
1277: fnd_log.string
1278: (
1279: fnd_log.level_statement
1280: , L_LOG_MODULE || 'task_purge_start'
1281: , 'calling the Tasks purge API cac_task_purge_pub.purge_task'
1282: );
1283: END IF ;
1296: , x_msg_count => x_msg_count
1297: , x_msg_data => x_msg_data
1298: );
1299:
1300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1301: THEN
1302: fnd_log.string
1303: (
1304: fnd_log.level_statement
1298: );
1299:
1300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1301: THEN
1302: fnd_log.string
1303: (
1304: fnd_log.level_statement
1305: , L_LOG_MODULE || 'task_purge_end'
1306: , 'returned from Tasks purge API with status ' || x_return_status
1300: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1301: THEN
1302: fnd_log.string
1303: (
1304: fnd_log.level_statement
1305: , L_LOG_MODULE || 'task_purge_end'
1306: , 'returned from Tasks purge API with status ' || x_return_status
1307: );
1308: END IF ;
1315: ---
1316:
1317: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1318: THEN
1319: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1320: THEN
1321: fnd_log.string
1322: (
1323: fnd_log.level_statement
1317: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1318: THEN
1319: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1320: THEN
1321: fnd_log.string
1322: (
1323: fnd_log.level_statement
1324: , L_LOG_MODULE || 'work_item_purge_start'
1325: , 'calling the UWQ Work Items purge API ieu_wr_pub.purge_wr_item'
1319: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1320: THEN
1321: fnd_log.string
1322: (
1323: fnd_log.level_statement
1324: , L_LOG_MODULE || 'work_item_purge_start'
1325: , 'calling the UWQ Work Items purge API ieu_wr_pub.purge_wr_item'
1326: );
1327: END IF ;
1340: , x_msg_count => x_msg_count
1341: , x_msg_data => x_msg_data
1342: );
1343:
1344: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1345: THEN
1346: fnd_log.string
1347: (
1348: fnd_log.level_statement
1342: );
1343:
1344: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1345: THEN
1346: fnd_log.string
1347: (
1348: fnd_log.level_statement
1349: , L_LOG_MODULE || 'work_item_purge_end'
1350: , 'returned from UWQ Work Items purge API with status '
1344: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1345: THEN
1346: fnd_log.string
1347: (
1348: fnd_log.level_statement
1349: , L_LOG_MODULE || 'work_item_purge_end'
1350: , 'returned from UWQ Work Items purge API with status '
1351: || x_return_status
1352: );
1360: ---
1361:
1362: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1363: THEN
1364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1365: THEN
1366: fnd_log.string
1367: (
1368: fnd_log.level_statement
1362: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1363: THEN
1364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1365: THEN
1366: fnd_log.string
1367: (
1368: fnd_log.level_statement
1369: , L_LOG_MODULE || 'interaction_purge_start'
1370: , 'calling the Interactions purge API '
1364: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1365: THEN
1366: fnd_log.string
1367: (
1368: fnd_log.level_statement
1369: , L_LOG_MODULE || 'interaction_purge_start'
1370: , 'calling the Interactions purge API '
1371: || 'jtf_ih_purge.p_delete_interactions'
1372: );
1386: , x_msg_count => x_msg_count
1387: , x_msg_data => x_msg_data
1388: );
1389:
1390: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1391: THEN
1392: fnd_log.string
1393: (
1394: fnd_log.level_statement
1388: );
1389:
1390: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1391: THEN
1392: fnd_log.string
1393: (
1394: fnd_log.level_statement
1395: , L_LOG_MODULE || 'interaction_purge_end'
1396: , 'returned from Interactions purge API with status '
1390: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1391: THEN
1392: fnd_log.string
1393: (
1394: fnd_log.level_statement
1395: , L_LOG_MODULE || 'interaction_purge_end'
1396: , 'returned from Interactions purge API with status '
1397: || x_return_status
1398: );
1406: ---
1407:
1408: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1409: THEN
1410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1411: THEN
1412: fnd_log.string
1413: (
1414: fnd_log.level_statement
1408: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1409: THEN
1410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1411: THEN
1412: fnd_log.string
1413: (
1414: fnd_log.level_statement
1415: , L_LOG_MODULE || 'get_srid_for_attach_del_start'
1416: , 'Collecting all the Incident_ids into a pl/sql table to '
1410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1411: THEN
1412: fnd_log.string
1413: (
1414: fnd_log.level_statement
1415: , L_LOG_MODULE || 'get_srid_for_attach_del_start'
1416: , 'Collecting all the Incident_ids into a pl/sql table to '
1417: || 'delete attachments, one at a time'
1418: );
1434: AND NVL(purge_status, 'S') = 'S';
1435:
1436: l_row_count := SQL%ROWCOUNT;
1437:
1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1439: THEN
1440: fnd_log.string
1441: (
1442: fnd_log.level_statement
1436: l_row_count := SQL%ROWCOUNT;
1437:
1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1439: THEN
1440: fnd_log.string
1441: (
1442: fnd_log.level_statement
1443: , L_LOG_MODULE || 'get_srid_for_attach_del_end'
1444: , 'After collecting all the Incident_ids into a pl/sql table '
1438: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1439: THEN
1440: fnd_log.string
1441: (
1442: fnd_log.level_statement
1443: , L_LOG_MODULE || 'get_srid_for_attach_del_end'
1444: , 'After collecting all the Incident_ids into a pl/sql table '
1445: || l_row_count || ' rows'
1446: );
1456: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1457: THEN
1458: IF l_incident_id_tbl.COUNT > 0
1459: THEN
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1461: THEN
1462: fnd_log.string
1463: (
1464: fnd_log.level_statement
1458: IF l_incident_id_tbl.COUNT > 0
1459: THEN
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1461: THEN
1462: fnd_log.string
1463: (
1464: fnd_log.level_statement
1465: , L_LOG_MODULE || 'attachment_purge_start'
1466: , 'calling the Attachments purge API '
1460: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1461: THEN
1462: fnd_log.string
1463: (
1464: fnd_log.level_statement
1465: , L_LOG_MODULE || 'attachment_purge_start'
1466: , 'calling the Attachments purge API '
1467: || 'fnd_attached_documents2_pkg.delete_attachments'
1468: );
1486: , x_automatically_added_flag => null
1487: );
1488: END LOOP;
1489:
1490: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1491: THEN
1492: fnd_log.string
1493: (
1494: fnd_log.level_statement
1488: END LOOP;
1489:
1490: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1491: THEN
1492: fnd_log.string
1493: (
1494: fnd_log.level_statement
1495: , L_LOG_MODULE || 'attachment_purge_end'
1496: , 'returned from Attachments purge API with status '
1490: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1491: THEN
1492: fnd_log.string
1493: (
1494: fnd_log.level_statement
1495: , L_LOG_MODULE || 'attachment_purge_end'
1496: , 'returned from Attachments purge API with status '
1497: || x_return_status
1498: );
1498: );
1499: END IF ;
1500: ELSIF l_incident_id_tbl.COUNT <= 0
1501: THEN
1502: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1503: THEN
1504: fnd_log.string
1505: (
1506: fnd_log.level_statement
1500: ELSIF l_incident_id_tbl.COUNT <= 0
1501: THEN
1502: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1503: THEN
1504: fnd_log.string
1505: (
1506: fnd_log.level_statement
1507: , L_LOG_MODULE || 'attachment_purge_err'
1508: , 'while calling Attachments purge API l_incident_id_tbl has '
1502: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1503: THEN
1504: fnd_log.string
1505: (
1506: fnd_log.level_statement
1507: , L_LOG_MODULE || 'attachment_purge_err'
1508: , 'while calling Attachments purge API l_incident_id_tbl has '
1509: || l_incident_id_tbl.COUNT || ' rows'
1510: );
1524: -- If audit information is required as per profile option
1525: -- CS_SR_PURGE_AUDIT_REQUIRED, then proceed further
1526:
1527: THEN
1528: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1529: THEN
1530: fnd_log.string
1531: (
1532: fnd_log.level_statement
1526:
1527: THEN
1528: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1529: THEN
1530: fnd_log.string
1531: (
1532: fnd_log.level_statement
1533: , L_LOG_MODULE || 'get_srbinfo_for_audit_start'
1534: , 'Collecting information that has to be written to the '
1528: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1529: THEN
1530: fnd_log.string
1531: (
1532: fnd_log.level_statement
1533: , L_LOG_MODULE || 'get_srbinfo_for_audit_start'
1534: , 'Collecting information that has to be written to the '
1535: || 'CS_INCIDENTS_PURGE_AUDIT_B table'
1536: );
1571: AND j.processing_set_id = p_processing_set_id;
1572:
1573: l_row_count := SQL%ROWCOUNT;
1574:
1575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1576: THEN
1577: fnd_log.string
1578: (
1579: fnd_log.level_statement
1573: l_row_count := SQL%ROWCOUNT;
1574:
1575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1576: THEN
1577: fnd_log.string
1578: (
1579: fnd_log.level_statement
1580: , L_LOG_MODULE || 'get_srbinfo_for_audit_end'
1581: , 'After collecting information that has to be written to the '
1575: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1576: THEN
1577: fnd_log.string
1578: (
1579: fnd_log.level_statement
1580: , L_LOG_MODULE || 'get_srbinfo_for_audit_end'
1581: , 'After collecting information that has to be written to the '
1582: || 'CS_INCIDENTS_PURGE_AUDIT_B table ' || l_row_count || ' rows'
1583: );
1584: END IF ;
1585:
1586: ---
1587:
1588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1589: THEN
1590: fnd_log.string
1591: (
1592: fnd_log.level_statement
1586: ---
1587:
1588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1589: THEN
1590: fnd_log.string
1591: (
1592: fnd_log.level_statement
1593: , L_LOG_MODULE || 'get_srtlinfo_for_audit_start'
1594: , 'Collecting information that has to be written to the '
1588: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1589: THEN
1590: fnd_log.string
1591: (
1592: fnd_log.level_statement
1593: , L_LOG_MODULE || 'get_srtlinfo_for_audit_start'
1594: , 'Collecting information that has to be written to the '
1595: || 'CS_INCIDENTS_PURGE_AUDIT_TL table'
1596: );
1623: AND j.processing_set_id = p_processing_set_id;
1624:
1625: l_row_count := SQL%ROWCOUNT;
1626:
1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1628: THEN
1629: fnd_log.string
1630: (
1631: fnd_log.level_statement
1625: l_row_count := SQL%ROWCOUNT;
1626:
1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1628: THEN
1629: fnd_log.string
1630: (
1631: fnd_log.level_statement
1632: , L_LOG_MODULE || 'get_srtlinfo_for_audit_end'
1633: , 'After collecting information that has to be written to the '
1627: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1628: THEN
1629: fnd_log.string
1630: (
1631: fnd_log.level_statement
1632: , L_LOG_MODULE || 'get_srtlinfo_for_audit_end'
1633: , 'After collecting information that has to be written to the '
1634: || 'CS_INCIDENTS_PURGE_AUDIT_TL table ' || l_row_count || ' rows'
1635: );
1635: );
1636: END IF ;
1637: ELSIF p_audit_required <> 'Y'
1638: THEN
1639: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1640: THEN
1641: fnd_log.string
1642: (
1643: fnd_log.level_statement
1637: ELSIF p_audit_required <> 'Y'
1638: THEN
1639: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1640: THEN
1641: fnd_log.string
1642: (
1643: fnd_log.level_statement
1644: , L_LOG_MODULE || 'purge_audit_not_reqd'
1645: , 'Not collecting audit information since p_audit_required is '
1639: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1640: THEN
1641: fnd_log.string
1642: (
1643: fnd_log.level_statement
1644: , L_LOG_MODULE || 'purge_audit_not_reqd'
1645: , 'Not collecting audit information since p_audit_required is '
1646: || p_audit_required || '. Would be done if Y.'
1647: );
1655: ---
1656:
1657: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1658: THEN
1659: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1660: THEN
1661: fnd_log.string
1662: (
1663: fnd_log.level_statement
1657: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1658: THEN
1659: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1660: THEN
1661: fnd_log.string
1662: (
1663: fnd_log.level_statement
1664: , L_LOG_MODULE || 'get_data_for_staging_start'
1665: , 'Collecting information that has to be written to the '
1659: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1660: THEN
1661: fnd_log.string
1662: (
1663: fnd_log.level_statement
1664: , L_LOG_MODULE || 'get_data_for_staging_start'
1665: , 'Collecting information that has to be written to the '
1666: || 'CS_INCIDENTS_PURGE_STAGING table'
1667: );
1690: AND j.processing_set_id = p_processing_set_id;
1691:
1692: l_row_count := SQL%ROWCOUNT;
1693:
1694: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1695: THEN
1696: fnd_log.string
1697: (
1698: fnd_log.level_statement
1692: l_row_count := SQL%ROWCOUNT;
1693:
1694: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1695: THEN
1696: fnd_log.string
1697: (
1698: fnd_log.level_statement
1699: , L_LOG_MODULE || 'get_data_for_staging_end'
1700: , 'After collecting information that has to be written to the '
1694: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1695: THEN
1696: fnd_log.string
1697: (
1698: fnd_log.level_statement
1699: , L_LOG_MODULE || 'get_data_for_staging_end'
1700: , 'After collecting information that has to be written to the '
1701: || 'CS_INCIDENTS_PURGE_STAGING table ' || l_row_count || ' rows'
1702: );
1710: ---
1711:
1712: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1713: THEN
1714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1715: THEN
1716: fnd_log.string
1717: (
1718: fnd_log.level_statement
1712: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1713: THEN
1714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1715: THEN
1716: fnd_log.string
1717: (
1718: fnd_log.level_statement
1719: , L_LOG_MODULE || 'del_srtl_start'
1720: , 'Deleting rows from table CS_INCIDENTS_ALL_TL'
1714: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1715: THEN
1716: fnd_log.string
1717: (
1718: fnd_log.level_statement
1719: , L_LOG_MODULE || 'del_srtl_start'
1720: , 'Deleting rows from table CS_INCIDENTS_ALL_TL'
1721: );
1722: END IF ;
1744: );
1745:
1746: l_row_count := SQL%ROWCOUNT;
1747:
1748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1749: THEN
1750: fnd_log.string
1751: (
1752: fnd_log.level_statement
1746: l_row_count := SQL%ROWCOUNT;
1747:
1748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1749: THEN
1750: fnd_log.string
1751: (
1752: fnd_log.level_statement
1753: , L_LOG_MODULE || 'del_srtl_end'
1754: , 'After deleting rows from table CS_INCIDENTS_ALL_TL ' || l_row_count
1748: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1749: THEN
1750: fnd_log.string
1751: (
1752: fnd_log.level_statement
1753: , L_LOG_MODULE || 'del_srtl_end'
1754: , 'After deleting rows from table CS_INCIDENTS_ALL_TL ' || l_row_count
1755: || ' rows'
1756: );
1764: ---
1765:
1766: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1767: THEN
1768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1769: THEN
1770: fnd_log.string
1771: (
1772: fnd_log.level_statement
1766: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1767: THEN
1768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1769: THEN
1770: fnd_log.string
1771: (
1772: fnd_log.level_statement
1773: , L_LOG_MODULE || 'del_srb_start'
1774: , 'Deleting rows from table CS_INCIDENTS_ALL_B'
1768: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1769: THEN
1770: fnd_log.string
1771: (
1772: fnd_log.level_statement
1773: , L_LOG_MODULE || 'del_srb_start'
1774: , 'Deleting rows from table CS_INCIDENTS_ALL_B'
1775: );
1776: END IF ;
1798: );
1799:
1800: l_row_count := SQL%ROWCOUNT;
1801:
1802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1803: THEN
1804: fnd_log.string
1805: (
1806: fnd_log.level_statement
1800: l_row_count := SQL%ROWCOUNT;
1801:
1802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1803: THEN
1804: fnd_log.string
1805: (
1806: fnd_log.level_statement
1807: , L_LOG_MODULE || 'del_srb_end'
1808: , 'After deleting rows from table CS_INCIDENTS_ALL_B ' || l_row_count
1802: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1803: THEN
1804: fnd_log.string
1805: (
1806: fnd_log.level_statement
1807: , L_LOG_MODULE || 'del_srb_end'
1808: , 'After deleting rows from table CS_INCIDENTS_ALL_B ' || l_row_count
1809: || ' rows'
1810: );
1826: -- updated back to the Staging Table to facilitate
1827: -- generation of concurrent request output file.
1828:
1829: THEN
1830: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1831: THEN
1832: fnd_log.string
1833: (
1834: fnd_log.level_statement
1828:
1829: THEN
1830: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1831: THEN
1832: fnd_log.string
1833: (
1834: fnd_log.level_statement
1835: , L_LOG_MODULE || 'write_staging_start'
1836: , 'Updating purge status into table CS_INCIDENTS_PURGE_STAGING'
1830: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1831: THEN
1832: fnd_log.string
1833: (
1834: fnd_log.level_statement
1835: , L_LOG_MODULE || 'write_staging_start'
1836: , 'Updating purge status into table CS_INCIDENTS_PURGE_STAGING'
1837: );
1838: END IF ;
1849: incident_id = l_incident_id_status_tbl(j);
1850:
1851: l_row_count := SQL%ROWCOUNT;
1852:
1853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1854: THEN
1855: fnd_log.string
1856: (
1857: fnd_log.level_statement
1851: l_row_count := SQL%ROWCOUNT;
1852:
1853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1854: THEN
1855: fnd_log.string
1856: (
1857: fnd_log.level_statement
1858: , L_LOG_MODULE || 'write_staging_end'
1859: , 'After updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1853: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1854: THEN
1855: fnd_log.string
1856: (
1857: fnd_log.level_statement
1858: , L_LOG_MODULE || 'write_staging_end'
1859: , 'After updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1860: || l_row_count || ' rows'
1861: );
1861: );
1862: END IF ;
1863: ELSIF l_incident_id_status_tbl.COUNT <= 0
1864: THEN
1865: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1866: THEN
1867: fnd_log.string
1868: (
1869: fnd_log.level_statement
1863: ELSIF l_incident_id_status_tbl.COUNT <= 0
1864: THEN
1865: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1866: THEN
1867: fnd_log.string
1868: (
1869: fnd_log.level_statement
1870: , L_LOG_MODULE || 'write_staging_norows'
1871: , 'While updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1865: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1866: THEN
1867: fnd_log.string
1868: (
1869: fnd_log.level_statement
1870: , L_LOG_MODULE || 'write_staging_norows'
1871: , 'While updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1872: || 'l_incident_id_status_tbl had ' || l_incident_id_status_tbl.COUNT
1873: || ' rows'
1883: ---
1884:
1885: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1886: THEN
1887: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1888: THEN
1889: fnd_log.string
1890: (
1891: fnd_log.level_statement
1885: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1886: THEN
1887: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1888: THEN
1889: fnd_log.string
1890: (
1891: fnd_log.level_statement
1892: , L_LOG_MODULE || 'write_staging_success_start'
1893: , 'Updating rows processed successfully with purge status = S'
1887: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1888: THEN
1889: fnd_log.string
1890: (
1891: fnd_log.level_statement
1892: , L_LOG_MODULE || 'write_staging_success_start'
1893: , 'Updating rows processed successfully with purge status = S'
1894: );
1895: END IF ;
1920: AND j.processing_set_id = p_processing_set_id
1921: );
1922: l_row_count := SQL%ROWCOUNT;
1923:
1924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1925: THEN
1926: fnd_log.string
1927: (
1928: fnd_log.level_statement
1922: l_row_count := SQL%ROWCOUNT;
1923:
1924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1925: THEN
1926: fnd_log.string
1927: (
1928: fnd_log.level_statement
1929: , L_LOG_MODULE || 'write_staging_success_end'
1930: , 'After updating rows processed successfully with '
1924: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1925: THEN
1926: fnd_log.string
1927: (
1928: fnd_log.level_statement
1929: , L_LOG_MODULE || 'write_staging_success_end'
1930: , 'After updating rows processed successfully with '
1931: || 'purge status = S ' || l_row_count
1932: );
1945: -- If audit information is required as per profile option
1946: -- CS_SR_PURGE_AUDIT_REQUIRED, then proceed further
1947:
1948: THEN
1949: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1950: THEN
1951: fnd_log.string
1952: (
1953: fnd_log.level_statement
1947:
1948: THEN
1949: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1950: THEN
1951: fnd_log.string
1952: (
1953: fnd_log.level_statement
1954: , L_LOG_MODULE || 'purge_audit_create_start'
1955: , 'Calling the procedure CREATE_PURGEAUDIT_RECORDS to create purge '
1949: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1950: THEN
1951: fnd_log.string
1952: (
1953: fnd_log.level_statement
1954: , L_LOG_MODULE || 'purge_audit_create_start'
1955: , 'Calling the procedure CREATE_PURGEAUDIT_RECORDS to create purge '
1956: || 'audit information'
1957: );
1986: , x_msg_count => x_msg_count
1987: , x_msg_data => x_msg_data
1988: );
1989:
1990: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1991: THEN
1992: fnd_log.string
1993: (
1994: fnd_log.level_statement
1988: );
1989:
1990: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1991: THEN
1992: fnd_log.string
1993: (
1994: fnd_log.level_statement
1995: , L_LOG_MODULE || 'purge_audit_create_end'
1996: , 'After calling the procedure CREATE_PURGEAUDIT_RECORDS. '
1990: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1991: THEN
1992: fnd_log.string
1993: (
1994: fnd_log.level_statement
1995: , L_LOG_MODULE || 'purge_audit_create_end'
1996: , 'After calling the procedure CREATE_PURGEAUDIT_RECORDS. '
1997: || 'Returned with status ' || x_return_status
1998: );
2004: Check_User_Termination;
2005:
2006: ---
2007:
2008: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2009: THEN
2010: fnd_log.string
2011: (
2012: fnd_log.level_procedure
2006: ---
2007:
2008: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2009: THEN
2010: fnd_log.string
2011: (
2012: fnd_log.level_procedure
2013: , L_LOG_MODULE || 'end'
2014: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2008: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2009: THEN
2010: fnd_log.string
2011: (
2012: fnd_log.level_procedure
2013: , L_LOG_MODULE || 'end'
2014: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2015: || x_return_status
2016: );
2020:
2021: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2025: THEN
2026: fnd_log.string
2027: (
2028: fnd_log.level_unexpected
2022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2025: THEN
2026: fnd_log.string
2027: (
2028: fnd_log.level_unexpected
2029: , L_LOG_MODULE || 'unexpected_error'
2030: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2024: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2025: THEN
2026: fnd_log.string
2027: (
2028: fnd_log.level_unexpected
2029: , L_LOG_MODULE || 'unexpected_error'
2030: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2031: );
2032:
2043: , p_encoded => 'F'
2044: , p_data => x_msg_data
2045: , p_msg_index_out => x_msg_index_out
2046: );
2047: fnd_log.string
2048: (
2049: fnd_log.level_unexpected
2050: , L_LOG_MODULE || 'unexpected_error'
2051: , 'Error encountered is : ' || x_msg_data || ' [Index:'
2045: , p_msg_index_out => x_msg_index_out
2046: );
2047: fnd_log.string
2048: (
2049: fnd_log.level_unexpected
2050: , L_LOG_MODULE || 'unexpected_error'
2051: , 'Error encountered is : ' || x_msg_data || ' [Index:'
2052: || x_msg_index_out || ']'
2053: );
2061: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2062: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2063: FND_MSG_PUB.ADD;
2064:
2065: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2066: THEN
2067: fnd_log.string
2068: (
2069: fnd_log.level_unexpected
2063: FND_MSG_PUB.ADD;
2064:
2065: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2066: THEN
2067: fnd_log.string
2068: (
2069: fnd_log.level_unexpected
2070: , L_LOG_MODULE || 'when_others'
2071: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2065: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2066: THEN
2067: fnd_log.string
2068: (
2069: fnd_log.level_unexpected
2070: , L_LOG_MODULE || 'when_others'
2071: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2072: );
2073: fnd_log.string
2069: fnd_log.level_unexpected
2070: , L_LOG_MODULE || 'when_others'
2071: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2072: );
2073: fnd_log.string
2074: (
2075: fnd_log.level_unexpected
2076: , L_LOG_MODULE || 'when_others'
2077: , SQLERRM
2071: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2072: );
2073: fnd_log.string
2074: (
2075: fnd_log.level_unexpected
2076: , L_LOG_MODULE || 'when_others'
2077: , SQLERRM
2078: );
2079: END IF ;
2139:
2140: BEGIN
2141: x_return_status := FND_API.G_RET_STS_SUCCESS;
2142:
2143: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2144: THEN
2145: fnd_log.string
2146: (
2147: fnd_log.level_procedure
2141: x_return_status := FND_API.G_RET_STS_SUCCESS;
2142:
2143: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2144: THEN
2145: fnd_log.string
2146: (
2147: fnd_log.level_procedure
2148: , L_LOG_MODULE || 'start'
2149: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2143: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2144: THEN
2145: fnd_log.string
2146: (
2147: fnd_log.level_procedure
2148: , L_LOG_MODULE || 'start'
2149: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2150: );
2151: fnd_log.string
2147: fnd_log.level_procedure
2148: , L_LOG_MODULE || 'start'
2149: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2150: );
2151: fnd_log.string
2152: (
2153: fnd_log.level_procedure
2154: , L_LOG_MODULE || 'param 1'
2155: , 'p_api_version_number:' || p_api_version_number
2149: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2150: );
2151: fnd_log.string
2152: (
2153: fnd_log.level_procedure
2154: , L_LOG_MODULE || 'param 1'
2155: , 'p_api_version_number:' || p_api_version_number
2156: );
2157: fnd_log.string
2153: fnd_log.level_procedure
2154: , L_LOG_MODULE || 'param 1'
2155: , 'p_api_version_number:' || p_api_version_number
2156: );
2157: fnd_log.string
2158: (
2159: fnd_log.level_procedure
2160: , L_LOG_MODULE || 'param 2'
2161: , 'p_init_msg_list:' || p_init_msg_list
2155: , 'p_api_version_number:' || p_api_version_number
2156: );
2157: fnd_log.string
2158: (
2159: fnd_log.level_procedure
2160: , L_LOG_MODULE || 'param 2'
2161: , 'p_init_msg_list:' || p_init_msg_list
2162: );
2163: fnd_log.string
2159: fnd_log.level_procedure
2160: , L_LOG_MODULE || 'param 2'
2161: , 'p_init_msg_list:' || p_init_msg_list
2162: );
2163: fnd_log.string
2164: (
2165: fnd_log.level_procedure
2166: , L_LOG_MODULE || 'param 3'
2167: , 'p_commit:' || p_commit
2161: , 'p_init_msg_list:' || p_init_msg_list
2162: );
2163: fnd_log.string
2164: (
2165: fnd_log.level_procedure
2166: , L_LOG_MODULE || 'param 3'
2167: , 'p_commit:' || p_commit
2168: );
2169: fnd_log.string
2165: fnd_log.level_procedure
2166: , L_LOG_MODULE || 'param 3'
2167: , 'p_commit:' || p_commit
2168: );
2169: fnd_log.string
2170: (
2171: fnd_log.level_procedure
2172: , L_LOG_MODULE || 'param 4'
2173: , 'p_object_type:' || p_object_type
2167: , 'p_commit:' || p_commit
2168: );
2169: fnd_log.string
2170: (
2171: fnd_log.level_procedure
2172: , L_LOG_MODULE || 'param 4'
2173: , 'p_object_type:' || p_object_type
2174: );
2175: fnd_log.string
2171: fnd_log.level_procedure
2172: , L_LOG_MODULE || 'param 4'
2173: , 'p_object_type:' || p_object_type
2174: );
2175: fnd_log.string
2176: (
2177: fnd_log.level_procedure
2178: , L_LOG_MODULE || 'param 5'
2179: , 'p_processing_set_id:' || p_processing_set_id
2173: , 'p_object_type:' || p_object_type
2174: );
2175: fnd_log.string
2176: (
2177: fnd_log.level_procedure
2178: , L_LOG_MODULE || 'param 5'
2179: , 'p_processing_set_id:' || p_processing_set_id
2180: );
2181: END IF ;
2205: ------------------------------------------------------------------------------
2206: -- Actual Logic starts below:
2207: ------------------------------------------------------------------------------
2208:
2209: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2210: THEN
2211: fnd_log.string
2212: (
2213: fnd_log.level_statement
2207: ------------------------------------------------------------------------------
2208:
2209: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2210: THEN
2211: fnd_log.string
2212: (
2213: fnd_log.level_statement
2214: , L_LOG_MODULE || 'del_cont_ext_aud_start'
2215: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'
2209: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2210: THEN
2211: fnd_log.string
2212: (
2213: fnd_log.level_statement
2214: , L_LOG_MODULE || 'del_cont_ext_aud_start'
2215: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'
2216: );
2217: END IF ;
2239: );
2240:
2241: l_row_count := SQL%ROWCOUNT;
2242:
2243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2244: THEN
2245: fnd_log.string
2246: (
2247: fnd_log.level_statement
2241: l_row_count := SQL%ROWCOUNT;
2242:
2243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2244: THEN
2245: fnd_log.string
2246: (
2247: fnd_log.level_statement
2248: , L_LOG_MODULE || 'del_cont_ext_aud_end'
2249: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '
2243: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2244: THEN
2245: fnd_log.string
2246: (
2247: fnd_log.level_statement
2248: , L_LOG_MODULE || 'del_cont_ext_aud_end'
2249: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '
2250: || l_row_count || ' rows'
2251: );
2252: END IF ;
2253:
2254: ---
2255:
2256: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2257: THEN
2258: fnd_log.string
2259: (
2260: fnd_log.level_statement
2254: ---
2255:
2256: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2257: THEN
2258: fnd_log.string
2259: (
2260: fnd_log.level_statement
2261: , L_LOG_MODULE || 'del_cont_ext_start'
2262: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'
2256: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2257: THEN
2258: fnd_log.string
2259: (
2260: fnd_log.level_statement
2261: , L_LOG_MODULE || 'del_cont_ext_start'
2262: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'
2263: );
2264: END IF ;
2281: );
2282:
2283: l_row_count := SQL%ROWCOUNT;
2284:
2285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2286: THEN
2287: fnd_log.string
2288: (
2289: fnd_log.level_statement
2283: l_row_count := SQL%ROWCOUNT;
2284:
2285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2286: THEN
2287: fnd_log.string
2288: (
2289: fnd_log.level_statement
2290: , L_LOG_MODULE || 'del_cont_ext_end'
2291: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '
2285: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2286: THEN
2287: fnd_log.string
2288: (
2289: fnd_log.level_statement
2290: , L_LOG_MODULE || 'del_cont_ext_end'
2291: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '
2292: || l_row_count || ' rows'
2293: );
2294: END IF ;
2295:
2296: ---
2297:
2298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2299: THEN
2300: fnd_log.string
2301: (
2302: fnd_log.level_statement
2296: ---
2297:
2298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2299: THEN
2300: fnd_log.string
2301: (
2302: fnd_log.level_statement
2303: , L_LOG_MODULE || 'del_cont_ext_start'
2304: , 'Deleting data from table CS_SR_CONTACTS_EXT'
2298: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2299: THEN
2300: fnd_log.string
2301: (
2302: fnd_log.level_statement
2303: , L_LOG_MODULE || 'del_cont_ext_start'
2304: , 'Deleting data from table CS_SR_CONTACTS_EXT'
2305: );
2306: END IF ;
2323: );
2324:
2325: l_row_count := SQL%ROWCOUNT;
2326:
2327: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2328: THEN
2329: fnd_log.string
2330: (
2331: fnd_log.level_statement
2325: l_row_count := SQL%ROWCOUNT;
2326:
2327: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2328: THEN
2329: fnd_log.string
2330: (
2331: fnd_log.level_statement
2332: , L_LOG_MODULE || 'del_cont_ext_end'
2333: , 'After deleting data from table CS_SR_CONTACTS_EXT '
2327: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2328: THEN
2329: fnd_log.string
2330: (
2331: fnd_log.level_statement
2332: , L_LOG_MODULE || 'del_cont_ext_end'
2333: , 'After deleting data from table CS_SR_CONTACTS_EXT '
2334: || l_row_count || ' rows'
2335: );
2336: END IF ;
2337:
2338: ---
2339:
2340: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2341: THEN
2342: fnd_log.string
2343: (
2344: fnd_log.level_statement
2338: ---
2339:
2340: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2341: THEN
2342: fnd_log.string
2343: (
2344: fnd_log.level_statement
2345: , L_LOG_MODULE || 'del_cont_point_aud_start'
2346: , 'Deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT'
2340: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2341: THEN
2342: fnd_log.string
2343: (
2344: fnd_log.level_statement
2345: , L_LOG_MODULE || 'del_cont_point_aud_start'
2346: , 'Deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT'
2347: );
2348: END IF ;
2365: );
2366:
2367: l_row_count := SQL%ROWCOUNT;
2368:
2369: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2370: THEN
2371: fnd_log.string
2372: (
2373: fnd_log.level_statement
2367: l_row_count := SQL%ROWCOUNT;
2368:
2369: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2370: THEN
2371: fnd_log.string
2372: (
2373: fnd_log.level_statement
2374: , L_LOG_MODULE || 'del_cont_point_aud_end'
2375: , 'After deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT '
2369: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2370: THEN
2371: fnd_log.string
2372: (
2373: fnd_log.level_statement
2374: , L_LOG_MODULE || 'del_cont_point_aud_end'
2375: , 'After deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT '
2376: || l_row_count || ' rows'
2377: );
2378: END IF ;
2379:
2380: ---
2381:
2382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2383: THEN
2384: fnd_log.string
2385: (
2386: fnd_log.level_statement
2380: ---
2381:
2382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2383: THEN
2384: fnd_log.string
2385: (
2386: fnd_log.level_statement
2387: , L_LOG_MODULE || 'del_cont_point_start'
2388: , 'Deleting data from table CS_HZ_SR_CONTACT_POINTS'
2382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2383: THEN
2384: fnd_log.string
2385: (
2386: fnd_log.level_statement
2387: , L_LOG_MODULE || 'del_cont_point_start'
2388: , 'Deleting data from table CS_HZ_SR_CONTACT_POINTS'
2389: );
2390: END IF ;
2406: AND NVL(purge_status, 'S') = 'S'
2407: );
2408: l_row_count := SQL%ROWCOUNT;
2409:
2410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2411: THEN
2412: fnd_log.string
2413: (
2414: fnd_log.level_statement
2408: l_row_count := SQL%ROWCOUNT;
2409:
2410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2411: THEN
2412: fnd_log.string
2413: (
2414: fnd_log.level_statement
2415: , L_LOG_MODULE || 'del_cont_point_end'
2416: , 'After deleting data from table CS_HZ_SR_CONTACT_POINTS '
2410: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2411: THEN
2412: fnd_log.string
2413: (
2414: fnd_log.level_statement
2415: , L_LOG_MODULE || 'del_cont_point_end'
2416: , 'After deleting data from table CS_HZ_SR_CONTACT_POINTS '
2417: || l_row_count || ' rows'
2418: );
2419: END IF ;
2420:
2421: ---
2422:
2423: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2424: THEN
2425: fnd_log.string
2426: (
2427: fnd_log.level_procedure
2421: ---
2422:
2423: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2424: THEN
2425: fnd_log.string
2426: (
2427: fnd_log.level_procedure
2428: , L_LOG_MODULE || 'end'
2429: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2423: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2424: THEN
2425: fnd_log.string
2426: (
2427: fnd_log.level_procedure
2428: , L_LOG_MODULE || 'end'
2429: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2430: || x_return_status
2431: );
2435:
2436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2438:
2439: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string
2442: (
2443: fnd_log.level_unexpected
2437: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2438:
2439: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string
2442: (
2443: fnd_log.level_unexpected
2444: , L_LOG_MODULE || 'unexpected_error'
2445: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2439: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2440: THEN
2441: fnd_log.string
2442: (
2443: fnd_log.level_unexpected
2444: , L_LOG_MODULE || 'unexpected_error'
2445: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2446: );
2447: END IF ;
2452: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2453: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2454: FND_MSG_PUB.ADD;
2455:
2456: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2457: THEN
2458: fnd_log.string
2459: (
2460: fnd_log.level_unexpected
2454: FND_MSG_PUB.ADD;
2455:
2456: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2457: THEN
2458: fnd_log.string
2459: (
2460: fnd_log.level_unexpected
2461: , L_LOG_MODULE || 'when_others'
2462: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2456: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2457: THEN
2458: fnd_log.string
2459: (
2460: fnd_log.level_unexpected
2461: , L_LOG_MODULE || 'when_others'
2462: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2463: );
2464: fnd_log.string
2460: fnd_log.level_unexpected
2461: , L_LOG_MODULE || 'when_others'
2462: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2463: );
2464: fnd_log.string
2465: (
2466: fnd_log.level_unexpected
2467: , L_LOG_MODULE || 'when_others'
2468: , SQLERRM
2462: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2463: );
2464: fnd_log.string
2465: (
2466: fnd_log.level_unexpected
2467: , L_LOG_MODULE || 'when_others'
2468: , SQLERRM
2469: );
2470: END IF ;
2527:
2528: BEGIN
2529: x_return_status := FND_API.G_RET_STS_SUCCESS;
2530:
2531: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2532: THEN
2533: fnd_log.string
2534: (
2535: fnd_log.level_procedure
2529: x_return_status := FND_API.G_RET_STS_SUCCESS;
2530:
2531: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2532: THEN
2533: fnd_log.string
2534: (
2535: fnd_log.level_procedure
2536: , L_LOG_MODULE || 'start'
2537: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2531: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2532: THEN
2533: fnd_log.string
2534: (
2535: fnd_log.level_procedure
2536: , L_LOG_MODULE || 'start'
2537: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2538: );
2539: fnd_log.string
2535: fnd_log.level_procedure
2536: , L_LOG_MODULE || 'start'
2537: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2538: );
2539: fnd_log.string
2540: (
2541: fnd_log.level_procedure
2542: , L_LOG_MODULE || 'param 1'
2543: , 'p_api_version_number:' || p_api_version_number
2537: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2538: );
2539: fnd_log.string
2540: (
2541: fnd_log.level_procedure
2542: , L_LOG_MODULE || 'param 1'
2543: , 'p_api_version_number:' || p_api_version_number
2544: );
2545: fnd_log.string
2541: fnd_log.level_procedure
2542: , L_LOG_MODULE || 'param 1'
2543: , 'p_api_version_number:' || p_api_version_number
2544: );
2545: fnd_log.string
2546: (
2547: fnd_log.level_procedure
2548: , L_LOG_MODULE || 'param 2'
2549: , 'p_init_msg_list:' || p_init_msg_list
2543: , 'p_api_version_number:' || p_api_version_number
2544: );
2545: fnd_log.string
2546: (
2547: fnd_log.level_procedure
2548: , L_LOG_MODULE || 'param 2'
2549: , 'p_init_msg_list:' || p_init_msg_list
2550: );
2551: fnd_log.string
2547: fnd_log.level_procedure
2548: , L_LOG_MODULE || 'param 2'
2549: , 'p_init_msg_list:' || p_init_msg_list
2550: );
2551: fnd_log.string
2552: (
2553: fnd_log.level_procedure
2554: , L_LOG_MODULE || 'param 3'
2555: , 'p_commit:' || p_commit
2549: , 'p_init_msg_list:' || p_init_msg_list
2550: );
2551: fnd_log.string
2552: (
2553: fnd_log.level_procedure
2554: , L_LOG_MODULE || 'param 3'
2555: , 'p_commit:' || p_commit
2556: );
2557: fnd_log.string
2553: fnd_log.level_procedure
2554: , L_LOG_MODULE || 'param 3'
2555: , 'p_commit:' || p_commit
2556: );
2557: fnd_log.string
2558: (
2559: fnd_log.level_procedure
2560: , L_LOG_MODULE || 'param 4'
2561: , 'p_object_type:' || p_object_type
2555: , 'p_commit:' || p_commit
2556: );
2557: fnd_log.string
2558: (
2559: fnd_log.level_procedure
2560: , L_LOG_MODULE || 'param 4'
2561: , 'p_object_type:' || p_object_type
2562: );
2563: fnd_log.string
2559: fnd_log.level_procedure
2560: , L_LOG_MODULE || 'param 4'
2561: , 'p_object_type:' || p_object_type
2562: );
2563: fnd_log.string
2564: (
2565: fnd_log.level_procedure
2566: , L_LOG_MODULE || 'param 5'
2567: , 'p_processing_set_id:' || p_processing_set_id
2561: , 'p_object_type:' || p_object_type
2562: );
2563: fnd_log.string
2564: (
2565: fnd_log.level_procedure
2566: , L_LOG_MODULE || 'param 5'
2567: , 'p_processing_set_id:' || p_processing_set_id
2568: );
2569: END IF ;
2593: ------------------------------------------------------------------------------
2594: -- Actual Logic starts below:
2595: ------------------------------------------------------------------------------
2596:
2597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2598: THEN
2599: fnd_log.string
2600: (
2601: fnd_log.level_statement
2595: ------------------------------------------------------------------------------
2596:
2597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2598: THEN
2599: fnd_log.string
2600: (
2601: fnd_log.level_statement
2602: , L_LOG_MODULE || 'del_sraudit_tl_start'
2603: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'
2597: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2598: THEN
2599: fnd_log.string
2600: (
2601: fnd_log.level_statement
2602: , L_LOG_MODULE || 'del_sraudit_tl_start'
2603: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'
2604: );
2605: END IF ;
2622: );
2623:
2624: l_row_count := SQL%ROWCOUNT;
2625:
2626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2627: THEN
2628: fnd_log.string
2629: (
2630: fnd_log.level_statement
2624: l_row_count := SQL%ROWCOUNT;
2625:
2626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2627: THEN
2628: fnd_log.string
2629: (
2630: fnd_log.level_statement
2631: , L_LOG_MODULE || 'del_sraudit_tl_end'
2632: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '
2626: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2627: THEN
2628: fnd_log.string
2629: (
2630: fnd_log.level_statement
2631: , L_LOG_MODULE || 'del_sraudit_tl_end'
2632: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '
2633: || l_row_count || ' rows'
2634: );
2635: END IF ;
2636:
2637: ---
2638:
2639: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2640: THEN
2641: fnd_log.string
2642: (
2643: fnd_log.level_statement
2637: ---
2638:
2639: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2640: THEN
2641: fnd_log.string
2642: (
2643: fnd_log.level_statement
2644: , L_LOG_MODULE || 'del_sraudit_b_start'
2645: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'
2639: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2640: THEN
2641: fnd_log.string
2642: (
2643: fnd_log.level_statement
2644: , L_LOG_MODULE || 'del_sraudit_b_start'
2645: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'
2646: );
2647: END IF ;
2663: );
2664:
2665: l_row_count := SQL%ROWCOUNT;
2666:
2667: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2668: THEN
2669: fnd_log.string
2670: (
2671: fnd_log.level_statement
2665: l_row_count := SQL%ROWCOUNT;
2666:
2667: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2668: THEN
2669: fnd_log.string
2670: (
2671: fnd_log.level_statement
2672: , L_LOG_MODULE || 'del_sraudit_b_end'
2673: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '
2667: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2668: THEN
2669: fnd_log.string
2670: (
2671: fnd_log.level_statement
2672: , L_LOG_MODULE || 'del_sraudit_b_end'
2673: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '
2674: || l_row_count || ' rows'
2675: );
2676: END IF ;
2677:
2678: ---
2679:
2680: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2681: THEN
2682: fnd_log.string
2683: (
2684: fnd_log.level_procedure
2678: ---
2679:
2680: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2681: THEN
2682: fnd_log.string
2683: (
2684: fnd_log.level_procedure
2685: , L_LOG_MODULE || 'end'
2686: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2680: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2681: THEN
2682: fnd_log.string
2683: (
2684: fnd_log.level_procedure
2685: , L_LOG_MODULE || 'end'
2686: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2687: || x_return_status
2688: );
2692:
2693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2695:
2696: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2697: THEN
2698: fnd_log.string
2699: (
2700: fnd_log.level_unexpected
2694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2695:
2696: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2697: THEN
2698: fnd_log.string
2699: (
2700: fnd_log.level_unexpected
2701: , L_LOG_MODULE || 'unexpected_error'
2702: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2696: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2697: THEN
2698: fnd_log.string
2699: (
2700: fnd_log.level_unexpected
2701: , L_LOG_MODULE || 'unexpected_error'
2702: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2703: );
2704: END IF ;
2709: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2710: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2711: FND_MSG_PUB.ADD;
2712:
2713: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2714: THEN
2715: fnd_log.string
2716: (
2717: fnd_log.level_unexpected
2711: FND_MSG_PUB.ADD;
2712:
2713: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2714: THEN
2715: fnd_log.string
2716: (
2717: fnd_log.level_unexpected
2718: , L_LOG_MODULE || 'when_others'
2719: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2713: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2714: THEN
2715: fnd_log.string
2716: (
2717: fnd_log.level_unexpected
2718: , L_LOG_MODULE || 'when_others'
2719: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2720: );
2721: fnd_log.string
2717: fnd_log.level_unexpected
2718: , L_LOG_MODULE || 'when_others'
2719: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2720: );
2721: fnd_log.string
2722: (
2723: fnd_log.level_unexpected
2724: , L_LOG_MODULE || 'when_others'
2725: , SQLERRM
2719: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2720: );
2721: fnd_log.string
2722: (
2723: fnd_log.level_unexpected
2724: , L_LOG_MODULE || 'when_others'
2725: , SQLERRM
2726: );
2727: END IF ;
2785:
2786: BEGIN
2787: x_return_status := FND_API.G_RET_STS_SUCCESS;
2788:
2789: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2790: THEN
2791: fnd_log.string
2792: (
2793: fnd_log.level_procedure
2787: x_return_status := FND_API.G_RET_STS_SUCCESS;
2788:
2789: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2790: THEN
2791: fnd_log.string
2792: (
2793: fnd_log.level_procedure
2794: , L_LOG_MODULE || 'start'
2795: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2789: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2790: THEN
2791: fnd_log.string
2792: (
2793: fnd_log.level_procedure
2794: , L_LOG_MODULE || 'start'
2795: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2796: );
2797: fnd_log.string
2793: fnd_log.level_procedure
2794: , L_LOG_MODULE || 'start'
2795: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2796: );
2797: fnd_log.string
2798: (
2799: fnd_log.level_procedure
2800: , L_LOG_MODULE || 'param 1'
2801: , 'p_api_version_number:' || p_api_version_number
2795: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2796: );
2797: fnd_log.string
2798: (
2799: fnd_log.level_procedure
2800: , L_LOG_MODULE || 'param 1'
2801: , 'p_api_version_number:' || p_api_version_number
2802: );
2803: fnd_log.string
2799: fnd_log.level_procedure
2800: , L_LOG_MODULE || 'param 1'
2801: , 'p_api_version_number:' || p_api_version_number
2802: );
2803: fnd_log.string
2804: (
2805: fnd_log.level_procedure
2806: , L_LOG_MODULE || 'param 2'
2807: , 'p_init_msg_list:' || p_init_msg_list
2801: , 'p_api_version_number:' || p_api_version_number
2802: );
2803: fnd_log.string
2804: (
2805: fnd_log.level_procedure
2806: , L_LOG_MODULE || 'param 2'
2807: , 'p_init_msg_list:' || p_init_msg_list
2808: );
2809: fnd_log.string
2805: fnd_log.level_procedure
2806: , L_LOG_MODULE || 'param 2'
2807: , 'p_init_msg_list:' || p_init_msg_list
2808: );
2809: fnd_log.string
2810: (
2811: fnd_log.level_procedure
2812: , L_LOG_MODULE || 'param 3'
2813: , 'p_commit:' || p_commit
2807: , 'p_init_msg_list:' || p_init_msg_list
2808: );
2809: fnd_log.string
2810: (
2811: fnd_log.level_procedure
2812: , L_LOG_MODULE || 'param 3'
2813: , 'p_commit:' || p_commit
2814: );
2815: fnd_log.string
2811: fnd_log.level_procedure
2812: , L_LOG_MODULE || 'param 3'
2813: , 'p_commit:' || p_commit
2814: );
2815: fnd_log.string
2816: (
2817: fnd_log.level_procedure
2818: , L_LOG_MODULE || 'param 4'
2819: , 'p_object_type:' || p_object_type
2813: , 'p_commit:' || p_commit
2814: );
2815: fnd_log.string
2816: (
2817: fnd_log.level_procedure
2818: , L_LOG_MODULE || 'param 4'
2819: , 'p_object_type:' || p_object_type
2820: );
2821: fnd_log.string
2817: fnd_log.level_procedure
2818: , L_LOG_MODULE || 'param 4'
2819: , 'p_object_type:' || p_object_type
2820: );
2821: fnd_log.string
2822: (
2823: fnd_log.level_procedure
2824: , L_LOG_MODULE || 'param 5'
2825: , 'p_processing_set_id:' || p_processing_set_id
2819: , 'p_object_type:' || p_object_type
2820: );
2821: fnd_log.string
2822: (
2823: fnd_log.level_procedure
2824: , L_LOG_MODULE || 'param 5'
2825: , 'p_processing_set_id:' || p_processing_set_id
2826: );
2827: END IF ;
2851: ------------------------------------------------------------------------------
2852: -- Actual Logic starts below:
2853: ------------------------------------------------------------------------------
2854:
2855: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2856: THEN
2857: fnd_log.string
2858: (
2859: fnd_log.level_statement
2853: ------------------------------------------------------------------------------
2854:
2855: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2856: THEN
2857: fnd_log.string
2858: (
2859: fnd_log.level_statement
2860: , L_LOG_MODULE || 'cug_attr_tl_del_start'
2861: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'
2855: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2856: THEN
2857: fnd_log.string
2858: (
2859: fnd_log.level_statement
2860: , L_LOG_MODULE || 'cug_attr_tl_del_start'
2861: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'
2862: );
2863: END IF ;
2881: );
2882:
2883: l_row_count := SQL%ROWCOUNT;
2884:
2885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2886: THEN
2887: fnd_log.string
2888: (
2889: fnd_log.level_statement
2883: l_row_count := SQL%ROWCOUNT;
2884:
2885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2886: THEN
2887: fnd_log.string
2888: (
2889: fnd_log.level_statement
2890: , L_LOG_MODULE || 'cug_attr_tl_del_end'
2891: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '
2885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2886: THEN
2887: fnd_log.string
2888: (
2889: fnd_log.level_statement
2890: , L_LOG_MODULE || 'cug_attr_tl_del_end'
2891: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '
2892: || l_row_count || ' rows'
2893: );
2894: END IF ;
2895:
2896: ---
2897:
2898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2899: THEN
2900: fnd_log.string
2901: (
2902: fnd_log.level_statement
2896: ---
2897:
2898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2899: THEN
2900: fnd_log.string
2901: (
2902: fnd_log.level_statement
2903: , L_LOG_MODULE || 'cug_attr_b_del_start'
2904: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_B'
2898: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2899: THEN
2900: fnd_log.string
2901: (
2902: fnd_log.level_statement
2903: , L_LOG_MODULE || 'cug_attr_b_del_start'
2904: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_B'
2905: );
2906: END IF ;
2922: );
2923:
2924: l_row_count := SQL%ROWCOUNT;
2925:
2926: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2927: THEN
2928: fnd_log.string
2929: (
2930: fnd_log.level_statement
2924: l_row_count := SQL%ROWCOUNT;
2925:
2926: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2927: THEN
2928: fnd_log.string
2929: (
2930: fnd_log.level_statement
2931: , L_LOG_MODULE || 'cug_attr_b_del_end'
2932: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_B '
2926: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2927: THEN
2928: fnd_log.string
2929: (
2930: fnd_log.level_statement
2931: , L_LOG_MODULE || 'cug_attr_b_del_end'
2932: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_B '
2933: || l_row_count || ' rows'
2934: );
2935: END IF ;
2936:
2937: ---
2938:
2939: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2940: THEN
2941: fnd_log.string
2942: (
2943: fnd_log.level_statement
2937: ---
2938:
2939: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2940: THEN
2941: fnd_log.string
2942: (
2943: fnd_log.level_statement
2944: , L_LOG_MODULE || 'sr_ext_attr_aud_del_start'
2945: , 'Deleting data from table CS_INCIDENTS_EXT_AUDIT'
2939: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2940: THEN
2941: fnd_log.string
2942: (
2943: fnd_log.level_statement
2944: , L_LOG_MODULE || 'sr_ext_attr_aud_del_start'
2945: , 'Deleting data from table CS_INCIDENTS_EXT_AUDIT'
2946: );
2947: END IF ;
2966: );
2967:
2968: l_row_count := SQL%ROWCOUNT;
2969:
2970: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2971: THEN
2972: fnd_log.string
2973: (
2974: fnd_log.level_statement
2968: l_row_count := SQL%ROWCOUNT;
2969:
2970: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2971: THEN
2972: fnd_log.string
2973: (
2974: fnd_log.level_statement
2975: , L_LOG_MODULE || 'sr_ext_attr_aud_del_end'
2976: , 'After deleting data from table CS_INCIDENTS_EXT_AUDIT '
2970: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2971: THEN
2972: fnd_log.string
2973: (
2974: fnd_log.level_statement
2975: , L_LOG_MODULE || 'sr_ext_attr_aud_del_end'
2976: , 'After deleting data from table CS_INCIDENTS_EXT_AUDIT '
2977: || l_row_count || ' rows'
2978: );
2979: END IF ;
2980:
2981: ---
2982:
2983: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2984: THEN
2985: fnd_log.string
2986: (
2987: fnd_log.level_statement
2981: ---
2982:
2983: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2984: THEN
2985: fnd_log.string
2986: (
2987: fnd_log.level_statement
2988: , L_LOG_MODULE || 'sr_ext_attr_del_start'
2989: , 'Deleting data from table CS_INCIDENTS_EXT_TL'
2983: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2984: THEN
2985: fnd_log.string
2986: (
2987: fnd_log.level_statement
2988: , L_LOG_MODULE || 'sr_ext_attr_del_start'
2989: , 'Deleting data from table CS_INCIDENTS_EXT_TL'
2990: );
2991: END IF ;
3008: );
3009:
3010: l_row_count := SQL%ROWCOUNT;
3011:
3012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3013: THEN
3014: fnd_log.string
3015: (
3016: fnd_log.level_statement
3010: l_row_count := SQL%ROWCOUNT;
3011:
3012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3013: THEN
3014: fnd_log.string
3015: (
3016: fnd_log.level_statement
3017: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3018: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3012: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3013: THEN
3014: fnd_log.string
3015: (
3016: fnd_log.level_statement
3017: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3018: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3019: || l_row_count || ' rows'
3020: );
3021: END IF ;
3022:
3023: ---
3024:
3025: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3026: THEN
3027: fnd_log.string
3028: (
3029: fnd_log.level_statement
3023: ---
3024:
3025: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3026: THEN
3027: fnd_log.string
3028: (
3029: fnd_log.level_statement
3030: , L_LOG_MODULE || 'sr_ext_attr_del_start'
3031: , 'Deleting data from table CS_INCIDENTS_EXT'
3025: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3026: THEN
3027: fnd_log.string
3028: (
3029: fnd_log.level_statement
3030: , L_LOG_MODULE || 'sr_ext_attr_del_start'
3031: , 'Deleting data from table CS_INCIDENTS_EXT'
3032: );
3033: END IF ;
3050: );
3051:
3052: l_row_count := SQL%ROWCOUNT;
3053:
3054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3055: THEN
3056: fnd_log.string
3057: (
3058: fnd_log.level_statement
3052: l_row_count := SQL%ROWCOUNT;
3053:
3054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3055: THEN
3056: fnd_log.string
3057: (
3058: fnd_log.level_statement
3059: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3060: , 'After deleting data from table CS_INCIDENTS_EXT '
3054: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3055: THEN
3056: fnd_log.string
3057: (
3058: fnd_log.level_statement
3059: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3060: , 'After deleting data from table CS_INCIDENTS_EXT '
3061: || l_row_count || ' rows'
3062: );
3063: END IF ;
3064:
3065: ---
3066:
3067: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3068: THEN
3069: fnd_log.string
3070: (
3071: fnd_log.level_procedure
3065: ---
3066:
3067: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3068: THEN
3069: fnd_log.string
3070: (
3071: fnd_log.level_procedure
3072: , L_LOG_MODULE || 'end'
3073: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3067: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3068: THEN
3069: fnd_log.string
3070: (
3071: fnd_log.level_procedure
3072: , L_LOG_MODULE || 'end'
3073: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3074: || x_return_status
3075: );
3079:
3080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3082:
3083: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3084: THEN
3085: fnd_log.string
3086: (
3087: fnd_log.level_unexpected
3081: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3082:
3083: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3084: THEN
3085: fnd_log.string
3086: (
3087: fnd_log.level_unexpected
3088: , L_LOG_MODULE || 'unexpected_error'
3089: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3083: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3084: THEN
3085: fnd_log.string
3086: (
3087: fnd_log.level_unexpected
3088: , L_LOG_MODULE || 'unexpected_error'
3089: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3090: );
3091: END IF ;
3096: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3097: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3098: FND_MSG_PUB.ADD;
3099:
3100: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3101: THEN
3102: fnd_log.string
3103: (
3104: fnd_log.level_unexpected
3098: FND_MSG_PUB.ADD;
3099:
3100: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3101: THEN
3102: fnd_log.string
3103: (
3104: fnd_log.level_unexpected
3105: , L_LOG_MODULE || 'when_others'
3106: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3100: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3101: THEN
3102: fnd_log.string
3103: (
3104: fnd_log.level_unexpected
3105: , L_LOG_MODULE || 'when_others'
3106: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3107: );
3108: fnd_log.string
3104: fnd_log.level_unexpected
3105: , L_LOG_MODULE || 'when_others'
3106: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3107: );
3108: fnd_log.string
3109: (
3110: fnd_log.level_unexpected
3111: , L_LOG_MODULE || 'when_others'
3112: , SQLERRM
3106: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3107: );
3108: fnd_log.string
3109: (
3110: fnd_log.level_unexpected
3111: , L_LOG_MODULE || 'when_others'
3112: , SQLERRM
3113: );
3114: END IF ;
3250:
3251: BEGIN
3252: x_return_status := FND_API.G_RET_STS_SUCCESS;
3253:
3254: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3255: THEN
3256: fnd_log.string
3257: (
3258: fnd_log.level_procedure
3252: x_return_status := FND_API.G_RET_STS_SUCCESS;
3253:
3254: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3255: THEN
3256: fnd_log.string
3257: (
3258: fnd_log.level_procedure
3259: , L_LOG_MODULE || 'start'
3260: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3254: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3255: THEN
3256: fnd_log.string
3257: (
3258: fnd_log.level_procedure
3259: , L_LOG_MODULE || 'start'
3260: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3261: );
3262: fnd_log.string
3258: fnd_log.level_procedure
3259: , L_LOG_MODULE || 'start'
3260: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3261: );
3262: fnd_log.string
3263: (
3264: fnd_log.level_procedure
3265: , L_LOG_MODULE || 'param 1'
3266: , 'p_api_version_number:' || p_api_version_number
3260: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3261: );
3262: fnd_log.string
3263: (
3264: fnd_log.level_procedure
3265: , L_LOG_MODULE || 'param 1'
3266: , 'p_api_version_number:' || p_api_version_number
3267: );
3268: fnd_log.string
3264: fnd_log.level_procedure
3265: , L_LOG_MODULE || 'param 1'
3266: , 'p_api_version_number:' || p_api_version_number
3267: );
3268: fnd_log.string
3269: (
3270: fnd_log.level_procedure
3271: , L_LOG_MODULE || 'param 2'
3272: , 'p_init_msg_list:' || p_init_msg_list
3266: , 'p_api_version_number:' || p_api_version_number
3267: );
3268: fnd_log.string
3269: (
3270: fnd_log.level_procedure
3271: , L_LOG_MODULE || 'param 2'
3272: , 'p_init_msg_list:' || p_init_msg_list
3273: );
3274: fnd_log.string
3270: fnd_log.level_procedure
3271: , L_LOG_MODULE || 'param 2'
3272: , 'p_init_msg_list:' || p_init_msg_list
3273: );
3274: fnd_log.string
3275: (
3276: fnd_log.level_procedure
3277: , L_LOG_MODULE || 'param 3'
3278: , 'p_commit:' || p_commit
3272: , 'p_init_msg_list:' || p_init_msg_list
3273: );
3274: fnd_log.string
3275: (
3276: fnd_log.level_procedure
3277: , L_LOG_MODULE || 'param 3'
3278: , 'p_commit:' || p_commit
3279: );
3280: fnd_log.string
3276: fnd_log.level_procedure
3277: , L_LOG_MODULE || 'param 3'
3278: , 'p_commit:' || p_commit
3279: );
3280: fnd_log.string
3281: (
3282: fnd_log.level_procedure
3283: , L_LOG_MODULE || 'param 4'
3284: , 'p_purge_set_id' || p_purge_set_id
3278: , 'p_commit:' || p_commit
3279: );
3280: fnd_log.string
3281: (
3282: fnd_log.level_procedure
3283: , L_LOG_MODULE || 'param 4'
3284: , 'p_purge_set_id' || p_purge_set_id
3285: );
3286: END IF ;
3314: ------------------------------------------------------------------------------
3315:
3316: IF p_incident_id_tbl.COUNT > 0
3317: THEN
3318: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3319: THEN
3320: fnd_log.string
3321: (
3322: fnd_log.level_statement
3316: IF p_incident_id_tbl.COUNT > 0
3317: THEN
3318: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3319: THEN
3320: fnd_log.string
3321: (
3322: fnd_log.level_statement
3323: , L_LOG_MODULE || 'ins_purge_aud_b_start'
3324: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_B'
3318: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3319: THEN
3320: fnd_log.string
3321: (
3322: fnd_log.level_statement
3323: , L_LOG_MODULE || 'ins_purge_aud_b_start'
3324: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_B'
3325: );
3326: END IF ;
3370: );
3371:
3372: l_row_count := SQL%ROWCOUNT;
3373:
3374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3375: THEN
3376: fnd_log.string
3377: (
3378: fnd_log.level_statement
3372: l_row_count := SQL%ROWCOUNT;
3373:
3374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3375: THEN
3376: fnd_log.string
3377: (
3378: fnd_log.level_statement
3379: , L_LOG_MODULE || 'ins_purge_aud_b_end'
3380: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3374: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3375: THEN
3376: fnd_log.string
3377: (
3378: fnd_log.level_statement
3379: , L_LOG_MODULE || 'ins_purge_aud_b_end'
3380: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3381: || l_row_count || ' rows'
3382: );
3382: );
3383: END IF ;
3384: ELSIF p_incident_id_tbl.COUNT <= 0
3385: THEN
3386: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3387: THEN
3388: fnd_log.string
3389: (
3390: fnd_log.level_statement
3384: ELSIF p_incident_id_tbl.COUNT <= 0
3385: THEN
3386: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3387: THEN
3388: fnd_log.string
3389: (
3390: fnd_log.level_statement
3391: , L_LOG_MODULE || 'ins_purge_aud_b_err'
3392: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3386: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3387: THEN
3388: fnd_log.string
3389: (
3390: fnd_log.level_statement
3391: , L_LOG_MODULE || 'ins_purge_aud_b_err'
3392: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3393: || 'p_incident_id_tbl had ' || p_incident_id_tbl.COUNT || ' rows'
3394: );
3396: END IF;
3397:
3398: IF p_incident_id_tl_tbl.COUNT > 0
3399: THEN
3400: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3401: THEN
3402: fnd_log.string
3403: (
3404: fnd_log.level_statement
3398: IF p_incident_id_tl_tbl.COUNT > 0
3399: THEN
3400: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3401: THEN
3402: fnd_log.string
3403: (
3404: fnd_log.level_statement
3405: , L_LOG_MODULE || 'ins_purge_aud_tl_start'
3406: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL'
3400: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3401: THEN
3402: fnd_log.string
3403: (
3404: fnd_log.level_statement
3405: , L_LOG_MODULE || 'ins_purge_aud_tl_start'
3406: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL'
3407: );
3408: END IF ;
3439: );
3440:
3441: l_row_count := SQL%ROWCOUNT;
3442:
3443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3444: THEN
3445: fnd_log.string
3446: (
3447: fnd_log.level_statement
3441: l_row_count := SQL%ROWCOUNT;
3442:
3443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3444: THEN
3445: fnd_log.string
3446: (
3447: fnd_log.level_statement
3448: , L_LOG_MODULE || 'ins_purge_aud_tl_end'
3449: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3443: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3444: THEN
3445: fnd_log.string
3446: (
3447: fnd_log.level_statement
3448: , L_LOG_MODULE || 'ins_purge_aud_tl_end'
3449: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3450: || l_row_count || ' rows'
3451: );
3451: );
3452: END IF ;
3453: ELSIF p_incident_id_tl_tbl.COUNT <= 0
3454: THEN
3455: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3456: THEN
3457: fnd_log.string
3458: (
3459: fnd_log.level_statement
3453: ELSIF p_incident_id_tl_tbl.COUNT <= 0
3454: THEN
3455: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3456: THEN
3457: fnd_log.string
3458: (
3459: fnd_log.level_statement
3460: , L_LOG_MODULE || 'ins_purge_aud_tl_err'
3461: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3455: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3456: THEN
3457: fnd_log.string
3458: (
3459: fnd_log.level_statement
3460: , L_LOG_MODULE || 'ins_purge_aud_tl_err'
3461: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3462: || 'p_incident_id_tl_tbl had ' || p_incident_id_tl_tbl.COUNT || ' rows'
3463: );
3463: );
3464: END IF ;
3465: END IF;
3466:
3467: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3468: THEN
3469: fnd_log.string
3470: (
3471: fnd_log.level_procedure
3465: END IF;
3466:
3467: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3468: THEN
3469: fnd_log.string
3470: (
3471: fnd_log.level_procedure
3472: , L_LOG_MODULE || 'end'
3473: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3467: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3468: THEN
3469: fnd_log.string
3470: (
3471: fnd_log.level_procedure
3472: , L_LOG_MODULE || 'end'
3473: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3474: || x_return_status
3475: );
3479:
3480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3482:
3483: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3484: THEN
3485: fnd_log.string
3486: (
3487: fnd_log.level_unexpected
3481: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3482:
3483: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3484: THEN
3485: fnd_log.string
3486: (
3487: fnd_log.level_unexpected
3488: , L_LOG_MODULE || 'unexpected_error'
3489: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3483: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3484: THEN
3485: fnd_log.string
3486: (
3487: fnd_log.level_unexpected
3488: , L_LOG_MODULE || 'unexpected_error'
3489: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3490: );
3491: END IF ;
3496: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3497: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3498: FND_MSG_PUB.ADD;
3499:
3500: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3501: THEN
3502: fnd_log.string
3503: (
3504: fnd_log.level_unexpected
3498: FND_MSG_PUB.ADD;
3499:
3500: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3501: THEN
3502: fnd_log.string
3503: (
3504: fnd_log.level_unexpected
3505: , L_LOG_MODULE || 'when_others'
3506: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3500: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3501: THEN
3502: fnd_log.string
3503: (
3504: fnd_log.level_unexpected
3505: , L_LOG_MODULE || 'when_others'
3506: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3507: );
3508: fnd_log.string
3504: fnd_log.level_unexpected
3505: , L_LOG_MODULE || 'when_others'
3506: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3507: );
3508: fnd_log.string
3509: (
3510: fnd_log.level_unexpected
3511: , L_LOG_MODULE || 'when_others'
3512: , SQLERRM
3506: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3507: );
3508: fnd_log.string
3509: (
3510: fnd_log.level_unexpected
3511: , L_LOG_MODULE || 'when_others'
3512: , SQLERRM
3513: );
3514: END IF ;
3583: -- If the user terminates the concurrent request
3584: -- raise an exception and add a message to the stack
3585:
3586: THEN
3587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3588: THEN
3589: fnd_log.string
3590: (
3591: fnd_log.level_statement
3585:
3586: THEN
3587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3588: THEN
3589: fnd_log.string
3590: (
3591: fnd_log.level_statement
3592: , L_LOG_MODULE || 'conc_req_user_stop'
3593: , 'This concurrent request is in status ' || l_dev_status
3587: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3588: THEN
3589: fnd_log.string
3590: (
3591: fnd_log.level_statement
3592: , L_LOG_MODULE || 'conc_req_user_stop'
3593: , 'This concurrent request is in status ' || l_dev_status
3594: || ' and phase ' || l_dev_phase
3595: );
3611: END IF;
3612: ELSE
3613: -- if fnd_concurrent.get_request_status failed...
3614:
3615: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3616: THEN
3617: fnd_log.string
3618: (
3619: fnd_log.level_unexpected
3613: -- if fnd_concurrent.get_request_status failed...
3614:
3615: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3616: THEN
3617: fnd_log.string
3618: (
3619: fnd_log.level_unexpected
3620: , L_LOG_MODULE || 'conc_req_status_fail'
3621: , 'Failed while getting the status of this request'
3615: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3616: THEN
3617: fnd_log.string
3618: (
3619: fnd_log.level_unexpected
3620: , L_LOG_MODULE || 'conc_req_status_fail'
3621: , 'Failed while getting the status of this request'
3622: );
3623: END IF ;