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.GHR_WF_PD_PKG dependencies on HR_UTILITY

Line 384: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

380: fetch csr_pd_routing_history into l_pd_routing_history_id;
381: if csr_pd_routing_history%notfound then
382: null;
383: -- ?? Check with ****
384: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
385: -- hr_utility.raise_error;
386: end if;
387: close csr_pd_routing_history;
388: --

Line 385: -- hr_utility.raise_error;

381: if csr_pd_routing_history%notfound then
382: null;
383: -- ?? Check with ****
384: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
385: -- hr_utility.raise_error;
386: end if;
387: close csr_pd_routing_history;
388: --
389: -- Get Routing Details

Line 395: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

391: fetch csr_pd_routing_details into l_action_taken, l_user_name, l_groupbox_id;
392: if csr_pd_routing_details%notfound then
393: null;
394: -- ?? Check with ****
395: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
396: -- hr_utility.raise_error;
397: end if;
398: close csr_pd_routing_details;
399: --

Line 396: -- hr_utility.raise_error;

392: if csr_pd_routing_details%notfound then
393: null;
394: -- ?? Check with ****
395: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
396: -- hr_utility.raise_error;
397: end if;
398: close csr_pd_routing_details;
399: --
400: --

Line 413: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');

409: p_groupbox_name := l_groupbox_name;
410: if csr_groupbox_details%notfound then
411: null;
412: -- ?? Check with ****
413: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
414: -- hr_utility.raise_error;
415: end if;
416: close csr_groupbox_details;
417: end if;

Line 414: -- hr_utility.raise_error;

410: if csr_groupbox_details%notfound then
411: null;
412: -- ?? Check with ****
413: -- hr_utility.set_message(8301,'GHR_38211_NOA_FAMILY_NOTFOUND');
414: -- hr_utility.raise_error;
415: end if;
416: close csr_groupbox_details;
417: end if;
418: elsif l_action_taken in ('CANCELED','CLASSIFIED','RECLASSIFIED') then

Line 502: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');

498:
499: open csr_pd_details;
500: fetch csr_pd_details into l_category, l_routing_group_id;
501: if csr_pd_details%notfound then
502: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');
503: hr_utility.raise_error;
504: end if;
505: close csr_pd_details;
506: if l_routing_group_id Is Not Null then

Line 503: hr_utility.raise_error;

499: open csr_pd_details;
500: fetch csr_pd_details into l_category, l_routing_group_id;
501: if csr_pd_details%notfound then
502: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');
503: hr_utility.raise_error;
504: end if;
505: close csr_pd_details;
506: if l_routing_group_id Is Not Null then
507: open csr_rgps;

Line 510: hr_utility.set_message(8301,'GHR_38050_INV_ROUTING_GROUP');

506: if l_routing_group_id Is Not Null then
507: open csr_rgps;
508: fetch csr_rgps into l_routing_group_name, l_description;
509: if csr_rgps%notfound then
510: hr_utility.set_message(8301,'GHR_38050_INV_ROUTING_GROUP');
511: hr_utility.raise_error;
512: end if;
513: close csr_rgps;
514: end if;

Line 511: hr_utility.raise_error;

507: open csr_rgps;
508: fetch csr_rgps into l_routing_group_name, l_description;
509: if csr_rgps%notfound then
510: hr_utility.set_message(8301,'GHR_38050_INV_ROUTING_GROUP');
511: hr_utility.raise_error;
512: end if;
513: close csr_rgps;
514: end if;
515: open csr_pdc;

Line 628: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');

624: begin
625: open csr_pdh;
626: fetch csr_pdh into l_item_key;
627: if csr_pdh%notfound then
628: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');
629: hr_utility.raise_error;
630: else
631: wf_engine.CompleteActivity('OF8', l_item_key, 'GH_NOTIFY_PD','COMPLETE');
632: end if;

Line 629: hr_utility.raise_error;

625: open csr_pdh;
626: fetch csr_pdh into l_item_key;
627: if csr_pdh%notfound then
628: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');
629: hr_utility.raise_error;
630: else
631: wf_engine.CompleteActivity('OF8', l_item_key, 'GH_NOTIFY_PD','COMPLETE');
632: end if;
633: close csr_pdh;

Line 775: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');

771: aname => 'PD_ID');
772: open csr_pdh;
773: fetch csr_pdh into l_action_taken;
774: if csr_pdh%notfound then
775: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');
776: hr_utility.raise_error;
777: end if;
778: close csr_pdh;
779: l_load_form := 'GHRWSPDI:p_position_description_id=' || l_position_description_id

Line 776: hr_utility.raise_error;

772: open csr_pdh;
773: fetch csr_pdh into l_action_taken;
774: if csr_pdh%notfound then
775: hr_utility.set_message(8301,'GHR_PD_ID_PRIMARY_KEY_INVALID');
776: hr_utility.raise_error;
777: end if;
778: close csr_pdh;
779: l_load_form := 'GHRWSPDI:p_position_description_id=' || l_position_description_id
780: || ' p_inbox_query_only="YES"';