APPS.PA_PLAN_RES_DEFAULTS_PUB dependencies on FND_API

Line 37: x_return_status := FND_API.G_RET_STS_SUCCESS;

33:
34: --hr_utility.trace_on(NULL, 'RMCL');
35: --hr_utility.trace('strt update');
36: x_msg_count := 0;
37: x_return_status := FND_API.G_RET_STS_SUCCESS;
38:
39: IF P_PLAN_RES_DEF_ID_TBL.COUNT > 0 THEN
40: FOR i IN P_PLAN_RES_DEF_ID_TBL.FIRST .. P_PLAN_RES_DEF_ID_TBL.LAST LOOP
41: --hr_utility.trace('in first if ');

Line 51: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

47: where PLAN_RES_DEFAULT_ID = P_PLAN_RES_DEF_ID_TBL(i);
48:
49: EXCEPTION
50: WHEN NO_DATA_FOUND THEN
51: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
52: x_msg_count := x_msg_count + 1;
53: RETURN;
54: --FND_MSG_PUB.add_exc_msg(
55: --p_pkg_name => 'pa_plan_res_defaults_pub',

Line 172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

168: x_msg_count => x_msg_count ,
169: x_msg_data => x_msg_data);
170: --hr_utility.trace('x_return_status is | ' || x_return_status);
171:
172: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
173: pa_utils.add_message('PA', x_msg_data);
174: RETURN;
175: END IF;
176: END LOOP;

Line 181: x_return_status := FND_API.G_RET_STS_ERROR;

177: END IF;
178:
179: EXCEPTION
180: WHEN l_master_error THEN
181: x_return_status := FND_API.G_RET_STS_ERROR;
182: x_msg_data := 'PA_RES_ITEM_MASTER_USED';
183: x_msg_count := x_msg_count + 1;
184: pa_utils.add_message('PA', x_msg_data);
185: WHEN l_invalid_cat_set THEN -- Bug 3768550

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182: x_msg_data := 'PA_RES_ITEM_MASTER_USED';
183: x_msg_count := x_msg_count + 1;
184: pa_utils.add_message('PA', x_msg_data);
185: WHEN l_invalid_cat_set THEN -- Bug 3768550
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: x_msg_data := 'PA_RES_INV_ITEM_CAT_SET';
188: x_msg_count := x_msg_count + 1;
189: Pa_Utils.Add_Message(P_App_Short_Name => 'PA',
190: P_Msg_Name => 'PA_RES_INV_ITEM_CAT_SET',

Line 195: x_return_status := FND_API.G_RET_STS_ERROR;

191: p_token1 => 'CAT_NAME',
192: p_value1 => l_cat_name);
193:
194: WHEN l_category_error THEN
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: x_msg_data := 'PA_RES_ITEM_CATEGORY_USED';
197: x_msg_count := x_msg_count + 1;
198: pa_utils.add_message('PA', x_msg_data);
199: WHEN OTHERS THEN

Line 204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

200: -- FND_MSG_PUB.add_exc_msg(
201: -- p_pkg_name => 'pa_plan_res_defaults_pub.UPDATE_RESOURCE_DEFAULTS'
202: -- ,p_procedure_name => PA_DEBUG.G_Err_Stack);
203: x_msg_count := x_msg_count + 1;
204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
205: x_msg_data := substr(SQLERRM, 1, 25);
206:
207: end UPDATE_RESOURCE_DEFAULTS;
208: