APPS.PA_RES_LIST_MEMBERS_PKG dependencies on FND_API

Line 97: x_return_status := FND_API.G_RET_STS_SUCCESS;

93: x_return_status OUT NOCOPY VARCHAR2,
94: x_error_msg_data OUT NOCOPY VARCHAR2 )
95: IS
96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98:
99: INSERT INTO PA_RESOURCE_LIST_MEMBERS(
100: RESOURCE_LIST_MEMBER_ID,
101: RESOURCE_LIST_ID,

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

251: FND_GLOBAL.USER_ID,
252: FND_GLOBAL.LOGIN_ID);
253: EXCEPTION
254: WHEN OTHERS THEN
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256: x_msg_count := x_msg_count + 1;
257: RETURN;
258: END Insert_Row;
259: /*************************************************/

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

311: x_error_msg_data OUT NOCOPY VARCHAR2)
312: IS
313: l_mfc_cost_type_id Number;
314: BEGIN
315: x_return_status := FND_API.G_RET_STS_SUCCESS;
316: /*****************************************************************
317: * Bug - 3571205
318: * Desc - For MFC Cost Type ID, We need to do an extra chedck to
319: * determine if the user has explicitely Nulled out the

Line 321: * FND_API.G_MISS_NUM field. If the user wants to explicitely

317: * Bug - 3571205
318: * Desc - For MFC Cost Type ID, We need to do an extra chedck to
319: * determine if the user has explicitely Nulled out the
320: * field or not. This can be determined by checking the
321: * FND_API.G_MISS_NUM field. If the user wants to explicitely
322: * Null out the field then he should pass FND_API.G_MISS_NUM
323: * to the p_mfc_cost_type_id parameter.
324: *****************************************************************/
325: IF p_mfc_cost_type_id IS NOT NULL AND p_mfc_cost_type_id <> FND_API.G_MISS_NUM THEN

Line 322: * Null out the field then he should pass FND_API.G_MISS_NUM

318: * Desc - For MFC Cost Type ID, We need to do an extra chedck to
319: * determine if the user has explicitely Nulled out the
320: * field or not. This can be determined by checking the
321: * FND_API.G_MISS_NUM field. If the user wants to explicitely
322: * Null out the field then he should pass FND_API.G_MISS_NUM
323: * to the p_mfc_cost_type_id parameter.
324: *****************************************************************/
325: IF p_mfc_cost_type_id IS NOT NULL AND p_mfc_cost_type_id <> FND_API.G_MISS_NUM THEN
326: l_mfc_cost_type_id := p_mfc_cost_type_id;

Line 325: IF p_mfc_cost_type_id IS NOT NULL AND p_mfc_cost_type_id <> FND_API.G_MISS_NUM THEN

321: * FND_API.G_MISS_NUM field. If the user wants to explicitely
322: * Null out the field then he should pass FND_API.G_MISS_NUM
323: * to the p_mfc_cost_type_id parameter.
324: *****************************************************************/
325: IF p_mfc_cost_type_id IS NOT NULL AND p_mfc_cost_type_id <> FND_API.G_MISS_NUM THEN
326: l_mfc_cost_type_id := p_mfc_cost_type_id;
327: END IF;
328:
329: IF p_mfc_cost_type_id IS NULL THEN

Line 337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

333: FROM pa_resource_list_members
334: WHERE resource_list_member_id = p_resource_list_member_id;
335: EXCEPTION
336: WHEN OTHERS THEN
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: Return;
339: END;
340: END IF;
341:

Line 342: IF p_mfc_cost_type_id = FND_API.G_MISS_NUM THEN

338: Return;
339: END;
340: END IF;
341:
342: IF p_mfc_cost_type_id = FND_API.G_MISS_NUM THEN
343: l_mfc_cost_type_id := Null;
344: END IF;
345: /************************************************************
346: * Bug : 3494646

Line 409: FND_API.G_RET_STS_ERROR;

405: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
406: x_msg_count :=
407: x_msg_count + 1;
408: x_return_status :=
409: FND_API.G_RET_STS_ERROR;
410: x_error_msg_data :=
411: 'PA_XC_RECORD_CHANGED';
412: RETURN;
413: END IF;

Line 431: x_return_status := FND_API.G_RET_STS_SUCCESS;

427: x_msg_count IN OUT NOCOPY VARCHAR2,
428: x_return_status OUT NOCOPY VARCHAR2)
429: IS
430: BEGIN
431: x_return_status := FND_API.G_RET_STS_SUCCESS;
432: IF p_exist_res_list = 'Y' THEN
433: /*************************************************
434: * If 'Y' is returned from the above select, then
435: * we cannot Delete the resource list member. So

Line 450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

446: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
447: 'pa_create_resource_pub.delete_planning_resource'
448: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
449: x_msg_count := x_msg_count+1;
450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
451: END;
452: ELSE
453: /****************************************************
454: * If 'N' is returned from the above select. Then it means no

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

463: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
464: 'pa_create_resource_pub.delete_planning_resource'
465: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
466: x_msg_count := x_msg_count+1;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: END;
469: END IF;
470:
471: END Delete_Row;