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.EAM_CLEARANCE_UTILITY_PVT dependencies on FND_API

Line 150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

146: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
147: x_work_clearance_header_rec:= l_work_clearance_header_rec;
148:
149: WHEN OTHERS THEN
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: x_work_clearance_header_rec:= l_work_clearance_header_rec;
152:
153:
154: END QUERY_ROW;

Line 270: ,decode(p_work_clearance_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_work_clearance_header_rec.APPROVED_BY)

266: ,p_work_clearance_header_rec.ATTRIBUTE27
267: ,p_work_clearance_header_rec.ATTRIBUTE28
268: ,p_work_clearance_header_rec.ATTRIBUTE29
269: ,p_work_clearance_header_rec.ATTRIBUTE30
270: ,decode(p_work_clearance_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_work_clearance_header_rec.APPROVED_BY)
271: ,SYSDATE
272: ,FND_GLOBAL.user_id
273: ,SYSDATE
274: ,FND_GLOBAL.user_id

Line 277: x_return_status := FND_API.G_RET_STS_SUCCESS;

273: ,SYSDATE
274: ,FND_GLOBAL.user_id
275: ,FND_GLOBAL.login_id);
276:
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278:
279:
280: EXCEPTION
281: WHEN OTHERS THEN

Line 282: x_return_status := fnd_api.g_ret_sts_error;

278:
279:
280: EXCEPTION
281: WHEN OTHERS THEN
282: x_return_status := fnd_api.g_ret_sts_error;
283:
284: END INSERT_ROW;
285:
286: /********************************************************************

Line 353: x_return_status := FND_API.G_RET_STS_SUCCESS;

349: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
350: WHERE WORK_CLEARANCE_ID = p_work_clearance_header_rec.WORK_CLEARANCE_ID
351: AND organization_id = p_work_clearance_header_rec.organization_id;
352:
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354: EXCEPTION
355: WHEN OTHERS THEN
356: x_return_status := fnd_api.g_ret_sts_error;
357:

Line 356: x_return_status := fnd_api.g_ret_sts_error;

352:
353: x_return_status := FND_API.G_RET_STS_SUCCESS;
354: EXCEPTION
355: WHEN OTHERS THEN
356: x_return_status := fnd_api.g_ret_sts_error;
357:
358:
359: END UPDATE_ROW;
360:

Line 373: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

369: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
370: , x_return_Status OUT NOCOPY VARCHAR2
371: )IS
372: l_msg_data VARCHAR2(240);
373: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
374: BEGIN
375:
376: IF p_work_clearance_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
377: THEN

Line 398: x_return_status := fnd_api.g_ret_sts_error;

394: x_return_status := l_return_status;
395:
396: EXCEPTION
397: WHEN OTHERS THEN
398: x_return_status := fnd_api.g_ret_sts_error;
399:
400:
401: END PERFORM_WRITES;
402:

Line 446: raise fnd_api.g_exc_unexpected_error;

442: IF l_to_status_type NOT IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG,
443: WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.DRAFT)
444: THEN
445:
446: raise fnd_api.g_exc_unexpected_error;
447:
448: END IF;
449: -- Update status in clearance table
450: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in clearance table'); END IF;

Line 460: raise fnd_api.g_exc_unexpected_error;

456: AND WORK_CLEARANCE_ID = l_clearance_id;
457:
458: EXCEPTION
459: WHEN OTHERS THEN
460: raise fnd_api.g_exc_unexpected_error;
461: END;
462:
463: EXCEPTION
464: WHEN fnd_api.g_exc_error THEN

Line 464: WHEN fnd_api.g_exc_error THEN

460: raise fnd_api.g_exc_unexpected_error;
461: END;
462:
463: EXCEPTION
464: WHEN fnd_api.g_exc_error THEN
465: ROLLBACK TO CHANGE_CLEARANCE_STATUS;
466: x_return_status := fnd_api.g_ret_sts_error;
467:
468:

Line 466: x_return_status := fnd_api.g_ret_sts_error;

462:
463: EXCEPTION
464: WHEN fnd_api.g_exc_error THEN
465: ROLLBACK TO CHANGE_CLEARANCE_STATUS;
466: x_return_status := fnd_api.g_ret_sts_error;
467:
468:
469: WHEN OTHERS THEN
470: ROLLBACK TO CHANGE_CLEARANCE_STATUS;

Line 471: x_return_status := fnd_api.g_ret_sts_unexp_error;

467:
468:
469: WHEN OTHERS THEN
470: ROLLBACK TO CHANGE_CLEARANCE_STATUS;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472:
473: END CHANGE_CLEARANCE_STATUS;
474:
475: