DBA Data[Home] [Help]

APPS.HR_PER_TYPE_USAGE_INTERNAL dependencies on FND_MESSAGE

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

663: hr_utility.set_location(l_proc, 20);
664: end if;
665: --
666: close csr_delete_person_type_usages;
667: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE',l_proc);
669: fnd_message.set_token('STEP',10);
670: fnd_message.raise_error;
671: else

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

664: end if;
665: --
666: close csr_delete_person_type_usages;
667: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE',l_proc);
669: fnd_message.set_token('STEP',10);
670: fnd_message.raise_error;
671: else
672: --

Line 669: fnd_message.set_token('STEP',10);

665: --
666: close csr_delete_person_type_usages;
667: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE',l_proc);
669: fnd_message.set_token('STEP',10);
670: fnd_message.raise_error;
671: else
672: --
673: if g_debug then

Line 670: fnd_message.raise_error;

666: close csr_delete_person_type_usages;
667: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
668: fnd_message.set_token('PROCEDURE',l_proc);
669: fnd_message.set_token('STEP',10);
670: fnd_message.raise_error;
671: else
672: --
673: if g_debug then
674: hr_utility.set_location(l_proc, 30);

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

717: hr_utility.set_location(l_proc, 50);
718: end if;
719: --
720: close csr_person_types;
721: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE',l_proc);
723: fnd_message.set_token('STEP',20);
724: fnd_message.raise_error;
725: else

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

718: end if;
719: --
720: close csr_person_types;
721: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE',l_proc);
723: fnd_message.set_token('STEP',20);
724: fnd_message.raise_error;
725: else
726: --

Line 723: fnd_message.set_token('STEP',20);

719: --
720: close csr_person_types;
721: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE',l_proc);
723: fnd_message.set_token('STEP',20);
724: fnd_message.raise_error;
725: else
726: --
727: if g_debug then

Line 724: fnd_message.raise_error;

720: close csr_person_types;
721: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
722: fnd_message.set_token('PROCEDURE',l_proc);
723: fnd_message.set_token('STEP',20);
724: fnd_message.raise_error;
725: else
726: --
727: if g_debug then
728: hr_utility.set_location(l_proc, 60);

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

1055: hr_utility.set_location('cancel_person_type_usage.c_person_type_usage_id = '||to_char(c_person_type_usage_id),12);
1056: end if;
1057: exception
1058: when no_data_found then
1059: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
1060: fnd_message.set_token('PROCEDURE',l_proc);
1061: fnd_message.set_token('STEP',13);
1062: fnd_message.raise_error;
1063: end;

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

1056: end if;
1057: exception
1058: when no_data_found then
1059: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
1060: fnd_message.set_token('PROCEDURE',l_proc);
1061: fnd_message.set_token('STEP',13);
1062: fnd_message.raise_error;
1063: end;
1064: --

Line 1061: fnd_message.set_token('STEP',13);

1057: exception
1058: when no_data_found then
1059: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
1060: fnd_message.set_token('PROCEDURE',l_proc);
1061: fnd_message.set_token('STEP',13);
1062: fnd_message.raise_error;
1063: end;
1064: --
1065: --added following 'if' clause for 2449091

Line 1062: fnd_message.raise_error;

1058: when no_data_found then
1059: fnd_message.set_name('PAY','HR_6153_ALL_PROCEDURE_FAIL');
1060: fnd_message.set_token('PROCEDURE',l_proc);
1061: fnd_message.set_token('STEP',13);
1062: fnd_message.raise_error;
1063: end;
1064: --
1065: --added following 'if' clause for 2449091
1066: --

Line 1424: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');

1420: open csr_ptu_prev_row;
1421: fetch csr_ptu_prev_row into l_ptu_prev_row;
1422: if csr_ptu_prev_row%found then
1423: if l_ptu_prev_row.effective_start_date > p_date_start-1 then
1424: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');
1425: fnd_message.raise_error;
1426: else
1427: update PER_PERSON_TYPE_USAGES_F
1428: set effective_end_date = p_date_start-1,

Line 1425: fnd_message.raise_error;

1421: fetch csr_ptu_prev_row into l_ptu_prev_row;
1422: if csr_ptu_prev_row%found then
1423: if l_ptu_prev_row.effective_start_date > p_date_start-1 then
1424: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');
1425: fnd_message.raise_error;
1426: else
1427: update PER_PERSON_TYPE_USAGES_F
1428: set effective_end_date = p_date_start-1,
1429: object_version_number = object_version_number+1

Line 1443: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');

1439: open csr_prev_other_row;
1440: fetch csr_prev_other_row into l_prev_other_row;
1441: if csr_prev_other_row%found then
1442: if l_prev_other_row.effective_start_date > p_date_start-1 then
1443: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');
1444: fnd_message.raise_error;
1445: else
1446: update PER_PERSON_TYPE_USAGES_F
1447: set effective_end_date = p_date_start-1,

Line 1444: fnd_message.raise_error;

1440: fetch csr_prev_other_row into l_prev_other_row;
1441: if csr_prev_other_row%found then
1442: if l_prev_other_row.effective_start_date > p_date_start-1 then
1443: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');
1444: fnd_message.raise_error;
1445: else
1446: update PER_PERSON_TYPE_USAGES_F
1447: set effective_end_date = p_date_start-1,
1448: object_version_number = object_version_number+1

Line 1474: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');

1470: open csr_ptu_apl_row;
1471: fetch csr_ptu_apl_row into l_prev_other_row;
1472: if csr_ptu_apl_row%found then
1473: if l_prev_other_row.effective_start_date > p_date_start-1 then
1474: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');
1475: fnd_message.raise_error;
1476: else
1477: update PER_PERSON_TYPE_USAGES_F
1478: set effective_end_date = p_date_start-1,

Line 1475: fnd_message.raise_error;

1471: fetch csr_ptu_apl_row into l_prev_other_row;
1472: if csr_ptu_apl_row%found then
1473: if l_prev_other_row.effective_start_date > p_date_start-1 then
1474: fnd_message.set_name('PER','HR_289742_NO_CHG_DATE_PTU');
1475: fnd_message.raise_error;
1476: else
1477: update PER_PERSON_TYPE_USAGES_F
1478: set effective_end_date = p_date_start-1,
1479: object_version_number = object_version_number+1