DBA Data[Home] [Help]

APPS.PA_ASGN_CONFLICT_HIST_PKG dependencies on FND_API

Line 49: x_return_status := FND_API.G_RET_STS_SUCCESS;

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',

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

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',

Line 152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:

Line 188: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 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:

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 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:

Line 266: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 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:

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 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:

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 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:

Line 369: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 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: