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: IF p_oprn_rsrc_tbl.count > 0 THEN

Line 240: IF l_retn_status <> FND_API.g_ret_sts_success THEN

236: p_oprn_rsrc_tbl => p_oprn_rsrc_tbl,
237: x_message_count => x_message_count,
238: x_message_list => x_message_list,
239: x_return_status => l_retn_status);
240: IF l_retn_status <> FND_API.g_ret_sts_success THEN
241: RAISE ins_oprn_actv_err;
242: END IF;
243: END IF;
244:

Line 255: x_return_status := FND_API.G_RET_STS_ERROR;

251: ,p_data => x_message_list);
252: EXCEPTION
253: WHEN setup_failure OR invalid_version THEN
254: ROLLBACK TO SAVEPOINT insert_oprn_actv;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
257: P_data => x_message_list);
258: WHEN ins_oprn_actv_err THEN
259: ROLLBACK TO SAVEPOINT insert_oprn_actv;

Line 260: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

261: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
262: P_data => x_message_list);
263: WHEN OTHERS THEN
264: ROLLBACK TO SAVEPOINT insert_oprn_actv;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
267: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
268: FND_MSG_PUB.ADD;
269: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 313: x_return_status := FND_API.g_ret_sts_success;

309: fnd_msg_pub.initialize;
310: END IF;
311:
312: /* Initially let us assign the return status to success */
313: x_return_status := FND_API.g_ret_sts_success;
314:
315: IF NOT gmd_api_grp.setup_done THEN
316: gmd_api_grp.setup_done := gmd_api_grp.setup;
317: END IF;

Line 323: IF NOT FND_API.compatible_api_call(l_api_version

319: RAISE setup_failure;
320: END IF;
321:
322: /* Make sure we are call compatible */
323: IF NOT FND_API.compatible_api_call(l_api_version
324: ,p_api_version
325: ,'update_operation_activity'
326: ,'gmd_operation_activities_pub') THEN
327: RAISE invalid_version;

Line 376: x_return_status := FND_API.g_ret_sts_error;

372: OPEN get_oprn_id(p_oprn_line_id);
373: FETCH get_oprn_id INTO v_oprn_id;
374: IF get_oprn_id%NOTFOUND THEN
375: gmd_api_grp.log_message('GMD_INVALID_OPRNLINE_ID');
376: x_return_status := FND_API.g_ret_sts_error;
377: END IF;
378: CLOSE get_oprn_id;
379:
380: /* Operation Security Validation */

Line 423: IF l_retn_status <> FND_API.g_ret_sts_success THEN

419: , p_update_table => p_update_table
420: , x_message_count => x_message_count
421: , x_message_list => x_message_list
422: , x_return_status => l_retn_status);
423: IF l_retn_status <> FND_API.g_ret_sts_success THEN
424: RAISE upd_oprn_actv_err;
425: END IF;
426:
427: IF p_commit THEN

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435:
436: EXCEPTION
437: WHEN setup_failure OR invalid_version THEN
438: ROLLBACK TO SAVEPOINT upd_oprn_actv;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
441: P_data => x_message_list);
442: WHEN upd_oprn_actv_err THEN
443: ROLLBACK TO SAVEPOINT upd_oprn_actv;

Line 444: x_return_status := FND_API.G_RET_STS_ERROR;

440: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
441: P_data => x_message_list);
442: WHEN upd_oprn_actv_err THEN
443: ROLLBACK TO SAVEPOINT upd_oprn_actv;
444: x_return_status := FND_API.G_RET_STS_ERROR;
445: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
446: P_data => x_message_list);
447:
448: WHEN OTHERS THEN

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

446: P_data => x_message_list);
447:
448: WHEN OTHERS THEN
449: ROLLBACK TO SAVEPOINT upd_oprn_actv;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
452: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
453: FND_MSG_PUB.ADD;
454: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 505: x_return_status := FND_API.g_ret_sts_success;

501: fnd_msg_pub.initialize;
502: END IF;
503:
504: /* Initially let us assign the return status to success */
505: x_return_status := FND_API.g_ret_sts_success;
506:
507: IF NOT gmd_api_grp.setup_done THEN
508: gmd_api_grp.setup_done := gmd_api_grp.setup;
509: END IF;

Line 516: IF NOT FND_API.compatible_api_call(l_api_version

512: END IF;
513:
514:
515: /* Make sure we are call compatible */
516: IF NOT FND_API.compatible_api_call(l_api_version
517: ,p_api_version
518: ,'delete_operation_activity'
519: ,'gmd_operation_activities_pvt') THEN
520: RAISE invalid_version;

Line 571: IF l_retn_status <> FND_API.g_ret_sts_success THEN

567: (p_oprn_line_id => p_oprn_line_id
568: , x_message_count => x_message_count
569: , x_message_list => x_message_list
570: , x_return_status => l_retn_status);
571: IF l_retn_status <> FND_API.g_ret_sts_success THEN
572: RAISE del_oprn_actv_err;
573: END IF;
574:
575: IF p_commit THEN

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

582:
583: EXCEPTION
584: WHEN setup_failure OR invalid_version THEN
585: ROLLBACK TO SAVEPOINT delete_oprn_actv;
586: x_return_status := FND_API.G_RET_STS_ERROR;
587: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
588: P_data => x_message_list);
589: WHEN del_oprn_actv_err THEN
590: ROLLBACK TO SAVEPOINT delete_oprn_actv;

Line 591: x_return_status := FND_API.G_RET_STS_ERROR;

587: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
588: P_data => x_message_list);
589: WHEN del_oprn_actv_err THEN
590: ROLLBACK TO SAVEPOINT delete_oprn_actv;
591: x_return_status := FND_API.G_RET_STS_ERROR;
592: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
593: P_data => x_message_list);
594: WHEN OTHERS THEN
595: ROLLBACK TO SAVEPOINT delete_oprn_actv;

Line 596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

592: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
593: P_data => x_message_list);
594: WHEN OTHERS THEN
595: ROLLBACK TO SAVEPOINT delete_oprn_actv;
596: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
597: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
598: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
599: FND_MSG_PUB.ADD;
600: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,