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

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

127: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
128: x_work_permit_header_rec := l_work_permit_header_rec;
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132: x_work_permit_header_rec := l_work_permit_header_rec;
133:
134: END QUERY_ROW;
135:

Line 208: ,decode(p_work_permit_header_rec.PENDING_FLAG,FND_API.G_MISS_CHAR, NULL, p_work_permit_header_rec.PENDING_FLAG)

204: ,p_work_permit_header_rec.ORGANIZATION_ID
205: ,p_work_permit_header_rec.PERMIT_TYPE
206: ,p_work_permit_header_rec.VALID_FROM
207: ,p_work_permit_header_rec.VALID_TO
208: ,decode(p_work_permit_header_rec.PENDING_FLAG,FND_API.G_MISS_CHAR, NULL, p_work_permit_header_rec.PENDING_FLAG)
209: ,p_work_permit_header_rec.COMPLETION_DATE
210: ,p_work_permit_header_rec.USER_DEFINED_STATUS_ID
211: ,p_work_permit_header_rec.STATUS_TYPE
212: ,p_work_permit_header_rec.ATTRIBUTE_CATEGORY

Line 243: ,decode(p_work_permit_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_work_permit_header_rec.APPROVED_BY)

239: ,p_work_permit_header_rec.ATTRIBUTE27
240: ,p_work_permit_header_rec.ATTRIBUTE28
241: ,p_work_permit_header_rec.ATTRIBUTE29
242: ,p_work_permit_header_rec.ATTRIBUTE30
243: ,decode(p_work_permit_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_work_permit_header_rec.APPROVED_BY)
244: ,SYSDATE
245: ,FND_GLOBAL.user_id
246: ,SYSDATE
247: ,FND_GLOBAL.user_id

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: ,SYSDATE
247: ,FND_GLOBAL.user_id
248: ,FND_GLOBAL.login_id);
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252:
253: EXCEPTION
254: WHEN OTHERS THEN

Line 255: x_return_status := fnd_api.g_ret_sts_error;

251:
252:
253: EXCEPTION
254: WHEN OTHERS THEN
255: x_return_status := fnd_api.g_ret_sts_error;
256:
257: END INSERT_ROW;
258:
259: /********************************************************************

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: ,LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
321: WHERE permit_id = p_work_permit_header_rec.permit_id
322: AND organization_id = p_work_permit_header_rec.organization_id;
323:
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: END UPDATE_ROW;
327:
328:

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

337: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
338: , x_return_Status OUT NOCOPY VARCHAR2
339: )IS
340: l_msg_data VARCHAR2(240);
341: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
342: BEGIN
343:
344: IF p_work_permit_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
345: THEN

Line 365: x_return_status := fnd_api.g_ret_sts_error;

361: x_return_status := l_return_status;
362:
363: EXCEPTION
364: WHEN OTHERS THEN
365: x_return_status := fnd_api.g_ret_sts_error;
366:
367:
368: END PERFORM_WRITES;
369:

Line 416: raise fnd_api.g_exc_unexpected_error;

412: IF l_to_status_type NOT IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,
413: WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.DRAFT)
414: THEN
415:
416: raise fnd_api.g_exc_unexpected_error;
417:
418: END IF;
419:
420: -- Update status in permits table

Line 432: raise fnd_api.g_exc_unexpected_error;

428: AND permit_id = l_permit_id;
429:
430: EXCEPTION
431: WHEN OTHERS THEN
432: raise fnd_api.g_exc_unexpected_error;
433: END;
434:
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:

Line 435: x_return_status := FND_API.G_RET_STS_SUCCESS;

431: WHEN OTHERS THEN
432: raise fnd_api.g_exc_unexpected_error;
433: END;
434:
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437: EXCEPTION
438: WHEN fnd_api.g_exc_error THEN
439: ROLLBACK TO CHANGE_WORK_PERMIT_STATUS;

Line 438: WHEN fnd_api.g_exc_error THEN

434:
435: x_return_status := FND_API.G_RET_STS_SUCCESS;
436:
437: EXCEPTION
438: WHEN fnd_api.g_exc_error THEN
439: ROLLBACK TO CHANGE_WORK_PERMIT_STATUS;
440: x_return_status := fnd_api.g_ret_sts_error;
441:
442:

Line 440: x_return_status := fnd_api.g_ret_sts_error;

436:
437: EXCEPTION
438: WHEN fnd_api.g_exc_error THEN
439: ROLLBACK TO CHANGE_WORK_PERMIT_STATUS;
440: x_return_status := fnd_api.g_ret_sts_error;
441:
442:
443: WHEN OTHERS THEN
444: ROLLBACK TO CHANGE_WORK_PERMIT_STATUS;

Line 445: x_return_status := fnd_api.g_ret_sts_unexp_error;

441:
442:
443: WHEN OTHERS THEN
444: ROLLBACK TO CHANGE_WORK_PERMIT_STATUS;
445: x_return_status := fnd_api.g_ret_sts_unexp_error;
446:
447: END CHANGE_WORK_PERMIT_STATUS;
448:
449: