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_RECIPE_FETCH_PUB dependencies on FND_API

Line 8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMD_FETCH_PUB';
5:
6: /* IN Parameters:
7: P_api_version - standard parameter
8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE
9: P_commit - standard parameter. Should be FND_API.G_FALSE
10: This procedure does no insert/update/delete
11: P_validation_level - standard parameter
12: OUT Parameters:

Line 9: P_commit - standard parameter. Should be FND_API.G_FALSE

5:
6: /* IN Parameters:
7: P_api_version - standard parameter
8: P_init_msg_list - standard parameter Should be FND_API.G_FALSE
9: P_commit - standard parameter. Should be FND_API.G_FALSE
10: This procedure does no insert/update/delete
11: P_validation_level - standard parameter
12: OUT Parameters:
13: x_return_status - standard parameter. S=success,E=expected error,

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

46: l_api_name CONSTANT VARCHAR2(30) := 'get_recipe_id';
47: l_api_version CONSTANT NUMBER := 1.0;
48:
49: BEGIN
50: IF (NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
51: l_api_name, G_PKG_NAME)) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

48:
49: BEGIN
50: IF (NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
51: l_api_name, G_PKG_NAME)) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54: IF FND_API.to_Boolean(p_init_msg_list) THEN
55: FND_MSG_PUB.initialize;
56: END IF;

Line 54: IF FND_API.to_Boolean(p_init_msg_list) THEN

50: IF (NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
51: l_api_name, G_PKG_NAME)) THEN
52: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
53: END IF;
54: IF FND_API.to_Boolean(p_init_msg_list) THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: END IF;
54: IF FND_API.to_Boolean(p_init_msg_list) THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58:
59: OPEN get_recp;
60: FETCH get_recp into x_recipe_id;
61: IF get_recp%NOTFOUND THEN

Line 62: RAISE fnd_api.g_exc_error;

58:
59: OPEN get_recp;
60: FETCH get_recp into x_recipe_id;
61: IF get_recp%NOTFOUND THEN
62: RAISE fnd_api.g_exc_error;
63: END IF;
64: CLOSE get_recp;
65:
66: -- standard call to get msge cnt, and if cnt is 1, get mesg info

Line 70: WHEN FND_API.G_EXC_ERROR THEN

66: -- standard call to get msge cnt, and if cnt is 1, get mesg info
67: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
68:
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: X_return_code := SQLCODE;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
74:

Line 72: x_return_status := FND_API.G_RET_STS_ERROR;

68:
69: EXCEPTION
70: WHEN FND_API.G_EXC_ERROR THEN
71: X_return_code := SQLCODE;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
74:
75: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
76: X_return_code := SQLCODE;

Line 75: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

71: X_return_code := SQLCODE;
72: x_return_status := FND_API.G_RET_STS_ERROR;
73: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
74:
75: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
76: X_return_code := SQLCODE;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
79:

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
74:
75: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
76: X_return_code := SQLCODE;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
79:
80: WHEN OTHERS THEN
81:

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79:
80: WHEN OTHERS THEN
81:
82: X_return_code := SQLCODE;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
85:
86: END get_recipe_id;
87:

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

122: l_api_name CONSTANT VARCHAR2(30) := 'get_routing_id';
123: l_api_version CONSTANT NUMBER := 1.0;
124:
125: BEGIN
126: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
127: l_api_name, G_PKG_NAME) THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

124:
125: BEGIN
126: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
127: l_api_name, G_PKG_NAME) THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: IF FND_API.to_Boolean(p_init_msg_list) THEN
131: FND_MSG_PUB.initialize;
132: END IF;

Line 130: IF FND_API.to_Boolean(p_init_msg_list) THEN

126: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
127: l_api_name, G_PKG_NAME) THEN
128: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
129: END IF;
130: IF FND_API.to_Boolean(p_init_msg_list) THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

129: END IF;
130: IF FND_API.to_Boolean(p_init_msg_list) THEN
131: FND_MSG_PUB.initialize;
132: END IF;
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:
135: OPEN get_rout;
136: FETCH get_rout into x_routing_id;
137: IF get_rout%NOTFOUND THEN

Line 138: RAISE fnd_api.g_exc_error;

134:
135: OPEN get_rout;
136: FETCH get_rout into x_routing_id;
137: IF get_rout%NOTFOUND THEN
138: RAISE fnd_api.g_exc_error;
139: END IF;
140: CLOSE get_rout;
141:
142: -- standard call to get msge cnt, and if cnt is 1, get mesg info

Line 146: WHEN FND_API.G_EXC_ERROR THEN

142: -- standard call to get msge cnt, and if cnt is 1, get mesg info
143: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
147: X_return_code := SQLCODE;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
150:

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

144:
145: EXCEPTION
146: WHEN FND_API.G_EXC_ERROR THEN
147: X_return_code := SQLCODE;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: X_return_code := SQLCODE;

Line 151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

147: X_return_code := SQLCODE;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: X_return_code := SQLCODE;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
155:

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: X_return_code := SQLCODE;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
155:
156: WHEN OTHERS THEN
157:

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

155:
156: WHEN OTHERS THEN
157:
158: X_return_code := SQLCODE;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
161:
162: END get_routing_id;
163:

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

209: ORDER BY routing_id;
210:
211: begin
212:
213: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
214: l_api_name, G_PKG_NAME) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: begin
212:
213: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
214: l_api_name, G_PKG_NAME) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: IF FND_API.to_Boolean(p_init_msg_list) THEN
218: FND_MSG_PUB.initialize;
219: END IF;

Line 217: IF FND_API.to_Boolean(p_init_msg_list) THEN

213: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
214: l_api_name, G_PKG_NAME) THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217: IF FND_API.to_Boolean(p_init_msg_list) THEN
218: FND_MSG_PUB.initialize;
219: END IF;
220:
221: For get_rec IN cur_rout_hdr LOOP

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: FND_MSG_PUB.initialize;
219: END IF;
220:
221: For get_rec IN cur_rout_hdr LOOP
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223:
224: i := i + 1;
225:
226: x_rout_out(i).routing_id := get_rec.routing_id ;

Line 284: RAISE fnd_api.g_exc_error;

280:
281: END LOOP;
282:
283: IF i= 0 THEN
284: RAISE fnd_api.g_exc_error;
285: END IF;
286:
287: -- standard call to get msge cnt, and if cnt is 1, get mesg info
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 291: WHEN FND_API.G_EXC_ERROR THEN

287: -- standard call to get msge cnt, and if cnt is 1, get mesg info
288: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: X_return_code := SQLCODE;
293: 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:

Line 293: x_return_status := FND_API.G_RET_STS_ERROR;

289:
290: EXCEPTION
291: WHEN FND_API.G_EXC_ERROR THEN
292: X_return_code := SQLCODE;
293: 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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: X_return_code := SQLCODE;

Line 296: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

292: X_return_code := SQLCODE;
293: 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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: X_return_code := SQLCODE;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
300:

Line 298: 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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
297: X_return_code := SQLCODE;
298: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
299: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
300:
301: WHEN OTHERS THEN
302: X_return_code := SQLCODE;

Line 303: 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: WHEN OTHERS THEN
302: X_return_code := SQLCODE;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
305:
306: END get_rout_hdr;
307:

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

342: l_api_name CONSTANT VARCHAR2(30) := 'get_formula_id';
343: l_api_version CONSTANT NUMBER := 1.0;
344:
345: BEGIN
346: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
347: l_api_name, G_PKG_NAME) THEN
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

344:
345: BEGIN
346: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
347: l_api_name, G_PKG_NAME) THEN
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350: IF FND_API.to_Boolean(p_init_msg_list) THEN
351: FND_MSG_PUB.initialize;
352: END IF;

Line 350: IF FND_API.to_Boolean(p_init_msg_list) THEN

346: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
347: l_api_name, G_PKG_NAME) THEN
348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;
350: IF FND_API.to_Boolean(p_init_msg_list) THEN
351: FND_MSG_PUB.initialize;
352: END IF;
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349: END IF;
350: IF FND_API.to_Boolean(p_init_msg_list) THEN
351: FND_MSG_PUB.initialize;
352: END IF;
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354:
355: OPEN get_form;
356: FETCH get_form into x_formula_id;
357:

Line 359: RAISE fnd_api.g_exc_error;

355: OPEN get_form;
356: FETCH get_form into x_formula_id;
357:
358: IF get_form%NOTFOUND THEN
359: RAISE fnd_api.g_exc_error;
360: END IF; -- end if formula_id not found
361:
362: CLOSE get_form;
363:

Line 368: WHEN FND_API.G_EXC_ERROR THEN

364: -- standard call to get msge cnt, and if cnt is 1, get mesg info
365: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: X_return_code := SQLCODE;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366:
367: EXCEPTION
368: WHEN FND_API.G_EXC_ERROR THEN
369: X_return_code := SQLCODE;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;

Line 373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

369: X_return_code := SQLCODE;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
377:

Line 375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

371: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: X_return_code := SQLCODE;
375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
376: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
377:
378: WHEN OTHERS THEN
379:

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

377:
378: WHEN OTHERS THEN
379:
380: X_return_code := SQLCODE;
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
383:
384: END get_formula_id;
385:

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

425: l_return_code NUMBER ;
426: l_msg_data VARCHAR2(2000) ;
427:
428: BEGIN
429: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
430: l_api_name, G_PKG_NAME) THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

427:
428: BEGIN
429: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
430: l_api_name, G_PKG_NAME) THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433: IF FND_API.to_Boolean(p_init_msg_list) THEN
434: FND_MSG_PUB.initialize;
435: END IF;

Line 433: IF FND_API.to_Boolean(p_init_msg_list) THEN

429: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
430: l_api_name, G_PKG_NAME) THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433: IF FND_API.to_Boolean(p_init_msg_list) THEN
434: FND_MSG_PUB.initialize;
435: END IF;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:

Line 436: x_return_status := FND_API.G_RET_STS_SUCCESS;

432: END IF;
433: IF FND_API.to_Boolean(p_init_msg_list) THEN
434: FND_MSG_PUB.initialize;
435: END IF;
436: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: -- call the get_routing_id procedure to check the routing exists or not
439: get_routing_id
440: ( p_api_version => 1.0 ,

Line 456: RAISE fnd_api.g_exc_error;

452: IF l_routing_id IS not null then
453: OPEN get_proc;
454: FETCH get_proc into x_process_loss;
455: ELSE
456: RAISE fnd_api.g_exc_error;
457: END IF;
458: /* IF get_proc%NOTFOUND THEN
459: RAISE fnd_api.g_exc_error;
460: END IF; -- end if recipe_id not found */

Line 459: RAISE fnd_api.g_exc_error;

455: ELSE
456: RAISE fnd_api.g_exc_error;
457: END IF;
458: /* IF get_proc%NOTFOUND THEN
459: RAISE fnd_api.g_exc_error;
460: END IF; -- end if recipe_id not found */
461:
462: CLOSE get_proc;
463:

Line 468: WHEN FND_API.G_EXC_ERROR THEN

464: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
465: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
466:
467: EXCEPTION
468: WHEN FND_API.G_EXC_ERROR THEN
469: X_return_code := SQLCODE;
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
472:

Line 470: x_return_status := FND_API.G_RET_STS_ERROR;

466:
467: EXCEPTION
468: WHEN FND_API.G_EXC_ERROR THEN
469: X_return_code := SQLCODE;
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: X_return_code := SQLCODE;

Line 473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

469: X_return_code := SQLCODE;
470: x_return_status := FND_API.G_RET_STS_ERROR;
471: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: X_return_code := SQLCODE;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
477:

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: X_return_code := SQLCODE;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
477:
478: WHEN OTHERS THEN
479:

Line 481: x_return_status := FND_API.G_RET_STS_ERROR;

477:
478: WHEN OTHERS THEN
479:
480: X_return_code := SQLCODE;
481: x_return_status := FND_API.G_RET_STS_ERROR;
482: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
483:
484: END get_process_loss;
485:

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

530: l_api_version CONSTANT NUMBER := 1.0;
531: i NUMBER := 0;
532:
533: BEGIN
534: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
535: l_api_name, G_PKG_NAME) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

532:
533: BEGIN
534: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
535: l_api_name, G_PKG_NAME) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538: IF FND_API.to_Boolean(p_init_msg_list) THEN
539: FND_MSG_PUB.initialize;
540: END IF;

Line 538: IF FND_API.to_Boolean(p_init_msg_list) THEN

534: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
535: l_api_name, G_PKG_NAME) THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: END IF;
538: IF FND_API.to_Boolean(p_init_msg_list) THEN
539: FND_MSG_PUB.initialize;
540: END IF;
541: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
542:

Line 541: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

537: END IF;
538: IF FND_API.to_Boolean(p_init_msg_list) THEN
539: FND_MSG_PUB.initialize;
540: END IF;
541: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543:
544: FOR get_rec IN get_matl LOOP
545: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 545: x_return_status := FND_API.G_RET_STS_SUCCESS;

541: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
542:
543:
544: FOR get_rec IN get_matl LOOP
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546: i := i + 1;
547:
548: x_recipe_rout_matl_tbl(i).recipe_id := get_rec.recipe_id;
549: x_recipe_rout_matl_tbl(i).formulaline_id := get_rec.formulaline_id ;

Line 599: RAISE fnd_api.g_exc_error;

595:
596: END LOOP;
597:
598: IF i = 0 THEN
599: RAISE fnd_api.g_exc_error;
600: END IF; -- end if recipe_id not found
601:
602: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
603: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 606: WHEN FND_API.G_EXC_ERROR THEN

602: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
603: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
604:
605: EXCEPTION
606: WHEN FND_API.G_EXC_ERROR THEN
607: X_return_code := SQLCODE;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
610:

Line 608: x_return_status := FND_API.G_RET_STS_ERROR;

604:
605: EXCEPTION
606: WHEN FND_API.G_EXC_ERROR THEN
607: X_return_code := SQLCODE;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
610:
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: X_return_code := SQLCODE;

Line 611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

607: X_return_code := SQLCODE;
608: x_return_status := FND_API.G_RET_STS_ERROR;
609: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
610:
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: X_return_code := SQLCODE;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
615:

Line 613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

609: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
610:
611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
612: X_return_code := SQLCODE;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
615:
616: WHEN OTHERS THEN
617: X_return_code := SQLCODE;

Line 618: x_return_status := FND_API.G_RET_STS_ERROR;

614: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
615:
616: WHEN OTHERS THEN
617: X_return_code := SQLCODE;
618: x_return_status := FND_API.G_RET_STS_ERROR;
619: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
620:
621: END get_rout_material;
622:

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

673: AND d.oprn_id = o.oprn_id ;
674: --END BUG#2330056
675:
676: BEGIN
677: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
678: l_api_name, G_PKG_NAME) THEN
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

675:
676: BEGIN
677: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
678: l_api_name, G_PKG_NAME) THEN
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681: IF FND_API.to_Boolean(p_init_msg_list) THEN
682: FND_MSG_PUB.initialize;
683: END IF;

Line 681: IF FND_API.to_Boolean(p_init_msg_list) THEN

677: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
678: l_api_name, G_PKG_NAME) THEN
679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
680: END IF;
681: IF FND_API.to_Boolean(p_init_msg_list) THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_SUCCESS;
685:

Line 684: x_return_status := FND_API.G_RET_STS_SUCCESS;

680: END IF;
681: IF FND_API.to_Boolean(p_init_msg_list) THEN
682: FND_MSG_PUB.initialize;
683: END IF;
684: x_return_status := FND_API.G_RET_STS_SUCCESS;
685:
686: For get_rec IN get_routing_step LOOP
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: i := i + 1;

Line 687: x_return_status := FND_API.G_RET_STS_SUCCESS;

683: END IF;
684: x_return_status := FND_API.G_RET_STS_SUCCESS;
685:
686: For get_rec IN get_routing_step LOOP
687: x_return_status := FND_API.G_RET_STS_SUCCESS;
688: i := i + 1;
689:
690: x_routing_step_out(i).routingstep_no := get_rec.routingstep_no ;
691: x_routing_step_out(i).routingstep_id := get_rec.routingstep_id ;

Line 744: RAISE fnd_api.g_exc_error;

740: x_routing_step_out(i).attribute30 := get_rec.attribute30;
741: END LOOP;
742:
743: IF i = 0 THEN
744: RAISE fnd_api.g_exc_error;
745: END IF; -- end if recipe_id not found
746:
747: -- standard call to get msge cnt, and if cnt is 1, get mesg info
748: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 751: WHEN FND_API.G_EXC_ERROR THEN

747: -- standard call to get msge cnt, and if cnt is 1, get mesg info
748: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
749:
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: X_return_code := SQLCODE;
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
755:

Line 753: x_return_status := FND_API.G_RET_STS_ERROR;

749:
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: X_return_code := SQLCODE;
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: X_return_code := SQLCODE;

Line 756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

752: X_return_code := SQLCODE;
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: X_return_code := SQLCODE;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
760:

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

754: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: X_return_code := SQLCODE;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
760:
761: WHEN OTHERS THEN
762: X_return_code := SQLCODE;

Line 763: x_return_status := FND_API.G_RET_STS_ERROR;

759: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
760:
761: WHEN OTHERS THEN
762: X_return_code := SQLCODE;
763: x_return_status := FND_API.G_RET_STS_ERROR;
764: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
765:
766: END get_routing_step_details;
767:

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

936: FROM org_access_view
937: WHERE organization_id = p_organization_id;
938:
939: BEGIN
940: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
941: l_api_name, G_PKG_NAME) THEN
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: END IF;
944:

Line 942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

938:
939: BEGIN
940: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
941: l_api_name, G_PKG_NAME) THEN
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: END IF;
944:
945: IF FND_API.to_Boolean(p_init_msg_list) THEN
946: FND_MSG_PUB.initialize;

Line 945: IF FND_API.to_Boolean(p_init_msg_list) THEN

941: l_api_name, G_PKG_NAME) THEN
942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
943: END IF;
944:
945: IF FND_API.to_Boolean(p_init_msg_list) THEN
946: FND_MSG_PUB.initialize;
947: END IF;
948:
949: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 949: x_return_status := FND_API.G_RET_STS_SUCCESS;

945: IF FND_API.to_Boolean(p_init_msg_list) THEN
946: FND_MSG_PUB.initialize;
947: END IF;
948:
949: x_return_status := FND_API.G_RET_STS_SUCCESS;
950:
951: -- call the get_routing_id procedure to check the routing exists or not
952: OPEN Cur_get_recipe;
953: FETCH Cur_get_recipe INTO l_routing_id, l_calculate_step_qty;

Line 973: IF l_return_status <> FND_API.g_ret_sts_success THEN

969: p_ignore_vol_conv => TRUE,
970: p_scale_factor => NVL(P_val_scale_factor,1),
971: p_process_loss => NVL(p_process_loss, 0),
972: p_organization_id => p_organization_id);
973: IF l_return_status <> FND_API.g_ret_sts_success THEN
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: ELSE
977: l_rout_scale_factor := GMD_COMMON_VAL.Get_Routing_Scale_Factor

Line 974: RAISE FND_API.G_EXC_ERROR;

970: p_scale_factor => NVL(P_val_scale_factor,1),
971: p_process_loss => NVL(p_process_loss, 0),
972: p_organization_id => p_organization_id);
973: IF l_return_status <> FND_API.g_ret_sts_success THEN
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: ELSE
977: l_rout_scale_factor := GMD_COMMON_VAL.Get_Routing_Scale_Factor
978: (vRecipe_Id => p_recipe_id

Line 1095: WHEN FND_API.G_EXC_ERROR THEN

1091: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
1092: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1093:
1094: EXCEPTION
1095: WHEN FND_API.G_EXC_ERROR THEN
1096: X_return_code := SQLCODE;
1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1099:

Line 1097: x_return_status := FND_API.G_RET_STS_ERROR;

1093:
1094: EXCEPTION
1095: WHEN FND_API.G_EXC_ERROR THEN
1096: X_return_code := SQLCODE;
1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1099:
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: X_return_code := SQLCODE;

Line 1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1096: X_return_code := SQLCODE;
1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1099:
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: X_return_code := SQLCODE;
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1103: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1104:

Line 1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1098: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1099:
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: X_return_code := SQLCODE;
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1103: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1104:
1105: WHEN OTHERS THEN
1106: X_return_code := SQLCODE;

Line 1107: x_return_status := FND_API.G_RET_STS_ERROR;

1103: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1104:
1105: WHEN OTHERS THEN
1106: X_return_code := SQLCODE;
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: FND_MSG_PUB.add_exc_msg ('GMD_RECIPE_FETCH_PUB', 'GET_RECIPE_STEP_DETAILS');
1109: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1110:
1111: END get_recipe_step_details;

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

1159: l_return_code NUMBER ;
1160: l_msg_data VARCHAR2(2000) ;
1161:
1162: BEGIN
1163: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1164: l_api_name, G_PKG_NAME) THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1161:
1162: BEGIN
1163: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1164: l_api_name, G_PKG_NAME) THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167: IF FND_API.to_Boolean(p_init_msg_list) THEN
1168: FND_MSG_PUB.initialize;
1169: END IF;

Line 1167: IF FND_API.to_Boolean(p_init_msg_list) THEN

1163: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1164: l_api_name, G_PKG_NAME) THEN
1165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1166: END IF;
1167: IF FND_API.to_Boolean(p_init_msg_list) THEN
1168: FND_MSG_PUB.initialize;
1169: END IF;
1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171: /*Check for circular step dependency */

Line 1170: x_return_status := FND_API.G_RET_STS_SUCCESS;

1166: END IF;
1167: IF FND_API.to_Boolean(p_init_msg_list) THEN
1168: FND_MSG_PUB.initialize;
1169: END IF;
1170: x_return_status := FND_API.G_RET_STS_SUCCESS;
1171: /*Check for circular step dependency */
1172: -- call the get_routing_id procedure to check the routing exists or not
1173:
1174: get_routing_id (

Line 1193: x_return_status := FND_API.G_RET_STS_SUCCESS;

1189: ELSE
1190:
1191: FOR get_rec IN get_depd LOOP
1192: i := i + 1;
1193: x_return_status := FND_API.G_RET_STS_SUCCESS;
1194: x_routing_depd_tbl(i).dep_routingstep_no := get_rec.dep_routingstep_no ;
1195: x_routing_depd_tbl(i).routingstep_no := get_rec.routingstep_no ;
1196: x_routing_depd_tbl(i).routing_id := get_rec.routing_id;
1197: x_routing_depd_tbl(i).dep_type := get_rec.dep_type;

Line 1217: RAISE fnd_api.g_exc_error;

1213: x_routing_depd_tbl(i).chargeable_ind := get_rec.chargeable_ind;
1214: END LOOP;
1215:
1216: IF i = 0 THEN
1217: RAISE fnd_api.g_exc_error;
1218: END IF;
1219: END IF;
1220: END IF;
1221:

Line 1226: WHEN FND_API.G_EXC_ERROR THEN

1222: /* standard call to get msge cnt, and if cnt is 1, get mesg info*/
1223: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1224:
1225: EXCEPTION
1226: WHEN FND_API.G_EXC_ERROR THEN
1227: X_return_code := SQLCODE;
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1230:

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR;

1224:
1225: EXCEPTION
1226: WHEN FND_API.G_EXC_ERROR THEN
1227: X_return_code := SQLCODE;
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1230:
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: X_return_code := SQLCODE;

Line 1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1227: X_return_code := SQLCODE;
1228: x_return_status := FND_API.G_RET_STS_ERROR;
1229: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1230:
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: X_return_code := SQLCODE;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1235:

Line 1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1229: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1230:
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: X_return_code := SQLCODE;
1233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1234: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1235:
1236: WHEN OTHERS THEN
1237: X_return_code := SQLCODE;

Line 1238: x_return_status := FND_API.G_RET_STS_ERROR;

1234: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1235:
1236: WHEN OTHERS THEN
1237: X_return_code := SQLCODE;
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1240:
1241: END get_step_depd_details;
1242:

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

1327: -- END BUG#2686887
1328:
1329: BEGIN
1330:
1331: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1332: l_api_name, G_PKG_NAME) THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1329: BEGIN
1330:
1331: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1332: l_api_name, G_PKG_NAME) THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335: IF FND_API.to_Boolean(p_init_msg_list) THEN
1336: FND_MSG_PUB.initialize;
1337: END IF;

Line 1335: IF FND_API.to_Boolean(p_init_msg_list) THEN

1331: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1332: l_api_name, G_PKG_NAME) THEN
1333: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1334: END IF;
1335: IF FND_API.to_Boolean(p_init_msg_list) THEN
1336: FND_MSG_PUB.initialize;
1337: END IF;
1338:
1339: FOR get_rec IN get_recp_act LOOP

Line 1340: x_return_status := FND_API.G_RET_STS_SUCCESS;

1336: FND_MSG_PUB.initialize;
1337: END IF;
1338:
1339: FOR get_rec IN get_recp_act LOOP
1340: x_return_status := FND_API.G_RET_STS_SUCCESS;
1341: i := i + 1;
1342: x_oprn_act_out(i).routingstep_no := get_rec.routing_step_no ;
1343: x_oprn_act_out(i).routingstep_id := get_rec.routingstep_id ;
1344: x_oprn_act_out(i).oprn_no := get_rec.oprn_no ;

Line 1400: RAISE fnd_api.g_exc_error;

1396:
1397: END LOOP;
1398:
1399: IF i = 0 THEN
1400: RAISE fnd_api.g_exc_error;
1401: END IF;
1402:
1403: /*standard call to get msge cnt, and if cnt is 1, get mesg info*/
1404: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 1407: WHEN FND_API.G_EXC_ERROR THEN

1403: /*standard call to get msge cnt, and if cnt is 1, get mesg info*/
1404: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1405:
1406: EXCEPTION
1407: WHEN FND_API.G_EXC_ERROR THEN
1408: X_return_code := SQLCODE;
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1411:

Line 1409: x_return_status := FND_API.G_RET_STS_ERROR;

1405:
1406: EXCEPTION
1407: WHEN FND_API.G_EXC_ERROR THEN
1408: X_return_code := SQLCODE;
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: X_return_code := SQLCODE;

Line 1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1408: X_return_code := SQLCODE;
1409: x_return_status := FND_API.G_RET_STS_ERROR;
1410: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: X_return_code := SQLCODE;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1416:

Line 1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1410: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: X_return_code := SQLCODE;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1416:
1417: WHEN OTHERS THEN
1418: X_return_code := SQLCODE;

Line 1419: x_return_status := FND_API.G_RET_STS_ERROR;

1415: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1416:
1417: WHEN OTHERS THEN
1418: X_return_code := SQLCODE;
1419: x_return_status := FND_API.G_RET_STS_ERROR;
1420: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1421:
1422: END get_oprn_act_detl;
1423:

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

1567:
1568: --END BUG #2686887
1569:
1570: BEGIN
1571: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1572: l_api_name, G_PKG_NAME) THEN
1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574: END IF;
1575: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1569:
1570: BEGIN
1571: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1572: l_api_name, G_PKG_NAME) THEN
1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574: END IF;
1575: IF FND_API.to_Boolean(p_init_msg_list) THEN
1576: FND_MSG_PUB.initialize;
1577: END IF;

Line 1575: IF FND_API.to_Boolean(p_init_msg_list) THEN

1571: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
1572: l_api_name, G_PKG_NAME) THEN
1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574: END IF;
1575: IF FND_API.to_Boolean(p_init_msg_list) THEN
1576: FND_MSG_PUB.initialize;
1577: END IF;
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:

Line 1578: x_return_status := FND_API.G_RET_STS_SUCCESS;

1574: END IF;
1575: IF FND_API.to_Boolean(p_init_msg_list) THEN
1576: FND_MSG_PUB.initialize;
1577: END IF;
1578: x_return_status := FND_API.G_RET_STS_SUCCESS;
1579:
1580: /* BUG#2621411 RajaSekhar Added capacity_tolerance field */
1581:
1582: FOR get_rec IN get_recp_resc LOOP

Line 1663: RAISE fnd_api.g_exc_error;

1659:
1660: END LOOP;
1661:
1662: IF i = 0 THEN
1663: RAISE fnd_api.g_exc_error;
1664: END IF; -- end if recipe_id not found
1665:
1666: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
1667: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 1670: WHEN FND_API.G_EXC_ERROR THEN

1666: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
1667: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1668:
1669: EXCEPTION
1670: WHEN FND_API.G_EXC_ERROR THEN
1671: X_return_code := SQLCODE;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1674:

Line 1672: x_return_status := FND_API.G_RET_STS_ERROR;

1668:
1669: EXCEPTION
1670: WHEN FND_API.G_EXC_ERROR THEN
1671: X_return_code := SQLCODE;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1674:
1675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1676: X_return_code := SQLCODE;

Line 1675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1671: X_return_code := SQLCODE;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1674:
1675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1676: X_return_code := SQLCODE;
1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1678: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1679:

Line 1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1673: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1674:
1675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1676: X_return_code := SQLCODE;
1677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1678: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1679:
1680: WHEN OTHERS THEN
1681: X_return_code := SQLCODE;

Line 1682: x_return_status := FND_API.G_RET_STS_ERROR;

1678: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1679:
1680: WHEN OTHERS THEN
1681: X_return_code := SQLCODE;
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
1684:
1685: END get_oprn_resc_detl;
1686:

Line 1970: x_return_status := FND_API.G_RET_STS_SUCCESS;

1966:
1967: BEGIN
1968:
1969: /* Set return status to success initially */
1970: x_return_status := FND_API.G_RET_STS_SUCCESS;
1971:
1972: /* Chk. whether the recipe id or the validity rule id is passed */
1973: IF (p_recipe_id IS NULL AND p_recipe_validity_rule_id IS NULL) THEN
1974: RAISE INVALID_DATA;

Line 2032: x_return_status := FND_API.G_RET_STS_ERROR;

2028: x_contiguous_ind := NULL;
2029: fnd_message.set_name ('GMI', 'GMI_MISSING');
2030: fnd_message.set_token ('MISSING', 'RECIPE_ID');
2031: fnd_msg_pub.add;
2032: x_return_status := FND_API.G_RET_STS_ERROR;
2033:
2034: END FETCH_CONTIGUOUS_IND;
2035:
2036: /*======================================================================

Line 2079: x_return_status := FND_API.G_RET_STS_SUCCESS;

2075:
2076: BEGIN
2077:
2078: /* Set return status to success initially */
2079: x_return_status := FND_API.G_RET_STS_SUCCESS;
2080:
2081: /* Chk. whether the recipe id or the validity rule id is passed */
2082: IF (p_recipe_id IS NULL AND p_recipe_validity_rule_id IS NULL) THEN
2083: RAISE INVALID_DATA;

Line 2120: x_return_status := FND_API.G_RET_STS_ERROR;

2116: x_enhanced_pi_ind := NULL;
2117: fnd_message.set_name ('GMI', 'GMI_MISSING');
2118: fnd_message.set_token ('MISSING', 'RECIPE_ID');
2119: fnd_msg_pub.add;
2120: x_return_status := FND_API.G_RET_STS_ERROR;
2121:
2122: END FETCH_ENHANCED_PI_IND;
2123:
2124: END GMD_RECIPE_FETCH_PUB ;