DBA Data[Home] [Help]

APPS.PSA_XFR_TO_GL_PKG dependencies on PSA_XFR_TO_GL_PKG

Line 1: PACKAGE BODY PSA_XFR_TO_GL_PKG AS

1: PACKAGE BODY PSA_XFR_TO_GL_PKG AS
2: /* $Header: PSAMFG2B.pls 120.3 2006/09/13 12:49:36 agovil noship $ */
3:
4: /* ################################## GLOBAL VARIABLES DECLARE START ################################## */
5:

Line 91: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFG2B.PSA_XFR_TO_GL_PKG.';

87: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
88: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
89: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
90: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
91: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFG2B.PSA_XFR_TO_GL_PKG.';
92: --===========================FND_LOG.END=======================================
93:
94: PROCEDURE Transfer_to_gl ( errbuf OUT NOCOPY VARCHAR2,
95: retcode OUT NOCOPY VARCHAR2,

Line 1389: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');

1385: EXCEPTION
1386: WHEN INVALID_DISTRIBUTION THEN
1387: -- ========================= FND LOG ===========================
1388: psa_utils.debug_other_string(g_excep_level,l_full_path,
1389: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');
1390: psa_utils.debug_other_string(g_excep_level,l_full_path,
1391: ' --> p_error_message --> ' || l_error_message);
1392: -- ========================= FND LOG ===========================
1393: retcode := 'F';

Line 1398: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');

1394:
1395: WHEN OTHERS THEN
1396: -- ========================= FND LOG ===========================
1397: psa_utils.debug_other_string(g_excep_level,l_full_path,
1398: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_trx_to_gl ');
1399: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
1400: psa_utils.debug_unexpected_msg(l_full_path);
1401: -- ========================= FND LOG ===========================
1402: errbuf := 2;

Line 2418: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');

2414: EXCEPTION
2415: WHEN INVALID_DISTRIBUTION THEN
2416: -- ========================= FND LOG ===========================
2417: psa_utils.debug_other_string(g_excep_level,l_full_path,
2418: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');
2419: psa_utils.debug_other_string(g_excep_level,l_full_path,
2420: ' --> p_error_message --> ' || l_error_message);
2421: -- ========================= FND LOG ===========================
2422: retcode := 'F';

Line 2427: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');

2423:
2424: WHEN OTHERS THEN
2425: -- ========================= FND LOG ===========================
2426: psa_utils.debug_other_string(g_excep_level,l_full_path,
2427: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl ');
2428: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2429: psa_utils.debug_unexpected_msg(l_full_path);
2430: -- ========================= FND LOG ===========================
2431: errbuf := 2;

Line 2786: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PPSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');

2782: EXCEPTION
2783: WHEN INVALID_DISTRIBUTION THEN
2784: -- ========================= FND LOG ===========================
2785: psa_utils.debug_other_string(g_excep_level,l_full_path,
2786: ' --> EXCEPTION - INVALID_DISTRIBUTION raised during PPSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');
2787: psa_utils.debug_other_string(g_excep_level,l_full_path,
2788: ' --> p_error_message --> ' || l_error_message);
2789: -- ========================= FND LOG ===========================
2790: retcode := 'F';

Line 2795: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');

2791:
2792: WHEN OTHERS THEN
2793: -- ========================= FND LOG ===========================
2794: psa_utils.debug_other_string(g_excep_level,l_full_path,
2795: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Mfar_adj_to_gl ');
2796: psa_utils.debug_other_string(g_excep_level,l_full_path, sqlcode || sqlerrm);
2797: psa_utils.debug_unexpected_msg(l_full_path);
2798: -- ========================= FND LOG ===========================
2799: errbuf := 2;

Line 3080: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Reverse_core_entries_if_any ');

3076: WHEN OTHERS THEN
3077: p_error_message := sqlcode || sqlerrm;
3078: -- ========================= FND LOG ===========================
3079: psa_utils.debug_other_string(g_excep_level,l_full_path,
3080: ' --> EXCEPTION - OTHERS raised during PSA_XFR_TO_GL_PKG.Reverse_core_entries_if_any ');
3081: psa_utils.debug_other_string(g_excep_level,l_full_path, p_error_message);
3082: psa_utils.debug_unexpected_msg(l_full_path);
3083: -- ========================= FND LOG ===========================
3084: errbuf := 2;

Line 3962: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);

3958: EXCEPTION
3959: WHEN INVALID_DISTRIBUTION THEN
3960: -- ========================= FND LOG ===========================
3961: psa_utils.debug_other_string(g_excep_level,l_full_path,
3962: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);
3963: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || l_error_message);
3964: -- ========================= FND LOG ===========================
3965: retcode := 'F';
3966:

Line 3970: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);

3966:
3967: WHEN OTHERS THEN
3968: -- ========================= FND LOG ===========================
3969: psa_utils.debug_other_string(g_excep_level,l_full_path,
3970: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Unable to create Multi-Fund distributions for Receivable Application ID: ' || I.receivable_application_id);
3971: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
3972: psa_utils.debug_unexpected_msg(l_full_path);
3973: -- ========================= FND LOG ===========================
3974: retcode := 'F';

Line 4096: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Exception : OTHERS ');

4092: EXCEPTION
4093: WHEN OTHERS THEN
4094: -- ========================= FND LOG ===========================
4095: psa_utils.debug_other_string(g_excep_level,l_full_path,
4096: ' PSA_XFR_TO_GL_PKG.Mfar_rct_to_gl: Exception : OTHERS ');
4097: psa_utils.debug_other_string(g_excep_level,l_full_path,' Error Message : ' || sqlerrm);
4098: psa_utils.debug_unexpected_msg(l_full_path);
4099: -- ========================= FND LOG ===========================
4100: retcode := 'F';

Line 4352: END psa_xfr_to_gl_pkg;

4348: END Misc_rct_to_gl_CB;
4349:
4350: /* ########################################## END OF PSA_TRSNAFER_TO_GL_PKG ################################# */
4351:
4352: END psa_xfr_to_gl_pkg;