45: sysdate ,
46: fnd_global.user_id ,
47: fnd_global.login_id );
48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: EXCEPTION
51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
48:
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: EXCEPTION
51: WHEN OTHERS THEN
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
54: p_procedure_name => 'insert_rows');
55: raise;
56:
145:
146: END IF;
147: END IF;
148:
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: EXCEPTION
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
148:
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: EXCEPTION
151: WHEN OTHERS THEN
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
153: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
154: p_procedure_name => 'insert_rows');
155: raise;
156:
184: WHERE conflict_group_id = p_conflict_group_id
185: AND assignment_id = p_assignment_id
186: AND conflict_assignment_id = p_conflict_assignment_id;
187:
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: x_return_status := FND_API.G_RET_STS_SUCCESS;
189:
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
194: p_procedure_name => 'update_rows');
195: raise;
196:
220: last_updated_by = fnd_global.user_id,
221: last_update_login = fnd_global.login_id
222: WHERE conflict_group_id = p_conflict_group_id;
223:
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: EXCEPTION
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: EXCEPTION
227: WHEN OTHERS THEN
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
230: p_procedure_name => 'update_rows');
231: raise;
232:
262: AND assignment_id = p_assignment_id_arr(j);
263:
264: END IF;
265:
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267:
268: EXCEPTION
269: WHEN OTHERS THEN
270: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
271: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
272: p_procedure_name => 'update_rows');
273: raise;
274:
300: last_update_login = fnd_global.login_id
301: WHERE conflict_group_id = p_conflict_group_id
302: AND assignment_id = p_assignment_id;
303:
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLICT_HIST_PKG',
310: p_procedure_name => 'update_rows');
311: raise;
312:
334: WHERE conflict_group_id = p_conflict_group_id
335: AND assignment_id = p_assignment_id
336: AND conflict_assignment_id = p_conflict_assignment_id;
337:
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339:
340: EXCEPTION
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLCIT_HIST_PKG',
344: p_procedure_name => 'delete_rows');
345: raise;
346:
365: DELETE FROM PA_ASSIGNMENT_CONFLICT_HIST -- Bug 9356152
366: WHERE assignment_id = p_assignment_id
367: OR CONFLICT_ASSIGNMENT_ID = p_assignment_id;
368:
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: x_return_status := FND_API.G_RET_STS_SUCCESS;
370:
371: EXCEPTION
372: WHEN OTHERS THEN
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_ASGN_CONFLCIT_HIST_PKG',
375: p_procedure_name => 'delete_conflict_rows');
376: raise;
377: