DBA Data[Home] [Help]

APPS.MSC_ATP_BPEL dependencies on MSC_SCH_WB

Line 15: msc_sch_wb.atp_debug('Begin Procedure ATP_Rec_convert_tab');

11: x_return_status varchar2(10);
12:
13: begin
14:
15: msc_sch_wb.atp_debug('Begin Procedure ATP_Rec_convert_tab');
16:
17: for i in 1..p_atp_tab.COUNT loop
18:
19: msc_sch_wb.atp_debug('Before extend');

Line 19: msc_sch_wb.atp_debug('Before extend');

15: msc_sch_wb.atp_debug('Begin Procedure ATP_Rec_convert_tab');
16:
17: for i in 1..p_atp_tab.COUNT loop
18:
19: msc_sch_wb.atp_debug('Before extend');
20:
21: MSC_SATP_FUNC.Extend_Atp(x_atp_rec, x_return_status, 1);
22:
23: msc_sch_wb.atp_debug('After extend');

Line 23: msc_sch_wb.atp_debug('After extend');

19: msc_sch_wb.atp_debug('Before extend');
20:
21: MSC_SATP_FUNC.Extend_Atp(x_atp_rec, x_return_status, 1);
22:
23: msc_sch_wb.atp_debug('After extend');
24: msc_sch_wb.atp_debug('x_atp_rec.Row_Id.count: '||x_atp_rec.Row_Id.COUNT);
25:
26: --assignments
27: x_atp_rec.Row_Id(i) := p_atp_tab(i).Row_Id;

Line 24: msc_sch_wb.atp_debug('x_atp_rec.Row_Id.count: '||x_atp_rec.Row_Id.COUNT);

20:
21: MSC_SATP_FUNC.Extend_Atp(x_atp_rec, x_return_status, 1);
22:
23: msc_sch_wb.atp_debug('After extend');
24: msc_sch_wb.atp_debug('x_atp_rec.Row_Id.count: '||x_atp_rec.Row_Id.COUNT);
25:
26: --assignments
27: x_atp_rec.Row_Id(i) := p_atp_tab(i).Row_Id;
28: x_atp_rec.Instance_Id(i) := p_atp_tab(i).Instance_Id ;

Line 183: msc_sch_wb.atp_debug('Inside exception of ATP_Rec_convert_tab '||sqlerrm);

179: */
180: end loop;
181:
182: exception when others then
183: msc_sch_wb.atp_debug('Inside exception of ATP_Rec_convert_tab '||sqlerrm);
184:
185: END ATP_Rec_convert_tab ;
186:
187: PROCEDURE ATP_Rec_convert_rec(

Line 194: msc_sch_wb.atp_debug('Begin Procedure ATP_Rec_convert_rec');

190: IS
191:
192: begin
193:
194: msc_sch_wb.atp_debug('Begin Procedure ATP_Rec_convert_rec');
195:
196: FOR i in 1..p_atp_rec.action.COUNT LOOP
197:
198: msc_sch_wb.atp_debug('i: '||i);

Line 198: msc_sch_wb.atp_debug('i: '||i);

194: msc_sch_wb.atp_debug('Begin Procedure ATP_Rec_convert_rec');
195:
196: FOR i in 1..p_atp_rec.action.COUNT LOOP
197:
198: msc_sch_wb.atp_debug('i: '||i);
199:
200: -- assignments
201:
202: p_atp_tab(i).Row_Id := p_atp_rec.Row_Id(i);

Line 358: msc_sch_wb.atp_debug('Inside exception of ATP_Rec_convert_rec '||sqlerrm);

354: */
355: END LOOP;
356:
357: exception when others then
358: msc_sch_wb.atp_debug('Inside exception of ATP_Rec_convert_rec '||sqlerrm);
359:
360: END ATP_Rec_convert_rec ;
361:
362: PROCEDURE Call_ATP_BPEL(

Line 378: msc_sch_wb.atp_debug('Inside begin of PROCEDURE Call_ATP_BPEL');

374: x_atp_period MRP_ATP_PUB.ATP_Period_Typ;
375: x_atp_details MRP_ATP_PUB.ATP_Details_Typ;
376:
377: BEGIN
378: msc_sch_wb.atp_debug('Inside begin of PROCEDURE Call_ATP_BPEL');
379:
380: msc_sch_wb.atp_debug('Before call ATP_Rec_convert_tab');
381:
382: /* Call Procedure ATP_Rec_convert_tab to convert input table of records

Line 380: msc_sch_wb.atp_debug('Before call ATP_Rec_convert_tab');

376:
377: BEGIN
378: msc_sch_wb.atp_debug('Inside begin of PROCEDURE Call_ATP_BPEL');
379:
380: msc_sch_wb.atp_debug('Before call ATP_Rec_convert_tab');
381:
382: /* Call Procedure ATP_Rec_convert_tab to convert input table of records
383: to record of tables. */
384:

Line 387: msc_sch_wb.atp_debug('After call ATP_Rec_convert_tab');

383: to record of tables. */
384:
385: ATP_Rec_convert_tab( p_atp_tab, p_atp_rec );
386:
387: msc_sch_wb.atp_debug('After call ATP_Rec_convert_tab');
388:
389: MRP_ATP_PUB.Call_ATP(
390: p_session_id ,
391: p_atp_rec ,

Line 400: msc_sch_wb.atp_debug('After call Call_ATP');

396: x_return_status ,
397: x_msg_data ,
398: x_msg_count );
399:
400: msc_sch_wb.atp_debug('After call Call_ATP');
401: msc_sch_wb.atp_debug('x_atp_rec.Inventory_Item_Id.COUNT: '||x_atp_rec.Inventory_Item_Id.COUNT);
402: msc_sch_wb.atp_debug('x_atp_supply_demand.Inventory_Item_Id.COUNT: '||x_atp_supply_demand.Inventory_Item_Id.COUNT);
403: msc_sch_wb.atp_debug('x_atp_period.Inventory_Item_Id.COUNT: '||x_atp_period.Inventory_Item_Id.COUNT);
404: msc_sch_wb.atp_debug('x_atp_details.Inventory_Item_Id.COUNT: '||x_atp_details.Inventory_Item_Id.COUNT);

Line 401: msc_sch_wb.atp_debug('x_atp_rec.Inventory_Item_Id.COUNT: '||x_atp_rec.Inventory_Item_Id.COUNT);

397: x_msg_data ,
398: x_msg_count );
399:
400: msc_sch_wb.atp_debug('After call Call_ATP');
401: msc_sch_wb.atp_debug('x_atp_rec.Inventory_Item_Id.COUNT: '||x_atp_rec.Inventory_Item_Id.COUNT);
402: msc_sch_wb.atp_debug('x_atp_supply_demand.Inventory_Item_Id.COUNT: '||x_atp_supply_demand.Inventory_Item_Id.COUNT);
403: msc_sch_wb.atp_debug('x_atp_period.Inventory_Item_Id.COUNT: '||x_atp_period.Inventory_Item_Id.COUNT);
404: msc_sch_wb.atp_debug('x_atp_details.Inventory_Item_Id.COUNT: '||x_atp_details.Inventory_Item_Id.COUNT);
405:

Line 402: msc_sch_wb.atp_debug('x_atp_supply_demand.Inventory_Item_Id.COUNT: '||x_atp_supply_demand.Inventory_Item_Id.COUNT);

398: x_msg_count );
399:
400: msc_sch_wb.atp_debug('After call Call_ATP');
401: msc_sch_wb.atp_debug('x_atp_rec.Inventory_Item_Id.COUNT: '||x_atp_rec.Inventory_Item_Id.COUNT);
402: msc_sch_wb.atp_debug('x_atp_supply_demand.Inventory_Item_Id.COUNT: '||x_atp_supply_demand.Inventory_Item_Id.COUNT);
403: msc_sch_wb.atp_debug('x_atp_period.Inventory_Item_Id.COUNT: '||x_atp_period.Inventory_Item_Id.COUNT);
404: msc_sch_wb.atp_debug('x_atp_details.Inventory_Item_Id.COUNT: '||x_atp_details.Inventory_Item_Id.COUNT);
405:
406: /* Call Procedure ATP_Rec_convert_rec to convert record of tables to

Line 403: msc_sch_wb.atp_debug('x_atp_period.Inventory_Item_Id.COUNT: '||x_atp_period.Inventory_Item_Id.COUNT);

399:
400: msc_sch_wb.atp_debug('After call Call_ATP');
401: msc_sch_wb.atp_debug('x_atp_rec.Inventory_Item_Id.COUNT: '||x_atp_rec.Inventory_Item_Id.COUNT);
402: msc_sch_wb.atp_debug('x_atp_supply_demand.Inventory_Item_Id.COUNT: '||x_atp_supply_demand.Inventory_Item_Id.COUNT);
403: msc_sch_wb.atp_debug('x_atp_period.Inventory_Item_Id.COUNT: '||x_atp_period.Inventory_Item_Id.COUNT);
404: msc_sch_wb.atp_debug('x_atp_details.Inventory_Item_Id.COUNT: '||x_atp_details.Inventory_Item_Id.COUNT);
405:
406: /* Call Procedure ATP_Rec_convert_rec to convert record of tables to
407: table of records. */

Line 404: msc_sch_wb.atp_debug('x_atp_details.Inventory_Item_Id.COUNT: '||x_atp_details.Inventory_Item_Id.COUNT);

400: msc_sch_wb.atp_debug('After call Call_ATP');
401: msc_sch_wb.atp_debug('x_atp_rec.Inventory_Item_Id.COUNT: '||x_atp_rec.Inventory_Item_Id.COUNT);
402: msc_sch_wb.atp_debug('x_atp_supply_demand.Inventory_Item_Id.COUNT: '||x_atp_supply_demand.Inventory_Item_Id.COUNT);
403: msc_sch_wb.atp_debug('x_atp_period.Inventory_Item_Id.COUNT: '||x_atp_period.Inventory_Item_Id.COUNT);
404: msc_sch_wb.atp_debug('x_atp_details.Inventory_Item_Id.COUNT: '||x_atp_details.Inventory_Item_Id.COUNT);
405:
406: /* Call Procedure ATP_Rec_convert_rec to convert record of tables to
407: table of records. */
408:

Line 411: msc_sch_wb.atp_debug('After call ATP_Rec_convert_rec');

407: table of records. */
408:
409: ATP_Rec_convert_rec( x_atp_rec, x_atp_tab);
410:
411: msc_sch_wb.atp_debug('After call ATP_Rec_convert_rec');
412: msc_sch_wb.atp_debug('End of wrapper file Call_ATP_BPEL .');
413: msc_sch_wb.atp_debug('********************************');
414:
415: EXCEPTION when others then

Line 412: msc_sch_wb.atp_debug('End of wrapper file Call_ATP_BPEL .');

408:
409: ATP_Rec_convert_rec( x_atp_rec, x_atp_tab);
410:
411: msc_sch_wb.atp_debug('After call ATP_Rec_convert_rec');
412: msc_sch_wb.atp_debug('End of wrapper file Call_ATP_BPEL .');
413: msc_sch_wb.atp_debug('********************************');
414:
415: EXCEPTION when others then
416: msc_sch_wb.atp_debug('Inside exception in Call_ATP_BPEL '||sqlerrm);

Line 413: msc_sch_wb.atp_debug('********************************');

409: ATP_Rec_convert_rec( x_atp_rec, x_atp_tab);
410:
411: msc_sch_wb.atp_debug('After call ATP_Rec_convert_rec');
412: msc_sch_wb.atp_debug('End of wrapper file Call_ATP_BPEL .');
413: msc_sch_wb.atp_debug('********************************');
414:
415: EXCEPTION when others then
416: msc_sch_wb.atp_debug('Inside exception in Call_ATP_BPEL '||sqlerrm);
417:

Line 416: msc_sch_wb.atp_debug('Inside exception in Call_ATP_BPEL '||sqlerrm);

412: msc_sch_wb.atp_debug('End of wrapper file Call_ATP_BPEL .');
413: msc_sch_wb.atp_debug('********************************');
414:
415: EXCEPTION when others then
416: msc_sch_wb.atp_debug('Inside exception in Call_ATP_BPEL '||sqlerrm);
417:
418: END Call_ATP_BPEL;
419:
420: