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

Line 132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

128: WHEN NO_DATA_FOUND THEN
129: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
130: x_isolation_header_rec := l_isolation_header_rec;
131: WHEN OTHERS THEN
132: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
133: x_isolation_header_rec := l_isolation_header_rec;
134: END QUERY_ROW;
135:
136: /********************************************************************

Line 211: DECODE(p_isolation_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_isolation_header_rec.APPROVED_BY) ,

207: p_isolation_header_rec.PENDING_FLAG ,
208: p_isolation_header_rec.EFFECTIVE_START_DATE ,
209: p_isolation_header_rec.EFFECTIVE_END_DATE ,
210: p_isolation_header_rec.PERMIT_REQUIRED ,
211: DECODE(p_isolation_header_rec.APPROVED_BY, FND_API.G_MISS_CHAR, NULL, p_isolation_header_rec.APPROVED_BY) ,
212: p_isolation_header_rec.USER_DEFINED_STATUS ,
213: p_isolation_header_rec.SYSTEM_STATUS ,
214: p_isolation_header_rec.ATTRIBUTE_CATEGORY ,
215: p_isolation_header_rec.ATTRIBUTE1 ,

Line 251: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 254: x_return_status := fnd_api.g_ret_sts_error;

250: );
251: x_return_status := FND_API.G_RET_STS_SUCCESS;
252: EXCEPTION
253: WHEN OTHERS THEN
254: x_return_status := fnd_api.g_ret_sts_error;
255: END INSERT_ROW;
256:
257: /********************************************************************
258: * Procedure : UPDATE_ROW

Line 316: x_return_status := FND_API.G_RET_STS_SUCCESS;

312: LAST_UPDATED_BY =FND_GLOBAL.user_id ,
313: LAST_UPDATE_LOGIN =FND_GLOBAL.login_id
314: WHERE isolation_id = p_isolation_header_rec.isolation_id
315: AND organization_id = p_isolation_header_rec.organization_id;
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_return_status := fnd_api.g_ret_sts_error;
320: END UPDATE_ROW;

Line 319: x_return_status := fnd_api.g_ret_sts_error;

315: AND organization_id = p_isolation_header_rec.organization_id;
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_return_status := fnd_api.g_ret_sts_error;
320: END UPDATE_ROW;
321: /********************************************************************
322: * Procedure : PERFORM_WRITES
323: * Purpose : This is the only procedure that the user will have

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

328: x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type ,
329: x_return_Status OUT NOCOPY VARCHAR2 )
330: IS
331: l_msg_data VARCHAR2(240);
332: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
333: BEGIN
334: IF p_isolation_header_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE THEN
335: Insert_Row ( p_isolation_header_rec => p_isolation_header_rec
336: , x_return_Status => l_return_status

Line 347: x_return_status := fnd_api.g_ret_sts_error;

343: END IF;
344: x_return_status := l_return_status;
345: EXCEPTION
346: WHEN OTHERS THEN
347: x_return_status := fnd_api.g_ret_sts_error;
348: END PERFORM_WRITES;
349:
350: /********************************************************************
351: * Procedure : CHANGE_ISOLATION_STATUS

Line 386: raise fnd_api.g_exc_unexpected_error;

382: EAM_ERROR_MESSAGE_PVT.Write_Debug('Validating Status');
383: END IF;
384: -- Validate status_id
385: IF l_to_status_type NOT IN (WIP_CONSTANTS.RELEASED, WIP_CONSTANTS.COMP_CHRG,WIP_CONSTANTS.COMP_NOCHRG, WIP_CONSTANTS.CANCELLED, WIP_CONSTANTS.DRAFT) THEN
386: raise fnd_api.g_exc_unexpected_error;
387: END IF;
388: -- Update status in tablesolation
389: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN
390: EAM_ERROR_MESSAGE_PVT.Write_Debug('Update status in isolation table');

Line 399: raise fnd_api.g_exc_unexpected_error;

395: WHERE ORGANIZATION_ID = l_organization_id
396: AND isolation_id = l_isolation_id;
397: EXCEPTION
398: WHEN OTHERS THEN
399: raise fnd_api.g_exc_unexpected_error;
400: END;
401: EXCEPTION
402: WHEN fnd_api.g_exc_error THEN
403: ROLLBACK TO CHANGE_ISOLATION_STATUS;

Line 402: WHEN fnd_api.g_exc_error THEN

398: WHEN OTHERS THEN
399: raise fnd_api.g_exc_unexpected_error;
400: END;
401: EXCEPTION
402: WHEN fnd_api.g_exc_error THEN
403: ROLLBACK TO CHANGE_ISOLATION_STATUS;
404: x_return_status := fnd_api.g_ret_sts_error;
405: WHEN OTHERS THEN
406: ROLLBACK TO CHANGE_isolation_STATUS;

Line 404: x_return_status := fnd_api.g_ret_sts_error;

400: END;
401: EXCEPTION
402: WHEN fnd_api.g_exc_error THEN
403: ROLLBACK TO CHANGE_ISOLATION_STATUS;
404: x_return_status := fnd_api.g_ret_sts_error;
405: WHEN OTHERS THEN
406: ROLLBACK TO CHANGE_isolation_STATUS;
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: END CHANGE_isolation_STATUS;

Line 407: x_return_status := fnd_api.g_ret_sts_unexp_error;

403: ROLLBACK TO CHANGE_ISOLATION_STATUS;
404: x_return_status := fnd_api.g_ret_sts_error;
405: WHEN OTHERS THEN
406: ROLLBACK TO CHANGE_isolation_STATUS;
407: x_return_status := fnd_api.g_ret_sts_unexp_error;
408: END CHANGE_isolation_STATUS;
409: /*
410: PROCEDURE INSERT_ISOLATION_HISTORY_ROW
411: ( p_object_id IN NUMBER