282: IS
283: BEGIN
284:
285: IF (p_notification_action_code <>
286: hxc_app_comp_notifications_api.c_action_request_appr_resend
287: )
288: THEN
289: IF (p_notification_number_retries <> 0)
290: THEN
332: ) is
333: begin
334: if p_notification_action_code not in
335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
333: begin
334: if p_notification_action_code not in
335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
334: if p_notification_action_code not in
335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
335: (
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
336: hxc_app_comp_notifications_api.C_ACTION_APPROVED
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )
337: ,hxc_app_comp_notifications_api.C_ACTION_AUTO_APPROVE
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )
345: then
338: ,hxc_app_comp_notifications_api.C_ACTION_ERROR
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )
345: then
346: hr_utility.set_message(809,'HXC_ACTION_CODE');
339: ,hxc_app_comp_notifications_api.C_ACTION_REJECTED
340: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPROVAL
341: ,hxc_app_comp_notifications_api.C_ACTION_REQUEST_APPR_RESEND
342: ,hxc_app_comp_notifications_api.C_ACTION_SUBMISSION
343: ,hxc_app_comp_notifications_api.C_ACTION_TRANSFER
344: )
345: then
346: hr_utility.set_message(809,'HXC_ACTION_CODE');
347: hr_utility.raise_error;
358: ) is
359: begin
360: if p_notification_recipient_code not in
361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
359: begin
360: if p_notification_recipient_code not in
361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
360: if p_notification_recipient_code not in
361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )
361: (
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )
369: then
362: hxc_app_comp_notifications_api.C_RECIPIENT_ADMIN
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )
369: then
370: hr_utility.set_message(809,'HXC_RECIPIENT_CODE');
363: ,hxc_app_comp_notifications_api.C_RECIPIENT_APPROVER
364: ,hxc_app_comp_notifications_api.C_RECIPIENT_ERROR_ADMIN
365: ,hxc_app_comp_notifications_api.C_RECIPIENT_PREPARER
366: ,hxc_app_comp_notifications_api.C_RECIPIENT_SUPERVISOR
367: ,hxc_app_comp_notifications_api.C_RECIPIENT_WORKER
368: )
369: then
370: hr_utility.set_message(809,'HXC_RECIPIENT_CODE');
371: hr_utility.raise_error;