1152: p_effective_date => l_effective_date);
1153: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1154: if l_db_ovn <> l_ovn then
1155: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OPT');
1156: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1157: fnd_message.set_token('OBJECT ',l_object);
1158: fnd_message.set_token('OBJECT_NAME ',l_opt_name);
1159: fnd_message.raise_error;
1160: else
1153: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1154: if l_db_ovn <> l_ovn then
1155: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OPT');
1156: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1157: fnd_message.set_token('OBJECT ',l_object);
1158: fnd_message.set_token('OBJECT_NAME ',l_opt_name);
1159: fnd_message.raise_error;
1160: else
1161: BEN_OPTION_DEFINITION_API.UPDATE_OPTION_DEFINITION(
1154: if l_db_ovn <> l_ovn then
1155: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OPT');
1156: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1157: fnd_message.set_token('OBJECT ',l_object);
1158: fnd_message.set_token('OBJECT_NAME ',l_opt_name);
1159: fnd_message.raise_error;
1160: else
1161: BEN_OPTION_DEFINITION_API.UPDATE_OPTION_DEFINITION(
1162: P_EFFECTIVE_DATE => l_effective_date
1155: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OPT');
1156: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1157: fnd_message.set_token('OBJECT ',l_object);
1158: fnd_message.set_token('OBJECT_NAME ',l_opt_name);
1159: fnd_message.raise_error;
1160: else
1161: BEN_OPTION_DEFINITION_API.UPDATE_OPTION_DEFINITION(
1162: P_EFFECTIVE_DATE => l_effective_date
1163: ,P_BUSINESS_GROUP_ID => p_business_group_id
1426: p_effective_date => l_effective_date);
1427: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1428: if l_db_ovn <> l_ovn then
1429: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLN');
1430: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1431: fnd_message.set_token('OBJECT ',l_object);
1432: fnd_message.set_token('OBJECT_NAME ',l_pl_name);
1433: fnd_message.raise_error;
1434: else
1427: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1428: if l_db_ovn <> l_ovn then
1429: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLN');
1430: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1431: fnd_message.set_token('OBJECT ',l_object);
1432: fnd_message.set_token('OBJECT_NAME ',l_pl_name);
1433: fnd_message.raise_error;
1434: else
1435: BEN_PLAN_API.UPDATE_PLAN(
1428: if l_db_ovn <> l_ovn then
1429: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLN');
1430: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1431: fnd_message.set_token('OBJECT ',l_object);
1432: fnd_message.set_token('OBJECT_NAME ',l_pl_name);
1433: fnd_message.raise_error;
1434: else
1435: BEN_PLAN_API.UPDATE_PLAN(
1436: P_EFFECTIVE_DATE => l_effective_date
1429: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLN');
1430: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1431: fnd_message.set_token('OBJECT ',l_object);
1432: fnd_message.set_token('OBJECT_NAME ',l_pl_name);
1433: fnd_message.raise_error;
1434: else
1435: BEN_PLAN_API.UPDATE_PLAN(
1436: P_EFFECTIVE_DATE => l_effective_date
1437: ,P_BUSINESS_GROUP_ID => p_business_group_id
1659: p_effective_date => l_effective_date);
1660: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1661: if l_db_ovn <> l_ovn then
1662: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PGM');
1663: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1664: fnd_message.set_token('OBJECT ',l_object);
1665: fnd_message.set_token('OBJECT_NAME ',r_pgm.information170);
1666: fnd_message.raise_error;
1667: else
1660: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1661: if l_db_ovn <> l_ovn then
1662: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PGM');
1663: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1664: fnd_message.set_token('OBJECT ',l_object);
1665: fnd_message.set_token('OBJECT_NAME ',r_pgm.information170);
1666: fnd_message.raise_error;
1667: else
1668: BEN_PROGRAM_API.UPDATE_PROGRAM(
1661: if l_db_ovn <> l_ovn then
1662: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PGM');
1663: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1664: fnd_message.set_token('OBJECT ',l_object);
1665: fnd_message.set_token('OBJECT_NAME ',r_pgm.information170);
1666: fnd_message.raise_error;
1667: else
1668: BEN_PROGRAM_API.UPDATE_PROGRAM(
1669: P_EFFECTIVE_DATE => l_effective_date
1662: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PGM');
1663: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1664: fnd_message.set_token('OBJECT ',l_object);
1665: fnd_message.set_token('OBJECT_NAME ',r_pgm.information170);
1666: fnd_message.raise_error;
1667: else
1668: BEN_PROGRAM_API.UPDATE_PROGRAM(
1669: P_EFFECTIVE_DATE => l_effective_date
1670: ,P_BUSINESS_GROUP_ID => p_business_group_id
1921: p_effective_date => l_effective_date);
1922: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1923: if l_db_ovn <> l_ovn then
1924: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OIPL');
1925: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1926: fnd_message.set_token('OBJECT ',l_object);
1927: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id||' OPT :'||l_opt_id);
1928: fnd_message.raise_error;
1929: else
1922: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1923: if l_db_ovn <> l_ovn then
1924: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OIPL');
1925: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1926: fnd_message.set_token('OBJECT ',l_object);
1927: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id||' OPT :'||l_opt_id);
1928: fnd_message.raise_error;
1929: else
1930: BEN_OPTION_IN_PLAN_API.UPDATE_OPTION_IN_PLAN(
1923: if l_db_ovn <> l_ovn then
1924: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OIPL');
1925: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1926: fnd_message.set_token('OBJECT ',l_object);
1927: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id||' OPT :'||l_opt_id);
1928: fnd_message.raise_error;
1929: else
1930: BEN_OPTION_IN_PLAN_API.UPDATE_OPTION_IN_PLAN(
1931: P_EFFECTIVE_DATE => l_effective_date
1924: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','OIPL');
1925: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
1926: fnd_message.set_token('OBJECT ',l_object);
1927: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id||' OPT :'||l_opt_id);
1928: fnd_message.raise_error;
1929: else
1930: BEN_OPTION_IN_PLAN_API.UPDATE_OPTION_IN_PLAN(
1931: P_EFFECTIVE_DATE => l_effective_date
1932: ,P_BUSINESS_GROUP_ID => p_business_group_id
2159: p_effective_date => l_effective_date);
2160: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2161: if l_db_ovn <> l_ovn then
2162: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLIP');
2163: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2164: fnd_message.set_token('OBJECT ',l_object);
2165: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id);
2166: fnd_message.raise_error;
2167: else
2160: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2161: if l_db_ovn <> l_ovn then
2162: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLIP');
2163: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2164: fnd_message.set_token('OBJECT ',l_object);
2165: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id);
2166: fnd_message.raise_error;
2167: else
2168: BEN_PLAN_IN_PROGRAM_API.UPDATE_PLAN_IN_PROGRAM(
2161: if l_db_ovn <> l_ovn then
2162: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLIP');
2163: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2164: fnd_message.set_token('OBJECT ',l_object);
2165: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id);
2166: fnd_message.raise_error;
2167: else
2168: BEN_PLAN_IN_PROGRAM_API.UPDATE_PLAN_IN_PROGRAM(
2169: P_EFFECTIVE_DATE => l_effective_date
2162: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','PLIP');
2163: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2164: fnd_message.set_token('OBJECT ',l_object);
2165: fnd_message.set_token('OBJECT_NAME ','PL :'||l_pl_id);
2166: fnd_message.raise_error;
2167: else
2168: BEN_PLAN_IN_PROGRAM_API.UPDATE_PLAN_IN_PROGRAM(
2169: P_EFFECTIVE_DATE => l_effective_date
2170: ,P_BUSINESS_GROUP_ID => p_business_group_id
2554: p_effective_date => l_effective_date);
2555: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2556: if l_db_ovn <> l_ovn then
2557: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','ELP');
2558: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2559: fnd_message.set_token('OBJECT ',l_object);
2560: fnd_message.set_token('OBJECT_NAME ',r_ELP.INFORMATION151);
2561: fnd_message.raise_error;
2562: else
2555: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2556: if l_db_ovn <> l_ovn then
2557: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','ELP');
2558: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2559: fnd_message.set_token('OBJECT ',l_object);
2560: fnd_message.set_token('OBJECT_NAME ',r_ELP.INFORMATION151);
2561: fnd_message.raise_error;
2562: else
2563: hr_utility.set_location(' BEN_ELIGY_PRFL_F UPDATE_ELIGY_PROFILE ',30);
2556: if l_db_ovn <> l_ovn then
2557: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','ELP');
2558: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2559: fnd_message.set_token('OBJECT ',l_object);
2560: fnd_message.set_token('OBJECT_NAME ',r_ELP.INFORMATION151);
2561: fnd_message.raise_error;
2562: else
2563: hr_utility.set_location(' BEN_ELIGY_PRFL_F UPDATE_ELIGY_PROFILE ',30);
2564: begin
2557: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','ELP');
2558: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2559: fnd_message.set_token('OBJECT ',l_object);
2560: fnd_message.set_token('OBJECT_NAME ',r_ELP.INFORMATION151);
2561: fnd_message.raise_error;
2562: else
2563: hr_utility.set_location(' BEN_ELIGY_PRFL_F UPDATE_ELIGY_PROFILE ',30);
2564: begin
2565: BEN_ELIGY_PROFILE_API.UPDATE_ELIGY_PROFILE(
2879: p_effective_date => l_effective_date);
2880: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2881: if l_db_ovn <> l_ovn then
2882: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CEP');
2883: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2884: fnd_message.set_token('OBJECT ',l_object);
2885: fnd_message.set_token('OBJECT_NAME ','CEP :'||l_cep_id);
2886: fnd_message.raise_error;
2887: else
2880: hr_utility.set_location(' ovn is '||l_db_ovn,30);
2881: if l_db_ovn <> l_ovn then
2882: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CEP');
2883: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2884: fnd_message.set_token('OBJECT ',l_object);
2885: fnd_message.set_token('OBJECT_NAME ','CEP :'||l_cep_id);
2886: fnd_message.raise_error;
2887: else
2888: hr_utility.set_location(' BEN_PRTN_ELIG_PRFL_F UPDATE_PRTN_ELIG_PRFL ',30);
2881: if l_db_ovn <> l_ovn then
2882: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CEP');
2883: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2884: fnd_message.set_token('OBJECT ',l_object);
2885: fnd_message.set_token('OBJECT_NAME ','CEP :'||l_cep_id);
2886: fnd_message.raise_error;
2887: else
2888: hr_utility.set_location(' BEN_PRTN_ELIG_PRFL_F UPDATE_PRTN_ELIG_PRFL ',30);
2889: BEN_PRTN_ELIG_PRFL_API.UPDATE_PRTN_ELIG_PRFL(
2882: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CEP');
2883: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
2884: fnd_message.set_token('OBJECT ',l_object);
2885: fnd_message.set_token('OBJECT_NAME ','CEP :'||l_cep_id);
2886: fnd_message.raise_error;
2887: else
2888: hr_utility.set_location(' BEN_PRTN_ELIG_PRFL_F UPDATE_PRTN_ELIG_PRFL ',30);
2889: BEN_PRTN_ELIG_PRFL_API.UPDATE_PRTN_ELIG_PRFL(
2890: P_EFFECTIVE_DATE => l_effective_date
3601: p_effective_date => l_effective_date);
3602: hr_utility.set_location(' ovn is '||l_db_ovn,30);
3603: if l_db_ovn <> l_crr_ovn then
3604: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','VPF');
3605: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
3606: fnd_message.set_token('OBJECT ',l_object);
3607: fnd_message.set_token('OBJECT_NAME ','VPF : '||l_crr_id);
3608: fnd_message.raise_error;
3609: else
3602: hr_utility.set_location(' ovn is '||l_db_ovn,30);
3603: if l_db_ovn <> l_crr_ovn then
3604: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','VPF');
3605: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
3606: fnd_message.set_token('OBJECT ',l_object);
3607: fnd_message.set_token('OBJECT_NAME ','VPF : '||l_crr_id);
3608: fnd_message.raise_error;
3609: else
3610: begin
3603: if l_db_ovn <> l_crr_ovn then
3604: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','VPF');
3605: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
3606: fnd_message.set_token('OBJECT ',l_object);
3607: fnd_message.set_token('OBJECT_NAME ','VPF : '||l_crr_id);
3608: fnd_message.raise_error;
3609: else
3610: begin
3611: BEN_VRBL_RATE_PROFILE_API.UPDATE_VRBL_RATE_PROFILE(
3604: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','VPF');
3605: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
3606: fnd_message.set_token('OBJECT ',l_object);
3607: fnd_message.set_token('OBJECT_NAME ','VPF : '||l_crr_id);
3608: fnd_message.raise_error;
3609: else
3610: begin
3611: BEN_VRBL_RATE_PROFILE_API.UPDATE_VRBL_RATE_PROFILE(
3612: P_EFFECTIVE_DATE => l_effective_date