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.PQP_PTY_BUS dependencies on FND_MESSAGE

Line 68: fnd_message.set_name('PQP', 'PQP_230808_INVALID_CONTR_RULE');

64: ,p_lookup_type => 'PQP_NL_CONVERSION_RULE'
65: ,p_lookup_code => p_contribution_conversion_rule
66: ) then
67: -- Error: Invalid Contribution Conversion Rule
68: fnd_message.set_name('PQP', 'PQP_230808_INVALID_CONTR_RULE');
69: fnd_message.raise_error;
70: end if;
71: end if;
72: end if;

Line 69: fnd_message.raise_error;

65: ,p_lookup_code => p_contribution_conversion_rule
66: ) then
67: -- Error: Invalid Contribution Conversion Rule
68: fnd_message.set_name('PQP', 'PQP_230808_INVALID_CONTR_RULE');
69: fnd_message.raise_error;
70: end if;
71: end if;
72: end if;
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 137: fnd_message.set_name('PQP', 'PQP_230809_INVALID_THRES_RULE');

133: ,p_lookup_type => 'PQP_NL_CONVERSION_RULE'
134: ,p_lookup_code => p_threshold_conversion_rule
135: ) then
136: -- Error: Invalid Threshold Conversion Rule
137: fnd_message.set_name('PQP', 'PQP_230809_INVALID_THRES_RULE');
138: fnd_message.raise_error;
139: end if;
140: end if;
141: end if;

Line 138: fnd_message.raise_error;

134: ,p_lookup_code => p_threshold_conversion_rule
135: ) then
136: -- Error: Invalid Threshold Conversion Rule
137: fnd_message.set_name('PQP', 'PQP_230809_INVALID_THRES_RULE');
138: fnd_message.raise_error;
139: end if;
140: end if;
141: end if;
142: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 208: fnd_message.set_name('PQP', 'PQP_230810_INVALID_PEN_CAT');

204: ,p_lookup_type => 'PQP_PENSION_CATEGORY'
205: ,p_lookup_code => p_pension_category
206: ) then
207: -- Error: Invalid Pension Category
208: fnd_message.set_name('PQP', 'PQP_230810_INVALID_PEN_CAT');
209: fnd_message.raise_error;
210: end if;
211: end if;
212:

Line 209: fnd_message.raise_error;

205: ,p_lookup_code => p_pension_category
206: ) then
207: -- Error: Invalid Pension Category
208: fnd_message.set_name('PQP', 'PQP_230810_INVALID_PEN_CAT');
209: fnd_message.raise_error;
210: end if;
211: end if;
212:
213: end if;

Line 278: fnd_message.set_name('PQP', 'PQP_230811_INV_PRVDR_TYPE');

274: ,p_lookup_type => 'PQP_NL_PENSION_PROVIDER_TYPE'
275: ,p_lookup_code => p_pension_provider_type
276: ) then
277: -- Error: Invalid Pension Provider Type
278: fnd_message.set_name('PQP', 'PQP_230811_INV_PRVDR_TYPE');
279: fnd_message.raise_error;
280: end if;
281: end if;
282: end if;

Line 279: fnd_message.raise_error;

275: ,p_lookup_code => p_pension_provider_type
276: ) then
277: -- Error: Invalid Pension Provider Type
278: fnd_message.set_name('PQP', 'PQP_230811_INV_PRVDR_TYPE');
279: fnd_message.raise_error;
280: end if;
281: end if;
282: end if;
283: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 346: fnd_message.set_name('PQP', 'PQP_230812_SALARY_CALC_METHOD');

342: ,p_lookup_type => 'PQP_NL_SALARY_CALC_METHOD'
343: ,p_lookup_code => p_salary_calculation_method
344: ) then
345: -- Error: Invalid Salary Calculation Method
346: fnd_message.set_name('PQP', 'PQP_230812_SALARY_CALC_METHOD');
347: fnd_message.raise_error;
348: end if;
349: end if;
350: end if;

Line 347: fnd_message.raise_error;

343: ,p_lookup_code => p_salary_calculation_method
344: ) then
345: -- Error: Invalid Salary Calculation Method
346: fnd_message.set_name('PQP', 'PQP_230812_SALARY_CALC_METHOD');
347: fnd_message.raise_error;
348: end if;
349: end if;
350: end if;
351: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 442: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');

438: if csr_pension_type%FOUND then
439: close csr_pension_type;
440: hr_utility.set_location(' Pension Type Name already exists in table',15);
441: -- Error: Pension Name already exists in the table
442: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');
443: fnd_message.raise_error;
444: else
445: close csr_pension_type;
446: end if;

Line 443: fnd_message.raise_error;

439: close csr_pension_type;
440: hr_utility.set_location(' Pension Type Name already exists in table',15);
441: -- Error: Pension Name already exists in the table
442: fnd_message.set_name('PQP', 'PQP_230813_PEN_TYPE_EXISTS');
443: fnd_message.raise_error;
444: else
445: close csr_pension_type;
446: end if;
447:

Line 511: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');

507: fetch csr_org_info_nl Into l_org_info_exits;
508: if csr_org_info_nl%FOUND then
509: close csr_org_info_nl;
510: -- Error: Pension Name has been assigned to a provider
511: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');
512: fnd_message.raise_error;
513: else
514: close csr_org_info_nl;
515: end if;

Line 512: fnd_message.raise_error;

508: if csr_org_info_nl%FOUND then
509: close csr_org_info_nl;
510: -- Error: Pension Name has been assigned to a provider
511: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');
512: fnd_message.raise_error;
513: else
514: close csr_org_info_nl;
515: end if;
516: end if;

Line 524: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');

520: fetch csr_org_info_gb Into l_org_info_exits;
521: if csr_org_info_gb%FOUND then
522: close csr_org_info_gb;
523: -- Error: Pension Name has been assigned to a provider
524: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');
525: fnd_message.raise_error;
526: else
527: close csr_org_info_gb;
528: end if;

Line 525: fnd_message.raise_error;

521: if csr_org_info_gb%FOUND then
522: close csr_org_info_gb;
523: -- Error: Pension Name has been assigned to a provider
524: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');
525: fnd_message.raise_error;
526: else
527: close csr_org_info_gb;
528: end if;
529: end if;

Line 537: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');

533: fetch csr_org_info_hu Into l_org_info_exits;
534: if csr_org_info_hu%FOUND then
535: close csr_org_info_hu;
536: -- Error: Pension Name has been assigned to a provider
537: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');
538: fnd_message.raise_error;
539: else
540: close csr_org_info_hu;
541: end if;

Line 538: fnd_message.raise_error;

534: if csr_org_info_hu%FOUND then
535: close csr_org_info_hu;
536: -- Error: Pension Name has been assigned to a provider
537: fnd_message.set_name('PQP', 'PQP_230814_PEN_TYPE_ASGED');
538: fnd_message.raise_error;
539: else
540: close csr_org_info_hu;
541: end if;
542: end if;

Line 608: fnd_message.set_name('PQP', 'PQP_230022_INV_SPL_PEN_TYPE');

604: ,p_lookup_type => 'PQP_SPECIAL_PENSION_TYPE_CODE'
605: ,p_lookup_code => p_special_pension_type_code
606: ) then
607: -- Error: Invalid Special Pension Type Code
608: fnd_message.set_name('PQP', 'PQP_230022_INV_SPL_PEN_TYPE');
609: fnd_message.raise_error;
610: end if;
611: end if;
612: end if;

Line 609: fnd_message.raise_error;

605: ,p_lookup_code => p_special_pension_type_code
606: ) then
607: -- Error: Invalid Special Pension Type Code
608: fnd_message.set_name('PQP', 'PQP_230022_INV_SPL_PEN_TYPE');
609: fnd_message.raise_error;
610: end if;
611: end if;
612: end if;
613: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 677: fnd_message.set_name('PQP', 'PQP_230023_INV_PEN_SUB_CAT');

673: ,p_lookup_type => 'PQP_PENSION_SUB_CATEGORY'
674: ,p_lookup_code => p_pension_sub_category
675: ) then
676: -- Error: Invalid Pension Sub Category
677: fnd_message.set_name('PQP', 'PQP_230023_INV_PEN_SUB_CAT');
678: fnd_message.raise_error;
679: end if;
680: end if;
681: end if;

Line 678: fnd_message.raise_error;

674: ,p_lookup_code => p_pension_sub_category
675: ) then
676: -- Error: Invalid Pension Sub Category
677: fnd_message.set_name('PQP', 'PQP_230023_INV_PEN_SUB_CAT');
678: fnd_message.raise_error;
679: end if;
680: end if;
681: end if;
682: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 746: fnd_message.set_name('PQP', 'PQP_230024_INV_PEN_BASIS_CALC');

742: ,p_lookup_type => 'PQP_PENSION_BASIS_CALC_MTHD'
743: ,p_lookup_code => p_pension_basis_calc_method
744: ) then
745: -- Error: Invalid Pension Basis Calculation Method
746: fnd_message.set_name('PQP', 'PQP_230024_INV_PEN_BASIS_CALC');
747: fnd_message.raise_error;
748: end if;
749: end if;
750: end if;

Line 747: fnd_message.raise_error;

743: ,p_lookup_code => p_pension_basis_calc_method
744: ) then
745: -- Error: Invalid Pension Basis Calculation Method
746: fnd_message.set_name('PQP', 'PQP_230024_INV_PEN_BASIS_CALC');
747: fnd_message.raise_error;
748: end if;
749: end if;
750: end if;
751: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 815: fnd_message.set_name('PQP', 'PQP_230025_PREV_YR_BONUS_INCL');

811: ,p_lookup_type => 'PQP_YES_NO'
812: ,p_lookup_code => p_previous_year_bonus_included
813: ) then
814: -- Error: Invalid Previous Year Bonus Included
815: fnd_message.set_name('PQP', 'PQP_230025_PREV_YR_BONUS_INCL');
816: fnd_message.raise_error;
817: end if;
818: end if;
819: end if;

Line 816: fnd_message.raise_error;

812: ,p_lookup_code => p_previous_year_bonus_included
813: ) then
814: -- Error: Invalid Previous Year Bonus Included
815: fnd_message.set_name('PQP', 'PQP_230025_PREV_YR_BONUS_INCL');
816: fnd_message.raise_error;
817: end if;
818: end if;
819: end if;
820: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 884: fnd_message.set_name('PQP', 'PQP_230026_INV_RECUR_BONUS_PER');

880: ,p_lookup_type => 'PQP_BONUS_PERIOD'
881: ,p_lookup_code => p_recurring_bonus_period
882: ) then
883: -- Error: Invalid Recurring Bonus Period
884: fnd_message.set_name('PQP', 'PQP_230026_INV_RECUR_BONUS_PER');
885: fnd_message.raise_error;
886: end if;
887: end if;
888: end if;

Line 885: fnd_message.raise_error;

881: ,p_lookup_code => p_recurring_bonus_period
882: ) then
883: -- Error: Invalid Recurring Bonus Period
884: fnd_message.set_name('PQP', 'PQP_230026_INV_RECUR_BONUS_PER');
885: fnd_message.raise_error;
886: end if;
887: end if;
888: end if;
889: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 953: fnd_message.set_name('PQP', 'PQP_230027_INV_NON_RECUR_BONUS');

949: ,p_lookup_type => 'PQP_BONUS_PERIOD'
950: ,p_lookup_code => p_non_recurring_bonus_period
951: ) then
952: -- Error: Invalid Non Recurring Bonus Period
953: fnd_message.set_name('PQP', 'PQP_230027_INV_NON_RECUR_BONUS');
954: fnd_message.raise_error;
955: end if;
956: end if;
957: end if;

Line 954: fnd_message.raise_error;

950: ,p_lookup_code => p_non_recurring_bonus_period
951: ) then
952: -- Error: Invalid Non Recurring Bonus Period
953: fnd_message.set_name('PQP', 'PQP_230027_INV_NON_RECUR_BONUS');
954: fnd_message.raise_error;
955: end if;
956: end if;
957: end if;
958: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1054: fnd_message.set_name('PQP', 'PQP_230028_INV_PEN_SAL_BALANCE');

1050:
1051: if csr_chk_for_dimension%NOTFOUND then
1052: -- Error: Invalid Pension Salary Balance
1053: close csr_chk_for_dimension;
1054: fnd_message.set_name('PQP', 'PQP_230028_INV_PEN_SAL_BALANCE');
1055: fnd_message.raise_error;
1056: else
1057: close csr_chk_for_dimension;
1058: end if;

Line 1055: fnd_message.raise_error;

1051: if csr_chk_for_dimension%NOTFOUND then
1052: -- Error: Invalid Pension Salary Balance
1053: close csr_chk_for_dimension;
1054: fnd_message.set_name('PQP', 'PQP_230028_INV_PEN_SAL_BALANCE');
1055: fnd_message.raise_error;
1056: else
1057: close csr_chk_for_dimension;
1058: end if;
1059: end if;

Line 1125: fnd_message.set_name('PQP', 'PQP_230130_INV_EE_AGE_THRESH');

1121: ,p_lookup_type => 'PQP_YES_NO'
1122: ,p_lookup_code => p_ee_age_threshold
1123: ) then
1124: -- Error: Invalid Age Dependant Employee Threshold
1125: fnd_message.set_name('PQP', 'PQP_230130_INV_EE_AGE_THRESH');
1126: fnd_message.raise_error;
1127: end if;
1128: end if;
1129: end if;

Line 1126: fnd_message.raise_error;

1122: ,p_lookup_code => p_ee_age_threshold
1123: ) then
1124: -- Error: Invalid Age Dependant Employee Threshold
1125: fnd_message.set_name('PQP', 'PQP_230130_INV_EE_AGE_THRESH');
1126: fnd_message.raise_error;
1127: end if;
1128: end if;
1129: end if;
1130: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1194: fnd_message.set_name('PQP', 'PQP_230131_INV_ER_AGE_THRESH');

1190: ,p_lookup_type => 'PQP_YES_NO'
1191: ,p_lookup_code => p_er_age_threshold
1192: ) then
1193: -- Error: Invalid Age Dependant Employer Threshold
1194: fnd_message.set_name('PQP', 'PQP_230131_INV_ER_AGE_THRESH');
1195: fnd_message.raise_error;
1196: end if;
1197: end if;
1198: end if;

Line 1195: fnd_message.raise_error;

1191: ,p_lookup_code => p_er_age_threshold
1192: ) then
1193: -- Error: Invalid Age Dependant Employer Threshold
1194: fnd_message.set_name('PQP', 'PQP_230131_INV_ER_AGE_THRESH');
1195: fnd_message.raise_error;
1196: end if;
1197: end if;
1198: end if;
1199: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1263: fnd_message.set_name('PQP', 'PQP_230132_INV_EE_AGE_CONTRIB');

1259: ,p_lookup_type => 'PQP_YES_NO'
1260: ,p_lookup_code => p_ee_age_contribution
1261: ) then
1262: -- Error: Invalid Age Dependant Employee Contribution
1263: fnd_message.set_name('PQP', 'PQP_230132_INV_EE_AGE_CONTRIB');
1264: fnd_message.raise_error;
1265: end if;
1266: end if;
1267: end if;

Line 1264: fnd_message.raise_error;

1260: ,p_lookup_code => p_ee_age_contribution
1261: ) then
1262: -- Error: Invalid Age Dependant Employee Contribution
1263: fnd_message.set_name('PQP', 'PQP_230132_INV_EE_AGE_CONTRIB');
1264: fnd_message.raise_error;
1265: end if;
1266: end if;
1267: end if;
1268: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1332: fnd_message.set_name('PQP', 'PQP_230133_INV_ER_AGE_CONTRIB');

1328: ,p_lookup_type => 'PQP_YES_NO'
1329: ,p_lookup_code => p_er_age_contribution
1330: ) then
1331: -- Error: Invalid Age Dependant Employer Contribution
1332: fnd_message.set_name('PQP', 'PQP_230133_INV_ER_AGE_CONTRIB');
1333: fnd_message.raise_error;
1334: end if;
1335: end if;
1336: end if;

Line 1333: fnd_message.raise_error;

1329: ,p_lookup_code => p_er_age_contribution
1330: ) then
1331: -- Error: Invalid Age Dependant Employer Contribution
1332: fnd_message.set_name('PQP', 'PQP_230133_INV_ER_AGE_CONTRIB');
1333: fnd_message.raise_error;
1334: end if;
1335: end if;
1336: end if;
1337: hr_utility.set_location(' Leaving:'|| l_proc, 20);

Line 1445: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1441: close csr_sec_grp;
1442: --
1443: -- The primary key is invalid therefore we must error
1444: --
1445: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1446: hr_multi_message.add
1447: (p_associated_column1
1448: => nvl(p_associated_column1,'PENSION_TYPE_ID')
1449: );

Line 1526: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1522: --
1523: -- The primary key is invalid therefore we must error
1524: --
1525: close csr_leg_code;
1526: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1527: fnd_message.raise_error;
1528: end if;
1529: hr_utility.set_location(l_proc,30);
1530: --

Line 1527: fnd_message.raise_error;

1523: -- The primary key is invalid therefore we must error
1524: --
1525: close csr_leg_code;
1526: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1527: fnd_message.raise_error;
1528: end if;
1529: hr_utility.set_location(l_proc,30);
1530: --
1531: -- Set the global variables so the values are

Line 1860: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

1856: (p_pension_type_id => p_rec.pension_type_id
1857: ,p_effective_date => p_effective_date
1858: ,p_object_version_number => p_rec.object_version_number
1859: ) THEN
1860: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1861: fnd_message.set_token('PROCEDURE ', l_proc);
1862: fnd_message.set_token('STEP ', '5');
1863: fnd_message.raise_error;
1864: END IF;

Line 1861: fnd_message.set_token('PROCEDURE ', l_proc);

1857: ,p_effective_date => p_effective_date
1858: ,p_object_version_number => p_rec.object_version_number
1859: ) THEN
1860: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1861: fnd_message.set_token('PROCEDURE ', l_proc);
1862: fnd_message.set_token('STEP ', '5');
1863: fnd_message.raise_error;
1864: END IF;
1865: --

Line 1862: fnd_message.set_token('STEP ', '5');

1858: ,p_object_version_number => p_rec.object_version_number
1859: ) THEN
1860: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1861: fnd_message.set_token('PROCEDURE ', l_proc);
1862: fnd_message.set_token('STEP ', '5');
1863: fnd_message.raise_error;
1864: END IF;
1865: --
1866: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 1863: fnd_message.raise_error;

1859: ) THEN
1860: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1861: fnd_message.set_token('PROCEDURE ', l_proc);
1862: fnd_message.set_token('STEP ', '5');
1863: fnd_message.raise_error;
1864: END IF;
1865: --
1866: -- EDIT_HERE: Add checks to ensure non-updateable args have
1867: -- not been updated.

Line 1942: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1938: --
1939: -- An unhandled or unexpected error has occurred which
1940: -- we must report
1941: --
1942: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1943: fnd_message.set_token('PROCEDURE', l_proc);
1944: fnd_message.set_token('STEP','15');
1945: fnd_message.raise_error;
1946: End dt_update_validate;

Line 1943: fnd_message.set_token('PROCEDURE', l_proc);

1939: -- An unhandled or unexpected error has occurred which
1940: -- we must report
1941: --
1942: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1943: fnd_message.set_token('PROCEDURE', l_proc);
1944: fnd_message.set_token('STEP','15');
1945: fnd_message.raise_error;
1946: End dt_update_validate;
1947: --

Line 1944: fnd_message.set_token('STEP','15');

1940: -- we must report
1941: --
1942: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1943: fnd_message.set_token('PROCEDURE', l_proc);
1944: fnd_message.set_token('STEP','15');
1945: fnd_message.raise_error;
1946: End dt_update_validate;
1947: --
1948: -- ----------------------------------------------------------------------------

Line 1945: fnd_message.raise_error;

1941: --
1942: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1943: fnd_message.set_token('PROCEDURE', l_proc);
1944: fnd_message.set_token('STEP','15');
1945: fnd_message.raise_error;
1946: End dt_update_validate;
1947: --
1948: -- ----------------------------------------------------------------------------
1949: -- |--------------------------< dt_delete_validate >--------------------------|

Line 2039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2035: --
2036: -- An unhandled or unexpected error has occurred which
2037: -- we must report
2038: --
2039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2040: fnd_message.set_token('PROCEDURE', l_proc);
2041: fnd_message.set_token('STEP','15');
2042: fnd_message.raise_error;
2043: --

Line 2040: fnd_message.set_token('PROCEDURE', l_proc);

2036: -- An unhandled or unexpected error has occurred which
2037: -- we must report
2038: --
2039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2040: fnd_message.set_token('PROCEDURE', l_proc);
2041: fnd_message.set_token('STEP','15');
2042: fnd_message.raise_error;
2043: --
2044: End dt_delete_validate;

Line 2041: fnd_message.set_token('STEP','15');

2037: -- we must report
2038: --
2039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2040: fnd_message.set_token('PROCEDURE', l_proc);
2041: fnd_message.set_token('STEP','15');
2042: fnd_message.raise_error;
2043: --
2044: End dt_delete_validate;
2045: --

Line 2042: fnd_message.raise_error;

2038: --
2039: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2040: fnd_message.set_token('PROCEDURE', l_proc);
2041: fnd_message.set_token('STEP','15');
2042: fnd_message.raise_error;
2043: --
2044: End dt_delete_validate;
2045: --
2046: -- ----------------------------------------------------------------------------

Line 2827: fnd_message.set_name('PQP','PQP_230048_ORG_INFO_EXISTS');

2823: FETCH c_chk_org_info INTO l_org_info_exists;
2824: If c_chk_org_info%FOUND THEN
2825: CLOSE c_chk_org_info;
2826: hr_utility.set_location('Found org info for the PT'||l_proc,30);
2827: fnd_message.set_name('PQP','PQP_230048_ORG_INFO_EXISTS');
2828: hr_multi_message.add();
2829: Else
2830: CLOSE c_chk_org_info;
2831: End If;

Line 2839: fnd_message.set_name('PQP','PQP_230049_ASG_INFO_EXISTS');

2835: FETCH c_chk_asg_info INTO l_asg_info_exists;
2836: If c_chk_asg_info%FOUND THEN
2837: CLOSE c_chk_asg_info;
2838: hr_utility.set_location('Found ASG info for the PT'||l_proc,40);
2839: fnd_message.set_name('PQP','PQP_230049_ASG_INFO_EXISTS');
2840: hr_multi_message.add();
2841: Else
2842: CLOSE c_chk_asg_info;
2843: End If;

Line 2866: fnd_message.set_name('PQP','PQP_230050_FUTURE_ORG_INFO');

2862: END LOOP;
2863:
2864: If l_max_org_end_dt <> p_effective_date THEN
2865: hr_utility.set_location('Found future dates org eit rows'||l_proc,60);
2866: fnd_message.set_name('PQP','PQP_230050_FUTURE_ORG_INFO');
2867: fnd_message.set_token('ENDDATE',to_char(l_max_org_end_dt));
2868: hr_multi_message.add();
2869: End If;
2870:

Line 2867: fnd_message.set_token('ENDDATE',to_char(l_max_org_end_dt));

2863:
2864: If l_max_org_end_dt <> p_effective_date THEN
2865: hr_utility.set_location('Found future dates org eit rows'||l_proc,60);
2866: fnd_message.set_name('PQP','PQP_230050_FUTURE_ORG_INFO');
2867: fnd_message.set_token('ENDDATE',to_char(l_max_org_end_dt));
2868: hr_multi_message.add();
2869: End If;
2870:
2871: -- loop through all asg info rows and fetch the end date greatest than the eff date

Line 2881: fnd_message.set_name('PQP','PQP_230051_FUTURE_ASG_INFO');

2877: END LOOP;
2878: -- hr_utility.trace_off;
2879: If l_max_asg_end_dt <> p_effective_date THEN
2880: hr_utility.set_location('found future dates asg eit rows'||l_proc,70);
2881: fnd_message.set_name('PQP','PQP_230051_FUTURE_ASG_INFO');
2882: fnd_message.set_token('ENDDATE',to_char(l_max_asg_end_dt));
2883: hr_multi_message.add();
2884: End If;
2885:

Line 2882: fnd_message.set_token('ENDDATE',to_char(l_max_asg_end_dt));

2878: -- hr_utility.trace_off;
2879: If l_max_asg_end_dt <> p_effective_date THEN
2880: hr_utility.set_location('found future dates asg eit rows'||l_proc,70);
2881: fnd_message.set_name('PQP','PQP_230051_FUTURE_ASG_INFO');
2882: fnd_message.set_token('ENDDATE',to_char(l_max_asg_end_dt));
2883: hr_multi_message.add();
2884: End If;
2885:
2886: End If; -- end of date track mode DELETE/ZAP validations

Line 2917: fnd_message.set_name('PQP','PQP_230048_ORG_INFO_EXISTS');

2913: --
2914: IF c_chk_pggm_org_info%FOUND THEN
2915: CLOSE c_chk_pggm_org_info;
2916: hr_utility.set_location('Found org info for the PT'||l_proc,30);
2917: fnd_message.set_name('PQP','PQP_230048_ORG_INFO_EXISTS');
2918: hr_multi_message.add();
2919: ELSE
2920: CLOSE c_chk_pggm_org_info;
2921: END IF;

Line 2935: fnd_message.set_name('PQP','PQP_2300XX_SCHEME_INFO_EXISTS');

2931:
2932: IF c_pggm_scheme%FOUND THEN
2933: CLOSE c_pggm_scheme;
2934: hr_utility.set_location('Found scheme info for the PT'||l_proc,30);
2935: fnd_message.set_name('PQP','PQP_2300XX_SCHEME_INFO_EXISTS');
2936: hr_multi_message.add();
2937: ELSE
2938: CLOSE c_pggm_scheme;
2939: END IF;