APPS.AMS_CELL_PVT dependencies on FND_MSG_PUB

Line 65: FND_MSG_PUB.initialize;

61:
62: AMS_Utility_PVT.debug_message(l_full_name||': start');
63:
64: IF FND_API.to_boolean(p_init_msg_list) THEN
65: FND_MSG_PUB.initialize;
66: END IF;
67:
68: IF NOT FND_API.compatible_api_call(
69: l_api_version,

Line 205: FND_MSG_PUB.count_and_get(

201: IF FND_API.to_boolean(p_commit) THEN
202: COMMIT;
203: END IF;
204:
205: FND_MSG_PUB.count_and_get(
206: p_encoded => FND_API.g_false,
207: p_count => x_msg_count,
208: p_data => x_msg_data
209: );

Line 218: FND_MSG_PUB.count_and_get(

214:
215: WHEN FND_API.g_exc_error THEN
216: ROLLBACK TO create_cell;
217: x_return_status := FND_API.g_ret_sts_error;
218: FND_MSG_PUB.count_and_get(
219: p_encoded => FND_API.g_false,
220: p_count => x_msg_count,
221: p_data => x_msg_data
222: );

Line 226: FND_MSG_PUB.count_and_get(

222: );
223: WHEN FND_API.g_exc_unexpected_error THEN
224: ROLLBACK TO create_cell;
225: x_return_status := FND_API.g_ret_sts_unexp_error ;
226: FND_MSG_PUB.count_and_get(
227: p_encoded => FND_API.g_false,
228: p_count => x_msg_count,
229: p_data => x_msg_data
230: );

Line 236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

232: WHEN OTHERS THEN
233: ROLLBACK TO create_cell;
234: x_return_status := FND_API.g_ret_sts_unexp_error ;
235:
236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
237: THEN
238: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
239: END IF;
240:

Line 238: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

234: x_return_status := FND_API.g_ret_sts_unexp_error ;
235:
236: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
237: THEN
238: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
239: END IF;
240:
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,

Line 241: FND_MSG_PUB.count_and_get(

237: THEN
238: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
239: END IF;
240:
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data
245: );

Line 282: FND_MSG_PUB.initialize;

278:
279: AMS_Utility_PVT.debug_message(l_full_name||': start');
280:
281: IF FND_API.to_boolean(p_init_msg_list) THEN
282: FND_MSG_PUB.initialize;
283: END IF;
284:
285: IF NOT FND_API.compatible_api_call(
286: l_api_version,

Line 305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

301: WHERE cell_id = p_cell_id
302: AND object_version_number = p_object_version;
303:
304: IF (SQL%NOTFOUND) THEN
305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
306: THEN
307: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
308: FND_MSG_PUB.add;
309: END IF;

Line 308: FND_MSG_PUB.add;

304: IF (SQL%NOTFOUND) THEN
305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
306: THEN
307: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
308: FND_MSG_PUB.add;
309: END IF;
310: RAISE FND_API.g_exc_error;
311: END IF;
312:

Line 319: FND_MSG_PUB.count_and_get(

315: IF FND_API.to_boolean(p_commit) THEN
316: COMMIT;
317: END IF;
318:
319: FND_MSG_PUB.count_and_get(
320: p_encoded => FND_API.g_false,
321: p_count => x_msg_count,
322: p_data => x_msg_data
323: );

Line 332: FND_MSG_PUB.count_and_get(

328:
329: WHEN FND_API.g_exc_error THEN
330: ROLLBACK TO delete_cell;
331: x_return_status := FND_API.g_ret_sts_error;
332: FND_MSG_PUB.count_and_get(
333: p_encoded => FND_API.g_false,
334: p_count => x_msg_count,
335: p_data => x_msg_data
336: );

Line 341: FND_MSG_PUB.count_and_get(

337:
338: WHEN FND_API.g_exc_unexpected_error THEN
339: ROLLBACK TO delete_cell;
340: x_return_status := FND_API.g_ret_sts_unexp_error ;
341: FND_MSG_PUB.count_and_get(
342: p_encoded => FND_API.g_false,
343: p_count => x_msg_count,
344: p_data => x_msg_data
345: );

Line 351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

347: WHEN OTHERS THEN
348: ROLLBACK TO delete_cell;
349: x_return_status := FND_API.g_ret_sts_unexp_error ;
350:
351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
352: THEN
353: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
354: END IF;
355:

Line 353: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

349: x_return_status := FND_API.g_ret_sts_unexp_error ;
350:
351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
352: THEN
353: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
354: END IF;
355:
356: FND_MSG_PUB.count_and_get(
357: p_encoded => FND_API.g_false,

Line 356: FND_MSG_PUB.count_and_get(

352: THEN
353: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
354: END IF;
355:
356: FND_MSG_PUB.count_and_get(
357: p_encoded => FND_API.g_false,
358: p_count => x_msg_count,
359: p_data => x_msg_data
360: );

Line 411: FND_MSG_PUB.initialize;

407: -------------------- initialize ------------------------
408: AMS_Utility_PVT.debug_message(l_full_name||': start');
409:
410: IF FND_API.to_boolean(p_init_msg_list) THEN
411: FND_MSG_PUB.initialize;
412: END IF;
413:
414: IF NOT FND_API.compatible_api_call(
415: l_api_version,

Line 432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

428: OPEN c_cell_b;
429: FETCH c_cell_b INTO l_cell_id;
430: IF (c_cell_b%NOTFOUND) THEN
431: CLOSE c_cell_b;
432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
433: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
434: FND_MSG_PUB.add;
435: END IF;
436: RAISE FND_API.g_exc_error;

Line 434: FND_MSG_PUB.add;

430: IF (c_cell_b%NOTFOUND) THEN
431: CLOSE c_cell_b;
432: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
433: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
434: FND_MSG_PUB.add;
435: END IF;
436: RAISE FND_API.g_exc_error;
437: END IF;
438: CLOSE c_cell_b;

Line 444: FND_MSG_PUB.count_and_get(

440: OPEN c_cell_tl;
441: CLOSE c_cell_tl;
442:
443: -------------------- finish --------------------------
444: FND_MSG_PUB.count_and_get(
445: p_encoded => FND_API.g_false,
446: p_count => x_msg_count,
447: p_data => x_msg_data
448: );

Line 456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

452: EXCEPTION
453:
454: WHEN AMS_Utility_PVT.resource_locked THEN
455: x_return_status := FND_API.g_ret_sts_error;
456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
457: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
458: FND_MSG_PUB.add;
459: END IF;
460:

Line 458: FND_MSG_PUB.add;

454: WHEN AMS_Utility_PVT.resource_locked THEN
455: x_return_status := FND_API.g_ret_sts_error;
456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
457: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
458: FND_MSG_PUB.add;
459: END IF;
460:
461: FND_MSG_PUB.count_and_get(
462: p_encoded => FND_API.g_false,

Line 461: FND_MSG_PUB.count_and_get(

457: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
458: FND_MSG_PUB.add;
459: END IF;
460:
461: FND_MSG_PUB.count_and_get(
462: p_encoded => FND_API.g_false,
463: p_count => x_msg_count,
464: p_data => x_msg_data
465: );

Line 469: FND_MSG_PUB.count_and_get(

465: );
466:
467: WHEN FND_API.g_exc_error THEN
468: x_return_status := FND_API.g_ret_sts_error;
469: FND_MSG_PUB.count_and_get(
470: p_encoded => FND_API.g_false,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );

Line 477: FND_MSG_PUB.count_and_get(

473: );
474:
475: WHEN FND_API.g_exc_unexpected_error THEN
476: x_return_status := FND_API.g_ret_sts_unexp_error ;
477: FND_MSG_PUB.count_and_get(
478: p_encoded => FND_API.g_false,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );

Line 485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

481: );
482:
483: WHEN OTHERS THEN
484: x_return_status := FND_API.g_ret_sts_unexp_error ;
485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
486: THEN
487: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
488: END IF;
489:

Line 487: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

483: WHEN OTHERS THEN
484: x_return_status := FND_API.g_ret_sts_unexp_error ;
485: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
486: THEN
487: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
488: END IF;
489:
490: FND_MSG_PUB.count_and_get(
491: p_encoded => FND_API.g_false,

Line 490: FND_MSG_PUB.count_and_get(

486: THEN
487: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
488: END IF;
489:
490: FND_MSG_PUB.count_and_get(
491: p_encoded => FND_API.g_false,
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );

Line 537: FND_MSG_PUB.initialize;

533:
534: AMS_Utility_PVT.debug_message(l_full_name||': start');
535:
536: IF FND_API.to_boolean(p_init_msg_list) THEN
537: FND_MSG_PUB.initialize;
538: END IF;
539:
540: IF NOT FND_API.compatible_api_call(
541: l_api_version,

Line 595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

591: WHERE cell_id = l_cell_rec.cell_id
592: AND object_version_number = l_cell_rec.object_version_number;
593:
594: IF (SQL%NOTFOUND) THEN
595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
596: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
597: FND_MSG_PUB.add;
598: END IF;
599: AMS_Utility_PVT.debug_message(l_full_name ||': update b');

Line 597: FND_MSG_PUB.add;

593:
594: IF (SQL%NOTFOUND) THEN
595: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
596: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
597: FND_MSG_PUB.add;
598: END IF;
599: AMS_Utility_PVT.debug_message(l_full_name ||': update b');
600: RAISE FND_API.g_exc_error;
601: END IF;

Line 614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

610: WHERE cell_id = l_cell_rec.cell_id
611: AND USERENV('LANG') IN (language, source_lang);
612:
613: IF (SQL%NOTFOUND) THEN
614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
615: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
616: FND_MSG_PUB.add;
617: AMS_Utility_PVT.debug_message(l_full_name ||': updatetl');
618: END IF;

Line 616: FND_MSG_PUB.add;

612:
613: IF (SQL%NOTFOUND) THEN
614: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
615: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
616: FND_MSG_PUB.add;
617: AMS_Utility_PVT.debug_message(l_full_name ||': updatetl');
618: END IF;
619: RAISE FND_API.g_exc_error;
620: END IF;

Line 627: FND_MSG_PUB.count_and_get(

623: IF FND_API.to_boolean(p_commit) THEN
624: COMMIT;
625: END IF;
626:
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,
629: p_count => x_msg_count,
630: p_data => x_msg_data
631: );

Line 640: FND_MSG_PUB.count_and_get(

636:
637: WHEN FND_API.g_exc_error THEN
638: ROLLBACK TO update_cell;
639: x_return_status := FND_API.g_ret_sts_error;
640: FND_MSG_PUB.count_and_get(
641: p_encoded => FND_API.g_false,
642: p_count => x_msg_count,
643: p_data => x_msg_data
644: );

Line 649: FND_MSG_PUB.count_and_get(

645:
646: WHEN FND_API.g_exc_unexpected_error THEN
647: ROLLBACK TO update_cell;
648: x_return_status := FND_API.g_ret_sts_unexp_error;
649: FND_MSG_PUB.count_and_get(
650: p_encoded => FND_API.g_false,
651: p_count => x_msg_count,
652: p_data => x_msg_data
653: );

Line 659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

655: WHEN OTHERS THEN
656: ROLLBACK TO update_cell;
657: x_return_status := FND_API.g_ret_sts_unexp_error;
658:
659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
660: THEN
661: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
662: END IF;
663:

Line 661: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

657: x_return_status := FND_API.g_ret_sts_unexp_error;
658:
659: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
660: THEN
661: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
662: END IF;
663:
664: FND_MSG_PUB.count_and_get(
665: p_encoded => FND_API.g_false,

Line 664: FND_MSG_PUB.count_and_get(

660: THEN
661: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
662: END IF;
663:
664: FND_MSG_PUB.count_and_get(
665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );

Line 705: FND_MSG_PUB.initialize;

701: ----------------------- initialize --------------------
702: AMS_Utility_PVT.debug_message(l_full_name||': start');
703:
704: IF FND_API.to_boolean(p_init_msg_list) THEN
705: FND_MSG_PUB.initialize;
706: END IF;
707:
708: IF NOT FND_API.compatible_api_call(
709: l_api_version,

Line 737: FND_MSG_PUB.count_and_get(

733: END IF;
734:
735:
736: -------------------- finish --------------------------
737: FND_MSG_PUB.count_and_get(
738: p_encoded => FND_API.g_false,
739: p_count => x_msg_count,
740: p_data => x_msg_data
741: );

Line 749: FND_MSG_PUB.count_and_get(

745: EXCEPTION
746:
747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get(
750: p_encoded => FND_API.g_false,
751: p_count => x_msg_count,
752: p_data => x_msg_data
753: );

Line 757: FND_MSG_PUB.count_and_get(

753: );
754:
755: WHEN FND_API.g_exc_unexpected_error THEN
756: x_return_status := FND_API.g_ret_sts_unexp_error ;
757: FND_MSG_PUB.count_and_get(
758: p_encoded => FND_API.g_false,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );

Line 765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

761: );
762:
763: WHEN OTHERS THEN
764: x_return_status := FND_API.g_ret_sts_unexp_error;
765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
766: THEN
767: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
768: END IF;
769:

Line 767: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

763: WHEN OTHERS THEN
764: x_return_status := FND_API.g_ret_sts_unexp_error;
765: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
766: THEN
767: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
768: END IF;
769:
770: FND_MSG_PUB.count_and_get(
771: p_encoded => FND_API.g_false,

Line 770: FND_MSG_PUB.count_and_get(

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

Line 798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

794:
795: x_return_status := FND_API.g_ret_sts_success;
796: ------------------------ cell_code --------------------------
797: IF p_cell_rec.cell_code IS NULL THEN
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
799: THEN
800: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_CODE');
801: FND_MSG_PUB.add;
802: END IF;

Line 801: FND_MSG_PUB.add;

797: IF p_cell_rec.cell_code IS NULL THEN
798: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
799: THEN
800: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_CODE');
801: FND_MSG_PUB.add;
802: END IF;
803: x_return_status := FND_API.g_ret_sts_error;
804: RETURN;
805: END IF;

Line 809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

805: END IF;
806:
807: ------------------------ cell_name --------------------------
808: IF p_cell_rec.cell_name IS NULL THEN
809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
810: THEN
811: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_NAME');
812: FND_MSG_PUB.add;
813: END IF;

Line 812: FND_MSG_PUB.add;

808: IF p_cell_rec.cell_name IS NULL THEN
809: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
810: THEN
811: FND_MESSAGE.set_name('AMS', 'AMS_CELL_NO_NAME');
812: FND_MSG_PUB.add;
813: END IF;
814: x_return_status := FND_API.g_ret_sts_error;
815: RETURN;
816: END IF;

Line 849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

845: 'ams_cells_vl',
846: 'cell_id = ' || p_cell_rec.cell_id
847: ) = FND_API.g_false
848: THEN
849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
850: THEN
851: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_ID');
852: FND_MSG_PUB.add;
853: END IF;

Line 852: FND_MSG_PUB.add;

848: THEN
849: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
850: THEN
851: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_ID');
852: FND_MSG_PUB.add;
853: END IF;
854: x_return_status := FND_API.g_ret_sts_error;
855: RETURN;
856: END IF;

Line 876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

872: );
873: END IF;
874:
875: IF l_valid_flag = FND_API.g_false THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
877: THEN
878: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_NAME');
879: FND_MSG_PUB.add;
880: END IF;

Line 879: FND_MSG_PUB.add;

875: IF l_valid_flag = FND_API.g_false THEN
876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
877: THEN
878: FND_MESSAGE.set_name('AMS', 'AMS_CELL_DUPLICATE_NAME');
879: FND_MSG_PUB.add;
880: END IF;
881: x_return_status := FND_API.g_ret_sts_error;
882: RETURN;
883: END IF;

Line 900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

896: );
897: END IF;
898:
899: IF l_valid_flag = FND_API.g_false THEN
900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
901: THEN
902: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_CODE');
903: FND_MSG_PUB.add;
904: END IF;

Line 903: FND_MSG_PUB.add;

899: IF l_valid_flag = FND_API.g_false THEN
900: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
901: THEN
902: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_CODE');
903: FND_MSG_PUB.add;
904: END IF;
905: x_return_status := FND_API.g_ret_sts_error;
906: RETURN;
907: END IF;

Line 934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

930: 'resource_id',
931: p_cell_rec.owner_id
932: ) = FND_API.g_false
933: THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
935: THEN
936: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BAD_OWNER_USER_ID');
937: FND_MSG_PUB.add;
938: END IF;

Line 937: FND_MSG_PUB.add;

933: THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
935: THEN
936: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BAD_OWNER_USER_ID');
937: FND_MSG_PUB.add;
938: END IF;
939: x_return_status := FND_API.g_ret_sts_error;
940: RETURN;
941: END IF;

Line 952: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

948: 'cell_id',
949: p_cell_rec.parent_cell_id
950: ) = FND_API.g_false
951: THEN
952: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
953: THEN
954: FND_MESSAGE.set_name('AMS', 'AMS_CELL_WRONG_PARENT_CELL_ID');
955: FND_MSG_PUB.add;
956: END IF;

Line 955: FND_MSG_PUB.add;

951: THEN
952: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
953: THEN
954: FND_MESSAGE.set_name('AMS', 'AMS_CELL_WRONG_PARENT_CELL_ID');
955: FND_MSG_PUB.add;
956: END IF;
957: x_return_status := FND_API.g_ret_sts_error;
958: RETURN;
959: END IF;

Line 988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

984: AND p_cell_rec.enabled_flag IS NOT NULL
985: THEN
986: IF AMS_Utility_PVT.is_Y_or_N(p_cell_rec.enabled_flag) = FND_API.g_false
987: THEN
988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
989: THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_CELL_WRONG_ENABLED_FLAG');
991: FND_MSG_PUB.add;
992: END IF;

Line 991: FND_MSG_PUB.add;

987: THEN
988: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
989: THEN
990: FND_MESSAGE.set_name('AMS', 'AMS_CELL_WRONG_ENABLED_FLAG');
991: FND_MSG_PUB.add;
992: END IF;
993: x_return_status := FND_API.g_ret_sts_error;
994: RETURN;
995: END IF;

Line 1044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1040:
1041: IF l_active_children_count > 0
1042:
1043: THEN
1044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1045: THEN
1046: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CANCEL_ERROR');
1047: FND_MSG_PUB.add;
1048: END IF;

Line 1047: FND_MSG_PUB.add;

1043: THEN
1044: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1045: THEN
1046: FND_MESSAGE.set_name('AMS', 'AMS_CELL_CANCEL_ERROR');
1047: FND_MSG_PUB.add;
1048: END IF;
1049: x_return_status := FND_API.g_ret_sts_error;
1050: RETURN;
1051: END IF;

Line 1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1061: fetch c_check_parent into l_count;
1062: close c_check_parent;
1063: IF l_count > 0
1064: THEN
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1066: THEN
1067: FND_MESSAGE.set_name('AMS', 'AMS_CELL_PARENT_ERROR');
1068: FND_MSG_PUB.add;
1069: END IF;

Line 1068: FND_MSG_PUB.add;

1064: THEN
1065: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1066: THEN
1067: FND_MESSAGE.set_name('AMS', 'AMS_CELL_PARENT_ERROR');
1068: FND_MSG_PUB.add;
1069: END IF;
1070: x_return_status := FND_API.g_ret_sts_error;
1071: RETURN;
1072: END IF;

Line 1206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1202: OPEN c_cell;
1203: FETCH c_cell INTO l_cell_rec;
1204: IF c_cell%NOTFOUND THEN
1205: CLOSE c_cell;
1206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1208: FND_MSG_PUB.add;
1209: END IF;
1210: RAISE FND_API.g_exc_error;

Line 1208: FND_MSG_PUB.add;

1204: IF c_cell%NOTFOUND THEN
1205: CLOSE c_cell;
1206: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1207: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1208: FND_MSG_PUB.add;
1209: END IF;
1210: RAISE FND_API.g_exc_error;
1211: END IF;
1212: CLOSE c_cell;

Line 1326: FND_MSG_PUB.initialize;

1322:
1323: AMS_Utility_PVT.debug_message(l_full_name||': start');
1324:
1325: IF FND_API.to_boolean(p_init_msg_list) THEN
1326: FND_MSG_PUB.initialize;
1327: END IF;
1328:
1329: IF NOT FND_API.compatible_api_call(
1330: l_api_version,

Line 1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1342:
1343: OPEN c_discoverer_cell;
1344: FETCH c_discoverer_cell INTO l_discoverer_cell_rec;
1345: IF c_discoverer_cell%NOTFOUND THEN
1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1347: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1348: FND_MSG_PUB.add;
1349: END IF;
1350: RAISE FND_API.g_exc_error;

Line 1348: FND_MSG_PUB.add;

1344: FETCH c_discoverer_cell INTO l_discoverer_cell_rec;
1345: IF c_discoverer_cell%NOTFOUND THEN
1346: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1347: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1348: FND_MSG_PUB.add;
1349: END IF;
1350: RAISE FND_API.g_exc_error;
1351: END IF;
1352: CLOSE c_discoverer_cell;

Line 1393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1389: IF instr(l_sql_string, 'PARTY_ID') = 0
1390: OR l_from_position = 0
1391: OR instr(l_sql_string, 'PARTY_ID') > l_from_position
1392: THEN
1393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1394: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
1395: FND_MSG_PUB.add;
1396: END IF;
1397: RAISE FND_API.g_exc_error;

Line 1395: FND_MSG_PUB.add;

1391: OR instr(l_sql_string, 'PARTY_ID') > l_from_position
1392: THEN
1393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1394: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
1395: FND_MSG_PUB.add;
1396: END IF;
1397: RAISE FND_API.g_exc_error;
1398: -- x_return_status := FND_API.g_ret_sts_error;
1399: RETURN;

Line 1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1404: -- Check if query has these clauses
1405: IF instr(l_sql_string, 'ORDER BY') > 0
1406: OR instr(l_sql_string, 'GROUP BY') > 0
1407: THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1409: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
1410: FND_MSG_PUB.add;
1411: END IF;
1412: RAISE FND_API.g_exc_error;

Line 1410: FND_MSG_PUB.add;

1406: OR instr(l_sql_string, 'GROUP BY') > 0
1407: THEN
1408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1409: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
1410: FND_MSG_PUB.add;
1411: END IF;
1412: RAISE FND_API.g_exc_error;
1413: -- x_return_status := FND_API.g_ret_sts_error;
1414: RETURN;

Line 1463: FND_MSG_PUB.count_and_get(

1459: IF FND_API.to_boolean(p_commit) THEN
1460: COMMIT;
1461: END IF;
1462:
1463: FND_MSG_PUB.count_and_get(
1464: p_encoded => FND_API.g_false,
1465: p_count => x_msg_count,
1466: p_data => x_msg_data
1467: );

Line 1476: FND_MSG_PUB.count_and_get(

1472:
1473: WHEN FND_API.g_exc_error THEN
1474: ROLLBACK TO add_sel_workbook;
1475: x_return_status := FND_API.g_ret_sts_error;
1476: FND_MSG_PUB.count_and_get(
1477: p_encoded => FND_API.g_false,
1478: p_count => x_msg_count,
1479: p_data => x_msg_data
1480: );

Line 1485: FND_MSG_PUB.count_and_get(

1481:
1482: WHEN FND_API.g_exc_unexpected_error THEN
1483: ROLLBACK TO add_sel_workbook;
1484: x_return_status := FND_API.g_ret_sts_unexp_error ;
1485: FND_MSG_PUB.count_and_get(
1486: p_encoded => FND_API.g_false,
1487: p_count => x_msg_count,
1488: p_data => x_msg_data
1489: );

Line 1496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1492: WHEN OTHERS THEN
1493: ROLLBACK TO add_sel_workbook;
1494: x_return_status := FND_API.g_ret_sts_unexp_error ;
1495:
1496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1497: THEN
1498: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1499: END IF;
1500:

Line 1498: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1494: x_return_status := FND_API.g_ret_sts_unexp_error ;
1495:
1496: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1497: THEN
1498: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1499: END IF;
1500:
1501: FND_MSG_PUB.count_and_get(
1502: p_encoded => FND_API.g_false,

Line 1501: FND_MSG_PUB.count_and_get(

1497: THEN
1498: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1499: END IF;
1500:
1501: FND_MSG_PUB.count_and_get(
1502: p_encoded => FND_API.g_false,
1503: p_count => x_msg_count,
1504: p_data => x_msg_data
1505: );

Line 1556: FND_MSG_PUB.initialize;

1552:
1553: AMS_Utility_PVT.debug_message(l_full_name||': initialize');
1554:
1555: IF FND_API.to_boolean(p_init_msg_list) THEN
1556: FND_MSG_PUB.initialize;
1557: END IF;
1558:
1559: IF NOT FND_API.compatible_api_call(
1560: l_api_version,

Line 1598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1594:
1595: IF instr(l_sql_string, 'PARTY_ID') = 0
1596: OR instr(l_sql_string, 'PARTY_ID', 1, 1) > l_from_position
1597: THEN
1598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
1600: FND_MSG_PUB.add;
1601: END IF;
1602: RAISE FND_API.g_exc_error;

Line 1600: FND_MSG_PUB.add;

1596: OR instr(l_sql_string, 'PARTY_ID', 1, 1) > l_from_position
1597: THEN
1598: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1599: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
1600: FND_MSG_PUB.add;
1601: END IF;
1602: RAISE FND_API.g_exc_error;
1603: RETURN;
1604: END IF;

Line 1609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1605:
1606: IF instr(l_sql_string, 'ORDER BY') > 0
1607: OR instr(l_sql_string, 'GROUP BY') > 0
1608: THEN
1609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1610: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
1611: FND_MSG_PUB.add;
1612: END IF;
1613: RAISE FND_API.g_exc_error;

Line 1611: FND_MSG_PUB.add;

1607: OR instr(l_sql_string, 'GROUP BY') > 0
1608: THEN
1609: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1610: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
1611: FND_MSG_PUB.add;
1612: END IF;
1613: RAISE FND_API.g_exc_error;
1614: -- x_return_status := FND_API.g_ret_sts_error;
1615: RETURN;

Line 1652: FND_MSG_PUB.count_and_get(

1648: IF FND_API.to_boolean(p_commit) THEN
1649: COMMIT;
1650: END IF;
1651:
1652: FND_MSG_PUB.count_and_get(
1653: p_encoded => FND_API.g_false,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data
1656: );

Line 1665: FND_MSG_PUB.count_and_get(

1661:
1662: WHEN FND_API.g_exc_error THEN
1663: ROLLBACK TO add_sel_sql;
1664: x_return_status := FND_API.g_ret_sts_error;
1665: FND_MSG_PUB.count_and_get(
1666: p_encoded => FND_API.g_false,
1667: p_count => x_msg_count,
1668: p_data => x_msg_data
1669: );

Line 1674: FND_MSG_PUB.count_and_get(

1670:
1671: WHEN FND_API.g_exc_unexpected_error THEN
1672: ROLLBACK TO add_sel_sql;
1673: x_return_status := FND_API.g_ret_sts_unexp_error ;
1674: FND_MSG_PUB.count_and_get(
1675: p_encoded => FND_API.g_false,
1676: p_count => x_msg_count,
1677: p_data => x_msg_data
1678: );

Line 1685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1681: WHEN OTHERS THEN
1682: ROLLBACK TO add_sel_sql;
1683: x_return_status := FND_API.g_ret_sts_unexp_error ;
1684:
1685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1686: THEN
1687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1688: END IF;
1689:

Line 1687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1683: x_return_status := FND_API.g_ret_sts_unexp_error ;
1684:
1685: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1686: THEN
1687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1688: END IF;
1689:
1690: FND_MSG_PUB.count_and_get(
1691: p_encoded => FND_API.g_false,

Line 1690: FND_MSG_PUB.count_and_get(

1686: THEN
1687: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1688: END IF;
1689:
1690: FND_MSG_PUB.count_and_get(
1691: p_encoded => FND_API.g_false,
1692: p_count => x_msg_count,
1693: p_data => x_msg_data
1694: );

Line 1757: FND_MSG_PUB.initialize;

1753:
1754: AMS_Utility_PVT.debug_message(l_full_name||': start');
1755:
1756: IF FND_API.to_boolean(p_init_msg_list) THEN
1757: FND_MSG_PUB.initialize;
1758: END IF;
1759:
1760: IF NOT FND_API.compatible_api_call(
1761: l_api_version,

Line 1821: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1817:
1818: WHEN NO_DATA_FOUND THEN
1819: x_return_status := FND_API.g_ret_sts_unexp_error ;
1820:
1821: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1822: THEN
1823: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1824: END IF;
1825:

Line 1823: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1819: x_return_status := FND_API.g_ret_sts_unexp_error ;
1820:
1821: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1822: THEN
1823: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1824: END IF;
1825:
1826: FND_MSG_PUB.count_and_get(
1827: p_encoded => FND_API.g_false,

Line 1826: FND_MSG_PUB.count_and_get(

1822: THEN
1823: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1824: END IF;
1825:
1826: FND_MSG_PUB.count_and_get(
1827: p_encoded => FND_API.g_false,
1828: p_count => x_msg_count,
1829: p_data => x_msg_data
1830: );

Line 1834: FND_MSG_PUB.count_and_get(

1830: );
1831:
1832: WHEN FND_API.g_exc_error THEN
1833: x_return_status := FND_API.g_ret_sts_error;
1834: FND_MSG_PUB.count_and_get(
1835: p_encoded => FND_API.g_false,
1836: p_count => x_msg_count,
1837: p_data => x_msg_data
1838: );

Line 1842: FND_MSG_PUB.count_and_get(

1838: );
1839:
1840: WHEN FND_API.g_exc_unexpected_error THEN
1841: x_return_status := FND_API.g_ret_sts_unexp_error ;
1842: FND_MSG_PUB.count_and_get(
1843: p_encoded => FND_API.g_false,
1844: p_count => x_msg_count,
1845: p_data => x_msg_data
1846: );

Line 1901: FND_MSG_PUB.initialize;

1897:
1898: AMS_Utility_PVT.debug_message(l_full_name||': start');
1899:
1900: IF FND_API.to_boolean(p_init_msg_list) THEN
1901: FND_MSG_PUB.initialize;
1902: END IF;
1903:
1904: IF NOT FND_API.compatible_api_call(
1905: l_api_version,

Line 2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2057: AMS_Utility_PVT.debug_message(l_full_name || ': No Data Found error in get composite sql for cell ' || l_cell_id);
2058: AMS_Utility_Pvt.Debug_Message(l_full_name || ': Please check if the workbook or sql statement is valid');
2059: x_return_status := FND_API.g_ret_sts_unexp_error ;
2060:
2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2062: THEN
2063: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2064: END IF;
2065:

Line 2063: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2059: x_return_status := FND_API.g_ret_sts_unexp_error ;
2060:
2061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2062: THEN
2063: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2064: END IF;
2065:
2066: FND_MSG_PUB.count_and_get(
2067: p_encoded => FND_API.g_false,

Line 2066: FND_MSG_PUB.count_and_get(

2062: THEN
2063: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2064: END IF;
2065:
2066: FND_MSG_PUB.count_and_get(
2067: p_encoded => FND_API.g_false,
2068: p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );

Line 2077: FND_MSG_PUB.count_and_get(

2073: AMS_Utility_Pvt.Debug_Message(l_full_name ||': Expected error in get composite sql for cell '||l_cell_id);
2074: AMS_Utility_Pvt.Debug_Message(l_full_name ||': Please check if the workbook or sql statement is valid');
2075:
2076: x_return_status := FND_API.g_ret_sts_error;
2077: FND_MSG_PUB.count_and_get(
2078: p_encoded => FND_API.g_false,
2079: p_count => x_msg_count,
2080: p_data => x_msg_data
2081: );

Line 2087: FND_MSG_PUB.count_and_get(

2083: WHEN FND_API.g_exc_unexpected_error THEN
2084: AMS_Utility_Pvt.Debug_Message(l_full_name || ': Unexpected error in get composite sql for cell ' || l_cell_id);
2085: AMS_Utility_Pvt.Debug_Message(l_full_name || ': Please check if the workbook or sql statement is valid');
2086: x_return_status := FND_API.g_ret_sts_unexp_error ;
2087: FND_MSG_PUB.count_and_get(
2088: p_encoded => FND_API.g_false,
2089: p_count => x_msg_count,
2090: p_data => x_msg_data
2091: );

Line 2097: FND_MSG_PUB.count_and_get(

2093: WHEN OTHERS THEN
2094: AMS_Utility_Pvt.Debug_Message(l_full_name ||': Error in get composite sql for cell ' || l_cell_id);
2095: AMS_Utility_Pvt.Debug_Message(l_full_name ||': Please check if the workbook or sql statement is valid');
2096: x_return_status := FND_API.g_ret_sts_unexp_error ;
2097: FND_MSG_PUB.count_and_get(
2098: p_encoded => FND_API.g_false,
2099: p_count => x_msg_count,
2100: p_data => x_msg_data
2101: );

Line 2254: FND_MSG_PUB.initialize;

2250:
2251: AMS_Utility_PVT.debug_message(l_full_name||': start');
2252:
2253: IF FND_API.to_boolean(p_init_msg_list) THEN
2254: FND_MSG_PUB.initialize;
2255: END IF;
2256:
2257: IF NOT FND_API.compatible_api_call(
2258: l_api_version,

Line 2292: FND_MSG_PUB.count_and_get(

2288:
2289: ------------------------- finish -------------------------------
2290: x_sql_string := l_sql_string;
2291:
2292: FND_MSG_PUB.count_and_get(
2293: p_encoded => FND_API.g_false,
2294: p_count => x_msg_count,
2295: p_data => x_msg_data
2296: );

Line 2305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2301:
2302: WHEN NO_DATA_FOUND THEN
2303: x_return_status := FND_API.g_ret_sts_unexp_error ;
2304:
2305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2306: THEN
2307: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2308: END IF;
2309:

Line 2307: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2303: x_return_status := FND_API.g_ret_sts_unexp_error ;
2304:
2305: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2306: THEN
2307: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2308: END IF;
2309:
2310: FND_MSG_PUB.count_and_get(
2311: p_encoded => FND_API.g_false,

Line 2310: FND_MSG_PUB.count_and_get(

2306: THEN
2307: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2308: END IF;
2309:
2310: FND_MSG_PUB.count_and_get(
2311: p_encoded => FND_API.g_false,
2312: p_count => x_msg_count,
2313: p_data => x_msg_data
2314: );

Line 2318: FND_MSG_PUB.count_and_get(

2314: );
2315:
2316: WHEN FND_API.g_exc_error THEN
2317: x_return_status := FND_API.g_ret_sts_error;
2318: FND_MSG_PUB.count_and_get(
2319: p_encoded => FND_API.g_false,
2320: p_count => x_msg_count,
2321: p_data => x_msg_data
2322: );

Line 2326: FND_MSG_PUB.count_and_get(

2322: );
2323:
2324: WHEN FND_API.g_exc_unexpected_error THEN
2325: x_return_status := FND_API.g_ret_sts_unexp_error ;
2326: FND_MSG_PUB.count_and_get(
2327: p_encoded => FND_API.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data
2330: );

Line 2377: FND_MSG_PUB.initialize;

2373:
2374: AMS_Utility_PVT.debug_message(l_full_name||': start');
2375:
2376: IF FND_API.to_boolean(p_init_msg_list) THEN
2377: FND_MSG_PUB.initialize;
2378: END IF;
2379:
2380: IF NOT FND_API.compatible_api_call(
2381: l_api_version,

Line 2398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2394: l_sql_string := upper(l_sql_string);
2395: IF instr(l_sql_string, 'PARTY_ID') = 0
2396: OR instr(l_sql_string, 'PARTY_ID', 1, 1) > instr(l_sql_string, 'FROM', 1, 1)
2397: THEN
2398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2399: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
2400: FND_MSG_PUB.add;
2401: END IF;
2402: RAISE FND_API.g_exc_error;

Line 2400: FND_MSG_PUB.add;

2396: OR instr(l_sql_string, 'PARTY_ID', 1, 1) > instr(l_sql_string, 'FROM', 1, 1)
2397: THEN
2398: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2399: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
2400: FND_MSG_PUB.add;
2401: END IF;
2402: RAISE FND_API.g_exc_error;
2403: -- x_return_status := FND_API.g_ret_sts_error;
2404: RETURN;

Line 2430: FND_MSG_PUB.count_and_get(

2426: DBMS_SQL.CLOSE_CURSOR(l_party_cur);
2427:
2428: ------------------------- finish -------------------------------
2429:
2430: FND_MSG_PUB.count_and_get(
2431: p_encoded => FND_API.g_false,
2432: p_count => x_msg_count,
2433: p_data => x_msg_data
2434: );

Line 2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2439:
2440: WHEN NO_DATA_FOUND THEN
2441: x_return_status := FND_API.g_ret_sts_unexp_error ;
2442:
2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2444: THEN
2445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2446: END IF;
2447:

Line 2445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2441: x_return_status := FND_API.g_ret_sts_unexp_error ;
2442:
2443: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2444: THEN
2445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2446: END IF;
2447:
2448: FND_MSG_PUB.count_and_get(
2449: p_encoded => FND_API.g_false,

Line 2448: FND_MSG_PUB.count_and_get(

2444: THEN
2445: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2446: END IF;
2447:
2448: FND_MSG_PUB.count_and_get(
2449: p_encoded => FND_API.g_false,
2450: p_count => x_msg_count,
2451: p_data => x_msg_data
2452: );

Line 2456: FND_MSG_PUB.count_and_get(

2452: );
2453:
2454: WHEN FND_API.g_exc_error THEN
2455: x_return_status := FND_API.g_ret_sts_error;
2456: FND_MSG_PUB.count_and_get(
2457: p_encoded => FND_API.g_false,
2458: p_count => x_msg_count,
2459: p_data => x_msg_data
2460: );

Line 2464: FND_MSG_PUB.count_and_get(

2460: );
2461:
2462: WHEN FND_API.g_exc_unexpected_error THEN
2463: x_return_status := FND_API.g_ret_sts_unexp_error ;
2464: FND_MSG_PUB.count_and_get(
2465: p_encoded => FND_API.g_false,
2466: p_count => x_msg_count,
2467: p_data => x_msg_data
2468: );

Line 2473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2469:
2470: WHEN OTHERS THEN
2471: x_return_status := FND_API.g_ret_sts_unexp_error ;
2472:
2473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2474: THEN
2475: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2476: END IF;
2477:

Line 2475: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2471: x_return_status := FND_API.g_ret_sts_unexp_error ;
2472:
2473: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2474: THEN
2475: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2476: END IF;
2477:
2478: FND_MSG_PUB.count_and_get(
2479: p_encoded => FND_API.g_false,

Line 2478: FND_MSG_PUB.count_and_get(

2474: THEN
2475: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2476: END IF;
2477:
2478: FND_MSG_PUB.count_and_get(
2479: p_encoded => FND_API.g_false,
2480: p_count => x_msg_count,
2481: p_data => x_msg_data
2482: );

Line 2538: FND_MSG_PUB.initialize;

2534:
2535: AMS_Utility_PVT.debug_message(l_full_name||': start');
2536:
2537: IF FND_API.to_boolean(p_init_msg_list) THEN
2538: FND_MSG_PUB.initialize;
2539: END IF;
2540:
2541: IF NOT FND_API.compatible_api_call(
2542: l_api_version,

Line 2622: FND_MSG_PUB.count_and_get(

2618: x_segment_size := l_segment_size;
2619:
2620: AMS_Utility_PVT.debug_message(l_full_name ||': x_segment_size:'||x_segment_size);
2621:
2622: FND_MSG_PUB.count_and_get(
2623: p_encoded => FND_API.g_false,
2624: p_count => x_msg_count,
2625: p_data => x_msg_data
2626: );

Line 2637: FND_MSG_PUB.count_and_get(

2633: IF (DBMS_SQL.Is_Open(l_party_cur) = TRUE) THEN
2634: DBMS_SQL.Close_Cursor(l_party_cur) ;
2635: END IF;
2636: x_return_status := FND_API.g_ret_sts_error;
2637: FND_MSG_PUB.count_and_get(
2638: p_encoded => FND_API.g_false,
2639: p_count => x_msg_count,
2640: p_data => x_msg_data
2641: );

Line 2648: FND_MSG_PUB.count_and_get(

2644: IF (DBMS_SQL.Is_Open(l_party_cur) = TRUE) THEN
2645: DBMS_SQL.Close_Cursor(l_party_cur) ;
2646: END IF;
2647: x_return_status := FND_API.g_ret_sts_unexp_error ;
2648: FND_MSG_PUB.count_and_get(
2649: p_encoded => FND_API.g_false,
2650: p_count => x_msg_count,
2651: p_data => x_msg_data
2652: );

Line 2660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2656: DBMS_SQL.Close_Cursor(l_party_cur) ;
2657: END IF;
2658: x_return_status := FND_API.g_ret_sts_unexp_error ;
2659:
2660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2661: THEN
2662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2663: END IF;
2664:

Line 2662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2658: x_return_status := FND_API.g_ret_sts_unexp_error ;
2659:
2660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2661: THEN
2662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2663: END IF;
2664:
2665: FND_MSG_PUB.count_and_get(
2666: p_encoded => FND_API.g_false,

Line 2665: FND_MSG_PUB.count_and_get(

2661: THEN
2662: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2663: END IF;
2664:
2665: FND_MSG_PUB.count_and_get(
2666: p_encoded => FND_API.g_false,
2667: p_count => x_msg_count,
2668: p_data => x_msg_data
2669: );

Line 2711: FND_MSG_PUB.initialize;

2707:
2708: AMS_Utility_PVT.debug_message(l_full_name||': start');
2709:
2710: IF FND_API.to_boolean(p_init_msg_list) THEN
2711: FND_MSG_PUB.initialize;
2712: END IF;
2713:
2714: IF NOT FND_API.compatible_api_call(
2715: l_api_version,

Line 2730: FND_MSG_PUB.add;

2726:
2727: --bmuthukr bug 5130570
2728: if trim(l_sql_cell_rec.list_sql_string) is null AND l_sql_cell_rec.sel_type = 'SQL' then
2729: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BLANK_SQL');
2730: FND_MSG_PUB.add;
2731: RAISE FND_API.g_exc_error;
2732: end if;
2733: --
2734:

Line 2824: FND_MSG_PUB.count_and_get(

2820: IF FND_API.to_boolean(p_commit) THEN
2821: COMMIT;
2822: END IF;
2823:
2824: FND_MSG_PUB.count_and_get(
2825: p_encoded => FND_API.g_false,
2826: p_count => x_msg_count,
2827: p_data => x_msg_data
2828: );

Line 2837: FND_MSG_PUB.count_and_get(

2833:
2834: WHEN FND_API.g_exc_error THEN
2835: ROLLBACK TO create_sql_cell;
2836: x_return_status := FND_API.g_ret_sts_error;
2837: FND_MSG_PUB.count_and_get(
2838: p_encoded => FND_API.g_false,
2839: p_count => x_msg_count,
2840: p_data => x_msg_data
2841: );

Line 2845: FND_MSG_PUB.count_and_get(

2841: );
2842: WHEN FND_API.g_exc_unexpected_error THEN
2843: ROLLBACK TO create_sql_cell;
2844: x_return_status := FND_API.g_ret_sts_unexp_error ;
2845: FND_MSG_PUB.count_and_get(
2846: p_encoded => FND_API.g_false,
2847: p_count => x_msg_count,
2848: p_data => x_msg_data
2849: );

Line 2855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2851: WHEN OTHERS THEN
2852: ROLLBACK TO create_sql_cell;
2853: x_return_status := FND_API.g_ret_sts_unexp_error ;
2854:
2855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2856: THEN
2857: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2858: END IF;
2859:

Line 2857: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2853: x_return_status := FND_API.g_ret_sts_unexp_error ;
2854:
2855: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2856: THEN
2857: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2858: END IF;
2859:
2860: FND_MSG_PUB.count_and_get(
2861: p_encoded => FND_API.g_false,

Line 2860: FND_MSG_PUB.count_and_get(

2856: THEN
2857: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2858: END IF;
2859:
2860: FND_MSG_PUB.count_and_get(
2861: p_encoded => FND_API.g_false,
2862: p_count => x_msg_count,
2863: p_data => x_msg_data
2864: );

Line 2930: FND_MSG_PUB.initialize;

2926:
2927: AMS_Utility_PVT.debug_message(l_full_name||': start');
2928:
2929: IF FND_API.to_boolean(p_init_msg_list) THEN
2930: FND_MSG_PUB.initialize;
2931: END IF;
2932:
2933: IF NOT FND_API.compatible_api_call(
2934: l_api_version,

Line 2949: FND_MSG_PUB.add;

2945:
2946: --bmuthukr bug 5130570
2947: if trim(l_sql_cell_rec.list_sql_string) is null then
2948: FND_MESSAGE.set_name('AMS', 'AMS_CELL_BLANK_SQL');
2949: FND_MSG_PUB.add;
2950: RAISE FND_API.g_exc_error;
2951: end if;
2952: --
2953:

Line 3001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

2997: OPEN c_cell;
2998: FETCH c_cell INTO l_sql_cell_rec_old;
2999: IF c_cell%NOTFOUND THEN
3000: CLOSE c_cell;
3001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3002: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3003: FND_MSG_PUB.add;
3004: END IF;
3005: RAISE FND_API.g_exc_error;

Line 3003: FND_MSG_PUB.add;

2999: IF c_cell%NOTFOUND THEN
3000: CLOSE c_cell;
3001: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3002: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3003: FND_MSG_PUB.add;
3004: END IF;
3005: RAISE FND_API.g_exc_error;
3006: END IF;
3007: CLOSE c_cell;

Line 3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3014: WHERE act_discoverer_used_by_id = l_sql_cell_rec.cell_id
3015: AND arc_act_discoverer_used_by = 'CELL';
3016:
3017: IF (SQL%NOTFOUND) THEN
3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3019: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3020: FND_MSG_PUB.add;
3021: END IF;
3022: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');

Line 3020: FND_MSG_PUB.add;

3016:
3017: IF (SQL%NOTFOUND) THEN
3018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3019: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3020: FND_MSG_PUB.add;
3021: END IF;
3022: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');
3023: RAISE FND_API.g_exc_error;
3024: END IF;

Line 3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3048: WHERE act_discoverer_used_by_id = l_sql_cell_rec.cell_id
3049: AND arc_act_discoverer_used_by = 'CELL';
3050:
3051: IF (SQL%NOTFOUND) THEN
3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3053: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3054: FND_MSG_PUB.add;
3055: END IF;
3056: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');

Line 3054: FND_MSG_PUB.add;

3050:
3051: IF (SQL%NOTFOUND) THEN
3052: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3053: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
3054: FND_MSG_PUB.add;
3055: END IF;
3056: AMS_Utility_PVT.debug_message(l_full_name ||': delete from ams_act_discoverer_all');
3057: RAISE FND_API.g_exc_error;
3058: END IF;

Line 3099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3095: IF instr(l_sql_string, 'PARTY_ID') = 0
3096: OR l_from_position = 0
3097: OR instr(l_sql_string, 'PARTY_ID') > l_from_position
3098: THEN
3099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3100: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
3101: FND_MSG_PUB.add;
3102: END IF;
3103: RAISE FND_API.g_exc_error;

Line 3101: FND_MSG_PUB.add;

3097: OR instr(l_sql_string, 'PARTY_ID') > l_from_position
3098: THEN
3099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3100: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_SQL');
3101: FND_MSG_PUB.add;
3102: END IF;
3103: RAISE FND_API.g_exc_error;
3104: RETURN;
3105: END IF;

Line 3110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

3106:
3107: IF instr(l_sql_string, 'ORDER BY') > 0
3108: OR instr(l_sql_string, 'GROUP BY') > 0
3109: THEN
3110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3111: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
3112: FND_MSG_PUB.add;
3113: END IF;
3114: RAISE FND_API.g_exc_error;

Line 3112: FND_MSG_PUB.add;

3108: OR instr(l_sql_string, 'GROUP BY') > 0
3109: THEN
3110: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
3111: FND_MESSAGE.set_name('AMS', 'AMS_CELL_INVALID_ORDERBY');
3112: FND_MSG_PUB.add;
3113: END IF;
3114: RAISE FND_API.g_exc_error;
3115: -- x_return_status := FND_API.g_ret_sts_error;
3116: RETURN;

Line 3154: FND_MSG_PUB.count_and_get(

3150: IF FND_API.to_boolean(p_commit) THEN
3151: COMMIT;
3152: END IF;
3153:
3154: FND_MSG_PUB.count_and_get(
3155: p_encoded => FND_API.g_false,
3156: p_count => x_msg_count,
3157: p_data => x_msg_data
3158: );

Line 3167: FND_MSG_PUB.count_and_get(

3163:
3164: WHEN FND_API.g_exc_error THEN
3165: ROLLBACK TO update_sql_cell;
3166: x_return_status := FND_API.g_ret_sts_error;
3167: FND_MSG_PUB.count_and_get(
3168: p_encoded => FND_API.g_false,
3169: p_count => x_msg_count,
3170: p_data => x_msg_data
3171: );

Line 3175: FND_MSG_PUB.count_and_get(

3171: );
3172: WHEN FND_API.g_exc_unexpected_error THEN
3173: ROLLBACK TO update_sql_cell;
3174: x_return_status := FND_API.g_ret_sts_unexp_error ;
3175: FND_MSG_PUB.count_and_get(
3176: p_encoded => FND_API.g_false,
3177: p_count => x_msg_count,
3178: p_data => x_msg_data
3179: );

Line 3185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

3181: WHEN OTHERS THEN
3182: ROLLBACK TO update_sql_cell;
3183: x_return_status := FND_API.g_ret_sts_unexp_error ;
3184:
3185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3186: THEN
3187: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3188: END IF;
3189:

Line 3187: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3183: x_return_status := FND_API.g_ret_sts_unexp_error ;
3184:
3185: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3186: THEN
3187: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3188: END IF;
3189:
3190: FND_MSG_PUB.count_and_get(
3191: p_encoded => FND_API.g_false,

Line 3190: FND_MSG_PUB.count_and_get(

3186: THEN
3187: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3188: END IF;
3189:
3190: FND_MSG_PUB.count_and_get(
3191: p_encoded => FND_API.g_false,
3192: p_count => x_msg_count,
3193: p_data => x_msg_data
3194: );

Line 3314: FND_MSG_PUB.count_and_get(

3310: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3311: t_segment_size(l_iterator) := l_segment_size;
3312: ELSE
3313: t_segment_size(l_iterator) := null;
3314: FND_MSG_PUB.count_and_get(
3315: p_encoded => FND_API.g_false,
3316: p_count => x_msg_count,
3317: p_data => x_msg_data
3318: );

Line 3344: FND_MSG_PUB.count_and_get(

3340: close c_all_cell_rec ;
3341: END IF;
3342: ROLLBACK TO Update_Segment_Size;
3343: x_return_status := FND_API.g_ret_sts_error;
3344: FND_MSG_PUB.count_and_get(
3345: p_encoded => FND_API.g_false,
3346: p_count => x_msg_count,
3347: p_data => x_msg_data
3348: );

Line 3355: FND_MSG_PUB.count_and_get (

3351: close c_all_cell_rec ;
3352: END IF;
3353: ROLLBACK TO Update_Segment_Size;
3354: x_return_status := FND_API.g_ret_sts_unexp_error ;
3355: FND_MSG_PUB.count_and_get (
3356: p_encoded => FND_API.g_false,
3357: p_count => x_msg_count,
3358: p_data => x_msg_data
3359: );

Line 3367: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

3363: END IF;
3364: ROLLBACK TO Update_Segment_Size;
3365: x_return_status := FND_API.g_ret_sts_unexp_error ;
3366:
3367: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3368: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3369: END IF;
3370:
3371: FND_MSG_PUB.count_and_get (

Line 3368: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);

3364: ROLLBACK TO Update_Segment_Size;
3365: x_return_status := FND_API.g_ret_sts_unexp_error ;
3366:
3367: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3368: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3369: END IF;
3370:
3371: FND_MSG_PUB.count_and_get (
3372: p_encoded => FND_API.g_false,

Line 3371: FND_MSG_PUB.count_and_get (

3367: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
3368: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
3369: END IF;
3370:
3371: FND_MSG_PUB.count_and_get (
3372: p_encoded => FND_API.g_false,
3373: p_count => x_msg_count,
3374: p_data => x_msg_data
3375: );

Line 3404: -- FND_MSG_PUB.initialize;

3400: -- l_return_status VARCHAR2(1) ;
3401: -- l_msg_count NUMBER ;
3402: -- l_msg_data VARCHAR2(2000);
3403: --BEGIN
3404: -- FND_MSG_PUB.initialize;
3405: -- -- Call the procedure to refresh Segment size
3406: -- Update_Segment_Size
3407: -- ( p_cell_id => p_cell_id,
3408: -- x_return_status => l_return_status,