DBA Data[Home] [Help]

APPS.EAM_SUB_RESOURCE_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 171: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

167: *********************************************************************/
168:
169: PROCEDURE Insert_Row
170: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
171: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
172: , x_return_Status OUT NOCOPY VARCHAR2
173: )
174: IS
175: BEGIN

Line 177: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Sub Resource rec for ' || p_eam_sub_res_rec.resource_seq_num); END IF;

173: )
174: IS
175: BEGIN
176:
177: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Sub Resource rec for ' || p_eam_sub_res_rec.resource_seq_num); END IF;
178:
179: -- bug no 3444091
180: if p_eam_sub_res_rec.start_date > p_eam_sub_res_rec.completion_date then
181: x_return_status := fnd_api.g_ret_sts_error;

Line 284: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Sub Resource') ; END IF;

280: , SYSDATE);
281:
282:
283:
284: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Sub Resource') ; END IF;
285:
286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287:
288: EXCEPTION

Line 290: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

286: x_return_status := FND_API.G_RET_STS_SUCCESS;
287:
288: EXCEPTION
289: WHEN OTHERS THEN
290: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
291: ( p_message_name => NULL
292: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
293: , x_mesg_token_Tbl => x_mesg_token_tbl
294: );

Line 311: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

307: *********************************************************************/
308:
309: PROCEDURE Update_Row
310: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
311: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
312: , x_return_Status OUT NOCOPY VARCHAR2
313: )
314: IS
315: BEGIN

Line 317: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Sub Resource: '|| p_eam_sub_res_rec.resource_seq_num); END IF;

313: )
314: IS
315: BEGIN
316:
317: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Sub Resource: '|| p_eam_sub_res_rec.resource_seq_num); END IF;
318:
319: -- bug no 3444091
320: if p_eam_sub_res_rec.start_date > p_eam_sub_res_rec.completion_date then
321: x_return_status := fnd_api.g_ret_sts_error;

Line 386: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

382: *********************************************************************/
383:
384: PROCEDURE Delete_Row
385: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
386: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
387: , x_return_Status OUT NOCOPY VARCHAR2
388: )
389: IS
390: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 390: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

386: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
387: , x_return_Status OUT NOCOPY VARCHAR2
388: )
389: IS
390: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
391: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
392: BEGIN
393:
394: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Sub Resource Usage') ; END IF;

Line 394: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Sub Resource Usage') ; END IF;

390: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
391: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
392: BEGIN
393:
394: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Sub Resource Usage') ; END IF;
395:
396: EAM_RES_USAGE_UTILITY_PVT.Delete_Usage
397: ( p_wip_entity_id => p_eam_sub_res_rec.wip_entity_id
398: , p_organization_id => p_eam_sub_res_rec.organization_id

Line 405: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Sub resources') ; END IF;

401: , x_mesg_token_Tbl => l_mesg_token_Tbl
402: , x_return_Status => l_return_Status
403: );
404:
405: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Deleting Sub resources') ; END IF;
406:
407: DELETE FROM WIP_SUB_OPERATION_RESOURCES
408: WHERE wip_entity_id = p_eam_sub_res_rec.wip_entity_id
409: AND organization_id = p_eam_sub_res_rec.organization_id

Line 432: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

428: *********************************************************************/
429:
430: PROCEDURE Perform_Writes
431: ( p_eam_sub_res_rec IN EAM_PROCESS_WO_PUB.eam_sub_res_rec_type
432: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
433: , x_return_status OUT NOCOPY VARCHAR2
434: )
435: IS
436: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 436: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

432: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
433: , x_return_status OUT NOCOPY VARCHAR2
434: )
435: IS
436: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
437: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
438: BEGIN
439:
440: IF p_eam_sub_res_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE