DBA Data[Home] [Help]

APPS.PA_PERIOD_MASKS_PUB dependencies on PA_PERIOD_MASKS_PUB

Line 1: PACKAGE BODY PA_PERIOD_MASKS_PUB as

1: PACKAGE BODY PA_PERIOD_MASKS_PUB as
2: /* $Header: PAFPPMMB.pls 120.0.12000000.2 2007/09/10 12:12:56 admarath ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE maintain_period_masks(

Line 24: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PERIOD_MASKS_PUB.maintain_period_masks';

20: x_msg_count OUT NOCOPY NUMBER,
21: x_msg_data OUT NOCOPY VARCHAR2 )
22:
23: IS
24: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PERIOD_MASKS_PUB.maintain_period_masks';
25: l_project_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
26: l_period_masks_s number := 0;
27:
28: l_language varchar2(100) := null;

Line 38: PA_DEBUG.init_err_stack('PAFPPMMB.PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK');

34: --l_from_anchor_position.delete;
35: l_return_status varchar2(30);
36: BEGIN
37: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
38: PA_DEBUG.init_err_stack('PAFPPMMB.PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK');
39: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
40: pa_debug.set_curr_function( p_function => 'maintain_period_masks'
41: ,p_debug_mode => p_pa_debug_mode);
42: END IF;

Line 231: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS',

227:
228: IF P_PA_DEBUG_MODE = 'Y' THEN
229: pa_fp_gen_amount_utils.fp_debug
230: (p_msg => 'Before calling
231: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS',
232: p_module_name => l_module_name,
233: p_log_level => 5);
234: END IF;
235: /*populating table pa_period_mask_details*/

Line 236: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS(

232: p_module_name => l_module_name,
233: p_log_level => 5);
234: END IF;
235: /*populating table pa_period_mask_details*/
236: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS(
237: p_period_mask_id => l_period_masks_s,
238: p_num_of_periods => p_num_of_periods,
239: p_anchor_period_flag => p_anchor_period_flag,
240: p_from_anchor_position => p_from_anchor_position,

Line 249: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTL: '

245: x_msg_data => x_msg_data);
246: IF P_PA_DEBUG_MODE = 'Y' THEN
247: pa_fp_gen_amount_utils.fp_debug
248: (p_msg => 'Status after calling
249: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTL: '
250: ||x_return_status,
251: p_module_name => l_module_name,
252: p_log_level => 5);
253: END IF;

Line 306: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS',

302:
303: IF P_PA_DEBUG_MODE = 'Y' THEN
304: pa_fp_gen_amount_utils.fp_debug
305: (p_msg => 'Before calling
306: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS',
307: p_module_name => l_module_name,
308: p_log_level => 5);
309: END IF;
310: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS(

Line 310: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS(

306: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS',
307: p_module_name => l_module_name,
308: p_log_level => 5);
309: END IF;
310: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS(
311: p_period_mask_id => p_period_mask_id,
312: p_num_of_periods => p_num_of_periods,
313: p_anchor_period_flag => p_anchor_period_flag,
314: p_from_anchor_position => p_from_anchor_position,

Line 323: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTL: '

319: x_msg_data => x_msg_data);
320: IF P_PA_DEBUG_MODE = 'Y' THEN
321: pa_fp_gen_amount_utils.fp_debug
322: (p_msg => 'Status after calling
323: PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTL: '
324: ||x_return_status,
325: p_module_name => l_module_name,
326: p_log_level => 5);
327: END IF;

Line 354: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PERIOD_MASKS_PUB',

350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: x_msg_count := 1;
352: x_msg_data := substr(SQLERRM,1,240);
353:
354: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PERIOD_MASKS_PUB',
355: p_procedure_name => 'maintain_period_masks');
356:
357: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
358: PA_DEBUG.reset_err_stack;

Line 380: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS';

376: x_return_status OUT NOCOPY VARCHAR2,
377: x_msg_count OUT NOCOPY NUMBER,
378: x_msg_data OUT NOCOPY VARCHAR2)
379: IS
380: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PERIOD_MASKS_PUB.MAINTAIN_PERIOD_MASK_DTLS';
381:
382: CURSOR succ_pd IS
383: SELECT from_anchor_position,num_of_periods FROM
384: pa_fp_period_mask_tmp WHERE from_anchor_position > 0 ORDER BY from_anchor_position;

Line 605: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PERIOD_MASKS_PUB.delete_period_mask';

601: x_return_status OUT NOCOPY VARCHAR2,
602: x_msg_count OUT NOCOPY NUMBER,
603: x_msg_data OUT NOCOPY VARCHAR2 )
604: IS
605: l_module_name VARCHAR2(100) := 'pa.plsql.PA_PERIOD_MASKS_PUB.delete_period_mask';
606: BEGIN
607: IF P_PA_DEBUG_MODE = 'Y' THEN
608: pa_debug.set_curr_function( p_function => 'delete_period_mask',
609: p_debug_mode => p_pa_debug_mode );

Line 657: END PA_PERIOD_MASKS_PUB;

653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END delete_period_mask;
655:
656:
657: END PA_PERIOD_MASKS_PUB;