eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_GSP_BEN_VALIDATIONS dependencies on BEN_PLN_SHD

Line 1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);

1474: hr_utility.set_location('p_pl_id'||p_pl_id,10);
1475: hr_utility.set_location('p_effective_date'||p_effective_date,15);
1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);

Line 1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);

1476: hr_utility.set_location('p_Business_Group_Id'||p_Business_Group_Id,20);
1477: hr_utility.set_location('p_pl_Typ_Id'||p_pl_Typ_Id,25);
1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);
1483: end if;
1484:

Line 1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);

1478: hr_utility.set_location('Old pl_Typ_Id'||ben_pln_shd.g_old_rec.PL_TYP_ID,30);
1479: hr_utility.set_location('p_Mapping_Table_PK_ID'||p_Mapping_Table_PK_ID,35);
1480: hr_utility.set_location('Old Mapping_Table_PK_ID'||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,40);
1481: hr_utility.set_location('p_pl_stat_cd'||p_pl_stat_cd,45);
1482: hr_utility.set_location('Old pl_stat_cd'||ben_pln_shd.g_old_rec.pl_stat_cd,60);
1483: end if;
1484:
1485: l_exists := chk_pl_exists_in_grdldr(p_pl_id => p_pl_id,
1486: p_effective_date => p_effective_date,

Line 1495: Open csr_pl_type(ben_pln_shd.g_old_rec.PL_TYP_ID);

1491: hr_utility.set_location('Plan Exists in Program : '||l_exists,90);
1492: end if;
1493: If l_exists = 'Y' Then
1494:
1495: Open csr_pl_type(ben_pln_shd.g_old_rec.PL_TYP_ID);
1496: Fetch csr_pl_type into l_exist_pl_type_cd;
1497: Close csr_pl_type;
1498:
1499:

Line 1531: hr_utility.set_location('Old Plan Status : '||ben_pln_shd.g_old_rec.pl_stat_cd,165);

1527: -- Cannot Update Status
1528: --
1529:
1530: if g_debug then
1531: hr_utility.set_location('Old Plan Status : '||ben_pln_shd.g_old_rec.pl_stat_cd,165);
1532: end if;
1533:
1534:
1535: If (ben_pln_shd.g_old_rec.pl_stat_cd = 'A' And ben_pln_shd.g_old_rec.pl_stat_cd <> p_pl_stat_cd)Then

Line 1535: If (ben_pln_shd.g_old_rec.pl_stat_cd = 'A' And ben_pln_shd.g_old_rec.pl_stat_cd <> p_pl_stat_cd)Then

1531: hr_utility.set_location('Old Plan Status : '||ben_pln_shd.g_old_rec.pl_stat_cd,165);
1532: end if;
1533:
1534:
1535: If (ben_pln_shd.g_old_rec.pl_stat_cd = 'A' And ben_pln_shd.g_old_rec.pl_stat_cd <> p_pl_stat_cd)Then
1536: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_PGM_STATUS');
1537: hr_utility.raise_error;
1538: End If;
1539:

Line 1565: hr_utility.set_location('Old Grade Id : '||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,200);

1561:
1562: if l_emp_exists = 'Y' Then
1563:
1564: if g_debug then
1565: hr_utility.set_location('Old Grade Id : '||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,200);
1566: end if;
1567:
1568:
1569: If (ben_pln_shd.g_old_rec.Mapping_Table_PK_ID <> p_Mapping_Table_PK_ID)Then

Line 1569: If (ben_pln_shd.g_old_rec.Mapping_Table_PK_ID <> p_Mapping_Table_PK_ID)Then

1565: hr_utility.set_location('Old Grade Id : '||ben_pln_shd.g_old_rec.Mapping_Table_PK_ID,200);
1566: end if;
1567:
1568:
1569: If (ben_pln_shd.g_old_rec.Mapping_Table_PK_ID <> p_Mapping_Table_PK_ID)Then
1570: hr_utility.set_message(8302,'PQH_GSP_NOT_PL_UPD_EMP_GRD_ID');
1571: hr_utility.raise_error;
1572: End If;
1573: end if;