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

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

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

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

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

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

1191: END IF;
1192: --
1193: EXCEPTION
1194: WHEN OTHERS THEN
1195: hr_utility.trace(' exception in '||g_package||'.get_transaction_info : ' || sqlerrm);
1196: raise;
1197: --
1198: END get_transaction_info;
1199: --

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

1344:
1345: --
1346: EXCEPTION
1347: WHEN OTHERS THEN
1348: hr_utility.trace(' exception in '||g_package||'.revert_to_last_save : ' || sqlerrm);
1349: raise;
1350: --
1351: END revert_to_last_save;
1352:

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

1418: --
1419: --
1420: EXCEPTION
1421: WHEN OTHERS THEN
1422: hr_utility.trace(' exception in '||g_package||'.get_url_for_edit : ' || sqlerrm);
1423: raise;
1424: --
1425: END get_url_for_edit;
1426: --

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

1659: --
1660: --
1661: EXCEPTION
1662: WHEN OTHERS THEN
1663: hr_utility.trace(' exception in '||g_package||'.set_transaction_status : ' || sqlerrm);
1664: raise;
1665: --
1666: END set_transaction_status;
1667:

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

1704: --
1705: --
1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: hr_utility.trace(' exception in '||g_package||'.set_txn_approve_status : ' || sqlerrm);
1709: Wf_Core.Context(g_package, 'set_txn_approve_status', itemType, itemKey);
1710: raise;
1711: --
1712: END set_txn_approve_status;

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

1732: END IF;
1733:
1734: EXCEPTION
1735: WHEN OTHERS THEN
1736: hr_utility.trace(' exception in '||g_package||'.set_txn_rfc_status : ' || sqlerrm);
1737: Wf_Core.Context(g_package, 'set_txn_rfc_status', itemType, itemKey);
1738: raise;
1739: --
1740: END set_txn_rfc_status;

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

1765: END IF;
1766:
1767: EXCEPTION
1768: WHEN OTHERS THEN
1769: hr_utility.trace(' exception in '||g_package||'.set_txn_sfl_status : ' || sqlerrm);
1770: Wf_Core.Context(g_package, 'set_txn_sfl_status', itemType, itemKey);
1771: raise;
1772: END set_txn_sfl_status;
1773: --

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

1850: --
1851: --
1852: EXCEPTION
1853: WHEN OTHERS THEN
1854: hr_utility.trace(' exception in '||g_package||'.set_effective_date_and_option : ' || sqlerrm);
1855: raise;
1856: --
1857: END set_effective_date_and_option;
1858: --

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

1953: --
1954: --
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: hr_utility.trace(' exception in '||g_package||'.reset_txn_current_values : ' || sqlerrm);
1958: Wf_Core.Context(g_package, 'reset_txn_current_values', itemType, itemKey);
1959: raise;
1960: --
1961: END reset_txn_current_values;

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

2011: --
2012: --
2013: EXCEPTION
2014: WHEN OTHERS THEN
2015: hr_utility.trace(' exception in '||g_package||'.check_initial_save_for_later : ' || sqlerrm);
2016: Wf_Core.Context(g_package, 'check_initial_save_for_later', itemType, itemKey);
2017: raise;
2018: --
2019: END check_initial_save_for_later;

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

2287: COMMIT;
2288: --
2289: EXCEPTION
2290: WHEN OTHERS THEN
2291: hr_utility.trace(' exception in '||g_package||'.return_for_correction : ' || sqlerrm);
2292: raise;
2293: --
2294: END return_for_correction;
2295: --

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

2406: END IF;
2407: --
2408: EXCEPTION
2409: WHEN OTHERS THEN
2410: hr_utility.trace(' exception in '||g_package||'.get_edit_link : ' || sqlerrm);
2411: raise;
2412: --
2413: END get_edit_link;
2414: --

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

2485: --
2486: --
2487: EXCEPTION
2488: WHEN OTHERS THEN
2489: hr_utility.trace(' exception in '||g_package||'.set_date_if_as_of_approval : ' || sqlerrm);
2490: Wf_Core.Context(g_package, 'set_date_if_as_of_approval', itemType, itemKey);
2491: raise;
2492: --
2493: END set_date_if_as_of_approval;

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

2542: IF (p_addToPub <> 'NO') THEN
2543: open c1 ;
2544: fetch c1 into ln_app_id ;
2545: close c1 ;
2546: hr_utility.set_message(ln_app_id,p_message_name);
2547: IF (p_token_name IS NOT NULL AND p_token_value IS NOT NULL ) THEN
2548: hr_utility.set_message_token(p_token_name,p_token_value);
2549: END IF;
2550: IF ( p_message_type = 'ERR') THEN

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

2544: fetch c1 into ln_app_id ;
2545: close c1 ;
2546: hr_utility.set_message(ln_app_id,p_message_name);
2547: IF (p_token_name IS NOT NULL AND p_token_value IS NOT NULL ) THEN
2548: hr_utility.set_message_token(p_token_name,p_token_value);
2549: END IF;
2550: IF ( p_message_type = 'ERR') THEN
2551: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
2552: ELSE

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

2557: return l_text;
2558: --
2559: EXCEPTION
2560: WHEN OTHERS THEN
2561: hr_utility.trace(' exception in '||g_package||'.add_message : ' || sqlerrm);
2562: raise;
2563: --
2564: END add_message;
2565: --

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

2875: RETURN l_errorWarnings;
2876: --
2877: EXCEPTION
2878: WHEN OTHERS THEN
2879: hr_utility.trace(' exception in '||g_package||'.get_errors_and_warnings : ' || sqlerrm);
2880: raise;
2881: --
2882: END get_errors_and_warnings;
2883:

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

2937: --
2938: --
2939: EXCEPTION
2940: WHEN OTHERS THEN
2941: hr_utility.trace(' exception in '||g_package||'.validation_on_final_approval : ' || sqlerrm);
2942: Wf_Core.Context(g_package, 'validation_on_final_approval', itemType, itemKey);
2943: raise;
2944: --
2945: END validation_on_final_approval;

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

2983: document := l_errorWarnings;
2984: --
2985: EXCEPTION
2986: WHEN OTHERS THEN
2987: hr_utility.trace(' exception in '||g_package||'.check_for_warning_error : ' || sqlerrm);
2988: document := 'Exception in '||g_package||'.check_for_warning_error : '||
2989: sqlerrm||'';
2990: --
2991: END check_for_warning_error ;

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

3016: --
3017: --
3018: EXCEPTION
3019: WHEN OTHERS THEN
3020: hr_utility.trace(' exception in '||g_package||'.is_notification_closed : ' || sqlerrm);
3021: raise;
3022: --
3023: END is_notification_closed;
3024: --

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

3060: RETURN l_isCustomRFC;
3061: --
3062: EXCEPTION
3063: WHEN OTHERS THEN
3064: hr_utility.trace(' exception in '||g_package||'.complete_custom_rfc : ' || sqlerrm);
3065: raise;
3066: --
3067: END complete_custom_rfc;
3068: --

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

3191: END IF;
3192: --
3193: EXCEPTION
3194: WHEN OTHERS THEN
3195: hr_utility.trace(' exception in '||g_package||'.set_hr_rep_role : ' || sqlerrm);
3196: Wf_Core.Context(g_package, 'set_hr_rep_role', itemType, itemKey);
3197: raise;
3198:
3199: END set_hr_rep_role;

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

3222: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
3223: ':'||wf_engine.eng_null;
3224: exception
3225: when others then
3226: hr_utility.trace(' exception in '||g_package||'.approval_block : ' || sqlerrm);
3227: Wf_Core.Context(g_package, 'approval_block', itemType, itemKey);
3228: raise;
3229: end approval_block;
3230: --

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

3811: l_errors := 'N';
3812: IF (l_ntf_err_text is not NULL)
3813: THEN
3814: l_errors := 'Y';
3815: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3816: hr_utility.set_message_token('ERROR_MESSAGE', l_ntf_err_text);
3817: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3818: END IF;
3819: IF (l_ntf_name = 'HR_EMBED_NTF_PAY_CONTACT_MSG')

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

3812: IF (l_ntf_err_text is not NULL)
3813: THEN
3814: l_errors := 'Y';
3815: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3816: hr_utility.set_message_token('ERROR_MESSAGE', l_ntf_err_text);
3817: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3818: END IF;
3819: IF (l_ntf_name = 'HR_EMBED_NTF_PAY_CONTACT_MSG')
3820: THEN

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

3834: itemtype => p_itemType,
3835: itemkey => p_itemKey,
3836: aname => 'APPROVAL_COMMENT_COPY');
3837:
3838: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3839: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3840: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3841: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3842: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);

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

3835: itemkey => p_itemKey,
3836: aname => 'APPROVAL_COMMENT_COPY');
3837:
3838: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3839: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3840: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3841: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3842: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3843:

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

3836: aname => 'APPROVAL_COMMENT_COPY');
3837:
3838: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3839: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3840: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3841: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3842: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3843:
3844: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');

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

3837:
3838: hr_utility.set_message(800, 'HRSSA_MID_PAY_PERIOD_MSG');
3839: hr_utility.set_message_token('SALARY_BASIS_CHANGE_TOKEN', l_sal_basis_change_token);
3840: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3841: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3842: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3843:
3844: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');
3845: hr_utility.set_message_token('NOTE_FROM_REQUESTOR', l_note_from_requestor);

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

3840: hr_utility.set_message_token('CURRENT_PERSON_DISPLAY_NAME', l_current_person_display_name);
3841: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3842: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3843:
3844: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');
3845: hr_utility.set_message_token('NOTE_FROM_REQUESTOR', l_note_from_requestor);
3846: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3847: l_errors := 'Y';
3848: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')

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

3841: hr_utility.set_message_token('PROCESS_DISPLAY_NAME',l_process_display_name);
3842: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3843:
3844: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_REQUESTOR');
3845: hr_utility.set_message_token('NOTE_FROM_REQUESTOR', l_note_from_requestor);
3846: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3847: l_errors := 'Y';
3848: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')
3849: THEN

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

3846: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3847: l_errors := 'Y';
3848: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')
3849: THEN
3850: hr_utility.set_message(800, 'HRSSA_INTRVN_ACTION_MSG');
3851: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3852: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3853: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3854: l_errors := 'Y';

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

3848: ELSIF (l_ntf_name = 'HR_EMBED_ON_APPR_NTFY_HR_REP')
3849: THEN
3850: hr_utility.set_message(800, 'HRSSA_INTRVN_ACTION_MSG');
3851: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3852: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3853: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3854: l_errors := 'Y';
3855: ELSIF (l_ntf_name = 'HR_EMBED_V5_RFC_OTHER' or l_ntf_name = 'HR_EMBED_V5_RFC_INITIATOR')
3856: THEN

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

3857: l_note_from_approver := wf_engine.GetItemAttrText(
3858: itemtype => p_itemType,
3859: itemkey => p_itemKey,
3860: aname => 'NOTE_FROM_APPR');
3861: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_APPR');
3862: hr_utility.set_message_token('NOTE_FROM_APPR', l_note_from_approver);
3863: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3864: l_errors := 'Y';
3865: ELSIF (l_ntf_name = 'HR_EMBED_TXN_ERROR_MSG')

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

3858: itemtype => p_itemType,
3859: itemkey => p_itemKey,
3860: aname => 'NOTE_FROM_APPR');
3861: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_APPR');
3862: hr_utility.set_message_token('NOTE_FROM_APPR', l_note_from_approver);
3863: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3864: l_errors := 'Y';
3865: ELSIF (l_ntf_name = 'HR_EMBED_TXN_ERROR_MSG')
3866: THEN

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

3867: l_error_message := wf_engine.GetItemAttrText(
3868: itemtype => p_itemType,
3869: itemkey => p_itemKey,
3870: aname => 'ERROR_MESSAGE');
3871: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3872: hr_utility.set_message_token('ERROR_MESSAGE', l_error_message);
3873: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3874: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3875: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);

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

3868: itemtype => p_itemType,
3869: itemkey => p_itemKey,
3870: aname => 'ERROR_MESSAGE');
3871: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3872: hr_utility.set_message_token('ERROR_MESSAGE', l_error_message);
3873: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3874: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3875: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3876: l_errors := 'Y';

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

3870: aname => 'ERROR_MESSAGE');
3871: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');
3872: hr_utility.set_message_token('ERROR_MESSAGE', l_error_message);
3873: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3874: hr_utility.set_message(800, 'HRSSA_CANCEL_ACTION_MSG');
3875: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3876: l_errors := 'Y';
3877: END IF;
3878:

Line 3884: if(hr_utility.check_warning) Then

3880: (itemtype => p_itemType
3881: ,itemkey => p_itemKey
3882: ,aname => 'TRANSACTION_ID'));
3883:
3884: if(hr_utility.check_warning) Then
3885: l_errors := 'Y';
3886: hr_utility.clear_warning;
3887: end if;
3888:

Line 3886: hr_utility.clear_warning;

3882: ,aname => 'TRANSACTION_ID'));
3883:
3884: if(hr_utility.check_warning) Then
3885: l_errors := 'Y';
3886: hr_utility.clear_warning;
3887: end if;
3888:
3889: RETURN l_errors;
3890: END set_developer_ntf_msg;