APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_OPT_SHD

Line 1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);

1933: hr_utility.set_location('p_opt_id'||p_opt_id,10);
1934: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1935: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1936: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,25);
1937: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,30);
1938: end if;
1939:
1940:
1941: -- Checks OPT has GSP Type and OPT exists in GSP Program

Line 1974: hr_utility.set_location('Old Point Id :'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,80);

1970: If l_oipl_has_emp_assign = 'Y' Then
1971:
1972:
1973: if g_debug then
1974: hr_utility.set_location('Old Point Id :'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,80);
1975: end if;
1976:
1977: -- Cannot change Step which is mapped to Option
1978: If (ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID <> p_mapping_table_pk_id) Then

Line 1978: If (ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID <> p_mapping_table_pk_id) Then

1974: hr_utility.set_location('Old Point Id :'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,80);
1975: end if;
1976:
1977: -- Cannot change Step which is mapped to Option
1978: If (ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID <> p_mapping_table_pk_id) Then
1979: hr_utility.set_message(8302,'PQH_GSP_NOT_UPD_OPT_STEP_ID');
1980: hr_utility.raise_error;
1981: End if;
1982:

Line 2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);

2042: hr_utility.set_location('p_effective_date'||p_effective_date,15);
2043: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
2044: hr_utility.set_location('p_dml_operation'||p_dml_operation,25);
2045: hr_utility.set_location('p_mapping_table_pk_id'||p_mapping_table_pk_id,35);
2046: hr_utility.set_location('Old mapping_table_pk_id'||ben_opt_shd.g_old_rec.MAPPING_TABLE_PK_ID,40);
2047: end if;
2048:
2049:
2050: if p_dml_operation = 'I' Then