eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_COMMON_VAL dependencies on FND_API

Line 166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

162: **************************************************************************** */
163:
164: PROCEDURE customer_exists
165: ( p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
169: p_customer_id IN NUMBER,
170: p_site_id IN NUMBER,

Line 167: p_commit IN VARCHAR2 := FND_API.G_FALSE,

163:
164: PROCEDURE customer_exists
165: ( p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
169: p_customer_id IN NUMBER,
170: p_site_id IN NUMBER,
171: p_org_id IN NUMBER,

Line 168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

164: PROCEDURE customer_exists
165: ( p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
167: p_commit IN VARCHAR2 := FND_API.G_FALSE,
168: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
169: p_customer_id IN NUMBER,
170: p_site_id IN NUMBER,
171: p_org_id IN NUMBER,
172: p_customer_no IN VARCHAR2,

Line 243: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

239: l_org_id NUMBER;
240:
241: BEGIN
242: /* no SAVEPOINT needed because there is no insert/update/delete */
243: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
244: l_api_name, G_PKG_NAME) THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

241: BEGIN
242: /* no SAVEPOINT needed because there is no insert/update/delete */
243: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
244: l_api_name, G_PKG_NAME) THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF FND_API.to_Boolean(p_init_msg_list) THEN
248: FND_MSG_PUB.initialize;
249: END IF;

Line 247: IF FND_API.to_Boolean(p_init_msg_list) THEN

243: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
244: l_api_name, G_PKG_NAME) THEN
245: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: END IF;
247: IF FND_API.to_Boolean(p_init_msg_list) THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: END IF;
247: IF FND_API.to_Boolean(p_init_msg_list) THEN
248: FND_MSG_PUB.initialize;
249: END IF;
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: IF (p_customer_id IS NOT NULL OR p_customer_no IS NOT NULL) THEN
253: OPEN get_record;
254: FETCH get_record into x_customer_id;

Line 256: RAISE fnd_api.g_exc_error;

252: IF (p_customer_id IS NOT NULL OR p_customer_no IS NOT NULL) THEN
253: OPEN get_record;
254: FETCH get_record into x_customer_id;
255: IF get_record%NOTFOUND THEN
256: RAISE fnd_api.g_exc_error;
257: END IF;
258: CLOSE get_record;
259: END IF;
260:

Line 265: RAISE fnd_api.g_exc_error;

261: IF (p_site_id IS NOT NULL) THEN
262: OPEN get_site;
263: FETCH get_site into l_site_id;
264: IF get_site%NOTFOUND THEN
265: RAISE fnd_api.g_exc_error;
266: END IF;
267: CLOSE get_site;
268: END IF;
269:

Line 274: RAISE fnd_api.g_exc_error;

270: IF (p_org_id IS NOT NULL) THEN
271: OPEN get_orgid;
272: FETCH get_orgid into l_org_id;
273: IF get_orgid%NOTFOUND THEN
274: RAISE fnd_api.g_exc_error;
275: END IF;
276: CLOSE get_orgid;
277: END IF;
278:

Line 285: WHEN FND_API.G_EXC_ERROR THEN

281: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
282: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
283:
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:

Line 287: x_return_status := FND_API.G_RET_STS_ERROR;

283:
284: EXCEPTION
285: WHEN FND_API.G_EXC_ERROR THEN
286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: X_return_code := SQLCODE;

Line 290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

286: X_return_code := SQLCODE;
287: x_return_status := FND_API.G_RET_STS_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: X_return_code := SQLCODE;
292:
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

289:
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: X_return_code := SQLCODE;
292:
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
295:
296: WHEN OTHERS THEN
297: X_return_code := SQLCODE;

Line 298: x_return_status := FND_API.G_RET_STS_ERROR;

294: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
295:
296: WHEN OTHERS THEN
297: X_return_code := SQLCODE;
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
300:
301: END customer_exists;
302:

Line 362: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

358: *
359: **************************************************************************** */
360: PROCEDURE action_code
361: ( p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
363: p_commit IN VARCHAR2 := FND_API.G_FALSE,
364: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
365: p_action_code IN VARCHAR2,
366: x_return_status OUT NOCOPY VARCHAR2,

Line 363: p_commit IN VARCHAR2 := FND_API.G_FALSE,

359: **************************************************************************** */
360: PROCEDURE action_code
361: ( p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
363: p_commit IN VARCHAR2 := FND_API.G_FALSE,
364: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
365: p_action_code IN VARCHAR2,
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,

Line 364: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,

360: PROCEDURE action_code
361: ( p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
363: p_commit IN VARCHAR2 := FND_API.G_FALSE,
364: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_NONE,
365: p_action_code IN VARCHAR2,
366: x_return_status OUT NOCOPY VARCHAR2,
367: x_msg_count OUT NOCOPY NUMBER,
368: x_msg_data OUT NOCOPY VARCHAR2,

Line 377: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

373: l_api_version CONSTANT NUMBER := 1.0;
374:
375: BEGIN
376: /* no SAVEPOINT needed because there is no insert/update/delete */
377: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
378: l_api_name, G_PKG_NAME) THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

375: BEGIN
376: /* no SAVEPOINT needed because there is no insert/update/delete */
377: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
378: l_api_name, G_PKG_NAME) THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: IF FND_API.to_Boolean(p_init_msg_list) THEN
382: FND_MSG_PUB.initialize;
383: END IF;

Line 381: IF FND_API.to_Boolean(p_init_msg_list) THEN

377: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
378: l_api_name, G_PKG_NAME) THEN
379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
380: END IF;
381: IF FND_API.to_Boolean(p_init_msg_list) THEN
382: FND_MSG_PUB.initialize;
383: END IF;
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:

Line 384: x_return_status := FND_API.G_RET_STS_SUCCESS;

380: END IF;
381: IF FND_API.to_Boolean(p_init_msg_list) THEN
382: FND_MSG_PUB.initialize;
383: END IF;
384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:
386:
387: IF p_action_code is null or p_action_code not in ('I', 'U', 'D') THEN
388: RAISE fnd_api.g_exc_error;

Line 388: RAISE fnd_api.g_exc_error;

384: x_return_status := FND_API.G_RET_STS_SUCCESS;
385:
386:
387: IF p_action_code is null or p_action_code not in ('I', 'U', 'D') THEN
388: RAISE fnd_api.g_exc_error;
389: END IF;
390:
391: /* no standard check of p_commit because no insert/update/delete */
392:

Line 397: WHEN FND_API.G_EXC_ERROR THEN

393: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
394: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
395:
396: EXCEPTION
397: WHEN FND_API.G_EXC_ERROR THEN
398: X_return_code := SQLCODE;
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
401:

Line 399: x_return_status := FND_API.G_RET_STS_ERROR;

395:
396: EXCEPTION
397: WHEN FND_API.G_EXC_ERROR THEN
398: X_return_code := SQLCODE;
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
401:
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: X_return_code := SQLCODE;

Line 402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

398: X_return_code := SQLCODE;
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
401:
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: X_return_code := SQLCODE;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
406:

Line 404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

400: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
401:
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: X_return_code := SQLCODE;
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
406:
407: WHEN OTHERS THEN
408: X_return_code := SQLCODE;

Line 409: x_return_status := FND_API.G_RET_STS_ERROR;

405: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
406:
407: WHEN OTHERS THEN
408: X_return_code := SQLCODE;
409: x_return_status := FND_API.G_RET_STS_ERROR;
410:
411: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
412:
413: END action_code;

Line 950: WHEN FND_API.g_exc_error THEN

946: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
947: P_data => x_msg_data);
948:
949: EXCEPTION
950: WHEN FND_API.g_exc_error THEN
951: NULL;
952: When Others then
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

949: EXCEPTION
950: WHEN FND_API.g_exc_error THEN
951: NULL;
952: When Others then
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
955: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
956: FND_MSG_PUB.ADD;
957: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

Line 1103: IF x_return_status <> FND_API.g_ret_sts_success THEN

1099: ,p_scale_factor => p_scale_factor
1100: ,p_primaries => p_primaries
1101: ,x_scale_tab => l_material_tab
1102: ,x_return_status => x_return_status);
1103: IF x_return_status <> FND_API.g_ret_sts_success THEN
1104: RAISE FND_API.g_exc_error;
1105: END IF;
1106: END IF; /* IF NVL(p_scale_factor, 1) = 1 */
1107:

Line 1104: RAISE FND_API.g_exc_error;

1100: ,p_primaries => p_primaries
1101: ,x_scale_tab => l_material_tab
1102: ,x_return_status => x_return_status);
1103: IF x_return_status <> FND_API.g_ret_sts_success THEN
1104: RAISE FND_API.g_exc_error;
1105: END IF;
1106: END IF; /* IF NVL(p_scale_factor, 1) = 1 */
1107:
1108: /* Calculate the ingredient total quantities */

Line 1161: WHEN FND_API.g_exc_error THEN

1157: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,
1158: P_data => x_msg_data);
1159:
1160: EXCEPTION
1161: WHEN FND_API.g_exc_error THEN
1162: x_return_status := 'Q';
1163: WHEN Others THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

Line 1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1160: EXCEPTION
1161: WHEN FND_API.g_exc_error THEN
1162: x_return_status := 'Q';
1163: WHEN Others THEN
1164: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1165: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
1166: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1167: FND_MSG_PUB.ADD;
1168: FND_MSG_PUB.COUNT_AND_GET (P_count => x_msg_count,

Line 1220: X_return_status := FND_API.g_ret_sts_success;

1216: l_return_status VARCHAR2(1);
1217: l_msg_count NUMBER;
1218: l_msg_data VARCHAR2(2000);
1219: BEGIN
1220: X_return_status := FND_API.g_ret_sts_success;
1221: IF vRecipe_Id IS NOT NULL THEN
1222: OPEN Cur_get_recipe;
1223: FETCH Cur_get_recipe INTO l_formula_id, l_routing_id, l_calculate_step_qty;
1224: CLOSE Cur_get_recipe;

Line 1395: x_return_status := FND_API.g_ret_sts_success;

1391: /* Get the Routing Scale Factor */
1392: IF (l_debug = 'Y') THEN
1393: gmd_debug.put_line('In calc_charges proc initializing the variables ');
1394: END IF;
1395: x_return_status := FND_API.g_ret_sts_success;
1396:
1397: /* Get the Routing Scale Factor */
1398: IF (l_debug = 'Y') THEN
1399: gmd_debug.put_line('In calc_charges proc - before calling routing scale fact '

Line 1555: x_return_status := FND_API.g_ret_sts_success;

1551: IF (l_debug = 'Y') THEN
1552: gmd_debug.put_line('In CalcCharges Step Proc - ');
1553: END IF;
1554: /* Initialize variables */
1555: x_return_status := FND_API.g_ret_sts_success;
1556: FOR i IN 1..P_step_tbl.COUNT LOOP
1557: /*Bug 3669132 - Thomas Daniel */
1558: /*Initialize default charge variable to identify if the code has entered the following for loop */
1559: l_def_charge := NULL;

Line 2416: X_global_return_status varchar2(1) := FND_API.g_ret_sts_success;

2412: l_formula_no varchar2(32);
2413: l_formula_vers number; --RLNAGARA B6982623
2414: l_recipe_no varchar2(32);
2415: l_recipe_version number;
2416: X_global_return_status varchar2(1) := FND_API.g_ret_sts_success;
2417:
2418: VALIDATION_FAIL EXCEPTION;
2419: NO_FORMULA EXCEPTION;
2420:

Line 2446: X_return_status := FND_API.g_ret_sts_error;

2442: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2443: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2444: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2445: fnd_msg_pub.ADD;
2446: X_return_status := FND_API.g_ret_sts_error;
2447: RAISE VALIDATION_FAIL;
2448: END IF;
2449: CLOSE Cur_formula_own;
2450:

Line 2461: X_return_status := FND_API.g_ret_sts_error;

2457: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2458: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2459: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2460: fnd_msg_pub.ADD;
2461: X_return_status := FND_API.g_ret_sts_error;
2462: RAISE VALIDATION_FAIL;
2463: END IF;
2464: CLOSE Cur_formula_own_revision;
2465: END IF;

Line 2478: X_return_status := FND_API.g_ret_sts_error;

2474: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2475: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2476: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2477: fnd_msg_pub.ADD;
2478: X_return_status := FND_API.g_ret_sts_error;
2479: RAISE VALIDATION_FAIL;
2480: END IF;
2481: CLOSE Cur_recipe_own;
2482: -- Bug 5237351 added

Line 2493: X_return_status := FND_API.g_ret_sts_error;

2489: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2490: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2491: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2492: fnd_msg_pub.ADD;
2493: X_return_status := FND_API.g_ret_sts_error;
2494: RAISE VALIDATION_FAIL;
2495: END IF;
2496: CLOSE Cur_recipe_own_revision;
2497: END IF;

Line 2509: X_return_status := FND_API.g_ret_sts_error;

2505: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2506: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2507: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2508: fnd_msg_pub.ADD;
2509: X_return_status := FND_API.g_ret_sts_error;
2510: RAISE VALIDATION_FAIL;
2511: END IF;
2512: CLOSE Cur_recipe_override;
2513: -- Bug 5237351 added

Line 2524: X_return_status := FND_API.g_ret_sts_error;

2520: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2521: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2522: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2523: fnd_msg_pub.ADD;
2524: X_return_status := FND_API.g_ret_sts_error;
2525: RAISE VALIDATION_FAIL;
2526: END IF;
2527: CLOSE Cur_recipe_override_revision;
2528: END IF;

Line 2538: X_return_status := FND_API.g_ret_sts_error;

2534: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2535: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2536: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2537: fnd_msg_pub.ADD;
2538: X_return_status := FND_API.g_ret_sts_error;
2539: RAISE VALIDATION_FAIL;
2540: END IF;
2541: CLOSE Cur_recipe_validity;
2542: -- Bug 5237351 added

Line 2553: X_return_status := FND_API.g_ret_sts_error;

2549: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2550: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2551: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2552: fnd_msg_pub.ADD;
2553: X_return_status := FND_API.g_ret_sts_error;
2554: RAISE VALIDATION_FAIL;
2555: END IF;
2556: CLOSE Cur_recipe_validity_revision;
2557: END IF;

Line 2560: x_return_status := FND_API.G_RET_STS_SUCCESS;

2556: CLOSE Cur_recipe_validity_revision;
2557: END IF;
2558:
2559: -- Final Return Status of the API
2560: x_return_status := FND_API.G_RET_STS_SUCCESS;
2561: EXCEPTION
2562: WHEN VALIDATION_FAIL THEN
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564: WHEN NO_FORMULA THEN

Line 2563: x_return_status := FND_API.G_RET_STS_ERROR;

2559: -- Final Return Status of the API
2560: x_return_status := FND_API.G_RET_STS_SUCCESS;
2561: EXCEPTION
2562: WHEN VALIDATION_FAIL THEN
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564: WHEN NO_FORMULA THEN
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566:
2567: WHEN OTHERS THEN

Line 2565: x_return_status := FND_API.G_RET_STS_SUCCESS;

2561: EXCEPTION
2562: WHEN VALIDATION_FAIL THEN
2563: x_return_status := FND_API.G_RET_STS_ERROR;
2564: WHEN NO_FORMULA THEN
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566:
2567: WHEN OTHERS THEN
2568: X_return_status := FND_API.g_ret_sts_unexp_error;
2569:

Line 2568: X_return_status := FND_API.g_ret_sts_unexp_error;

2564: WHEN NO_FORMULA THEN
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;
2566:
2567: WHEN OTHERS THEN
2568: X_return_status := FND_API.g_ret_sts_unexp_error;
2569:
2570: END check_formula_item_access;
2571:
2572: -- Kapil ME Auto-Prod :Bug# 5716318

Line 2666: x_return_status := FND_API.G_RET_STS_SUCCESS;

2662: AND base_uom_flag = 'Y';
2663:
2664: BEGIN
2665:
2666: x_return_status := FND_API.G_RET_STS_SUCCESS;
2667: FND_MSG_PUB.initialize;
2668:
2669: -- Check ORganization Parameters
2670: OPEN Cur_get_formula_org;

Line 2685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2681: GMD_API_GRP.FETCH_PARM_VALUES ( P_orgn_id => p_orgn_id ,
2682: P_parm_name => 'FM_YIELD_TYPE' ,
2683: P_parm_value => l_yield_type ,
2684: X_return_status => x_return_status );
2685: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2686: RETURN;
2687: END IF;
2688:
2689: /* Bug no.7145922 - Start */

Line 2897: x_return_status := fnd_api.g_ret_sts_unexp_error;

2893: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2894: p_data => x_msg_data);
2895: EXCEPTION
2896: WHEN CANNOT_CONVERT THEN
2897: x_return_status := fnd_api.g_ret_sts_unexp_error;
2898: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2899: p_data => x_msg_data);
2900: END Calculate_Total_Product_Qty ;
2901: