DBA Data[Home] [Help]

APPS.PA_RELATIONSHIP_UTILS dependencies on FND_MSG_PUB

Line 437: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_UTILS',

433: WHEN OTHERS THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
435: x_error_message_code := SQLCODE ;
436:
437: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIP_UTILS',
438: p_procedure_name => 'CHECK_CREATE_LINK_OK',
439: p_error_text => SUBSTRB(SQLERRM,1,240));
440: RAISE;
441: END CHECK_CREATE_LINK_OK;

Line 670: x_msg_count := FND_MSG_PUB.count_msg;

666: p_project_id IS NULL OR
667: p_task_ver_id IS NULL
668: THEN
669: x_return_status := FND_API.G_RET_STS_ERROR;
670: x_msg_count := FND_MSG_PUB.count_msg;
671: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
672: ,p_msg_name => 'PA_PS_PARAMS_NULL');
673: raise FND_API.G_EXC_ERROR;
674: END IF;

Line 679: x_msg_count := FND_MSG_PUB.count_msg;

675:
676: IF p_pre_project_id <> p_project_id
677: THEN
678: x_return_status := FND_API.G_RET_STS_ERROR;
679: x_msg_count := FND_MSG_PUB.count_msg;
680: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
681: ,p_msg_name => 'PA_PS_NOT_INTRA_DEPND');
682: raise FND_API.G_EXC_ERROR;
683: END IF;

Line 689: x_msg_count := FND_MSG_PUB.count_msg;

685: --c) a task cannot depend on it-self
686: IF p_pre_task_ver_id = p_task_ver_id
687: THEN
688: x_return_status := FND_API.G_RET_STS_ERROR;
689: x_msg_count := FND_MSG_PUB.count_msg;
690: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
691: ,p_msg_name => 'PA_PS_NO_SELF_DEPDN');
692: raise FND_API.G_EXC_ERROR;
693: END IF;

Line 700: x_msg_count := FND_MSG_PUB.count_msg;

696: FETCH cur_a INTO l_dummy_char;
697: IF cur_a%FOUND
698: THEN
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: x_msg_count := FND_MSG_PUB.count_msg;
701: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
702: ,p_msg_name => 'PA_PS_DEPND_EXISTS');
703: raise FND_API.G_EXC_ERROR;
704: END IF;

Line 712: x_msg_count := FND_MSG_PUB.count_msg;

708: FETCH cur_b INTO l_dummy_char;
709: IF cur_b%FOUND
710: THEN
711: x_return_status := FND_API.G_RET_STS_ERROR;
712: x_msg_count := FND_MSG_PUB.count_msg;
713: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
714: ,p_msg_name => 'PA_PS_CIRCLR_DEPND_EXISTS');
715: raise FND_API.G_EXC_ERROR;
716: END IF;

Line 725: x_msg_count := FND_MSG_PUB.count_msg;

721: FETCH cur_d INTO l_dummy_char;
722: IF cur_d%FOUND
723: THEN
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: x_msg_count := FND_MSG_PUB.count_msg;
726: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
727: ,p_msg_name => 'PA_PS_SUBTASKS_DEPND_EXISTS');
728: raise FND_API.G_EXC_ERROR;
729: END IF;

Line 736: x_msg_count := FND_MSG_PUB.count_msg;

732: --Bug 3629024 : Check for the existence of a closed path
733: --This bug fix is for rule D
734: IF get_parents_childs(p_pre_task_ver_id, p_task_ver_id) = TRUE THEN
735: x_return_status := FND_API.G_RET_STS_ERROR;
736: x_msg_count := FND_MSG_PUB.count_msg;
737: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
738: ,p_msg_name => 'PA_PS_SUBTASKS_DEPND_EXISTS');
739: raise FND_API.G_EXC_ERROR;
740: END IF;

Line 748: x_msg_count := FND_MSG_PUB.count_msg;

744: FETCH cur_e1 INTO l_dummy_char;
745: IF cur_e1%FOUND
746: THEN
747: x_return_status := FND_API.G_RET_STS_ERROR;
748: x_msg_count := FND_MSG_PUB.count_msg;
749: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
750: ,p_msg_name => 'PA_PS_NO_PARENT_PRED');
751: raise FND_API.G_EXC_ERROR;
752: END IF;

Line 761: x_msg_count := FND_MSG_PUB.count_msg;

757: FETCH cur_e2 INTO l_dummy_char;
758: IF cur_e2%FOUND
759: THEN
760: x_return_status := FND_API.G_RET_STS_ERROR;
761: x_msg_count := FND_MSG_PUB.count_msg;
762: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
763: ,p_msg_name => 'PA_PS_NO_CHILD_PRED');
764: raise FND_API.G_EXC_ERROR;
765: END IF;

Line 784: x_msg_count := FND_MSG_PUB.count_msg;

780: IF l_parent_task_ver_id IS NOT NULL AND
781: l_parent_task_ver_id = p_pre_task_ver_id
782: THEN
783: x_return_status := FND_API.G_RET_STS_ERROR;
784: x_msg_count := FND_MSG_PUB.count_msg;
785: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
786: ,p_msg_name => 'PA_PS_NO_PARENT_PRED');
787: raise FND_API.G_EXC_ERROR;
788: ELSE

Line 816: x_msg_count := FND_MSG_PUB.count_msg;

812: IF l_parent_task_ver_id IS NOT NULL AND
813: l_parent_task_ver_id = p_task_ver_id /* is succssor a parent in the same line of hierarcgy*/
814: THEN
815: x_return_status := FND_API.G_RET_STS_ERROR;
816: x_msg_count := FND_MSG_PUB.count_msg;
817: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
818: ,p_msg_name => 'PA_PS_NO_CHILD_PRED');
819: raise FND_API.G_EXC_ERROR;
820: ELSE

Line 829: x_msg_count := FND_MSG_PUB.count_msg;

825:
826: EXCEPTION
827: when FND_API.G_EXC_ERROR then
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: x_msg_count := FND_MSG_PUB.count_msg;
830: when OTHERS then
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: x_msg_count := 1; -- 4537865 : RESET OUT param
833: x_msg_data := SUBSTRB(SQLERRM,1,240); -- 4537865 : RESET OUT PARAM

Line 834: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_UTILS',

830: when OTHERS then
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: x_msg_count := 1; -- 4537865 : RESET OUT param
833: x_msg_data := SUBSTRB(SQLERRM,1,240); -- 4537865 : RESET OUT PARAM
834: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_UTILS',
835: p_procedure_name => 'check_create_intra_dep_ok',
836: p_error_text => x_msg_data ); -- 4537865
837: raise;
838:

Line 954: x_msg_count := FND_MSG_PUB.count_msg;

950: p_project_id IS NULL OR
951: p_task_ver_id IS NULL
952: THEN
953: x_return_status := FND_API.G_RET_STS_ERROR;
954: x_msg_count := FND_MSG_PUB.count_msg;
955: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
956: ,p_msg_name => 'PA_PS_PARAMS_NULL');
957: raise FND_API.G_EXC_ERROR;
958: END IF;

Line 964: x_msg_count := FND_MSG_PUB.count_msg;

960: --check for inter projects. The successor project and predecssor projects should be different.
961: IF p_pre_project_id = p_project_id
962: THEN
963: x_return_status := FND_API.G_RET_STS_ERROR;
964: x_msg_count := FND_MSG_PUB.count_msg;
965: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
966: ,p_msg_name => 'PA_PS_NOT_INTER_DEPND');
967: raise FND_API.G_EXC_ERROR;
968: END IF;

Line 984: x_msg_count := FND_MSG_PUB.count_msg;

980:
981: if (l_link_exists = 'Y') then
982:
983: x_return_status := FND_API.G_RET_STS_ERROR;
984: x_msg_count := FND_MSG_PUB.count_msg;
985:
986: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
987: , p_msg_name => 'PA_WP_PRGM_EXISTS_NO_DEP');
988:

Line 1005: x_msg_count := FND_MSG_PUB.count_msg;

1001: FETCH cur_valid_sucsr_proj_task INTO l_dummy;
1002: IF cur_valid_sucsr_proj_task%NOTFOUND
1003: THEN
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: x_msg_count := FND_MSG_PUB.count_msg;
1006: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1007: ,p_msg_name => 'PA_PS_INV_SUCSR_PRJ_TSK');
1008: raise FND_API.G_EXC_ERROR;
1009: END IF;

Line 1018: x_msg_count := FND_MSG_PUB.count_msg;

1014: FETCH cur_valid_pred_proj_task INTO l_dummy;
1015: IF cur_valid_pred_proj_task%NOTFOUND
1016: THEN
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: x_msg_count := FND_MSG_PUB.count_msg;
1019: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1020: ,p_msg_name => 'PA_PS_INV_PRED_PRJ_TSK');
1021: raise FND_API.G_EXC_ERROR;
1022: END IF;

Line 1032: x_msg_count := FND_MSG_PUB.count_msg;

1028: FETCH cur_a INTO l_dummy_char;
1029: IF cur_a%FOUND
1030: THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: x_msg_count := FND_MSG_PUB.count_msg;
1033: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1034: ,p_msg_name => 'PA_PS_DEPND_EXISTS');
1035: raise FND_API.G_EXC_ERROR;
1036: END IF;

Line 1042: x_msg_count := FND_MSG_PUB.count_msg;

1038:
1039: EXCEPTION
1040: when FND_API.G_EXC_ERROR then
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: x_msg_count := FND_MSG_PUB.count_msg;
1043: when OTHERS then
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: x_msg_count := 1; -- 4537865 : RESET OUT param
1046: x_msg_data := SUBSTRB(SQLERRM,1,240); -- 4537865 : RESET OUT PARAM

Line 1047: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_UTILS',

1043: when OTHERS then
1044: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1045: x_msg_count := 1; -- 4537865 : RESET OUT param
1046: x_msg_data := SUBSTRB(SQLERRM,1,240); -- 4537865 : RESET OUT PARAM
1047: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_UTILS',
1048: p_procedure_name => 'check_create_inter_dep_ok',
1049: p_error_text => x_msg_data); -- 4537865
1050: raise;
1051: