DBA Data[Home] [Help]

APPS.PA_XC_PROJECT_PUB dependencies on FND_MESSAGE

Line 725: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_STRUCT_VER');

721: FETCH l_check_proj_struct_ver_id_csr INTO l_validate_flag;
722: if l_check_proj_struct_ver_id_csr%NOTFOUND then
723: x_msg_count := x_msg_count + 1;
724: x_msg_data.extend(1);
725: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_STRUCT_VER');
726: x_return_status := 'E';
727: -- dbms_output.put_line('IMP_PROJECT: Raising ERROR PA_INVLD_PROJ_STRUCT_VER');
728: raise API_ERROR;
729: end if;

Line 738: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_STRUCT_PR');

734: FETCH l_check_proj_struct_id_csr INTO l_validate_flag;
735: if l_check_proj_struct_id_csr%NOTFOUND then
736: x_msg_count := x_msg_count + 1;
737: x_msg_data.extend(1);
738: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_STRUCT_PR');
739: x_return_status := 'E';
740: -- dbms_output.put_line('IMP_PROJECT: Raising ERROR PA_INVLD_PROJ_STRUCT_PR');
741: raise API_ERROR;
742: end if;

Line 752: -- fnd_message.set_name('PA', 'PA_INVLD_PROJ_VER_PR');

748: if (p_structure_version_id is not NULL and p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM and p_structure_version_id <>0) then
749: OPEN l_check_proj_ver_id_csr (p_project_id, p_structure_version_id);
750: FETCH l_check_proj_ver_id_csr INTO l_validate_flag;
751: if l_check_proj_ver_id_csr%NOTFOUND then
752: -- fnd_message.set_name('PA', 'PA_INVLD_PROJ_VER_PR');
753: x_msg_count := x_msg_count + 1;
754: x_msg_data.extend(1);
755: -- fnd_msg_pub.add;
756: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_VER_PR');

Line 756: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_VER_PR');

752: -- fnd_message.set_name('PA', 'PA_INVLD_PROJ_VER_PR');
753: x_msg_count := x_msg_count + 1;
754: x_msg_data.extend(1);
755: -- fnd_msg_pub.add;
756: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_VER_PR');
757: -- x_msg_data(x_msg_count) := fnd_message.get;
758: x_return_status := 'E';
759: raise API_ERROR;
760: end if;

Line 757: -- x_msg_data(x_msg_count) := fnd_message.get;

753: x_msg_count := x_msg_count + 1;
754: x_msg_data.extend(1);
755: -- fnd_msg_pub.add;
756: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVLD_PROJ_VER_PR');
757: -- x_msg_data(x_msg_count) := fnd_message.get;
758: x_return_status := 'E';
759: raise API_ERROR;
760: end if;
761: CLOSE l_check_proj_ver_id_csr;

Line 774: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_ID');

770: FETCH l_get_structure_count_csr INTO l_struct_count;
771:
772: if l_struct_count <> 1 then
773: CLOSE l_get_structure_count_csr;
774: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_ID');
775: x_msg_count := x_msg_count + 1;
776: x_msg_data.extend(1);
777: -- fnd_msg_pub.add;
778: -- x_msg_data(x_msg_count) := fnd_message.get;

Line 778: -- x_msg_data(x_msg_count) := fnd_message.get;

774: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_ID');
775: x_msg_count := x_msg_count + 1;
776: x_msg_data.extend(1);
777: -- fnd_msg_pub.add;
778: -- x_msg_data(x_msg_count) := fnd_message.get;
779: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_ID');
780: x_return_status := 'E';
781: raise API_ERROR;
782: else

Line 779: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_ID');

775: x_msg_count := x_msg_count + 1;
776: x_msg_data.extend(1);
777: -- fnd_msg_pub.add;
778: -- x_msg_data(x_msg_count) := fnd_message.get;
779: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_ID');
780: x_return_status := 'E';
781: raise API_ERROR;
782: else
783: OPEN l_get_structure_id_csr(p_project_id);

Line 812: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_PS_WP_VERSION_NOT_EXIST');

808: -- bug fix 2358590: If it does not exist throw an error
809: if l_get_working_version_csr%NOTFOUND then
810: x_msg_count := x_msg_count + 1;
811: x_msg_data.extend(1);
812: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_PS_WP_VERSION_NOT_EXIST');
813: x_return_status := 'E';
814: raise API_ERROR;
815: end if;
816: CLOSE l_get_working_version_csr;

Line 822: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');

818: OPEN l_get_working_version_csr(l_structure_id);
819: FETCH l_get_working_version_csr INTO l_structure_version_id;
820: CLOSE l_get_working_version_csr;
821: elsif l_workplan_purpose = 'Y' then
822: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
823: x_msg_count := x_msg_count + 1;
824: x_msg_data.extend(1);
825: -- fnd_msg_pub.add;
826: -- x_msg_data(x_msg_count) := fnd_message.get;

Line 826: -- x_msg_data(x_msg_count) := fnd_message.get;

822: -- fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
823: x_msg_count := x_msg_count + 1;
824: x_msg_data.extend(1);
825: -- fnd_msg_pub.add;
826: -- x_msg_data(x_msg_count) := fnd_message.get;
827: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
828: x_return_status := 'E';
829: raise API_ERROR;
830: end if;

Line 827: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');

823: x_msg_count := x_msg_count + 1;
824: x_msg_data.extend(1);
825: -- fnd_msg_pub.add;
826: -- x_msg_data(x_msg_count) := fnd_message.get;
827: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
828: x_return_status := 'E';
829: raise API_ERROR;
830: end if;
831: */

Line 841: -- hyau fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');

837: else
838: OPEN l_get_struct_id_csr (l_structure_version_id);
839: FETCH l_get_struct_id_csr INTO l_structure_id;
840: if l_get_struct_id_csr%NOTFOUND then
841: -- hyau fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
842: x_msg_count := x_msg_count + 1;
843: x_msg_data.extend(1);
844: -- hyau fnd_msg_pub.add;
845: -- hyau x_msg_data(x_msg_count) := fnd_message.get;

Line 845: -- hyau x_msg_data(x_msg_count) := fnd_message.get;

841: -- hyau fnd_message.set_name('PA', 'PA_NO_STRUCTURE_VER_ID');
842: x_msg_count := x_msg_count + 1;
843: x_msg_data.extend(1);
844: -- hyau fnd_msg_pub.add;
845: -- hyau x_msg_data(x_msg_count) := fnd_message.get;
846: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
847: x_return_status := 'E';
848: raise API_ERROR;
849: end if;

Line 846: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');

842: x_msg_count := x_msg_count + 1;
843: x_msg_data.extend(1);
844: -- hyau fnd_msg_pub.add;
845: -- hyau x_msg_data(x_msg_count) := fnd_message.get;
846: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_STRUCTURE_VER_ID');
847: x_return_status := 'E';
848: raise API_ERROR;
849: end if;
850: CLOSE l_get_struct_id_csr;

Line 868: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_FUNCTION_SECURITY_ENFORCED');

864: END IF;
865:
866: x_msg_count := x_msg_count + 1;
867: x_msg_data.extend(1);
868: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_FUNCTION_SECURITY_ENFORCED');
869: --added for bug 2192242
870: fnd_message.set_name('PA', 'PA_FUNCTION_SECURITY_ENFORCED'); -- Fix for Bug # 4513291. Uncommented and moved below.
871: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
872:

Line 870: fnd_message.set_name('PA', 'PA_FUNCTION_SECURITY_ENFORCED'); -- Fix for Bug # 4513291. Uncommented and moved below.

866: x_msg_count := x_msg_count + 1;
867: x_msg_data.extend(1);
868: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_FUNCTION_SECURITY_ENFORCED');
869: --added for bug 2192242
870: fnd_message.set_name('PA', 'PA_FUNCTION_SECURITY_ENFORCED'); -- Fix for Bug # 4513291. Uncommented and moved below.
871: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
872:
873: -- x_msg_data(x_msg_count) := fnd_message.get;
874: x_return_status := 'E';

Line 873: -- x_msg_data(x_msg_count) := fnd_message.get;

869: --added for bug 2192242
870: fnd_message.set_name('PA', 'PA_FUNCTION_SECURITY_ENFORCED'); -- Fix for Bug # 4513291. Uncommented and moved below.
871: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
872:
873: -- x_msg_data(x_msg_count) := fnd_message.get;
874: x_return_status := 'E';
875: raise API_ERROR;
876: END IF;
877:

Line 918: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');

914: EXCEPTION
915: WHEN OTHERS THEN
916: x_msg_count := x_msg_count + 1;
917: x_msg_data.extend(1);
918: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
919: --added for bug 2192242
920: fnd_message.set_name('PA', 'PA_INVALID_PROJECT_ID');-- Fix for Bug # 4513291. Uncommented and moved below.
921: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
922: -- x_msg_data(x_msg_count) := fnd_message.get;

Line 920: fnd_message.set_name('PA', 'PA_INVALID_PROJECT_ID');-- Fix for Bug # 4513291. Uncommented and moved below.

916: x_msg_count := x_msg_count + 1;
917: x_msg_data.extend(1);
918: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
919: --added for bug 2192242
920: fnd_message.set_name('PA', 'PA_INVALID_PROJECT_ID');-- Fix for Bug # 4513291. Uncommented and moved below.
921: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
922: -- x_msg_data(x_msg_count) := fnd_message.get;
923: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
924: x_return_status := 'E';

Line 922: -- x_msg_data(x_msg_count) := fnd_message.get;

918: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
919: --added for bug 2192242
920: fnd_message.set_name('PA', 'PA_INVALID_PROJECT_ID');-- Fix for Bug # 4513291. Uncommented and moved below.
921: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
922: -- x_msg_data(x_msg_count) := fnd_message.get;
923: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
924: x_return_status := 'E';
925: raise API_ERROR;
926: END;

Line 923: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');

919: --added for bug 2192242
920: fnd_message.set_name('PA', 'PA_INVALID_PROJECT_ID');-- Fix for Bug # 4513291. Uncommented and moved below.
921: fnd_msg_pub.add; -- Fix for Bug # 4513291. Uncommented and moved below.
922: -- x_msg_data(x_msg_count) := fnd_message.get;
923: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_INVALID_PROJECT_ID');
924: x_return_status := 'E';
925: raise API_ERROR;
926: END;
927: --Sakthi

Line 944: fnd_message.set_name('PA', 'PA_NO_PROJECT_ID');

940:
941: -- Check project id
942:
943: if (p_project_id is null or p_project_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM) then
944: fnd_message.set_name('PA', 'PA_NO_PROJECT_ID');
945: x_msg_count := x_msg_count + 1;
946: x_msg_data.extend(1);
947: --added for bug 2192242
948: fnd_msg_pub.add;

Line 949: -- x_msg_data(x_msg_count) := fnd_message.get;

945: x_msg_count := x_msg_count + 1;
946: x_msg_data.extend(1);
947: --added for bug 2192242
948: fnd_msg_pub.add;
949: -- x_msg_data(x_msg_count) := fnd_message.get;
950: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_PROJECT_ID');
951: x_return_status := 'E';
952:
953: raise API_ERROR;

Line 950: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_PROJECT_ID');

946: x_msg_data.extend(1);
947: --added for bug 2192242
948: fnd_msg_pub.add;
949: -- x_msg_data(x_msg_count) := fnd_message.get;
950: x_msg_data(x_msg_count) := fnd_message.get_string('PA', 'PA_NO_PROJECT_ID');
951: x_return_status := 'E';
952:
953: raise API_ERROR;
954: end if ;

Line 967: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');

963: pa_debug.debug('Update Project Detals : Error PA_XC_NO_DATA_FOUND');
964: end if;
965:
966: CLOSE lock_project_record;
967: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
968: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
969: FND_MESSAGE.Set_token('PROJECT',to_char(p_project_id));
970: FND_MESSAGE.Set_token('TASK',NULL);
971: x_msg_count := x_msg_count + 1;

Line 968: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');

964: end if;
965:
966: CLOSE lock_project_record;
967: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
968: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
969: FND_MESSAGE.Set_token('PROJECT',to_char(p_project_id));
970: FND_MESSAGE.Set_token('TASK',NULL);
971: x_msg_count := x_msg_count + 1;
972: x_msg_data.extend(1);

Line 969: FND_MESSAGE.Set_token('PROJECT',to_char(p_project_id));

965:
966: CLOSE lock_project_record;
967: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
968: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
969: FND_MESSAGE.Set_token('PROJECT',to_char(p_project_id));
970: FND_MESSAGE.Set_token('TASK',NULL);
971: x_msg_count := x_msg_count + 1;
972: x_msg_data.extend(1);
973: --added for bug 2192242

Line 970: FND_MESSAGE.Set_token('TASK',NULL);

966: CLOSE lock_project_record;
967: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
968: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
969: FND_MESSAGE.Set_token('PROJECT',to_char(p_project_id));
970: FND_MESSAGE.Set_token('TASK',NULL);
971: x_msg_count := x_msg_count + 1;
972: x_msg_data.extend(1);
973: --added for bug 2192242
974: fnd_msg_pub.add;

Line 975: x_msg_data(x_msg_count) := fnd_message.get;

971: x_msg_count := x_msg_count + 1;
972: x_msg_data.extend(1);
973: --added for bug 2192242
974: fnd_msg_pub.add;
975: x_msg_data(x_msg_count) := fnd_message.get;
976: x_return_status := 'E';
977:
978: raise API_ERROR;
979: end if;

Line 1065: fnd_message.set_name('PA', l_err_stage);

1061:
1062: --dbms_output.put_line(l_return_status);
1063:
1064: -- Sakthi
1065: fnd_message.set_name('PA', l_err_stage);
1066: x_msg_count := x_msg_count + 1;
1067: x_msg_data.extend(1);
1068: --added for bug 2192242
1069: fnd_msg_pub.add;

Line 1070: x_msg_data(x_msg_count) := fnd_message.get;

1066: x_msg_count := x_msg_count + 1;
1067: x_msg_data.extend(1);
1068: --added for bug 2192242
1069: fnd_msg_pub.add;
1070: x_msg_data(x_msg_count) := fnd_message.get;
1071: -- Sakthi
1072:
1073: raise API_ERROR;
1074: end if;

Line 1257: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');

1253: if (p_debug_mode = 'Y') then
1254: pa_debug.debug('Import-Project : Inside No Data Found Exception ...');
1255: end if;
1256:
1257: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
1258: x_msg_count := x_msg_count + 1;
1259: x_msg_data.extend(1);
1260: --added for bug 2192242
1261: fnd_msg_pub.add;

Line 1262: x_msg_data(x_msg_count) := fnd_message.get;

1258: x_msg_count := x_msg_count + 1;
1259: x_msg_data.extend(1);
1260: --added for bug 2192242
1261: fnd_msg_pub.add;
1262: x_msg_data(x_msg_count) := fnd_message.get;
1263: x_return_status := 'E';
1264:
1265: WHEN ROW_ALREADY_LOCKED THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');

1269: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');
1270: end if;
1271:
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1275: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1276: FND_MESSAGE.Set_token('TASK',NULL);
1277: x_msg_count := x_msg_count + 1;

Line 1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');

1270: end if;
1271:
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1275: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1276: FND_MESSAGE.Set_token('TASK',NULL);
1277: x_msg_count := x_msg_count + 1;
1278: x_msg_data.extend(1);

Line 1275: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));

1271:
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1275: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1276: FND_MESSAGE.Set_token('TASK',NULL);
1277: x_msg_count := x_msg_count + 1;
1278: x_msg_data.extend(1);
1279: --added for bug 2192242

Line 1276: FND_MESSAGE.Set_token('TASK',NULL);

1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');
1274: FND_MESSAGE.Set_token('ENTITY', 'PA_PROJECTS_ALL');
1275: FND_MESSAGE.Set_token('PROJECT',to_char(P_PROJECT_ID));
1276: FND_MESSAGE.Set_token('TASK',NULL);
1277: x_msg_count := x_msg_count + 1;
1278: x_msg_data.extend(1);
1279: --added for bug 2192242
1280: fnd_msg_pub.add;

Line 1281: x_msg_data(x_msg_count) := FND_MESSAGE.get;

1277: x_msg_count := x_msg_count + 1;
1278: x_msg_data.extend(1);
1279: --added for bug 2192242
1280: fnd_msg_pub.add;
1281: x_msg_data(x_msg_count) := FND_MESSAGE.get;
1282: x_return_status := 'E';
1283: END IF;
1284:
1285: WHEN OTHERS THEN