DBA Data[Home] [Help]

APPS.PSA_MFAR_ADJUSTMENTS dependencies on PSA_MFAR_ADJUSTMENTS

Line 1: PACKAGE BODY PSA_MFAR_ADJUSTMENTS AS

1: PACKAGE BODY PSA_MFAR_ADJUSTMENTS AS
2: /* $Header: PSAMFADB.pls 120.22 2006/09/13 12:14:12 agovil ship $ */
3:
4: --
5: -- global variables

Line 23: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFADB.PSA_MFAR_ADJUSTMENTS.';

19: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
20: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
21: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
22: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
23: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFADB.PSA_MFAR_ADJUSTMENTS.';
24: --===========================FND_LOG.END=======================================
25:
26: --
27: -- Local Procedures

Line 327: l_exception_error := 'EXCEPTION - FLEX_COMPARE_ERROR PACKAGE - PSA_MFAR_ADJUSTMENTS.CREATE_DISTRIBUTIONS - '||FND_MESSAGE.GET;

323: -- ========================= FND LOG ===========================
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 ===========================

Line 337: l_exception_error := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_ADJUSTMENTS.CREATE_DISTRIBUTIONS - '||SQLCODE || ' - ' || SQLERRM;

333: -- ========================= FND LOG ===========================
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 ===========================

Line 743: l_exception_error := 'EXCEPTION - FLEX_BUILD_ERROR PACKAGE - PSA_MFAR_ADJUSTMENTS.GENERATE_ADJ_DIST '||FND_MESSAGE.GET;

739: RETURN TRUE;
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 ===========================

Line 753: l_exception_error := 'EXCEPTION - OTHERS PACKAGE - PSA_MFAR_ADJUSTMENTS.GENERATE_ADJ_DIST '||SQLCODE || ' - ' || SQLERRM;

749: -- ========================= FND LOG ===========================
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 ===========================

Line 819: END PSA_MFAR_ADJUSTMENTS;

815: END IF;
816:
817: END FIND_TAX_FREIGHT_LINES;
818:
819: END PSA_MFAR_ADJUSTMENTS;