APPS.EAM_RES_INST_UTILITY_PVT dependencies on FND_API

Line 51: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

47: , x_Return_status OUT NOCOPY VARCHAR2
48: )
49: IS
50: l_eam_res_inst_rec EAM_PROCESS_WO_PUB.eam_res_inst_rec_type;
51: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
52: l_dummy varchar2(10);
53: BEGIN
54:
55: IF p_serial_number is null THEN

Line 107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

103: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
104: x_eam_res_inst_rec := l_eam_res_inst_rec;
105:
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: x_eam_res_inst_rec := l_eam_res_inst_rec;
109:
110: END Query_Row;
111:

Line 134: x_return_status := fnd_api.g_ret_sts_error;

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;
135: fnd_message.set_name('EAM','EAM_WO_RS_IN_DT_ERR');
136: return;
137: end if;
138:

Line 175: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
178: WHEN OTHERS THEN
179: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

181: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
182: , x_mesg_token_Tbl => x_mesg_token_tbl
183: );
184:
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186:
187: END Insert_Row;
188:
189: /********************************************************************

Line 210: x_return_status := fnd_api.g_ret_sts_error;

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;
211: fnd_message.set_name('EAM','EAM_WO_RS_IN_DT_ERR');
212: return;
213: end if;
214:

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: AND instance_id = p_eam_res_inst_rec.instance_id
228: AND (serial_number IS NULL OR (serial_number = p_eam_res_inst_rec.serial_number));
229:
230:
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232:
233: END Update_Row;
234:
235: /********************************************************************

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: AND serial_number = p_eam_res_inst_rec.serial_number;
279: END IF;
280:
281:
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283:
284: END Delete_Row;
285:
286:

Line 304: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

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
308: THEN