690:
691:
692: --Bug#5559292
693:
694: G_PROJECT_NUMBER_GEN_MODE := PA_PROJECT_UTILS.GetProjNumMode;
695: G_PROJECT_NUMBER_TYPE := PA_PROJECT_UTILS.GetProjNumType;
696:
697: --Bug#5559292
698:
691:
692: --Bug#5559292
693:
694: G_PROJECT_NUMBER_GEN_MODE := PA_PROJECT_UTILS.GetProjNumMode;
695: G_PROJECT_NUMBER_TYPE := PA_PROJECT_UTILS.GetProjNumType;
696:
697: --Bug#5559292
698:
699:
889: END IF;
890:
891: -- Ensure that Project name is unique
892:
893: IF pa_project_utils.check_unique_project_name
894: (l_project_in_rec.project_name,
895: NULL ) = 0 THEN
896: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
897: THEN
936:
937: -- Bug#2638968 Ensure that Long name is unique
938: IF l_project_in_rec.long_name <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
939: AND l_project_in_rec.long_name IS NOT NULL THEN
940: IF pa_project_utils.check_unique_long_name
941: (l_project_in_rec.long_name,
942: NULL ) = 0 THEN
943: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
944: THEN
961:
962: -- bug#3014919: Ensure Project Reference is unique
963: IF l_project_in_rec.pm_project_reference <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
964: AND l_project_in_rec.pm_project_reference IS NOT NULL THEN
965: IF pa_project_utils.check_unique_project_reference
966: (l_project_in_rec.pm_project_reference,
967: p_pm_product_code, -- added for bug 4870305
968: NULL ) = 0
969: THEN
1002: END IF;
1003:
1004:
1005: IF G_PROJECT_NUMBER_GEN_MODE = 'MANUAL' THEN
1006: IF pa_project_utils.check_unique_project_number
1007: (l_create_project_number,
1008: NULL ) = 0 THEN
1009: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1010: pa_interface_utils_pub.map_new_amg_msg
11224: AND p_project_in.pa_project_number IS NOT NULL
11225: THEN
11226: IF p_project_in.pa_project_number <> l_project_rec.segment1
11227: THEN
11228: pa_project_utils.change_proj_num_ok
11229: (l_project_id,
11230: l_err_code,
11231: l_err_stage,
11232: l_err_stack );
11522: l_org_func_security := 'N';
11523: END IF;
11524:
11525:
11526: pa_project_utils2.validate_attribute_change(
11527: X_Context => 'ORGANIZATION_VALIDATION'
11528: ,X_insert_update_mode => NULL
11529: ,X_calling_module => 'UPDATE_PROJECT'
11530: ,X_project_id => l_project_id
11710: p_project_out.return_status := FND_API.G_RET_STS_ERROR;
11711: RAISE FND_API.G_EXC_ERROR;
11712: END IF;
11713:
11714: pa_project_utils.check_dist_rule_chg_ok ( l_project_id,
11715: l_project_rec.distribution_rule,
11716: p_project_in.distribution_rule,
11717: l_err_code,
11718: l_err_stage,