APPS.PA_FP_PERIOD_MASKS_UTILS dependencies on PA_FP_PERIOD_MASKS_UTILS

Line 1: PACKAGE body PA_FP_PERIOD_MASKS_UTILS as

1: PACKAGE body PA_FP_PERIOD_MASKS_UTILS as
2: /* $Header: PAFPPMUB.pls 120.0 2005/06/03 13:47:08 appldev noship $ */
3: /*********************************************************************
4: Important : The appropriate procedures that make a call to the below
5: procedures must make a call to FND_MSG_PUB.initialize.

Line 16: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PERIOD_MASKS_UTILS.NAME_VALIDATION';

12: p_init_msg_flag IN VARCHAR2,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_msg_count OUT NOCOPY NUMBER,
15: x_msg_data OUT NOCOPY VARCHAR2) IS
16: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PERIOD_MASKS_UTILS.NAME_VALIDATION';
17: l_exists VARCHAR2(1);
18: l_msg_count NUMBER;
19: l_msg_index_out NUMBER;
20: l_data VARCHAR2(2000);

Line 79: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',

75: WHEN OTHERS THEN
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: x_msg_count := 1;
78: x_msg_data := SQLERRM;
79: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',
80: p_procedure_name => 'name_validation');
81: IF P_PA_DEBUG_MODE = 'Y' THEN
82: pa_fp_gen_amount_utils.fp_debug
83: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 101: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PERIOD_MASKS_UTILS.NOP_VALIDATION';

97: p_error_flag_tab IN OUT NOCOPY PA_VC_1000_150,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2) IS
101: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PERIOD_MASKS_UTILS.NOP_VALIDATION';
102: l_num_of_periods PA_NUM_1000_NUM;
103: l_invalid_num_exists BOOLEAN := FALSE;
104: l_msg_count NUMBER;
105: l_msg_index_out NUMBER;

Line 177: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',

173: WHEN OTHERS THEN
174: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
175: x_msg_count := 1;
176: x_msg_data := SQLERRM;
177: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',
178: p_procedure_name => 'nop_validation');
179: IF P_PA_DEBUG_MODE = 'Y' THEN
180: pa_fp_gen_amount_utils.fp_debug
181: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),

Line 203: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PERIOD_MASKS_UTILS.MAINTAIN_PERIOD_MASK_DTLS';

199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2) IS
202:
203: l_module_name VARCHAR2(100) := 'pa.plsql.PA_FP_PERIOD_MASKS_UTILS.MAINTAIN_PERIOD_MASK_DTLS';
204: CURSOR succ_pd IS
205: SELECT from_anchor_position,num_of_periods FROM
206: pa_fp_period_mask_tmp WHERE from_anchor_position > 0 ORDER BY from_anchor_position;
207: CURSOR prec_pd IS

Line 347: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',

343: WHEN OTHERS THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: x_msg_count := 1;
346: x_msg_data := SQLERRM;
347: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',
348: p_procedure_name => 'MAINTAIN_PERIOD_MASK_DTLS');
349: IF P_PA_DEBUG_MODE = 'Y' THEN
350: pa_debug.write_log(
351: x_module => l_module_name,

Line 426: END PA_FP_PERIOD_MASKS_UTILS;

422: WHEN OTHERS THEN
423: RETURN 'N';
424: END IS_DELETE_ALLOWED;
425:
426: END PA_FP_PERIOD_MASKS_UTILS;