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 1102: IF x_return_status <> FND_API.g_ret_sts_success THEN

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

Line 1103: RAISE FND_API.g_exc_error;

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

Line 1160: WHEN FND_API.g_exc_error THEN

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

Line 1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1219: X_return_status := FND_API.g_ret_sts_success;

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

Line 1344: x_return_status := FND_API.g_ret_sts_success;

1340: /* Get the Routing Scale Factor */
1341: IF (l_debug = 'Y') THEN
1342: gmd_debug.put_line('In calc_charges proc initializing the variables ');
1343: END IF;
1344: x_return_status := FND_API.g_ret_sts_success;
1345:
1346: /* Get the Routing Scale Factor */
1347: IF (l_debug = 'Y') THEN
1348: gmd_debug.put_line('In calc_charges proc - before calling routing scale fact '

Line 1504: x_return_status := FND_API.g_ret_sts_success;

1500: IF (l_debug = 'Y') THEN
1501: gmd_debug.put_line('In CalcCharges Step Proc - ');
1502: END IF;
1503: /* Initialize variables */
1504: x_return_status := FND_API.g_ret_sts_success;
1505: FOR i IN 1..P_step_tbl.COUNT LOOP
1506: /*Bug 3669132 - Thomas Daniel */
1507: /*Initialize default charge variable to identify if the code has entered the following for loop */
1508: l_def_charge := NULL;

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

2354: l_formula_no varchar2(32);
2355: l_formula_vers number; --RLNAGARA B6982623
2356: l_recipe_no varchar2(32);
2357: l_recipe_version number;
2358: X_global_return_status varchar2(1) := FND_API.g_ret_sts_success;
2359:
2360: VALIDATION_FAIL EXCEPTION;
2361: NO_FORMULA EXCEPTION;
2362:

Line 2388: X_return_status := FND_API.g_ret_sts_error;

2384: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2385: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2386: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2387: fnd_msg_pub.ADD;
2388: X_return_status := FND_API.g_ret_sts_error;
2389: RAISE VALIDATION_FAIL;
2390: END IF;
2391: CLOSE Cur_formula_own;
2392:

Line 2403: X_return_status := FND_API.g_ret_sts_error;

2399: FND_MESSAGE.set_token('FORMULA_NO',l_formula_no);
2400: FND_MESSAGE.set_token('FORMULA_VERSION',l_formula_vers);
2401: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2402: fnd_msg_pub.ADD;
2403: X_return_status := FND_API.g_ret_sts_error;
2404: RAISE VALIDATION_FAIL;
2405: END IF;
2406: CLOSE Cur_formula_own_revision;
2407: END IF;

Line 2420: X_return_status := FND_API.g_ret_sts_error;

2416: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2417: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2418: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2419: fnd_msg_pub.ADD;
2420: X_return_status := FND_API.g_ret_sts_error;
2421: RAISE VALIDATION_FAIL;
2422: END IF;
2423: CLOSE Cur_recipe_own;
2424: -- Bug 5237351 added

Line 2435: X_return_status := FND_API.g_ret_sts_error;

2431: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2432: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2433: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2434: fnd_msg_pub.ADD;
2435: X_return_status := FND_API.g_ret_sts_error;
2436: RAISE VALIDATION_FAIL;
2437: END IF;
2438: CLOSE Cur_recipe_own_revision;
2439: END IF;

Line 2451: X_return_status := FND_API.g_ret_sts_error;

2447: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2448: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2449: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2450: fnd_msg_pub.ADD;
2451: X_return_status := FND_API.g_ret_sts_error;
2452: RAISE VALIDATION_FAIL;
2453: END IF;
2454: CLOSE Cur_recipe_override;
2455: -- Bug 5237351 added

Line 2466: X_return_status := FND_API.g_ret_sts_error;

2462: FND_MESSAGE.set_token('RECIPE_NO',l_recipe_no);
2463: FND_MESSAGE.set_token('RECIPE_VERSION',l_recipe_version);
2464: FND_MESSAGE.SET_TOKEN('ORGANIZATION_CODE',l_organization_code);
2465: fnd_msg_pub.ADD;
2466: X_return_status := FND_API.g_ret_sts_error;
2467: RAISE VALIDATION_FAIL;
2468: END IF;
2469: CLOSE Cur_recipe_override_revision;
2470: END IF;

Line 2480: X_return_status := FND_API.g_ret_sts_error;

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

Line 2495: X_return_status := FND_API.g_ret_sts_error;

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

Line 2502: x_return_status := FND_API.G_RET_STS_SUCCESS;

2498: CLOSE Cur_recipe_validity_revision;
2499: END IF;
2500:
2501: -- Final Return Status of the API
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;
2503: EXCEPTION
2504: WHEN VALIDATION_FAIL THEN
2505: x_return_status := FND_API.G_RET_STS_ERROR;
2506: WHEN NO_FORMULA THEN

Line 2505: x_return_status := FND_API.G_RET_STS_ERROR;

2501: -- Final Return Status of the API
2502: x_return_status := FND_API.G_RET_STS_SUCCESS;
2503: EXCEPTION
2504: WHEN VALIDATION_FAIL THEN
2505: x_return_status := FND_API.G_RET_STS_ERROR;
2506: WHEN NO_FORMULA THEN
2507: x_return_status := FND_API.G_RET_STS_SUCCESS;
2508:
2509: WHEN OTHERS THEN

Line 2507: x_return_status := FND_API.G_RET_STS_SUCCESS;

2503: EXCEPTION
2504: WHEN VALIDATION_FAIL THEN
2505: x_return_status := FND_API.G_RET_STS_ERROR;
2506: WHEN NO_FORMULA THEN
2507: x_return_status := FND_API.G_RET_STS_SUCCESS;
2508:
2509: WHEN OTHERS THEN
2510: X_return_status := FND_API.g_ret_sts_unexp_error;
2511:

Line 2510: X_return_status := FND_API.g_ret_sts_unexp_error;

2506: WHEN NO_FORMULA THEN
2507: x_return_status := FND_API.G_RET_STS_SUCCESS;
2508:
2509: WHEN OTHERS THEN
2510: X_return_status := FND_API.g_ret_sts_unexp_error;
2511:
2512: END check_formula_item_access;
2513:
2514: -- Kapil ME Auto-Prod :Bug# 5716318

Line 2607: x_return_status := FND_API.G_RET_STS_SUCCESS;

2603: AND base_uom_flag = 'Y';
2604:
2605: BEGIN
2606:
2607: x_return_status := FND_API.G_RET_STS_SUCCESS;
2608: FND_MSG_PUB.initialize;
2609:
2610: -- Check ORganization Parameters
2611: OPEN Cur_get_formula_org;

Line 2626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2622: GMD_API_GRP.FETCH_PARM_VALUES ( P_orgn_id => p_orgn_id ,
2623: P_parm_name => 'FM_YIELD_TYPE' ,
2624: P_parm_value => l_yield_type ,
2625: X_return_status => x_return_status );
2626: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2627: RETURN;
2628: END IF;
2629:
2630: /* Populate a local pl/sql table that will be iterated for further processings. */

Line 2823: x_return_status := fnd_api.g_ret_sts_unexp_error;

2819: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2820: p_data => x_msg_data);
2821: EXCEPTION
2822: WHEN CANNOT_CONVERT THEN
2823: x_return_status := fnd_api.g_ret_sts_unexp_error;
2824: fnd_msg_pub.count_and_get (p_count => x_msg_count,
2825: p_data => x_msg_data);
2826: END Calculate_Total_Product_Qty ;
2827: