DBA Data[Home] [Help]

APPS.INV_GMI_RSV_BRANCH dependencies on FND_API

Line 76: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN

72:
73: BEGIN
74:
75: -- Validate Input Attribute p_organization_id;
76: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN
77: RETURN FALSE;
78: END IF;
79:
80: -- Check IF Process Inventory Is Installed.

Line 94: WHEN fnd_api.g_exc_error THEN

90:
91: RETURN FALSE;
92:
93: EXCEPTION
94: WHEN fnd_api.g_exc_error THEN
95: RETURN FALSE;
96:
97: WHEN OTHERS THEN
98: --

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156:
157: BEGIN
158:
159: -- Initialize API return status to sucess
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161:
162: -- As long as there are records in the Global cache
163: -- search It to find matching organization id.
164:

Line 192: RAISE FND_API.G_EXC_ERROR;

188: -- add_process_org_to_cache(l_process_rec); /* INVCONV */
189: RETURN;
190: ELSE
191: -- Return Expected Error do I need A MESSAGE!!!
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194: -- END IF; End INVCONV
195: /* INVCONV x_opm_whse_code := l_opm_whse_code;
196: x_opm_co_code := l_opm_co_code;

Line 201: WHEN fnd_api.g_exc_error THEN

197: x_opm_orgn_code := l_opm_orgn_code; INVCONV */
198:
199: EXCEPTION
200:
201: WHEN fnd_api.g_exc_error THEN
202: x_return_status := fnd_api.g_ret_sts_error;
203: --
204: WHEN fnd_api.g_exc_unexpected_error THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 202: x_return_status := fnd_api.g_ret_sts_error;

198:
199: EXCEPTION
200:
201: WHEN fnd_api.g_exc_error THEN
202: x_return_status := fnd_api.g_ret_sts_error;
203: --
204: WHEN fnd_api.g_exc_unexpected_error THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error ;
206: --

Line 204: WHEN fnd_api.g_exc_unexpected_error THEN

200:
201: WHEN fnd_api.g_exc_error THEN
202: x_return_status := fnd_api.g_ret_sts_error;
203: --
204: WHEN fnd_api.g_exc_unexpected_error THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error ;
206: --
207: WHEN OTHERS THEN
208: x_return_status := fnd_api.g_ret_sts_unexp_error ;

Line 205: x_return_status := fnd_api.g_ret_sts_unexp_error ;

201: WHEN fnd_api.g_exc_error THEN
202: x_return_status := fnd_api.g_ret_sts_error;
203: --
204: WHEN fnd_api.g_exc_unexpected_error THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error ;
206: --
207: WHEN OTHERS THEN
208: x_return_status := fnd_api.g_ret_sts_unexp_error ;
209: --

Line 208: x_return_status := fnd_api.g_ret_sts_unexp_error ;

204: WHEN fnd_api.g_exc_unexpected_error THEN
205: x_return_status := fnd_api.g_ret_sts_unexp_error ;
206: --
207: WHEN OTHERS THEN
208: x_return_status := fnd_api.g_ret_sts_unexp_error ;
209: --
210: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
211: THEN
212: fnd_msg_pub.add_exc_msg

Line 278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

274: RETURN FALSE;
275:
276: EXCEPTION
277:
278: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: RETURN FALSE;
280:
281: WHEN OTHERS THEN
282: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 328: -- Call FND API to set Installed Flag

324:
325: BEGIN
326:
327:
328: -- Call FND API to set Installed Flag
329: IF fnd_installation.get_app_info( 'GMI',l_status,l_industry,l_schema) THEN
330: INV_GMI_RSV_BRANCH.G_PROCESS_INV_INSTALLED := l_status;
331: END IF;
332:

Line 397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

393: END IF;
394:
395: EXCEPTION
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: RETURN FALSE;
399:
400: WHEN OTHERS THEN
401: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 557: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN

553: END IF;
554:
555: END IF; */
556: -- Validate Input Attribute p_organization_id;
557: IF p_organization_id IS NULL OR p_organization_id = fnd_api.g_miss_num THEN
558: RETURN FALSE;
559: END IF;
560: process_enabled := 'N';
561: INV_GMI_RSV_BRANCH.G_PROCESS_ORGN := 'N';

Line 576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

572: End If;
573:
574: EXCEPTION
575:
576: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
577: RETURN FALSE;
578:
579: WHEN OTHERS THEN
580: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

640: RETURN FALSE;
641:
642: EXCEPTION
643:
644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
645: RETURN FALSE;
646:
647: WHEN OTHERS THEN
648: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME