DBA Data[Home] [Help]

APPS.EAM_RES_USAGE_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 37: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

33: *********************************************************************/
34:
35: PROCEDURE Add_Usage
36: ( p_eam_res_usage_rec IN EAM_PROCESS_WO_PUB.eam_res_usage_rec_type
37: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
38: , x_return_Status OUT NOCOPY VARCHAR2
39: )
40: IS
41: BEGIN

Line 43: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource Usage for ' || p_eam_res_usage_rec.resource_seq_num); END IF;

39: )
40: IS
41: BEGIN
42:
43: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource Usage for ' || p_eam_res_usage_rec.resource_seq_num); END IF;
44:
45: -- bug no 3444091
46: if p_eam_res_usage_rec.start_date > p_eam_res_usage_rec.completion_date then
47: x_return_status := fnd_api.g_ret_sts_error;

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

89: , p_eam_res_usage_rec.program_id
90: , SYSDATE);
91:
92:
93: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Resource Usage') ; END IF;
94:
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: EXCEPTION

Line 99: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

95: x_return_status := FND_API.G_RET_STS_SUCCESS;
96:
97: EXCEPTION
98: WHEN OTHERS THEN
99: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
100: ( p_message_name => NULL
101: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
102: , x_mesg_token_Tbl => x_mesg_token_tbl
103: );

Line 123: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

119: ( p_wip_entity_id IN NUMBER
120: , p_organization_id IN NUMBER
121: , p_operation_seq_num IN NUMBER
122: , p_resource_seq_num IN NUMBER
123: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
124: , x_return_Status OUT NOCOPY VARCHAR2
125: )
126: IS
127: BEGIN

Line 129: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Usage: '|| p_resource_seq_num); END IF;

125: )
126: IS
127: BEGIN
128:
129: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Usage: '|| p_resource_seq_num); END IF;
130:
131: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
132: WHERE wip_entity_id = p_wip_entity_id
133: AND organization_id = p_organization_id

Line 164: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;

160: FOR I IN 1..l_eam_res_usage_tbl.COUNT LOOP
161:
162: l_eam_res_usage_rec := l_eam_res_usage_tbl(I);
163:
164: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Return status validation passed') ; END IF ;
165:
166: IF ( l_eam_res_usage_rec.wip_entity_id = p_wip_entity_id and
167: l_eam_res_usage_rec.organization_id = p_organization_id and
168: l_eam_res_usage_rec.operation_seq_num = p_operation_seq_num and