APPS.PA_COPY_CHANGE_DOC_PVT dependencies on FND_MSG_PUB

Line 442: FND_MSG_PUB.Count_And_Get

438: EXCEPTION
439: WHEN G_EXCEPTION_ERROR THEN
440: ROLLBACK TO copy_change_doc;
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: FND_MSG_PUB.Count_And_Get
443: (p_count => x_msg_count,
444: p_data => x_msg_data);
445: RAISE;
446:

Line 450: FND_MSG_PUB.Count_And_Get

446:
447: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
448: ROLLBACK TO copy_change_doc;
449: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
450: FND_MSG_PUB.Count_And_Get
451: (p_count => x_msg_count,
452: p_data => x_msg_data);
453: RAISE;
454:

Line 458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',

454:
455: WHEN OTHERS THEN
456: --ROLLBACK TO copy_change_doc;
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
459: p_procedure_name => 'COPY_CONTROL_ITEM',
460: p_error_text => SUBSTRB(SQLERRM,1,240));
461:
462: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 462: fnd_msg_pub.count_and_get(p_count => x_msg_count,

458: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
459: p_procedure_name => 'COPY_CONTROL_ITEM',
460: p_error_text => SUBSTRB(SQLERRM,1,240));
461:
462: fnd_msg_pub.count_and_get(p_count => x_msg_count,
463: p_data => x_msg_data);
464: RAISE;
465:
466:

Line 524: fnd_msg_pub.initialize;

520: SAVEPOINT copy_change_doc;
521: --END IF;
522:
523: IF p_init_msg_list = FND_API.g_true THEN
524: fnd_msg_pub.initialize;
525: END IF;
526:
527: open c_ci_approved;
528: fetch c_ci_approved into l_sts_yn;

Line 584: FND_MSG_PUB.Count_And_Get

580: EXCEPTION
581: WHEN G_EXCEPTION_ERROR THEN
582: ROLLBACK TO copy_change_doc;
583: x_return_status := FND_API.G_RET_STS_ERROR;
584: FND_MSG_PUB.Count_And_Get
585: (p_count => x_msg_count,
586: p_data => x_msg_data);
587:
588:

Line 592: FND_MSG_PUB.Count_And_Get

588:
589: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
590: ROLLBACK TO copy_change_doc;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get
593: (p_count => x_msg_count,
594: p_data => x_msg_data);
595:
596:

Line 603: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',

599: ROLLBACK TO copy_change_doc;
600: --END IF;
601:
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
604: p_procedure_name => 'copy_change_doc',
605: p_error_text => SUBSTRB(SQLERRM,1,240));
606:
607: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 607: fnd_msg_pub.count_and_get(p_count => x_msg_count,

603: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
604: p_procedure_name => 'copy_change_doc',
605: p_error_text => SUBSTRB(SQLERRM,1,240));
606:
607: fnd_msg_pub.count_and_get(p_count => x_msg_count,
608: p_data => x_msg_data);
609:
610: END copy_change_doc;
611:

Line 693: fnd_msg_pub.initialize;

689: SAVEPOINT copy_change_doc;
690: -- END IF;
691:
692: IF p_init_msg_list = FND_API.g_true THEN
693: fnd_msg_pub.initialize;
694: END IF;
695:
696: -- throw error for approved change docs
697:

Line 804: FND_MSG_PUB.Count_And_Get

800: EXCEPTION
801: WHEN G_EXCEPTION_ERROR THEN
802: ROLLBACK TO copy_change_doc;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get
805: (p_count => x_msg_count,
806: p_data => x_msg_data);
807:
808:

Line 812: FND_MSG_PUB.Count_And_Get

808:
809: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
810: ROLLBACK TO copy_change_doc;
811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
812: FND_MSG_PUB.Count_And_Get
813: (p_count => x_msg_count,
814: p_data => x_msg_data);
815:
816:

Line 823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',

819: ROLLBACK TO copy_change_doc;
820: --END IF;
821:
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
824: p_procedure_name => 'copy_change_doc',
825: p_error_text => SUBSTRB(SQLERRM,1,240));
826:
827: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 827: fnd_msg_pub.count_and_get(p_count => x_msg_count,

823: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
824: p_procedure_name => 'copy_change_doc',
825: p_error_text => SUBSTRB(SQLERRM,1,240));
826:
827: fnd_msg_pub.count_and_get(p_count => x_msg_count,
828: p_data => x_msg_data);
829:
830: END copy_change_doc;
831: procedure update_comments(

Line 860: fnd_msg_pub.initialize;

856: SAVEPOINT update_comments;
857: --END IF;
858:
859: IF p_init_msg_list = FND_API.g_true THEN
860: fnd_msg_pub.initialize;
861: END IF;
862:
863: IF( p_ci_id is null) THEN
864: PA_UTILS.Add_Message( p_app_short_name => 'PA'

Line 888: FND_MSG_PUB.Count_And_Get

884: EXCEPTION
885: WHEN G_EXCEPTION_ERROR THEN
886: ROLLBACK TO update_comments;
887: x_return_status := FND_API.G_RET_STS_ERROR;
888: FND_MSG_PUB.Count_And_Get
889: (p_count => x_msg_count,
890: p_data => x_msg_data);
891:
892:

Line 896: FND_MSG_PUB.Count_And_Get

892:
893: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
894: ROLLBACK TO update_comments;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: FND_MSG_PUB.Count_And_Get
897: (p_count => x_msg_count,
898: p_data => x_msg_data);
899:
900:

Line 907: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',

903: ROLLBACK TO update_comments;
904: --END IF;
905:
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
908: p_procedure_name => 'update_comments',
909: p_error_text => SUBSTRB(SQLERRM,1,240));
910:
911: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 911: fnd_msg_pub.count_and_get(p_count => x_msg_count,

907: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_COPY_CHANGE_DOC_PVT',
908: p_procedure_name => 'update_comments',
909: p_error_text => SUBSTRB(SQLERRM,1,240));
910:
911: fnd_msg_pub.count_and_get(p_count => x_msg_count,
912: p_data => x_msg_data);
913:
914: END update_comments;
915: