APPS.HR_OFFER_CUSTOM dependencies on HR_UTILITY

Line 782: hr_utility.raise_error;

778: else
779: -- the assignment was not found as of the sysdate. this is a fatal error
780: -- which we must raise
781: fnd_message.set_name('PER', 'HR_ASG_DOES_NOT_EXIST');
782: hr_utility.raise_error;
783: end if;
784: -- commit any outstanding changes
785: -- commit;
786: --

Line 891: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

887: --
888: open csr_get_category_id (csr_p_lang => l_language);
889: fetch csr_get_category_id into l_category_id;
890: if csr_get_category_id%notfound then
891: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
892: hr_utility.raise_error;
893: end if;
894: close csr_get_category_id;
895: --

Line 892: hr_utility.raise_error;

888: open csr_get_category_id (csr_p_lang => l_language);
889: fetch csr_get_category_id into l_category_id;
890: if csr_get_category_id%notfound then
891: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
892: hr_utility.raise_error;
893: end if;
894: close csr_get_category_id;
895: --
896: -- get sequence id for attached_document_id

Line 1291: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1287: -- -------------------------------------------------------------------------
1288: open csr_get_category_id (csr_p_lang => l_language);
1289: fetch csr_get_category_id into l_category_id;
1290: if csr_get_category_id%notfound then
1291: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1292: hr_utility.raise_error;
1293: end if;
1294: close csr_get_category_id;
1295: --

Line 1292: hr_utility.raise_error;

1288: open csr_get_category_id (csr_p_lang => l_language);
1289: fetch csr_get_category_id into l_category_id;
1290: if csr_get_category_id%notfound then
1291: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1292: hr_utility.raise_error;
1293: end if;
1294: close csr_get_category_id;
1295: --
1296: -- -------------------------------------------------------------------------

Line 1312: raise hr_utility.hr_error;

1308: fetch csr_documents_tl into l_media_id;
1309: IF csr_documents_tl%NOTFOUND THEN
1310: close csr_attached_documents;
1311: close csr_documents_tl;
1312: raise hr_utility.hr_error;
1313: ELSE
1314: open csr_documents_long_text(csr_p_media_id => l_media_id);
1315: fetch csr_documents_long_text into l_attachment_text;
1316: IF csr_documents_long_text%NOTFOUND THEN

Line 1320: raise hr_utility.hr_error;

1316: IF csr_documents_long_text%NOTFOUND THEN
1317: close csr_attached_documents;
1318: close csr_documents_tl;
1319: close csr_documents_long_text;
1320: raise hr_utility.hr_error;
1321: ELSE
1322: close csr_attached_documents;
1323: close csr_documents_tl;
1324: close csr_documents_long_text;

Line 1338: when hr_utility.hr_error THEN

1334: p_category_id := l_category_id;
1335: p_seq_num := l_seq_num;
1336:
1337: exception
1338: when hr_utility.hr_error THEN
1339: p_attachment_text := null;
1340: p_attached_document_id := null;
1341: p_document_id := null;
1342: p_media_id := null;