741: p_key_column_value => l_pth_id);
742: hr_utility.set_location(' ovn is '||l_db_ovn,30);
743: if l_db_ovn <> l_pth_ovn then
744: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CCP');
745: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
746: fnd_message.set_token('OBJECT ',l_object);
747: fnd_message.set_token('OBJECT_NAME ',substr(pth_rec.information1,1,30));
748: fnd_message.raise_error;
749: else
742: hr_utility.set_location(' ovn is '||l_db_ovn,30);
743: if l_db_ovn <> l_pth_ovn then
744: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CCP');
745: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
746: fnd_message.set_token('OBJECT ',l_object);
747: fnd_message.set_token('OBJECT_NAME ',substr(pth_rec.information1,1,30));
748: fnd_message.raise_error;
749: else
750: per_hierarchy_nodes_api.update_hierarchy_nodes
743: if l_db_ovn <> l_pth_ovn then
744: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CCP');
745: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
746: fnd_message.set_token('OBJECT ',l_object);
747: fnd_message.set_token('OBJECT_NAME ',substr(pth_rec.information1,1,30));
748: fnd_message.raise_error;
749: else
750: per_hierarchy_nodes_api.update_hierarchy_nodes
751: (p_hierarchy_node_id => l_pth_id
744: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CCP');
745: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
746: fnd_message.set_token('OBJECT ',l_object);
747: fnd_message.set_token('OBJECT_NAME ',substr(pth_rec.information1,1,30));
748: fnd_message.raise_error;
749: else
750: per_hierarchy_nodes_api.update_hierarchy_nodes
751: (p_hierarchy_node_id => l_pth_id
752: ,p_entity_id => pth_rec.information234
852: p_key_column_value => l_cdd_id);
853: hr_utility.set_location(' ovn is '||l_db_ovn,30);
854: if l_db_ovn <> l_cdd_ovn then
855: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CDD');
856: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
857: fnd_message.set_token('OBJECT ',l_object);
858: fnd_message.set_token('OBJECT_NAME ',substr(cdd_rec.information113,1,30));
859: fnd_message.raise_error;
860: else
853: hr_utility.set_location(' ovn is '||l_db_ovn,30);
854: if l_db_ovn <> l_cdd_ovn then
855: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CDD');
856: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
857: fnd_message.set_token('OBJECT ',l_object);
858: fnd_message.set_token('OBJECT_NAME ',substr(cdd_rec.information113,1,30));
859: fnd_message.raise_error;
860: else
861: pqh_corps_extra_info_api.update_corps_extra_info
854: if l_db_ovn <> l_cdd_ovn then
855: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CDD');
856: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
857: fnd_message.set_token('OBJECT ',l_object);
858: fnd_message.set_token('OBJECT_NAME ',substr(cdd_rec.information113,1,30));
859: fnd_message.raise_error;
860: else
861: pqh_corps_extra_info_api.update_corps_extra_info
862: (p_effective_date => p_effective_date
855: l_object := hr_general.decode_lookup('PQH_GSP_OBJECT_TYPE','CDD');
856: fnd_message.set_name('PQH','PQH_GSP_OBJ_OVN_INVALID');
857: fnd_message.set_token('OBJECT ',l_object);
858: fnd_message.set_token('OBJECT_NAME ',substr(cdd_rec.information113,1,30));
859: fnd_message.raise_error;
860: else
861: pqh_corps_extra_info_api.update_corps_extra_info
862: (p_effective_date => p_effective_date
863: ,p_corps_extra_info_id => l_cdd_id
1235: IF l_db_ovn <> l_cpd_ovn
1236: THEN
1237: l_object :=
1238: hr_general.decode_lookup ('PQH_GSP_OBJECT_TYPE', 'CPD');
1239: fnd_message.set_name ('PQH', 'PQH_GSP_OBJ_OVN_INVALID');
1240: fnd_message.set_token ('OBJECT ', l_object);
1241: fnd_message.set_token ('OBJECT_NAME ', cpd_rec.information5);
1242: fnd_message.raise_error;
1243: ELSE
1236: THEN
1237: l_object :=
1238: hr_general.decode_lookup ('PQH_GSP_OBJECT_TYPE', 'CPD');
1239: fnd_message.set_name ('PQH', 'PQH_GSP_OBJ_OVN_INVALID');
1240: fnd_message.set_token ('OBJECT ', l_object);
1241: fnd_message.set_token ('OBJECT_NAME ', cpd_rec.information5);
1242: fnd_message.raise_error;
1243: ELSE
1244: pqh_corps_definitions_api.update_corps_definition
1237: l_object :=
1238: hr_general.decode_lookup ('PQH_GSP_OBJECT_TYPE', 'CPD');
1239: fnd_message.set_name ('PQH', 'PQH_GSP_OBJ_OVN_INVALID');
1240: fnd_message.set_token ('OBJECT ', l_object);
1241: fnd_message.set_token ('OBJECT_NAME ', cpd_rec.information5);
1242: fnd_message.raise_error;
1243: ELSE
1244: pqh_corps_definitions_api.update_corps_definition
1245: (p_effective_date => p_effective_date,
1238: hr_general.decode_lookup ('PQH_GSP_OBJECT_TYPE', 'CPD');
1239: fnd_message.set_name ('PQH', 'PQH_GSP_OBJ_OVN_INVALID');
1240: fnd_message.set_token ('OBJECT ', l_object);
1241: fnd_message.set_token ('OBJECT_NAME ', cpd_rec.information5);
1242: fnd_message.raise_error;
1243: ELSE
1244: pqh_corps_definitions_api.update_corps_definition
1245: (p_effective_date => p_effective_date,
1246: p_date_from => l_pgm_esd,