APPS.PSA_SLA_PROCESSING_PKG dependencies on PSA_UTILS

Line 62: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure postprocessing ' );

58: IS
59: l_path_name VARCHAR2(1024);
60: BEGIN
61: l_path_name := g_path_name || '.postprocessing';
62: psa_utils.debug_other_string(g_state_level,l_path_name, 'BEGIN of procedure postprocessing ' );
63: -- Bug 11856887 : Removed the application payables as the changes done for
64: -- the enhancement 11855000 are initially applicable for payables only
65: IF (p_application_id NOT IN (707)) THEN
66: RETURN;

Line 87: psa_utils.debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );

83: AND e.ledger_id = l.ledger_id
84: AND e.budgetary_control_flag = 'N'
85: AND l.enable_budgetary_control_flag = 'Y');
86:
87: psa_utils.debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN
90: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
91: WHEN OTHERS THEN

Line 90: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

86:
87: psa_utils.debug_other_string(g_state_level,l_path_name, 'Updated '||SQL%ROWCOUNT||' rows.' );
88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN
90: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
91: WHEN OTHERS THEN
92: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
93: RAISE;
94: End;

Line 92: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));

88: EXCEPTION
89: WHEN NO_DATA_FOUND THEN
90: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
91: WHEN OTHERS THEN
92: psa_utils.debug_other_string(g_excep_level,l_path_name,'EXCEPTION: '|| SQLERRM(sqlcode));
93: RAISE;
94: End;
95:
96: