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_PERIOD_MASKS_PUB dependencies on PA_DEBUG

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

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(
6: p_period_mask_id IN NUMBER,
7: p_name IN VARCHAR2,

Line 37: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

33: --l_anchor_period_flag.delete;
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);

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 39: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

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;
43:

Line 40: pa_debug.set_curr_function( p_function => 'maintain_period_masks'

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;
43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 41: ,p_debug_mode => p_pa_debug_mode);

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;
43:
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45: x_msg_count := 0;

Line 52: IF P_PA_DEBUG_MODE = 'Y' THEN

48: FND_MSG_PUB.Initialize;
49: END IF;
50:
51: /*********Name Validation***********/
52: IF P_PA_DEBUG_MODE = 'Y' THEN
53: pa_fp_gen_amount_utils.fp_debug
54: (p_msg => 'Before calling pa_fp_period_masks_utils.name_validation',
55: p_module_name => l_module_name,
56: p_log_level => 5);

Line 65: IF P_PA_DEBUG_MODE = 'Y' THEN

61: p_init_msg_flag => 'N',
62: x_return_status => x_return_status,
63: x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data );
65: IF P_PA_DEBUG_MODE = 'Y' THEN
66: pa_fp_gen_amount_utils.fp_debug
67: (p_msg => 'Status after calling
68: pa_fp_period_masks_utils.name_validation: '
69: ||x_return_status,

Line 75: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

71: p_log_level => 5);
72: END IF;
73:
74: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
75: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
76: PA_DEBUG.reset_err_stack;
77: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
78: PA_DEBUG.Reset_Curr_Function;
79: END IF;

Line 76: PA_DEBUG.reset_err_stack;

72: END IF;
73:
74: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
75: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
76: PA_DEBUG.reset_err_stack;
77: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
78: PA_DEBUG.Reset_Curr_Function;
79: END IF;
80: RETURN;

Line 77: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

73:
74: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
75: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
76: PA_DEBUG.reset_err_stack;
77: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
78: PA_DEBUG.Reset_Curr_Function;
79: END IF;
80: RETURN;
81: END IF;

Line 78: PA_DEBUG.Reset_Curr_Function;

74: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
75: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
76: PA_DEBUG.reset_err_stack;
77: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
78: PA_DEBUG.Reset_Curr_Function;
79: END IF;
80: RETURN;
81: END IF;
82: l_return_status := x_return_status;

Line 88: IF P_PA_DEBUG_MODE = 'Y' THEN

84: /*********Effective Date Validation***********/
85: /**Doosan changes. Moved this api from pa_fin_plan_type_utils
86: *to pa_fin_plan_utils
87: *pa_fin_plan_types_utils.end_date_active_val(*/
88: IF P_PA_DEBUG_MODE = 'Y' THEN
89: pa_fp_gen_amount_utils.fp_debug
90: (p_msg => 'Before calling
91: pa_fp_period_masks_utils.end_date_active_val',
92: p_module_name => l_module_name,

Line 102: IF P_PA_DEBUG_MODE = 'Y' THEN

98: x_return_status => x_return_status,
99: x_msg_count => x_msg_count,
100: x_msg_data => x_msg_data);
101:
102: IF P_PA_DEBUG_MODE = 'Y' THEN
103: pa_fp_gen_amount_utils.fp_debug
104: (p_msg => 'Status after calling
105: pa_fp_period_masks_utils.end_date_active_val: '
106: ||x_return_status,

Line 112: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

108: p_log_level => 5);
109:
110: END IF;
111: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
112: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
113: PA_DEBUG.reset_err_stack;
114: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
115: PA_DEBUG.Reset_Curr_Function;
116: END IF;

Line 113: PA_DEBUG.reset_err_stack;

109:
110: END IF;
111: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
112: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
113: PA_DEBUG.reset_err_stack;
114: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
115: PA_DEBUG.Reset_Curr_Function;
116: END IF;
117: RETURN;

Line 114: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

110: END IF;
111: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
112: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
113: PA_DEBUG.reset_err_stack;
114: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
115: PA_DEBUG.Reset_Curr_Function;
116: END IF;
117: RETURN;
118: END IF;

Line 115: PA_DEBUG.Reset_Curr_Function;

111: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
112: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
113: PA_DEBUG.reset_err_stack;
114: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
115: PA_DEBUG.Reset_Curr_Function;
116: END IF;
117: RETURN;
118: END IF;
119:

Line 125: IF P_PA_DEBUG_MODE = 'Y' THEN

121: l_return_status := x_return_status;
122: END IF;
123:
124: /*********Number of Period Validation***********/
125: IF P_PA_DEBUG_MODE = 'Y' THEN
126: pa_fp_gen_amount_utils.fp_debug
127: (p_msg => 'Before calling
128: pa_fp_period_masks_utils.nop_validation',
129: p_module_name => l_module_name,

Line 139: IF P_PA_DEBUG_MODE = 'Y' THEN

135: p_error_flag_tab => p_error_flag_tab,
136: x_return_status => x_return_status,
137: x_msg_count => x_msg_count,
138: x_msg_data => x_msg_data);
139: IF P_PA_DEBUG_MODE = 'Y' THEN
140: pa_fp_gen_amount_utils.fp_debug
141: (p_msg => 'Status after calling
142: pa_fp_period_masks_utils.nop_validation: '
143: ||x_return_status,

Line 148: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

144: p_module_name => l_module_name,
145: p_log_level => 5);
146: END IF;
147: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
148: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
149: PA_DEBUG.reset_err_stack;
150: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
151: PA_DEBUG.Reset_Curr_Function;
152: END IF;

Line 149: PA_DEBUG.reset_err_stack;

145: p_log_level => 5);
146: END IF;
147: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
148: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
149: PA_DEBUG.reset_err_stack;
150: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
151: PA_DEBUG.Reset_Curr_Function;
152: END IF;
153: RETURN;

Line 150: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

146: END IF;
147: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
148: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
149: PA_DEBUG.reset_err_stack;
150: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
151: PA_DEBUG.Reset_Curr_Function;
152: END IF;
153: RETURN;
154: END IF;

Line 151: PA_DEBUG.Reset_Curr_Function;

147: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
148: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
149: PA_DEBUG.reset_err_stack;
150: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
151: PA_DEBUG.Reset_Curr_Function;
152: END IF;
153: RETURN;
154: END IF;
155: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 161: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

157: END IF;
158: x_return_status := l_return_status;
159:
160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
161: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
162: PA_DEBUG.reset_err_stack;
163: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
164: PA_DEBUG.Reset_Curr_Function;
165: END IF;

Line 162: PA_DEBUG.reset_err_stack;

158: x_return_status := l_return_status;
159:
160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
161: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
162: PA_DEBUG.reset_err_stack;
163: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
164: PA_DEBUG.Reset_Curr_Function;
165: END IF;
166: return;

Line 163: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

159:
160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
161: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
162: PA_DEBUG.reset_err_stack;
163: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
164: PA_DEBUG.Reset_Curr_Function;
165: END IF;
166: return;
167: END IF;

Line 164: PA_DEBUG.Reset_Curr_Function;

160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
161: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
162: PA_DEBUG.reset_err_stack;
163: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
164: PA_DEBUG.Reset_Curr_Function;
165: END IF;
166: return;
167: END IF;
168:

Line 228: IF P_PA_DEBUG_MODE = 'Y' THEN

224: (select null from PA_PERIOD_MASKS_TL T
225: where T.PERIOD_MASK_ID = l_period_masks_s
226: and T.LANGUAGE = L.LANGUAGE_CODE);
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,

Line 246: IF P_PA_DEBUG_MODE = 'Y' THEN

242: p_commit_flag => 'N',
243: x_return_status => x_return_status,
244: x_msg_count => x_msg_count,
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,

Line 256: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

252: p_log_level => 5);
253: END IF;
254:
255: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
257: PA_DEBUG.reset_err_stack;
258: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
259: PA_DEBUG.Reset_Curr_Function;
260: END IF;

Line 257: PA_DEBUG.reset_err_stack;

253: END IF;
254:
255: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
257: PA_DEBUG.reset_err_stack;
258: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
259: PA_DEBUG.Reset_Curr_Function;
260: END IF;
261: RETURN;

Line 258: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

254:
255: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
257: PA_DEBUG.reset_err_stack;
258: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
259: PA_DEBUG.Reset_Curr_Function;
260: END IF;
261: RETURN;
262: END IF;

Line 259: PA_DEBUG.Reset_Curr_Function;

255: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
256: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
257: PA_DEBUG.reset_err_stack;
258: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
259: PA_DEBUG.Reset_Curr_Function;
260: END IF;
261: RETURN;
262: END IF;
263:

Line 282: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

278: IF (sql%notfound) THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
281: p_msg_name => 'PA_FP_PM_INVALID');
282: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
283: PA_DEBUG.reset_err_stack;
284: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
285: PA_DEBUG.Reset_Curr_Function;
286: END IF;

Line 283: PA_DEBUG.reset_err_stack;

279: x_return_status := FND_API.G_RET_STS_ERROR;
280: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
281: p_msg_name => 'PA_FP_PM_INVALID');
282: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
283: PA_DEBUG.reset_err_stack;
284: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
285: PA_DEBUG.Reset_Curr_Function;
286: END IF;
287: RETURN;

Line 284: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

280: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
281: p_msg_name => 'PA_FP_PM_INVALID');
282: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
283: PA_DEBUG.reset_err_stack;
284: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
285: PA_DEBUG.Reset_Curr_Function;
286: END IF;
287: RETURN;
288: END IF;

Line 285: PA_DEBUG.Reset_Curr_Function;

281: p_msg_name => 'PA_FP_PM_INVALID');
282: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
283: PA_DEBUG.reset_err_stack;
284: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
285: PA_DEBUG.Reset_Curr_Function;
286: END IF;
287: RETURN;
288: END IF;
289:

Line 303: IF P_PA_DEBUG_MODE = 'Y' THEN

299: DELETE FROM pa_period_mask_details
300: WHERE period_mask_id = p_period_mask_id;
301: l_rec_count := p_num_of_periods.count();
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,

Line 320: IF P_PA_DEBUG_MODE = 'Y' THEN

316: p_commit_flag => 'N',
317: x_return_status => x_return_status,
318: x_msg_count => x_msg_count,
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,

Line 329: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

325: p_module_name => l_module_name,
326: p_log_level => 5);
327: END IF;
328: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
329: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
330: PA_DEBUG.reset_err_stack;
331: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
332: PA_DEBUG.Reset_Curr_Function;
333: END IF;

Line 330: PA_DEBUG.reset_err_stack;

326: p_log_level => 5);
327: END IF;
328: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
329: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
330: PA_DEBUG.reset_err_stack;
331: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
332: PA_DEBUG.Reset_Curr_Function;
333: END IF;
334: RETURN;

Line 331: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

327: END IF;
328: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
329: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
330: PA_DEBUG.reset_err_stack;
331: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
332: PA_DEBUG.Reset_Curr_Function;
333: END IF;
334: RETURN;
335: END IF;

Line 332: PA_DEBUG.Reset_Curr_Function;

328: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
329: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
330: PA_DEBUG.reset_err_stack;
331: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
332: PA_DEBUG.Reset_Curr_Function;
333: END IF;
334: RETURN;
335: END IF;
336:

Line 342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

338:
339: IF (p_commit_flag = 'Y') THEN
340: COMMIT;
341: END IF;
342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
343: PA_DEBUG.reset_err_stack;
344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
345: PA_DEBUG.Reset_Curr_Function;
346: END IF;

Line 343: PA_DEBUG.reset_err_stack;

339: IF (p_commit_flag = 'Y') THEN
340: COMMIT;
341: END IF;
342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
343: PA_DEBUG.reset_err_stack;
344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
345: PA_DEBUG.Reset_Curr_Function;
346: END IF;
347:

Line 344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

340: COMMIT;
341: END IF;
342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
343: PA_DEBUG.reset_err_stack;
344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
345: PA_DEBUG.Reset_Curr_Function;
346: END IF;
347:
348: EXCEPTION

Line 345: PA_DEBUG.Reset_Curr_Function;

341: END IF;
342: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
343: PA_DEBUG.reset_err_stack;
344: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
345: PA_DEBUG.Reset_Curr_Function;
346: END IF;
347:
348: EXCEPTION
349: WHEN OTHERS THEN

Line 357: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN

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;
359: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
360: PA_DEBUG.Reset_Curr_Function;
361: END IF;

Line 358: PA_DEBUG.reset_err_stack;

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;
359: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
360: PA_DEBUG.Reset_Curr_Function;
361: END IF;
362:

Line 359: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN

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;
359: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
360: PA_DEBUG.Reset_Curr_Function;
361: END IF;
362:
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 360: PA_DEBUG.Reset_Curr_Function;

356:
357: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
358: PA_DEBUG.reset_err_stack;
359: ELSIF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'N' THEN
360: PA_DEBUG.Reset_Curr_Function;
361: END IF;
362:
363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
364:

Line 402: IF P_PA_DEBUG_MODE = 'Y' THEN

398: l_flag_exists BOOLEAN := FALSE;
399:
400: l_count number;
401: BEGIN
402: IF P_PA_DEBUG_MODE = 'Y' THEN
403: pa_debug.set_curr_function( p_function => 'MAINTAIN_PERIOD_MASK_DTLS',
404: p_debug_mode => p_pa_debug_mode );
405: END IF;
406:

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

399:
400: l_count number;
401: BEGIN
402: IF P_PA_DEBUG_MODE = 'Y' THEN
403: pa_debug.set_curr_function( p_function => 'MAINTAIN_PERIOD_MASK_DTLS',
404: p_debug_mode => p_pa_debug_mode );
405: END IF;
406:
407: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 404: p_debug_mode => p_pa_debug_mode );

400: l_count number;
401: BEGIN
402: IF P_PA_DEBUG_MODE = 'Y' THEN
403: pa_debug.set_curr_function( p_function => 'MAINTAIN_PERIOD_MASK_DTLS',
404: p_debug_mode => p_pa_debug_mode );
405: END IF;
406:
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408:

Line 418: IF P_PA_DEBUG_MODE = 'Y' THEN

414:
415:
416: DELETE FROM pa_fp_period_mask_tmp;
417:
418: IF P_PA_DEBUG_MODE = 'Y' THEN
419: pa_fp_gen_amount_utils.fp_debug
420: (p_msg => 'Before inserting into temporary table',
421: p_module_name => l_module_name,
422: p_log_level => 5);

Line 429: IF P_PA_DEBUG_MODE = 'Y' THEN

425: FORALL i in p_num_of_periods.FIRST..p_num_of_periods.LAST
426: INSERT INTO pa_fp_period_mask_tmp(NUM_OF_PERIODS,ANCHOR_PERIOD_FLAG,FROM_ANCHOR_POSITION)
427: VALUES ( p_num_of_periods(i),p_anchor_period_flag(i),p_from_anchor_position(i));
428:
429: IF P_PA_DEBUG_MODE = 'Y' THEN
430: pa_fp_gen_amount_utils.fp_debug
431: (p_msg => 'After inserting into temporary table',
432: p_module_name => l_module_name,
433: p_log_level => 5);

Line 460: IF P_PA_DEBUG_MODE = 'Y' THEN

456: l_initial_flag := 'Y';
457: l_tmp := l_first_no_of_pds;
458: l_tmp_end := l_first_no_of_pds - 1;
459:
460: IF P_PA_DEBUG_MODE = 'Y' THEN
461: pa_fp_gen_amount_utils.fp_debug
462: (p_msg => 'Before succeeding period',
463: p_module_name => l_module_name,
464: p_log_level => 5);

Line 477: IF P_PA_DEBUG_MODE = 'Y' THEN

473:
474: l_tmp := l_tmp + succ_pd_rec.num_of_periods;
475: END LOOP;
476:
477: IF P_PA_DEBUG_MODE = 'Y' THEN
478: pa_fp_gen_amount_utils.fp_debug
479: (p_msg => 'After succeeding period',
480: p_module_name => l_module_name,
481: p_log_level => 5);

Line 487: IF P_PA_DEBUG_MODE = 'Y' THEN

483:
484: l_tmp := 0;
485: l_tmp_end := -1;
486:
487: IF P_PA_DEBUG_MODE = 'Y' THEN
488: pa_fp_gen_amount_utils.fp_debug
489: (p_msg => 'Before preceeding period',
490: p_module_name => l_module_name,
491: p_log_level => 5);

Line 505: IF P_PA_DEBUG_MODE = 'Y' THEN

501: l_tmp_end := l_tmp_end - prec_pd_rec.num_of_periods;
502:
503: END LOOP;
504:
505: IF P_PA_DEBUG_MODE = 'Y' THEN
506: pa_fp_gen_amount_utils.fp_debug
507: (p_msg => 'After preceeding period',
508: p_module_name => l_module_name,
509: p_log_level => 5);

Line 514: IF P_PA_DEBUG_MODE = 'Y' THEN

510: END IF;
511:
512: BEGIN
513:
514: IF P_PA_DEBUG_MODE = 'Y' THEN
515: pa_fp_gen_amount_utils.fp_debug
516: (p_msg => 'Before inserting additional records in the temporary table',
517: p_module_name => l_module_name,
518: p_log_level => 5);

Line 533: IF P_PA_DEBUG_MODE = 'Y' THEN

529: anchor_period_flag,from_anchor_start,from_anchor_end,from_anchor_position)
530: VALUES (0,'N',99999,99999,99999 );
531:
532:
533: IF P_PA_DEBUG_MODE = 'Y' THEN
534: pa_fp_gen_amount_utils.fp_debug
535: (p_msg => 'After inserting additional records in the temporary table',
536: p_module_name => l_module_name,
537: p_log_level => 5);

Line 567: IF P_PA_DEBUG_MODE = 'Y' THEN

563: sysdate FROM pa_fp_period_mask_tmp );
564:
565:
566: IF (SQL%NOTFOUND) THEN
567: IF P_PA_DEBUG_MODE = 'Y' THEN
568: PA_DEBUG.RESET_CURR_FUNCTION;
569: END IF;
570: RAISE no_data_found;
571: END IF;

Line 568: PA_DEBUG.RESET_CURR_FUNCTION;

564:
565:
566: IF (SQL%NOTFOUND) THEN
567: IF P_PA_DEBUG_MODE = 'Y' THEN
568: PA_DEBUG.RESET_CURR_FUNCTION;
569: END IF;
570: RAISE no_data_found;
571: END IF;
572:

Line 578: IF P_PA_DEBUG_MODE = 'Y' THEN

574:
575: if p_commit_flag = 'Y' then
576: COMMIT;
577: END IF;
578: IF P_PA_DEBUG_MODE = 'Y' THEN
579: PA_DEBUG.RESET_CURR_FUNCTION;
580: END IF;
581: EXCEPTION
582: WHEN OTHERS THEN

Line 579: PA_DEBUG.RESET_CURR_FUNCTION;

575: if p_commit_flag = 'Y' then
576: COMMIT;
577: END IF;
578: IF P_PA_DEBUG_MODE = 'Y' THEN
579: PA_DEBUG.RESET_CURR_FUNCTION;
580: END IF;
581: EXCEPTION
582: WHEN OTHERS THEN
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 588: IF P_PA_DEBUG_MODE = 'Y' THEN

584: x_msg_count := 1;
585: x_msg_data := SQLERRM;
586: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',
587: p_procedure_name => 'MAINTAIN_PERIOD_MASK_DTLS');
588: IF P_PA_DEBUG_MODE = 'Y' THEN
589: PA_DEBUG.RESET_CURR_FUNCTION;
590: END IF;
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592:

Line 589: PA_DEBUG.RESET_CURR_FUNCTION;

585: x_msg_data := SQLERRM;
586: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_UTILS',
587: p_procedure_name => 'MAINTAIN_PERIOD_MASK_DTLS');
588: IF P_PA_DEBUG_MODE = 'Y' THEN
589: PA_DEBUG.RESET_CURR_FUNCTION;
590: END IF;
591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
592:
593: END MAINTAIN_PERIOD_MASK_DTLS;

Line 607: IF P_PA_DEBUG_MODE = 'Y' THEN

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 );
610: END IF;
611: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 608: pa_debug.set_curr_function( p_function => 'delete_period_mask',

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 );
610: END IF;
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: x_msg_count := 0;

Line 609: p_debug_mode => p_pa_debug_mode );

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 );
610: END IF;
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612: x_msg_count := 0;
613:

Line 625: IF P_PA_DEBUG_MODE = 'Y' THEN

621: IF (sql%notfound) THEN
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
624: p_msg_name => 'PA_FP_PM_INVALID2');
625: IF P_PA_DEBUG_MODE = 'Y' THEN
626: PA_DEBUG.RESET_CURR_FUNCTION;
627: END IF;
628: RETURN;
629: END IF;

Line 626: PA_DEBUG.RESET_CURR_FUNCTION;

622: x_return_status := FND_API.G_RET_STS_ERROR;
623: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
624: p_msg_name => 'PA_FP_PM_INVALID2');
625: IF P_PA_DEBUG_MODE = 'Y' THEN
626: PA_DEBUG.RESET_CURR_FUNCTION;
627: END IF;
628: RETURN;
629: END IF;
630:

Line 640: IF P_PA_DEBUG_MODE = 'Y' THEN

636:
637: IF (p_commit_flag = 'Y') THEN
638: COMMIT;
639: END IF;
640: IF P_PA_DEBUG_MODE = 'Y' THEN
641: PA_DEBUG.RESET_CURR_FUNCTION;
642: END IF;
643: EXCEPTION
644: WHEN OTHERS THEN

Line 641: PA_DEBUG.RESET_CURR_FUNCTION;

637: IF (p_commit_flag = 'Y') THEN
638: COMMIT;
639: END IF;
640: IF P_PA_DEBUG_MODE = 'Y' THEN
641: PA_DEBUG.RESET_CURR_FUNCTION;
642: END IF;
643: EXCEPTION
644: WHEN OTHERS THEN
645: x_return_status := FND_API.G_RET_STS_ERROR;

Line 650: IF P_PA_DEBUG_MODE = 'Y' THEN

646: x_msg_count := 1;
647: x_msg_data := to_char(sqlcode);
648: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_PUB',
649: p_procedure_name => 'delete_period_mask');
650: IF P_PA_DEBUG_MODE = 'Y' THEN
651: PA_DEBUG.RESET_CURR_FUNCTION;
652: END IF;
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END delete_period_mask;

Line 651: PA_DEBUG.RESET_CURR_FUNCTION;

647: x_msg_data := to_char(sqlcode);
648: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_PERIOD_MASKS_PUB',
649: p_procedure_name => 'delete_period_mask');
650: IF P_PA_DEBUG_MODE = 'Y' THEN
651: PA_DEBUG.RESET_CURR_FUNCTION;
652: END IF;
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: END delete_period_mask;
655: