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.JTF_PHYSICALMAP_GRP dependencies on FND_API

Line 35: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

31: -- 6. Raise an exception for any other errors
32: ---------------------------------------------------------------------
33: PROCEDURE save_physicalmap (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
36: p_commit IN VARCHAR2 := FND_API.g_false,
37: x_return_status OUT VARCHAR2,
38: x_msg_count OUT NUMBER,
39: x_msg_data OUT VARCHAR2,

Line 36: p_commit IN VARCHAR2 := FND_API.g_false,

32: ---------------------------------------------------------------------
33: PROCEDURE save_physicalmap (
34: p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
36: p_commit IN VARCHAR2 := FND_API.g_false,
37: x_return_status OUT VARCHAR2,
38: x_msg_count OUT NUMBER,
39: x_msg_data OUT VARCHAR2,
40: p_attachment_id IN NUMBER,

Line 67: IF NOT FND_API.compatible_api_call(

63: -- Standard start of API savepoint
64: SAVEPOINT save_physicalmap_grp;
65:
66: -- Standard call to check for call compatibility
67: IF NOT FND_API.compatible_api_call(
68: g_api_version,
69: p_api_version,
70: l_api_name,
71: g_pkg_name

Line 73: RAISE FND_API.g_exc_unexpected_error;

69: p_api_version,
70: l_api_name,
71: g_pkg_name
72: ) THEN
73: RAISE FND_API.g_exc_unexpected_error;
74: END IF;
75:
76: -- Initialize message list if p_init_msg_list is set to TRUE
77: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 77: IF FND_API.to_boolean(p_init_msg_list) THEN

73: RAISE FND_API.g_exc_unexpected_error;
74: END IF;
75:
76: -- Initialize message list if p_init_msg_list is set to TRUE
77: IF FND_API.to_boolean(p_init_msg_list) THEN
78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API rturn status to success

Line 82: x_return_status := FND_API.g_ret_sts_success;

78: FND_MSG_PUB.initialize;
79: END IF;
80:
81: -- Initialize API rturn status to success
82: x_return_status := FND_API.g_ret_sts_success;
83:
84: -- API body
85:
86: -- Check if the attachment id exists

Line 90: RAISE FND_API.g_exc_error;

86: -- Check if the attachment id exists
87: l_deliverable_id := JTF_DSPMGRVALIDATION_GRP.check_attachment_deliverable(
88: p_attachment_id);
89: IF l_deliverable_id IS NULL THEN
90: RAISE FND_API.g_exc_error;
91: END IF;
92:
93: -- Check if the mini-site id exists
94: l_msite_id := p_msite_id;

Line 97: RAISE FND_API.g_exc_error;

93: -- Check if the mini-site id exists
94: l_msite_id := p_msite_id;
95: IF p_msite_id IS NOT NULL THEN
96: IF NOT JTF_DSPMGRVALIDATION_GRP.check_msite_exists(p_msite_id) THEN
97: RAISE FND_API.g_exc_error;
98: END IF;
99:
100: -- Delete all the existing mappings
101: DELETE FROM JTF_DSP_LGL_PHYS_MAP

Line 111: RAISE FND_API.g_exc_error;

107: l_default_msite := g_yes;
108:
109: l_msite_id := JTF_DSPMGRVALIDATION_GRP.check_master_msite_exists;
110: IF l_msite_id IS NULL THEN
111: RAISE FND_API.g_exc_error;
112: END IF;
113:
114: -- Delete all the existing mappings
115: DELETE FROM JTF_DSP_LGL_PHYS_MAP

Line 173: RAISE FND_API.g_exc_error;

169: IF (l_msite_type = 'SITE') THEN
170: IF NOT JTF_DSPMGRVALIDATION_GRP.check_language_supported(
171: p_msite_id,
172: p_language_code_tbl(l_index)) THEN
173: RAISE FND_API.g_exc_error;
174: END IF;
175: END IF;
176:
177: OPEN lgl_phys_map_id_seq;

Line 213: WHEN FND_API.g_exc_error THEN

209: );
210:
211: EXCEPTION
212:
213: WHEN FND_API.g_exc_error THEN
214: ROLLBACK TO save_one_physicalmap_grp;
215: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
216: x_return_status := FND_API.g_ret_sts_error;
217: END IF;

Line 215: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

211: EXCEPTION
212:
213: WHEN FND_API.g_exc_error THEN
214: ROLLBACK TO save_one_physicalmap_grp;
215: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
216: x_return_status := FND_API.g_ret_sts_error;
217: END IF;
218:
219: WHEN dup_val_on_index THEN

Line 216: x_return_status := FND_API.g_ret_sts_error;

212:
213: WHEN FND_API.g_exc_error THEN
214: ROLLBACK TO save_one_physicalmap_grp;
215: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
216: x_return_status := FND_API.g_ret_sts_error;
217: END IF;
218:
219: WHEN dup_val_on_index THEN
220: ROLLBACK TO save_one_physicalmap_grp;

Line 221: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

217: END IF;
218:
219: WHEN dup_val_on_index THEN
220: ROLLBACK TO save_one_physicalmap_grp;
221: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 222: x_return_status := FND_API.g_ret_sts_error;

218:
219: WHEN dup_val_on_index THEN
220: ROLLBACK TO save_one_physicalmap_grp;
221: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
222: x_return_status := FND_API.g_ret_sts_error;
223: END IF;
224: IF FND_MSG_PUB.check_msg_level(
225: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
226: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 254: x_return_status := FND_API.g_ret_sts_unexp_error ;

250: END IF;
251:
252: WHEN OTHERS THEN
253: ROLLBACK TO save_one_physicalmap_grp;
254: x_return_status := FND_API.g_ret_sts_unexp_error ;
255:
256: IF FND_MSG_PUB.check_msg_level(
257: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
258: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 269: IF FND_API.to_boolean(p_commit) THEN

265: END IF;
266:
267: -- Check if the caller requested to commit ,
268: -- If p_commit set to true, commit the transaction
269: IF FND_API.to_boolean(p_commit) THEN
270: COMMIT;
271: END IF;
272:
273: -- Standard call to get message count and if count is 1, get message info

Line 275: p_encoded => FND_API.g_false,

271: END IF;
272:
273: -- Standard call to get message count and if count is 1, get message info
274: FND_MSG_PUB.count_and_get(
275: p_encoded => FND_API.g_false,
276: p_count => x_msg_count,
277: p_data => x_msg_data
278: );
279:

Line 283: WHEN FND_API.g_exc_error THEN

279:
280:
281: EXCEPTION
282:
283: WHEN FND_API.g_exc_error THEN
284: ROLLBACK TO save_physicalmap_grp;
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(
287: p_encoded => FND_API.g_false,

Line 285: x_return_status := FND_API.g_ret_sts_error;

281: EXCEPTION
282:
283: WHEN FND_API.g_exc_error THEN
284: ROLLBACK TO save_physicalmap_grp;
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(
287: p_encoded => FND_API.g_false,
288: p_count => x_msg_count,
289: p_data => x_msg_data

Line 287: p_encoded => FND_API.g_false,

283: WHEN FND_API.g_exc_error THEN
284: ROLLBACK TO save_physicalmap_grp;
285: x_return_status := FND_API.g_ret_sts_error;
286: FND_MSG_PUB.count_and_get(
287: p_encoded => FND_API.g_false,
288: p_count => x_msg_count,
289: p_data => x_msg_data
290: );
291:

Line 292: WHEN FND_API.g_exc_unexpected_error THEN

288: p_count => x_msg_count,
289: p_data => x_msg_data
290: );
291:
292: WHEN FND_API.g_exc_unexpected_error THEN
293: ROLLBACK TO save_physicalmap_grp;
294: x_return_status := FND_API.g_ret_sts_unexp_error;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,

Line 294: x_return_status := FND_API.g_ret_sts_unexp_error;

290: );
291:
292: WHEN FND_API.g_exc_unexpected_error THEN
293: ROLLBACK TO save_physicalmap_grp;
294: x_return_status := FND_API.g_ret_sts_unexp_error;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data

Line 296: p_encoded => FND_API.g_false,

292: WHEN FND_API.g_exc_unexpected_error THEN
293: ROLLBACK TO save_physicalmap_grp;
294: x_return_status := FND_API.g_ret_sts_unexp_error;
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );
300:

Line 303: x_return_status := FND_API.g_ret_sts_error;

299: );
300:
301: WHEN dup_val_on_index THEN
302: ROLLBACK TO save_physicalmap_grp;
303: x_return_status := FND_API.g_ret_sts_error;
304: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
305: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
306:
307: IF l_default_msite = g_no THEN

Line 318: p_encoded => FND_API.g_false,

314: FND_MSG_PUB.add;
315: END IF;
316:
317: FND_MSG_PUB.count_and_get(
318: p_encoded => FND_API.g_false,
319: p_count => x_msg_count,
320: p_data => x_msg_data
321: );
322:

Line 325: x_return_status := FND_API.g_ret_sts_unexp_error ;

321: );
322:
323: WHEN OTHERS THEN
324: ROLLBACK TO save_physicalmap_grp;
325: x_return_status := FND_API.g_ret_sts_unexp_error ;
326:
327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;

Line 332: p_encoded => FND_API.g_false,

328: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
329: END IF;
330:
331: FND_MSG_PUB.count_and_get(
332: p_encoded => FND_API.g_false,
333: p_count => x_msg_count,
334: p_data => x_msg_data
335: );
336:

Line 372: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

368: -- 6. Raise an exception for any other errors
369: ---------------------------------------------------------------------
370: PROCEDURE save_physicalmap (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
373: p_commit IN VARCHAR2 := FND_API.g_false,
374: x_return_status OUT VARCHAR2,
375: x_msg_count OUT NUMBER,
376: x_msg_data OUT VARCHAR2,

Line 373: p_commit IN VARCHAR2 := FND_API.g_false,

369: ---------------------------------------------------------------------
370: PROCEDURE save_physicalmap (
371: p_api_version IN NUMBER,
372: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
373: p_commit IN VARCHAR2 := FND_API.g_false,
374: x_return_status OUT VARCHAR2,
375: x_msg_count OUT NUMBER,
376: x_msg_data OUT VARCHAR2,
377: p_attachment_id IN NUMBER,

Line 387: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;

383:
384: l_deliverable_id NUMBER;
385:
386: l_language_code_tbl LANGUAGE_CODE_TBL_TYPE;
387: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
388:
389: l_index NUMBER;
390: l_index1 NUMBER;
391: l_count NUMBER := 0;

Line 401: IF NOT FND_API.compatible_api_call(

397: -- Standard start of API savepoint
398: SAVEPOINT save_physicalmap_grp;
399:
400: -- Standard call to check for call compatibility
401: IF NOT FND_API.compatible_api_call(
402: g_api_version,
403: p_api_version,
404: l_api_name,
405: g_pkg_name

Line 407: RAISE FND_API.g_exc_unexpected_error;

403: p_api_version,
404: l_api_name,
405: g_pkg_name
406: ) THEN
407: RAISE FND_API.g_exc_unexpected_error;
408: END IF;
409:
410: -- Initialize message list if p_init_msg_list is set to TRUE
411: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 411: IF FND_API.to_boolean(p_init_msg_list) THEN

407: RAISE FND_API.g_exc_unexpected_error;
408: END IF;
409:
410: -- Initialize message list if p_init_msg_list is set to TRUE
411: IF FND_API.to_boolean(p_init_msg_list) THEN
412: FND_MSG_PUB.initialize;
413: END IF;
414:
415: -- Initialize API rturn status to success

Line 416: x_return_status := FND_API.g_ret_sts_success;

412: FND_MSG_PUB.initialize;
413: END IF;
414:
415: -- Initialize API rturn status to success
416: x_return_status := FND_API.g_ret_sts_success;
417:
418: -- API body
419:
420: -- Check if the input parameters are valid

Line 426: RAISE FND_API.g_exc_unexpected_error;

422: l_count := 0;
423: FOR l_index1 IN 1..p_msite_lang_tbl.COUNT LOOP
424: IF p_msite_lang_tbl(l_index1).lang_count IS NULL
425: OR p_msite_lang_tbl(l_index1).lang_count < 0 THEN
426: RAISE FND_API.g_exc_unexpected_error;
427: END IF;
428:
429: l_count := l_count + p_msite_lang_tbl(l_index1).lang_count;
430: END LOOP;

Line 435: RAISE FND_API.g_exc_unexpected_error;

431:
432: IF l_count > 0 THEN
433: IF p_language_code_tbl IS NULL OR
434: l_count <> p_language_code_tbl.COUNT THEN
435: RAISE FND_API.g_exc_unexpected_error;
436: END IF;
437: END IF;
438:
439: ELSE

Line 448: RAISE FND_API.g_exc_error;

444: -- Check if the attachment id exists
445: l_deliverable_id := JTF_DSPMGRVALIDATION_GRP.check_attachment_deliverable(
446: p_attachment_id);
447: IF l_deliverable_id IS NULL THEN
448: RAISE FND_API.g_exc_error;
449: END IF;
450:
451: l_count := 0;
452: FOR l_index1 IN 1..p_msite_lang_tbl.COUNT LOOP

Line 454: l_return_status := FND_API.g_ret_sts_success;

450:
451: l_count := 0;
452: FOR l_index1 IN 1..p_msite_lang_tbl.COUNT LOOP
453:
454: l_return_status := FND_API.g_ret_sts_success;
455: l_language_code_tbl := NULL;
456:
457: IF p_msite_lang_tbl(l_index1).lang_count > 0 THEN
458: /*

Line 495: IF l_return_status <> FND_API.g_ret_sts_success THEN

491: p_msite_id => p_msite_lang_tbl(l_index1).msite_id,
492: p_language_code_tbl => l_language_code_tbl
493: );
494:
495: IF l_return_status <> FND_API.g_ret_sts_success THEN
496: x_return_status := l_return_status;
497: END IF;
498:
499: /*

Line 523: IF FND_API.to_boolean(p_commit) THEN

519: */
520:
521: -- Check if the caller requested to commit ,
522: -- If p_commit set to true, commit the transaction
523: IF FND_API.to_boolean(p_commit) THEN
524: COMMIT;
525: END IF;
526:
527: -- Standard call to get message count and if count is 1, get message info

Line 529: p_encoded => FND_API.g_false,

525: END IF;
526:
527: -- Standard call to get message count and if count is 1, get message info
528: FND_MSG_PUB.count_and_get(
529: p_encoded => FND_API.g_false,
530: p_count => x_msg_count,
531: p_data => x_msg_data
532: );
533:

Line 536: WHEN FND_API.g_exc_error THEN

532: );
533:
534: EXCEPTION
535:
536: WHEN FND_API.g_exc_error THEN
537: ROLLBACK TO save_physicalmap_grp;
538: x_return_status := FND_API.g_ret_sts_error;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false,

Line 538: x_return_status := FND_API.g_ret_sts_error;

534: EXCEPTION
535:
536: WHEN FND_API.g_exc_error THEN
537: ROLLBACK TO save_physicalmap_grp;
538: x_return_status := FND_API.g_ret_sts_error;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false,
541: p_count => x_msg_count,
542: p_data => x_msg_data

Line 540: p_encoded => FND_API.g_false,

536: WHEN FND_API.g_exc_error THEN
537: ROLLBACK TO save_physicalmap_grp;
538: x_return_status := FND_API.g_ret_sts_error;
539: FND_MSG_PUB.count_and_get(
540: p_encoded => FND_API.g_false,
541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:

Line 545: WHEN FND_API.g_exc_unexpected_error THEN

541: p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:
545: WHEN FND_API.g_exc_unexpected_error THEN
546: ROLLBACK TO save_physicalmap_grp;
547: x_return_status := FND_API.g_ret_sts_unexp_error;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false,

Line 547: x_return_status := FND_API.g_ret_sts_unexp_error;

543: );
544:
545: WHEN FND_API.g_exc_unexpected_error THEN
546: ROLLBACK TO save_physicalmap_grp;
547: x_return_status := FND_API.g_ret_sts_unexp_error;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false,
550: p_count => x_msg_count,
551: p_data => x_msg_data

Line 549: p_encoded => FND_API.g_false,

545: WHEN FND_API.g_exc_unexpected_error THEN
546: ROLLBACK TO save_physicalmap_grp;
547: x_return_status := FND_API.g_ret_sts_unexp_error;
548: FND_MSG_PUB.count_and_get(
549: p_encoded => FND_API.g_false,
550: p_count => x_msg_count,
551: p_data => x_msg_data
552: );
553:

Line 556: x_return_status := FND_API.g_ret_sts_unexp_error ;

552: );
553:
554: WHEN OTHERS THEN
555: ROLLBACK TO save_physicalmap_grp;
556: x_return_status := FND_API.g_ret_sts_unexp_error ;
557:
558: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;

Line 563: p_encoded => FND_API.g_false,

559: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
560: END IF;
561:
562: FND_MSG_PUB.count_and_get(
563: p_encoded => FND_API.g_false,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );
567:

Line 590: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

586: -- 3. Raise an exception for any other errors
587: --------------------------------------------------------------------
588: PROCEDURE delete_physicalmap(
589: p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
591: p_commit IN VARCHAR2 := FND_API.g_false,
592: x_return_status OUT VARCHAR2,
593: x_msg_count OUT NUMBER,
594: x_msg_data OUT VARCHAR2,

Line 591: p_commit IN VARCHAR2 := FND_API.g_false,

587: --------------------------------------------------------------------
588: PROCEDURE delete_physicalmap(
589: p_api_version IN NUMBER,
590: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
591: p_commit IN VARCHAR2 := FND_API.g_false,
592: x_return_status OUT VARCHAR2,
593: x_msg_count OUT NUMBER,
594: x_msg_data OUT VARCHAR2,
595: p_lgl_phys_map_id_tbl IN LGL_PHYS_MAP_ID_TBL_TYPE) IS

Line 608: IF NOT FND_API.compatible_api_call(

604: -- Standard start of API savepoint
605: SAVEPOINT delete_physicalmap_grp;
606:
607: -- Standard call to check for call compatibility
608: IF NOT FND_API.compatible_api_call(
609: g_api_version,
610: p_api_version,
611: l_api_name,
612: g_pkg_name

Line 614: RAISE FND_API.g_exc_unexpected_error;

610: p_api_version,
611: l_api_name,
612: g_pkg_name
613: ) THEN
614: RAISE FND_API.g_exc_unexpected_error;
615: END IF;
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE
618: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 618: IF FND_API.to_boolean(p_init_msg_list) THEN

614: RAISE FND_API.g_exc_unexpected_error;
615: END IF;
616:
617: -- Initialize message list if p_init_msg_list is set to TRUE
618: IF FND_API.to_boolean(p_init_msg_list) THEN
619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: -- Initialize API rturn status to success

Line 623: x_return_status := FND_API.g_ret_sts_success;

619: FND_MSG_PUB.initialize;
620: END IF;
621:
622: -- Initialize API rturn status to success
623: x_return_status := FND_API.g_ret_sts_success;
624:
625: -- API body
626:
627: IF p_lgl_phys_map_id_tbl IS NOT NULL THEN

Line 634: RAISE FND_API.g_exc_error;

630:
631: -- Check if the physicalMap id exists
632: IF NOT JTF_DSPMGRVALIDATION_GRP.check_physicalmap_exists(
633: p_lgl_phys_map_id_tbl(l_index)) THEN
634: RAISE FND_API.g_exc_error;
635: END IF;
636:
637: DELETE FROM JTF_DSP_LGL_PHYS_MAP
638: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);

Line 648: RAISE FND_API.g_exc_error;

644: 'ID',
645: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
646: FND_MSG_PUB.add;
647: END IF;
648: RAISE FND_API.g_exc_error;
649: END IF;
650:
651: EXCEPTION
652:

Line 653: WHEN FND_API.g_exc_error THEN

649: END IF;
650:
651: EXCEPTION
652:
653: WHEN FND_API.g_exc_error THEN
654: /*
655: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;
657: ENF IF;

Line 655: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

651: EXCEPTION
652:
653: WHEN FND_API.g_exc_error THEN
654: /*
655: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;
657: ENF IF;
658: */
659: -- only warning; no error status

Line 656: x_return_status := FND_API.g_ret_sts_error;

652:
653: WHEN FND_API.g_exc_error THEN
654: /*
655: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
656: x_return_status := FND_API.g_ret_sts_error;
657: ENF IF;
658: */
659: -- only warning; no error status
660: NULL;

Line 675: x_return_status := FND_API.g_ret_sts_unexp_error ;

671: END IF;
672: */
673:
674: WHEN OTHERS THEN
675: x_return_status := FND_API.g_ret_sts_unexp_error ;
676: IF FND_MSG_PUB.check_msg_level(
677: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
678: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
679: END IF;

Line 687: IF FND_API.to_boolean(p_commit) THEN

683: END IF;
684:
685: -- Check if the caller requested to commit ,
686: -- If p_commit set to true, commit the transaction
687: IF FND_API.to_boolean(p_commit) THEN
688: COMMIT;
689: END IF;
690:
691: -- Standard call to get message count and if count is 1, get message info

Line 693: p_encoded => FND_API.g_false,

689: END IF;
690:
691: -- Standard call to get message count and if count is 1, get message info
692: FND_MSG_PUB.count_and_get(
693: p_encoded => FND_API.g_false,
694: p_count => x_msg_count,
695: p_data => x_msg_data
696: );
697:

Line 700: WHEN FND_API.g_exc_error THEN

696: );
697:
698: EXCEPTION
699:
700: WHEN FND_API.g_exc_error THEN
701: ROLLBACK TO delete_physicalmap_grp;
702: x_return_status := FND_API.g_ret_sts_error;
703: FND_MSG_PUB.count_and_get(
704: p_encoded => FND_API.g_false,

Line 702: x_return_status := FND_API.g_ret_sts_error;

698: EXCEPTION
699:
700: WHEN FND_API.g_exc_error THEN
701: ROLLBACK TO delete_physicalmap_grp;
702: x_return_status := FND_API.g_ret_sts_error;
703: FND_MSG_PUB.count_and_get(
704: p_encoded => FND_API.g_false,
705: p_count => x_msg_count,
706: p_data => x_msg_data

Line 704: p_encoded => FND_API.g_false,

700: WHEN FND_API.g_exc_error THEN
701: ROLLBACK TO delete_physicalmap_grp;
702: x_return_status := FND_API.g_ret_sts_error;
703: FND_MSG_PUB.count_and_get(
704: p_encoded => FND_API.g_false,
705: p_count => x_msg_count,
706: p_data => x_msg_data
707: );
708:

Line 709: WHEN FND_API.g_exc_unexpected_error THEN

705: p_count => x_msg_count,
706: p_data => x_msg_data
707: );
708:
709: WHEN FND_API.g_exc_unexpected_error THEN
710: ROLLBACK TO delete_physicalmap_grp;
711: x_return_status := FND_API.g_ret_sts_unexp_error ;
712: FND_MSG_PUB.count_and_get(
713: p_encoded => FND_API.g_false,

Line 711: x_return_status := FND_API.g_ret_sts_unexp_error ;

707: );
708:
709: WHEN FND_API.g_exc_unexpected_error THEN
710: ROLLBACK TO delete_physicalmap_grp;
711: x_return_status := FND_API.g_ret_sts_unexp_error ;
712: FND_MSG_PUB.count_and_get(
713: p_encoded => FND_API.g_false,
714: p_count => x_msg_count,
715: p_data => x_msg_data

Line 713: p_encoded => FND_API.g_false,

709: WHEN FND_API.g_exc_unexpected_error THEN
710: ROLLBACK TO delete_physicalmap_grp;
711: x_return_status := FND_API.g_ret_sts_unexp_error ;
712: FND_MSG_PUB.count_and_get(
713: p_encoded => FND_API.g_false,
714: p_count => x_msg_count,
715: p_data => x_msg_data
716: );
717:

Line 720: x_return_status := FND_API.g_ret_sts_unexp_error ;

716: );
717:
718: WHEN OTHERS THEN
719: ROLLBACK TO delete_physicalmap_grp;
720: x_return_status := FND_API.g_ret_sts_unexp_error ;
721:
722: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;

Line 727: p_encoded => FND_API.g_false,

723: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
724: END IF;
725:
726: FND_MSG_PUB.count_and_get(
727: p_encoded => FND_API.g_false,
728: p_count => x_msg_count,
729: p_data => x_msg_data
730: );
731:

Line 921: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

917: -- 1. Delete all the mappings associated with the mini-sites and attachment
918: -- 2. Raise an exception for any other errors
919: PROCEDURE delete_attachment_msite(
920: p_api_version IN NUMBER,
921: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
922: p_commit IN VARCHAR2 := FND_API.g_false,
923: x_return_status OUT VARCHAR2,
924: x_msg_count OUT NUMBER,
925: x_msg_data OUT VARCHAR2,

Line 922: p_commit IN VARCHAR2 := FND_API.g_false,

918: -- 2. Raise an exception for any other errors
919: PROCEDURE delete_attachment_msite(
920: p_api_version IN NUMBER,
921: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
922: p_commit IN VARCHAR2 := FND_API.g_false,
923: x_return_status OUT VARCHAR2,
924: x_msg_count OUT NUMBER,
925: x_msg_data OUT VARCHAR2,
926: p_attachment_id IN NUMBER,

Line 938: IF NOT FND_API.compatible_api_call(

934: -- Standard start of API savepoint
935: SAVEPOINT delete_attachment_msite_grp;
936:
937: -- Standard call to check for call compatibility
938: IF NOT FND_API.compatible_api_call(
939: g_api_version,
940: p_api_version,
941: l_api_name,
942: g_pkg_name

Line 944: RAISE FND_API.g_exc_unexpected_error;

940: p_api_version,
941: l_api_name,
942: g_pkg_name
943: ) THEN
944: RAISE FND_API.g_exc_unexpected_error;
945: END IF;
946:
947: -- Initialize message list if p_init_msg_list is set to TRUE
948: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 948: IF FND_API.to_boolean(p_init_msg_list) THEN

944: RAISE FND_API.g_exc_unexpected_error;
945: END IF;
946:
947: -- Initialize message list if p_init_msg_list is set to TRUE
948: IF FND_API.to_boolean(p_init_msg_list) THEN
949: FND_MSG_PUB.initialize;
950: END IF;
951:
952: -- Initialize API rturn status to success

Line 953: x_return_status := FND_API.g_ret_sts_success;

949: FND_MSG_PUB.initialize;
950: END IF;
951:
952: -- Initialize API rturn status to success
953: x_return_status := FND_API.g_ret_sts_success;
954:
955: -- API body
956:
957: IF p_msite_id_tbl IS NOT NULL THEN

Line 979: x_return_status := FND_API.g_ret_sts_unexp_error ;

975: EXCEPTION
976:
977: WHEN OTHERS THEN
978: ROLLBACK TO delete_one_ath_msite_grp;
979: x_return_status := FND_API.g_ret_sts_unexp_error ;
980: IF FND_MSG_PUB.check_msg_level(
981: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
982: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
983: END IF;

Line 991: IF FND_API.to_boolean(p_commit) THEN

987: END IF;
988:
989: -- Check if the caller requested to commit ,
990: -- If p_commit set to true, commit the transaction
991: IF FND_API.to_boolean(p_commit) THEN
992: COMMIT;
993: END IF;
994:
995: -- Standard call to get message count and if count is 1, get message info

Line 997: p_encoded => FND_API.g_false,

993: END IF;
994:
995: -- Standard call to get message count and if count is 1, get message info
996: FND_MSG_PUB.count_and_get(
997: p_encoded => FND_API.g_false,
998: p_count => x_msg_count,
999: p_data => x_msg_data
1000: );
1001:

Line 1004: WHEN FND_API.g_exc_error THEN

1000: );
1001:
1002: EXCEPTION
1003:
1004: WHEN FND_API.g_exc_error THEN
1005: ROLLBACK TO delete_attachment_msite_grp;
1006: x_return_status := FND_API.g_ret_sts_error;
1007: FND_MSG_PUB.count_and_get(
1008: p_encoded => FND_API.g_false,

Line 1006: x_return_status := FND_API.g_ret_sts_error;

1002: EXCEPTION
1003:
1004: WHEN FND_API.g_exc_error THEN
1005: ROLLBACK TO delete_attachment_msite_grp;
1006: x_return_status := FND_API.g_ret_sts_error;
1007: FND_MSG_PUB.count_and_get(
1008: p_encoded => FND_API.g_false,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data

Line 1008: p_encoded => FND_API.g_false,

1004: WHEN FND_API.g_exc_error THEN
1005: ROLLBACK TO delete_attachment_msite_grp;
1006: x_return_status := FND_API.g_ret_sts_error;
1007: FND_MSG_PUB.count_and_get(
1008: p_encoded => FND_API.g_false,
1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012:

Line 1013: WHEN FND_API.g_exc_unexpected_error THEN

1009: p_count => x_msg_count,
1010: p_data => x_msg_data
1011: );
1012:
1013: WHEN FND_API.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_attachment_msite_grp;
1015: x_return_status := FND_API.g_ret_sts_unexp_error ;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,

Line 1015: x_return_status := FND_API.g_ret_sts_unexp_error ;

1011: );
1012:
1013: WHEN FND_API.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_attachment_msite_grp;
1015: x_return_status := FND_API.g_ret_sts_unexp_error ;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data

Line 1017: p_encoded => FND_API.g_false,

1013: WHEN FND_API.g_exc_unexpected_error THEN
1014: ROLLBACK TO delete_attachment_msite_grp;
1015: x_return_status := FND_API.g_ret_sts_unexp_error ;
1016: FND_MSG_PUB.count_and_get(
1017: p_encoded => FND_API.g_false,
1018: p_count => x_msg_count,
1019: p_data => x_msg_data
1020: );
1021:

Line 1024: x_return_status := FND_API.g_ret_sts_unexp_error ;

1020: );
1021:
1022: WHEN OTHERS THEN
1023: ROLLBACK TO delete_attachment_msite_grp;
1024: x_return_status := FND_API.g_ret_sts_unexp_error ;
1025:
1026: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;

Line 1031: p_encoded => FND_API.g_false,

1027: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029:
1030: FND_MSG_PUB.count_and_get(
1031: p_encoded => FND_API.g_false,
1032: p_count => x_msg_count,
1033: p_data => x_msg_data
1034: );
1035: