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_SAFETY_UTILITY_PVT dependencies on EAM_PROCESS_WO_PVT

Line 113: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;

109: WHERE esa.SOURCE_ID = p_source_id
110: AND esa.organization_id = p_organization_id
111: AND esa.ASSOCIATION_TYPE = p_association_type;
112:
113: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_FOUND;
114: x_safety_association_rec := l_safety_association_rec;
115:
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN

Line 118: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;

114: x_safety_association_rec := l_safety_association_rec;
115:
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN
118: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
119: x_safety_association_rec := l_safety_association_rec;
120:
121: WHEN OTHERS THEN
122: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 147: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inserting Safety Association Row'); END IF;

143:
144: -- l_organization_id NUMBER;
145:
146: BEGIN
147: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Inserting Safety Association Row'); END IF;
148:
149: INSERT INTO EAM_SAFETY_ASSOCIATIONS(
150: SAFETY_ASSOCIATION_ID
151: ,SOURCE_ID

Line 267: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Safety Association Row'); END IF;

263: )IS
264:
265:
266: BEGIN
267: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Safety Association Row'); END IF;
268:
269: UPDATE EAM_SAFETY_ASSOCIATIONS
270: SET
271: TARGET_REF_ID =p_safety_association_rec.TARGET_REF_ID

Line 337: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Safety Association Row'); END IF;

333: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
334: , x_return_Status OUT NOCOPY VARCHAR2
335: )IS
336: BEGIN
337: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Safety Association Row'); END IF;
338:
339: -- Deleting attachments before deleting any association
340:
341: FND_ATTACHED_DOCUMENTS2_PKG.DELETE_ATTACHMENTS(

Line 380: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing Safety Association Row'); END IF;

376: ) IS
377:
378: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
379: BEGIN
380: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing Safety Association Row'); END IF;
381:
382: IF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
383: THEN
384: INSERT_SAFFETY_ASSOCIATION_ROW

Line 382: IF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE

378: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
379: BEGIN
380: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Processing Safety Association Row'); END IF;
381:
382: IF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE
383: THEN
384: INSERT_SAFFETY_ASSOCIATION_ROW
385: ( p_safety_association_rec => p_safety_association_rec
386: , p_association_type => p_association_type

Line 390: ELSIF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE

386: , p_association_type => p_association_type
387: , x_mesg_token_Tbl => x_mesg_token_Tbl
388: , x_return_Status => l_return_status
389: );
390: ELSIF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_UPDATE
391: THEN
392: UPDATE_SAFFETY_ASSOCIATION_ROW
393: ( p_safety_association_rec => p_safety_association_rec
394: , p_association_type => p_association_type

Line 398: ELSIF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE

394: , p_association_type => p_association_type
395: , x_mesg_token_Tbl => x_mesg_token_Tbl
396: , x_return_Status => l_return_status
397: );
398: ELSIF p_safety_association_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_DELETE
399: THEN
400: DELETE_SAFFETY_ASSOCIATION_ROW
401: ( p_safety_association_rec => p_safety_association_rec
402: , p_association_type => p_association_type