DBA Data[Home] [Help]

APPS.PQH_SS_WORKFLOW dependencies on HR_UTILITY

Line 619: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);

615: --
616: --
617: EXCEPTION
618: WHEN OTHERS THEN
619: hr_utility.trace(' exception in '||g_package||'.complete_wf_activity : ' || sqlerrm);
620: Wf_Core.Context(g_package, 'complete_wf_activity', p_itemType, p_itemKey);
621: raise;
622: --
623: END complete_wf_activity;

Line 733: hr_utility.trace(' exception in '||g_package||'.start_approval_wf : ' || sqlerrm);

729: --
730: --
731: EXCEPTION
732: WHEN OTHERS THEN
733: hr_utility.trace(' exception in '||g_package||'.start_approval_wf : ' || sqlerrm);
734: Wf_Core.Context(g_package, 'start_approval_wf', itemType, itemKey);
735: raise;
736: --
737: END start_approval_wf;

Line 1216: hr_utility.trace(' exception in '||g_package||'.get_transaction_info : ' || sqlerrm);

1212: END IF;
1213: --
1214: EXCEPTION
1215: WHEN OTHERS THEN
1216: hr_utility.trace(' exception in '||g_package||'.get_transaction_info : ' || sqlerrm);
1217: raise;
1218: --
1219: END get_transaction_info;
1220: --

Line 1369: hr_utility.trace(' exception in '||g_package||'.revert_to_last_save : ' || sqlerrm);

1365:
1366: --
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: hr_utility.trace(' exception in '||g_package||'.revert_to_last_save : ' || sqlerrm);
1370: raise;
1371: --
1372: END revert_to_last_save;
1373:

Line 1443: hr_utility.trace(' exception in '||g_package||'.get_url_for_edit : ' || sqlerrm);

1439: --
1440: --
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: hr_utility.trace(' exception in '||g_package||'.get_url_for_edit : ' || sqlerrm);
1444: raise;
1445: --
1446: END get_url_for_edit;
1447: --

Line 1686: hr_utility.trace(' exception in '||g_package||'.set_transaction_status : ' || sqlerrm);

1682: --
1683: --
1684: EXCEPTION
1685: WHEN OTHERS THEN
1686: hr_utility.trace(' exception in '||g_package||'.set_transaction_status : ' || sqlerrm);
1687: raise;
1688: --
1689: END set_transaction_status;
1690:

Line 1731: hr_utility.trace(' exception in '||g_package||'.set_txn_approve_status : ' || sqlerrm);

1727: --
1728: --
1729: EXCEPTION
1730: WHEN OTHERS THEN
1731: hr_utility.trace(' exception in '||g_package||'.set_txn_approve_status : ' || sqlerrm);
1732: Wf_Core.Context(g_package, 'set_txn_approve_status', itemType, itemKey);
1733: raise;
1734: --
1735: END set_txn_approve_status;

Line 1759: hr_utility.trace(' exception in '||g_package||'.set_txn_rfc_status : ' || sqlerrm);

1755: END IF;
1756:
1757: EXCEPTION
1758: WHEN OTHERS THEN
1759: hr_utility.trace(' exception in '||g_package||'.set_txn_rfc_status : ' || sqlerrm);
1760: Wf_Core.Context(g_package, 'set_txn_rfc_status', itemType, itemKey);
1761: raise;
1762: --
1763: END set_txn_rfc_status;

Line 1792: hr_utility.trace(' exception in '||g_package||'.set_txn_sfl_status : ' || sqlerrm);

1788: END IF;
1789:
1790: EXCEPTION
1791: WHEN OTHERS THEN
1792: hr_utility.trace(' exception in '||g_package||'.set_txn_sfl_status : ' || sqlerrm);
1793: Wf_Core.Context(g_package, 'set_txn_sfl_status', itemType, itemKey);
1794: raise;
1795: END set_txn_sfl_status;
1796: --

Line 1877: hr_utility.trace(' exception in '||g_package||'.set_effective_date_and_option : ' || sqlerrm);

1873: --
1874: --
1875: EXCEPTION
1876: WHEN OTHERS THEN
1877: hr_utility.trace(' exception in '||g_package||'.set_effective_date_and_option : ' || sqlerrm);
1878: raise;
1879: --
1880: END set_effective_date_and_option;
1881: --

Line 1980: hr_utility.trace(' exception in '||g_package||'.reset_txn_current_values : ' || sqlerrm);

1976: --
1977: --
1978: EXCEPTION
1979: WHEN OTHERS THEN
1980: hr_utility.trace(' exception in '||g_package||'.reset_txn_current_values : ' || sqlerrm);
1981: Wf_Core.Context(g_package, 'reset_txn_current_values', itemType, itemKey);
1982: raise;
1983: --
1984: END reset_txn_current_values;

Line 2038: hr_utility.trace(' exception in '||g_package||'.check_initial_save_for_later : ' || sqlerrm);

2034: --
2035: --
2036: EXCEPTION
2037: WHEN OTHERS THEN
2038: hr_utility.trace(' exception in '||g_package||'.check_initial_save_for_later : ' || sqlerrm);
2039: Wf_Core.Context(g_package, 'check_initial_save_for_later', itemType, itemKey);
2040: raise;
2041: --
2042: END check_initial_save_for_later;

Line 2314: hr_utility.trace(' exception in '||g_package||'.return_for_correction : ' || sqlerrm);

2310: COMMIT;
2311: --
2312: EXCEPTION
2313: WHEN OTHERS THEN
2314: hr_utility.trace(' exception in '||g_package||'.return_for_correction : ' || sqlerrm);
2315: raise;
2316: --
2317: END return_for_correction;
2318: --

Line 2433: hr_utility.trace(' exception in '||g_package||'.get_edit_link : ' || sqlerrm);

2429: END IF;
2430: --
2431: EXCEPTION
2432: WHEN OTHERS THEN
2433: hr_utility.trace(' exception in '||g_package||'.get_edit_link : ' || sqlerrm);
2434: raise;
2435: --
2436: END get_edit_link;
2437: --

Line 2512: hr_utility.trace(' exception in '||g_package||'.set_date_if_as_of_approval : ' || sqlerrm);

2508: --
2509: --
2510: EXCEPTION
2511: WHEN OTHERS THEN
2512: hr_utility.trace(' exception in '||g_package||'.set_date_if_as_of_approval : ' || sqlerrm);
2513: Wf_Core.Context(g_package, 'set_date_if_as_of_approval', itemType, itemKey);
2514: raise;
2515: --
2516: END set_date_if_as_of_approval;

Line 2569: hr_utility.set_message(ln_app_id,p_message_name);

2565: IF (p_addToPub <> 'NO') THEN
2566: open c1 ;
2567: fetch c1 into ln_app_id ;
2568: close c1 ;
2569: hr_utility.set_message(ln_app_id,p_message_name);
2570: IF (p_token_name IS NOT NULL AND p_token_value IS NOT NULL ) THEN
2571: hr_utility.set_message_token(p_token_name,p_token_value);
2572: END IF;
2573: IF ( p_message_type = 'ERR') THEN

Line 2571: hr_utility.set_message_token(p_token_name,p_token_value);

2567: fetch c1 into ln_app_id ;
2568: close c1 ;
2569: hr_utility.set_message(ln_app_id,p_message_name);
2570: IF (p_token_name IS NOT NULL AND p_token_value IS NOT NULL ) THEN
2571: hr_utility.set_message_token(p_token_name,p_token_value);
2572: END IF;
2573: IF ( p_message_type = 'ERR') THEN
2574: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
2575: ELSE

Line 2584: hr_utility.trace(' exception in '||g_package||'.add_message : ' || sqlerrm);

2580: return l_text;
2581: --
2582: EXCEPTION
2583: WHEN OTHERS THEN
2584: hr_utility.trace(' exception in '||g_package||'.add_message : ' || sqlerrm);
2585: raise;
2586: --
2587: END add_message;
2588: --

Line 2903: hr_utility.trace(' exception in '||g_package||'.get_errors_and_warnings : ' || sqlerrm);

2899: RETURN l_errorWarnings;
2900: --
2901: EXCEPTION
2902: WHEN OTHERS THEN
2903: hr_utility.trace(' exception in '||g_package||'.get_errors_and_warnings : ' || sqlerrm);
2904: raise;
2905: --
2906: END get_errors_and_warnings;
2907:

Line 2973: hr_utility.trace(' exception in '||g_package||'.validation_on_final_approval : ' || sqlerrm);

2969: --
2970: --
2971: EXCEPTION
2972: WHEN OTHERS THEN
2973: hr_utility.trace(' exception in '||g_package||'.validation_on_final_approval : ' || sqlerrm);
2974: Wf_Core.Context(g_package, 'validation_on_final_approval', itemType, itemKey);
2975: raise;
2976: --
2977: END validation_on_final_approval;

Line 3019: hr_utility.trace(' exception in '||g_package||'.check_for_warning_error : ' || sqlerrm);

3015: document := l_errorWarnings;
3016: --
3017: EXCEPTION
3018: WHEN OTHERS THEN
3019: hr_utility.trace(' exception in '||g_package||'.check_for_warning_error : ' || sqlerrm);
3020: document := 'Exception in '||g_package||'.check_for_warning_error : '||
3021: sqlerrm||'
';
3022: --
3023: END check_for_warning_error ;

Line 3052: hr_utility.trace(' exception in '||g_package||'.is_notification_closed : ' || sqlerrm);

3048: --
3049: --
3050: EXCEPTION
3051: WHEN OTHERS THEN
3052: hr_utility.trace(' exception in '||g_package||'.is_notification_closed : ' || sqlerrm);
3053: raise;
3054: --
3055: END is_notification_closed;
3056: --

Line 3096: hr_utility.trace(' exception in '||g_package||'.complete_custom_rfc : ' || sqlerrm);

3092: RETURN l_isCustomRFC;
3093: --
3094: EXCEPTION
3095: WHEN OTHERS THEN
3096: hr_utility.trace(' exception in '||g_package||'.complete_custom_rfc : ' || sqlerrm);
3097: raise;
3098: --
3099: END complete_custom_rfc;
3100: --

Line 3227: hr_utility.trace(' exception in '||g_package||'.set_hr_rep_role : ' || sqlerrm);

3223: END IF;
3224: --
3225: EXCEPTION
3226: WHEN OTHERS THEN
3227: hr_utility.trace(' exception in '||g_package||'.set_hr_rep_role : ' || sqlerrm);
3228: Wf_Core.Context(g_package, 'set_hr_rep_role', itemType, itemKey);
3229: raise;
3230:
3231: END set_hr_rep_role;

Line 3258: hr_utility.trace(' exception in '||g_package||'.approval_block : ' || sqlerrm);

3254: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
3255: ':'||wf_engine.eng_null;
3256: exception
3257: when others then
3258: hr_utility.trace(' exception in '||g_package||'.approval_block : ' || sqlerrm);
3259: Wf_Core.Context(g_package, 'approval_block', itemType, itemKey);
3260: raise;
3261: end approval_block;
3262: --

Line 3619: hr_utility.set_location(' kck nid : ' || nid, 666);

3615: result varchar2(32000) := '';
3616: begin
3617: wf_notification.getNtfActInfo(nid, l_itype, l_ikey, l_actid);
3618:
3619: hr_utility.set_location(' kck nid : ' || nid, 666);
3620: hr_utility.set_location(' kck l_itype : ' || l_itype, 666);
3621: hr_utility.set_location(' kck l_ikey : ' || l_ikey, 666);
3622: hr_utility.set_location(' kck l_actid : ' || l_actid, 666);
3623:

Line 3620: hr_utility.set_location(' kck l_itype : ' || l_itype, 666);

3616: begin
3617: wf_notification.getNtfActInfo(nid, l_itype, l_ikey, l_actid);
3618:
3619: hr_utility.set_location(' kck nid : ' || nid, 666);
3620: hr_utility.set_location(' kck l_itype : ' || l_itype, 666);
3621: hr_utility.set_location(' kck l_ikey : ' || l_ikey, 666);
3622: hr_utility.set_location(' kck l_actid : ' || l_actid, 666);
3623:
3624: l_actid := null;

Line 3621: hr_utility.set_location(' kck l_ikey : ' || l_ikey, 666);

3617: wf_notification.getNtfActInfo(nid, l_itype, l_ikey, l_actid);
3618:
3619: hr_utility.set_location(' kck nid : ' || nid, 666);
3620: hr_utility.set_location(' kck l_itype : ' || l_itype, 666);
3621: hr_utility.set_location(' kck l_ikey : ' || l_ikey, 666);
3622: hr_utility.set_location(' kck l_actid : ' || l_actid, 666);
3623:
3624: l_actid := null;
3625:

Line 3622: hr_utility.set_location(' kck l_actid : ' || l_actid, 666);

3618:
3619: hr_utility.set_location(' kck nid : ' || nid, 666);
3620: hr_utility.set_location(' kck l_itype : ' || l_itype, 666);
3621: hr_utility.set_location(' kck l_ikey : ' || l_ikey, 666);
3622: hr_utility.set_location(' kck l_actid : ' || l_actid, 666);
3623:
3624: l_actid := null;
3625:
3626:

Line 3670: hr_utility.set_location(' kck histr.h_sequence : ' || histr.h_sequence, 666);

3666:
3667: i := 0;
3668: for histr in hist0c(l_itype, l_ikey, l_actid) loop
3669:
3670: hr_utility.set_location(' kck histr.h_sequence : ' || histr.h_sequence, 666);
3671: hr_utility.set_location(' kck histr.h_from_role : ' || histr.h_from_role, 666);
3672: hr_utility.set_location(' kck histr.h_action : ' || histr.h_action, 666);
3673: hr_utility.set_location(' kck histr.h_action_date : ' || histr.h_action_date, 666);
3674: hr_utility.set_location(' kck histr.h_comment : ' || histr.h_comment, 666);

Line 3671: hr_utility.set_location(' kck histr.h_from_role : ' || histr.h_from_role, 666);

3667: i := 0;
3668: for histr in hist0c(l_itype, l_ikey, l_actid) loop
3669:
3670: hr_utility.set_location(' kck histr.h_sequence : ' || histr.h_sequence, 666);
3671: hr_utility.set_location(' kck histr.h_from_role : ' || histr.h_from_role, 666);
3672: hr_utility.set_location(' kck histr.h_action : ' || histr.h_action, 666);
3673: hr_utility.set_location(' kck histr.h_action_date : ' || histr.h_action_date, 666);
3674: hr_utility.set_location(' kck histr.h_comment : ' || histr.h_comment, 666);
3675:

Line 3672: hr_utility.set_location(' kck histr.h_action : ' || histr.h_action, 666);

3668: for histr in hist0c(l_itype, l_ikey, l_actid) loop
3669:
3670: hr_utility.set_location(' kck histr.h_sequence : ' || histr.h_sequence, 666);
3671: hr_utility.set_location(' kck histr.h_from_role : ' || histr.h_from_role, 666);
3672: hr_utility.set_location(' kck histr.h_action : ' || histr.h_action, 666);
3673: hr_utility.set_location(' kck histr.h_action_date : ' || histr.h_action_date, 666);
3674: hr_utility.set_location(' kck histr.h_comment : ' || histr.h_comment, 666);
3675:
3676: if ((NOT (l_owner_role <> histr.h_from_role AND histr.h_action = 'Submit' )) AND

Line 3673: hr_utility.set_location(' kck histr.h_action_date : ' || histr.h_action_date, 666);

3669:
3670: hr_utility.set_location(' kck histr.h_sequence : ' || histr.h_sequence, 666);
3671: hr_utility.set_location(' kck histr.h_from_role : ' || histr.h_from_role, 666);
3672: hr_utility.set_location(' kck histr.h_action : ' || histr.h_action, 666);
3673: hr_utility.set_location(' kck histr.h_action_date : ' || histr.h_action_date, 666);
3674: hr_utility.set_location(' kck histr.h_comment : ' || histr.h_comment, 666);
3675:
3676: if ((NOT (l_owner_role <> histr.h_from_role AND histr.h_action = 'Submit' )) AND
3677: (NOT ( histr.h_from_role = l_owner_role and NVL(histr.h_action,'X') = 'Approve'))) then

Line 3674: hr_utility.set_location(' kck histr.h_comment : ' || histr.h_comment, 666);

3670: hr_utility.set_location(' kck histr.h_sequence : ' || histr.h_sequence, 666);
3671: hr_utility.set_location(' kck histr.h_from_role : ' || histr.h_from_role, 666);
3672: hr_utility.set_location(' kck histr.h_action : ' || histr.h_action, 666);
3673: hr_utility.set_location(' kck histr.h_action_date : ' || histr.h_action_date, 666);
3674: hr_utility.set_location(' kck histr.h_comment : ' || histr.h_comment, 666);
3675:
3676: if ((NOT (l_owner_role <> histr.h_from_role AND histr.h_action = 'Submit' )) AND
3677: (NOT ( histr.h_from_role = l_owner_role and NVL(histr.h_action,'X') = 'Approve'))) then
3678:

Line 3771: hr_utility.set_location('document_id passed : ' || document_id, 666);

3767:
3768: BEGIN
3769:
3770:
3771: hr_utility.set_location('document_id passed : ' || document_id, 666);
3772: --
3773: document_type := wf_notification.doc_html;
3774: document := wf_ntf_history(document_id, document_type);
3775: --

Line 3886: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');

3882: l_errors := 'N';
3883: IF (l_ntf_err_text is not NULL)
3884: THEN
3885: l_errors := 'Y';
3886: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3887: hr_utility.set_message_token('ERROR_MESSAGE', l_ntf_err_text);
3888: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3889: END IF;
3890: IF (l_ntf_name = 'HR_EMBED_NTF_PAY_CONTACT_MSG')

Line 3887: hr_utility.set_message_token('ERROR_MESSAGE', l_ntf_err_text);

3883: IF (l_ntf_err_text is not NULL)
3884: THEN
3885: l_errors := 'Y';
3886: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3887: hr_utility.set_message_token('ERROR_MESSAGE', l_ntf_err_text);
3888: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3889: END IF;
3890: IF (l_ntf_name = 'HR_EMBED_NTF_PAY_CONTACT_MSG')
3891: THEN

Line 3909: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');

3905: itemtype => p_itemType,
3906: itemkey => p_itemKey,
3907: aname => 'APPROVAL_COMMENT_COPY');
3908:
3909: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3910: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3911: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3912: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3913: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);

Line 3910: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);

3906: itemkey => p_itemKey,
3907: aname => 'APPROVAL_COMMENT_COPY');
3908:
3909: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3910: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3911: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3912: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3913: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3914:

Line 3911: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);

3907: aname => 'APPROVAL_COMMENT_COPY');
3908:
3909: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3910: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3911: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3912: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3913: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3914:
3915: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');

Line 3912: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);

3908:
3909: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3910: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3911: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3912: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3913: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3914:
3915: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');
3916: hr_utility.set_message_token('NOTE_FROM_REQUESTOR', l_note_from_requestor);

Line 3915: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');

3911: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3912: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3913: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3914:
3915: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');
3916: hr_utility.set_message_token('NOTE_FROM_REQUESTOR', l_note_from_requestor);
3917: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3918: l_errors := 'Y';
3919: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')

Line 3916: hr_utility.set_message_token('NOTE_FROM_REQUESTOR', l_note_from_requestor);

3912: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3913: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3914:
3915: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');
3916: hr_utility.set_message_token('NOTE_FROM_REQUESTOR', l_note_from_requestor);
3917: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3918: l_errors := 'Y';
3919: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')
3920: THEN

Line 3921: hr_utility.set_message(800, 'HRSSA_INTRVN_ACTION_MSG');

3917: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3918: l_errors := 'Y';
3919: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')
3920: THEN
3921: hr_utility.set_message(800, 'HRSSA_INTRVN_ACTION_MSG');
3922: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3923: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3924: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3925: l_errors := 'Y';

Line 3923: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');

3919: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')
3920: THEN
3921: hr_utility.set_message(800, 'HRSSA_INTRVN_ACTION_MSG');
3922: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3923: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3924: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3925: l_errors := 'Y';
3926: ELSIF (l_ntf_name = 'HR_EMBED_V5_RFC_OTHER' or l_ntf_name = 'HR_EMBED_V5_RFC_INITIATOR')
3927: THEN

Line 3932: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_APPR');

3928: l_note_from_approver := wf_engine.GetItemAttrText(
3929: itemtype => p_itemType,
3930: itemkey => p_itemKey,
3931: aname => 'NOTE_FROM_APPR');
3932: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_APPR');
3933: hr_utility.set_message_token('NOTE_FROM_APPR', l_note_from_approver);
3934: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3935: l_errors := 'Y';
3936: ELSIF (l_ntf_name = 'HR_EMBED_TXN_ERROR_MSG')

Line 3933: hr_utility.set_message_token('NOTE_FROM_APPR', l_note_from_approver);

3929: itemtype => p_itemType,
3930: itemkey => p_itemKey,
3931: aname => 'NOTE_FROM_APPR');
3932: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_APPR');
3933: hr_utility.set_message_token('NOTE_FROM_APPR', l_note_from_approver);
3934: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3935: l_errors := 'Y';
3936: ELSIF (l_ntf_name = 'HR_EMBED_TXN_ERROR_MSG')
3937: THEN

Line 3942: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');

3938: l_error_message := wf_engine.GetItemAttrText(
3939: itemtype => p_itemType,
3940: itemkey => p_itemKey,
3941: aname => 'ERROR_MESSAGE');
3942: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3943: hr_utility.set_message_token('ERROR_MESSAGE', l_error_message);
3944: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3945: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3946: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);

Line 3943: hr_utility.set_message_token('ERROR_MESSAGE', l_error_message);

3939: itemtype => p_itemType,
3940: itemkey => p_itemKey,
3941: aname => 'ERROR_MESSAGE');
3942: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3943: hr_utility.set_message_token('ERROR_MESSAGE', l_error_message);
3944: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3945: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3946: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3947: l_errors := 'Y';

Line 3945: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');

3941: aname => 'ERROR_MESSAGE');
3942: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3943: hr_utility.set_message_token('ERROR_MESSAGE', l_error_message);
3944: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3945: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3946: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3947: l_errors := 'Y';
3948: END IF;
3949:

Line 3955: if(hr_utility.check_warning) Then

3951: (itemtype => p_itemType
3952: ,itemkey => p_itemKey
3953: ,aname => 'TRANSACTION_ID'));
3954:
3955: if(hr_utility.check_warning) Then
3956: l_errors := 'Y';
3957: hr_utility.clear_warning;
3958: end if;
3959:

Line 3957: hr_utility.clear_warning;

3953: ,aname => 'TRANSACTION_ID'));
3954:
3955: if(hr_utility.check_warning) Then
3956: l_errors := 'Y';
3957: hr_utility.clear_warning;
3958: end if;
3959:
3960: RETURN l_errors;
3961: END set_developer_ntf_msg;