DBA Data[Home] [Help]

APPS.GMD_OPERATION_ACTIVITIES_PUB dependencies on FND_API

Line 113: x_return_status := FND_API.g_ret_sts_success;

109: gmd_debug.put_line('In insert_operation_activity public.');
110: END IF;
111:
112: /* Initially let us assign the return status to success */
113: x_return_status := FND_API.g_ret_sts_success;
114:
115: IF NOT gmd_api_grp.setup_done THEN
116: gmd_api_grp.setup_done := gmd_api_grp.setup;
117: END IF;

Line 123: IF NOT FND_API.compatible_api_call(l_api_version

119: RAISE setup_failure;
120: END IF;
121:
122: /* Make sure we are call compatible */
123: IF NOT FND_API.compatible_api_call(l_api_version
124: ,p_api_version
125: ,'insert_operation_activity'
126: ,'gmd_operation_activities_pub') THEN
127: RAISE invalid_version;

Line 227: IF l_retn_status <> FND_API.g_ret_sts_success THEN

223: x_message_count => x_message_count,
224: x_message_list => x_message_list,
225: x_return_status => l_retn_status);
226:
227: IF l_retn_status <> FND_API.g_ret_sts_success THEN
228: RAISE ins_oprn_actv_err;
229: END IF;
230:
231: /* Added the below call in Bug No.8316321 */

Line 246: IF l_retn_status <> FND_API.g_ret_sts_success THEN

242: p_oprn_rsrc_tbl => p_oprn_rsrc_tbl,
243: x_message_count => x_message_count,
244: x_message_list => x_message_list,
245: x_return_status => l_retn_status);
246: IF l_retn_status <> FND_API.g_ret_sts_success THEN
247: RAISE ins_oprn_actv_err;
248: END IF;
249: END IF;
250:

Line 261: x_return_status := FND_API.G_RET_STS_ERROR;

257: ,p_data => x_message_list);
258: EXCEPTION
259: WHEN setup_failure OR invalid_version THEN
260: ROLLBACK TO SAVEPOINT insert_oprn_actv;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
263: P_data => x_message_list);
264: WHEN ins_oprn_actv_err THEN
265: ROLLBACK TO SAVEPOINT insert_oprn_actv;

Line 266: x_return_status := FND_API.G_RET_STS_ERROR;

262: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
263: P_data => x_message_list);
264: WHEN ins_oprn_actv_err THEN
265: ROLLBACK TO SAVEPOINT insert_oprn_actv;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
268: P_data => x_message_list);
269: WHEN OTHERS THEN
270: ROLLBACK TO SAVEPOINT insert_oprn_actv;

Line 271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

267: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
268: P_data => x_message_list);
269: WHEN OTHERS THEN
270: ROLLBACK TO SAVEPOINT insert_oprn_actv;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
273: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
274: FND_MSG_PUB.ADD;
275: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 319: x_return_status := FND_API.g_ret_sts_success;

315: fnd_msg_pub.initialize;
316: END IF;
317:
318: /* Initially let us assign the return status to success */
319: x_return_status := FND_API.g_ret_sts_success;
320:
321: IF NOT gmd_api_grp.setup_done THEN
322: gmd_api_grp.setup_done := gmd_api_grp.setup;
323: END IF;

Line 329: IF NOT FND_API.compatible_api_call(l_api_version

325: RAISE setup_failure;
326: END IF;
327:
328: /* Make sure we are call compatible */
329: IF NOT FND_API.compatible_api_call(l_api_version
330: ,p_api_version
331: ,'update_operation_activity'
332: ,'gmd_operation_activities_pub') THEN
333: RAISE invalid_version;

Line 382: x_return_status := FND_API.g_ret_sts_error;

378: OPEN get_oprn_id(p_oprn_line_id);
379: FETCH get_oprn_id INTO v_oprn_id;
380: IF get_oprn_id%NOTFOUND THEN
381: gmd_api_grp.log_message('GMD_INVALID_OPRNLINE_ID');
382: x_return_status := FND_API.g_ret_sts_error;
383: END IF;
384: CLOSE get_oprn_id;
385:
386: /* Operation Security Validation */

Line 429: IF l_retn_status <> FND_API.g_ret_sts_success THEN

425: , p_update_table => p_update_table
426: , x_message_count => x_message_count
427: , x_message_list => x_message_list
428: , x_return_status => l_retn_status);
429: IF l_retn_status <> FND_API.g_ret_sts_success THEN
430: RAISE upd_oprn_actv_err;
431: END IF;
432:
433: /* Added the below call in Bug No.8316321 */

Line 450: x_return_status := FND_API.G_RET_STS_ERROR;

446:
447: EXCEPTION
448: WHEN setup_failure OR invalid_version THEN
449: ROLLBACK TO SAVEPOINT upd_oprn_actv;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
452: P_data => x_message_list);
453: WHEN upd_oprn_actv_err THEN
454: ROLLBACK TO SAVEPOINT upd_oprn_actv;

Line 455: x_return_status := FND_API.G_RET_STS_ERROR;

451: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
452: P_data => x_message_list);
453: WHEN upd_oprn_actv_err THEN
454: ROLLBACK TO SAVEPOINT upd_oprn_actv;
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
457: P_data => x_message_list);
458:
459: WHEN OTHERS THEN

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: P_data => x_message_list);
458:
459: WHEN OTHERS THEN
460: ROLLBACK TO SAVEPOINT upd_oprn_actv;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
463: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
464: FND_MSG_PUB.ADD;
465: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 516: x_return_status := FND_API.g_ret_sts_success;

512: fnd_msg_pub.initialize;
513: END IF;
514:
515: /* Initially let us assign the return status to success */
516: x_return_status := FND_API.g_ret_sts_success;
517:
518: IF NOT gmd_api_grp.setup_done THEN
519: gmd_api_grp.setup_done := gmd_api_grp.setup;
520: END IF;

Line 527: IF NOT FND_API.compatible_api_call(l_api_version

523: END IF;
524:
525:
526: /* Make sure we are call compatible */
527: IF NOT FND_API.compatible_api_call(l_api_version
528: ,p_api_version
529: ,'delete_operation_activity'
530: ,'gmd_operation_activities_pvt') THEN
531: RAISE invalid_version;

Line 582: IF l_retn_status <> FND_API.g_ret_sts_success THEN

578: (p_oprn_line_id => p_oprn_line_id
579: , x_message_count => x_message_count
580: , x_message_list => x_message_list
581: , x_return_status => l_retn_status);
582: IF l_retn_status <> FND_API.g_ret_sts_success THEN
583: RAISE del_oprn_actv_err;
584: END IF;
585:
586: IF p_commit THEN

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593:
594: EXCEPTION
595: WHEN setup_failure OR invalid_version THEN
596: ROLLBACK TO SAVEPOINT delete_oprn_actv;
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
599: P_data => x_message_list);
600: WHEN del_oprn_actv_err THEN
601: ROLLBACK TO SAVEPOINT delete_oprn_actv;

Line 602: x_return_status := FND_API.G_RET_STS_ERROR;

598: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
599: P_data => x_message_list);
600: WHEN del_oprn_actv_err THEN
601: ROLLBACK TO SAVEPOINT delete_oprn_actv;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
604: P_data => x_message_list);
605: WHEN OTHERS THEN
606: ROLLBACK TO SAVEPOINT delete_oprn_actv;

Line 607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

603: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
604: P_data => x_message_list);
605: WHEN OTHERS THEN
606: ROLLBACK TO SAVEPOINT delete_oprn_actv;
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
609: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
610: FND_MSG_PUB.ADD;
611: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,