APPS.PSA_MF_MISC_PKG dependencies on PSA_MF_MISC_PKG

Line 1: PACKAGE BODY psa_mf_misc_pkg AS

1: PACKAGE BODY psa_mf_misc_pkg AS
2: /* $Header: PSAMFMXB.pls 120.14 2006/09/13 13:39:16 agovil ship $ */
3:
4:
5: -- declare global variables

Line 16: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFMXB.psa_mf_misc_pkg.';

12: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
13: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
14: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
15: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
16: g_path VARCHAR2(50) := 'PSA.PLSQL.PSAMFMXB.psa_mf_misc_pkg.';
17: --===========================FND_LOG.END=======================================
18:
19:
20: -- Local functions

Line 142: IF NOT (PSA_MF_MISC_PKG.create_distributions (

138: ## There is count mismatch between core and MF Distribution
139: ## delete all mf distributions and re-create them.
140: */
141:
142: IF NOT (PSA_MF_MISC_PKG.create_distributions (
143: errbuf => errbuf,
144: retcode => retcode,
145: p_mode => 'R',
146: p_error_message => p_error_message,

Line 169: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> TRUE ');

165: END IF; -- 4 END IF
166: ELSE
167: -- ========================= FND LOG ===========================
168: psa_utils.debug_other_string(g_state_level,l_full_path,
169: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> TRUE ');
170: -- ========================= FND LOG ===========================
171: END IF; -- 3 END IF
172:
173: ELSE

Line 193: IF NOT (PSA_MF_MISC_PKG.create_distributions (

189: ' Generate_distributions --> match_ccid_rec.distribution_ccid'
190: || ' <> match_ccid_rec.code_combination_id');
191: -- ========================= FND LOG ===========================
192:
193: IF NOT (PSA_MF_MISC_PKG.create_distributions (
194: errbuf => errbuf,
195: retcode => retcode,
196: p_mode => 'R',
197: p_error_message => p_error_message,

Line 220: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> TRUE ');

216:
217: ELSE
218: -- ========================= FND LOG ===========================
219: psa_utils.debug_other_string(g_state_level,l_full_path,
220: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> TRUE ');
221: -- ========================= FND LOG ===========================
222: END IF;
223: END IF;
224:

Line 237: IF NOT (PSA_MF_MISC_PKG.create_distributions (

233: ## mf_dist_count = 0 .
234: ## Distribution will be created for the first time.
235: */
236:
237: IF NOT (PSA_MF_MISC_PKG.create_distributions (
238: errbuf => errbuf,
239: retcode => retcode,
240: p_mode => 'C',
241: p_error_message => p_error_message,

Line 265: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> FALSE ');

261:
262: ELSE
263: -- ========================= FND LOG ===========================
264: psa_utils.debug_other_string(g_state_level,l_full_path,
265: ' Generate_distributions -> PSA_MF_MISC_PKG.create_distributions --> FALSE ');
266: -- ========================= FND LOG ===========================
267: END IF;
268:
269: END IF; -- 1 END IF

Line 282: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.GENERATE_DISTRIBUTIONS - '||SQLERRM;

278: RETURN TRUE;
279:
280: EXCEPTION
281: WHEN OTHERS THEN -- here
282: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.GENERATE_DISTRIBUTIONS - '||SQLERRM;
283: -- ========================= FND LOG ===========================
284: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
285: psa_utils.debug_unexpected_msg(l_full_path);
286: -- ========================= FND LOG ===========================

Line 737: p_error_message:= 'EXCEPTION - FLEX_BUILD_ERROR PACKAGE - PSA_MF_MISC_PKG.CREATE_DISTRIBUTIONS - '||FND_MESSAGE.GET;

733: RETURN TRUE;
734:
735: EXCEPTION
736: WHEN FLEX_BUILD_ERROR THEN
737: p_error_message:= 'EXCEPTION - FLEX_BUILD_ERROR PACKAGE - PSA_MF_MISC_PKG.CREATE_DISTRIBUTIONS - '||FND_MESSAGE.GET;
738: -- ========================= FND LOG ===========================
739: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
740: -- ========================= FND LOG ===========================
741: retcode := 'F';

Line 745: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.CREATE_DISTRIBUTIONS - '||sqlerrm;

741: retcode := 'F';
742: RETURN FALSE;
743:
744: WHEN OTHERS THEN
745: p_error_message:= 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.CREATE_DISTRIBUTIONS - '||sqlerrm;
746: -- ========================= FND LOG ===========================
747: psa_utils.debug_other_string(g_excep_level,l_full_path,p_error_message);
748: psa_utils.debug_unexpected_msg(l_full_path);
749: -- ========================= FND LOG ===========================

Line 825: 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.MISC_RCT_CHANGED - '||sqlerrm);

821: EXCEPTION
822: WHEN OTHERS THEN
823: -- ========================= FND LOG ===========================
824: psa_utils.debug_other_string(g_excep_level,l_full_path,
825: 'EXCEPTION - OTHERS PACKAGE - PSA_MF_MISC_PKG.MISC_RCT_CHANGED - '||sqlerrm);
826: psa_utils.debug_unexpected_msg(l_full_path);
827: -- ========================= FND LOG ===========================
828: RETURN FALSE;
829:

Line 833: END psa_mf_misc_pkg;

829:
830: END misc_rct_changed;
831:
832:
833: END psa_mf_misc_pkg;