APPS.MSC_ATP_CTO dependencies on FND_API

Line 57: msc_sch_wb.atp_debug('*** G_RET_STS_SUCCESS := ' || FND_API.G_RET_STS_SUCCESS);

53: MSC_ATP_CTO.Match_CTO_Lines(p_session_id, p_dblink, p_instance_id, l_return_status);
54:
55: IF PG_DEBUG in ('Y', 'C') THEN
56: msc_sch_wb.atp_debug('***** l_return_status := ' || l_return_status);
57: msc_sch_wb.atp_debug('*** G_RET_STS_SUCCESS := ' || FND_API.G_RET_STS_SUCCESS);
58: END IF;
59: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
60: IF PG_DEBUG in ('Y', 'C') THEN
61: msc_sch_wb.atp_debug('***** Error Occured While Matching *****');

Line 59: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

55: IF PG_DEBUG in ('Y', 'C') THEN
56: msc_sch_wb.atp_debug('***** l_return_status := ' || l_return_status);
57: msc_sch_wb.atp_debug('*** G_RET_STS_SUCCESS := ' || FND_API.G_RET_STS_SUCCESS);
58: END IF;
59: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
60: IF PG_DEBUG in ('Y', 'C') THEN
61: msc_sch_wb.atp_debug('***** Error Occured While Matching *****');
62: END IF;
63: l_error_code := MSC_ATP_PVT.ERROR_WHILE_MATCHING;

Line 65: RAISE FND_API.G_EXC_ERROR ;

61: msc_sch_wb.atp_debug('***** Error Occured While Matching *****');
62: END IF;
63: l_error_code := MSC_ATP_PVT.ERROR_WHILE_MATCHING;
64: p_atp_rec.error_code(1) := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
65: RAISE FND_API.G_EXC_ERROR ;
66:
67: END IF;
68:
69: IF PG_DEBUG in ('Y', 'C') THEN

Line 144: x_return_status := FND_API.G_RET_STS_ERROR;

140: msc_sch_wb.atp_debug('***** Errror Occured in Check_Lines_For_CTO_ATP');
141: msc_sch_wb.atp_debug('Sql Error := ' || SQLERRM);
142: END IF;
143: p_atp_rec.error_code(1) := MSC_ATP_PVT.ATP_PROCESSING_ERROR;
144: x_return_status := FND_API.G_RET_STS_ERROR;
145:
146: END Check_Lines_For_CTO_ATP;
147:
148: Procedure Match_CTO_Lines(P_session_id IN Number,

Line 254: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

250: msc_sch_wb.atp_debug(' l_return_status := ' || l_return_status);
251: END IF;
252:
253:
254: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
255: IF PG_DEBUG in ('Y', 'C') THEN
256: msc_sch_wb.atp_debug(' Unhandeled ecpetion occured in call to CTO API');
257: msc_sch_wb.atp_debug('Error := ' || sqlerrm);
258: END IF;

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: IF PG_DEBUG in ('Y', 'C') THEN
256: msc_sch_wb.atp_debug(' Unhandeled ecpetion occured in call to CTO API');
257: msc_sch_wb.atp_debug('Error := ' || sqlerrm);
258: END IF;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: RAISE FND_API.G_EXC_ERROR ;
261:
262: END IF;
263:

Line 260: RAISE FND_API.G_EXC_ERROR ;

256: msc_sch_wb.atp_debug(' Unhandeled ecpetion occured in call to CTO API');
257: msc_sch_wb.atp_debug('Error := ' || sqlerrm);
258: END IF;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: RAISE FND_API.G_EXC_ERROR ;
261:
262: END IF;
263:
264: EXCEPTION

Line 270: x_return_status := FND_API.G_RET_STS_ERROR;

266: IF PG_DEBUG in ('Y', 'C') THEN
267: msc_sch_wb.atp_debug(' Unhandeled ecpetion occured in call to CTO API');
268: msc_sch_wb.atp_debug('Error := ' || sqlerrm);
269: END IF;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: RAISE FND_API.G_EXC_ERROR ;
272: ---match fail
273: END;
274:

Line 271: RAISE FND_API.G_EXC_ERROR ;

267: msc_sch_wb.atp_debug(' Unhandeled ecpetion occured in call to CTO API');
268: msc_sch_wb.atp_debug('Error := ' || sqlerrm);
269: END IF;
270: x_return_status := FND_API.G_RET_STS_ERROR;
271: RAISE FND_API.G_EXC_ERROR ;
272: ---match fail
273: END;
274:
275: -- update mrp_atp_schedule_temp with match info Praent_ato_lin_id information

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: END IF; --IF l_cto_lines_for_match.inventory_item_id.count > 0 TH
322: EXCEPTION
323: WHEN OTHERS THEN
324: msc_sch_wb.atp_debug('Error Occured := ' || SQLERRM);
325: x_return_status := FND_API.G_RET_STS_ERROR;
326:
327: END Match_CTO_Lines;
328:
329: Procedure Process_CTO_Sources(p_dblink IN varchar2,