[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 ;
1743: );
1744:
1745: l_row_count := SQL%ROWCOUNT;
1746:
1747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1748: THEN
1749: fnd_log.string
1750: (
1751: fnd_log.level_statement
1745: l_row_count := SQL%ROWCOUNT;
1746:
1747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1748: THEN
1749: fnd_log.string
1750: (
1751: fnd_log.level_statement
1752: , L_LOG_MODULE || 'del_srtl_end'
1753: , 'After deleting rows from table CS_INCIDENTS_ALL_TL ' || l_row_count
1747: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1748: THEN
1749: fnd_log.string
1750: (
1751: fnd_log.level_statement
1752: , L_LOG_MODULE || 'del_srtl_end'
1753: , 'After deleting rows from table CS_INCIDENTS_ALL_TL ' || l_row_count
1754: || ' rows'
1755: );
1763: ---
1764:
1765: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1766: THEN
1767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1768: THEN
1769: fnd_log.string
1770: (
1771: fnd_log.level_statement
1765: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1766: THEN
1767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1768: THEN
1769: fnd_log.string
1770: (
1771: fnd_log.level_statement
1772: , L_LOG_MODULE || 'del_srb_start'
1773: , 'Deleting rows from table CS_INCIDENTS_ALL_B'
1767: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1768: THEN
1769: fnd_log.string
1770: (
1771: fnd_log.level_statement
1772: , L_LOG_MODULE || 'del_srb_start'
1773: , 'Deleting rows from table CS_INCIDENTS_ALL_B'
1774: );
1775: END IF ;
1796: );
1797:
1798: l_row_count := SQL%ROWCOUNT;
1799:
1800: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1801: THEN
1802: fnd_log.string
1803: (
1804: fnd_log.level_statement
1798: l_row_count := SQL%ROWCOUNT;
1799:
1800: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1801: THEN
1802: fnd_log.string
1803: (
1804: fnd_log.level_statement
1805: , L_LOG_MODULE || 'del_srb_end'
1806: , 'After deleting rows from table CS_INCIDENTS_ALL_B ' || l_row_count
1800: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1801: THEN
1802: fnd_log.string
1803: (
1804: fnd_log.level_statement
1805: , L_LOG_MODULE || 'del_srb_end'
1806: , 'After deleting rows from table CS_INCIDENTS_ALL_B ' || l_row_count
1807: || ' rows'
1808: );
1824: -- updated back to the Staging Table to facilitate
1825: -- generation of concurrent request output file.
1826:
1827: THEN
1828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1829: THEN
1830: fnd_log.string
1831: (
1832: fnd_log.level_statement
1826:
1827: THEN
1828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1829: THEN
1830: fnd_log.string
1831: (
1832: fnd_log.level_statement
1833: , L_LOG_MODULE || 'write_staging_start'
1834: , 'Updating purge status into table CS_INCIDENTS_PURGE_STAGING'
1828: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1829: THEN
1830: fnd_log.string
1831: (
1832: fnd_log.level_statement
1833: , L_LOG_MODULE || 'write_staging_start'
1834: , 'Updating purge status into table CS_INCIDENTS_PURGE_STAGING'
1835: );
1836: END IF ;
1847: incident_id = l_incident_id_status_tbl(j);
1848:
1849: l_row_count := SQL%ROWCOUNT;
1850:
1851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1852: THEN
1853: fnd_log.string
1854: (
1855: fnd_log.level_statement
1849: l_row_count := SQL%ROWCOUNT;
1850:
1851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1852: THEN
1853: fnd_log.string
1854: (
1855: fnd_log.level_statement
1856: , L_LOG_MODULE || 'write_staging_end'
1857: , 'After updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1852: THEN
1853: fnd_log.string
1854: (
1855: fnd_log.level_statement
1856: , L_LOG_MODULE || 'write_staging_end'
1857: , 'After updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1858: || l_row_count || ' rows'
1859: );
1859: );
1860: END IF ;
1861: ELSIF l_incident_id_status_tbl.COUNT <= 0
1862: THEN
1863: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1864: THEN
1865: fnd_log.string
1866: (
1867: fnd_log.level_statement
1861: ELSIF l_incident_id_status_tbl.COUNT <= 0
1862: THEN
1863: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1864: THEN
1865: fnd_log.string
1866: (
1867: fnd_log.level_statement
1868: , L_LOG_MODULE || 'write_staging_norows'
1869: , 'While updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1863: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1864: THEN
1865: fnd_log.string
1866: (
1867: fnd_log.level_statement
1868: , L_LOG_MODULE || 'write_staging_norows'
1869: , 'While updating purge status into table CS_INCIDENTS_PURGE_STAGING '
1870: || 'l_incident_id_status_tbl had ' || l_incident_id_status_tbl.COUNT
1871: || ' rows'
1881: ---
1882:
1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1884: THEN
1885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1886: THEN
1887: fnd_log.string
1888: (
1889: fnd_log.level_statement
1883: IF x_return_status = FND_API.G_RET_STS_SUCCESS
1884: THEN
1885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1886: THEN
1887: fnd_log.string
1888: (
1889: fnd_log.level_statement
1890: , L_LOG_MODULE || 'write_staging_success_start'
1891: , 'Updating rows processed successfully with purge status = S'
1885: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1886: THEN
1887: fnd_log.string
1888: (
1889: fnd_log.level_statement
1890: , L_LOG_MODULE || 'write_staging_success_start'
1891: , 'Updating rows processed successfully with purge status = S'
1892: );
1893: END IF ;
1918: AND j.processing_set_id = p_processing_set_id
1919: );
1920: l_row_count := SQL%ROWCOUNT;
1921:
1922: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1923: THEN
1924: fnd_log.string
1925: (
1926: fnd_log.level_statement
1920: l_row_count := SQL%ROWCOUNT;
1921:
1922: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1923: THEN
1924: fnd_log.string
1925: (
1926: fnd_log.level_statement
1927: , L_LOG_MODULE || 'write_staging_success_end'
1928: , 'After updating rows processed successfully with '
1922: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1923: THEN
1924: fnd_log.string
1925: (
1926: fnd_log.level_statement
1927: , L_LOG_MODULE || 'write_staging_success_end'
1928: , 'After updating rows processed successfully with '
1929: || 'purge status = S ' || l_row_count
1930: );
1943: -- If audit information is required as per profile option
1944: -- CS_SR_PURGE_AUDIT_REQUIRED, then proceed further
1945:
1946: THEN
1947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1948: THEN
1949: fnd_log.string
1950: (
1951: fnd_log.level_statement
1945:
1946: THEN
1947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1948: THEN
1949: fnd_log.string
1950: (
1951: fnd_log.level_statement
1952: , L_LOG_MODULE || 'purge_audit_create_start'
1953: , 'Calling the procedure CREATE_PURGEAUDIT_RECORDS to create purge '
1947: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1948: THEN
1949: fnd_log.string
1950: (
1951: fnd_log.level_statement
1952: , L_LOG_MODULE || 'purge_audit_create_start'
1953: , 'Calling the procedure CREATE_PURGEAUDIT_RECORDS to create purge '
1954: || 'audit information'
1955: );
1984: , x_msg_count => x_msg_count
1985: , x_msg_data => x_msg_data
1986: );
1987:
1988: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1989: THEN
1990: fnd_log.string
1991: (
1992: fnd_log.level_statement
1986: );
1987:
1988: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1989: THEN
1990: fnd_log.string
1991: (
1992: fnd_log.level_statement
1993: , L_LOG_MODULE || 'purge_audit_create_end'
1994: , 'After calling the procedure CREATE_PURGEAUDIT_RECORDS. '
1988: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
1989: THEN
1990: fnd_log.string
1991: (
1992: fnd_log.level_statement
1993: , L_LOG_MODULE || 'purge_audit_create_end'
1994: , 'After calling the procedure CREATE_PURGEAUDIT_RECORDS. '
1995: || 'Returned with status ' || x_return_status
1996: );
2002: Check_User_Termination;
2003:
2004: ---
2005:
2006: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2007: THEN
2008: fnd_log.string
2009: (
2010: fnd_log.level_procedure
2004: ---
2005:
2006: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2007: THEN
2008: fnd_log.string
2009: (
2010: fnd_log.level_procedure
2011: , L_LOG_MODULE || 'end'
2012: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2006: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2007: THEN
2008: fnd_log.string
2009: (
2010: fnd_log.level_procedure
2011: , L_LOG_MODULE || 'end'
2012: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2013: || x_return_status
2014: );
2018:
2019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021:
2022: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2023: THEN
2024: fnd_log.string
2025: (
2026: fnd_log.level_unexpected
2020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2021:
2022: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2023: THEN
2024: fnd_log.string
2025: (
2026: fnd_log.level_unexpected
2027: , L_LOG_MODULE || 'unexpected_error'
2028: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2022: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2023: THEN
2024: fnd_log.string
2025: (
2026: fnd_log.level_unexpected
2027: , L_LOG_MODULE || 'unexpected_error'
2028: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2029: );
2030:
2041: , p_encoded => 'F'
2042: , p_data => x_msg_data
2043: , p_msg_index_out => x_msg_index_out
2044: );
2045: fnd_log.string
2046: (
2047: fnd_log.level_unexpected
2048: , L_LOG_MODULE || 'unexpected_error'
2049: , 'Error encountered is : ' || x_msg_data || ' [Index:'
2043: , p_msg_index_out => x_msg_index_out
2044: );
2045: fnd_log.string
2046: (
2047: fnd_log.level_unexpected
2048: , L_LOG_MODULE || 'unexpected_error'
2049: , 'Error encountered is : ' || x_msg_data || ' [Index:'
2050: || x_msg_index_out || ']'
2051: );
2059: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2060: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2061: FND_MSG_PUB.ADD;
2062:
2063: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2064: THEN
2065: fnd_log.string
2066: (
2067: fnd_log.level_unexpected
2061: FND_MSG_PUB.ADD;
2062:
2063: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2064: THEN
2065: fnd_log.string
2066: (
2067: fnd_log.level_unexpected
2068: , L_LOG_MODULE || 'when_others'
2069: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2063: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2064: THEN
2065: fnd_log.string
2066: (
2067: fnd_log.level_unexpected
2068: , L_LOG_MODULE || 'when_others'
2069: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2070: );
2071: fnd_log.string
2067: fnd_log.level_unexpected
2068: , L_LOG_MODULE || 'when_others'
2069: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2070: );
2071: fnd_log.string
2072: (
2073: fnd_log.level_unexpected
2074: , L_LOG_MODULE || 'when_others'
2075: , SQLERRM
2069: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2070: );
2071: fnd_log.string
2072: (
2073: fnd_log.level_unexpected
2074: , L_LOG_MODULE || 'when_others'
2075: , SQLERRM
2076: );
2077: END IF ;
2137:
2138: BEGIN
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140:
2141: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2142: THEN
2143: fnd_log.string
2144: (
2145: fnd_log.level_procedure
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;
2140:
2141: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2142: THEN
2143: fnd_log.string
2144: (
2145: fnd_log.level_procedure
2146: , L_LOG_MODULE || 'start'
2147: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2141: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2142: THEN
2143: fnd_log.string
2144: (
2145: fnd_log.level_procedure
2146: , L_LOG_MODULE || 'start'
2147: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2148: );
2149: fnd_log.string
2145: fnd_log.level_procedure
2146: , L_LOG_MODULE || 'start'
2147: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2148: );
2149: fnd_log.string
2150: (
2151: fnd_log.level_procedure
2152: , L_LOG_MODULE || 'param 1'
2153: , 'p_api_version_number:' || p_api_version_number
2147: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2148: );
2149: fnd_log.string
2150: (
2151: fnd_log.level_procedure
2152: , L_LOG_MODULE || 'param 1'
2153: , 'p_api_version_number:' || p_api_version_number
2154: );
2155: fnd_log.string
2151: fnd_log.level_procedure
2152: , L_LOG_MODULE || 'param 1'
2153: , 'p_api_version_number:' || p_api_version_number
2154: );
2155: fnd_log.string
2156: (
2157: fnd_log.level_procedure
2158: , L_LOG_MODULE || 'param 2'
2159: , 'p_init_msg_list:' || p_init_msg_list
2153: , 'p_api_version_number:' || p_api_version_number
2154: );
2155: fnd_log.string
2156: (
2157: fnd_log.level_procedure
2158: , L_LOG_MODULE || 'param 2'
2159: , 'p_init_msg_list:' || p_init_msg_list
2160: );
2161: fnd_log.string
2157: fnd_log.level_procedure
2158: , L_LOG_MODULE || 'param 2'
2159: , 'p_init_msg_list:' || p_init_msg_list
2160: );
2161: fnd_log.string
2162: (
2163: fnd_log.level_procedure
2164: , L_LOG_MODULE || 'param 3'
2165: , 'p_commit:' || p_commit
2159: , 'p_init_msg_list:' || p_init_msg_list
2160: );
2161: fnd_log.string
2162: (
2163: fnd_log.level_procedure
2164: , L_LOG_MODULE || 'param 3'
2165: , 'p_commit:' || p_commit
2166: );
2167: fnd_log.string
2163: fnd_log.level_procedure
2164: , L_LOG_MODULE || 'param 3'
2165: , 'p_commit:' || p_commit
2166: );
2167: fnd_log.string
2168: (
2169: fnd_log.level_procedure
2170: , L_LOG_MODULE || 'param 4'
2171: , 'p_object_type:' || p_object_type
2165: , 'p_commit:' || p_commit
2166: );
2167: fnd_log.string
2168: (
2169: fnd_log.level_procedure
2170: , L_LOG_MODULE || 'param 4'
2171: , 'p_object_type:' || p_object_type
2172: );
2173: fnd_log.string
2169: fnd_log.level_procedure
2170: , L_LOG_MODULE || 'param 4'
2171: , 'p_object_type:' || p_object_type
2172: );
2173: fnd_log.string
2174: (
2175: fnd_log.level_procedure
2176: , L_LOG_MODULE || 'param 5'
2177: , 'p_processing_set_id:' || p_processing_set_id
2171: , 'p_object_type:' || p_object_type
2172: );
2173: fnd_log.string
2174: (
2175: fnd_log.level_procedure
2176: , L_LOG_MODULE || 'param 5'
2177: , 'p_processing_set_id:' || p_processing_set_id
2178: );
2179: END IF ;
2203: ------------------------------------------------------------------------------
2204: -- Actual Logic starts below:
2205: ------------------------------------------------------------------------------
2206:
2207: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2208: THEN
2209: fnd_log.string
2210: (
2211: fnd_log.level_statement
2205: ------------------------------------------------------------------------------
2206:
2207: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2208: THEN
2209: fnd_log.string
2210: (
2211: fnd_log.level_statement
2212: , L_LOG_MODULE || 'del_cont_ext_aud_start'
2213: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'
2207: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2208: THEN
2209: fnd_log.string
2210: (
2211: fnd_log.level_statement
2212: , L_LOG_MODULE || 'del_cont_ext_aud_start'
2213: , 'Deleting data from table CS_SR_CONTACTS_EXT_AUDIT'
2214: );
2215: END IF ;
2237: );
2238:
2239: l_row_count := SQL%ROWCOUNT;
2240:
2241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2242: THEN
2243: fnd_log.string
2244: (
2245: fnd_log.level_statement
2239: l_row_count := SQL%ROWCOUNT;
2240:
2241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2242: THEN
2243: fnd_log.string
2244: (
2245: fnd_log.level_statement
2246: , L_LOG_MODULE || 'del_cont_ext_aud_end'
2247: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '
2241: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2242: THEN
2243: fnd_log.string
2244: (
2245: fnd_log.level_statement
2246: , L_LOG_MODULE || 'del_cont_ext_aud_end'
2247: , 'After deleting data from table CS_SR_CONTACTS_EXT_AUDIT '
2248: || l_row_count || ' rows'
2249: );
2250: END IF ;
2251:
2252: ---
2253:
2254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2255: THEN
2256: fnd_log.string
2257: (
2258: fnd_log.level_statement
2252: ---
2253:
2254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2255: THEN
2256: fnd_log.string
2257: (
2258: fnd_log.level_statement
2259: , L_LOG_MODULE || 'del_cont_ext_start'
2260: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'
2254: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2255: THEN
2256: fnd_log.string
2257: (
2258: fnd_log.level_statement
2259: , L_LOG_MODULE || 'del_cont_ext_start'
2260: , 'Deleting data from table CS_SR_CONTACTS_EXT_TL'
2261: );
2262: END IF ;
2279: );
2280:
2281: l_row_count := SQL%ROWCOUNT;
2282:
2283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2284: THEN
2285: fnd_log.string
2286: (
2287: fnd_log.level_statement
2281: l_row_count := SQL%ROWCOUNT;
2282:
2283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2284: THEN
2285: fnd_log.string
2286: (
2287: fnd_log.level_statement
2288: , L_LOG_MODULE || 'del_cont_ext_end'
2289: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '
2283: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2284: THEN
2285: fnd_log.string
2286: (
2287: fnd_log.level_statement
2288: , L_LOG_MODULE || 'del_cont_ext_end'
2289: , 'After deleting data from table CS_SR_CONTACTS_EXT_TL '
2290: || l_row_count || ' rows'
2291: );
2292: END IF ;
2293:
2294: ---
2295:
2296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2297: THEN
2298: fnd_log.string
2299: (
2300: fnd_log.level_statement
2294: ---
2295:
2296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2297: THEN
2298: fnd_log.string
2299: (
2300: fnd_log.level_statement
2301: , L_LOG_MODULE || 'del_cont_ext_start'
2302: , 'Deleting data from table CS_SR_CONTACTS_EXT'
2296: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2297: THEN
2298: fnd_log.string
2299: (
2300: fnd_log.level_statement
2301: , L_LOG_MODULE || 'del_cont_ext_start'
2302: , 'Deleting data from table CS_SR_CONTACTS_EXT'
2303: );
2304: END IF ;
2321: );
2322:
2323: l_row_count := SQL%ROWCOUNT;
2324:
2325: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2326: THEN
2327: fnd_log.string
2328: (
2329: fnd_log.level_statement
2323: l_row_count := SQL%ROWCOUNT;
2324:
2325: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2326: THEN
2327: fnd_log.string
2328: (
2329: fnd_log.level_statement
2330: , L_LOG_MODULE || 'del_cont_ext_end'
2331: , 'After deleting data from table CS_SR_CONTACTS_EXT '
2325: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2326: THEN
2327: fnd_log.string
2328: (
2329: fnd_log.level_statement
2330: , L_LOG_MODULE || 'del_cont_ext_end'
2331: , 'After deleting data from table CS_SR_CONTACTS_EXT '
2332: || l_row_count || ' rows'
2333: );
2334: END IF ;
2335:
2336: ---
2337:
2338: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2339: THEN
2340: fnd_log.string
2341: (
2342: fnd_log.level_statement
2336: ---
2337:
2338: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2339: THEN
2340: fnd_log.string
2341: (
2342: fnd_log.level_statement
2343: , L_LOG_MODULE || 'del_cont_point_aud_start'
2344: , 'Deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT'
2338: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2339: THEN
2340: fnd_log.string
2341: (
2342: fnd_log.level_statement
2343: , L_LOG_MODULE || 'del_cont_point_aud_start'
2344: , 'Deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT'
2345: );
2346: END IF ;
2363: );
2364:
2365: l_row_count := SQL%ROWCOUNT;
2366:
2367: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2368: THEN
2369: fnd_log.string
2370: (
2371: fnd_log.level_statement
2365: l_row_count := SQL%ROWCOUNT;
2366:
2367: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2368: THEN
2369: fnd_log.string
2370: (
2371: fnd_log.level_statement
2372: , L_LOG_MODULE || 'del_cont_point_aud_end'
2373: , 'After deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT '
2367: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2368: THEN
2369: fnd_log.string
2370: (
2371: fnd_log.level_statement
2372: , L_LOG_MODULE || 'del_cont_point_aud_end'
2373: , 'After deleting data from table CS_HZ_SR_CONTACT_PNTS_AUDIT '
2374: || l_row_count || ' rows'
2375: );
2376: END IF ;
2377:
2378: ---
2379:
2380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2381: THEN
2382: fnd_log.string
2383: (
2384: fnd_log.level_statement
2378: ---
2379:
2380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2381: THEN
2382: fnd_log.string
2383: (
2384: fnd_log.level_statement
2385: , L_LOG_MODULE || 'del_cont_point_start'
2386: , 'Deleting data from table CS_HZ_SR_CONTACT_POINTS'
2380: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2381: THEN
2382: fnd_log.string
2383: (
2384: fnd_log.level_statement
2385: , L_LOG_MODULE || 'del_cont_point_start'
2386: , 'Deleting data from table CS_HZ_SR_CONTACT_POINTS'
2387: );
2388: END IF ;
2403: AND NVL(purge_status, 'S') = 'S'
2404: );
2405: l_row_count := SQL%ROWCOUNT;
2406:
2407: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2408: THEN
2409: fnd_log.string
2410: (
2411: fnd_log.level_statement
2405: l_row_count := SQL%ROWCOUNT;
2406:
2407: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2408: THEN
2409: fnd_log.string
2410: (
2411: fnd_log.level_statement
2412: , L_LOG_MODULE || 'del_cont_point_end'
2413: , 'After deleting data from table CS_HZ_SR_CONTACT_POINTS '
2407: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2408: THEN
2409: fnd_log.string
2410: (
2411: fnd_log.level_statement
2412: , L_LOG_MODULE || 'del_cont_point_end'
2413: , 'After deleting data from table CS_HZ_SR_CONTACT_POINTS '
2414: || l_row_count || ' rows'
2415: );
2416: END IF ;
2417:
2418: ---
2419:
2420: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2421: THEN
2422: fnd_log.string
2423: (
2424: fnd_log.level_procedure
2418: ---
2419:
2420: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2421: THEN
2422: fnd_log.string
2423: (
2424: fnd_log.level_procedure
2425: , L_LOG_MODULE || 'end'
2426: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2420: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2421: THEN
2422: fnd_log.string
2423: (
2424: fnd_log.level_procedure
2425: , L_LOG_MODULE || 'end'
2426: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2427: || x_return_status
2428: );
2432:
2433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2435:
2436: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2437: THEN
2438: fnd_log.string
2439: (
2440: fnd_log.level_unexpected
2434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2435:
2436: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2437: THEN
2438: fnd_log.string
2439: (
2440: fnd_log.level_unexpected
2441: , L_LOG_MODULE || 'unexpected_error'
2442: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2436: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2437: THEN
2438: fnd_log.string
2439: (
2440: fnd_log.level_unexpected
2441: , L_LOG_MODULE || 'unexpected_error'
2442: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2443: );
2444: END IF ;
2449: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2450: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2451: FND_MSG_PUB.ADD;
2452:
2453: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2454: THEN
2455: fnd_log.string
2456: (
2457: fnd_log.level_unexpected
2451: FND_MSG_PUB.ADD;
2452:
2453: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2454: THEN
2455: fnd_log.string
2456: (
2457: fnd_log.level_unexpected
2458: , L_LOG_MODULE || 'when_others'
2459: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2453: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2454: THEN
2455: fnd_log.string
2456: (
2457: fnd_log.level_unexpected
2458: , L_LOG_MODULE || 'when_others'
2459: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2460: );
2461: fnd_log.string
2457: fnd_log.level_unexpected
2458: , L_LOG_MODULE || 'when_others'
2459: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2460: );
2461: fnd_log.string
2462: (
2463: fnd_log.level_unexpected
2464: , L_LOG_MODULE || 'when_others'
2465: , SQLERRM
2459: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2460: );
2461: fnd_log.string
2462: (
2463: fnd_log.level_unexpected
2464: , L_LOG_MODULE || 'when_others'
2465: , SQLERRM
2466: );
2467: END IF ;
2524:
2525: BEGIN
2526: x_return_status := FND_API.G_RET_STS_SUCCESS;
2527:
2528: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2529: THEN
2530: fnd_log.string
2531: (
2532: fnd_log.level_procedure
2526: x_return_status := FND_API.G_RET_STS_SUCCESS;
2527:
2528: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2529: THEN
2530: fnd_log.string
2531: (
2532: fnd_log.level_procedure
2533: , L_LOG_MODULE || 'start'
2534: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2528: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2529: THEN
2530: fnd_log.string
2531: (
2532: fnd_log.level_procedure
2533: , L_LOG_MODULE || 'start'
2534: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2535: );
2536: fnd_log.string
2532: fnd_log.level_procedure
2533: , L_LOG_MODULE || 'start'
2534: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2535: );
2536: fnd_log.string
2537: (
2538: fnd_log.level_procedure
2539: , L_LOG_MODULE || 'param 1'
2540: , 'p_api_version_number:' || p_api_version_number
2534: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2535: );
2536: fnd_log.string
2537: (
2538: fnd_log.level_procedure
2539: , L_LOG_MODULE || 'param 1'
2540: , 'p_api_version_number:' || p_api_version_number
2541: );
2542: fnd_log.string
2538: fnd_log.level_procedure
2539: , L_LOG_MODULE || 'param 1'
2540: , 'p_api_version_number:' || p_api_version_number
2541: );
2542: fnd_log.string
2543: (
2544: fnd_log.level_procedure
2545: , L_LOG_MODULE || 'param 2'
2546: , 'p_init_msg_list:' || p_init_msg_list
2540: , 'p_api_version_number:' || p_api_version_number
2541: );
2542: fnd_log.string
2543: (
2544: fnd_log.level_procedure
2545: , L_LOG_MODULE || 'param 2'
2546: , 'p_init_msg_list:' || p_init_msg_list
2547: );
2548: fnd_log.string
2544: fnd_log.level_procedure
2545: , L_LOG_MODULE || 'param 2'
2546: , 'p_init_msg_list:' || p_init_msg_list
2547: );
2548: fnd_log.string
2549: (
2550: fnd_log.level_procedure
2551: , L_LOG_MODULE || 'param 3'
2552: , 'p_commit:' || p_commit
2546: , 'p_init_msg_list:' || p_init_msg_list
2547: );
2548: fnd_log.string
2549: (
2550: fnd_log.level_procedure
2551: , L_LOG_MODULE || 'param 3'
2552: , 'p_commit:' || p_commit
2553: );
2554: fnd_log.string
2550: fnd_log.level_procedure
2551: , L_LOG_MODULE || 'param 3'
2552: , 'p_commit:' || p_commit
2553: );
2554: fnd_log.string
2555: (
2556: fnd_log.level_procedure
2557: , L_LOG_MODULE || 'param 4'
2558: , 'p_object_type:' || p_object_type
2552: , 'p_commit:' || p_commit
2553: );
2554: fnd_log.string
2555: (
2556: fnd_log.level_procedure
2557: , L_LOG_MODULE || 'param 4'
2558: , 'p_object_type:' || p_object_type
2559: );
2560: fnd_log.string
2556: fnd_log.level_procedure
2557: , L_LOG_MODULE || 'param 4'
2558: , 'p_object_type:' || p_object_type
2559: );
2560: fnd_log.string
2561: (
2562: fnd_log.level_procedure
2563: , L_LOG_MODULE || 'param 5'
2564: , 'p_processing_set_id:' || p_processing_set_id
2558: , 'p_object_type:' || p_object_type
2559: );
2560: fnd_log.string
2561: (
2562: fnd_log.level_procedure
2563: , L_LOG_MODULE || 'param 5'
2564: , 'p_processing_set_id:' || p_processing_set_id
2565: );
2566: END IF ;
2590: ------------------------------------------------------------------------------
2591: -- Actual Logic starts below:
2592: ------------------------------------------------------------------------------
2593:
2594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2595: THEN
2596: fnd_log.string
2597: (
2598: fnd_log.level_statement
2592: ------------------------------------------------------------------------------
2593:
2594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2595: THEN
2596: fnd_log.string
2597: (
2598: fnd_log.level_statement
2599: , L_LOG_MODULE || 'del_sraudit_tl_start'
2600: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'
2594: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2595: THEN
2596: fnd_log.string
2597: (
2598: fnd_log.level_statement
2599: , L_LOG_MODULE || 'del_sraudit_tl_start'
2600: , 'Deleting data from table CS_INCIDENTS_AUDIT_TL'
2601: );
2602: END IF ;
2618: );
2619:
2620: l_row_count := SQL%ROWCOUNT;
2621:
2622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2623: THEN
2624: fnd_log.string
2625: (
2626: fnd_log.level_statement
2620: l_row_count := SQL%ROWCOUNT;
2621:
2622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2623: THEN
2624: fnd_log.string
2625: (
2626: fnd_log.level_statement
2627: , L_LOG_MODULE || 'del_sraudit_tl_end'
2628: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '
2622: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2623: THEN
2624: fnd_log.string
2625: (
2626: fnd_log.level_statement
2627: , L_LOG_MODULE || 'del_sraudit_tl_end'
2628: , 'After deleting data from table CS_INCIDENTS_AUDIT_TL '
2629: || l_row_count || ' rows'
2630: );
2631: END IF ;
2632:
2633: ---
2634:
2635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2636: THEN
2637: fnd_log.string
2638: (
2639: fnd_log.level_statement
2633: ---
2634:
2635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2636: THEN
2637: fnd_log.string
2638: (
2639: fnd_log.level_statement
2640: , L_LOG_MODULE || 'del_sraudit_b_start'
2641: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'
2635: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2636: THEN
2637: fnd_log.string
2638: (
2639: fnd_log.level_statement
2640: , L_LOG_MODULE || 'del_sraudit_b_start'
2641: , 'Deleting data from table CS_INCIDENTS_AUDIT_B'
2642: );
2643: END IF ;
2659: );
2660:
2661: l_row_count := SQL%ROWCOUNT;
2662:
2663: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2664: THEN
2665: fnd_log.string
2666: (
2667: fnd_log.level_statement
2661: l_row_count := SQL%ROWCOUNT;
2662:
2663: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2664: THEN
2665: fnd_log.string
2666: (
2667: fnd_log.level_statement
2668: , L_LOG_MODULE || 'del_sraudit_b_end'
2669: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '
2663: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2664: THEN
2665: fnd_log.string
2666: (
2667: fnd_log.level_statement
2668: , L_LOG_MODULE || 'del_sraudit_b_end'
2669: , 'After deleting data from table CS_INCIDENTS_AUDIT_B '
2670: || l_row_count || ' rows'
2671: );
2672: END IF ;
2673:
2674: ---
2675:
2676: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2677: THEN
2678: fnd_log.string
2679: (
2680: fnd_log.level_procedure
2674: ---
2675:
2676: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2677: THEN
2678: fnd_log.string
2679: (
2680: fnd_log.level_procedure
2681: , L_LOG_MODULE || 'end'
2682: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2676: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2677: THEN
2678: fnd_log.string
2679: (
2680: fnd_log.level_procedure
2681: , L_LOG_MODULE || 'end'
2682: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
2683: || x_return_status
2684: );
2688:
2689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2691:
2692: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string
2695: (
2696: fnd_log.level_unexpected
2690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2691:
2692: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string
2695: (
2696: fnd_log.level_unexpected
2697: , L_LOG_MODULE || 'unexpected_error'
2698: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2692: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2693: THEN
2694: fnd_log.string
2695: (
2696: fnd_log.level_unexpected
2697: , L_LOG_MODULE || 'unexpected_error'
2698: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
2699: );
2700: END IF ;
2705: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
2706: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
2707: FND_MSG_PUB.ADD;
2708:
2709: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2710: THEN
2711: fnd_log.string
2712: (
2713: fnd_log.level_unexpected
2707: FND_MSG_PUB.ADD;
2708:
2709: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2710: THEN
2711: fnd_log.string
2712: (
2713: fnd_log.level_unexpected
2714: , L_LOG_MODULE || 'when_others'
2715: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2709: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
2710: THEN
2711: fnd_log.string
2712: (
2713: fnd_log.level_unexpected
2714: , L_LOG_MODULE || 'when_others'
2715: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2716: );
2717: fnd_log.string
2713: fnd_log.level_unexpected
2714: , L_LOG_MODULE || 'when_others'
2715: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2716: );
2717: fnd_log.string
2718: (
2719: fnd_log.level_unexpected
2720: , L_LOG_MODULE || 'when_others'
2721: , SQLERRM
2715: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
2716: );
2717: fnd_log.string
2718: (
2719: fnd_log.level_unexpected
2720: , L_LOG_MODULE || 'when_others'
2721: , SQLERRM
2722: );
2723: END IF ;
2781:
2782: BEGIN
2783: x_return_status := FND_API.G_RET_STS_SUCCESS;
2784:
2785: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2786: THEN
2787: fnd_log.string
2788: (
2789: fnd_log.level_procedure
2783: x_return_status := FND_API.G_RET_STS_SUCCESS;
2784:
2785: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2786: THEN
2787: fnd_log.string
2788: (
2789: fnd_log.level_procedure
2790: , L_LOG_MODULE || 'start'
2791: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2785: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2786: THEN
2787: fnd_log.string
2788: (
2789: fnd_log.level_procedure
2790: , L_LOG_MODULE || 'start'
2791: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2792: );
2793: fnd_log.string
2789: fnd_log.level_procedure
2790: , L_LOG_MODULE || 'start'
2791: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2792: );
2793: fnd_log.string
2794: (
2795: fnd_log.level_procedure
2796: , L_LOG_MODULE || 'param 1'
2797: , 'p_api_version_number:' || p_api_version_number
2791: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
2792: );
2793: fnd_log.string
2794: (
2795: fnd_log.level_procedure
2796: , L_LOG_MODULE || 'param 1'
2797: , 'p_api_version_number:' || p_api_version_number
2798: );
2799: fnd_log.string
2795: fnd_log.level_procedure
2796: , L_LOG_MODULE || 'param 1'
2797: , 'p_api_version_number:' || p_api_version_number
2798: );
2799: fnd_log.string
2800: (
2801: fnd_log.level_procedure
2802: , L_LOG_MODULE || 'param 2'
2803: , 'p_init_msg_list:' || p_init_msg_list
2797: , 'p_api_version_number:' || p_api_version_number
2798: );
2799: fnd_log.string
2800: (
2801: fnd_log.level_procedure
2802: , L_LOG_MODULE || 'param 2'
2803: , 'p_init_msg_list:' || p_init_msg_list
2804: );
2805: fnd_log.string
2801: fnd_log.level_procedure
2802: , L_LOG_MODULE || 'param 2'
2803: , 'p_init_msg_list:' || p_init_msg_list
2804: );
2805: fnd_log.string
2806: (
2807: fnd_log.level_procedure
2808: , L_LOG_MODULE || 'param 3'
2809: , 'p_commit:' || p_commit
2803: , 'p_init_msg_list:' || p_init_msg_list
2804: );
2805: fnd_log.string
2806: (
2807: fnd_log.level_procedure
2808: , L_LOG_MODULE || 'param 3'
2809: , 'p_commit:' || p_commit
2810: );
2811: fnd_log.string
2807: fnd_log.level_procedure
2808: , L_LOG_MODULE || 'param 3'
2809: , 'p_commit:' || p_commit
2810: );
2811: fnd_log.string
2812: (
2813: fnd_log.level_procedure
2814: , L_LOG_MODULE || 'param 4'
2815: , 'p_object_type:' || p_object_type
2809: , 'p_commit:' || p_commit
2810: );
2811: fnd_log.string
2812: (
2813: fnd_log.level_procedure
2814: , L_LOG_MODULE || 'param 4'
2815: , 'p_object_type:' || p_object_type
2816: );
2817: fnd_log.string
2813: fnd_log.level_procedure
2814: , L_LOG_MODULE || 'param 4'
2815: , 'p_object_type:' || p_object_type
2816: );
2817: fnd_log.string
2818: (
2819: fnd_log.level_procedure
2820: , L_LOG_MODULE || 'param 5'
2821: , 'p_processing_set_id:' || p_processing_set_id
2815: , 'p_object_type:' || p_object_type
2816: );
2817: fnd_log.string
2818: (
2819: fnd_log.level_procedure
2820: , L_LOG_MODULE || 'param 5'
2821: , 'p_processing_set_id:' || p_processing_set_id
2822: );
2823: END IF ;
2847: ------------------------------------------------------------------------------
2848: -- Actual Logic starts below:
2849: ------------------------------------------------------------------------------
2850:
2851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2852: THEN
2853: fnd_log.string
2854: (
2855: fnd_log.level_statement
2849: ------------------------------------------------------------------------------
2850:
2851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2852: THEN
2853: fnd_log.string
2854: (
2855: fnd_log.level_statement
2856: , L_LOG_MODULE || 'cug_attr_tl_del_start'
2857: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'
2851: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2852: THEN
2853: fnd_log.string
2854: (
2855: fnd_log.level_statement
2856: , L_LOG_MODULE || 'cug_attr_tl_del_start'
2857: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_TL'
2858: );
2859: END IF ;
2877: );
2878:
2879: l_row_count := SQL%ROWCOUNT;
2880:
2881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2882: THEN
2883: fnd_log.string
2884: (
2885: fnd_log.level_statement
2879: l_row_count := SQL%ROWCOUNT;
2880:
2881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2882: THEN
2883: fnd_log.string
2884: (
2885: fnd_log.level_statement
2886: , L_LOG_MODULE || 'cug_attr_tl_del_end'
2887: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '
2881: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2882: THEN
2883: fnd_log.string
2884: (
2885: fnd_log.level_statement
2886: , L_LOG_MODULE || 'cug_attr_tl_del_end'
2887: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_TL '
2888: || l_row_count || ' rows'
2889: );
2890: END IF ;
2891:
2892: ---
2893:
2894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2895: THEN
2896: fnd_log.string
2897: (
2898: fnd_log.level_statement
2892: ---
2893:
2894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2895: THEN
2896: fnd_log.string
2897: (
2898: fnd_log.level_statement
2899: , L_LOG_MODULE || 'cug_attr_b_del_start'
2900: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_B'
2894: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2895: THEN
2896: fnd_log.string
2897: (
2898: fnd_log.level_statement
2899: , L_LOG_MODULE || 'cug_attr_b_del_start'
2900: , 'Deleting data from table CUG_INCIDNT_ATTR_VALS_B'
2901: );
2902: END IF ;
2918: );
2919:
2920: l_row_count := SQL%ROWCOUNT;
2921:
2922: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2923: THEN
2924: fnd_log.string
2925: (
2926: fnd_log.level_statement
2920: l_row_count := SQL%ROWCOUNT;
2921:
2922: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2923: THEN
2924: fnd_log.string
2925: (
2926: fnd_log.level_statement
2927: , L_LOG_MODULE || 'cug_attr_b_del_end'
2928: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_B '
2922: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2923: THEN
2924: fnd_log.string
2925: (
2926: fnd_log.level_statement
2927: , L_LOG_MODULE || 'cug_attr_b_del_end'
2928: , 'After deleting data from table CUG_INCIDNT_ATTR_VALS_B '
2929: || l_row_count || ' rows'
2930: );
2931: END IF ;
2932:
2933: ---
2934:
2935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2936: THEN
2937: fnd_log.string
2938: (
2939: fnd_log.level_statement
2933: ---
2934:
2935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2936: THEN
2937: fnd_log.string
2938: (
2939: fnd_log.level_statement
2940: , L_LOG_MODULE || 'sr_ext_attr_aud_del_start'
2941: , 'Deleting data from table CS_INCIDENTS_EXT_AUDIT'
2935: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2936: THEN
2937: fnd_log.string
2938: (
2939: fnd_log.level_statement
2940: , L_LOG_MODULE || 'sr_ext_attr_aud_del_start'
2941: , 'Deleting data from table CS_INCIDENTS_EXT_AUDIT'
2942: );
2943: END IF ;
2962: );
2963:
2964: l_row_count := SQL%ROWCOUNT;
2965:
2966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2967: THEN
2968: fnd_log.string
2969: (
2970: fnd_log.level_statement
2964: l_row_count := SQL%ROWCOUNT;
2965:
2966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2967: THEN
2968: fnd_log.string
2969: (
2970: fnd_log.level_statement
2971: , L_LOG_MODULE || 'sr_ext_attr_aud_del_end'
2972: , 'After deleting data from table CS_INCIDENTS_EXT_AUDIT '
2966: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2967: THEN
2968: fnd_log.string
2969: (
2970: fnd_log.level_statement
2971: , L_LOG_MODULE || 'sr_ext_attr_aud_del_end'
2972: , 'After deleting data from table CS_INCIDENTS_EXT_AUDIT '
2973: || l_row_count || ' rows'
2974: );
2975: END IF ;
2976:
2977: ---
2978:
2979: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2980: THEN
2981: fnd_log.string
2982: (
2983: fnd_log.level_statement
2977: ---
2978:
2979: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2980: THEN
2981: fnd_log.string
2982: (
2983: fnd_log.level_statement
2984: , L_LOG_MODULE || 'sr_ext_attr_del_start'
2985: , 'Deleting data from table CS_INCIDENTS_EXT_TL'
2979: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
2980: THEN
2981: fnd_log.string
2982: (
2983: fnd_log.level_statement
2984: , L_LOG_MODULE || 'sr_ext_attr_del_start'
2985: , 'Deleting data from table CS_INCIDENTS_EXT_TL'
2986: );
2987: END IF ;
3004: );
3005:
3006: l_row_count := SQL%ROWCOUNT;
3007:
3008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3009: THEN
3010: fnd_log.string
3011: (
3012: fnd_log.level_statement
3006: l_row_count := SQL%ROWCOUNT;
3007:
3008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3009: THEN
3010: fnd_log.string
3011: (
3012: fnd_log.level_statement
3013: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3014: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3008: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3009: THEN
3010: fnd_log.string
3011: (
3012: fnd_log.level_statement
3013: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3014: , 'After deleting data from table CS_INCIDENTS_EXT_TL '
3015: || l_row_count || ' rows'
3016: );
3017: END IF ;
3018:
3019: ---
3020:
3021: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3022: THEN
3023: fnd_log.string
3024: (
3025: fnd_log.level_statement
3019: ---
3020:
3021: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3022: THEN
3023: fnd_log.string
3024: (
3025: fnd_log.level_statement
3026: , L_LOG_MODULE || 'sr_ext_attr_del_start'
3027: , 'Deleting data from table CS_INCIDENTS_EXT'
3021: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3022: THEN
3023: fnd_log.string
3024: (
3025: fnd_log.level_statement
3026: , L_LOG_MODULE || 'sr_ext_attr_del_start'
3027: , 'Deleting data from table CS_INCIDENTS_EXT'
3028: );
3029: END IF ;
3046: );
3047:
3048: l_row_count := SQL%ROWCOUNT;
3049:
3050: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3051: THEN
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement
3048: l_row_count := SQL%ROWCOUNT;
3049:
3050: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3051: THEN
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement
3055: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3056: , 'After deleting data from table CS_INCIDENTS_EXT '
3050: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3051: THEN
3052: fnd_log.string
3053: (
3054: fnd_log.level_statement
3055: , L_LOG_MODULE || 'sr_ext_attr_del_end'
3056: , 'After deleting data from table CS_INCIDENTS_EXT '
3057: || l_row_count || ' rows'
3058: );
3059: END IF ;
3060:
3061: ---
3062:
3063: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3064: THEN
3065: fnd_log.string
3066: (
3067: fnd_log.level_procedure
3061: ---
3062:
3063: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3064: THEN
3065: fnd_log.string
3066: (
3067: fnd_log.level_procedure
3068: , L_LOG_MODULE || 'end'
3069: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3063: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3064: THEN
3065: fnd_log.string
3066: (
3067: fnd_log.level_procedure
3068: , L_LOG_MODULE || 'end'
3069: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3070: || x_return_status
3071: );
3075:
3076: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3078:
3079: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3080: THEN
3081: fnd_log.string
3082: (
3083: fnd_log.level_unexpected
3077: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3078:
3079: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3080: THEN
3081: fnd_log.string
3082: (
3083: fnd_log.level_unexpected
3084: , L_LOG_MODULE || 'unexpected_error'
3085: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3079: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3080: THEN
3081: fnd_log.string
3082: (
3083: fnd_log.level_unexpected
3084: , L_LOG_MODULE || 'unexpected_error'
3085: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3086: );
3087: END IF ;
3092: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3093: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3094: FND_MSG_PUB.ADD;
3095:
3096: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3097: THEN
3098: fnd_log.string
3099: (
3100: fnd_log.level_unexpected
3094: FND_MSG_PUB.ADD;
3095:
3096: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3097: THEN
3098: fnd_log.string
3099: (
3100: fnd_log.level_unexpected
3101: , L_LOG_MODULE || 'when_others'
3102: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3096: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3097: THEN
3098: fnd_log.string
3099: (
3100: fnd_log.level_unexpected
3101: , L_LOG_MODULE || 'when_others'
3102: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3103: );
3104: fnd_log.string
3100: fnd_log.level_unexpected
3101: , L_LOG_MODULE || 'when_others'
3102: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3103: );
3104: fnd_log.string
3105: (
3106: fnd_log.level_unexpected
3107: , L_LOG_MODULE || 'when_others'
3108: , SQLERRM
3102: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3103: );
3104: fnd_log.string
3105: (
3106: fnd_log.level_unexpected
3107: , L_LOG_MODULE || 'when_others'
3108: , SQLERRM
3109: );
3110: END IF ;
3246:
3247: BEGIN
3248: x_return_status := FND_API.G_RET_STS_SUCCESS;
3249:
3250: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3251: THEN
3252: fnd_log.string
3253: (
3254: fnd_log.level_procedure
3248: x_return_status := FND_API.G_RET_STS_SUCCESS;
3249:
3250: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3251: THEN
3252: fnd_log.string
3253: (
3254: fnd_log.level_procedure
3255: , L_LOG_MODULE || 'start'
3256: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3250: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3251: THEN
3252: fnd_log.string
3253: (
3254: fnd_log.level_procedure
3255: , L_LOG_MODULE || 'start'
3256: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3257: );
3258: fnd_log.string
3254: fnd_log.level_procedure
3255: , L_LOG_MODULE || 'start'
3256: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3257: );
3258: fnd_log.string
3259: (
3260: fnd_log.level_procedure
3261: , L_LOG_MODULE || 'param 1'
3262: , 'p_api_version_number:' || p_api_version_number
3256: , 'Inside ' || L_API_NAME_FULL || ', called with parameters below:'
3257: );
3258: fnd_log.string
3259: (
3260: fnd_log.level_procedure
3261: , L_LOG_MODULE || 'param 1'
3262: , 'p_api_version_number:' || p_api_version_number
3263: );
3264: fnd_log.string
3260: fnd_log.level_procedure
3261: , L_LOG_MODULE || 'param 1'
3262: , 'p_api_version_number:' || p_api_version_number
3263: );
3264: fnd_log.string
3265: (
3266: fnd_log.level_procedure
3267: , L_LOG_MODULE || 'param 2'
3268: , 'p_init_msg_list:' || p_init_msg_list
3262: , 'p_api_version_number:' || p_api_version_number
3263: );
3264: fnd_log.string
3265: (
3266: fnd_log.level_procedure
3267: , L_LOG_MODULE || 'param 2'
3268: , 'p_init_msg_list:' || p_init_msg_list
3269: );
3270: fnd_log.string
3266: fnd_log.level_procedure
3267: , L_LOG_MODULE || 'param 2'
3268: , 'p_init_msg_list:' || p_init_msg_list
3269: );
3270: fnd_log.string
3271: (
3272: fnd_log.level_procedure
3273: , L_LOG_MODULE || 'param 3'
3274: , 'p_commit:' || p_commit
3268: , 'p_init_msg_list:' || p_init_msg_list
3269: );
3270: fnd_log.string
3271: (
3272: fnd_log.level_procedure
3273: , L_LOG_MODULE || 'param 3'
3274: , 'p_commit:' || p_commit
3275: );
3276: fnd_log.string
3272: fnd_log.level_procedure
3273: , L_LOG_MODULE || 'param 3'
3274: , 'p_commit:' || p_commit
3275: );
3276: fnd_log.string
3277: (
3278: fnd_log.level_procedure
3279: , L_LOG_MODULE || 'param 4'
3280: , 'p_purge_set_id' || p_purge_set_id
3274: , 'p_commit:' || p_commit
3275: );
3276: fnd_log.string
3277: (
3278: fnd_log.level_procedure
3279: , L_LOG_MODULE || 'param 4'
3280: , 'p_purge_set_id' || p_purge_set_id
3281: );
3282: END IF ;
3310: ------------------------------------------------------------------------------
3311:
3312: IF p_incident_id_tbl.COUNT > 0
3313: THEN
3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3315: THEN
3316: fnd_log.string
3317: (
3318: fnd_log.level_statement
3312: IF p_incident_id_tbl.COUNT > 0
3313: THEN
3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3315: THEN
3316: fnd_log.string
3317: (
3318: fnd_log.level_statement
3319: , L_LOG_MODULE || 'ins_purge_aud_b_start'
3320: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_B'
3314: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3315: THEN
3316: fnd_log.string
3317: (
3318: fnd_log.level_statement
3319: , L_LOG_MODULE || 'ins_purge_aud_b_start'
3320: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_B'
3321: );
3322: END IF ;
3366: );
3367:
3368: l_row_count := SQL%ROWCOUNT;
3369:
3370: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3371: THEN
3372: fnd_log.string
3373: (
3374: fnd_log.level_statement
3368: l_row_count := SQL%ROWCOUNT;
3369:
3370: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3371: THEN
3372: fnd_log.string
3373: (
3374: fnd_log.level_statement
3375: , L_LOG_MODULE || 'ins_purge_aud_b_end'
3376: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3370: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3371: THEN
3372: fnd_log.string
3373: (
3374: fnd_log.level_statement
3375: , L_LOG_MODULE || 'ins_purge_aud_b_end'
3376: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3377: || l_row_count || ' rows'
3378: );
3378: );
3379: END IF ;
3380: ELSIF p_incident_id_tbl.COUNT <= 0
3381: THEN
3382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3383: THEN
3384: fnd_log.string
3385: (
3386: fnd_log.level_statement
3380: ELSIF p_incident_id_tbl.COUNT <= 0
3381: THEN
3382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3383: THEN
3384: fnd_log.string
3385: (
3386: fnd_log.level_statement
3387: , L_LOG_MODULE || 'ins_purge_aud_b_err'
3388: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3382: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3383: THEN
3384: fnd_log.string
3385: (
3386: fnd_log.level_statement
3387: , L_LOG_MODULE || 'ins_purge_aud_b_err'
3388: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_B '
3389: || 'p_incident_id_tbl had ' || p_incident_id_tbl.COUNT || ' rows'
3390: );
3392: END IF;
3393:
3394: IF p_incident_id_tl_tbl.COUNT > 0
3395: THEN
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3397: THEN
3398: fnd_log.string
3399: (
3400: fnd_log.level_statement
3394: IF p_incident_id_tl_tbl.COUNT > 0
3395: THEN
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3397: THEN
3398: fnd_log.string
3399: (
3400: fnd_log.level_statement
3401: , L_LOG_MODULE || 'ins_purge_aud_tl_start'
3402: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL'
3396: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3397: THEN
3398: fnd_log.string
3399: (
3400: fnd_log.level_statement
3401: , L_LOG_MODULE || 'ins_purge_aud_tl_start'
3402: , 'Inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL'
3403: );
3404: END IF ;
3435: );
3436:
3437: l_row_count := SQL%ROWCOUNT;
3438:
3439: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3440: THEN
3441: fnd_log.string
3442: (
3443: fnd_log.level_statement
3437: l_row_count := SQL%ROWCOUNT;
3438:
3439: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3440: THEN
3441: fnd_log.string
3442: (
3443: fnd_log.level_statement
3444: , L_LOG_MODULE || 'ins_purge_aud_tl_end'
3445: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3439: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3440: THEN
3441: fnd_log.string
3442: (
3443: fnd_log.level_statement
3444: , L_LOG_MODULE || 'ins_purge_aud_tl_end'
3445: , 'After inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3446: || l_row_count || ' rows'
3447: );
3447: );
3448: END IF ;
3449: ELSIF p_incident_id_tl_tbl.COUNT <= 0
3450: THEN
3451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3452: THEN
3453: fnd_log.string
3454: (
3455: fnd_log.level_statement
3449: ELSIF p_incident_id_tl_tbl.COUNT <= 0
3450: THEN
3451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3452: THEN
3453: fnd_log.string
3454: (
3455: fnd_log.level_statement
3456: , L_LOG_MODULE || 'ins_purge_aud_tl_err'
3457: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3451: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3452: THEN
3453: fnd_log.string
3454: (
3455: fnd_log.level_statement
3456: , L_LOG_MODULE || 'ins_purge_aud_tl_err'
3457: , 'While inserting data into table CS_INCIDENTS_PURGE_AUDIT_TL '
3458: || 'p_incident_id_tl_tbl had ' || p_incident_id_tl_tbl.COUNT || ' rows'
3459: );
3459: );
3460: END IF ;
3461: END IF;
3462:
3463: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3464: THEN
3465: fnd_log.string
3466: (
3467: fnd_log.level_procedure
3461: END IF;
3462:
3463: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3464: THEN
3465: fnd_log.string
3466: (
3467: fnd_log.level_procedure
3468: , L_LOG_MODULE || 'end'
3469: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3463: IF fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3464: THEN
3465: fnd_log.string
3466: (
3467: fnd_log.level_procedure
3468: , L_LOG_MODULE || 'end'
3469: , 'Completed work in ' || L_API_NAME_FULL || ' with return status '
3470: || x_return_status
3471: );
3475:
3476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3478:
3479: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3480: THEN
3481: fnd_log.string
3482: (
3483: fnd_log.level_unexpected
3477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3478:
3479: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3480: THEN
3481: fnd_log.string
3482: (
3483: fnd_log.level_unexpected
3484: , L_LOG_MODULE || 'unexpected_error'
3485: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3479: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3480: THEN
3481: fnd_log.string
3482: (
3483: fnd_log.level_unexpected
3484: , L_LOG_MODULE || 'unexpected_error'
3485: , 'Inside WHEN FND_API.G_EXC_UNEXPECTED_ERROR of ' || L_API_NAME_FULL
3486: );
3487: END IF ;
3492: FND_MESSAGE.Set_Token('API_NAME', L_API_NAME_FULL);
3493: FND_MESSAGE.Set_Token('ERROR', SQLERRM);
3494: FND_MSG_PUB.ADD;
3495:
3496: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3497: THEN
3498: fnd_log.string
3499: (
3500: fnd_log.level_unexpected
3494: FND_MSG_PUB.ADD;
3495:
3496: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3497: THEN
3498: fnd_log.string
3499: (
3500: fnd_log.level_unexpected
3501: , L_LOG_MODULE || 'when_others'
3502: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3496: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3497: THEN
3498: fnd_log.string
3499: (
3500: fnd_log.level_unexpected
3501: , L_LOG_MODULE || 'when_others'
3502: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3503: );
3504: fnd_log.string
3500: fnd_log.level_unexpected
3501: , L_LOG_MODULE || 'when_others'
3502: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3503: );
3504: fnd_log.string
3505: (
3506: fnd_log.level_unexpected
3507: , L_LOG_MODULE || 'when_others'
3508: , SQLERRM
3502: , 'Inside WHEN OTHERS of ' || L_API_NAME_FULL || '. Oracle Error was:'
3503: );
3504: fnd_log.string
3505: (
3506: fnd_log.level_unexpected
3507: , L_LOG_MODULE || 'when_others'
3508: , SQLERRM
3509: );
3510: END IF ;
3579: -- If the user terminates the concurrent request
3580: -- raise an exception and add a message to the stack
3581:
3582: THEN
3583: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3584: THEN
3585: fnd_log.string
3586: (
3587: fnd_log.level_statement
3581:
3582: THEN
3583: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3584: THEN
3585: fnd_log.string
3586: (
3587: fnd_log.level_statement
3588: , L_LOG_MODULE || 'conc_req_user_stop'
3589: , 'This concurrent request is in status ' || l_dev_status
3583: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level
3584: THEN
3585: fnd_log.string
3586: (
3587: fnd_log.level_statement
3588: , L_LOG_MODULE || 'conc_req_user_stop'
3589: , 'This concurrent request is in status ' || l_dev_status
3590: || ' and phase ' || l_dev_phase
3591: );
3607: END IF;
3608: ELSE
3609: -- if fnd_concurrent.get_request_status failed...
3610:
3611: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3612: THEN
3613: fnd_log.string
3614: (
3615: fnd_log.level_unexpected
3609: -- if fnd_concurrent.get_request_status failed...
3610:
3611: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3612: THEN
3613: fnd_log.string
3614: (
3615: fnd_log.level_unexpected
3616: , L_LOG_MODULE || 'conc_req_status_fail'
3617: , 'Failed while getting the status of this request'
3611: IF fnd_log.level_unexpected >= fnd_log.g_current_runtime_level
3612: THEN
3613: fnd_log.string
3614: (
3615: fnd_log.level_unexpected
3616: , L_LOG_MODULE || 'conc_req_status_fail'
3617: , 'Failed while getting the status of this request'
3618: );
3619: END IF ;