DBA Data[Home] [Help]

APPS.PSA_MFAR_ADJUSTMENTS dependencies on PSA_MFAR_UTILS

Line 72: psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_MFAR_UTILS.is_ccid_exists');

68: RETURN FALSE;
69: EXCEPTION
70: WHEN OTHERS THEN
71: -- ========================= FND LOG ===========================
72: psa_utils.debug_other_string(g_excep_level,l_full_path,'EXCEPTION - OTHERS : ERROR IN PSA_MFAR_UTILS.is_ccid_exists');
73: psa_utils.debug_other_string(g_excep_level,l_full_path,'RETURN -> FALSE');
74: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
75: psa_utils.debug_unexpected_msg(l_full_path);
76: -- ========================= FND LOG ===========================

Line 228: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');

224: FETCH c_adj_dist INTO l_adj_dist_rec;
225: EXIT WHEN c_adj_dist%NOTFOUND;
226:
227: -- ========================= FND LOG ===========================
228: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');
229: -- ========================= FND LOG ===========================
230:
231: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => g_adj_ccid,
232: P_OVERRIDE_CCID => l_adj_dist_rec.mf_rec_ccid,

Line 231: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => g_adj_ccid,

227: -- ========================= FND LOG ===========================
228: psa_utils.debug_other_string(g_state_level,l_full_path, ' Calling PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ');
229: -- ========================= FND LOG ===========================
230:
231: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => g_adj_ccid,
232: P_OVERRIDE_CCID => l_adj_dist_rec.mf_rec_ccid,
233: P_SET_OF_BOOKS_ID => g_set_of_books_id,
234: P_TRX_TYPE => 'ADJ',
235: P_CCID => l_temp_rec_ccid)) -- OUT

Line 318: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);

314: RETURN TRUE;
315:
316: EXCEPTION
317: WHEN GENERATE_ADJ_DIST_EXCEP THEN
318: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);
319: p_error_message := l_exception_error;
320: retcode := 'F';
321: -- ========================= FND LOG ===========================
322: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);

Line 328: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);

324: RETURN FALSE;
325:
326: WHEN FLEX_COMPARE_ERROR THEN
327: l_exception_error := 'EXCEPTION - FLEX_COMPARE_ERROR PACKAGE - PSA_MFAR_ADJUSTMENTS.CREATE_DISTRIBUTIONS - '||FND_MESSAGE.GET;
328: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);
329: p_error_message := l_exception_error;
330: retcode := 'F';
331: -- ========================= FND LOG ===========================
332: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);

Line 338: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);

334: RETURN FALSE;
335:
336: WHEN OTHERS THEN
337: l_exception_error := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_ADJUSTMENTS.CREATE_DISTRIBUTIONS - '||SQLCODE || ' - ' || SQLERRM;
338: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);
339: p_error_message := l_exception_error;
340: retcode := 'F';
341: -- ========================= FND LOG ===========================
342: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);

Line 573: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => l_adj_ccid,

569: -- ========================= FND LOG ===========================
570: psa_utils.debug_other_string(g_state_level,l_full_path, ' l_adj_ccid --> ' || l_adj_ccid );
571: -- ========================= FND LOG ===========================
572:
573: IF NOT ( PSA_MFAR_UTILS.OVERRIDE_SEGMENTS ( P_PRIMARY_CCID => l_adj_ccid,
574: P_OVERRIDE_CCID => ccid_info(i).mf_rec_ccid,
575: P_SET_OF_BOOKS_ID => g_set_of_books_id,
576: P_TRX_TYPE => 'ADJ',
577: P_CCID => p_ccid)) -- OUT

Line 744: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);

740:
741: EXCEPTION
742: WHEN FLEX_BUILD_ERROR THEN
743: l_exception_error := 'EXCEPTION - FLEX_BUILD_ERROR PACKAGE - PSA_MFAR_ADJUSTMENTS.GENERATE_ADJ_DIST '||FND_MESSAGE.GET;
744: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);
745: p_error_message := l_exception_error;
746: RETCODE := 'F';
747: -- ========================= FND LOG ===========================
748: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);

Line 754: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);

750: RETURN FALSE;
751:
752: WHEN OTHERS THEN
753: l_exception_error := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_ADJUSTMENTS.GENERATE_ADJ_DIST '||SQLCODE || ' - ' || SQLERRM;
754: PSA_MFAR_UTILS.INSERT_DISTRIBUTIONS_LOG (g_run_id, 'ADJUSTMENT', g_customer_trx_id, g_adjustment_id, l_exception_error);
755: p_error_message := l_exception_error;
756: RETCODE := 'F';
757: -- ========================= FND LOG ===========================
758: psa_utils.debug_other_string(g_excep_level,l_full_path,l_exception_error);