[Home] [Help]
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
31: FND_MSG_PUB.Initialize;
32: END IF;
33:
40: AND p_period_mask_id <> period_mask_id
41: AND ROWNUM < 2;
42: --DBMS_OUTPUT.PUT_LINE(p_name || ' Already Exists');
43: --Duplicate Name should not be entered
44: x_return_status := FND_API.G_RET_STS_ERROR;
45: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
46: p_msg_name => 'PA_ALL_UNIQUE_NAME_EXISTS');
47: l_name_exists:=TRUE;
48: EXCEPTION
53: l_msg_count := FND_MSG_PUB.count_msg;
54: IF l_msg_count > 0 THEN
55: IF l_msg_count = 1 THEN
56: PA_INTERFACE_UTILS_PUB.get_messages
57: (p_encoded => FND_API.G_TRUE,
58: p_msg_index => 1,
59: p_msg_count => l_msg_count,
60: p_msg_data => l_msg_data,
61: p_data => l_data,
72:
73: RETURN;
74: EXCEPTION
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');
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');
91: END NAME_VALIDATION;
92:
93:
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;
117: END IF;
118: x_msg_count := 0;
119: /* SELECT num_of_periods
120: BULK COLLECT INTO l_num_of_periods
121: FROM pa_fp_period_mask_tmp; */
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;
140: p_msg_name => 'PA_FP_INVALID_NUM_HDR');
141: l_err_msg_flag := 'N';
142:
143: END IF;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
146: p_msg_name => 'PA_FP_INVALID_NUM',
147: p_token1 => 'INVNUM',
148: p_value1 => l_num_of_periods(j));
152: /* l_msg_count := FND_MSG_PUB.count_msg;
153: IF (l_msg_count > 0) THEN
154: IF (l_msg_count = 1) THEN
155: PA_INTERFACE_UTILS_PUB.get_messages
156: (p_encoded => FND_API.G_TRUE,
157: p_msg_index => 1,
158: p_msg_count => l_msg_count,
159: p_msg_data => l_msg_data,
160: p_data => l_data,
170: END IF;
171: RETURN;
172: EXCEPTION
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');
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;
189:
190:
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
227: FND_MSG_PUB.Initialize;
228: END IF;
229:
340: END IF;
341:
342: EXCEPTION
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');
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:
359: */
360: