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_AAT_BUS dependencies on FND_MESSAGE

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

55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;

Line 60: fnd_message.raise_error;

56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --

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

128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --

Line 133: fnd_message.raise_error;

129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are

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

466: (p_assignment_attribute_id => p_rec.assignment_attribute_id
467: ,p_effective_date => p_effective_date
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;

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

467: ,p_effective_date => p_effective_date
468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --

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

468: ,p_object_version_number => p_rec.object_version_number
469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
476: --

Line 473: fnd_message.raise_error;

469: ) THEN
470: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE ', l_proc);
472: fnd_message.set_token('STEP ', '5');
473: fnd_message.raise_error;
474: END IF;
475: --
476: --
477: EXCEPTION

Line 779: fnd_message.set_name('PQP', 'PQP_230527_RATES_TABLE_INVALID');

775: FETCH cur_tbl INTO l_dummy;
776: IF cur_tbl%NOTFOUND THEN
777: -- Error
778: CLOSE cur_tbl;
779: fnd_message.set_name('PQP', 'PQP_230527_RATES_TABLE_INVALID');
780: fnd_message.raise_error;
781: END IF;
782:
783: CLOSE cur_tbl;

Line 780: fnd_message.raise_error;

776: IF cur_tbl%NOTFOUND THEN
777: -- Error
778: CLOSE cur_tbl;
779: fnd_message.set_name('PQP', 'PQP_230527_RATES_TABLE_INVALID');
780: fnd_message.raise_error;
781: END IF;
782:
783: CLOSE cur_tbl;
784:

Line 847: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

843: ,p_lookup_code => p_tp_is_teacher
844: ) then
845:
846: -- Invalid Job Status
847: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
848: fnd_message.set_token('COLUMN_NAME', 'TP_IS_TEACHER');
849: fnd_message.raise_error;
850: end if;
851: hr_utility.set_location(l_proc, 30);

Line 848: fnd_message.set_token('COLUMN_NAME', 'TP_IS_TEACHER');

844: ) then
845:
846: -- Invalid Job Status
847: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
848: fnd_message.set_token('COLUMN_NAME', 'TP_IS_TEACHER');
849: fnd_message.raise_error;
850: end if;
851: hr_utility.set_location(l_proc, 30);
852: end if;

Line 849: fnd_message.raise_error;

845:
846: -- Invalid Job Status
847: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
848: fnd_message.set_token('COLUMN_NAME', 'TP_IS_TEACHER');
849: fnd_message.raise_error;
850: end if;
851: hr_utility.set_location(l_proc, 30);
852: end if;
853: end if;

Line 911: fnd_message.set_name( 'PQP','PQP_230204_TP_INVALID_GRP_CODE');

907: -- and it cannot be possibly '00'
908: if p_tp_is_teacher is not null then
909: if ((p_tp_headteacher_grp_code IS NOT NULL) and ( p_tp_headteacher_grp_code NOT BETWEEN 1 and 99 )) THEN
910: -- Invalid headteacher group code
911: fnd_message.set_name( 'PQP','PQP_230204_TP_INVALID_GRP_CODE');
912: fnd_message.set_token('COLUMN_NAME', 'TP_HEADTEACHER_GRP_CODE' );
913: fnd_message.raise_error;
914: end if;
915: hr_utility.set_location(l_proc, 30);

Line 912: fnd_message.set_token('COLUMN_NAME', 'TP_HEADTEACHER_GRP_CODE' );

908: if p_tp_is_teacher is not null then
909: if ((p_tp_headteacher_grp_code IS NOT NULL) and ( p_tp_headteacher_grp_code NOT BETWEEN 1 and 99 )) THEN
910: -- Invalid headteacher group code
911: fnd_message.set_name( 'PQP','PQP_230204_TP_INVALID_GRP_CODE');
912: fnd_message.set_token('COLUMN_NAME', 'TP_HEADTEACHER_GRP_CODE' );
913: fnd_message.raise_error;
914: end if;
915: hr_utility.set_location(l_proc, 30);
916: end if;

Line 913: fnd_message.raise_error;

909: if ((p_tp_headteacher_grp_code IS NOT NULL) and ( p_tp_headteacher_grp_code NOT BETWEEN 1 and 99 )) THEN
910: -- Invalid headteacher group code
911: fnd_message.set_name( 'PQP','PQP_230204_TP_INVALID_GRP_CODE');
912: fnd_message.set_token('COLUMN_NAME', 'TP_HEADTEACHER_GRP_CODE' );
913: fnd_message.raise_error;
914: end if;
915: hr_utility.set_location(l_proc, 30);
916: end if;
917: end if;

Line 980: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

976: ,p_lookup_type => 'YES_NO'
977: ,p_lookup_code => p_tp_elected_pension
978: ) then
979:
980: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
981: fnd_message.set_token('COLUMN_NAME', 'TP_ELECTED_PENSION');
982: fnd_message.raise_error;
983:
984: end if;

Line 981: fnd_message.set_token('COLUMN_NAME', 'TP_ELECTED_PENSION');

977: ,p_lookup_code => p_tp_elected_pension
978: ) then
979:
980: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
981: fnd_message.set_token('COLUMN_NAME', 'TP_ELECTED_PENSION');
982: fnd_message.raise_error;
983:
984: end if;
985: hr_utility.set_location(l_proc, 30);

Line 982: fnd_message.raise_error;

978: ) then
979:
980: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
981: fnd_message.set_token('COLUMN_NAME', 'TP_ELECTED_PENSION');
982: fnd_message.raise_error;
983:
984: end if;
985: hr_utility.set_location(l_proc, 30);
986: end if;

Line 1077: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

1073: l_FormatValid := 'N';
1074: end;
1075: --
1076: if l_FormatValid = 'N' then
1077: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1078: fnd_message.set_token('COLUMN_NAME', 'TP_SAFEGUARDED_GRADE');
1079: fnd_message.raise_error;
1080: else -- l_FormatValid = 'Y'
1081: -- Validate the grade

Line 1078: fnd_message.set_token('COLUMN_NAME', 'TP_SAFEGUARDED_GRADE');

1074: end;
1075: --
1076: if l_FormatValid = 'N' then
1077: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1078: fnd_message.set_token('COLUMN_NAME', 'TP_SAFEGUARDED_GRADE');
1079: fnd_message.raise_error;
1080: else -- l_FormatValid = 'Y'
1081: -- Validate the grade
1082: begin

Line 1079: fnd_message.raise_error;

1075: --
1076: if l_FormatValid = 'N' then
1077: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1078: fnd_message.set_token('COLUMN_NAME', 'TP_SAFEGUARDED_GRADE');
1079: fnd_message.raise_error;
1080: else -- l_FormatValid = 'Y'
1081: -- Validate the grade
1082: begin
1083: open ChkGradeValid;

Line 1092: fnd_message.set_name('PAY', 'PQP_230573_INVALID_GRADE');

1088: l_GradeValid := 'N';
1089: end;
1090: --
1091: if l_GradeValid = 'N' then
1092: fnd_message.set_name('PAY', 'PQP_230573_INVALID_GRADE');
1093: fnd_message.raise_error;
1094: end if;
1095: end if; -- l_FormatValid = 'N'
1096: hr_utility.set_location(l_proc, 30);

Line 1093: fnd_message.raise_error;

1089: end;
1090: --
1091: if l_GradeValid = 'N' then
1092: fnd_message.set_name('PAY', 'PQP_230573_INVALID_GRADE');
1093: fnd_message.raise_error;
1094: end if;
1095: end if; -- l_FormatValid = 'N'
1096: hr_utility.set_location(l_proc, 30);
1097: end if; -- p_tp_safeguarded_grade is not null

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

1328: --
1329: -- Rule 1
1330: if p_tp_is_teacher is not null then
1331: if p_tp_elected_pension is null then
1332: fnd_message.set_name('PQP', 'PQP_230563_PENSION_FLAG_NULL');
1333: fnd_message.raise_error;
1334: end if;
1335: end if;
1336: hr_utility.set_location(l_proc, 20);

Line 1333: fnd_message.raise_error;

1329: -- Rule 1
1330: if p_tp_is_teacher is not null then
1331: if p_tp_elected_pension is null then
1332: fnd_message.set_name('PQP', 'PQP_230563_PENSION_FLAG_NULL');
1333: fnd_message.raise_error;
1334: end if;
1335: end if;
1336: hr_utility.set_location(l_proc, 20);
1337:

Line 1346: fnd_message.set_name('PQP', 'PQP_230562_JOB_STATUS_NULL');

1342: (p_tp_elected_pension is not null) or
1343: */
1344: if (p_tp_safeguarded_grade is not null) then
1345: if p_tp_is_teacher is null then
1346: fnd_message.set_name('PQP', 'PQP_230562_JOB_STATUS_NULL');
1347: fnd_message.raise_error;
1348: end if;
1349: end if;
1350:

Line 1347: fnd_message.raise_error;

1343: */
1344: if (p_tp_safeguarded_grade is not null) then
1345: if p_tp_is_teacher is null then
1346: fnd_message.set_name('PQP', 'PQP_230562_JOB_STATUS_NULL');
1347: fnd_message.raise_error;
1348: end if;
1349: end if;
1350:
1351: -- Rule 3

Line 1353: fnd_message.set_name('PQP', 'PQP_230574_CAREER_COMBI_ERR');

1349: end if;
1350:
1351: -- Rule 3
1352: if p_tp_fast_track = 'Y' and p_tp_safeguarded_grade is not null then
1353: fnd_message.set_name('PQP', 'PQP_230574_CAREER_COMBI_ERR');
1354: fnd_message.raise_error;
1355: end if;
1356:
1357:

Line 1354: fnd_message.raise_error;

1350:
1351: -- Rule 3
1352: if p_tp_fast_track = 'Y' and p_tp_safeguarded_grade is not null then
1353: fnd_message.set_name('PQP', 'PQP_230574_CAREER_COMBI_ERR');
1354: fnd_message.raise_error;
1355: end if;
1356:
1357:
1358: hr_utility.set_location(' Leaving: '|| l_proc, 30);

Line 1432: fnd_message.set_name('PQP', 'PQP_230207_RATE_GRADE_COMB_ERR');

1428: (p_tp_safeguarded_rate_type = 'SP' and p_tp_safeguarded_grade IS NULL ) or
1429: (p_tp_safeguarded_rate_type = 'SN' and p_tp_safeguarded_grade IS NOT NULL )) then
1430:
1431: --raise error message;
1432: fnd_message.set_name('PQP', 'PQP_230207_RATE_GRADE_COMB_ERR');
1433: fnd_message.raise_error;
1434:
1435: end if;
1436:

Line 1433: fnd_message.raise_error;

1429: (p_tp_safeguarded_rate_type = 'SN' and p_tp_safeguarded_grade IS NOT NULL )) then
1430:
1431: --raise error message;
1432: fnd_message.set_name('PQP', 'PQP_230207_RATE_GRADE_COMB_ERR');
1433: fnd_message.raise_error;
1434:
1435: end if;
1436:
1437:

Line 1447: fnd_message.set_name('PQP', 'PQP_230568_INVALID_RATE_TYPE');

1443: and
1444: --added SN in the following condition to take care for the condition Safeguarded and No Rate requirement
1445: nvl(p_tp_safeguarded_rate_type,'AbXy') not in ('G','SP','SN') then
1446: -- invalid rate type selected
1447: fnd_message.set_name('PQP', 'PQP_230568_INVALID_RATE_TYPE');
1448: fnd_message.raise_error;
1449: else
1450: if p_tp_safeguarded_rate_id is not null then
1451:

Line 1448: fnd_message.raise_error;

1444: --added SN in the following condition to take care for the condition Safeguarded and No Rate requirement
1445: nvl(p_tp_safeguarded_rate_type,'AbXy') not in ('G','SP','SN') then
1446: -- invalid rate type selected
1447: fnd_message.set_name('PQP', 'PQP_230568_INVALID_RATE_TYPE');
1448: fnd_message.raise_error;
1449: else
1450: if p_tp_safeguarded_rate_id is not null then
1451:
1452: begin

Line 1464: fnd_message.set_name('PQP', 'PQP_230569_INVALID_PAY_RATE');

1460:
1461: if l_RateValid = 'N' then
1462:
1463: -- invalid grade or scale rate selected
1464: fnd_message.set_name('PQP', 'PQP_230569_INVALID_PAY_RATE');
1465: fnd_message.raise_error;
1466:
1467: end if;
1468: hr_utility.set_location(l_proc, 30);

Line 1465: fnd_message.raise_error;

1461: if l_RateValid = 'N' then
1462:
1463: -- invalid grade or scale rate selected
1464: fnd_message.set_name('PQP', 'PQP_230569_INVALID_PAY_RATE');
1465: fnd_message.raise_error;
1466:
1467: end if;
1468: hr_utility.set_location(l_proc, 30);
1469: -- the else part is commented out as it is no longer required to check if the rate id is null

Line 1477: -- fnd_message.set_name('PQP', 'PQP_230569_INVALID_PAY_RATE');

1473: /*
1474: else -- p_tp_safeguarded_rate_id is null
1475: --if p_tp_safeguarded_grade is not null then
1476: -- invalid grade or scale rate selected
1477: -- fnd_message.set_name('PQP', 'PQP_230569_INVALID_PAY_RATE');
1478: -- fnd_message.raise_error;
1479: --end if;
1480: */
1481: end if; -- p_tp_safeguarded_rate_id is not null

Line 1478: -- fnd_message.raise_error;

1474: else -- p_tp_safeguarded_rate_id is null
1475: --if p_tp_safeguarded_grade is not null then
1476: -- invalid grade or scale rate selected
1477: -- fnd_message.set_name('PQP', 'PQP_230569_INVALID_PAY_RATE');
1478: -- fnd_message.raise_error;
1479: --end if;
1480: */
1481: end if; -- p_tp_safeguarded_rate_id is not null
1482:

Line 1556: fnd_message.set_name('PQP', 'PQP_230570_INVALID_SPINAL_PNT');

1552:
1553: if l_SPValid = 'N' then
1554:
1555: -- invalid spinal point selected
1556: fnd_message.set_name('PQP', 'PQP_230570_INVALID_SPINAL_PNT');
1557: fnd_message.raise_error;
1558:
1559: end if; -- l_SPValid = 'N'
1560:

Line 1557: fnd_message.raise_error;

1553: if l_SPValid = 'N' then
1554:
1555: -- invalid spinal point selected
1556: fnd_message.set_name('PQP', 'PQP_230570_INVALID_SPINAL_PNT');
1557: fnd_message.raise_error;
1558:
1559: end if; -- l_SPValid = 'N'
1560:
1561: hr_utility.set_location(l_proc, 30);

Line 1568: fnd_message.set_name('PQP', 'PQP_230571_SPINAL_POINT_MUST');

1564: if nvl(p_tp_safeguarded_rate_type,'AbXy') = 'SP' and
1565: p_tp_safeguarded_grade is not null then
1566:
1567: -- spinal point id must be supplied if rate type is SP
1568: fnd_message.set_name('PQP', 'PQP_230571_SPINAL_POINT_MUST');
1569: fnd_message.raise_error;
1570:
1571: end if; -- tp_safeguarded_rate_type = 'SP'
1572: end if; -- p_tp_spinal_point_id is not null

Line 1569: fnd_message.raise_error;

1565: p_tp_safeguarded_grade is not null then
1566:
1567: -- spinal point id must be supplied if rate type is SP
1568: fnd_message.set_name('PQP', 'PQP_230571_SPINAL_POINT_MUST');
1569: fnd_message.raise_error;
1570:
1571: end if; -- tp_safeguarded_rate_type = 'SP'
1572: end if; -- p_tp_spinal_point_id is not null
1573: end if; -- (((p_assignment_attribute_id is not null) and...

Line 1680: fnd_message.set_name('PQP', 'PQP_230572_INVALID_GRADE_SPINE');

1676: end;
1677:
1678: if l_GSValid = 'N' then
1679: -- spinal point is not valid for this grade and scale rate
1680: fnd_message.set_name('PQP', 'PQP_230572_INVALID_GRADE_SPINE');
1681: fnd_message.raise_error;
1682: end if;
1683:
1684: hr_utility.set_location(l_proc, 30);

Line 1681: fnd_message.raise_error;

1677:
1678: if l_GSValid = 'N' then
1679: -- spinal point is not valid for this grade and scale rate
1680: fnd_message.set_name('PQP', 'PQP_230572_INVALID_GRADE_SPINE');
1681: fnd_message.raise_error;
1682: end if;
1683:
1684: hr_utility.set_location(l_proc, 30);
1685: end if; -- (p_tp_spinal_point_id is not null) or

Line 1748: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');

1744: ,p_lookup_type => 'YES_NO'
1745: ,p_lookup_code => p_tp_fast_track
1746: ) then
1747:
1748: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1749: fnd_message.set_token('COLUMN_NAME', 'TP_FAST_TRACK');
1750: fnd_message.raise_error;
1751:
1752: end if;

Line 1749: fnd_message.set_token('COLUMN_NAME', 'TP_FAST_TRACK');

1745: ,p_lookup_code => p_tp_fast_track
1746: ) then
1747:
1748: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1749: fnd_message.set_token('COLUMN_NAME', 'TP_FAST_TRACK');
1750: fnd_message.raise_error;
1751:
1752: end if;
1753: hr_utility.set_location(l_proc, 30);

Line 1750: fnd_message.raise_error;

1746: ) then
1747:
1748: fnd_message.set_name('PAY', 'HR_7462_PLK_INVLD_VALUE');
1749: fnd_message.set_token('COLUMN_NAME', 'TP_FAST_TRACK');
1750: fnd_message.raise_error;
1751:
1752: end if;
1753: hr_utility.set_location(l_proc, 30);
1754: end if;

Line 1835: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

1831: --
1832: -- A referential integrity check was violated therefore
1833: -- we must error
1834: --
1835: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1836: fnd_message.set_token('TABLE_NAME', l_table_name);
1837: fnd_message.raise_error;
1838: When Others Then
1839: --

Line 1836: fnd_message.set_token('TABLE_NAME', l_table_name);

1832: -- A referential integrity check was violated therefore
1833: -- we must error
1834: --
1835: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1836: fnd_message.set_token('TABLE_NAME', l_table_name);
1837: fnd_message.raise_error;
1838: When Others Then
1839: --
1840: -- An unhandled or unexpected error has occurred which

Line 1837: fnd_message.raise_error;

1833: -- we must error
1834: --
1835: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1836: fnd_message.set_token('TABLE_NAME', l_table_name);
1837: fnd_message.raise_error;
1838: When Others Then
1839: --
1840: -- An unhandled or unexpected error has occurred which
1841: -- we must report

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

1839: --
1840: -- An unhandled or unexpected error has occurred which
1841: -- we must report
1842: --
1843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1844: fnd_message.set_token('PROCEDURE', l_proc);
1845: fnd_message.set_token('STEP','15');
1846: fnd_message.raise_error;
1847: End dt_update_validate;

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

1840: -- An unhandled or unexpected error has occurred which
1841: -- we must report
1842: --
1843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1844: fnd_message.set_token('PROCEDURE', l_proc);
1845: fnd_message.set_token('STEP','15');
1846: fnd_message.raise_error;
1847: End dt_update_validate;
1848: --

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

1841: -- we must report
1842: --
1843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1844: fnd_message.set_token('PROCEDURE', l_proc);
1845: fnd_message.set_token('STEP','15');
1846: fnd_message.raise_error;
1847: End dt_update_validate;
1848: --
1849: -- ---------------------------------------------------------------------------+

Line 1846: fnd_message.raise_error;

1842: --
1843: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1844: fnd_message.set_token('PROCEDURE', l_proc);
1845: fnd_message.set_token('STEP','15');
1846: fnd_message.raise_error;
1847: End dt_update_validate;
1848: --
1849: -- ---------------------------------------------------------------------------+
1850: -- |--------------------------< dt_delete_validate >--------------------------|

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

1938: --
1939: -- A referential integrity check was violated therefore
1940: -- we must error
1941: --
1942: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1943: fnd_message.set_token('TABLE_NAME', l_table_name);
1944: fnd_message.raise_error;
1945: When Others Then
1946: --

Line 1943: fnd_message.set_token('TABLE_NAME', l_table_name);

1939: -- A referential integrity check was violated therefore
1940: -- we must error
1941: --
1942: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1943: fnd_message.set_token('TABLE_NAME', l_table_name);
1944: fnd_message.raise_error;
1945: When Others Then
1946: --
1947: -- An unhandled or unexpected error has occurred which

Line 1944: fnd_message.raise_error;

1940: -- we must error
1941: --
1942: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1943: fnd_message.set_token('TABLE_NAME', l_table_name);
1944: fnd_message.raise_error;
1945: When Others Then
1946: --
1947: -- An unhandled or unexpected error has occurred which
1948: -- we must report

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

1946: --
1947: -- An unhandled or unexpected error has occurred which
1948: -- we must report
1949: --
1950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1951: fnd_message.set_token('PROCEDURE', l_proc);
1952: fnd_message.set_token('STEP','15');
1953: fnd_message.raise_error;
1954: --

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

1947: -- An unhandled or unexpected error has occurred which
1948: -- we must report
1949: --
1950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1951: fnd_message.set_token('PROCEDURE', l_proc);
1952: fnd_message.set_token('STEP','15');
1953: fnd_message.raise_error;
1954: --
1955: End dt_delete_validate;

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

1948: -- we must report
1949: --
1950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1951: fnd_message.set_token('PROCEDURE', l_proc);
1952: fnd_message.set_token('STEP','15');
1953: fnd_message.raise_error;
1954: --
1955: End dt_delete_validate;
1956: --

Line 1953: fnd_message.raise_error;

1949: --
1950: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1951: fnd_message.set_token('PROCEDURE', l_proc);
1952: fnd_message.set_token('STEP','15');
1953: fnd_message.raise_error;
1954: --
1955: End dt_delete_validate;
1956: --
1957: -- ---------------------------------------------------------------------------+