DBA Data[Home] [Help]

APPS.EAM_RES_INST_UTILITY_PVT dependencies on EAM_ERROR_MESSAGE_PVT

Line 124: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

120: *********************************************************************/
121:
122: PROCEDURE Insert_Row
123: ( p_eam_res_inst_rec IN EAM_PROCESS_WO_PUB.eam_res_inst_rec_type
124: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
125: , x_return_Status OUT NOCOPY VARCHAR2
126: )
127: IS
128: BEGIN

Line 130: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource Instance rec for ' || p_eam_res_inst_rec.instance_id); END IF;

126: )
127: IS
128: BEGIN
129:
130: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Writing Resource Instance rec for ' || p_eam_res_inst_rec.instance_id); END IF;
131:
132: -- bug no 3444091
133: if p_eam_res_inst_rec.start_date > p_eam_res_inst_rec.completion_date then
134: x_return_status := fnd_api.g_ret_sts_error;

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

169: , FND_GLOBAL.login_id
170: );
171:
172:
173: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug ('Creating new Resource Instances') ; END IF;
174:
175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: EXCEPTION

Line 179: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

175: x_return_status := FND_API.G_RET_STS_SUCCESS;
176:
177: EXCEPTION
178: WHEN OTHERS THEN
179: EAM_ERROR_MESSAGE_PVT.Add_Error_Token
180: ( p_message_name => NULL
181: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
182: , x_mesg_token_Tbl => x_mesg_token_tbl
183: );

Line 200: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

196: *********************************************************************/
197:
198: PROCEDURE Update_Row
199: ( p_eam_res_inst_rec IN EAM_PROCESS_WO_PUB.eam_res_inst_rec_type
200: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
201: , x_return_Status OUT NOCOPY VARCHAR2
202: )
203: IS
204: BEGIN

Line 206: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;

202: )
203: IS
204: BEGIN
205:
206: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Updating Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;
207:
208: -- bug no 3444091
209: if p_eam_res_inst_rec.start_date > p_eam_res_inst_rec.completion_date then
210: x_return_status := fnd_api.g_ret_sts_error;

Line 246: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

242: *********************************************************************/
243:
244: PROCEDURE Delete_Row
245: ( p_eam_res_inst_rec IN EAM_PROCESS_WO_PUB.eam_res_inst_rec_type
246: , x_mesg_token_Tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
247: , x_return_Status OUT NOCOPY VARCHAR2
248: )
249: IS
250: BEGIN

Line 252: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;

248: )
249: IS
250: BEGIN
251:
252: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance: '|| p_eam_res_inst_rec.instance_id); END IF;
253:
254: DELETE FROM WIP_OP_RESOURCE_INSTANCES
255: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id
256: AND organization_id = p_eam_res_inst_rec.organization_id

Line 262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance Usages: '|| p_eam_res_inst_rec.instance_id); END IF;

258: AND resource_seq_num = p_eam_res_inst_rec.resource_seq_num
259: AND instance_id = p_eam_res_inst_rec.instance_id
260: AND (serial_number IS NULL OR (serial_number=p_eam_res_inst_rec.serial_number));
261:
262: IF EAM_PROCESS_WO_PVT.Get_Debug = 'Y' THEN EAM_ERROR_MESSAGE_PVT.Write_Debug('Deleting Resource Instance Usages: '|| p_eam_res_inst_rec.instance_id); END IF;
263:
264: IF p_eam_res_inst_rec.serial_number is NULL THEN
265: DELETE FROM WIP_OPERATION_RESOURCE_USAGE
266: WHERE wip_entity_id = p_eam_res_inst_rec.wip_entity_id

Line 299: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type

295: *********************************************************************/
296:
297: PROCEDURE Perform_Writes
298: ( p_eam_res_inst_rec IN EAM_PROCESS_WO_PUB.eam_res_inst_rec_type
299: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
300: , x_return_status OUT NOCOPY VARCHAR2
301: )
302: IS
303: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

Line 303: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;

299: , x_mesg_token_tbl OUT NOCOPY EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type
300: , x_return_status OUT NOCOPY VARCHAR2
301: )
302: IS
303: l_Mesg_Token_tbl EAM_ERROR_MESSAGE_PVT.Mesg_Token_Tbl_Type;
304: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
305: BEGIN
306:
307: IF p_eam_res_inst_rec.transaction_type = EAM_PROCESS_WO_PVT.G_OPR_CREATE