eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CAC_TASK_PURGE_PVT dependencies on CAC_TASK_PURGE_PVT

Line 1: PACKAGE BODY CAC_TASK_PURGE_PVT AS

1: PACKAGE BODY CAC_TASK_PURGE_PVT AS
2: /* $Header: cactkpvb.pls 120.18 2006/07/13 12:22:58 sbarat noship $ */
3: /*=======================================================================+
4: | Copyright (c) 2002 Oracle Corporation Redwood Shores, California, USA|
5: | All rights reserved. |

Line 154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'request_id = '||l_request_id);

150: -- Procedure level Logging
151: ----------------------------
152: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
153: THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'request_id = '||l_request_id);
155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'request_data = '||l_request_data);
156: END IF;
157:
158:

Line 155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'request_data = '||l_request_data);

151: ----------------------------
152: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
153: THEN
154: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'request_id = '||l_request_id);
155: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'request_data = '||l_request_data);
156: END IF;
157:
158:
159: IF l_request_data IS NULL

Line 167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_from = '||p_creation_date_from);

163: -- Procedure level Logging
164: ----------------------------
165: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
166: THEN
167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_from = '||p_creation_date_from);
168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_to = '||p_creation_date_to);
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);

Line 168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_to = '||p_creation_date_to);

164: ----------------------------
165: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
166: THEN
167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_from = '||p_creation_date_from);
168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_to = '||p_creation_date_to);
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);

Line 169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);

165: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
166: THEN
167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_from = '||p_creation_date_from);
168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_to = '||p_creation_date_to);
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);

Line 170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);

166: THEN
167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_from = '||p_creation_date_from);
168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_to = '||p_creation_date_to);
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);

Line 171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);

167: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_from = '||p_creation_date_from);
168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_to = '||p_creation_date_to);
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);

Line 172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);

168: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_creation_date_to = '||p_creation_date_to);
169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);

Line 173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);

169: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_from = '||p_last_updation_date_from);
170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);

Line 174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);

170: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_last_updation_date_to = '||p_last_updation_date_to);
171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);

Line 175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);

171: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_from = '||p_planned_end_date_from);
172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);

Line 176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);

172: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_planned_end_date_to = '||p_planned_end_date_to);
173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_deleted_task_only = '||p_delete_deleted_task_only);

Line 177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);

173: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_from = '||p_scheduled_end_date_from);
174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_deleted_task_only = '||p_delete_deleted_task_only);
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_no_of_worker = '||p_no_of_worker);

Line 178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);

174: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_scheduled_end_date_to = '||p_scheduled_end_date_to);
175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_deleted_task_only = '||p_delete_deleted_task_only);
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_no_of_worker = '||p_no_of_worker);
182: END IF;

Line 179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);

175: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_from = '||p_actual_end_date_from);
176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_deleted_task_only = '||p_delete_deleted_task_only);
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_no_of_worker = '||p_no_of_worker);
182: END IF;
183:

Line 180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_deleted_task_only = '||p_delete_deleted_task_only);

176: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_actual_end_date_to = '||p_actual_end_date_to);
177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_deleted_task_only = '||p_delete_deleted_task_only);
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_no_of_worker = '||p_no_of_worker);
182: END IF;
183:
184:

Line 181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_no_of_worker = '||p_no_of_worker);

177: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_type_id = '||p_task_type_id);
178: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_task_status_id = '||p_task_status_id);
179: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_closed_task_only = '||p_delete_closed_task_only);
180: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_delete_deleted_task_only = '||p_delete_deleted_task_only);
181: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'p_no_of_worker = '||p_no_of_worker);
182: END IF;
183:
184:
185: -- Converting all dates from VARCHAR2 to DATE datatype

Line 216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Deleting data from staging table - JTF_TASK_PURGE');

212: -- Statement level Logging
213: ----------------------------
214: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
215: THEN
216: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Deleting data from staging table - JTF_TASK_PURGE');
217: END IF;
218:
219:
220: -- Cleanup process: Delete all the rows in the staging table corresponding

Line 241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Checking whether environment is timezone enabled');

237: -- Statement level Logging
238: ----------------------------
239: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
240: THEN
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Checking whether environment is timezone enabled');
242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Enable Timezone Conversions = '||l_tz_enabled_prof);
243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Server Timezone = '||l_server_tz_id);
244: END IF;
245:

Line 242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Enable Timezone Conversions = '||l_tz_enabled_prof);

238: ----------------------------
239: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
240: THEN
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Checking whether environment is timezone enabled');
242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Enable Timezone Conversions = '||l_tz_enabled_prof);
243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Server Timezone = '||l_server_tz_id);
244: END IF;
245:
246: IF (NVL(l_tz_enabled_prof, 'N') = 'Y' AND l_server_tz_id IS NOT NULL)

Line 243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Server Timezone = '||l_server_tz_id);

239: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
240: THEN
241: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Checking whether environment is timezone enabled');
242: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Enable Timezone Conversions = '||l_tz_enabled_prof);
243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Profile value of Server Timezone = '||l_server_tz_id);
244: END IF;
245:
246: IF (NVL(l_tz_enabled_prof, 'N') = 'Y' AND l_server_tz_id IS NOT NULL)
247: THEN

Line 256: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Overall timezone status = '||l_tz_enabled);

252: -- Statement level Logging
253: ----------------------------
254: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
255: THEN
256: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Overall timezone status = '||l_tz_enabled);
257: END IF;
258:
259: ----------------------------
260: -- Statement level Logging

Line 264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Constructing dynamic select statement');

260: -- Statement level Logging
261: ----------------------------
262: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
263: THEN
264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Constructing dynamic select statement');
265: END IF;
266:
267:
268: -- constructing the query

Line 452: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Calling dynamic select statement = '||l_sql_string);

448: -- Statement level Logging
449: ----------------------------
450: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
451: THEN
452: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Calling dynamic select statement = '||l_sql_string);
453: END IF;
454:
455:
456: -- Open the cursor and fetch values in variables

Line 464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'No of fetched records = '||l_tab_task_id.count);

460: Close C_Cur_Ref;
461:
462: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
463: THEN
464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'No of fetched records = '||l_tab_task_id.count);
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Inserting data into staging table - JTF_TASK_PURGE');
466: END IF;
467:
468: -- Inserting values into JTF_TASK_PURGE

Line 465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Inserting data into staging table - JTF_TASK_PURGE');

461:
462: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
463: THEN
464: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'No of fetched records = '||l_tab_task_id.count);
465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Inserting data into staging table - JTF_TASK_PURGE');
466: END IF;
467:
468: -- Inserting values into JTF_TASK_PURGE
469:

Line 517: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Final no of workers set = '||l_no_of_worker);

513: -- Statement level Logging
514: ----------------------------
515: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
516: THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Final no of workers set = '||l_no_of_worker);
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Batch size = '||l_batch_size);
519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Updating JTF_TASK_PURGE to set worker id');
520: END IF;
521:

Line 518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Batch size = '||l_batch_size);

514: ----------------------------
515: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
516: THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Final no of workers set = '||l_no_of_worker);
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Batch size = '||l_batch_size);
519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Updating JTF_TASK_PURGE to set worker id');
520: END IF;
521:
522:

Line 519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Updating JTF_TASK_PURGE to set worker id');

515: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
516: THEN
517: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Final no of workers set = '||l_no_of_worker);
518: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Batch size = '||l_batch_size);
519: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Updating JTF_TASK_PURGE to set worker id');
520: END IF;
521:
522:
523: -- updating worker_id in JTF_TASK_PURGE table

Line 549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Invoke child concurrent request');

545: -- Statement level Logging
546: ----------------------------
547: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
548: THEN
549: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Invoke child concurrent request');
550: END IF;
551:
552:
553: -- Start child concurrent programs

Line 588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Pausing parent concurrent request');

584: -- Statement level Logging
585: ----------------------------
586: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
587: THEN
588: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Pausing parent concurrent request');
589: END IF;
590:
591:
592: -- Moving the parent concurrent request to Paused

Line 602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Commiting so that child concurrent request runs');

598: );
599:
600: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
601: THEN
602: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Commiting so that child concurrent request runs');
603: END IF;
604:
605: -- Committing so that the worker concurrent program that
606: -- was submitted above is started by the concurrent manager.

Line 633: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Checking the status of child concurrent requests');

629: -- Statement level Logging
630: ----------------------------
631: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
632: THEN
633: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Checking the status of child concurrent requests');
634: END IF;
635:
636:
637: -- check status of worker concurrent request

Line 658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Status of child concurrent request id = '||r_child_request.request_id);

654: -- Statement level Logging
655: ----------------------------
656: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
657: THEN
658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Status of child concurrent request id = '||r_child_request.request_id);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_phase = '||l_worker_conc_req_phase);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_status = '||l_worker_conc_req_status);
661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_phase = '||l_worker_conc_req_dev_phase);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_status = '||l_worker_conc_req_dev_status);

Line 659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_phase = '||l_worker_conc_req_phase);

655: ----------------------------
656: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
657: THEN
658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Status of child concurrent request id = '||r_child_request.request_id);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_phase = '||l_worker_conc_req_phase);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_status = '||l_worker_conc_req_status);
661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_phase = '||l_worker_conc_req_dev_phase);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_status = '||l_worker_conc_req_dev_status);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_message = '||l_worker_conc_req_message);

Line 660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_status = '||l_worker_conc_req_status);

656: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
657: THEN
658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Status of child concurrent request id = '||r_child_request.request_id);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_phase = '||l_worker_conc_req_phase);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_status = '||l_worker_conc_req_status);
661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_phase = '||l_worker_conc_req_dev_phase);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_status = '||l_worker_conc_req_dev_status);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_message = '||l_worker_conc_req_message);
664: END IF;

Line 661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_phase = '||l_worker_conc_req_dev_phase);

657: THEN
658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Status of child concurrent request id = '||r_child_request.request_id);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_phase = '||l_worker_conc_req_phase);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_status = '||l_worker_conc_req_status);
661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_phase = '||l_worker_conc_req_dev_phase);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_status = '||l_worker_conc_req_dev_status);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_message = '||l_worker_conc_req_message);
664: END IF;
665:

Line 662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_status = '||l_worker_conc_req_dev_status);

658: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Status of child concurrent request id = '||r_child_request.request_id);
659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_phase = '||l_worker_conc_req_phase);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_status = '||l_worker_conc_req_status);
661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_phase = '||l_worker_conc_req_dev_phase);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_status = '||l_worker_conc_req_dev_status);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_message = '||l_worker_conc_req_message);
664: END IF;
665:
666:

Line 663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_message = '||l_worker_conc_req_message);

659: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_phase = '||l_worker_conc_req_phase);
660: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_status = '||l_worker_conc_req_status);
661: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_phase = '||l_worker_conc_req_dev_phase);
662: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_dev_status = '||l_worker_conc_req_dev_status);
663: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_worker_conc_req_message = '||l_worker_conc_req_message);
664: END IF;
665:
666:
667: -- If the current worker has completed its work, based

Line 691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Set l_main_conc_req_dev_status = '||l_main_conc_req_dev_status);

687: -- Statement level Logging
688: ----------------------------
689: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
690: THEN
691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Set l_main_conc_req_dev_status = '||l_main_conc_req_dev_status);
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_child_message = '||l_child_message);
693: END IF;
694:
695: END IF;

Line 692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_child_message = '||l_child_message);

688: ----------------------------
689: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
690: THEN
691: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Set l_main_conc_req_dev_status = '||l_main_conc_req_dev_status);
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_child_message = '||l_child_message);
693: END IF;
694:
695: END IF;
696:

Line 704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error in checking statuses of child requests');

700: -- Statement level Logging
701: ----------------------------
702: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
703: THEN
704: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error in checking statuses of child requests');
705: END IF;
706:
707:
708: -- There was a failure while collecting a child request

Line 763: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'errbuf = '||errbuf);

759: -- Procedure level Logging
760: ----------------------------
761: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
762: THEN
763: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'errbuf = '||errbuf);
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'retcode = '||retcode);
765: END IF;
766:
767: END IF; -- End of l_request_data Is NULL

Line 764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'retcode = '||retcode);

760: ----------------------------
761: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
762: THEN
763: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'errbuf = '||errbuf);
764: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'retcode = '||retcode);
765: END IF;
766:
767: END IF; -- End of l_request_data Is NULL
768:

Line 797: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'fnd_api.g_exc_unexpected_error');

793: -- Exception level Logging
794: ----------------------------
795: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
796: THEN
797: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'fnd_api.g_exc_unexpected_error');
798: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);
799: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
800: END IF;
801:

Line 798: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);

794: ----------------------------
795: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
796: THEN
797: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'fnd_api.g_exc_unexpected_error');
798: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);
799: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
800: END IF;
801:
802:

Line 799: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));

795: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
796: THEN
797: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'fnd_api.g_exc_unexpected_error');
798: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);
799: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
800: END IF;
801:
802:
803: WHEN OTHERS

Line 833: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'OTHERS error');

829: -- Eeception level Logging
830: ----------------------------
831: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
832: THEN
833: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'OTHERS error');
834: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);
835: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
836: END IF;
837:

Line 834: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);

830: ----------------------------
831: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
832: THEN
833: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'OTHERS error');
834: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);
835: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
836: END IF;
837:
838:

Line 835: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));

831: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
832: THEN
833: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'OTHERS error');
834: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'l_msg_count = '||l_msg_count);
835: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_STANDALONE_TASKS', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
836: END IF;
837:
838:
839: END PURGE_STANDALONE_TASKS;

Line 894: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'p_processing_set_id = '||p_processing_set_id);

890: -- Procedure level Logging
891: ----------------------------
892: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
893: THEN
894: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'p_processing_set_id = '||p_processing_set_id);
895: END IF;
896:
897: ----------------------------
898: -- Statement level Logging

Line 902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');

898: -- Statement level Logging
899: ----------------------------
900: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
901: THEN
902: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');
903: END IF;
904:
905:
906: Open C_Task_Id;

Line 918: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Calling FND_ATTACHED_DOCUMENTS2_DKG.Delete_Attachments API to delete attachment');

914: -- Statement level Logging
915: ----------------------------
916: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
917: THEN
918: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Calling FND_ATTACHED_DOCUMENTS2_DKG.Delete_Attachments API to delete attachment');
919: END IF;
920:
921:
922: -- Deleting attachment information from Attachment table

Line 969: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'fnd_api.g_exc_unexpected_error');

965: -- Exception level Logging
966: ----------------------------
967: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
968: THEN
969: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'fnd_api.g_exc_unexpected_error');
970: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);
971: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
972: END IF;
973:

Line 970: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);

966: ----------------------------
967: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
968: THEN
969: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'fnd_api.g_exc_unexpected_error');
970: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);
971: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
972: END IF;
973:
974: WHEN OTHERS

Line 971: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));

967: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
968: THEN
969: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'fnd_api.g_exc_unexpected_error');
970: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);
971: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
972: END IF;
973:
974: WHEN OTHERS
975: THEN

Line 1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'OTHERS error');

996: -- Exception level Logging
997: ----------------------------
998: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
999: THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'OTHERS error');
1001: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);
1002: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1003: END IF;
1004:

Line 1001: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);

997: ----------------------------
998: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
999: THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'OTHERS error');
1001: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);
1002: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1003: END IF;
1004:
1005: END DELETE_TASK_ATTACHMENTS;

Line 1002: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));

998: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
999: THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'OTHERS error');
1001: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'x_msg_count = '||x_msg_count);
1002: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.DELETE_TASK_ATTACHMENTS', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1003: END IF;
1004:
1005: END DELETE_TASK_ATTACHMENTS;
1006:

Line 1045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Start of VALIDATE_STANDALONE_TASK');

1041: -- Procedure level Logging
1042: ----------------------------
1043: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1044: THEN
1045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Start of VALIDATE_STANDALONE_TASK');
1046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'p_processing_set_id = '||p_processing_set_id);
1047: END IF;
1048:
1049: ----------------------------

Line 1046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'p_processing_set_id = '||p_processing_set_id);

1042: ----------------------------
1043: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1044: THEN
1045: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Start of VALIDATE_STANDALONE_TASK');
1046: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'p_processing_set_id = '||p_processing_set_id);
1047: END IF;
1048:
1049: ----------------------------
1050: -- Statement level Logging

Line 1054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Before calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');

1050: -- Statement level Logging
1051: ----------------------------
1052: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1053: THEN
1054: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Before calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');
1055: END IF;
1056:
1057: CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS(
1058: P_API_VERSION => 1.0,

Line 1091: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'End of VALIDATE_STANDALONE_TASK');

1087: -- Procedure level Logging
1088: ----------------------------
1089: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1090: THEN
1091: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'End of VALIDATE_STANDALONE_TASK');
1092: END IF;
1093:
1094: FND_MSG_PUB.Count_And_Get (
1095: p_count => x_msg_count,

Line 1120: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'fnd_api.g_exc_unexpected_error');

1116: -- Exception level Logging
1117: ----------------------------
1118: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1119: THEN
1120: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'fnd_api.g_exc_unexpected_error');
1121: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);
1122: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1123: END IF;
1124:

Line 1121: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);

1117: ----------------------------
1118: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1119: THEN
1120: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'fnd_api.g_exc_unexpected_error');
1121: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);
1122: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1123: END IF;
1124:
1125: WHEN OTHERS

Line 1122: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));

1118: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1119: THEN
1120: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'fnd_api.g_exc_unexpected_error');
1121: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);
1122: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1123: END IF;
1124:
1125: WHEN OTHERS
1126: THEN

Line 1148: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'OTHERS error');

1144: -- Exception level Logging
1145: ----------------------------
1146: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1147: THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'OTHERS error');
1149: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);
1150: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1151: END IF;
1152:

Line 1149: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);

1145: ----------------------------
1146: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1147: THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'OTHERS error');
1149: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);
1150: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1151: END IF;
1152:
1153: END VALIDATE_STANDALONE_TASK;

Line 1150: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));

1146: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1147: THEN
1148: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'OTHERS error');
1149: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'x_msg_count = '||x_msg_count);
1150: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1151: END IF;
1152:
1153: END VALIDATE_STANDALONE_TASK;
1154:

Line 1228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'p_worker_id = '||p_worker_id);

1224: -- Procedure level Logging
1225: ----------------------------
1226: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1227: THEN
1228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'p_worker_id = '||p_worker_id);
1229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'p_concurrent_request_id = '||p_concurrent_request_id);
1230: END IF;
1231:
1232: ----------------------------

Line 1229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'p_concurrent_request_id = '||p_concurrent_request_id);

1225: ----------------------------
1226: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1227: THEN
1228: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'p_worker_id = '||p_worker_id);
1229: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'p_concurrent_request_id = '||p_concurrent_request_id);
1230: END IF;
1231:
1232: ----------------------------
1233: -- Statement level Logging

Line 1237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Fetching data from JTF_TASK_PURGE');

1233: -- Statement level Logging
1234: ----------------------------
1235: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1236: THEN
1237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Fetching data from JTF_TASK_PURGE');
1238: END IF;
1239:
1240:
1241: Open C_Object_Id;

Line 1251: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'No of records fetched from JTF_TASK_PURGE');

1247: -- Statement level Logging
1248: ----------------------------
1249: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1250: THEN
1251: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'No of records fetched from JTF_TASK_PURGE');
1252: END IF;
1253:
1254:
1255: IF l_tab_task_id.COUNT > 0

Line 1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Inserting data into temp table - JTF_OBJECT_PURGE_PARAM_TMP');

1264: -- Statement level Logging
1265: ----------------------------
1266: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1267: THEN
1268: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Inserting data into temp table - JTF_OBJECT_PURGE_PARAM_TMP');
1269: END IF;
1270:
1271:
1272: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST

Line 1289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Calling wrapper API - VALIDATE_STANDALONE_TASK');

1285: -- Statement level Logging
1286: ----------------------------
1287: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1288: THEN
1289: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.VALIDATE_STANDALONE_TASK', 'Calling wrapper API - VALIDATE_STANDALONE_TASK');
1290: END IF;
1291:
1292: -- Calling VALIDATE_STANDALONE_TASK to validate standalone tasks
1293:

Line 1315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling wrapper API - DELETE_TASK_ATTACHMENTS');

1311: -- Statement level Logging
1312: ----------------------------
1313: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1314: THEN
1315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling wrapper API - DELETE_TASK_ATTACHMENTS');
1316: END IF;
1317:
1318:
1319: -- Calling DELETE_TASK_ATTACHMENTS to delete attachments

Line 1343: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling note API - CAC_NOTE_PURGE_PUB.PURGE_NOTES');

1339: -- Statement level Logging
1340: ----------------------------
1341: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1342: THEN
1343: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling note API - CAC_NOTE_PURGE_PUB.PURGE_NOTES');
1344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Passing l_processing_set_id = '||l_processing_set_id);
1345: END IF;
1346:
1347:

Line 1344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Passing l_processing_set_id = '||l_processing_set_id);

1340: ----------------------------
1341: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1342: THEN
1343: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling note API - CAC_NOTE_PURGE_PUB.PURGE_NOTES');
1344: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Passing l_processing_set_id = '||l_processing_set_id);
1345: END IF;
1346:
1347:
1348: -- Calling CAC_NOTE_PURGE_PUB.PURGE_NOTES to delete notes

Line 1373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Before calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');

1369: -- Statement level Logging
1370: ----------------------------
1371: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1372: THEN
1373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Before calling CSM_TASK_PURGE_PKG.VALIDATE_MFS_TASKS');
1374: END IF;
1375:
1376: -- Calling CSM_TASK_PURGE_PKG.DELETE_MFS_TASKS to delete data from Field Service
1377:

Line 1401: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Before calling IEU_WR_PUB.Purge_Wr_Item');

1397: -- Statement level Logging
1398: ----------------------------
1399: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1400: THEN
1401: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Before calling IEU_WR_PUB.Purge_Wr_Item');
1402: END IF;
1403:
1404:
1405: -- Calling IEU_WR_PUB.Purge_Wr_Item to delete data from UWQ

Line 1430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Before calling JTF_IH_PURGE.P_Delete_Interactions');

1426: -- Statement level Logging
1427: ----------------------------
1428: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1429: THEN
1430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Before calling JTF_IH_PURGE.P_Delete_Interactions');
1431: END IF;
1432:
1433:
1434: -- Calling JTF_IH_PURGE.P_Delete_Interactions to delete data from Interaction History

Line 1460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES');

1456: -- Statement level Logging
1457: ----------------------------
1458: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1459: THEN
1460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES');
1461: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Passing l_processing_set_id = '||l_processing_set_id);
1462: END IF;
1463:
1464:

Line 1461: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Passing l_processing_set_id = '||l_processing_set_id);

1457: ----------------------------
1458: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1459: THEN
1460: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES');
1461: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Passing l_processing_set_id = '||l_processing_set_id);
1462: END IF;
1463:
1464:
1465: -- Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES to delte task entities

Line 1465: -- Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES to delte task entities

1461: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Passing l_processing_set_id = '||l_processing_set_id);
1462: END IF;
1463:
1464:
1465: -- Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES to delte task entities
1466:
1467: CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES(
1468: p_api_version => 1.0 ,
1469: p_init_msg_list => fnd_api.g_false ,

Line 1467: CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES(

1463:
1464:
1465: -- Calling CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES to delte task entities
1466:
1467: CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES(
1468: p_api_version => 1.0 ,
1469: p_init_msg_list => fnd_api.g_false ,
1470: p_commit => fnd_api.g_false ,
1471: p_processing_set_id => l_processing_set_id ,

Line 1490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Updating process_flag of JTF_TASK_PURGE');

1486: -- Statement level Logging
1487: ----------------------------
1488: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1489: THEN
1490: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Updating process_flag of JTF_TASK_PURGE');
1491: END IF;
1492:
1493:
1494: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST

Line 1508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Updating purge_status of JTF_TASK_PURGE');

1504: -- Statement level Logging
1505: ----------------------------
1506: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1507: THEN
1508: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Updating purge_status of JTF_TASK_PURGE');
1509: END IF;
1510:
1511:
1512: Open C_Error_Tmp;

Line 1553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'errbuf = '||errbuf);

1549: -- Procedure level Logging
1550: ----------------------------
1551: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1552: THEN
1553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'errbuf = '||errbuf);
1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'retcode = '||retcode);
1555: END IF;
1556:
1557: EXCEPTION

Line 1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'retcode = '||retcode);

1550: ----------------------------
1551: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1552: THEN
1553: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'errbuf = '||errbuf);
1554: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'retcode = '||retcode);
1555: END IF;
1556:
1557: EXCEPTION
1558: WHEN fnd_api.g_exc_unexpected_error

Line 1586: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'fnd_api.g_exc_unexpected_error');

1582: -- Exception level Logging
1583: ----------------------------
1584: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1585: THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'fnd_api.g_exc_unexpected_error');
1587: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);
1588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
1589: END IF;
1590:

Line 1587: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);

1583: ----------------------------
1584: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1585: THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'fnd_api.g_exc_unexpected_error');
1587: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);
1588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
1589: END IF;
1590:
1591: WHEN OTHERS

Line 1588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));

1584: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1585: THEN
1586: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'fnd_api.g_exc_unexpected_error');
1587: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);
1588: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
1589: END IF;
1590:
1591: WHEN OTHERS
1592: THEN

Line 1622: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'OTHERS error');

1618: -- Exception level Logging
1619: ----------------------------
1620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1621: THEN
1622: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'OTHERS error');
1623: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);
1624: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
1625: END IF;
1626:

Line 1623: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);

1619: ----------------------------
1620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1621: THEN
1622: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'OTHERS error');
1623: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);
1624: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
1625: END IF;
1626:
1627: END POPULATE_PURGE_TMP;

Line 1624: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));

1620: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1621: THEN
1622: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'OTHERS error');
1623: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'l_msg_count = '||l_msg_count);
1624: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.POPULATE_PURGE_TMP', 'Error message = '||REPLACE(l_msg_data,CHR(0),' '));
1625: END IF;
1626:
1627: END POPULATE_PURGE_TMP;
1628:

Line 1684: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'p_processing_set_id = '||p_processing_set_id);

1680: -- Procedure level Logging
1681: ----------------------------
1682: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1683: THEN
1684: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'p_processing_set_id = '||p_processing_set_id);
1685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'p_object_type = '||p_object_type);
1686: END IF;
1687:
1688: ----------------------------

Line 1685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'p_object_type = '||p_object_type);

1681: ----------------------------
1682: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1683: THEN
1684: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'p_processing_set_id = '||p_processing_set_id);
1685: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'p_object_type = '||p_object_type);
1686: END IF;
1687:
1688: ----------------------------
1689: -- Statement level Logging

Line 1693: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');

1689: -- Statement level Logging
1690: ----------------------------
1691: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1692: THEN
1693: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Fetching record from JTF_OBJECT_PURGE_PARAM_TMP');
1694: END IF;
1695:
1696:
1697: Open C_Task_Id;

Line 1709: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_DATES');

1705: -- Statement level Logging
1706: ----------------------------
1707: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1708: THEN
1709: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_DATES');
1710: END IF;
1711:
1712:
1713: --Delete data from JTF_TASK_DATES table

Line 1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_DEPENDS');

1720: -- Statement level Logging
1721: ----------------------------
1722: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1723: THEN
1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_DEPENDS');
1725: END IF;
1726:
1727:
1728: --Delete data from JTF_TASK_DEPENDS table

Line 1741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_CONTACTS');

1737: -- Statement level Logging
1738: ----------------------------
1739: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1740: THEN
1741: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_CONTACTS');
1742: END IF;
1743:
1744:
1745: --Delete data from JTF_TASK_CONTACTS table

Line 1757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_PHONES');

1753: -- Statement level Logging
1754: ----------------------------
1755: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1756: THEN
1757: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_PHONES');
1758: END IF;
1759:
1760:
1761: --Delete data from JTF_TASK_PHONES table

Line 1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_RSC_REQS');

1778: -- Statement level Logging
1779: ----------------------------
1780: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1781: THEN
1782: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_RSC_REQS');
1783: END IF;
1784:
1785:
1786: --Delete data from JTF_TASK_RSC_REQS

Line 1797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_REFERENCES_B');

1793: -- Statement level Logging
1794: ----------------------------
1795: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1796: THEN
1797: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_REFERENCES_B');
1798: END IF;
1799:
1800:
1801: --Delete data from JTF_TASK_REFERENCES_B table

Line 1817: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_REFERENCES_TL');

1813: -- Statement level Logging
1814: ----------------------------
1815: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1816: THEN
1817: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_REFERENCES_TL');
1818: END IF;
1819:
1820:
1821: Forall i In l_tab_task_ref_id.FIRST..l_tab_task_ref_id.LAST

Line 1832: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_AUDITS_B');

1828: -- Statement level Logging
1829: ----------------------------
1830: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1831: THEN
1832: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_AUDITS_B');
1833: END IF;
1834:
1835:
1836: --Delete data from JTF_TASK_AUDITS_B table

Line 1851: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_AUDITS_TL');

1847: -- Statement level Logging
1848: ----------------------------
1849: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1850: THEN
1851: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_AUDITS_TL');
1852: END IF;
1853:
1854:
1855: Forall i In l_tab_task_audits_id.FIRST..l_tab_task_audits_id.LAST

Line 1868: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_ALL_ASSIGNMENTS');

1864: -- Statement level Logging
1865: ----------------------------
1866: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1867: THEN
1868: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_ALL_ASSIGNMENTS');
1869: END IF;
1870:
1871: --Delete data from JTF_TASK_ALL_ASSIGNMENTS table
1872: Forall j In l_tab_task_id.FIRST..l_tab_task_id.LAST

Line 1883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Breaking parent-child relationship for the tasks to be purged in JTF_TASKS_B');

1879: -- Statement level Logging
1880: ----------------------------
1881: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1882: THEN
1883: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Breaking parent-child relationship for the tasks to be purged in JTF_TASKS_B');
1884: END IF;
1885:
1886:
1887: --Break parent-child relationship for the tasks to be purged

Line 1899: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASKS_B');

1895: -- Statement level Logging
1896: ----------------------------
1897: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1898: THEN
1899: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASKS_B');
1900: END IF;
1901:
1902:
1903: --Delete data from JTF_TASKS_B table

Line 1915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASKS_TL');

1911: -- Statement level Logging
1912: ----------------------------
1913: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1914: THEN
1915: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASKS_TL');
1916: END IF;
1917:
1918:
1919: --Delete data from JTF_TASKS_TL table

Line 1934: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_RECUR_RULES');

1930: -- Statement level Logging
1931: ----------------------------
1932: IF( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1933: THEN
1934: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Deleting from table - JTF_TASK_RECUR_RULES');
1935: END IF;
1936:
1937:
1938: Forall j In l_tab_rec_rule_id.FIRST..l_tab_rec_rule_id.LAST

Line 1959: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'End of PURGE_TASK_ENTITIES');

1955: -- Procedure level Logging
1956: ----------------------------
1957: IF( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1958: THEN
1959: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'End of PURGE_TASK_ENTITIES');
1960: END IF;
1961:
1962: EXCEPTION
1963: WHEN fnd_api.g_exc_unexpected_error

Line 1985: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'fnd_api.g_exc_unexpected_error');

1981: -- Exception level Logging
1982: ----------------------------
1983: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1984: THEN
1985: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'fnd_api.g_exc_unexpected_error');
1986: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);
1987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1988: END IF;
1989:

Line 1986: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);

1982: ----------------------------
1983: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1984: THEN
1985: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'fnd_api.g_exc_unexpected_error');
1986: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);
1987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1988: END IF;
1989:
1990: WHEN OTHERS

Line 1987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));

1983: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1984: THEN
1985: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'fnd_api.g_exc_unexpected_error');
1986: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);
1987: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
1988: END IF;
1989:
1990: WHEN OTHERS
1991: THEN

Line 2016: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'OTHERS error');

2012: -- Exception level Logging
2013: ----------------------------
2014: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2015: THEN
2016: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'OTHERS error');
2017: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);
2018: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
2019: END IF;
2020:

Line 2017: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);

2013: ----------------------------
2014: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2015: THEN
2016: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'OTHERS error');
2017: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);
2018: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
2019: END IF;
2020:
2021: END PURGE_TASK_ENTITIES;

Line 2018: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));

2014: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2015: THEN
2016: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'OTHERS error');
2017: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'x_msg_count = '||x_msg_count);
2018: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'CAC_TASK_PURGE_PVT.PURGE_TASK_ENTITIES', 'Error message = '||REPLACE(x_msg_data,CHR(0),' '));
2019: END IF;
2020:
2021: END PURGE_TASK_ENTITIES;
2022:

Line 2023: END CAC_TASK_PURGE_PVT;

2019: END IF;
2020:
2021: END PURGE_TASK_ENTITIES;
2022:
2023: END CAC_TASK_PURGE_PVT;