DBA Data[Home] [Help]

APPS.GMD_OPERATION_RESOURCES_PUB dependencies on FND_API

Line 173: x_return_status := FND_API.g_ret_sts_success;

169: BEGIN
170: SAVEPOINT insert_oprn_rsrc;
171:
172: /* Initially let us assign the return status to success */
173: x_return_status := FND_API.g_ret_sts_success;
174:
175: IF NOT gmd_api_grp.setup_done THEN
176: gmd_api_grp.setup_done := gmd_api_grp.setup;
177: END IF;

Line 183: IF NOT FND_API.compatible_api_call(l_api_version

179: RAISE setup_failure;
180: END IF;
181:
182: /* Make sure we are call compatible */
183: IF NOT FND_API.compatible_api_call(l_api_version
184: ,p_api_version
185: ,'insert_operation_resources'
186: ,'gmd_operation_resources_pub') THEN
187: RAISE invalid_version;

Line 405: IF x_return_status = FND_API.g_ret_sts_success THEN

401: RAISE ins_oprn_rsrc_err;
402: END IF;
403:
404: /* Lets initialialize the default values */
405: IF x_return_status = FND_API.g_ret_sts_success THEN
406: OPEN fetch_proc_uom (p_oprn_line_id);
407: FETCH fetch_proc_uom INTO l_oprn_rsrc_tbl(i).resource_process_uom;
408: CLOSE fetch_proc_uom;
409: END IF;

Line 423: IF l_return_status <> FND_API.g_ret_sts_success THEN

419: x_message_count => x_message_count,
420: x_message_list => x_message_list,
421: x_return_status => l_return_status);
422:
423: IF l_return_status <> FND_API.g_ret_sts_success THEN
424: RAISE ins_oprn_rsrc_err;
425: END IF;
426:
427: /* Let us check if their are more than one resource marked as primary */

Line 460: x_return_status := FND_API.G_RET_STS_ERROR;

456: END IF;
457: EXCEPTION
458: WHEN setup_failure OR invalid_version OR inv_resource_ind THEN
459: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
460: x_return_status := FND_API.G_RET_STS_ERROR;
461: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
462: P_data => x_message_list);
463: WHEN ins_oprn_rsrc_err THEN
464: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;

Line 465: x_return_status := FND_API.G_RET_STS_ERROR;

461: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
462: P_data => x_message_list);
463: WHEN ins_oprn_rsrc_err THEN
464: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
467: P_data => x_message_list);
468: WHEN OTHERS THEN
469: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

466: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
467: P_data => x_message_list);
468: WHEN OTHERS THEN
469: ROLLBACK TO SAVEPOINT insert_oprn_rsrc;
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
472: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
473: FND_MSG_PUB.ADD;
474: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 514: x_return_status := FND_API.g_ret_sts_success;

510: BEGIN
511: SAVEPOINT update_oprn_rsrc;
512:
513: /* Initially let us assign the return status to success */
514: x_return_status := FND_API.g_ret_sts_success;
515:
516: /* Make sure we are call compatible */
517: IF NOT FND_API.compatible_api_call(l_api_version
518: ,p_api_version

Line 517: IF NOT FND_API.compatible_api_call(l_api_version

513: /* Initially let us assign the return status to success */
514: x_return_status := FND_API.g_ret_sts_success;
515:
516: /* Make sure we are call compatible */
517: IF NOT FND_API.compatible_api_call(l_api_version
518: ,p_api_version
519: ,'update_operation_resources'
520: ,'gmd_operation_resources_pub') THEN
521: RAISE invalid_version;

Line 706: IF l_return_status <> FND_API.g_ret_sts_success THEN

702: , p_update_table => p_update_table
703: , x_message_count => x_message_count
704: , x_message_list => x_message_list
705: , x_return_status => l_return_status);
706: IF l_return_status <> FND_API.g_ret_sts_success THEN
707: RAISE upd_oprn_rsrc_err;
708: END IF;
709: IF p_commit THEN
710: COMMIT;

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720:
721: EXCEPTION
722: WHEN invalid_version OR setup_failure THEN
723: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
726: P_data => x_message_list);
727: WHEN upd_oprn_rsrc_err THEN
728: ROLLBACK TO SAVEPOINT update_oprn_rsrc;

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

725: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
726: P_data => x_message_list);
727: WHEN upd_oprn_rsrc_err THEN
728: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
731: P_data => x_message_list);
732: WHEN OTHERS THEN
733: ROLLBACK TO SAVEPOINT update_oprn_rsrc;

Line 734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

730: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
731: P_data => x_message_list);
732: WHEN OTHERS THEN
733: ROLLBACK TO SAVEPOINT update_oprn_rsrc;
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
736: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
737: FND_MSG_PUB.ADD;
738: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,

Line 790: x_return_status := FND_API.g_ret_sts_success;

786: BEGIN
787: SAVEPOINT delete_oprn_rsrc;
788:
789: /* Initially let us assign the return status to success */
790: x_return_status := FND_API.g_ret_sts_success;
791:
792: /* Initialize message list and count if needed */
793: IF p_init_msg_list THEN
794: fnd_msg_pub.initialize;

Line 798: IF NOT FND_API.compatible_api_call(l_api_version

794: fnd_msg_pub.initialize;
795: END IF;
796:
797: /* Make sure we are call compatible */
798: IF NOT FND_API.compatible_api_call(l_api_version
799: ,p_api_version
800: ,'delete_operation_resources'
801: ,'gmd_operation_resources_pub') THEN
802: RAISE invalid_version;

Line 861: IF x_return_status = FND_API.g_ret_sts_success THEN

857: RAISE del_oprn_rsrc_err;
858: END IF;
859:
860:
861: IF x_return_status = FND_API.g_ret_sts_success THEN
862: /* Call PVT delete_operation_resources */
863: IF (l_debug = 'Y') THEN
864: gmd_debug.put_line('before call to delete_operation_resource PVT');
865: END IF;

Line 871: IF l_return_status <> FND_API.g_ret_sts_success THEN

867: ,p_resources => p_resources
868: , x_message_count => x_message_count
869: , x_message_list => x_message_list
870: , x_return_status => l_return_status);
871: IF l_return_status <> FND_API.g_ret_sts_success THEN
872: RAISE del_oprn_rsrc_err;
873: END IF;
874:
875: /* This implies that we are setting this current resource as secondary or auxillary */

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896:
897: EXCEPTION
898: WHEN invalid_version OR setup_failure OR inv_resource_ind THEN
899: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
902: P_data => x_message_list);
903: WHEN del_oprn_rsrc_err THEN
904: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;

Line 905: x_return_status := FND_API.G_RET_STS_ERROR;

901: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
902: P_data => x_message_list);
903: WHEN del_oprn_rsrc_err THEN
904: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
905: x_return_status := FND_API.G_RET_STS_ERROR;
906: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
907: P_data => x_message_list);
908: WHEN OTHERS THEN
909: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,
907: P_data => x_message_list);
908: WHEN OTHERS THEN
909: ROLLBACK TO SAVEPOINT delete_oprn_rsrc;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
912: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
913: FND_MSG_PUB.ADD;
914: FND_MSG_PUB.COUNT_AND_GET (P_count => x_message_count,