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

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

3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'gmd_fetch_oprn';
5: PROCEDURE fetch_oprn
6: ( p_api_version IN NUMBER ,
7: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
8: p_oprn_id IN NUMBER ,
9: p_orgn_code IN VARCHAR2 ,
10: x_return_status OUT NOCOPY VARCHAR2 ,
11: x_msg_count OUT NOCOPY NUMBER ,

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28: l_api_name VARCHAR2(30) := 'fetch_oprn';
29: l_api_version NUMBER := 1.0;
30: i NUMBER := 0;
31: BEGIN
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
35: l_api_name, G_PKG_NAME) THEN
36: RAISE FND_API.G_EXC_ERROR;

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

30: i NUMBER := 0;
31: BEGIN
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
35: l_api_name, G_PKG_NAME) THEN
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:

Line 36: RAISE FND_API.G_EXC_ERROR;

32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
35: l_api_name, G_PKG_NAME) THEN
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:
39: IF FND_API.to_Boolean(p_init_msg_list) THEN
40: FND_MSG_PUB.initialize;

Line 39: IF FND_API.to_Boolean(p_init_msg_list) THEN

35: l_api_name, G_PKG_NAME) THEN
36: RAISE FND_API.G_EXC_ERROR;
37: END IF;
38:
39: IF FND_API.to_Boolean(p_init_msg_list) THEN
40: FND_MSG_PUB.initialize;
41: END IF;
42:
43: OPEN Cur_validate_record;

Line 54: p_init_msg_list => FND_API.G_FALSE,

50: -- Bug #2415756 (JKB) Added validation above.
51:
52:
53: gmd_fetch_oprn.get_oprn_act(p_api_version => p_api_version,
54: p_init_msg_list => FND_API.G_FALSE,
55: p_oprn_id => p_oprn_id,
56: x_return_status => x_return_status,
57: x_msg_count => x_msg_count,
58: x_msg_data => x_msg_data,

Line 62: IF X_return_status = FND_API.g_ret_sts_success THEN

58: x_msg_data => x_msg_data,
59: x_return_code => x_return_code,
60: x_oprn_act_out => x_oprn_act_out);
61:
62: IF X_return_status = FND_API.g_ret_sts_success THEN
63: gmd_fetch_oprn.get_oprn_resc(p_api_version => p_api_version,
64: p_init_msg_list => FND_API.G_FALSE,
65: p_oprn_id => p_oprn_id,
66: p_orgn_code => p_orgn_code,

Line 64: p_init_msg_list => FND_API.G_FALSE,

60: x_oprn_act_out => x_oprn_act_out);
61:
62: IF X_return_status = FND_API.g_ret_sts_success THEN
63: gmd_fetch_oprn.get_oprn_resc(p_api_version => p_api_version,
64: p_init_msg_list => FND_API.G_FALSE,
65: p_oprn_id => p_oprn_id,
66: p_orgn_code => p_orgn_code,
67: x_return_status => x_return_status,
68: x_msg_count => x_msg_count,

Line 78: WHEN FND_API.G_EXC_ERROR THEN

74: /*standard call to get msge cnt, and if cnt is 1, get mesg info*/
75: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
76:
77: EXCEPTION
78: WHEN FND_API.G_EXC_ERROR THEN
79: X_return_code := SQLCODE;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
82:

Line 80: x_return_status := FND_API.G_RET_STS_ERROR;

76:
77: EXCEPTION
78: WHEN FND_API.G_EXC_ERROR THEN
79: X_return_code := SQLCODE;
80: x_return_status := FND_API.G_RET_STS_ERROR;
81: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
82:
83: WHEN INVALID_OPERATION THEN
84: x_return_status := FND_API.G_RET_STS_ERROR;

Line 84: x_return_status := FND_API.G_RET_STS_ERROR;

80: x_return_status := FND_API.G_RET_STS_ERROR;
81: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
82:
83: WHEN INVALID_OPERATION THEN
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: FND_MESSAGE.SET_NAME('GMD', 'FM_INVOPRN');
86: FND_MSG_PUB.ADD;
87: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
88: WHEN OTHERS THEN

Line 90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

86: FND_MSG_PUB.ADD;
87: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
88: WHEN OTHERS THEN
89: X_return_code := SQLCODE;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
92: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
93: END fetch_oprn;
94:

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

94:
95:
96: PROCEDURE get_oprn_act
97: ( p_api_version IN NUMBER ,
98: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
99: p_oprn_id IN NUMBER ,
100: x_return_status OUT NOCOPY VARCHAR2 ,
101: x_msg_count OUT NOCOPY NUMBER ,
102: x_msg_data OUT NOCOPY VARCHAR2 ,

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

130: ORDER BY a.oprn_line_id;
131:
132: begin
133:
134: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
135: l_api_name, G_PKG_NAME) THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132: begin
133:
134: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
135: l_api_name, G_PKG_NAME) THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138: IF FND_API.to_Boolean(p_init_msg_list) THEN
139: FND_MSG_PUB.initialize;
140: END IF;

Line 138: IF FND_API.to_Boolean(p_init_msg_list) THEN

134: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
135: l_api_name, G_PKG_NAME) THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138: IF FND_API.to_Boolean(p_init_msg_list) THEN
139: FND_MSG_PUB.initialize;
140: END IF;
141:
142: For get_rec IN get_oprn_act1 LOOP

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: FND_MSG_PUB.initialize;
140: END IF;
141:
142: For get_rec IN get_oprn_act1 LOOP
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144:
145: i := i + 1;
146:
147: x_oprn_act_out(i).oprn_no := get_rec.oprn_no ;

Line 202: RAISE fnd_api.g_exc_error;

198:
199: END LOOP;
200:
201: IF i = 0 THEN
202: RAISE fnd_api.g_exc_error;
203: END IF;
204:
205:
206:

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207: /*standard call to get msge cnt, and if cnt is 1, get mesg info*/
208: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: X_return_code := SQLCODE;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
215:

Line 213: x_return_status := FND_API.G_RET_STS_ERROR;

209:
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: X_return_code := SQLCODE;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
215:
216: WHEN OTHERS THEN
217: X_return_code := SQLCODE;

Line 218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

214: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
215:
216: WHEN OTHERS THEN
217: X_return_code := SQLCODE;
218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
219: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
220: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
221:
222: END get_oprn_act;

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

225:
226:
227: PROCEDURE get_oprn_resc
228: ( p_api_version IN NUMBER ,
229: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
230: p_oprn_id IN NUMBER ,
231: p_orgn_code IN VARCHAR2 ,
232: x_return_status OUT NOCOPY VARCHAR2 ,
233: x_msg_count OUT NOCOPY NUMBER ,

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

281:
282:
283: BEGIN
284:
285: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
286: l_api_name, G_PKG_NAME) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

283: BEGIN
284:
285: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
286: l_api_name, G_PKG_NAME) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289: IF FND_API.to_Boolean(p_init_msg_list) THEN
290: FND_MSG_PUB.initialize;
291: END IF;

Line 289: IF FND_API.to_Boolean(p_init_msg_list) THEN

285: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,
286: l_api_name, G_PKG_NAME) THEN
287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
288: END IF;
289: IF FND_API.to_Boolean(p_init_msg_list) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 293: x_return_status := FND_API.G_RET_STS_SUCCESS;

289: IF FND_API.to_Boolean(p_init_msg_list) THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: x_return_status := FND_API.G_RET_STS_SUCCESS;
294:
295: /* BUG#2621411 RajaSekhar Added capacity_tolerance field */
296:
297: For get_rec IN get_oprn_resc LOOP

Line 385: RAISE fnd_api.g_exc_error;

381: END LOOP;
382: END LOOP;
383:
384: IF i = 0 THEN
385: RAISE fnd_api.g_exc_error;
386: END IF;
387:
388: /* standard call to get msge cnt, and if cnt is 1, get mesg info */
389: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);

Line 392: WHEN FND_API.G_EXC_ERROR THEN

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

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

390:
391: EXCEPTION
392: WHEN FND_API.G_EXC_ERROR THEN
393: X_return_code := SQLCODE;
394: x_return_status := FND_API.G_RET_STS_ERROR;
395: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
396:
397: WHEN OTHERS THEN
398: X_return_code := SQLCODE;

Line 399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

395: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
396:
397: WHEN OTHERS THEN
398: X_return_code := SQLCODE;
399: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
400: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
401: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
402: END get_oprn_resc;
403:

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

402: END get_oprn_resc;
403:
404: PROCEDURE get_oprn_process_param_detl
405: ( p_api_version IN NUMBER ,
406: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
407: p_oprn_line_id IN NUMBER ,
408: p_resources IN VARCHAR2 ,
409: x_return_status OUT NOCOPY VARCHAR2 ,
410: x_msg_count OUT NOCOPY NUMBER ,

Line 429: x_return_status := FND_API.G_RET_STS_SUCCESS;

425: l_api_name VARCHAR2(40) := 'get_oprn_process_param_detl';
426: X_row NUMBER DEFAULT 0;
427: X_override NUMBER(5) DEFAULT 0;
428: BEGIN
429: x_return_status := FND_API.G_RET_STS_SUCCESS;
430:
431: FOR l_oprn_rec IN Cur_get_oprn_rsrc LOOP
432: X_row := X_row + 1;
433: X_oprn_resc_proc_param_tbl(X_row).recipe_id := NULL;

Line 456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

452: X_oprn_resc_proc_param_tbl(X_row).recipe_override := X_override;
453: END LOOP; /* FOR l_oprn_rec IN Cur_get_oprn_rsrc */
454: EXCEPTION
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
457: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
458: FND_MSG_PUB.Count_And_Get(p_count=>x_msg_count, p_data=>x_msg_data);
459: END get_oprn_process_param_detl;
460: