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 668: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 677: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 687: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 698: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 710: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 723: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 734: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 746: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 759: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 782: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 814: x_msg_count := FND_MSG_PUB.count_msg;

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

Line 827: x_msg_count := FND_MSG_PUB.count_msg;

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

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

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

Line 947: x_msg_count := FND_MSG_PUB.count_msg;

943: p_project_id IS NULL OR
944: p_task_ver_id IS NULL
945: THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: x_msg_count := FND_MSG_PUB.count_msg;
948: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
949: ,p_msg_name => 'PA_PS_PARAMS_NULL');
950: raise FND_API.G_EXC_ERROR;
951: END IF;

Line 957: x_msg_count := FND_MSG_PUB.count_msg;

953: --check for inter projects. The successor project and predecssor projects should be different.
954: IF p_pre_project_id = p_project_id
955: THEN
956: x_return_status := FND_API.G_RET_STS_ERROR;
957: x_msg_count := FND_MSG_PUB.count_msg;
958: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
959: ,p_msg_name => 'PA_PS_NOT_INTER_DEPND');
960: raise FND_API.G_EXC_ERROR;
961: END IF;

Line 977: x_msg_count := FND_MSG_PUB.count_msg;

973:
974: if (l_link_exists = 'Y') then
975:
976: x_return_status := FND_API.G_RET_STS_ERROR;
977: x_msg_count := FND_MSG_PUB.count_msg;
978:
979: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA'
980: , p_msg_name => 'PA_WP_PRGM_EXISTS_NO_DEP');
981:

Line 998: x_msg_count := FND_MSG_PUB.count_msg;

994: FETCH cur_valid_sucsr_proj_task INTO l_dummy;
995: IF cur_valid_sucsr_proj_task%NOTFOUND
996: THEN
997: x_return_status := FND_API.G_RET_STS_ERROR;
998: x_msg_count := FND_MSG_PUB.count_msg;
999: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1000: ,p_msg_name => 'PA_PS_INV_SUCSR_PRJ_TSK');
1001: raise FND_API.G_EXC_ERROR;
1002: END IF;

Line 1011: x_msg_count := FND_MSG_PUB.count_msg;

1007: FETCH cur_valid_pred_proj_task INTO l_dummy;
1008: IF cur_valid_pred_proj_task%NOTFOUND
1009: THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR;
1011: x_msg_count := FND_MSG_PUB.count_msg;
1012: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1013: ,p_msg_name => 'PA_PS_INV_PRED_PRJ_TSK');
1014: raise FND_API.G_EXC_ERROR;
1015: END IF;

Line 1025: x_msg_count := FND_MSG_PUB.count_msg;

1021: FETCH cur_a INTO l_dummy_char;
1022: IF cur_a%FOUND
1023: THEN
1024: x_return_status := FND_API.G_RET_STS_ERROR;
1025: x_msg_count := FND_MSG_PUB.count_msg;
1026: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
1027: ,p_msg_name => 'PA_PS_DEPND_EXISTS');
1028: raise FND_API.G_EXC_ERROR;
1029: END IF;

Line 1035: x_msg_count := FND_MSG_PUB.count_msg;

1031:
1032: EXCEPTION
1033: when FND_API.G_EXC_ERROR then
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: x_msg_count := FND_MSG_PUB.count_msg;
1036: when OTHERS then
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038: x_msg_count := 1; -- 4537865 : RESET OUT param
1039: x_msg_data := SUBSTRB(SQLERRM,1,240); -- 4537865 : RESET OUT PARAM

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

1036: when OTHERS then
1037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1038: x_msg_count := 1; -- 4537865 : RESET OUT param
1039: x_msg_data := SUBSTRB(SQLERRM,1,240); -- 4537865 : RESET OUT PARAM
1040: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_RELATIONSHIOP_UTILS',
1041: p_procedure_name => 'check_create_inter_dep_ok',
1042: p_error_text => x_msg_data); -- 4537865
1043: raise;
1044: