DBA Data[Home] [Help]

APPS.EAM_SAFETY_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 140: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

136:
137: PROCEDURE INSERT_SAFFETY_ASSOCIATION_ROW
138: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
139: , p_association_type IN NUMBER
140: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
141: , x_return_Status OUT NOCOPY VARCHAR2
142: )IS
143:
144: -- l_organization_id NUMBER;

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 261: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

257:
258: PROCEDURE UPDATE_SAFFETY_ASSOCIATION_ROW
259: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
260: , p_association_type IN NUMBER
261: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
262: , x_return_Status OUT NOCOPY VARCHAR2
263: )IS
264:
265:

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 333: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

329:
330: PROCEDURE DELETE_SAFFETY_ASSOCIATION_ROW
331: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
332: , p_association_type IN NUMBER
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;

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 374: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

370:
371: PROCEDURE WRITE_SAFFETY_ASSOCIATION_ROW
372: ( p_safety_association_rec IN EAM_PROCESS_SAFETY_PUB.eam_safety_assoc_rec_type
373: , p_association_type IN NUMBER
374: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
375: , x_return_Status OUT NOCOPY VARCHAR2
376: ) IS
377:
378: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

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