APPS.EAM_SUB_RESOURCE_UTILITY_PVT dependencies on FND_API

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

45: , x_Return_status OUT NOCOPY VARCHAR2
46: )
47: IS
48: l_eam_sub_res_rec EAM_PROCESS_WO_PUB.eam_sub_res_rec_type;
49: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
50: l_dummy VARCHAR2(10);
51: BEGIN
52:
53: SELECT

Line 154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

150: x_return_status := EAM_PROCESS_WO_PVT.G_RECORD_NOT_FOUND;
151: x_eam_sub_res_rec := l_eam_sub_res_rec;
152:
153: WHEN OTHERS THEN
154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
155: x_eam_sub_res_rec := l_eam_sub_res_rec;
156:
157: END Query_Row;
158:

Line 181: x_return_status := fnd_api.g_ret_sts_error;

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;
182: fnd_message.set_name('EAM','EAM_WO_SUBR_DT_ERR');
183: return;
184: end if;
185:

Line 286: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
289: WHEN OTHERS THEN
290: EAM_ERROR_MESSAGE_PVT.Add_Error_Token

Line 296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

292: , p_message_text => G_PKG_NAME ||' :Inserting Record ' || SQLERRM
293: , x_mesg_token_Tbl => x_mesg_token_tbl
294: );
295:
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297:
298: END Insert_Row;
299:
300: /********************************************************************

Line 321: x_return_status := fnd_api.g_ret_sts_error;

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;
322: fnd_message.set_name('EAM','EAM_WO_SUBR_DT_ERR');
323: return;
324: end if;
325:

Line 371: x_return_status := FND_API.G_RET_STS_SUCCESS;

367: AND organization_id = p_eam_sub_res_rec.organization_id
368: AND operation_seq_num = p_eam_sub_res_rec.operation_seq_num
369: AND resource_seq_num = p_eam_sub_res_rec.resource_seq_num;
370:
371: x_return_status := FND_API.G_RET_STS_SUCCESS;
372:
373: END Update_Row;
374:
375: /********************************************************************

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

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;
395:

Line 415: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

411: AND resource_seq_num = p_eam_sub_res_rec.resource_seq_num;
412:
413: x_return_status := l_return_status;
414: x_mesg_token_tbl := l_mesg_token_tbl;
415: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: END Delete_Row;
418:
419:

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

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