DBA Data[Home] [Help]

APPS.PA_PERIOD_MASKS_PUB dependencies on FND_API

Line 44: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;
46:
47: IF p_init_msg_flag = 'Y' THEN
48: FND_MSG_PUB.Initialize;

Line 74: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

70: p_module_name => l_module_name,
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;

Line 111: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

107: p_module_name => l_module_name,
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;

Line 120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

116: END IF;
117: RETURN;
118: END IF;
119:
120: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
121: l_return_status := x_return_status;
122: END IF;
123:
124: /*********Number of Period Validation***********/

Line 147: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

143: ||x_return_status,
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;

Line 155: IF x_return_status = FND_API.G_RET_STS_ERROR 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
156: l_return_status := x_return_status;
157: END IF;
158: x_return_status := l_return_status;
159:

Line 160: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

156: l_return_status := x_return_status;
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;

Line 255: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

251: p_module_name => l_module_name,
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;

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: record_version_number = record_version_number + 1
276: WHERE period_mask_id = p_period_mask_id
277: and record_version_number = p_record_version_number;
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;

Line 328: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

324: ||x_return_status,
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;

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

346: END IF;
347:
348: EXCEPTION
349: WHEN OTHERS THEN
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',

Line 363: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
365: END maintain_period_masks;
366:
367:

Line 407: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
409: IF p_init_msg_flag = 'Y' THEN
410: FND_MSG_PUB.Initialize;
411: END IF;

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
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');

Line 591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
594:
595: --*************************

Line 611: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
614: IF p_init_msg_flag = 'Y' THEN
615: FND_MSG_PUB.Initialize;

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: DELETE FROM pa_period_masks_b
619: WHERE period_mask_id = p_period_mask_id
620: and record_version_number = p_record_version_number;
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;

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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');

Line 653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
656:
657: END PA_PERIOD_MASKS_PUB;