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.PAY_PSD_BUS dependencies on PAY_PL_SII_DETAILS_F

Line 31: , pay_pl_sii_details_f psd

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_pl_sii_details_f psd
32: where psd.sii_details_id = p_sii_details_id
33: and pbg.business_group_id = psd.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_pl_sii_details_f psd

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_pl_sii_details_f psd
102: where psd.sii_details_id = p_sii_details_id
103: and pbg.business_group_id = psd.business_group_id;
104: --
105: -- Declare local variables

Line 244: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'

240: hr_utility.set_location(' Leaving:'|| l_proc, 20);
241: exception
242: when app_exception.application_exception then
243: if hr_multi_message.exception_add
244: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'
245: ) then
246: hr_utility.set_location(' Leaving:'|| l_proc, 30);
247: raise;
248: end if;

Line 325: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'

321: hr_utility.set_location(' Leaving:'|| l_proc, 20);
322: exception
323: when app_exception.application_exception then
324: if hr_multi_message.exception_add
325: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'
326: ) then
327: hr_utility.set_location(' Leaving:'|| l_proc, 30);
328: raise;
329: end if;

Line 447: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'

443: ,p_argument_value => p_per_or_asg_id
444: );
445:
446: if hr_multi_message.no_exclusive_error
447: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'
448: ,p_check_column2 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'
449: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID') then
450:
451: -- Continue with valiadtion only if the columns

Line 448: ,p_check_column2 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'

444: );
445:
446: if hr_multi_message.no_exclusive_error
447: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'
448: ,p_check_column2 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'
449: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID') then
450:
451: -- Continue with valiadtion only if the columns
452: -- a) BUSINESS_GROUP_ID and

Line 449: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID') then

445:
446: if hr_multi_message.no_exclusive_error
447: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.CONTRACT_CATEGORY'
448: ,p_check_column2 => 'PAY_PL_SII_DETAILS_F.BUSINESS_GROUP_ID'
449: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID') then
450:
451: -- Continue with valiadtion only if the columns
452: -- a) BUSINESS_GROUP_ID and
453: -- b) CONTRACT_CATEGORY are valid.

Line 495: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID'

491: hr_utility.set_location(' Leaving:'|| l_proc, 20);
492: exception
493: when app_exception.application_exception then
494: if hr_multi_message.exception_add
495: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PER_OR_ASG_ID'
496: ) then
497: hr_utility.set_location(' Leaving:'|| l_proc, 30);
498: raise;
499: end if;

Line 615: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.EMP_SOCIAL_SECURITY_INFO'

611: hr_utility.set_location(' Leaving:'|| l_proc, 20);
612: exception
613: when app_exception.application_exception then
614: if hr_multi_message.exception_add
615: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.EMP_SOCIAL_SECURITY_INFO'
616: ) then
617: hr_utility.set_location(' Leaving:'|| l_proc, 30);
618: raise;
619: end if;

Line 738: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONTRIBUTION'

734: hr_utility.set_location(' Leaving:'|| l_proc, 20);
735: exception
736: when app_exception.application_exception then
737: if hr_multi_message.exception_add
738: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONTRIBUTION'
739: ) then
740: hr_utility.set_location(' Leaving:'|| l_proc, 30);
741: raise;
742: end if;

Line 862: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONTRIBUTION'

858: hr_utility.set_location(' Leaving:'|| l_proc, 20);
859: exception
860: when app_exception.application_exception then
861: if hr_multi_message.exception_add
862: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONTRIBUTION'
863: ) then
864: hr_utility.set_location(' Leaving:'|| l_proc, 30);
865: raise;
866: end if;

Line 986: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONTRIBUTION'

982: hr_utility.set_location(' Leaving:'|| l_proc, 20);
983: exception
984: when app_exception.application_exception then
985: if hr_multi_message.exception_add
986: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONTRIBUTION'
987: ) then
988: hr_utility.set_location(' Leaving:'|| l_proc, 30);
989: raise;
990: end if;

Line 1110: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONTRIBUTION'

1106: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1107: exception
1108: when app_exception.application_exception then
1109: if hr_multi_message.exception_add
1110: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONTRIBUTION'
1111: ) then
1112: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1113: raise;
1114: end if;

Line 1233: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_CONTRIBUTION'

1229: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1230: exception
1231: when app_exception.application_exception then
1232: if hr_multi_message.exception_add
1233: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_CONTRIBUTION'
1234: ) then
1235: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1236: raise;
1237: end if;

Line 1357: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONTRIBUTION'

1353: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1354: exception
1355: when app_exception.application_exception then
1356: if hr_multi_message.exception_add
1357: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONTRIBUTION'
1358: ) then
1359: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1360: raise;
1361: end if;

Line 1482: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONTRIBUTION'

1478: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1479: exception
1480: when app_exception.application_exception then
1481: if hr_multi_message.exception_add
1482: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONTRIBUTION'
1483: ) then
1484: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1485: raise;
1486: end if;

Line 1554: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONTRIBUTION'

1550: );
1551:
1552: -- Proceed with validation only if the Old Age Contribution Value is not Invalid
1553: if hr_multi_message.no_exclusive_error
1554: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONTRIBUTION'
1555: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONT_END_REASON') then
1556:
1557:
1558: -- Only proceed with validation if:

Line 1555: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONT_END_REASON') then

1551:
1552: -- Proceed with validation only if the Old Age Contribution Value is not Invalid
1553: if hr_multi_message.no_exclusive_error
1554: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONTRIBUTION'
1555: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONT_END_REASON') then
1556:
1557:
1558: -- Only proceed with validation if:
1559: -- a) The current g_old_rec is current and

Line 1636: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONT_END_REASON'

1632: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1633: exception
1634: when app_exception.application_exception then
1635: if hr_multi_message.exception_add
1636: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_AGE_CONT_END_REASON'
1637: ) then
1638: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1639: raise;
1640: end if;

Line 1709: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONTRIBUTION'

1705: );
1706:
1707: -- Proceed with validation only if the Old Age Contribution Value is not Invalid
1708: if hr_multi_message.no_exclusive_error
1709: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONTRIBUTION'
1710: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_PENSION_END_REASON') then
1711:
1712:
1713: -- Only proceed with validation if:

Line 1710: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_PENSION_END_REASON') then

1706:
1707: -- Proceed with validation only if the Old Age Contribution Value is not Invalid
1708: if hr_multi_message.no_exclusive_error
1709: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONTRIBUTION'
1710: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.OLD_PENSION_END_REASON') then
1711:
1712:
1713: -- Only proceed with validation if:
1714: -- a) The current g_old_rec is current and

Line 1790: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONT_END_REASON'

1786: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1787: exception
1788: when app_exception.application_exception then
1789: if hr_multi_message.exception_add
1790: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.PENSION_CONT_END_REASON'
1791: ) then
1792: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1793: raise;
1794: end if;

Line 1862: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONTRIBUTION'

1858: );
1859:
1860: -- Proceed with validation only if the Sickness Contribution Value is not Invalid
1861: if hr_multi_message.no_exclusive_error
1862: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONTRIBUTION'
1863: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONT_END_REASON') then
1864:
1865:
1866: -- Only proceed with validation if:

Line 1863: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONT_END_REASON') then

1859:
1860: -- Proceed with validation only if the Sickness Contribution Value is not Invalid
1861: if hr_multi_message.no_exclusive_error
1862: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONTRIBUTION'
1863: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONT_END_REASON') then
1864:
1865:
1866: -- Only proceed with validation if:
1867: -- a) The current g_old_rec is current and

Line 1943: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONT_END_REASON'

1939: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1940: exception
1941: when app_exception.application_exception then
1942: if hr_multi_message.exception_add
1943: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.SICKNESS_CONT_END_REASON'
1944: ) then
1945: hr_utility.set_location(' Leaving:'|| l_proc, 30);
1946: raise;
1947: end if;

Line 2015: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONTRIBUTION'

2011: );
2012:
2013: -- Proceed with validation only if the Work Injury Contribution Value is not Invalid
2014: if hr_multi_message.no_exclusive_error
2015: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONTRIBUTION'
2016: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONT_END_REASON') then
2017:
2018:
2019: -- Only proceed with validation if:

Line 2016: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONT_END_REASON') then

2012:
2013: -- Proceed with validation only if the Work Injury Contribution Value is not Invalid
2014: if hr_multi_message.no_exclusive_error
2015: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONTRIBUTION'
2016: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONT_END_REASON') then
2017:
2018:
2019: -- Only proceed with validation if:
2020: -- a) The current g_old_rec is current and

Line 2096: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONT_END_REASON'

2092: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2093: exception
2094: when app_exception.application_exception then
2095: if hr_multi_message.exception_add
2096: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.WORK_INJURY_CONT_END_REASON'
2097: ) then
2098: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2099: raise;
2100: end if;

Line 2168: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_CONTRIBUTION'

2164: );
2165:
2166: -- Proceed with validation only if the Labor Contribution Value is not Invalid
2167: if hr_multi_message.no_exclusive_error
2168: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_CONTRIBUTION'
2169: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_FUND_CONT_END_REASON') then
2170:
2171:
2172: -- Only proceed with validation if:

Line 2169: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_FUND_CONT_END_REASON') then

2165:
2166: -- Proceed with validation only if the Labor Contribution Value is not Invalid
2167: if hr_multi_message.no_exclusive_error
2168: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_CONTRIBUTION'
2169: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_FUND_CONT_END_REASON') then
2170:
2171:
2172: -- Only proceed with validation if:
2173: -- a) The current g_old_rec is current and

Line 2249: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_FUND_CONT_END_REASON'

2245: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2246: exception
2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.LABOR_FUND_CONT_END_REASON'
2250: ) then
2251: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2252: raise;
2253: end if;

Line 2321: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONTRIBUTION'

2317: );
2318:
2319: -- Proceed with validation only if the Health Contribution Value is not Invalid
2320: if hr_multi_message.no_exclusive_error
2321: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONTRIBUTION'
2322: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONT_END_REASON') then
2323:
2324:
2325: -- Only proceed with validation if:

Line 2322: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONT_END_REASON') then

2318:
2319: -- Proceed with validation only if the Health Contribution Value is not Invalid
2320: if hr_multi_message.no_exclusive_error
2321: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONTRIBUTION'
2322: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONT_END_REASON') then
2323:
2324:
2325: -- Only proceed with validation if:
2326: -- a) The current g_old_rec is current and

Line 2402: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONT_END_REASON'

2398: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2399: exception
2400: when app_exception.application_exception then
2401: if hr_multi_message.exception_add
2402: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.HEALTH_CONT_END_REASON'
2403: ) then
2404: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2405: raise;
2406: end if;

Line 2474: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONTRIBUTION'

2470: );
2471:
2472: -- Proceed with validation only if the Old Age Contribution Value is not Invalid
2473: if hr_multi_message.no_exclusive_error
2474: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONTRIBUTION'
2475: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONT_END_REASON') then
2476:
2477:
2478: -- Only proceed with validation if:

Line 2475: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONT_END_REASON') then

2471:
2472: -- Proceed with validation only if the Old Age Contribution Value is not Invalid
2473: if hr_multi_message.no_exclusive_error
2474: (p_check_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONTRIBUTION'
2475: ,p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONT_END_REASON') then
2476:
2477:
2478: -- Only proceed with validation if:
2479: -- a) The current g_old_rec is current and

Line 2555: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONT_END_REASON'

2551: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2552: exception
2553: when app_exception.application_exception then
2554: if hr_multi_message.exception_add
2555: (p_associated_column1 => 'PAY_PL_SII_DETAILS_F.UNEMPLOYMENT_CONT_END_REASON'
2556: ) then
2557: hr_utility.set_location(' Leaving:'|| l_proc, 30);
2558: raise;
2559: end if;