DBA Data[Home] [Help]

APPS.PSP_GENERAL dependencies on DBMS_UTILITY

Line 3058: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3054: END IF;
3055: RETURN l_return_code;
3056: EXCEPTION
3057: WHEN OTHERS THEN
3058: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3059: hr_utility.TRACE ('chk_param_valid => sqlerrm is ' || SQLERRM);
3060: hr_utility.TRACE ('chk_param_valid => sqlcode is ' || SQLCODE);
3061: RAISE;
3062: END chk_param_valid;

Line 3100: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3096: END IF;
3097: RETURN l_return_code;
3098: EXCEPTION
3099: WHEN OTHERS THEN
3100: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3101: hr_utility.TRACE ('chk_global_element_level => sqlerrm is ' || SQLERRM);
3102: hr_utility.TRACE ('chk_global_element_level => sqlcode is ' || SQLCODE);
3103: RAISE;
3104: END chk_global_element_level;

Line 3144: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3140: END IF;
3141: RETURN l_return_code;
3142: EXCEPTION
3143: WHEN OTHERS THEN
3144: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3145: hr_utility.TRACE ('chk_element_level => sqlerrm is ' || SQLERRM);
3146: hr_utility.TRACE ('chk_element_level => sqlcode is ' || SQLCODE);
3147: RAISE;
3148: END chk_element_level;

Line 3187: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3183: END IF;
3184: RETURN l_return_code;
3185: EXCEPTION
3186: WHEN OTHERS THEN
3187: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3188: hr_utility.TRACE ('chk_element_Group_level => sqlerrm is ' || SQLERRM);
3189: hr_utility.TRACE ('chk_element_Group_level => sqlcode is ' || SQLCODE);
3190: RAISE;
3191: END chk_element_Group_level;

Line 3231: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3227: END IF;
3228: RETURN l_return_code;
3229: EXCEPTION
3230: WHEN OTHERS THEN
3231: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3232: hr_utility.TRACE ('chk_assignment_level => sqlerrm is ' || SQLERRM);
3233: hr_utility.TRACE ('chk_assignment_level => sqlcode is ' || SQLCODE);
3234: RAISE;
3235: END chk_assignment_level;

Line 3272: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3268: END IF;
3269: RETURN l_return_code;
3270: EXCEPTION
3271: WHEN OTHERS THEN
3272: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3273: hr_utility.TRACE ('chk_default_labor_schedule => sqlerrm is ' || SQLERRM);
3274: hr_utility.TRACE ('chk_default_labor_schedule => sqlcode is ' || SQLCODE);
3275: RAISE;
3276: END chk_default_labor_schedule;

Line 3314: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3310: END IF;
3311: RETURN l_return_code;
3312: EXCEPTION
3313: WHEN OTHERS THEN
3314: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3315: hr_utility.TRACE ('chk_Org_Default_Account => sqlerrm is ' || SQLERRM);
3316: hr_utility.TRACE ('chk_Org_Default_Account => sqlcode is ' || SQLCODE);
3317: RAISE;
3318: END chk_Org_Default_Account;

Line 3356: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3352: END IF;
3353: RETURN l_return_code;
3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3357: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlerrm is ' || SQLERRM);
3358: hr_utility.TRACE ('chk_Suspense_Account_Level => sqlcode is ' || SQLCODE);
3359: RAISE;
3360: END chk_Suspense_Account_Level;

Line 3399: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3395: END IF;
3396: RETURN l_return_code;
3397: EXCEPTION
3398: WHEN OTHERS THEN
3399: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3400: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlerrm is ' || SQLERRM);
3401: hr_utility.TRACE ('chk_Generic_Sus_Account_Level => sqlcode is ' || SQLCODE);
3402: RAISE;
3403: END chk_Generic_Sus_Account_Level;

Line 3440: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3436: END IF;
3437: RETURN l_return_code;
3438: EXCEPTION
3439: WHEN OTHERS THEN
3440: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3441: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlerrm is ' || SQLERRM);
3442: hr_utility.TRACE ('chk_Org_Excess_Salary_Account => sqlcode is ' || SQLCODE);
3443: RAISE;
3444: END chk_Org_Excess_Salary_Account;

Line 3508: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3504: END IF;
3505: RETURN l_return_code;
3506: EXCEPTION
3507: WHEN OTHERS THEN
3508: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3509: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlerrm is ' || SQLERRM);
3510: hr_utility.TRACE ('chk_for_enc_liq_summ_lines => sqlcode is ' || SQLCODE);
3511: RAISE;
3512: END chk_for_enc_liq_summ_lines;

Line 3576: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3572: END IF;
3573: RETURN l_return_code;
3574: EXCEPTION
3575: WHEN OTHERS THEN
3576: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3577: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlerrm is ' || SQLERRM);
3578: hr_utility.TRACE ('chk_dist_adj_pregen_summ_lines => sqlcode is ' || SQLCODE);
3579: RAISE;
3580: END chk_dist_adj_pregen_summ_lines;

Line 3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3699: RETURN l_return_code;
3700:
3701: EXCEPTION
3702: WHEN OTHERS THEN
3703: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3704: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlerrm is ' || SQLERRM);
3705: hr_utility.TRACE ('chk_in_psp_pre_gen_dist_lines => sqlcode is ' || SQLCODE);
3706: RAISE;
3707: END chk_in_psp_pre_gen_dist_lines;

Line 3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3766: END IF;
3767: RETURN l_return_code;
3768: EXCEPTION
3769: WHEN OTHERS THEN
3770: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3771: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlerrm is ' || SQLERRM);
3772: hr_utility.TRACE ('chk_in_psp_adjustment_lines => sqlcode is ' || SQLCODE);
3773: RAISE;
3774: END chk_in_psp_adjustment_lines;

Line 3813: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3809: END IF;
3810: RETURN l_return_code;
3811: EXCEPTION
3812: WHEN OTHERS THEN
3813: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3814: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlerrm is ' || SQLERRM);
3815: hr_utility.TRACE ('chk_poeta_in_element_entries => sqlcode is ' || SQLCODE);
3816: RAISE;
3817: END chk_poeta_in_element_entries;

Line 3853: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3849: END IF;
3850: RETURN l_return_code;
3851: EXCEPTION
3852: WHEN OTHERS THEN
3853: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3854: hr_utility.TRACE ('chk_imported_poeta_trans => sqlerrm is ' || SQLERRM);
3855: hr_utility.TRACE ('chk_imported_poeta_trans => sqlcode is ' || SQLCODE);
3856: RAISE;
3857: END chk_imported_poeta_trans;

Line 3963: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

3959: RETURN l_return_flag;
3960:
3961: EXCEPTION
3962: WHEN OTHERS THEN
3963: hr_utility.trace(DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3964: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlerrm is ' || SQLERRM);
3965: hr_utility.TRACE ('chk_pa_trans_exists_in_ld => sqlcode is ' || SQLCODE);
3966: RAISE;
3967: END chk_pa_trans_exists_in_ld;