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.IBE_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 NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY 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 NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2,
40: p_attachment_id IN NUMBER,

Line 71: IF NOT FND_API.compatible_api_call(

67: l_default_msite := g_no;
68: l_default_lang := g_no;
69:
70: -- Standard call to check for call compatibility
71: IF NOT FND_API.compatible_api_call(
72: g_api_version,
73: p_api_version,
74: l_api_name,
75: g_pkg_name

Line 77: RAISE FND_API.g_exc_unexpected_error;

73: p_api_version,
74: l_api_name,
75: g_pkg_name
76: ) THEN
77: RAISE FND_API.g_exc_unexpected_error;
78: END IF;
79:
80: -- Initialize message list if p_init_msg_list is set to TRUE
81: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 81: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 86: x_return_status := FND_API.g_ret_sts_success;

82: FND_MSG_PUB.initialize;
83: END IF;
84:
85: -- Initialize API rturn status to success
86: x_return_status := FND_API.g_ret_sts_success;
87:
88: -- API body
89:
90: -- Check if the attachment id exists

Line 94: RAISE FND_API.g_exc_error;

90: -- Check if the attachment id exists
91: l_deliverable_id := IBE_DSPMGRVALIDATION_GRP.check_attachment_deliverable(
92: p_attachment_id);
93: IF l_deliverable_id IS NULL THEN
94: RAISE FND_API.g_exc_error;
95: END IF;
96:
97: -- Check if the mini-site id exists
98: l_msite_id := p_msite_id;

Line 101: RAISE FND_API.g_exc_error;

97: -- Check if the mini-site id exists
98: l_msite_id := p_msite_id;
99: IF p_msite_id IS NOT NULL THEN
100: IF NOT IBE_DSPMGRVALIDATION_GRP.check_msite_exists(p_msite_id) THEN
101: RAISE FND_API.g_exc_error;
102: END IF;
103:
104: -- Delete all the existing mappings
105: DELETE FROM IBE_DSP_LGL_PHYS_MAP

Line 115: RAISE FND_API.g_exc_error;

111: l_default_msite := g_yes;
112:
113: l_msite_id := IBE_DSPMGRVALIDATION_GRP.check_master_msite_exists;
114: IF l_msite_id IS NULL THEN
115: RAISE FND_API.g_exc_error;
116: END IF;
117:
118: -- Added by YAXU, check if the seeded physicalMap exists
119: IF p_language_code_tbl IS NOT NULL THEN

Line 201: RAISE FND_API.g_exc_error;

197: IF (l_msite_type = 'SITE') THEN
198: IF NOT IBE_DSPMGRVALIDATION_GRP.check_language_supported(
199: p_msite_id,
200: p_language_code_tbl(l_index)) THEN
201: RAISE FND_API.g_exc_error;
202: END IF;
203: END IF;
204:
205: OPEN lgl_phys_map_id_seq;

Line 241: WHEN FND_API.g_exc_error THEN

237: );
238:
239: EXCEPTION
240:
241: WHEN FND_API.g_exc_error THEN
242: ROLLBACK TO save_one_physicalmap_grp;
243: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
244: x_return_status := FND_API.g_ret_sts_error;
245: END IF;

Line 243: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

239: EXCEPTION
240:
241: WHEN FND_API.g_exc_error THEN
242: ROLLBACK TO save_one_physicalmap_grp;
243: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
244: x_return_status := FND_API.g_ret_sts_error;
245: END IF;
246:
247: WHEN dup_val_on_index THEN

Line 244: x_return_status := FND_API.g_ret_sts_error;

240:
241: WHEN FND_API.g_exc_error THEN
242: ROLLBACK TO save_one_physicalmap_grp;
243: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
244: x_return_status := FND_API.g_ret_sts_error;
245: END IF;
246:
247: WHEN dup_val_on_index THEN
248: ROLLBACK TO save_one_physicalmap_grp;

Line 249: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

245: END IF;
246:
247: WHEN dup_val_on_index THEN
248: ROLLBACK TO save_one_physicalmap_grp;
249: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
250: x_return_status := FND_API.g_ret_sts_error;
251: END IF;
252: IF FND_MSG_PUB.check_msg_level(
253: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 250: x_return_status := FND_API.g_ret_sts_error;

246:
247: WHEN dup_val_on_index THEN
248: ROLLBACK TO save_one_physicalmap_grp;
249: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
250: x_return_status := FND_API.g_ret_sts_error;
251: END IF;
252: IF FND_MSG_PUB.check_msg_level(
253: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
254: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 282: x_return_status := FND_API.g_ret_sts_unexp_error ;

278: END IF;
279:
280: WHEN OTHERS THEN
281: ROLLBACK TO save_one_physicalmap_grp;
282: x_return_status := FND_API.g_ret_sts_unexp_error ;
283:
284: IF FND_MSG_PUB.check_msg_level(
285: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
286: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 297: IF FND_API.to_boolean(p_commit) THEN

293: END IF;
294:
295: -- Check if the caller requested to commit ,
296: -- If p_commit set to true, commit the transaction
297: IF FND_API.to_boolean(p_commit) THEN
298: COMMIT;
299: END IF;
300:
301: -- Standard call to get message count and if count is 1, get message info

Line 303: p_encoded => FND_API.g_false,

299: END IF;
300:
301: -- Standard call to get message count and if count is 1, get message info
302: FND_MSG_PUB.count_and_get(
303: p_encoded => FND_API.g_false,
304: p_count => x_msg_count,
305: p_data => x_msg_data
306: );
307:

Line 311: WHEN FND_API.g_exc_error THEN

307:
308:
309: EXCEPTION
310:
311: WHEN FND_API.g_exc_error THEN
312: ROLLBACK TO save_physicalmap_grp;
313: x_return_status := FND_API.g_ret_sts_error;
314: FND_MSG_PUB.count_and_get(
315: p_encoded => FND_API.g_false,

Line 313: x_return_status := FND_API.g_ret_sts_error;

309: EXCEPTION
310:
311: WHEN FND_API.g_exc_error THEN
312: ROLLBACK TO save_physicalmap_grp;
313: x_return_status := FND_API.g_ret_sts_error;
314: FND_MSG_PUB.count_and_get(
315: p_encoded => FND_API.g_false,
316: p_count => x_msg_count,
317: p_data => x_msg_data

Line 315: p_encoded => FND_API.g_false,

311: WHEN FND_API.g_exc_error THEN
312: ROLLBACK TO save_physicalmap_grp;
313: x_return_status := FND_API.g_ret_sts_error;
314: FND_MSG_PUB.count_and_get(
315: p_encoded => FND_API.g_false,
316: p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319:

Line 320: WHEN FND_API.g_exc_unexpected_error THEN

316: p_count => x_msg_count,
317: p_data => x_msg_data
318: );
319:
320: WHEN FND_API.g_exc_unexpected_error THEN
321: ROLLBACK TO save_physicalmap_grp;
322: x_return_status := FND_API.g_ret_sts_unexp_error;
323: FND_MSG_PUB.count_and_get(
324: p_encoded => FND_API.g_false,

Line 322: x_return_status := FND_API.g_ret_sts_unexp_error;

318: );
319:
320: WHEN FND_API.g_exc_unexpected_error THEN
321: ROLLBACK TO save_physicalmap_grp;
322: x_return_status := FND_API.g_ret_sts_unexp_error;
323: FND_MSG_PUB.count_and_get(
324: p_encoded => FND_API.g_false,
325: p_count => x_msg_count,
326: p_data => x_msg_data

Line 324: p_encoded => FND_API.g_false,

320: WHEN FND_API.g_exc_unexpected_error THEN
321: ROLLBACK TO save_physicalmap_grp;
322: x_return_status := FND_API.g_ret_sts_unexp_error;
323: FND_MSG_PUB.count_and_get(
324: p_encoded => FND_API.g_false,
325: p_count => x_msg_count,
326: p_data => x_msg_data
327: );
328:

Line 331: x_return_status := FND_API.g_ret_sts_error;

327: );
328:
329: WHEN dup_val_on_index THEN
330: ROLLBACK TO save_physicalmap_grp;
331: x_return_status := FND_API.g_ret_sts_error;
332: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
333: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
334:
335: --added by YAXU on 08/02/2002

Line 358: p_encoded => FND_API.g_false,

354:
355: END IF;
356:
357: FND_MSG_PUB.count_and_get(
358: p_encoded => FND_API.g_false,
359: p_count => x_msg_count,
360: p_data => x_msg_data
361: );
362:

Line 365: x_return_status := FND_API.g_ret_sts_unexp_error ;

361: );
362:
363: WHEN OTHERS THEN
364: ROLLBACK TO save_physicalmap_grp;
365: x_return_status := FND_API.g_ret_sts_unexp_error ;
366:
367: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
368: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
369: END IF;

Line 372: p_encoded => FND_API.g_false,

368: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
369: END IF;
370:
371: FND_MSG_PUB.count_and_get(
372: p_encoded => FND_API.g_false,
373: p_count => x_msg_count,
374: p_data => x_msg_data
375: );
376:

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

408: -- 6. Raise an exception for any other errors
409: ---------------------------------------------------------------------
410: PROCEDURE save_physicalmap (
411: p_api_version IN NUMBER,
412: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
413: p_commit IN VARCHAR2 := FND_API.g_false,
414: x_return_status OUT NOCOPY VARCHAR2,
415: x_msg_count OUT NOCOPY NUMBER,
416: x_msg_data OUT NOCOPY VARCHAR2,

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

409: ---------------------------------------------------------------------
410: PROCEDURE save_physicalmap (
411: p_api_version IN NUMBER,
412: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
413: p_commit IN VARCHAR2 := FND_API.g_false,
414: x_return_status OUT NOCOPY VARCHAR2,
415: x_msg_count OUT NOCOPY NUMBER,
416: x_msg_data OUT NOCOPY VARCHAR2,
417: p_attachment_id IN NUMBER,

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

423:
424: l_deliverable_id NUMBER;
425:
426: l_language_code_tbl LANGUAGE_CODE_TBL_TYPE;
427: l_return_status VARCHAR2(1) := FND_API.g_ret_sts_success;
428:
429: l_index NUMBER;
430: l_index1 NUMBER;
431: l_count NUMBER := 0;

Line 441: IF NOT FND_API.compatible_api_call(

437: -- Standard start of API savepoint
438: SAVEPOINT save_physicalmap_grp;
439:
440: -- Standard call to check for call compatibility
441: IF NOT FND_API.compatible_api_call(
442: g_api_version,
443: p_api_version,
444: l_api_name,
445: g_pkg_name

Line 447: RAISE FND_API.g_exc_unexpected_error;

443: p_api_version,
444: l_api_name,
445: g_pkg_name
446: ) THEN
447: RAISE FND_API.g_exc_unexpected_error;
448: END IF;
449:
450: -- Initialize message list if p_init_msg_list is set to TRUE
451: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 451: IF FND_API.to_boolean(p_init_msg_list) THEN

447: RAISE FND_API.g_exc_unexpected_error;
448: END IF;
449:
450: -- Initialize message list if p_init_msg_list is set to TRUE
451: IF FND_API.to_boolean(p_init_msg_list) THEN
452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: -- Initialize API rturn status to success

Line 456: x_return_status := FND_API.g_ret_sts_success;

452: FND_MSG_PUB.initialize;
453: END IF;
454:
455: -- Initialize API rturn status to success
456: x_return_status := FND_API.g_ret_sts_success;
457:
458: -- API body
459:
460: -- Check if the input parameters are valid

Line 466: RAISE FND_API.g_exc_unexpected_error;

462: l_count := 0;
463: FOR l_index1 IN 1..p_msite_lang_tbl.COUNT LOOP
464: IF p_msite_lang_tbl(l_index1).lang_count IS NULL
465: OR p_msite_lang_tbl(l_index1).lang_count < 0 THEN
466: RAISE FND_API.g_exc_unexpected_error;
467: END IF;
468:
469: l_count := l_count + p_msite_lang_tbl(l_index1).lang_count;
470: END LOOP;

Line 475: RAISE FND_API.g_exc_unexpected_error;

471:
472: IF l_count > 0 THEN
473: IF p_language_code_tbl IS NULL OR
474: l_count <> p_language_code_tbl.COUNT THEN
475: RAISE FND_API.g_exc_unexpected_error;
476: END IF;
477: END IF;
478:
479: ELSE

Line 488: RAISE FND_API.g_exc_error;

484: -- Check if the attachment id exists
485: l_deliverable_id := IBE_DSPMGRVALIDATION_GRP.check_attachment_deliverable(
486: p_attachment_id);
487: IF l_deliverable_id IS NULL THEN
488: RAISE FND_API.g_exc_error;
489: END IF;
490:
491: l_count := 0;
492: FOR l_index1 IN 1..p_msite_lang_tbl.COUNT LOOP

Line 494: l_return_status := FND_API.g_ret_sts_success;

490:
491: l_count := 0;
492: FOR l_index1 IN 1..p_msite_lang_tbl.COUNT LOOP
493:
494: l_return_status := FND_API.g_ret_sts_success;
495: l_language_code_tbl := NULL;
496:
497: IF p_msite_lang_tbl(l_index1).lang_count > 0 THEN
498: /*

Line 535: IF l_return_status <> FND_API.g_ret_sts_success THEN

531: p_msite_id => p_msite_lang_tbl(l_index1).msite_id,
532: p_language_code_tbl => l_language_code_tbl
533: );
534:
535: IF l_return_status <> FND_API.g_ret_sts_success THEN
536: x_return_status := l_return_status;
537: END IF;
538:
539: /*

Line 563: IF FND_API.to_boolean(p_commit) THEN

559: */
560:
561: -- Check if the caller requested to commit ,
562: -- If p_commit set to true, commit the transaction
563: IF FND_API.to_boolean(p_commit) THEN
564: COMMIT;
565: END IF;
566:
567: -- Standard call to get message count and if count is 1, get message info

Line 569: p_encoded => FND_API.g_false,

565: END IF;
566:
567: -- Standard call to get message count and if count is 1, get message info
568: FND_MSG_PUB.count_and_get(
569: p_encoded => FND_API.g_false,
570: p_count => x_msg_count,
571: p_data => x_msg_data
572: );
573:

Line 576: WHEN FND_API.g_exc_error THEN

572: );
573:
574: EXCEPTION
575:
576: WHEN FND_API.g_exc_error THEN
577: ROLLBACK TO save_physicalmap_grp;
578: x_return_status := FND_API.g_ret_sts_error;
579: FND_MSG_PUB.count_and_get(
580: p_encoded => FND_API.g_false,

Line 578: x_return_status := FND_API.g_ret_sts_error;

574: EXCEPTION
575:
576: WHEN FND_API.g_exc_error THEN
577: ROLLBACK TO save_physicalmap_grp;
578: x_return_status := FND_API.g_ret_sts_error;
579: FND_MSG_PUB.count_and_get(
580: p_encoded => FND_API.g_false,
581: p_count => x_msg_count,
582: p_data => x_msg_data

Line 580: p_encoded => FND_API.g_false,

576: WHEN FND_API.g_exc_error THEN
577: ROLLBACK TO save_physicalmap_grp;
578: x_return_status := FND_API.g_ret_sts_error;
579: FND_MSG_PUB.count_and_get(
580: p_encoded => FND_API.g_false,
581: p_count => x_msg_count,
582: p_data => x_msg_data
583: );
584:

Line 585: WHEN FND_API.g_exc_unexpected_error THEN

581: p_count => x_msg_count,
582: p_data => x_msg_data
583: );
584:
585: WHEN FND_API.g_exc_unexpected_error THEN
586: ROLLBACK TO save_physicalmap_grp;
587: x_return_status := FND_API.g_ret_sts_unexp_error;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,

Line 587: x_return_status := FND_API.g_ret_sts_unexp_error;

583: );
584:
585: WHEN FND_API.g_exc_unexpected_error THEN
586: ROLLBACK TO save_physicalmap_grp;
587: x_return_status := FND_API.g_ret_sts_unexp_error;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,
590: p_count => x_msg_count,
591: p_data => x_msg_data

Line 589: p_encoded => FND_API.g_false,

585: WHEN FND_API.g_exc_unexpected_error THEN
586: ROLLBACK TO save_physicalmap_grp;
587: x_return_status := FND_API.g_ret_sts_unexp_error;
588: FND_MSG_PUB.count_and_get(
589: p_encoded => FND_API.g_false,
590: p_count => x_msg_count,
591: p_data => x_msg_data
592: );
593:

Line 596: x_return_status := FND_API.g_ret_sts_unexp_error ;

592: );
593:
594: WHEN OTHERS THEN
595: ROLLBACK TO save_physicalmap_grp;
596: x_return_status := FND_API.g_ret_sts_unexp_error ;
597:
598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
600: END IF;

Line 603: p_encoded => FND_API.g_false,

599: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
600: END IF;
601:
602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data
606: );
607:

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

626: -- 3. Raise an exception for any other errors
627: --------------------------------------------------------------------
628: PROCEDURE delete_physicalmap(
629: p_api_version IN NUMBER,
630: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
631: p_commit IN VARCHAR2 := FND_API.g_false,
632: x_return_status OUT NOCOPY VARCHAR2,
633: x_msg_count OUT NOCOPY NUMBER,
634: x_msg_data OUT NOCOPY VARCHAR2,

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

627: --------------------------------------------------------------------
628: PROCEDURE delete_physicalmap(
629: p_api_version IN NUMBER,
630: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
631: p_commit IN VARCHAR2 := FND_API.g_false,
632: x_return_status OUT NOCOPY VARCHAR2,
633: x_msg_count OUT NOCOPY NUMBER,
634: x_msg_data OUT NOCOPY VARCHAR2,
635: p_lgl_phys_map_id_tbl IN LGL_PHYS_MAP_ID_TBL_TYPE) IS

Line 648: IF NOT FND_API.compatible_api_call(

644: -- Standard start of API savepoint
645: SAVEPOINT delete_physicalmap_grp;
646:
647: -- Standard call to check for call compatibility
648: IF NOT FND_API.compatible_api_call(
649: g_api_version,
650: p_api_version,
651: l_api_name,
652: g_pkg_name

Line 654: RAISE FND_API.g_exc_unexpected_error;

650: p_api_version,
651: l_api_name,
652: g_pkg_name
653: ) THEN
654: RAISE FND_API.g_exc_unexpected_error;
655: END IF;
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE
658: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 658: IF FND_API.to_boolean(p_init_msg_list) THEN

654: RAISE FND_API.g_exc_unexpected_error;
655: END IF;
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE
658: IF FND_API.to_boolean(p_init_msg_list) THEN
659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API rturn status to success

Line 663: x_return_status := FND_API.g_ret_sts_success;

659: FND_MSG_PUB.initialize;
660: END IF;
661:
662: -- Initialize API rturn status to success
663: x_return_status := FND_API.g_ret_sts_success;
664:
665: -- API body
666:
667: IF p_lgl_phys_map_id_tbl IS NOT NULL THEN

Line 674: RAISE FND_API.g_exc_error;

670:
671: -- Check if the physicalMap id exists
672: IF NOT IBE_DSPMGRVALIDATION_GRP.check_physicalmap_exists(
673: p_lgl_phys_map_id_tbl(l_index)) THEN
674: RAISE FND_API.g_exc_error;
675: END IF;
676:
677: DELETE FROM IBE_DSP_LGL_PHYS_MAP
678: WHERE lgl_phys_map_id = p_lgl_phys_map_id_tbl(l_index);

Line 688: RAISE FND_API.g_exc_error;

684: 'ID',
685: TO_CHAR(p_lgl_phys_map_id_tbl(l_index)));
686: FND_MSG_PUB.add;
687: END IF;
688: RAISE FND_API.g_exc_error;
689: END IF;
690:
691: EXCEPTION
692:

Line 693: WHEN FND_API.g_exc_error THEN

689: END IF;
690:
691: EXCEPTION
692:
693: WHEN FND_API.g_exc_error THEN
694: /*
695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
696: x_return_status := FND_API.g_ret_sts_error;
697: ENF IF;

Line 695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

691: EXCEPTION
692:
693: WHEN FND_API.g_exc_error THEN
694: /*
695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
696: x_return_status := FND_API.g_ret_sts_error;
697: ENF IF;
698: */
699: -- only warning; no error status

Line 696: x_return_status := FND_API.g_ret_sts_error;

692:
693: WHEN FND_API.g_exc_error THEN
694: /*
695: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
696: x_return_status := FND_API.g_ret_sts_error;
697: ENF IF;
698: */
699: -- only warning; no error status
700: NULL;

Line 715: x_return_status := FND_API.g_ret_sts_unexp_error ;

711: END IF;
712: */
713:
714: WHEN OTHERS THEN
715: x_return_status := FND_API.g_ret_sts_unexp_error ;
716: IF FND_MSG_PUB.check_msg_level(
717: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
718: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
719: END IF;

Line 727: IF FND_API.to_boolean(p_commit) THEN

723: END IF;
724:
725: -- Check if the caller requested to commit ,
726: -- If p_commit set to true, commit the transaction
727: IF FND_API.to_boolean(p_commit) THEN
728: COMMIT;
729: END IF;
730:
731: -- Standard call to get message count and if count is 1, get message info

Line 733: p_encoded => FND_API.g_false,

729: END IF;
730:
731: -- Standard call to get message count and if count is 1, get message info
732: FND_MSG_PUB.count_and_get(
733: p_encoded => FND_API.g_false,
734: p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737:

Line 740: WHEN FND_API.g_exc_error THEN

736: );
737:
738: EXCEPTION
739:
740: WHEN FND_API.g_exc_error THEN
741: ROLLBACK TO delete_physicalmap_grp;
742: x_return_status := FND_API.g_ret_sts_error;
743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.g_false,

Line 742: x_return_status := FND_API.g_ret_sts_error;

738: EXCEPTION
739:
740: WHEN FND_API.g_exc_error THEN
741: ROLLBACK TO delete_physicalmap_grp;
742: x_return_status := FND_API.g_ret_sts_error;
743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.g_false,
745: p_count => x_msg_count,
746: p_data => x_msg_data

Line 744: p_encoded => FND_API.g_false,

740: WHEN FND_API.g_exc_error THEN
741: ROLLBACK TO delete_physicalmap_grp;
742: x_return_status := FND_API.g_ret_sts_error;
743: FND_MSG_PUB.count_and_get(
744: p_encoded => FND_API.g_false,
745: p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748:

Line 749: WHEN FND_API.g_exc_unexpected_error THEN

745: p_count => x_msg_count,
746: p_data => x_msg_data
747: );
748:
749: WHEN FND_API.g_exc_unexpected_error THEN
750: ROLLBACK TO delete_physicalmap_grp;
751: x_return_status := FND_API.g_ret_sts_unexp_error ;
752: FND_MSG_PUB.count_and_get(
753: p_encoded => FND_API.g_false,

Line 751: x_return_status := FND_API.g_ret_sts_unexp_error ;

747: );
748:
749: WHEN FND_API.g_exc_unexpected_error THEN
750: ROLLBACK TO delete_physicalmap_grp;
751: x_return_status := FND_API.g_ret_sts_unexp_error ;
752: FND_MSG_PUB.count_and_get(
753: p_encoded => FND_API.g_false,
754: p_count => x_msg_count,
755: p_data => x_msg_data

Line 753: p_encoded => FND_API.g_false,

749: WHEN FND_API.g_exc_unexpected_error THEN
750: ROLLBACK TO delete_physicalmap_grp;
751: x_return_status := FND_API.g_ret_sts_unexp_error ;
752: FND_MSG_PUB.count_and_get(
753: p_encoded => FND_API.g_false,
754: p_count => x_msg_count,
755: p_data => x_msg_data
756: );
757:

Line 760: x_return_status := FND_API.g_ret_sts_unexp_error ;

756: );
757:
758: WHEN OTHERS THEN
759: ROLLBACK TO delete_physicalmap_grp;
760: x_return_status := FND_API.g_ret_sts_unexp_error ;
761:
762: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
763: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
764: END IF;

Line 767: p_encoded => FND_API.g_false,

763: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
764: END IF;
765:
766: FND_MSG_PUB.count_and_get(
767: p_encoded => FND_API.g_false,
768: p_count => x_msg_count,
769: p_data => x_msg_data
770: );
771:

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

999: -- 1. Delete all the mappings associated with the mini-sites and attachment
1000: -- 2. Raise an exception for any other errors
1001: PROCEDURE delete_attachment_msite(
1002: p_api_version IN NUMBER,
1003: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1004: p_commit IN VARCHAR2 := FND_API.g_false,
1005: x_return_status OUT NOCOPY VARCHAR2,
1006: x_msg_count OUT NOCOPY NUMBER,
1007: x_msg_data OUT NOCOPY VARCHAR2,

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

1000: -- 2. Raise an exception for any other errors
1001: PROCEDURE delete_attachment_msite(
1002: p_api_version IN NUMBER,
1003: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1004: p_commit IN VARCHAR2 := FND_API.g_false,
1005: x_return_status OUT NOCOPY VARCHAR2,
1006: x_msg_count OUT NOCOPY NUMBER,
1007: x_msg_data OUT NOCOPY VARCHAR2,
1008: p_attachment_id IN NUMBER,

Line 1020: IF NOT FND_API.compatible_api_call(

1016: -- Standard start of API savepoint
1017: SAVEPOINT delete_attachment_msite_grp;
1018:
1019: -- Standard call to check for call compatibility
1020: IF NOT FND_API.compatible_api_call(
1021: g_api_version,
1022: p_api_version,
1023: l_api_name,
1024: g_pkg_name

Line 1026: RAISE FND_API.g_exc_unexpected_error;

1022: p_api_version,
1023: l_api_name,
1024: g_pkg_name
1025: ) THEN
1026: RAISE FND_API.g_exc_unexpected_error;
1027: END IF;
1028:
1029: -- Initialize message list if p_init_msg_list is set to TRUE
1030: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 1030: IF FND_API.to_boolean(p_init_msg_list) THEN

1026: RAISE FND_API.g_exc_unexpected_error;
1027: END IF;
1028:
1029: -- Initialize message list if p_init_msg_list is set to TRUE
1030: IF FND_API.to_boolean(p_init_msg_list) THEN
1031: FND_MSG_PUB.initialize;
1032: END IF;
1033:
1034: -- Initialize API rturn status to success

Line 1035: x_return_status := FND_API.g_ret_sts_success;

1031: FND_MSG_PUB.initialize;
1032: END IF;
1033:
1034: -- Initialize API rturn status to success
1035: x_return_status := FND_API.g_ret_sts_success;
1036:
1037: -- API body
1038:
1039: IF p_msite_id_tbl IS NOT NULL THEN

Line 1061: x_return_status := FND_API.g_ret_sts_unexp_error ;

1057: EXCEPTION
1058:
1059: WHEN OTHERS THEN
1060: ROLLBACK TO delete_one_ath_msite_grp;
1061: x_return_status := FND_API.g_ret_sts_unexp_error ;
1062: IF FND_MSG_PUB.check_msg_level(
1063: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1064: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1065: END IF;

Line 1073: IF FND_API.to_boolean(p_commit) THEN

1069: END IF;
1070:
1071: -- Check if the caller requested to commit ,
1072: -- If p_commit set to true, commit the transaction
1073: IF FND_API.to_boolean(p_commit) THEN
1074: COMMIT;
1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info

Line 1079: p_encoded => FND_API.g_false,

1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info
1078: FND_MSG_PUB.count_and_get(
1079: p_encoded => FND_API.g_false,
1080: p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1083:

Line 1086: WHEN FND_API.g_exc_error THEN

1082: );
1083:
1084: EXCEPTION
1085:
1086: WHEN FND_API.g_exc_error THEN
1087: ROLLBACK TO delete_attachment_msite_grp;
1088: x_return_status := FND_API.g_ret_sts_error;
1089: FND_MSG_PUB.count_and_get(
1090: p_encoded => FND_API.g_false,

Line 1088: x_return_status := FND_API.g_ret_sts_error;

1084: EXCEPTION
1085:
1086: WHEN FND_API.g_exc_error THEN
1087: ROLLBACK TO delete_attachment_msite_grp;
1088: x_return_status := FND_API.g_ret_sts_error;
1089: FND_MSG_PUB.count_and_get(
1090: p_encoded => FND_API.g_false,
1091: p_count => x_msg_count,
1092: p_data => x_msg_data

Line 1090: p_encoded => FND_API.g_false,

1086: WHEN FND_API.g_exc_error THEN
1087: ROLLBACK TO delete_attachment_msite_grp;
1088: x_return_status := FND_API.g_ret_sts_error;
1089: FND_MSG_PUB.count_and_get(
1090: p_encoded => FND_API.g_false,
1091: p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );
1094:

Line 1095: WHEN FND_API.g_exc_unexpected_error THEN

1091: p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );
1094:
1095: WHEN FND_API.g_exc_unexpected_error THEN
1096: ROLLBACK TO delete_attachment_msite_grp;
1097: x_return_status := FND_API.g_ret_sts_unexp_error ;
1098: FND_MSG_PUB.count_and_get(
1099: p_encoded => FND_API.g_false,

Line 1097: x_return_status := FND_API.g_ret_sts_unexp_error ;

1093: );
1094:
1095: WHEN FND_API.g_exc_unexpected_error THEN
1096: ROLLBACK TO delete_attachment_msite_grp;
1097: x_return_status := FND_API.g_ret_sts_unexp_error ;
1098: FND_MSG_PUB.count_and_get(
1099: p_encoded => FND_API.g_false,
1100: p_count => x_msg_count,
1101: p_data => x_msg_data

Line 1099: p_encoded => FND_API.g_false,

1095: WHEN FND_API.g_exc_unexpected_error THEN
1096: ROLLBACK TO delete_attachment_msite_grp;
1097: x_return_status := FND_API.g_ret_sts_unexp_error ;
1098: FND_MSG_PUB.count_and_get(
1099: p_encoded => FND_API.g_false,
1100: p_count => x_msg_count,
1101: p_data => x_msg_data
1102: );
1103:

Line 1106: x_return_status := FND_API.g_ret_sts_unexp_error ;

1102: );
1103:
1104: WHEN OTHERS THEN
1105: ROLLBACK TO delete_attachment_msite_grp;
1106: x_return_status := FND_API.g_ret_sts_unexp_error ;
1107:
1108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1109: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;

Line 1113: p_encoded => FND_API.g_false,

1109: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111:
1112: FND_MSG_PUB.count_and_get(
1113: p_encoded => FND_API.g_false,
1114: p_count => x_msg_count,
1115: p_data => x_msg_data
1116: );
1117:

Line 1166: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT

1162:
1163:
1164: PROCEDURE save_physicalmap(
1165: p_api_version IN NUMBER,
1166: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1167: p_commit IN VARCHAR2 := FND_API.g_false,
1168: x_return_status OUT NOCOPY VARCHAR2,
1169: x_msg_count OUT NOCOPY NUMBER,
1170: x_msg_data OUT NOCOPY VARCHAR2,

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

1163:
1164: PROCEDURE save_physicalmap(
1165: p_api_version IN NUMBER,
1166: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1167: p_commit IN VARCHAR2 := FND_API.g_false,
1168: x_return_status OUT NOCOPY VARCHAR2,
1169: x_msg_count OUT NOCOPY NUMBER,
1170: x_msg_data OUT NOCOPY VARCHAR2,
1171: p_deliverable_id IN NUMBER,

Line 1212: IF NOT FND_API.Compatible_API_Call(l_api_version,

1208: l_default_msite := g_no;
1209: l_default_lang := g_no;
1210:
1211:
1212: IF NOT FND_API.Compatible_API_Call(l_api_version,
1213: p_api_version,
1214: l_api_name,
1215: G_PKG_NAME) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1212: IF NOT FND_API.Compatible_API_Call(l_api_version,
1213: p_api_version,
1214: l_api_name,
1215: G_PKG_NAME) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218: IF FND_API.to_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;
1220: END IF;

Line 1218: IF FND_API.to_Boolean(p_init_msg_list) THEN

1214: l_api_name,
1215: G_PKG_NAME) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218: IF FND_API.to_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;
1220: END IF;
1221: -- Initialize API return status to SUCCESS
1222: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1222: x_return_status := FND_API.G_RET_STS_SUCCESS;

1218: IF FND_API.to_Boolean(p_init_msg_list) THEN
1219: FND_MSG_PUB.initialize;
1220: END IF;
1221: -- Initialize API return status to SUCCESS
1222: x_return_status := FND_API.G_RET_STS_SUCCESS;
1223: l_ocm_integration
1224: := FND_PROFILE.value('IBE_M_USE_CONTENT_INTEGRATION');
1225: IF (l_ocm_integration IS NOT NULL)
1226: AND (l_ocm_integration = 'Y') THEN

Line 1243: RAISE FND_API.g_exc_error;

1239: l_msite_id := p_msite_id;
1240: IF p_msite_id IS NOT NULL THEN
1241: IF NOT IBE_DSPMGRVALIDATION_GRP.check_msite_exists
1242: (p_msite_id) THEN
1243: RAISE FND_API.g_exc_error;
1244: END IF;
1245: ELSE
1246: l_msite_type := 'ALLSITES';
1247: l_default_msite := g_yes;

Line 1251: RAISE FND_API.g_exc_error;

1247: l_default_msite := g_yes;
1248: l_msite_id :=
1249: IBE_DSPMGRVALIDATION_GRP.check_master_msite_exists;
1250: IF l_msite_id IS NULL THEN
1251: RAISE FND_API.g_exc_error;
1252: END IF;
1253: END IF;
1254:
1255: IF (l_ocm_integration IS NULL)

Line 1359: RAISE FND_API.g_exc_error;

1355: -- Check if the language is supported at the given site
1356: -- For OCM integration, this check is not necessary.
1357: IF NOT IBE_DSPMGRVALIDATION_GRP.check_language_supported
1358: (p_msite_id, p_language_code_tbl(l_index)) THEN
1359: RAISE FND_API.g_exc_error;
1360: END IF;
1361: END IF;
1362: l_language_code := p_language_code_tbl(l_index);
1363: END IF;

Line 1379: WHEN FND_API.g_exc_error THEN

1375: FND_GLOBAL.login_id, l_msite_id, l_language_code,
1376: l_attachment_id, l_deliverable_id, l_default_msite,
1377: l_default_lang, l_content_item_key);
1378: EXCEPTION
1379: WHEN FND_API.g_exc_error THEN
1380: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1381: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1382: x_return_status := FND_API.g_ret_sts_error;
1383: END IF;

Line 1381: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

1377: l_default_lang, l_content_item_key);
1378: EXCEPTION
1379: WHEN FND_API.g_exc_error THEN
1380: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1381: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1382: x_return_status := FND_API.g_ret_sts_error;
1383: END IF;
1384: WHEN dup_val_on_index THEN
1385: ROLLBACK TO SAVE_ONE_PHYSICALMAP;

Line 1382: x_return_status := FND_API.g_ret_sts_error;

1378: EXCEPTION
1379: WHEN FND_API.g_exc_error THEN
1380: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1381: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1382: x_return_status := FND_API.g_ret_sts_error;
1383: END IF;
1384: WHEN dup_val_on_index THEN
1385: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1386: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

Line 1386: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN

1382: x_return_status := FND_API.g_ret_sts_error;
1383: END IF;
1384: WHEN dup_val_on_index THEN
1385: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1386: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1387: x_return_status := FND_API.g_ret_sts_error;
1388: END IF;
1389: IF FND_MSG_PUB.check_msg_level
1390: (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 1387: x_return_status := FND_API.g_ret_sts_error;

1383: END IF;
1384: WHEN dup_val_on_index THEN
1385: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1386: IF x_return_status <> FND_API.g_ret_sts_unexp_error THEN
1387: x_return_status := FND_API.g_ret_sts_error;
1388: END IF;
1389: IF FND_MSG_PUB.check_msg_level
1390: (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1391: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 1410: x_return_status := FND_API.g_ret_sts_unexp_error;

1406: FND_MSG_PUB.add;
1407: END IF;
1408: WHEN OTHERS THEN
1409: ROLLBACK TO SAVE_ONE_PHYSICALMAP;
1410: x_return_status := FND_API.g_ret_sts_unexp_error;
1411: IF FND_MSG_PUB.check_msg_level(
1412: FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1413: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1414: END IF;

Line 1419: IF (FND_API.To_Boolean(p_commit)) THEN

1415: END;
1416: END LOOP;
1417: END IF;
1418: END IF;
1419: IF (FND_API.To_Boolean(p_commit)) THEN
1420: COMMIT WORK;
1421: END IF;
1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1423: p_data => x_msg_data,

Line 1426: WHEN FND_API.G_EXC_ERROR THEN

1422: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1423: p_data => x_msg_data,
1424: p_encoded => 'F');
1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: ROLLBACK TO SAVE_PHYSICALMAP;
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1430: p_data => x_msg_data,

Line 1428: x_return_status := FND_API.G_RET_STS_ERROR;

1424: p_encoded => 'F');
1425: EXCEPTION
1426: WHEN FND_API.G_EXC_ERROR THEN
1427: ROLLBACK TO SAVE_PHYSICALMAP;
1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1430: p_data => x_msg_data,
1431: p_encoded => 'F');
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1428: x_return_status := FND_API.G_RET_STS_ERROR;
1429: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1430: p_data => x_msg_data,
1431: p_encoded => 'F');
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1433: ROLLBACK TO SAVE_PHYSICALMAP;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1436: p_data => x_msg_data,

Line 1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1430: p_data => x_msg_data,
1431: p_encoded => 'F');
1432: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1433: ROLLBACK TO SAVE_PHYSICALMAP;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1436: p_data => x_msg_data,
1437: p_encoded => 'F');
1438:

Line 1442: x_return_status := FND_API.g_ret_sts_error;

1438:
1439: --added by YAXU on 01/02/2004
1440: WHEN dup_val_on_index THEN
1441: ROLLBACK TO SAVE_PHYSICALMAP;
1442: x_return_status := FND_API.g_ret_sts_error;
1443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
1444: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1445:
1446: IF l_default_msite = g_yes and l_default_lang = g_yes THEN

Line 1459: p_encoded => FND_API.g_false,

1455:
1456: END IF;
1457:
1458: FND_MSG_PUB.count_and_get(
1459: p_encoded => FND_API.g_false,
1460: p_count => x_msg_count,
1461: p_data => x_msg_data
1462: );
1463:

Line 1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_MSG_PUB.Add;
1472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1473: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1474: THEN
1475: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1476: END IF;

Line 1484: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT

1480: END save_physicalmap;
1481:
1482: PROCEDURE save_physicalmap(
1483: p_api_version IN NUMBER,
1484: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1485: p_commit IN VARCHAR2 := FND_API.g_false,
1486: x_return_status OUT NOCOPY VARCHAR2,
1487: x_msg_count OUT NOCOPY NUMBER,
1488: x_msg_data OUT NOCOPY VARCHAR2,

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

1481:
1482: PROCEDURE save_physicalmap(
1483: p_api_version IN NUMBER,
1484: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1485: p_commit IN VARCHAR2 := FND_API.g_false,
1486: x_return_status OUT NOCOPY VARCHAR2,
1487: x_msg_count OUT NOCOPY NUMBER,
1488: x_msg_data OUT NOCOPY VARCHAR2,
1489: p_deliverable_id IN NUMBER,

Line 1512: l_return_status := FND_API.g_ret_sts_success;

1508: l_old_content_item_key VARCHAR2(100);
1509:
1510: BEGIN
1511: SAVEPOINT SAVE_PHYSICALMAP;
1512: l_return_status := FND_API.g_ret_sts_success;
1513: IF NOT FND_API.Compatible_API_Call(l_api_version,
1514: p_api_version,
1515: l_api_name,
1516: G_PKG_NAME) THEN

Line 1513: IF NOT FND_API.Compatible_API_Call(l_api_version,

1509:
1510: BEGIN
1511: SAVEPOINT SAVE_PHYSICALMAP;
1512: l_return_status := FND_API.g_ret_sts_success;
1513: IF NOT FND_API.Compatible_API_Call(l_api_version,
1514: p_api_version,
1515: l_api_name,
1516: G_PKG_NAME) THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1513: IF NOT FND_API.Compatible_API_Call(l_api_version,
1514: p_api_version,
1515: l_api_name,
1516: G_PKG_NAME) THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: END IF;
1519: IF FND_API.to_Boolean(p_init_msg_list) THEN
1520: FND_MSG_PUB.initialize;
1521: END IF;

Line 1519: IF FND_API.to_Boolean(p_init_msg_list) THEN

1515: l_api_name,
1516: G_PKG_NAME) THEN
1517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1518: END IF;
1519: IF FND_API.to_Boolean(p_init_msg_list) THEN
1520: FND_MSG_PUB.initialize;
1521: END IF;
1522: -- Initialize API return status to SUCCESS
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1523: x_return_status := FND_API.G_RET_STS_SUCCESS;

1519: IF FND_API.to_Boolean(p_init_msg_list) THEN
1520: FND_MSG_PUB.initialize;
1521: END IF;
1522: -- Initialize API return status to SUCCESS
1523: x_return_status := FND_API.G_RET_STS_SUCCESS;
1524: -- Validate the input parameters
1525: IF p_msite_lang_tbl IS NOT NULL THEN
1526: l_count := 0;
1527: FOR l_index IN 1..p_msite_lang_tbl.COUNT LOOP

Line 1530: RAISE FND_API.g_exc_unexpected_error;

1526: l_count := 0;
1527: FOR l_index IN 1..p_msite_lang_tbl.COUNT LOOP
1528: IF p_msite_lang_tbl(l_index).lang_count IS NULL
1529: OR p_msite_lang_tbl(l_index).lang_count < 0 THEN
1530: RAISE FND_API.g_exc_unexpected_error;
1531: END IF;
1532: l_count := l_count + p_msite_lang_tbl(l_index).lang_count;
1533: END LOOP;
1534: IF (l_count > 0) THEN

Line 1537: RAISE FND_API.g_exc_unexpected_error;

1533: END LOOP;
1534: IF (l_count > 0) THEN
1535: IF (p_language_code_tbl IS NULL) OR
1536: l_count <> p_language_code_tbl.COUNT THEN
1537: RAISE FND_API.g_exc_unexpected_error;
1538: END IF;
1539: END IF;
1540: -- ELSE -- removed by YAXU
1541: -- RETURN;

Line 1577: l_return_status := FND_API.g_ret_sts_success;

1573: -- Start saving
1574: IF( p_msite_lang_tbl IS NOT NULL) THEN -- added by YAXU
1575: l_count := 0;
1576: FOR l_index IN 1..p_msite_lang_tbl.COUNT LOOP
1577: l_return_status := FND_API.g_ret_sts_success;
1578: l_language_code_tbl := NULL;
1579: IF p_msite_lang_tbl(l_index).lang_count > 0 THEN
1580: l_language_code_tbl := LANGUAGE_CODE_TBL_TYPE(
1581: p_language_code_tbl(l_count + 1));

Line 1600: IF l_return_status <> FND_API.g_ret_sts_success THEN

1596: p_old_content_key => p_old_content_key,
1597: p_new_content_key => p_new_content_key,
1598: p_msite_id => p_msite_lang_tbl(l_index).msite_id,
1599: p_language_code_tbl => l_language_code_tbl);
1600: IF l_return_status <> FND_API.g_ret_sts_success THEN
1601: x_return_status := l_return_status;
1602: END IF;
1603: END LOOP;
1604: END IF;

Line 1606: IF (FND_API.To_Boolean(p_commit)) THEN

1602: END IF;
1603: END LOOP;
1604: END IF;
1605:
1606: IF (FND_API.To_Boolean(p_commit)) THEN
1607: COMMIT WORK;
1608: END IF;
1609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1610: p_data => x_msg_data,

Line 1613: WHEN FND_API.G_EXC_ERROR THEN

1609: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1610: p_data => x_msg_data,
1611: p_encoded => 'F');
1612: EXCEPTION
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: ROLLBACK TO SAVE_PHYSICALMAP;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1617: p_data => x_msg_data,

Line 1615: x_return_status := FND_API.G_RET_STS_ERROR;

1611: p_encoded => 'F');
1612: EXCEPTION
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: ROLLBACK TO SAVE_PHYSICALMAP;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1617: p_data => x_msg_data,
1618: p_encoded => 'F');
1619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1617: p_data => x_msg_data,
1618: p_encoded => 'F');
1619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1620: ROLLBACK TO SAVE_PHYSICALMAP;
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1623: p_data => x_msg_data,

Line 1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1617: p_data => x_msg_data,
1618: p_encoded => 'F');
1619: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1620: ROLLBACK TO SAVE_PHYSICALMAP;
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1623: p_data => x_msg_data,
1624: p_encoded => 'F');
1625: WHEN OTHERS THEN

Line 1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1628: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1629: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1630: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1631: FND_MSG_PUB.Add;
1632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1633: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1634: THEN
1635: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1636: END IF;

Line 1644: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT

1640: END save_physicalmap;
1641:
1642: PROCEDURE delete_physicalmap(
1643: p_api_version IN NUMBER,
1644: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1645: p_commit IN VARCHAR2 := FND_API.g_false,
1646: x_return_status OUT NOCOPY VARCHAR2,
1647: x_msg_count OUT NOCOPY NUMBER,
1648: x_msg_data OUT NOCOPY VARCHAR2,

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

1641:
1642: PROCEDURE delete_physicalmap(
1643: p_api_version IN NUMBER,
1644: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1645: p_commit IN VARCHAR2 := FND_API.g_false,
1646: x_return_status OUT NOCOPY VARCHAR2,
1647: x_msg_count OUT NOCOPY NUMBER,
1648: x_msg_data OUT NOCOPY VARCHAR2,
1649: p_deliverable_id IN NUMBER,

Line 1667: IF NOT FND_API.Compatible_API_Call(l_api_version,

1663:
1664: BEGIN
1665: SAVEPOINT DELETE_PHYSICALMAP;
1666: l_deliverable_id := p_deliverable_id;
1667: IF NOT FND_API.Compatible_API_Call(l_api_version,
1668: p_api_version,
1669: l_api_name,
1670: G_PKG_NAME) THEN
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1667: IF NOT FND_API.Compatible_API_Call(l_api_version,
1668: p_api_version,
1669: l_api_name,
1670: G_PKG_NAME) THEN
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1672: END IF;
1673: IF FND_API.to_Boolean(p_init_msg_list) THEN
1674: FND_MSG_PUB.initialize;
1675: END IF;

Line 1673: IF FND_API.to_Boolean(p_init_msg_list) THEN

1669: l_api_name,
1670: G_PKG_NAME) THEN
1671: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1672: END IF;
1673: IF FND_API.to_Boolean(p_init_msg_list) THEN
1674: FND_MSG_PUB.initialize;
1675: END IF;
1676: -- Initialize API return status to SUCCESS
1677: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1677: x_return_status := FND_API.G_RET_STS_SUCCESS;

1673: IF FND_API.to_Boolean(p_init_msg_list) THEN
1674: FND_MSG_PUB.initialize;
1675: END IF;
1676: -- Initialize API return status to SUCCESS
1677: x_return_status := FND_API.G_RET_STS_SUCCESS;
1678: l_ocm_integration
1679: := FND_PROFILE.value('IBE_M_USE_CONTENT_INTEGRATION');
1680: IF (l_ocm_integration IS NOT NULL)
1681: AND (l_ocm_integration = 'Y') THEN

Line 1725: IF (FND_API.To_Boolean(p_commit)) THEN

1721: END IF;
1722: END IF;
1723:
1724: END IF;
1725: IF (FND_API.To_Boolean(p_commit)) THEN
1726: COMMIT WORK;
1727: END IF;
1728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1729: p_data => x_msg_data,

Line 1732: WHEN FND_API.G_EXC_ERROR THEN

1728: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1729: p_data => x_msg_data,
1730: p_encoded => 'F');
1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN
1733: ROLLBACK TO DELETE_PHYSICALMAP;
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1736: p_data => x_msg_data,

Line 1734: x_return_status := FND_API.G_RET_STS_ERROR;

1730: p_encoded => 'F');
1731: EXCEPTION
1732: WHEN FND_API.G_EXC_ERROR THEN
1733: ROLLBACK TO DELETE_PHYSICALMAP;
1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1736: p_data => x_msg_data,
1737: p_encoded => 'F');
1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1734: x_return_status := FND_API.G_RET_STS_ERROR;
1735: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1736: p_data => x_msg_data,
1737: p_encoded => 'F');
1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1739: ROLLBACK TO DELETE_PHYSICALMAP;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1742: p_data => x_msg_data,

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1736: p_data => x_msg_data,
1737: p_encoded => 'F');
1738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1739: ROLLBACK TO DELETE_PHYSICALMAP;
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1742: p_data => x_msg_data,
1743: p_encoded => 'F');
1744: WHEN OTHERS THEN

Line 1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1747: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1748: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1749: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1750: FND_MSG_PUB.Add;
1751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1752: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1753: THEN
1754: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1755: END IF;

Line 1763: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT

1759: END delete_physicalmap;
1760:
1761: PROCEDURE replace_content(
1762: p_api_version IN NUMBER,
1763: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1764: p_commit IN VARCHAR2 := FND_API.g_false,
1765: x_return_status OUT NOCOPY VARCHAR2,
1766: x_msg_count OUT NOCOPY NUMBER,
1767: x_msg_data OUT NOCOPY VARCHAR2,

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

1760:
1761: PROCEDURE replace_content(
1762: p_api_version IN NUMBER,
1763: p_init_msg_list IN VARCHAR2 := FND_API.g_false, --modified by YAXU, ewmove DEFAULT
1764: p_commit IN VARCHAR2 := FND_API.g_false,
1765: x_return_status OUT NOCOPY VARCHAR2,
1766: x_msg_count OUT NOCOPY NUMBER,
1767: x_msg_data OUT NOCOPY VARCHAR2,
1768: p_old_content_key IN VARCHAR2,

Line 1781: IF NOT FND_API.Compatible_API_Call(l_api_version,

1777: l_old_attachment_id NUMBER;
1778: l_old_content_item_key VARCHAR2(100);
1779: BEGIN
1780: SAVEPOINT REPLACE_CONTENT;
1781: IF NOT FND_API.Compatible_API_Call(l_api_version,
1782: p_api_version,
1783: l_api_name,
1784: G_PKG_NAME) THEN
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1781: IF NOT FND_API.Compatible_API_Call(l_api_version,
1782: p_api_version,
1783: l_api_name,
1784: G_PKG_NAME) THEN
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786: END IF;
1787: IF FND_API.to_Boolean(p_init_msg_list) THEN
1788: FND_MSG_PUB.initialize;
1789: END IF;

Line 1787: IF FND_API.to_Boolean(p_init_msg_list) THEN

1783: l_api_name,
1784: G_PKG_NAME) THEN
1785: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1786: END IF;
1787: IF FND_API.to_Boolean(p_init_msg_list) THEN
1788: FND_MSG_PUB.initialize;
1789: END IF;
1790: -- Initialize API return status to SUCCESS
1791: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1791: x_return_status := FND_API.G_RET_STS_SUCCESS;

1787: IF FND_API.to_Boolean(p_init_msg_list) THEN
1788: FND_MSG_PUB.initialize;
1789: END IF;
1790: -- Initialize API return status to SUCCESS
1791: x_return_status := FND_API.G_RET_STS_SUCCESS;
1792: l_ocm_integration
1793: := FND_PROFILE.value('IBE_M_USE_CONTENT_INTEGRATION');
1794: IF (l_ocm_integration IS NOT NULL)
1795: AND (l_ocm_integration = 'Y') THEN

Line 1810: IF (FND_API.To_Boolean(p_commit)) THEN

1806: SET attachment_id = l_attachment_id
1807: WHERE attachment_id = l_old_attachment_id
1808: AND content_item_key IS NULL;
1809: END IF;
1810: IF (FND_API.To_Boolean(p_commit)) THEN
1811: COMMIT WORK;
1812: END IF;
1813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1814: p_data => x_msg_data,

Line 1817: WHEN FND_API.G_EXC_ERROR THEN

1813: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1814: p_data => x_msg_data,
1815: p_encoded => 'F');
1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: ROLLBACK TO REPLACE_CONTENT;
1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1821: p_data => x_msg_data,

Line 1819: x_return_status := FND_API.G_RET_STS_ERROR;

1815: p_encoded => 'F');
1816: EXCEPTION
1817: WHEN FND_API.G_EXC_ERROR THEN
1818: ROLLBACK TO REPLACE_CONTENT;
1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1821: p_data => x_msg_data,
1822: p_encoded => 'F');
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1819: x_return_status := FND_API.G_RET_STS_ERROR;
1820: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1821: p_data => x_msg_data,
1822: p_encoded => 'F');
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1824: ROLLBACK TO REPLACE_CONTENT;
1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1827: p_data => x_msg_data,

Line 1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1821: p_data => x_msg_data,
1822: p_encoded => 'F');
1823: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1824: ROLLBACK TO REPLACE_CONTENT;
1825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1826: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1827: p_data => x_msg_data,
1828: p_encoded => 'F');
1829: WHEN OTHERS THEN

Line 1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1832: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1833: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1834: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1835: FND_MSG_PUB.Add;
1836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1837: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1838: THEN
1839: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1840: END IF;