DBA Data[Home] [Help]

APPS.GMD_OPERATIONS_PUB dependencies on FND_API

Line 93: IF NOT FND_API.compatible_api_call(l_api_version

89: BEGIN
90: SAVEPOINT insert_oprn;
91:
92: /* Make sure we are call compatible */
93: IF NOT FND_API.compatible_api_call(l_api_version
94: ,p_api_version
95: ,'insert_operation'
96: ,'gmd_operations_pub') THEN
97: RAISE invalid_version;

Line 114: x_return_status := FND_API.g_ret_sts_success;

110: RAISE setup_failure;
111: END IF;
112:
113: /* Initially let us assign the return status to success */
114: x_return_status := FND_API.g_ret_sts_success;
115:
116: /* Operation number must be passed, otherwise give error */
117: IF p_operations.oprn_no IS NULL THEN
118: IF (l_debug = 'Y') THEN

Line 195: RAISE FND_API.G_EXC_ERROR;

191: --Check that organization id is not null if raise an error message
192: IF (p_operations.owner_organization_id IS NULL) THEN
193: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_ORGANIZATION_ID');
194: FND_MSG_PUB.Add;
195: RAISE FND_API.G_EXC_ERROR;
196: END IF;
197:
198: -- Check if organization is accessible to the responsibility
199: IF NOT (GMD_API_GRP.OrgnAccessible (powner_orgn_id => p_operations.owner_organization_id) ) THEN

Line 208: RAISE FND_API.G_EXC_ERROR;

204: IF NOT (gmd_api_grp.check_orgn_status(p_operations.owner_organization_id)) THEN
205: FND_MESSAGE.SET_NAME('GMD', 'GMD_INVALID_ORGANIZATION_ID');
206: FND_MESSAGE.SET_TOKEN('ORGN_ID', p_operations.owner_organization_id);
207: FND_MSG_PUB.Add;
208: RAISE FND_API.G_EXC_ERROR;
209: END IF;
210:
211: /* Effective start date must be passed, otherwise give error */
212: IF p_operations.effective_start_date IS NULL THEN

Line 267: IF l_retn_status <> FND_API.g_ret_sts_success THEN

263: GMD_OPERATIONS_PVT.insert_operation(p_operations => p_operations,
264: x_message_count => x_message_count,
265: x_message_list => x_message_list,
266: x_return_status => l_retn_status);
267: IF l_retn_status <> FND_API.g_ret_sts_success THEN
268: RAISE ins_operation_err;
269: END IF;
270:
271:

Line 304: IF l_retn_status <> FND_API.g_ret_sts_success THEN

300: x_message_count => x_message_count,
301: x_message_list => x_message_list,
302: x_return_status => l_retn_status);
303:
304: IF l_retn_status <> FND_API.g_ret_sts_success THEN
305: RAISE ins_operation_err;
306: END IF;
307: my_rsrc_table_type.delete;
308: END LOOP; --i in 1.. p_oprn_actv_tbl.count

Line 335: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN

331: , p_ignore_flag => FALSE
332: , x_message_count => x_message_count
333: , x_message_list => x_message_list
334: , x_return_status => l_retn_status);
335: IF x_return_status NOT IN (FND_API.g_ret_sts_success,'P') THEN
336: RAISE default_status_err;
337: END IF; --x_return_status
338: END IF; --l_entity_status.entity_status <> 100
339: COMMIT;

Line 349: x_return_status := FND_API.G_RET_STS_ERROR;

345:
346: EXCEPTION
347: WHEN setup_failure OR invalid_version THEN
348: ROLLBACK TO SAVEPOINT insert_oprn;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
351: P_data => x_message_list);
352: WHEN ins_operation_err THEN
353: ROLLBACK TO SAVEPOINT insert_oprn;

Line 354: x_return_status := FND_API.g_ret_sts_error;

350: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
351: P_data => x_message_list);
352: WHEN ins_operation_err THEN
353: ROLLBACK TO SAVEPOINT insert_oprn;
354: x_return_status := FND_API.g_ret_sts_error;
355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
356: P_data => x_message_list);
357: WHEN default_status_err THEN
358: ROLLBACK TO default_status_sp;

Line 359: x_return_status := FND_API.g_ret_sts_error;

355: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
356: P_data => x_message_list);
357: WHEN default_status_err THEN
358: ROLLBACK TO default_status_sp;
359: x_return_status := FND_API.g_ret_sts_error;
360: FND_MSG_PUB.Count_And_Get (
361: p_count => x_message_count,
362: p_data => x_message_list );
363: WHEN OTHERS THEN

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

361: p_count => x_message_count,
362: p_data => x_message_list );
363: WHEN OTHERS THEN
364: ROLLBACK TO SAVEPOINT insert_oprn;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
367: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
368: FND_MSG_PUB.ADD;
369: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 432: IF NOT FND_API.compatible_api_call(l_api_version

428: fnd_msg_pub.initialize;
429: END IF;
430:
431: /* Make sure we are call compatible */
432: IF NOT FND_API.compatible_api_call(l_api_version
433: ,p_api_version
434: ,'update_operation'
435: ,'gmd_operations_pub') THEN
436: RAISE invalid_version;

Line 448: x_return_status := FND_API.g_ret_sts_success;

444: RAISE setup_failure;
445: END IF;
446:
447: /* Initially let us assign the return status to success */
448: x_return_status := FND_API.g_ret_sts_success;
449:
450: IF (l_debug = 'Y') THEN
451: gmd_debug.put_line('Start of update_operation PUB');
452: END IF;

Line 576: IF l_retn_status <> FND_API.g_ret_sts_success THEN

572: , p_update_table => p_update_table
573: , x_message_count => x_message_count
574: , x_message_list => x_message_list
575: , x_return_status => l_retn_status);
576: IF l_retn_status <> FND_API.g_ret_sts_success THEN
577: RAISE upd_oprn_err;
578: END IF;
579: IF p_commit THEN
580: COMMIT;

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588: ,p_data => x_message_list);
589:
590: EXCEPTION
591: WHEN invalid_version or setup_failure THEN
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: ROLLBACK TO SAVEPOINT update_oprn;
594: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
595: P_data => x_message_list);
596: WHEN upd_oprn_err THEN

Line 597: x_return_status := FND_API.G_RET_STS_ERROR;

593: ROLLBACK TO SAVEPOINT update_oprn;
594: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
595: P_data => x_message_list);
596: WHEN upd_oprn_err THEN
597: x_return_status := FND_API.G_RET_STS_ERROR;
598: ROLLBACK TO SAVEPOINT update_oprn;
599: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
600: P_data => x_message_list);
601: WHEN OTHERS THEN

Line 603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

599: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
600: P_data => x_message_list);
601: WHEN OTHERS THEN
602: ROLLBACK TO SAVEPOINT update_oprn;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
605: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
606: FND_MSG_PUB.ADD;
607: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 644: x_return_status := FND_API.g_ret_sts_success;

640: fnd_msg_pub.initialize;
641: END IF;
642:
643: /* Initially let us assign the return status to success */
644: x_return_status := FND_API.g_ret_sts_success;
645:
646: IF (l_debug = 'Y') THEN
647: gmd_debug.put_line('START of delete_operation PUB');
648: END IF;

Line 665: IF l_retn_status <> FND_API.g_ret_sts_success THEN

661: ,x_message_count => x_message_count
662: ,x_message_list => x_message_list
663: ,x_return_status => l_retn_status);
664:
665: IF l_retn_status <> FND_API.g_ret_sts_success THEN
666: RAISE upd_oprn_err;
667: END IF;
668:
669: IF p_commit THEN

Line 684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

680: END IF;
681:
682: EXCEPTION
683: WHEN upd_oprn_err THEN
684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
685: ROLLBACK TO SAVEPOINT delete_oprn;
686: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
687: P_data => x_message_list);
688: WHEN OTHERS THEN

Line 690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

686: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
687: P_data => x_message_list);
688: WHEN OTHERS THEN
689: ROLLBACK TO SAVEPOINT delete_oprn;
690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
691: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
693: FND_MSG_PUB.ADD;
694: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,