DBA Data[Home] [Help]

APPS.IEO_MEDIA_PUB dependencies on FND_API

Line 30: IF NOT FND_API.Compatible_API_Call (l_api_version ,

26: x_err_num NUMBER;
27: x_err_msg VARCHAR2(256);
28:
29: BEGIN
30: IF NOT FND_API.Compatible_API_Call (l_api_version ,
31: p_api_version ,
32: l_api_name ,
33: G_PKG_NAME )
34: THEN

Line 35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

31: p_api_version ,
32: l_api_name ,
33: G_PKG_NAME )
34: THEN
35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37: -- Initialize message list if p_init_msg_list is set to TRUE.
38: IF FND_API.to_Boolean( p_init_msg_list ) THEN
39: FND_MSG_PUB.initialize;

Line 38: IF FND_API.to_Boolean( p_init_msg_list ) THEN

34: THEN
35: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37: -- Initialize message list if p_init_msg_list is set to TRUE.
38: IF FND_API.to_Boolean( p_init_msg_list ) THEN
39: FND_MSG_PUB.initialize;
40: END IF;
41: -- Initialize API return status to failure
42:

Line 43: x_return_status := FND_API.G_RET_STS_SUCCESS ;

39: FND_MSG_PUB.initialize;
40: END IF;
41: -- Initialize API return status to failure
42:
43: x_return_status := FND_API.G_RET_STS_SUCCESS ;
44: x_msg_count := 0;
45: x_msg_data := null;
46:
47: -- API body

Line 59: IF FND_API.To_Boolean( p_commit ) THEN

55:
56: if sql%notfound then raise NO_DATA_FOUND;
57: end if;
58:
59: IF FND_API.To_Boolean( p_commit ) THEN
60: COMMIT WORK;
61: END IF;
62:
63: EXCEPTION

Line 85: IF FND_API.To_Boolean( p_commit ) THEN

81: ieo_media_rt_device_map_s1.nextval,
82: 1, sysdate, 1, sysdate, 1
83: );
84:
85: IF FND_API.To_Boolean( p_commit ) THEN
86: COMMIT WORK;
87: END IF;
88:
89: WHEN FND_API.G_EXC_ERROR THEN

Line 89: WHEN FND_API.G_EXC_ERROR THEN

85: IF FND_API.To_Boolean( p_commit ) THEN
86: COMMIT WORK;
87: END IF;
88:
89: WHEN FND_API.G_EXC_ERROR THEN
90: rollback;
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: x_msg_count := 1;
93: x_err_num := SQLCODE;

Line 91: x_return_status := FND_API.G_RET_STS_ERROR ;

87: END IF;
88:
89: WHEN FND_API.G_EXC_ERROR THEN
90: rollback;
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: x_msg_count := 1;
93: x_err_num := SQLCODE;
94: x_err_msg := SUBSTR(SQLERRM, 1, 100);
95: x_msg_data := 'UPDATE_DEVICE_MAP: IEO_EXC_ERROR'

Line 100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

96: || ' ErrorCode = ' || x_err_num
97: || ' ErrorMsg = ' || x_err_msg;
98: --dbms_output.put_line(x_msg_data);
99:
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: --dbms_output.put_line('Unexpected error');
102: ROLLBACK;
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: x_msg_count := 1;

Line 103: x_return_status := FND_API.G_RET_STS_ERROR ;

99:
100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
101: --dbms_output.put_line('Unexpected error');
102: ROLLBACK;
103: x_return_status := FND_API.G_RET_STS_ERROR ;
104: x_msg_count := 1;
105: x_err_num := SQLCODE;
106: x_err_msg := SUBSTR(SQLERRM, 1, 100);
107: x_msg_data := 'UPDATE_DEVICE_MAP: IEO_UNEXPECTED_ERROR'

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

109: || ' ErrorMsg = ' || x_err_msg;
110: --dbms_output.put_line(x_msg_data);
111: WHEN OTHERS THEN
112: rollback;
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
114: x_msg_count := 1;
115: x_err_num := SQLCODE;
116: x_err_msg := SUBSTR(SQLERRM, 1, 100);
117: x_msg_data := 'UPDATE_DEVICE_MAP: IEO_OTHERS_ERROR'

Line 148: IF NOT FND_API.Compatible_API_Call (l_api_version ,

144: x_err_msg VARCHAR2(256);
145: l_server_group_id NUMBER;
146:
147: BEGIN
148: IF NOT FND_API.Compatible_API_Call (l_api_version ,
149: p_api_version ,
150: l_api_name ,
151: G_PKG_NAME )
152: THEN

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: p_api_version ,
150: l_api_name ,
151: G_PKG_NAME )
152: THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;

Line 156: IF FND_API.to_Boolean( p_init_msg_list ) THEN

152: THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: IF FND_API.to_Boolean( p_init_msg_list ) THEN
157: FND_MSG_PUB.initialize;
158: END IF;
159: -- Initialize API return status to success
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: x_server_id := null;
162: x_device_map_id := -1;
163: -- API body
164: --dbms_output.put_line('GET_DEVICE_LOCATION: server_group_name = ' || p_server_group_name

Line 192: IF FND_API.To_Boolean( p_commit ) THEN

188:
189: x_msg_data := null;
190: x_msg_count :=0;
191:
192: IF FND_API.To_Boolean( p_commit ) THEN
193: COMMIT WORK;
194: END IF;
195:
196:

Line 199: IF FND_API.To_Boolean( p_commit ) THEN

195:
196:
197: EXCEPTION
198: WHEN NO_DATA_FOUND THEN
199: IF FND_API.To_Boolean( p_commit ) THEN
200: COMMIT WORK;
201: END IF;
202:
203: WHEN FND_API.G_EXC_ERROR THEN

Line 203: WHEN FND_API.G_EXC_ERROR THEN

199: IF FND_API.To_Boolean( p_commit ) THEN
200: COMMIT WORK;
201: END IF;
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: rollback;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: x_msg_count := 1;
207: x_err_num := SQLCODE;

Line 205: x_return_status := FND_API.G_RET_STS_ERROR ;

201: END IF;
202:
203: WHEN FND_API.G_EXC_ERROR THEN
204: rollback;
205: x_return_status := FND_API.G_RET_STS_ERROR ;
206: x_msg_count := 1;
207: x_err_num := SQLCODE;
208: x_err_msg := SUBSTR(SQLERRM, 1, 100);
209: x_msg_data :='UPDATE_ROUTE_RESULT: IEO_EXC_ERROR'

Line 213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

209: x_msg_data :='UPDATE_ROUTE_RESULT: IEO_EXC_ERROR'
210: || ' ErrorCode = ' || x_err_num
211: || ' ErrorMsg = ' || x_err_msg;
212: --dbms_output.put_line(x_msg_data);
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: ROLLBACK;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: x_msg_count := 1;
217: x_err_num := SQLCODE;

Line 215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

211: || ' ErrorMsg = ' || x_err_msg;
212: --dbms_output.put_line(x_msg_data);
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: ROLLBACK;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: x_msg_count := 1;
217: x_err_num := SQLCODE;
218: x_err_msg := SUBSTR(SQLERRM, 1, 100);
219: x_msg_data :='UPDATE_ROUTE_RESULT: IEO_UNEXPECTED_ERROR'

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

221: || ' ErrorMsg = ' || x_err_msg;
222: --dbms_output.put_line(x_msg_data);
223: WHEN OTHERS THEN
224: rollback;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
226: x_msg_count := 1;
227: x_err_num := SQLCODE;
228: x_err_msg := SUBSTR(SQLERRM, 1, 100);
229: x_msg_data :='UPDATE_ROUTE_RESULT: IEO_OTHERS_ERROR'

Line 257: IF NOT FND_API.Compatible_API_Call (l_api_version ,

253: x_err_num NUMBER;
254: x_err_msg VARCHAR2(256);
255:
256: BEGIN
257: IF NOT FND_API.Compatible_API_Call (l_api_version ,
258: p_api_version ,
259: l_api_name ,
260: G_PKG_NAME )
261: THEN

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: p_api_version ,
259: l_api_name ,
260: G_PKG_NAME )
261: THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;

Line 265: IF FND_API.to_Boolean( p_init_msg_list ) THEN

261: THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: END IF;
264: -- Initialize message list if p_init_msg_list is set to TRUE.
265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS ;

265: IF FND_API.to_Boolean( p_init_msg_list ) THEN
266: FND_MSG_PUB.initialize;
267: END IF;
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS ;
270: x_msg_data := 'LOCATE_LEAST_LOADED_IN_GROUP: server_group '
271: || p_server_group_name || ' not found';
272: x_msg_count := 1;
273: x_server_id := null;

Line 292: IF FND_API.To_Boolean( p_commit ) THEN

288:
289: x_msg_count :=0;
290: x_msg_data := null;
291:
292: IF FND_API.To_Boolean( p_commit ) THEN
293: COMMIT WORK;
294: END IF;
295: EXCEPTION
296: -- WHEN AGENT_NOT_FOUND THEN

Line 307: WHEN FND_API.G_EXC_ERROR THEN

303: || ' ErrorCode = ' || x_err_num
304: || ' ErrorMsg = ' || x_err_msg;
305: --dbms_output.put_line(x_msg_data);
306:
307: WHEN FND_API.G_EXC_ERROR THEN
308: rollback;
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: x_msg_count := 1;
311: x_err_num := SQLCODE;

Line 309: x_return_status := FND_API.G_RET_STS_ERROR ;

305: --dbms_output.put_line(x_msg_data);
306:
307: WHEN FND_API.G_EXC_ERROR THEN
308: rollback;
309: x_return_status := FND_API.G_RET_STS_ERROR ;
310: x_msg_count := 1;
311: x_err_num := SQLCODE;
312: x_err_msg := SUBSTR(SQLERRM, 1, 100);
313: x_msg_data :='LOCATE_LEAST_LOADED_IN_GROUP: IEO_EXC_ERROR'

Line 317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

313: x_msg_data :='LOCATE_LEAST_LOADED_IN_GROUP: IEO_EXC_ERROR'
314: || ' ErrorCode = ' || x_err_num
315: || ' ErrorMsg = ' || x_err_msg;
316: --dbms_output.put_line(x_msg_data);
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: rollback;
319: x_return_status := FND_API.G_RET_STS_ERROR ;
320: x_msg_count := 1;
321: x_err_num := SQLCODE;

Line 319: x_return_status := FND_API.G_RET_STS_ERROR ;

315: || ' ErrorMsg = ' || x_err_msg;
316: --dbms_output.put_line(x_msg_data);
317: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
318: rollback;
319: x_return_status := FND_API.G_RET_STS_ERROR ;
320: x_msg_count := 1;
321: x_err_num := SQLCODE;
322: x_err_msg := SUBSTR(SQLERRM, 1, 100);
323: x_msg_data :='LOCATE_LEAST_LOADED_IN_GROUP: IEO_UNEXPECTED_ERROR'

Line 329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

325: || ' ErrorMsg = ' || x_err_msg;
326: --dbms_output.put_line(x_msg_data);
327: WHEN OTHERS THEN
328: rollback;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
330: x_msg_count := 1;
331: x_err_num := SQLCODE;
332: x_err_msg := SUBSTR(SQLERRM, 1, 100);
333: x_msg_data :='LOCATE_LEAST_LOADED_IN_GROUP: IEO_OTHERS_ERROR'

Line 363: IF NOT FND_API.Compatible_API_Call (l_api_version ,

359: x_err_num NUMBER;
360: x_err_msg VARCHAR2(256);
361:
362: BEGIN
363: IF NOT FND_API.Compatible_API_Call (l_api_version ,
364: p_api_version ,
365: l_api_name ,
366: G_PKG_NAME )
367: THEN

Line 368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

364: p_api_version ,
365: l_api_name ,
366: G_PKG_NAME )
367: THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370: -- Initialize message list if p_init_msg_list is set to TRUE.
371: IF FND_API.to_Boolean( p_init_msg_list ) THEN
372: FND_MSG_PUB.initialize;

Line 371: IF FND_API.to_Boolean( p_init_msg_list ) THEN

367: THEN
368: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
369: END IF;
370: -- Initialize message list if p_init_msg_list is set to TRUE.
371: IF FND_API.to_Boolean( p_init_msg_list ) THEN
372: FND_MSG_PUB.initialize;
373: END IF;
374:
375: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 375: x_return_status := FND_API.G_RET_STS_SUCCESS ;

371: IF FND_API.to_Boolean( p_init_msg_list ) THEN
372: FND_MSG_PUB.initialize;
373: END IF;
374:
375: x_return_status := FND_API.G_RET_STS_SUCCESS ;
376: x_msg_data := 'LOCATE_BY_MINOR_LOAD: server_group '
377: || p_server_group_name || ' not found';
378: x_msg_count := 1;
379: x_server_id := null;

Line 398: IF FND_API.To_Boolean( p_commit ) THEN

394:
395: x_msg_count :=0;
396: x_msg_data := null;
397:
398: IF FND_API.To_Boolean( p_commit ) THEN
399: COMMIT WORK;
400: END IF;
401: EXCEPTION
402: -- WHEN AGENT_NOT_FOUND THEN

Line 413: WHEN FND_API.G_EXC_ERROR THEN

409: || ' ErrorCode = ' || x_err_num
410: || ' ErrorMsg = ' || x_err_msg;
411: --dbms_output.put_line(x_msg_data);
412:
413: WHEN FND_API.G_EXC_ERROR THEN
414: rollback;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: x_msg_count := 1;
417: x_err_num := SQLCODE;

Line 415: x_return_status := FND_API.G_RET_STS_ERROR ;

411: --dbms_output.put_line(x_msg_data);
412:
413: WHEN FND_API.G_EXC_ERROR THEN
414: rollback;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: x_msg_count := 1;
417: x_err_num := SQLCODE;
418: x_err_msg := SUBSTR(SQLERRM, 1, 100);
419: x_msg_data :='LOCATE_BY_MINOR_LOAD: IEO_EXC_ERROR'

Line 423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

419: x_msg_data :='LOCATE_BY_MINOR_LOAD: IEO_EXC_ERROR'
420: || ' ErrorCode = ' || x_err_num
421: || ' ErrorMsg = ' || x_err_msg;
422: --dbms_output.put_line(x_msg_data);
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: rollback;
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426: x_msg_count := 1;
427: x_err_num := SQLCODE;

Line 425: x_return_status := FND_API.G_RET_STS_ERROR ;

421: || ' ErrorMsg = ' || x_err_msg;
422: --dbms_output.put_line(x_msg_data);
423: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
424: rollback;
425: x_return_status := FND_API.G_RET_STS_ERROR ;
426: x_msg_count := 1;
427: x_err_num := SQLCODE;
428: x_err_msg := SUBSTR(SQLERRM, 1, 100);
429: x_msg_data :='LOCATE_BY_MINOR_LOAD: IEO_UNEXPECTED_ERROR'

Line 435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

431: || ' ErrorMsg = ' || x_err_msg;
432: --dbms_output.put_line(x_msg_data);
433: WHEN OTHERS THEN
434: rollback;
435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
436: x_msg_count := 1;
437: x_err_num := SQLCODE;
438: x_err_msg := SUBSTR(SQLERRM, 1, 100);
439: x_msg_data :='LOCATE_BY_MINOR_LOAD: IEO_OTHERS_ERROR'

Line 467: IF NOT FND_API.Compatible_API_Call (l_api_version ,

463: x_err_num NUMBER;
464: x_err_msg VARCHAR2(256);
465:
466: BEGIN
467: IF NOT FND_API.Compatible_API_Call (l_api_version ,
468: p_api_version ,
469: l_api_name ,
470: G_PKG_NAME )
471: THEN

Line 472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

468: p_api_version ,
469: l_api_name ,
470: G_PKG_NAME )
471: THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;

Line 475: IF FND_API.to_Boolean( p_init_msg_list ) THEN

471: THEN
472: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
473: END IF;
474: -- Initialize message list if p_init_msg_list is set to TRUE.
475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 479: x_return_status := FND_API.G_RET_STS_SUCCESS ;

475: IF FND_API.to_Boolean( p_init_msg_list ) THEN
476: FND_MSG_PUB.initialize;
477: END IF;
478:
479: x_return_status := FND_API.G_RET_STS_SUCCESS ;
480: x_msg_data := 'LOCATE_BY_MAJOR_LOAD: server_group '
481: || p_server_group_name || ' not found';
482: x_msg_count := 1;
483: x_server_id := null;

Line 502: IF FND_API.To_Boolean( p_commit ) THEN

498:
499: x_msg_count :=0;
500: x_msg_data := null;
501:
502: IF FND_API.To_Boolean( p_commit ) THEN
503: COMMIT WORK;
504: END IF;
505: EXCEPTION
506: -- WHEN AGENT_NOT_FOUND THEN

Line 517: WHEN FND_API.G_EXC_ERROR THEN

513: || ' ErrorCode = ' || x_err_num
514: || ' ErrorMsg = ' || x_err_msg;
515: --dbms_output.put_line(x_msg_data);
516:
517: WHEN FND_API.G_EXC_ERROR THEN
518: rollback;
519: x_return_status := FND_API.G_RET_STS_ERROR ;
520: x_msg_count := 1;
521: x_err_num := SQLCODE;

Line 519: x_return_status := FND_API.G_RET_STS_ERROR ;

515: --dbms_output.put_line(x_msg_data);
516:
517: WHEN FND_API.G_EXC_ERROR THEN
518: rollback;
519: x_return_status := FND_API.G_RET_STS_ERROR ;
520: x_msg_count := 1;
521: x_err_num := SQLCODE;
522: x_err_msg := SUBSTR(SQLERRM, 1, 100);
523: x_msg_data :='LOCATE_BY_MAJOR_LOAD: IEO_EXC_ERROR'

Line 527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

523: x_msg_data :='LOCATE_BY_MAJOR_LOAD: IEO_EXC_ERROR'
524: || ' ErrorCode = ' || x_err_num
525: || ' ErrorMsg = ' || x_err_msg;
526: --dbms_output.put_line(x_msg_data);
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: rollback;
529: x_return_status := FND_API.G_RET_STS_ERROR ;
530: x_msg_count := 1;
531: x_err_num := SQLCODE;

Line 529: x_return_status := FND_API.G_RET_STS_ERROR ;

525: || ' ErrorMsg = ' || x_err_msg;
526: --dbms_output.put_line(x_msg_data);
527: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
528: rollback;
529: x_return_status := FND_API.G_RET_STS_ERROR ;
530: x_msg_count := 1;
531: x_err_num := SQLCODE;
532: x_err_msg := SUBSTR(SQLERRM, 1, 100);
533: x_msg_data :='LOCATE_BY_MAJOR_LOAD: IEO_UNEXPECTED_ERROR'

Line 539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

535: || ' ErrorMsg = ' || x_err_msg;
536: --dbms_output.put_line(x_msg_data);
537: WHEN OTHERS THEN
538: rollback;
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
540: x_msg_count := 1;
541: x_err_num := SQLCODE;
542: x_err_msg := SUBSTR(SQLERRM, 1, 100);
543: x_msg_data :='LOCATE_BY_MAJOR_LOAD: IEO_OTHERS_ERROR'