APPS.MSC_ATP_PUB dependencies on MSC_OE_DATA_TEMP

Line 492: msc_oe_data_temp_in_use EXCEPTION;

488: l_instance_id number; --5195929 for db link
489: l_return_status VARCHAR2(60); --5195929 for db link
490:
491: --bug 9651251
492: msc_oe_data_temp_in_use EXCEPTION;
493: PRAGMA EXCEPTION_INIT(msc_oe_data_temp_in_use, -14450);
494:
495: BEGIN
496: --bug3609185 initialize API returm status to success

Line 493: PRAGMA EXCEPTION_INIT(msc_oe_data_temp_in_use, -14450);

489: l_return_status VARCHAR2(60); --5195929 for db link
490:
491: --bug 9651251
492: msc_oe_data_temp_in_use EXCEPTION;
493: PRAGMA EXCEPTION_INIT(msc_oe_data_temp_in_use, -14450);
494:
495: BEGIN
496: --bug3609185 initialize API returm status to success
497: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 581: --Bug 9651251, put this in a PLSQL block and catch msc_oe_data_temp_in_use exception.

577: l_atp_rec := p_atp_rec;
578:
579: -- Start 4279623
580: IF nvl(l_atp_rec.calling_module(1), -1) not in (724,-1) THEN
581: --Bug 9651251, put this in a PLSQL block and catch msc_oe_data_temp_in_use exception.
582: BEGIN
583: FORALL i in 1..l_atp_rec.action.COUNT
584: insert into msc_oe_data_temp
585: (

Line 584: insert into msc_oe_data_temp

580: IF nvl(l_atp_rec.calling_module(1), -1) not in (724,-1) THEN
581: --Bug 9651251, put this in a PLSQL block and catch msc_oe_data_temp_in_use exception.
582: BEGIN
583: FORALL i in 1..l_atp_rec.action.COUNT
584: insert into msc_oe_data_temp
585: (
586: seq_id,
587: order_line_id,
588: oe_flag,

Line 594: msc.msc_oe_data_temp_s.NEXTVAL,

590: session_id
591: )
592: values
593: (
594: msc.msc_oe_data_temp_s.NEXTVAL,
595: l_atp_rec.identifier(i),
596: decode(l_atp_rec.oe_flag(i),'Y',(Select decode(MSC_ATP_PVT.G_INV_CTP, 5, l_atp_rec.OE_FLAG(i),
597: decode( prha.interface_source_code, 'MRP', 'Y', 'MSC', 'Y','CTO', 'Y', 'CTO-LOWER LEVEL', 'Y', 'N')) --4889943
598: from po_requisition_headers_all prha

Line 610: msc_sch_wb.atp_debug('Call_ATP: Inserted data into msc_oe_data_temp');

606: p_session_id
607: );
608:
609: IF PG_DEBUG in ('Y', 'C') THEN
610: msc_sch_wb.atp_debug('Call_ATP: Inserted data into msc_oe_data_temp');
611: msc_sch_wb.atp_debug('Records selected in mrp_oe_data_temp : ' || SQL%ROWCOUNT);
612: END IF;
613:
614: select oe_flag,internal_org_id,seq_id

Line 619: from msc_oe_data_temp

615: bulk collect into
616: l_atp_rec.oe_flag,
617: l_atp_rec.internal_org_id,
618: l_atp_rec.attribute_11
619: from msc_oe_data_temp
620: where session_id = p_session_id
621: order by seq_id;
622:
623: IF PG_DEBUG in ('Y', 'C') THEN

Line 633: WHEN msc_oe_data_temp_in_use THEN --Bug 9651251

629: msc_sch_wb.atp_debug('call_atp: Internal Org.Id : ' || l_atp_rec.internal_org_id(l));
630: END LOOP;
631: END IF;
632: EXCEPTION
633: WHEN msc_oe_data_temp_in_use THEN --Bug 9651251
634: msc_sch_wb.atp_debug('Call_ATP: In msc_oe_data_temp_in_use excp.');
635: FOR i in 1..l_atp_rec.action.COUNT LOOP
636: l_atp_rec.oe_flag(i) := NULL;
637: l_atp_rec.internal_org_id(i) := NULL;

Line 634: msc_sch_wb.atp_debug('Call_ATP: In msc_oe_data_temp_in_use excp.');

630: END LOOP;
631: END IF;
632: EXCEPTION
633: WHEN msc_oe_data_temp_in_use THEN --Bug 9651251
634: msc_sch_wb.atp_debug('Call_ATP: In msc_oe_data_temp_in_use excp.');
635: FOR i in 1..l_atp_rec.action.COUNT LOOP
636: l_atp_rec.oe_flag(i) := NULL;
637: l_atp_rec.internal_org_id(i) := NULL;
638: l_atp_rec.attribute_11(i) := i;