eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_PERIOD_MASKS_UTILS dependencies on PA_DEBUG

Line 7: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

3: /*********************************************************************
4: Important : The appropriate procedures that make a call to the below
5: procedures must make a call to FND_MSG_PUB.initialize.
6: **********************************************************************/
7: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
8:
9: PROCEDURE NAME_VALIDATION
10: (p_name IN pa_period_masks_tl.name%TYPE,
11: p_period_mask_id IN pa_period_masks_b.period_mask_id%TYPE,

Line 24: IF P_PA_DEBUG_MODE = 'Y' THEN

20: l_data VARCHAR2(2000);
21: l_msg_data VARCHAR2(2000);
22: l_name_exists boolean:=false;
23: BEGIN
24: IF P_PA_DEBUG_MODE = 'Y' THEN
25: pa_debug.set_curr_function( p_function => 'NAME_VALIDATION',
26: p_debug_mode => p_pa_debug_mode );
27: END IF;
28:

Line 25: pa_debug.set_curr_function( p_function => 'NAME_VALIDATION',

21: l_msg_data VARCHAR2(2000);
22: l_name_exists boolean:=false;
23: BEGIN
24: IF P_PA_DEBUG_MODE = 'Y' THEN
25: pa_debug.set_curr_function( p_function => 'NAME_VALIDATION',
26: p_debug_mode => p_pa_debug_mode );
27: END IF;
28:
29: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 26: p_debug_mode => p_pa_debug_mode );

22: l_name_exists boolean:=false;
23: BEGIN
24: IF P_PA_DEBUG_MODE = 'Y' THEN
25: pa_debug.set_curr_function( p_function => 'NAME_VALIDATION',
26: p_debug_mode => p_pa_debug_mode );
27: END IF;
28:
29: x_return_status := FND_API.G_RET_STS_SUCCESS;
30: IF p_init_msg_flag = 'Y' THEN

Line 69: IF P_PA_DEBUG_MODE = 'Y' THEN

65: ELSE
66: x_msg_count := l_msg_count;
67: END IF;
68: END IF;
69: IF P_PA_DEBUG_MODE = 'Y' THEN
70: PA_DEBUG.RESET_CURR_FUNCTION;
71: END IF;
72:
73: RETURN;

Line 70: PA_DEBUG.RESET_CURR_FUNCTION;

66: x_msg_count := l_msg_count;
67: END IF;
68: END IF;
69: IF P_PA_DEBUG_MODE = 'Y' THEN
70: PA_DEBUG.RESET_CURR_FUNCTION;
71: END IF;
72:
73: RETURN;
74: EXCEPTION

Line 81: IF P_PA_DEBUG_MODE = 'Y' THEN

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),
84: p_module_name => l_module_name,
85: p_log_level => 5);

Line 86: PA_DEBUG.RESET_CURR_FUNCTION;

82: pa_fp_gen_amount_utils.fp_debug
83: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
84: p_module_name => l_module_name,
85: p_log_level => 5);
86: PA_DEBUG.RESET_CURR_FUNCTION;
87: END IF;
88:
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: -- DBMS_OUTPUT.PUT_LINE('ERROR MSG FROM WHEN OTHER EXCEPTION');

Line 110: IF P_PA_DEBUG_MODE = 'Y' THEN

106: l_data VARCHAR2(2000);
107: l_msg_data VARCHAR2(2000);
108: l_err_msg_flag VARCHAR2(1):='Y';
109: BEGIN
110: IF P_PA_DEBUG_MODE = 'Y' THEN
111: pa_debug.set_curr_function( p_function => 'NOP_VALIDATION',
112: p_debug_mode => p_pa_debug_mode );
113: END IF;
114: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 111: pa_debug.set_curr_function( p_function => 'NOP_VALIDATION',

107: l_msg_data VARCHAR2(2000);
108: l_err_msg_flag VARCHAR2(1):='Y';
109: BEGIN
110: IF P_PA_DEBUG_MODE = 'Y' THEN
111: pa_debug.set_curr_function( p_function => 'NOP_VALIDATION',
112: p_debug_mode => p_pa_debug_mode );
113: END IF;
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115: IF p_init_msg_flag = 'Y' THEN

Line 112: p_debug_mode => p_pa_debug_mode );

108: l_err_msg_flag VARCHAR2(1):='Y';
109: BEGIN
110: IF P_PA_DEBUG_MODE = 'Y' THEN
111: pa_debug.set_curr_function( p_function => 'NOP_VALIDATION',
112: p_debug_mode => p_pa_debug_mode );
113: END IF;
114: x_return_status := FND_API.G_RET_STS_SUCCESS;
115: IF p_init_msg_flag = 'Y' THEN
116: FND_MSG_PUB.Initialize;

Line 126: IF P_PA_DEBUG_MODE = 'Y' THEN

122: if p_num_of_periods.count = 0 then
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
125: p_msg_name => 'PA_FP_NO_PM_DTLS');
126: IF P_PA_DEBUG_MODE = 'Y' THEN
127: PA_DEBUG.RESET_CURR_FUNCTION;
128: END IF;
129: RETURN;
130: end if;

Line 127: PA_DEBUG.RESET_CURR_FUNCTION;

123: x_return_status := FND_API.G_RET_STS_ERROR;
124: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
125: p_msg_name => 'PA_FP_NO_PM_DTLS');
126: IF P_PA_DEBUG_MODE = 'Y' THEN
127: PA_DEBUG.RESET_CURR_FUNCTION;
128: END IF;
129: RETURN;
130: end if;
131: l_num_of_periods := p_num_of_periods;

Line 168: IF P_PA_DEBUG_MODE = 'Y' THEN

164: ELSE
165: x_msg_count := l_msg_count;
166: END IF;
167: END IF; */
168: IF P_PA_DEBUG_MODE = 'Y' THEN
169: PA_DEBUG.RESET_CURR_FUNCTION;
170: END IF;
171: RETURN;
172: EXCEPTION

Line 169: PA_DEBUG.RESET_CURR_FUNCTION;

165: x_msg_count := l_msg_count;
166: END IF;
167: END IF; */
168: IF P_PA_DEBUG_MODE = 'Y' THEN
169: PA_DEBUG.RESET_CURR_FUNCTION;
170: END IF;
171: RETURN;
172: EXCEPTION
173: WHEN OTHERS THEN

Line 179: IF P_PA_DEBUG_MODE = 'Y' THEN

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),
182: p_module_name => l_module_name,
183: p_log_level => 5);

Line 184: PA_DEBUG.RESET_CURR_FUNCTION;

180: pa_fp_gen_amount_utils.fp_debug
181: (p_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
182: p_module_name => l_module_name,
183: p_log_level => 5);
184: PA_DEBUG.RESET_CURR_FUNCTION;
185: END IF;
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187: -- DBMS_OUTPUT.PUT_LINE('ERROR MSG FROM WHEN OTHER EXCEPTION');
188: END NOP_VALIDATION;

Line 220: IF P_PA_DEBUG_MODE = 'Y' THEN

216: l_anchor_period_flag PA_VC_1000_150;
217: l_flag_exists BOOLEAN := FALSE;
218: l_count number;
219: BEGIN
220: IF P_PA_DEBUG_MODE = 'Y' THEN
221: pa_debug.set_curr_function( p_function => 'MAINTAIN_PERIOD_MASK_DTLS',
222: p_debug_mode => p_pa_debug_mode );
223: END IF;
224:

Line 221: pa_debug.set_curr_function( p_function => 'MAINTAIN_PERIOD_MASK_DTLS',

217: l_flag_exists BOOLEAN := FALSE;
218: l_count number;
219: BEGIN
220: IF P_PA_DEBUG_MODE = 'Y' THEN
221: pa_debug.set_curr_function( p_function => 'MAINTAIN_PERIOD_MASK_DTLS',
222: p_debug_mode => p_pa_debug_mode );
223: END IF;
224:
225: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 222: p_debug_mode => p_pa_debug_mode );

218: l_count number;
219: BEGIN
220: IF P_PA_DEBUG_MODE = 'Y' THEN
221: pa_debug.set_curr_function( p_function => 'MAINTAIN_PERIOD_MASK_DTLS',
222: p_debug_mode => p_pa_debug_mode );
223: END IF;
224:
225: x_return_status := FND_API.G_RET_STS_SUCCESS;
226: IF p_init_msg_flag = 'Y' THEN

Line 232: IF P_PA_DEBUG_MODE = 'Y' THEN

228: END IF;
229:
230: x_msg_count := 0;
231: DELETE FROM pa_fp_period_mask_tmp;
232: IF P_PA_DEBUG_MODE = 'Y' THEN
233: PA_DEBUG.g_err_stage := 'Before inserting into temporary table';
234: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
235: END IF;
236: FORALL i in p_num_of_periods.FIRST..p_num_of_periods.LAST

Line 233: PA_DEBUG.g_err_stage := 'Before inserting into temporary table';

229:
230: x_msg_count := 0;
231: DELETE FROM pa_fp_period_mask_tmp;
232: IF P_PA_DEBUG_MODE = 'Y' THEN
233: PA_DEBUG.g_err_stage := 'Before inserting into temporary table';
234: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
235: END IF;
236: FORALL i in p_num_of_periods.FIRST..p_num_of_periods.LAST
237: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)

Line 234: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

230: x_msg_count := 0;
231: DELETE FROM pa_fp_period_mask_tmp;
232: IF P_PA_DEBUG_MODE = 'Y' THEN
233: PA_DEBUG.g_err_stage := 'Before inserting into temporary table';
234: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
235: END IF;
236: FORALL i in p_num_of_periods.FIRST..p_num_of_periods.LAST
237: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)
238: VALUES ( p_num_of_periods(i),p_anchor_period_flag(i),p_from_anchor_position(i));

Line 239: IF P_PA_DEBUG_MODE = 'Y' THEN

235: END IF;
236: FORALL i in p_num_of_periods.FIRST..p_num_of_periods.LAST
237: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)
238: VALUES ( p_num_of_periods(i),p_anchor_period_flag(i),p_from_anchor_position(i));
239: IF P_PA_DEBUG_MODE = 'Y' THEN
240: PA_DEBUG.g_err_stage := 'After inserting into temporary table';
241: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
242: END IF;
243: select count(*) into l_count

Line 240: PA_DEBUG.g_err_stage := 'After inserting into temporary table';

236: FORALL i in p_num_of_periods.FIRST..p_num_of_periods.LAST
237: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)
238: VALUES ( p_num_of_periods(i),p_anchor_period_flag(i),p_from_anchor_position(i));
239: IF P_PA_DEBUG_MODE = 'Y' THEN
240: PA_DEBUG.g_err_stage := 'After inserting into temporary table';
241: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
242: END IF;
243: select count(*) into l_count
244: from pa_fp_period_mask_tmp

Line 241: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

237: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)
238: VALUES ( p_num_of_periods(i),p_anchor_period_flag(i),p_from_anchor_position(i));
239: IF P_PA_DEBUG_MODE = 'Y' THEN
240: PA_DEBUG.g_err_stage := 'After inserting into temporary table';
241: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
242: END IF;
243: select count(*) into l_count
244: from pa_fp_period_mask_tmp
245: where anchor_period_flag = 'Y';

Line 264: IF P_PA_DEBUG_MODE = 'Y' THEN

260: WHERE anchor_period_flag = 'Y';
261: l_initial_flag := 'Y';
262: l_tmp := l_first_no_of_pds;
263: l_tmp_end := l_first_no_of_pds - 1;
264: IF P_PA_DEBUG_MODE = 'Y' THEN
265: PA_DEBUG.g_err_stage := 'Before succeeding period';
266: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
267: END IF;
268: FOR succ_pd_rec IN succ_pd LOOP

Line 265: PA_DEBUG.g_err_stage := 'Before succeeding period';

261: l_initial_flag := 'Y';
262: l_tmp := l_first_no_of_pds;
263: l_tmp_end := l_first_no_of_pds - 1;
264: IF P_PA_DEBUG_MODE = 'Y' THEN
265: PA_DEBUG.g_err_stage := 'Before succeeding period';
266: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
267: END IF;
268: FOR succ_pd_rec IN succ_pd LOOP
269: l_tmp_end := l_tmp_end + succ_pd_rec.num_of_periods;

Line 266: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

262: l_tmp := l_first_no_of_pds;
263: l_tmp_end := l_first_no_of_pds - 1;
264: IF P_PA_DEBUG_MODE = 'Y' THEN
265: PA_DEBUG.g_err_stage := 'Before succeeding period';
266: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
267: END IF;
268: FOR succ_pd_rec IN succ_pd LOOP
269: l_tmp_end := l_tmp_end + succ_pd_rec.num_of_periods;
270: UPDATE pa_fp_period_mask_tmp

Line 276: IF P_PA_DEBUG_MODE = 'Y' THEN

272: WHERE from_anchor_position = succ_pd_rec.from_anchor_position;
273:
274: l_tmp := l_tmp + succ_pd_rec.num_of_periods;
275: END LOOP;
276: IF P_PA_DEBUG_MODE = 'Y' THEN
277: PA_DEBUG.g_err_stage := 'After succeeding period';
278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
279: END IF;
280: l_tmp := 0;

Line 277: PA_DEBUG.g_err_stage := 'After succeeding period';

273:
274: l_tmp := l_tmp + succ_pd_rec.num_of_periods;
275: END LOOP;
276: IF P_PA_DEBUG_MODE = 'Y' THEN
277: PA_DEBUG.g_err_stage := 'After succeeding period';
278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
279: END IF;
280: l_tmp := 0;
281: l_tmp_end := -1;

Line 278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

274: l_tmp := l_tmp + succ_pd_rec.num_of_periods;
275: END LOOP;
276: IF P_PA_DEBUG_MODE = 'Y' THEN
277: PA_DEBUG.g_err_stage := 'After succeeding period';
278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
279: END IF;
280: l_tmp := 0;
281: l_tmp_end := -1;
282: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 282: IF P_PA_DEBUG_MODE = 'Y' THEN

278: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
279: END IF;
280: l_tmp := 0;
281: l_tmp_end := -1;
282: IF P_PA_DEBUG_MODE = 'Y' THEN
283: PA_DEBUG.g_err_stage := 'Before preceeding period';
284: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
285: END IF;
286: FOR prec_pd_rec IN prec_pd LOOP

Line 283: PA_DEBUG.g_err_stage := 'Before preceeding period';

279: END IF;
280: l_tmp := 0;
281: l_tmp_end := -1;
282: IF P_PA_DEBUG_MODE = 'Y' THEN
283: PA_DEBUG.g_err_stage := 'Before preceeding period';
284: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
285: END IF;
286: FOR prec_pd_rec IN prec_pd LOOP
287: l_tmp := l_tmp - prec_pd_rec.num_of_periods;

Line 284: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

280: l_tmp := 0;
281: l_tmp_end := -1;
282: IF P_PA_DEBUG_MODE = 'Y' THEN
283: PA_DEBUG.g_err_stage := 'Before preceeding period';
284: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
285: END IF;
286: FOR prec_pd_rec IN prec_pd LOOP
287: l_tmp := l_tmp - prec_pd_rec.num_of_periods;
288: UPDATE pa_fp_period_mask_tmp

Line 295: IF P_PA_DEBUG_MODE = 'Y' THEN

291:
292: l_tmp_end := l_tmp_end - prec_pd_rec.num_of_periods;
293: END LOOP;
294:
295: IF P_PA_DEBUG_MODE = 'Y' THEN
296: PA_DEBUG.g_err_stage := 'After preceeding period';
297: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
298: END IF;
299: BEGIN

Line 296: PA_DEBUG.g_err_stage := 'After preceeding period';

292: l_tmp_end := l_tmp_end - prec_pd_rec.num_of_periods;
293: END LOOP;
294:
295: IF P_PA_DEBUG_MODE = 'Y' THEN
296: PA_DEBUG.g_err_stage := 'After preceeding period';
297: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
298: END IF;
299: BEGIN
300: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 297: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

293: END LOOP;
294:
295: IF P_PA_DEBUG_MODE = 'Y' THEN
296: PA_DEBUG.g_err_stage := 'After preceeding period';
297: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
298: END IF;
299: BEGIN
300: IF P_PA_DEBUG_MODE = 'Y' THEN
301: PA_DEBUG.g_err_stage := 'Before inserting additional records in the temporary table';

Line 300: IF P_PA_DEBUG_MODE = 'Y' THEN

296: PA_DEBUG.g_err_stage := 'After preceeding period';
297: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
298: END IF;
299: BEGIN
300: IF P_PA_DEBUG_MODE = 'Y' THEN
301: PA_DEBUG.g_err_stage := 'Before inserting additional records in the temporary table';
302: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
303: END IF;
304: INSERT INTO pa_fp_period_mask_tmp(num_of_periods,

Line 301: PA_DEBUG.g_err_stage := 'Before inserting additional records in the temporary table';

297: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
298: END IF;
299: BEGIN
300: IF P_PA_DEBUG_MODE = 'Y' THEN
301: PA_DEBUG.g_err_stage := 'Before inserting additional records in the temporary table';
302: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
303: END IF;
304: INSERT INTO pa_fp_period_mask_tmp(num_of_periods,
305: anchor_period_flag,

Line 302: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

298: END IF;
299: BEGIN
300: IF P_PA_DEBUG_MODE = 'Y' THEN
301: PA_DEBUG.g_err_stage := 'Before inserting additional records in the temporary table';
302: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
303: END IF;
304: INSERT INTO pa_fp_period_mask_tmp(num_of_periods,
305: anchor_period_flag,
306: from_anchor_start,from_anchor_end,from_anchor_position)

Line 311: IF P_PA_DEBUG_MODE = 'Y' THEN

307: VALUES (0,'N',-99999,-99999,-99999);
308: INSERT INTO pa_fp_period_mask_tmp(num_of_periods,
309: anchor_period_flag,from_anchor_start,from_anchor_end,from_anchor_position)
310: VALUES (0,'N',99999,99999,99999);
311: IF P_PA_DEBUG_MODE = 'Y' THEN
312: PA_DEBUG.g_err_stage := 'After inserting additional records in the temporary table';
313: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
314: END IF;
315: INSERT INTO pa_period_mask_details(PERIOD_MASK_ID,

Line 312: PA_DEBUG.g_err_stage := 'After inserting additional records in the temporary table';

308: INSERT INTO pa_fp_period_mask_tmp(num_of_periods,
309: anchor_period_flag,from_anchor_start,from_anchor_end,from_anchor_position)
310: VALUES (0,'N',99999,99999,99999);
311: IF P_PA_DEBUG_MODE = 'Y' THEN
312: PA_DEBUG.g_err_stage := 'After inserting additional records in the temporary table';
313: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
314: END IF;
315: INSERT INTO pa_period_mask_details(PERIOD_MASK_ID,
316: num_of_periods,

Line 313: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

309: anchor_period_flag,from_anchor_start,from_anchor_end,from_anchor_position)
310: VALUES (0,'N',99999,99999,99999);
311: IF P_PA_DEBUG_MODE = 'Y' THEN
312: PA_DEBUG.g_err_stage := 'After inserting additional records in the temporary table';
313: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
314: END IF;
315: INSERT INTO pa_period_mask_details(PERIOD_MASK_ID,
316: num_of_periods,
317: anchor_period_flag,

Line 334: IF P_PA_DEBUG_MODE = 'Y' THEN

330: END;
331: IF p_commit_flag = 'Y' THEN
332: COMMIT;
333: END IF;
334: IF P_PA_DEBUG_MODE = 'Y' THEN
335: PA_DEBUG.RESET_CURR_FUNCTION;
336: END IF;
337:
338: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 335: PA_DEBUG.RESET_CURR_FUNCTION;

331: IF p_commit_flag = 'Y' THEN
332: COMMIT;
333: END IF;
334: IF P_PA_DEBUG_MODE = 'Y' THEN
335: PA_DEBUG.RESET_CURR_FUNCTION;
336: END IF;
337:
338: IF P_PA_DEBUG_MODE = 'Y' THEN
339: PA_DEBUG.RESET_CURR_FUNCTION;

Line 338: IF P_PA_DEBUG_MODE = 'Y' THEN

334: IF P_PA_DEBUG_MODE = 'Y' THEN
335: PA_DEBUG.RESET_CURR_FUNCTION;
336: END IF;
337:
338: IF P_PA_DEBUG_MODE = 'Y' THEN
339: PA_DEBUG.RESET_CURR_FUNCTION;
340: END IF;
341:
342: EXCEPTION

Line 339: PA_DEBUG.RESET_CURR_FUNCTION;

335: PA_DEBUG.RESET_CURR_FUNCTION;
336: END IF;
337:
338: IF P_PA_DEBUG_MODE = 'Y' THEN
339: PA_DEBUG.RESET_CURR_FUNCTION;
340: END IF;
341:
342: EXCEPTION
343: WHEN OTHERS THEN

Line 349: IF P_PA_DEBUG_MODE = 'Y' THEN

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,
352: x_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
353: x_log_level => 5);

Line 350: pa_debug.write_log(

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,
352: x_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
353: x_log_level => 5);
354: PA_DEBUG.RESET_CURR_FUNCTION;

Line 354: PA_DEBUG.RESET_CURR_FUNCTION;

350: pa_debug.write_log(
351: x_module => l_module_name,
352: x_msg => 'Unexpected Error'||substr(sqlerrm, 1, 240),
353: x_log_level => 5);
354: PA_DEBUG.RESET_CURR_FUNCTION;
355: END IF;
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: END MAINTAIN_PERIOD_MASK_DTLS;
358: