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.sequence_dependent_ind, 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 287: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,

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

Line 289: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 291: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 387: RAISE fnd_api.g_exc_error;

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

Line 394: WHEN FND_API.G_EXC_ERROR THEN

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

Line 396: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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