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_RES_LIST_MEMBERS_PKG dependencies on FND_API

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: x_error_msg_data OUT NOCOPY VARCHAR2 )
96: IS
97: l_resource_list_id pa_resource_list_members.resource_list_id%type;--Added for Bug13535688 & 13546557 for CBS project
98: BEGIN
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101: INSERT INTO PA_RESOURCE_LIST_MEMBERS(
102: RESOURCE_LIST_MEMBER_ID,
103: RESOURCE_LIST_ID,

Line 276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

272: END IF;
273:
274: EXCEPTION
275: WHEN OTHERS THEN
276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
277: x_msg_count := x_msg_count + 1;
278: RETURN;
279: END Insert_Row;
280: /*************************************************/

Line 338: x_return_status := FND_API.G_RET_STS_SUCCESS;

334: IS
335: l_mfc_cost_type_id Number;
336: l_resource_list_id pa_resource_list_members.resource_list_id%type; --Added for Bug13535688 13546557 for CBS project
337: BEGIN
338: x_return_status := FND_API.G_RET_STS_SUCCESS;
339: /*****************************************************************
340: * Bug - 3571205
341: * Desc - For MFC Cost Type ID, We need to do an extra chedck to
342: * determine if the user has explicitely Nulled out the

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

340: * Bug - 3571205
341: * Desc - For MFC Cost Type ID, We need to do an extra chedck to
342: * determine if the user has explicitely Nulled out the
343: * field or not. This can be determined by checking the
344: * FND_API.G_MISS_NUM field. If the user wants to explicitely
345: * Null out the field then he should pass FND_API.G_MISS_NUM
346: * to the p_mfc_cost_type_id parameter.
347: *****************************************************************/
348: IF p_mfc_cost_type_id IS NOT NULL AND p_mfc_cost_type_id <> FND_API.G_MISS_NUM THEN

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

341: * Desc - For MFC Cost Type ID, We need to do an extra chedck to
342: * determine if the user has explicitely Nulled out the
343: * field or not. This can be determined by checking the
344: * FND_API.G_MISS_NUM field. If the user wants to explicitely
345: * Null out the field then he should pass FND_API.G_MISS_NUM
346: * to the p_mfc_cost_type_id parameter.
347: *****************************************************************/
348: IF p_mfc_cost_type_id IS NOT NULL AND p_mfc_cost_type_id <> FND_API.G_MISS_NUM THEN
349: l_mfc_cost_type_id := p_mfc_cost_type_id;

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

344: * FND_API.G_MISS_NUM field. If the user wants to explicitely
345: * Null out the field then he should pass FND_API.G_MISS_NUM
346: * to the p_mfc_cost_type_id parameter.
347: *****************************************************************/
348: IF p_mfc_cost_type_id IS NOT NULL AND p_mfc_cost_type_id <> FND_API.G_MISS_NUM THEN
349: l_mfc_cost_type_id := p_mfc_cost_type_id;
350: END IF;
351:
352: IF p_mfc_cost_type_id IS NULL THEN

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: FROM pa_resource_list_members
357: WHERE resource_list_member_id = p_resource_list_member_id;
358: EXCEPTION
359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: Return;
362: END;
363: END IF;
364:

Line 365: IF p_mfc_cost_type_id = FND_API.G_MISS_NUM THEN

361: Return;
362: END;
363: END IF;
364:
365: IF p_mfc_cost_type_id = FND_API.G_MISS_NUM THEN
366: l_mfc_cost_type_id := Null;
367: END IF;
368: /************************************************************
369: * Bug : 3494646

Line 433: FND_API.G_RET_STS_ERROR;

429: ,p_msg_name => 'PA_XC_RECORD_CHANGED');
430: x_msg_count :=
431: x_msg_count + 1;
432: x_return_status :=
433: FND_API.G_RET_STS_ERROR;
434: x_error_msg_data :=
435: 'PA_XC_RECORD_CHANGED';
436: RETURN;
437: END IF;

Line 471: x_return_status := FND_API.G_RET_STS_SUCCESS;

467: x_msg_count IN OUT NOCOPY VARCHAR2,
468: x_return_status OUT NOCOPY VARCHAR2)
469: IS
470: BEGIN
471: x_return_status := FND_API.G_RET_STS_SUCCESS;
472: IF p_exist_res_list = 'Y' THEN
473: /*************************************************
474: * If 'Y' is returned from the above select, then
475: * we cannot Delete the resource list member. So

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

486: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
487: 'pa_create_resource_pub.delete_planning_resource'
488: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
489: x_msg_count := x_msg_count+1;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
491: END;
492: ELSE
493: /****************************************************
494: * If 'N' is returned from the above select. Then it means no

Line 507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

503: FND_MSG_PUB.add_exc_msg( p_pkg_name =>
504: 'pa_create_resource_pub.delete_planning_resource'
505: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
506: x_msg_count := x_msg_count+1;
507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
508: END;
509: END IF;
510:
511: END Delete_Row;