eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_ATP_UTILS dependencies on MSC_SCH_WB

Line 40: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'session_id : '||x_session_id);

36: l_dynstring := '@'||x_dblink;
37: END IF;
38:
39: IF PG_DEBUG in ('Y', 'C') THEN
40: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'session_id : '||x_session_id);
41: msc_sch_wb.atp_debug('enter put_into_temp_table');
42: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'l_dynstring = '||l_dynstring);
43: -- bug 2974324. Repeated statements removed from here.
44: END IF;

Line 41: msc_sch_wb.atp_debug('enter put_into_temp_table');

37: END IF;
38:
39: IF PG_DEBUG in ('Y', 'C') THEN
40: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'session_id : '||x_session_id);
41: msc_sch_wb.atp_debug('enter put_into_temp_table');
42: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'l_dynstring = '||l_dynstring);
43: -- bug 2974324. Repeated statements removed from here.
44: END IF;
45:

Line 42: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'l_dynstring = '||l_dynstring);

38:
39: IF PG_DEBUG in ('Y', 'C') THEN
40: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'session_id : '||x_session_id);
41: msc_sch_wb.atp_debug('enter put_into_temp_table');
42: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'l_dynstring = '||l_dynstring);
43: -- bug 2974324. Repeated statements removed from here.
44: END IF;
45:
46: /* -- bug3378648:we dont need this sql as this should be done locally

Line 64: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'delete details temp rows := '|| SQL%ROWCOUNT);

60:
61: EXECUTE IMMEDIATE sql_stmt USING x_session_id, x_session_id;
62:
63: IF PG_DEBUG in ('Y', 'C') THEN
64: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'delete details temp rows := '|| SQL%ROWCOUNT);
65: END IF;
66: END IF;
67: /* -- bug3378648:we dont need this sql as this should be done locally
68:

Line 74: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted supply demand records ');

70:
71: /*
72: MSC_ATP_UTILS.PUT_SD_DATA(x_atp_supply_demand, x_dblink, x_session_id);
73: IF PG_DEBUG in ('Y', 'C') THEN
74: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted supply demand records ');
75: END IF;
76:
77: -- MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, x_dblink, x_session_id);
78: -- dsting call it with null because we'll transfer it later

Line 81: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' dsting expect 0 period recs: ' || x_atp_period.level.count);

77: -- MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, x_dblink, x_session_id);
78: -- dsting call it with null because we'll transfer it later
79: -- I'm not really expecting anything here
80: IF PG_DEBUG in ('Y', 'C') THEN
81: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' dsting expect 0 period recs: ' || x_atp_period.level.count);
82: END IF;
83: MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, NULL, x_session_id);
84:
85: IF PG_DEBUG in ('Y', 'C') THEN

Line 86: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted period records ');

82: END IF;
83: MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, NULL, x_session_id);
84:
85: IF PG_DEBUG in ('Y', 'C') THEN
86: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted period records ');
87: msc_sch_wb.atp_debug('enter put_into_temp_table :30');
88: END IF;
89:
90: -- dsting transfer it later

Line 87: msc_sch_wb.atp_debug('enter put_into_temp_table :30');

83: MSC_ATP_UTILS.PUT_PERIOD_DATA(x_atp_period, NULL, x_session_id);
84:
85: IF PG_DEBUG in ('Y', 'C') THEN
86: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted period records ');
87: msc_sch_wb.atp_debug('enter put_into_temp_table :30');
88: END IF;
89:
90: -- dsting transfer it later
91: -- MSC_ATP_UTILS.PUT_Pegging_Data(x_session_id, x_dblink);

Line 94: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'Inserted Pegging Records');

90: -- dsting transfer it later
91: -- MSC_ATP_UTILS.PUT_Pegging_Data(x_session_id, x_dblink);
92:
93: IF PG_DEBUG in ('Y', 'C') THEN
94: msc_sch_wb.atp_debug('put_into_temp_table: ' || 'Inserted Pegging Records');
95: END IF;
96: */
97:
98: MSC_ATP_UTILS.Put_Scheduling_data(x_atp_rec, x_mode, x_dblink, x_session_id);

Line 101: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted main records ');

97:
98: MSC_ATP_UTILS.Put_Scheduling_data(x_atp_rec, x_mode, x_dblink, x_session_id);
99:
100: IF PG_DEBUG in ('Y', 'C') THEN
101: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Inserted main records ');
102: END IF;
103:
104: --commit; -- autonomous transaction
105:

Line 114: msc_sch_wb.atp_debug('ATP Invalid Objects Found in put_Into_temp_table ');

110:
111: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
112: -- bug 2974324. Redundant cursor statements removed from here.
113: IF PG_DEBUG in ('Y', 'C') THEN
114: msc_sch_wb.atp_debug('ATP Invalid Objects Found in put_Into_temp_table ');
115: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Error in MSCUATPB.pls '||substr(sqlerrm,1,100));
116: END IF;
117: x_msg_data := substr(sqlerrm,1,100);
118: x_return_status := FND_API.G_RET_STS_ERROR;

Line 115: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Error in MSCUATPB.pls '||substr(sqlerrm,1,100));

111: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
112: -- bug 2974324. Redundant cursor statements removed from here.
113: IF PG_DEBUG in ('Y', 'C') THEN
114: msc_sch_wb.atp_debug('ATP Invalid Objects Found in put_Into_temp_table ');
115: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Error in MSCUATPB.pls '||substr(sqlerrm,1,100));
116: END IF;
117: x_msg_data := substr(sqlerrm,1,100);
118: x_return_status := FND_API.G_RET_STS_ERROR;
119: -- IF l_dynstring is null THEN

Line 127: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Error in MSCUATPB.pls '||substr(sqlerrm,1,100));

123:
124: WHEN OTHERS THEN
125: -- bug 2974324. Redundant cursor statements removed from here.
126: IF PG_DEBUG in ('Y', 'C') THEN
127: msc_sch_wb.atp_debug('put_into_temp_table: ' || ' Error in MSCUATPB.pls '||substr(sqlerrm,1,100));
128: END IF;
129: x_msg_data := substr(sqlerrm,1,100);
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131:

Line 170: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Entering get from temp table');

166: l_mso_lead_time_factor number;
167: BEGIN
168:
169: IF PG_DEBUG in ('Y', 'C') THEN
170: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Entering get from temp table');
171: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'p_details_falg := ' || p_details_flag);
172: END IF;
173: -- initialize API returm status to success
174: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 171: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'p_details_falg := ' || p_details_flag);

167: BEGIN
168:
169: IF PG_DEBUG in ('Y', 'C') THEN
170: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Entering get from temp table');
171: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'p_details_falg := ' || p_details_flag);
172: END IF;
173: -- initialize API returm status to success
174: x_return_status := FND_API.G_RET_STS_SUCCESS;
175:

Line 201: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, l_dynstring = '||l_dynstring);

197: END IF;
198: ---e_cto_rearch
199:
200: IF PG_DEBUG in ('Y', 'C') THEN
201: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, l_dynstring = '||l_dynstring);
202: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_session_id = '||x_session_id);
203: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_mode = ' || x_mode);
204: END IF;
205:

Line 202: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_session_id = '||x_session_id);

198: ---e_cto_rearch
199:
200: IF PG_DEBUG in ('Y', 'C') THEN
201: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, l_dynstring = '||l_dynstring);
202: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_session_id = '||x_session_id);
203: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_mode = ' || x_mode);
204: END IF;
205:
206: -- cchen: rewrite this sql_stmt. based on the mode we either have status 1

Line 203: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_mode = ' || x_mode);

199:
200: IF PG_DEBUG in ('Y', 'C') THEN
201: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, l_dynstring = '||l_dynstring);
202: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_session_id = '||x_session_id);
203: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, x_mode = ' || x_mode);
204: END IF;
205:
206: -- cchen: rewrite this sql_stmt. based on the mode we either have status 1
207: -- or 2 in the where clause

Line 225: msc_sch_wb.atp_debug('l_status_flag := ' || l_status_flag);

221: l_status_flag := 99;
222: END IF;
223:
224: IF PG_DEBUG in ('Y', 'C') THEN
225: msc_sch_wb.atp_debug('l_status_flag := ' || l_status_flag);
226: END IF;
227:
228: SELECT
229: ACTION

Line 557: msc_sch_wb.atp_debug('Records Retrieved := ' || x_atp_rec.inventory_item_id.count );

553: NVL(ATO_Model_Line_Id, ORDER_LINE_ID))
554: ORDER BY sequence_number;
555:
556: IF PG_DEBUG in ('Y', 'C') THEN
557: msc_sch_wb.atp_debug('Records Retrieved := ' || x_atp_rec.inventory_item_id.count );
558: END IF;
559:
560: --bug3520746 Begin Changes
561: --bug3610706 added the condition for de-centrlized env.

Line 585: msc_sch_wb.atp_debug('Rows inserted in msc_regions_temp:'|| sql%rowcount);

581: WHERE session_id = :x_session_id)';
582: EXECUTE IMMEDIATE sql_stmt USING x_session_id;
583:
584: IF PG_DEBUG in ('Y', 'C') THEN
585: msc_sch_wb.atp_debug('Rows inserted in msc_regions_temp:'|| sql%rowcount);
586: END IF;
587: END IF;
588: --bug3520746 End Changes
589: ---s_cto_rearch

Line 704: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'sql_stmt ' || sql_stmt);

700: 'FROM mrp_atp_schedule_temp'||l_dynstring||'
701: WHERE session_id = :x_session_id';
702:
703: IF PG_DEBUG in ('Y', 'C') THEN
704: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'sql_stmt ' || sql_stmt);
705: END IF;
706:
707: IF x_mode = results_mode THEN
708: sql_stmt := sql_stmt || ' AND status_flag = 2'; -- changed form 1 to 2

Line 718: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'sql_stmt ' || sql_stmt);

714: sql_stmt := sql_stmt || ' ORDER BY sequence_number ';
715: -- End Bug 2341719 .
716:
717: IF PG_DEBUG in ('Y', 'C') THEN
718: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'sql_stmt ' || sql_stmt);
719: END IF;
720:
721: OPEN sched_cv FOR sql_stmt USING x_session_id;
722:

Line 724: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'after open sched_cv ' );

720:
721: OPEN sched_cv FOR sql_stmt USING x_session_id;
722:
723: IF PG_DEBUG in ('Y', 'C') THEN
724: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'after open sched_cv ' );
725: END IF;
726:
727: LOOP
728: IF PG_DEBUG in ('Y', 'C') THEN

Line 729: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, in LOOP,line 1');

725: END IF;
726:
727: LOOP
728: IF PG_DEBUG in ('Y', 'C') THEN
729: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, in LOOP,line 1');
730: END IF;
731:
732: FETCH sched_cv INTO sched_rec;
733: temp := SQLCODE;

Line 735: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'after fetch: SQLCODE = '||temp);

731:
732: FETCH sched_cv INTO sched_rec;
733: temp := SQLCODE;
734: IF PG_DEBUG in ('Y', 'C') THEN
735: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'after fetch: SQLCODE = '||temp);
736: END IF;
737:
738: EXIT WHEN sched_cv%NOTFOUND;
739: -- process record

Line 742: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, in LOOP,after exit');

738: EXIT WHEN sched_cv%NOTFOUND;
739: -- process record
740:
741: IF PG_DEBUG in ('Y', 'C') THEN
742: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'get from temp table, in LOOP,after exit');
743: END IF;
744:
745: MSC_SATP_FUNC.Extend_Atp(x_atp_rec, x_return_status, 1);
746:

Line 813: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Diagnostic flag: ' || sched_rec.diagnostic_atp_flag);

809:
810: --diag_atp
811: x_atp_rec.attribute_02(i) := sched_rec.diagnostic_atp_flag;
812: IF PG_DEBUG in ('Y', 'C') THEN
813: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Diagnostic flag: ' || sched_rec.diagnostic_atp_flag);
814: END IF;
815: i := i + 1;
816:
817: END LOOP;

Line 830: msc_sch_wb.atp_debug('leaving get_from_temp_table');

826: x_atp_period,
827: x_atp_supply_demand);
828:
829: IF PG_DEBUG in ('Y', 'C') THEN
830: msc_sch_wb.atp_debug('leaving get_from_temp_table');
831: END IF;
832: END IF; -- If x_mode = results_mode
833:
834: EXCEPTION

Line 839: msc_sch_wb.atp_debug('error in get_from_temp_table' || sqlerrm);

835:
836: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: IF PG_DEBUG in ('Y', 'C') THEN
839: msc_sch_wb.atp_debug('error in get_from_temp_table' || sqlerrm);
840: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Invalid Objects found');
841: END IF;
842: RAISE MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND;
843:

Line 840: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Invalid Objects found');

836: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
837: x_return_status := FND_API.G_RET_STS_ERROR;
838: IF PG_DEBUG in ('Y', 'C') THEN
839: msc_sch_wb.atp_debug('error in get_from_temp_table' || sqlerrm);
840: msc_sch_wb.atp_debug('get_from_temp_table: ' || 'Invalid Objects found');
841: END IF;
842: RAISE MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND;
843:
844: WHEN OTHERS THEN

Line 847: msc_sch_wb.atp_debug('error in get_from_temp_table' || sqlerrm);

843:
844: WHEN OTHERS THEN
845: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: IF PG_DEBUG in ('Y', 'C') THEN
847: msc_sch_wb.atp_debug('error in get_from_temp_table' || sqlerrm);
848: END IF;
849: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
850:
851: END get_from_temp_table;

Line 894: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API 02 ');

890: -- this takes care of the case when call is made for rows already
891: -- processed. Eg. change orders case
892: IF (v_dummy <> 0) THEN
893: IF PG_DEBUG in ('Y', 'C') THEN
894: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API 02 ');
895: END IF;
896:
897: return(INV_EXTATP_GRP.G_ALL_SUCCESS);
898: END IF;

Line 1001: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API '||x_atp_rec.Inventory_Item_Id.COUNT);

997:
998: -- Update mtl_demand_interface with the right return values
999: -- call atp module
1000: IF PG_DEBUG in ('Y', 'C') THEN
1001: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API '||x_atp_rec.Inventory_Item_Id.COUNT);
1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));
1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));
1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));

Line 1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));

998: -- Update mtl_demand_interface with the right return values
999: -- call atp module
1000: IF PG_DEBUG in ('Y', 'C') THEN
1001: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API '||x_atp_rec.Inventory_Item_Id.COUNT);
1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));
1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));
1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));

Line 1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));

999: -- call atp module
1000: IF PG_DEBUG in ('Y', 'C') THEN
1001: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API '||x_atp_rec.Inventory_Item_Id.COUNT);
1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));
1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));
1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));

Line 1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));

1000: IF PG_DEBUG in ('Y', 'C') THEN
1001: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API '||x_atp_rec.Inventory_Item_Id.COUNT);
1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));
1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));
1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));

Line 1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));

1001: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' Calling API '||x_atp_rec.Inventory_Item_Id.COUNT);
1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));
1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));
1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));
1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));

Line 1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));

1002: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 0 '||x_atp_rec.inventory_item_id(1));
1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));
1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));
1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));
1010: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 8 '||x_atp_rec.Action(1));

Line 1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));

1003: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 1 '||x_atp_rec.Source_Organization_Id(1));
1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));
1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));
1010: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 8 '||x_atp_rec.Action(1));
1011: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 9 '||x_atp_rec.Insert_Flag(1));

Line 1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));

1004: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 2 '||x_atp_rec.Identifier(1));
1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));
1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));
1010: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 8 '||x_atp_rec.Action(1));
1011: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 9 '||x_atp_rec.Insert_Flag(1));
1012: END IF;

Line 1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));

1005: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 3 '||x_atp_rec.Calling_Module(1));
1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));
1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));
1010: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 8 '||x_atp_rec.Action(1));
1011: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 9 '||x_atp_rec.Insert_Flag(1));
1012: END IF;
1013:

Line 1010: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 8 '||x_atp_rec.Action(1));

1006: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 4 '||x_atp_rec.Quantity_Ordered(1));
1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));
1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));
1010: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 8 '||x_atp_rec.Action(1));
1011: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 9 '||x_atp_rec.Insert_Flag(1));
1012: END IF;
1013:
1014: x_session_id := p_session_id;

Line 1011: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 9 '||x_atp_rec.Insert_Flag(1));

1007: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 5 '||x_atp_rec.Quantity_UOM(1));
1008: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 6 '||x_atp_rec.Requested_Ship_Date(1));
1009: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 7 '||x_atp_rec.Latest_Acceptable_Date(1));
1010: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 8 '||x_atp_rec.Action(1));
1011: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 9 '||x_atp_rec.Insert_Flag(1));
1012: END IF;
1013:
1014: x_session_id := p_session_id;
1015:

Line 1028: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Ship_Date:'

1024: x_msg_data,
1025: x_msg_count);
1026:
1027: IF PG_DEBUG in ('Y', 'C') THEN
1028: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Ship_Date:'
1029: || to_char(x_atp_rec_out.Ship_Date(1)) );
1030: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Available_Quantity:'
1031: || to_char(x_atp_rec_out.Available_Quantity(1)) );
1032: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Requested_Date_Quantity:'

Line 1030: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Available_Quantity:'

1026:
1027: IF PG_DEBUG in ('Y', 'C') THEN
1028: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Ship_Date:'
1029: || to_char(x_atp_rec_out.Ship_Date(1)) );
1030: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Available_Quantity:'
1031: || to_char(x_atp_rec_out.Available_Quantity(1)) );
1032: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Requested_Date_Quantity:'
1033: || to_char(x_atp_rec_out.Requested_Date_Quantity(1)) );
1034: END IF;

Line 1032: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Requested_Date_Quantity:'

1028: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Ship_Date:'
1029: || to_char(x_atp_rec_out.Ship_Date(1)) );
1030: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Available_Quantity:'
1031: || to_char(x_atp_rec_out.Available_Quantity(1)) );
1032: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'x_atp_rec_out.Requested_Date_Quantity:'
1033: || to_char(x_atp_rec_out.Requested_Date_Quantity(1)) );
1034: END IF;
1035:
1036:

Line 1047: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'Errpr :'||x_msg_data);

1043: WHERE rowid = Chartorowid(X_atp_rec_out.row_id(j));
1044: END LOOP;
1045:
1046: IF PG_DEBUG in ('Y', 'C') THEN
1047: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'Errpr :'||x_msg_data);
1048: END IF;
1049: ELSE
1050:
1051: IF x_atp_rec_out.Inventory_Item_Id.COUNT > 0 THEN

Line 1053: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out count '||x_atp_rec_out.ship_date.COUNT);

1049: ELSE
1050:
1051: IF x_atp_rec_out.Inventory_Item_Id.COUNT > 0 THEN
1052: IF PG_DEBUG in ('Y', 'C') THEN
1053: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out count '||x_atp_rec_out.ship_date.COUNT);
1054: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.row_id(1));
1055: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.requested_date_quantity(1));
1056: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 11 '||x_atp_rec_out.ship_date(1));
1057: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 22 '||x_atp_rec_out.available_quantity(1));

Line 1054: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.row_id(1));

1050:
1051: IF x_atp_rec_out.Inventory_Item_Id.COUNT > 0 THEN
1052: IF PG_DEBUG in ('Y', 'C') THEN
1053: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out count '||x_atp_rec_out.ship_date.COUNT);
1054: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.row_id(1));
1055: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.requested_date_quantity(1));
1056: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 11 '||x_atp_rec_out.ship_date(1));
1057: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 22 '||x_atp_rec_out.available_quantity(1));
1058: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 33 '||x_atp_rec_out.group_ship_date(1));

Line 1055: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.requested_date_quantity(1));

1051: IF x_atp_rec_out.Inventory_Item_Id.COUNT > 0 THEN
1052: IF PG_DEBUG in ('Y', 'C') THEN
1053: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out count '||x_atp_rec_out.ship_date.COUNT);
1054: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.row_id(1));
1055: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.requested_date_quantity(1));
1056: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 11 '||x_atp_rec_out.ship_date(1));
1057: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 22 '||x_atp_rec_out.available_quantity(1));
1058: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 33 '||x_atp_rec_out.group_ship_date(1));
1059: END IF;

Line 1056: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 11 '||x_atp_rec_out.ship_date(1));

1052: IF PG_DEBUG in ('Y', 'C') THEN
1053: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out count '||x_atp_rec_out.ship_date.COUNT);
1054: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.row_id(1));
1055: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.requested_date_quantity(1));
1056: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 11 '||x_atp_rec_out.ship_date(1));
1057: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 22 '||x_atp_rec_out.available_quantity(1));
1058: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 33 '||x_atp_rec_out.group_ship_date(1));
1059: END IF;
1060: END IF;

Line 1057: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 22 '||x_atp_rec_out.available_quantity(1));

1053: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out count '||x_atp_rec_out.ship_date.COUNT);
1054: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.row_id(1));
1055: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.requested_date_quantity(1));
1056: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 11 '||x_atp_rec_out.ship_date(1));
1057: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 22 '||x_atp_rec_out.available_quantity(1));
1058: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 33 '||x_atp_rec_out.group_ship_date(1));
1059: END IF;
1060: END IF;
1061:

Line 1058: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 33 '||x_atp_rec_out.group_ship_date(1));

1054: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.row_id(1));
1055: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 00 '||x_atp_rec_out.requested_date_quantity(1));
1056: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 11 '||x_atp_rec_out.ship_date(1));
1057: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 22 '||x_atp_rec_out.available_quantity(1));
1058: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' 33 '||x_atp_rec_out.group_ship_date(1));
1059: END IF;
1060: END IF;
1061:
1062: IF x_atp_rec_out.Inventory_Item_Id.COUNT > 0 THEN

Line 1065: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out '||j);

1061:
1062: IF x_atp_rec_out.Inventory_Item_Id.COUNT > 0 THEN
1063: FOR j IN 1..x_atp_rec_out.Inventory_Item_Id.COUNT LOOP
1064: IF PG_DEBUG in ('Y', 'C') THEN
1065: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_rec_out '||j);
1066: END IF;
1067: -- FORALL j IN 1..x_atp_rec_out.Inventory_Item_Id.COUNT
1068: -- For all was giving wierd problems in Updating date variables.
1069:

Line 1072: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'christine, request date atp q is'||x_Atp_rec_out.requested_date_quantity(j));

1068: -- For all was giving wierd problems in Updating date variables.
1069:
1070: -- ?? Infinite_time_fence_date is being updated in inlatp.ppc
1071: IF PG_DEBUG in ('Y', 'C') THEN
1072: msc_sch_wb.atp_debug('Call_ATP_11: ' || 'christine, request date atp q is'||x_Atp_rec_out.requested_date_quantity(j));
1073: END IF;
1074: UPDATE mtl_demand_interface
1075: SET Request_Date_ATP_Quantity = x_Atp_rec_out.requested_date_quantity(j),
1076: Request_ATP_Date = To_date(To_char(X_atp_rec_out.ship_date(j), 'J'),'J'),

Line 1089: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_sd count '||x_atp_supply_demand.Inventory_Item_Id.COUNT);

1085:
1086: IF x_atp_supply_demand.Inventory_Item_Id.COUNT > 0 THEN
1087:
1088: IF PG_DEBUG in ('Y', 'C') THEN
1089: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_sd count '||x_atp_supply_demand.Inventory_Item_Id.COUNT);
1090: END IF;
1091:
1092: FOR j IN 1..x_atp_supply_demand.inventory_item_id.COUNT LOOP
1093: IF PG_DEBUG in ('Y', 'C') THEN

Line 1094: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_sd '||j);

1090: END IF;
1091:
1092: FOR j IN 1..x_atp_supply_demand.inventory_item_id.COUNT LOOP
1093: IF PG_DEBUG in ('Y', 'C') THEN
1094: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_sd '||j);
1095: END IF;
1096: INSERT INTO MTL_SUPPLY_DEMAND_TEMP
1097: (
1098: RECORD_TYPE,

Line 1143: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_period count '||x_atp_period.Inventory_Item_Id.COUNT);

1139: END LOOP;
1140: END IF;
1141: IF x_atp_period.inventory_item_id.COUNT > 0 THEN
1142: IF PG_DEBUG in ('Y', 'C') THEN
1143: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp_period count '||x_atp_period.Inventory_Item_Id.COUNT);
1144: END IF;
1145:
1146: FOR j IN 1..x_atp_period.inventory_item_id.COUNT LOOP
1147: IF PG_DEBUG in ('Y', 'C') THEN

Line 1148: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp period '||j);

1144: END IF;
1145:
1146: FOR j IN 1..x_atp_period.inventory_item_id.COUNT LOOP
1147: IF PG_DEBUG in ('Y', 'C') THEN
1148: msc_sch_wb.atp_debug('Call_ATP_11: ' || ' atp period '||j);
1149: END IF;
1150: INSERT INTO MTL_SUPPLY_DEMAND_TEMP
1151: (
1152: ATP_PERIOD_START_DATE,

Line 1230: msc_sch_wb.atp_debug('Excp in extend_mast : '||Substr(Sqlerrm,1,100));

1226: mast_rec.task_number.extend(1);
1227: EXCEPTION
1228: WHEN OTHERS THEN
1229: IF PG_DEBUG in ('Y', 'C') THEN
1230: msc_sch_wb.atp_debug('Excp in extend_mast : '||Substr(Sqlerrm,1,100));
1231: END IF;
1232: END extend_mast;
1233:
1234:

Line 1268: msc_sch_wb.atp_debug('Excp in trim_mast : '||Substr(Sqlerrm,1,100));

1264: mast_rec.task_number.trim(1);
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: IF PG_DEBUG in ('Y', 'C') THEN
1268: msc_sch_wb.atp_debug('Excp in trim_mast : '||Substr(Sqlerrm,1,100));
1269: END IF;
1270: END trim_mast;
1271:
1272: -- Bug 2974324. Redundant test procedure removed from here

Line 1294: msc_sch_wb.atp_debug('Begin put_into_bom_temp_table ');

1290:
1291: BEGIN
1292:
1293: IF PG_DEBUG in ('Y', 'C') THEN
1294: msc_sch_wb.atp_debug('****Begin put_into_bom_temp_table ****');
1295: END IF;
1296: -- initialize API returm status to success
1297: x_return_status := FND_API.G_RET_STS_SUCCESS;
1298:

Line 1313: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'sql_stmt : '||sql_stmt);

1309: ELSE
1310: sql_stmt := 'DELETE msc_bom_temp'||l_dynstring|| ' WHERE session_id = :session_id';
1311:
1312: IF PG_DEBUG in ('Y', 'C') THEN
1313: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'sql_stmt : '||sql_stmt);
1314: END IF;
1315:
1316: EXECUTE IMMEDIATE sql_stmt using p_session_id;
1317: END IF;

Line 1320: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'After deleting from msc_bom_temp table');

1316: EXECUTE IMMEDIATE sql_stmt using p_session_id;
1317: END IF;
1318:
1319: IF PG_DEBUG in ('Y', 'C') THEN
1320: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'After deleting from msc_bom_temp table');
1321: END IF;
1322:
1323: j := p_atp_bom_rec.assembly_identifier.FIRST;
1324: IF PG_DEBUG in ('Y', 'C') THEN

Line 1325: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'j = '||j);

1321: END IF;
1322:
1323: j := p_atp_bom_rec.assembly_identifier.FIRST;
1324: IF PG_DEBUG in ('Y', 'C') THEN
1325: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'j = '||j);
1326: END IF;
1327:
1328: -- bug 2974324. Changed the dynamic SQL to static if db_link is null
1329: IF p_dblink IS NOT NULL THEN

Line 1333: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'in loop j = '||j ||' : '|| 'item_id : ' ||

1329: IF p_dblink IS NOT NULL THEN
1330:
1331: WHILE j IS NOT NULL LOOP
1332: IF PG_DEBUG in ('Y', 'C') THEN
1333: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'in loop j = '||j ||' : '|| 'item_id : ' ||
1334: p_atp_bom_rec.assembly_item_id(j) || ' : '||
1335: 'comp item_id : ' ||p_atp_bom_rec.component_item_id(j)||
1336: ' atp flag : ' || p_atp_bom_rec.atp_check(j));
1337: END IF;

Line 1379: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'after insert into bom_temp');

1375: )';
1376:
1377:
1378: IF PG_DEBUG in ('Y', 'C') THEN
1379: msc_sch_wb.atp_debug('put_into_bom_temp_table: ' || 'after insert into bom_temp');
1380: END IF;
1381:
1382: EXECUTE IMMEDIATE sql_stmt using
1383: p_session_id,

Line 1448: msc_sch_wb.atp_debug('End put_into_bom_temp_table ');

1444: END IF; -- bug 2974324. Changed the dynamic SQL to static if db_link is null
1445:
1446:
1447: IF PG_DEBUG in ('Y', 'C') THEN
1448: msc_sch_wb.atp_debug('****End put_into_bom_temp_table ****');
1449: END IF;
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: IF PG_DEBUG in ('Y', 'C') THEN

Line 1453: msc_sch_wb.atp_debug(' Error in put_into_bom_temp_table '||substr(sqlerrm,1,100));

1449: END IF;
1450: EXCEPTION
1451: WHEN OTHERS THEN
1452: IF PG_DEBUG in ('Y', 'C') THEN
1453: msc_sch_wb.atp_debug(' Error in put_into_bom_temp_table '||substr(sqlerrm,1,100));
1454: END IF;
1455: x_msg_data := substr(sqlerrm,1,100);
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: END put_into_bom_temp_table;

Line 1475: msc_sch_wb.atp_debug('PROCEDURE Put_Period_Data');

1471:
1472: IF p_atp_period.level.COUNT > 0 THEN
1473:
1474: IF PG_DEBUG in ('Y', 'C') THEN
1475: msc_sch_wb.atp_debug('PROCEDURE Put_Period_Data');
1476: msc_sch_wb.atp_debug('Put_Period_Data: ' || ' period records '||p_atp_period.level.COUNT);
1477: END IF;
1478:
1479: l_user_id := FND_GLOBAL.user_id;

Line 1476: msc_sch_wb.atp_debug('Put_Period_Data: ' || ' period records '||p_atp_period.level.COUNT);

1472: IF p_atp_period.level.COUNT > 0 THEN
1473:
1474: IF PG_DEBUG in ('Y', 'C') THEN
1475: msc_sch_wb.atp_debug('PROCEDURE Put_Period_Data');
1476: msc_sch_wb.atp_debug('Put_Period_Data: ' || ' period records '||p_atp_period.level.COUNT);
1477: END IF;
1478:
1479: l_user_id := FND_GLOBAL.user_id;
1480: l_sysdate := sysdate;

Line 1564: msc_sch_wb.atp_debug(' XXX Put_Period_Data should not be called with dblink');

1560: );
1561:
1562: ELSE -- IF x_dblink IS NULL THEN
1563: IF PG_DEBUG in ('Y', 'C') THEN
1564: msc_sch_wb.atp_debug(' XXX Put_Period_Data should not be called with dblink');
1565: END IF;
1566:
1567: -- dsting: added stuff for creation_date, created_by,
1568: -- last_update_date, last_updated_by, last_update_login

Line 1653: msc_sch_wb.atp_debug('Put_Period_Data: ' || 'enter put_into_temp_table :just before execute');

1649: -- Parse cursor handler for sql_stmt
1650: DBMS_SQL.PARSE(cur_handler, sql_stmt, DBMS_SQL.NATIVE);
1651:
1652: IF PG_DEBUG in ('Y', 'C') THEN
1653: msc_sch_wb.atp_debug('Put_Period_Data: ' || 'enter put_into_temp_table :just before execute');
1654: END IF;
1655:
1656: FOR j IN 1..p_atp_period.level.COUNT LOOP
1657:

Line 1700: msc_sch_wb.atp_debug('Put_Period_Data: ' || 'enter put_into_temp_table :after execute');

1696:
1697: END LOOP;
1698:
1699: IF PG_DEBUG in ('Y', 'C') THEN
1700: msc_sch_wb.atp_debug('Put_Period_Data: ' || 'enter put_into_temp_table :after execute');
1701: END IF;
1702:
1703: -- Close the cursor in case it is open
1704: IF DBMS_SQL.IS_OPEN(cur_handler) THEN

Line 1729: msc_sch_wb.atp_debug('Put_Pegging_data: ' || 'p_dblink = ' ||p_dblink);

1725: -- put it back into source.
1726:
1727: l_user_id := FND_GLOBAL.USER_ID;
1728: IF PG_DEBUG in ('Y', 'C') THEN
1729: msc_sch_wb.atp_debug('Put_Pegging_data: ' || 'p_dblink = ' ||p_dblink);
1730: END IF;
1731:
1732: IF p_dblink is not null THEN
1733:

Line 1735: msc_sch_wb.atp_debug('Put_Pegging_data: ' || 'inserting pegging into source side');

1731:
1732: IF p_dblink is not null THEN
1733:
1734: IF PG_DEBUG in ('Y', 'C') THEN
1735: msc_sch_wb.atp_debug('Put_Pegging_data: ' || 'inserting pegging into source side');
1736: END IF;
1737: -- Bug 1761545, added component_identifier in pegging for MATO
1738:
1739: -- dsting: added creation_date, created_by,

Line 1842: msc_sch_wb.atp_debug('Put_Pegging_data: ' || 'inserted pegging into source side');

1838: l_user_id,
1839: p_session_id;
1840:
1841: IF PG_DEBUG in ('Y', 'C') THEN
1842: msc_sch_wb.atp_debug('Put_Pegging_data: ' || 'inserted pegging into source side');
1843: END IF;
1844:
1845:
1846: -- after the insert is done, delete the pegging records

Line 1899: msc_sch_wb.atp_debug('Put_Scheduling_data in results mode: ' || ' output records '|| l_count );

1895: ---s_cto_rearch
1896: IF l_count > 0 THEN
1897: IF p_mode = RESULTS_MODE THEN
1898: IF PG_DEBUG in ('Y', 'C') THEN
1899: msc_sch_wb.atp_debug('Put_Scheduling_data in results mode: ' || ' output records '|| l_count );
1900: END IF;
1901: MSC_ATP_UTILS.Put_sch_data_result_mode(p_atp_rec, p_dblink, p_session_id);
1902: ELSE
1903: MSC_ATP_UTILS.Put_sch_Data_Request_mode(p_atp_rec, p_session_id);

Line 1920: msc_sch_wb.atp_debug('PROCEDURE Retrieve_Period_And_SD_Data');

1916:
1917: BEGIN
1918:
1919: IF PG_DEBUG in ('Y', 'C') THEN
1920: msc_sch_wb.atp_debug('PROCEDURE Retrieve_Period_And_SD_Data');
1921: END IF;
1922:
1923: -----------------
1924: -- Period Data --

Line 1990: msc_sch_wb.atp_debug('Retrieve_Period_and_SD_Data: ' || ' Rows period data: ' || SQL%ROWCOUNT);

1986: where session_id = p_session_id
1987: and record_type = 3);
1988:
1989: IF PG_DEBUG in ('Y', 'C') THEN
1990: msc_sch_wb.atp_debug('Retrieve_Period_and_SD_Data: ' || ' Rows period data: ' || SQL%ROWCOUNT);
1991: END IF;
1992:
1993: -------------
1994: -- SD Data --

Line 2065: msc_sch_wb.atp_debug('Retrieve_Period_and_SD_Data: ' || ' Rows SD data: ' || SQL%ROWCOUNT);

2061: and record_type = 3);
2062:
2063:
2064: IF PG_DEBUG in ('Y', 'C') THEN
2065: msc_sch_wb.atp_debug('Retrieve_Period_and_SD_Data: ' || ' Rows SD data: ' || SQL%ROWCOUNT);
2066: END IF;
2067:
2068: END Retrieve_Period_and_SD_Data;
2069:

Line 2214: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'PROCEDURE Transfer_SD_And_Period_Data');

2210:
2211: BEGIN
2212:
2213: IF PG_DEBUG in ('Y', 'C') THEN
2214: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'PROCEDURE Transfer_SD_And_Period_Data');
2215: END IF;
2216:
2217: IF p_dblink IS NOT NULL THEN
2218: -- transfer period (record_type 1) and s/d (2) and pegging (3) data

Line 2221: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'apps_ver: ' || MSC_ATP_PVT.G_APPS_VER);

2217: IF p_dblink IS NOT NULL THEN
2218: -- transfer period (record_type 1) and s/d (2) and pegging (3) data
2219: -- that appear in the pegging tree
2220: IF PG_DEBUG in ('Y', 'C') THEN
2221: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'apps_ver: ' || MSC_ATP_PVT.G_APPS_VER);
2222: END IF;
2223:
2224: sql_stmt := 'Insert into mrp_atp_details_temp@' || p_dblink || ' (';
2225:

Line 2242: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'dsting: '||sql_stmt);

2238: and pegging_id in (Select pegging_id from mrp_atp_details_temp
2239: where session_id = :p_session_id
2240: and record_type = 3)';
2241: IF PG_DEBUG in ('Y', 'C') THEN
2242: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'dsting: '||sql_stmt);
2243: END IF;
2244: execute immediate sql_stmt using p_session_id , p_session_id;
2245:
2246: IF PG_DEBUG in ('Y', 'C') THEN

Line 2247: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'dsting: '|| SQL%ROWCOUNT);

2243: END IF;
2244: execute immediate sql_stmt using p_session_id , p_session_id;
2245:
2246: IF PG_DEBUG in ('Y', 'C') THEN
2247: msc_sch_wb.atp_debug('Transfer_mrp_atp_details_temp: ' || 'dsting: '|| SQL%ROWCOUNT);
2248: END IF;
2249: END IF;
2250:
2251: END Transfer_mrp_atp_details_temp;

Line 2270: msc_sch_wb.atp_debug('PROCEDURE Copy_MRP_SD_Recs');

2266: who_cols VARCHAR2(100);
2267: t1 NUMBER;
2268: BEGIN
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: msc_sch_wb.atp_debug('PROCEDURE Copy_MRP_SD_Recs');
2271: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_old_pegging_id: ' || p_old_pegging_id);
2272: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_pegging_id: ' || p_pegging_id);
2273: END IF;
2274:

Line 2271: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_old_pegging_id: ' || p_old_pegging_id);

2267: t1 NUMBER;
2268: BEGIN
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: msc_sch_wb.atp_debug('PROCEDURE Copy_MRP_SD_Recs');
2271: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_old_pegging_id: ' || p_old_pegging_id);
2272: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_pegging_id: ' || p_pegging_id);
2273: END IF;
2274:
2275: INSERT INTO mrp_atp_details_temp (

Line 2272: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_pegging_id: ' || p_pegging_id);

2268: BEGIN
2269: IF PG_DEBUG in ('Y', 'C') THEN
2270: msc_sch_wb.atp_debug('PROCEDURE Copy_MRP_SD_Recs');
2271: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_old_pegging_id: ' || p_old_pegging_id);
2272: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' p_pegging_id: ' || p_pegging_id);
2273: END IF;
2274:
2275: INSERT INTO mrp_atp_details_temp (
2276: session_id,

Line 2355: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' Num rows copied: ' || SQL%ROWCOUNT);

2351: where pegging_id = p_old_pegging_id
2352: and record_type = 2;
2353:
2354: IF PG_DEBUG in ('Y', 'C') THEN
2355: msc_sch_wb.atp_debug('Copy_MRP_SD_Recs: ' || ' Num rows copied: ' || SQL%ROWCOUNT);
2356: END IF;
2357:
2358: END Copy_MRP_SD_Recs;
2359:

Line 2379: msc_sch_wb.atp_debug('Process_Supply_Demand_details: ' || 'Distributed environment. Put from dest to source table');

2375:
2376: IF l_dynstring is not null then
2377: ---distributed database:
2378: IF PG_DEBUG in ('Y', 'C') THEN
2379: msc_sch_wb.atp_debug('Process_Supply_Demand_details: ' || 'Distributed environment. Put from dest to source table');
2380: END IF;
2381: sql_stmt := 'Insert into mrp_atp_details_temp' || l_dynstring ||
2382: '(select * from mrp_atp_details_temp
2383: where session_id = :p_session_id

Line 2393: msc_sch_wb.atp_debug('Process_Supply_Demand_details: ' || 'Non Distributed env. Put SD details from temp table to pl/sql tables');

2389:
2390: ELSE --- IF p_dblink is not null then
2391: --- non-distributed environment
2392: IF PG_DEBUG in ('Y', 'C') THEN
2393: msc_sch_wb.atp_debug('Process_Supply_Demand_details: ' || 'Non Distributed env. Put SD details from temp table to pl/sql tables');
2394: END IF;
2395: j := 1;
2396: SELECT ORDER_LINE_ID
2397: ,PEGGING_ID

Line 2496: msc_sch_wb.atp_debug('Put_SD_Data: ' || ' SD records '||p_atp_supply_demand.level.COUNT);

2492: l_user_id := FND_GLOBAL.USER_ID;
2493:
2494: IF p_atp_supply_demand.level.COUNT > 0 THEN
2495: IF PG_DEBUG in ('Y', 'C') THEN
2496: msc_sch_wb.atp_debug('Put_SD_Data: ' || ' SD records '||p_atp_supply_demand.level.COUNT);
2497: msc_sch_wb.atp_debug('XXX should not have sd records in Put_SD_Data');
2498: END IF;
2499:
2500: IF p_dblink IS NULL THEN

Line 2497: msc_sch_wb.atp_debug('XXX should not have sd records in Put_SD_Data');

2493:
2494: IF p_atp_supply_demand.level.COUNT > 0 THEN
2495: IF PG_DEBUG in ('Y', 'C') THEN
2496: msc_sch_wb.atp_debug('Put_SD_Data: ' || ' SD records '||p_atp_supply_demand.level.COUNT);
2497: msc_sch_wb.atp_debug('XXX should not have sd records in Put_SD_Data');
2498: END IF;
2499:
2500: IF p_dblink IS NULL THEN
2501:

Line 2671: msc_sch_wb.atp_debug('Put_SD_Data: ' || 'enter put_into_temp_table in between values and execute ');

2667: , :last_update_login
2668: )';
2669:
2670: IF PG_DEBUG in ('Y', 'C') THEN
2671: msc_sch_wb.atp_debug('Put_SD_Data: ' || 'enter put_into_temp_table in between values and execute ');
2672: END IF;
2673:
2674: -- Obtain cursor handler for sql_stmt
2675: cur_handler := DBMS_SQL.OPEN_CURSOR;

Line 2722: msc_sch_wb.atp_debug('Put_SD_Data: ' || 'enter put_into_temp_table :20');

2718: rows_processed := DBMS_SQL.EXECUTE(cur_handler);
2719:
2720: END LOOP;
2721: IF PG_DEBUG in ('Y', 'C') THEN
2722: msc_sch_wb.atp_debug('Put_SD_Data: ' || 'enter put_into_temp_table :20');
2723: END IF;
2724:
2725: -- Close the cursor in case it is open
2726: IF DBMS_SQL.IS_OPEN(cur_handler) THEN

Line 2740: msc_sch_wb.atp_debug('Inside Update_Line_Item_Properties');

2736: Action IN NUMBER) --3720018
2737: IS
2738: BEGIN
2739: IF PG_DEBUG in ('Y', 'C') THEN
2740: msc_sch_wb.atp_debug('Inside Update_Line_Item_Properties');
2741: msc_sch_wb.atp_debug('Update item properties');
2742: END IF;
2743: update mrp_atp_schedule_temp mast
2744: --bug 4078703: Populate atp_lead time as this lead time is required

Line 2741: msc_sch_wb.atp_debug('Update item properties');

2737: IS
2738: BEGIN
2739: IF PG_DEBUG in ('Y', 'C') THEN
2740: msc_sch_wb.atp_debug('Inside Update_Line_Item_Properties');
2741: msc_sch_wb.atp_debug('Update item properties');
2742: END IF;
2743: update mrp_atp_schedule_temp mast
2744: --bug 4078703: Populate atp_lead time as this lead time is required
2745: --on OM sales order lies to support misc. functionalities in inv and

Line 2774: msc_sch_wb.atp_debug('After updating item properties');

2770: and (mast.source_organization_id is not null
2771: or mast.validation_org is not null);
2772:
2773: IF PG_DEBUG in ('Y', 'C') THEN
2774: msc_sch_wb.atp_debug('After updating item properties');
2775: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
2776: END IF;
2777:
2778: --3720018, this query will update old_source_organization_id and old_demand_class

Line 2775: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);

2771: or mast.validation_org is not null);
2772:
2773: IF PG_DEBUG in ('Y', 'C') THEN
2774: msc_sch_wb.atp_debug('After updating item properties');
2775: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
2776: END IF;
2777:
2778: --3720018, this query will update old_source_organization_id and old_demand_class
2779: -- in case of atp inquiry for a scheduled line from sales order pad

Line 2793: msc_sch_wb.atp_debug('After updating old_source_organization_id and old_demand_class');

2789: where mast.Old_Source_Organization_Id is NULL and
2790: mast.session_id = p_session_id;
2791: END IF;
2792: IF PG_DEBUG in ('Y', 'C') THEN
2793: msc_sch_wb.atp_debug('After updating old_source_organization_id and old_demand_class');
2794: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
2795: END IF;
2796: -- 3720018
2797:

Line 2794: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);

2790: mast.session_id = p_session_id;
2791: END IF;
2792: IF PG_DEBUG in ('Y', 'C') THEN
2793: msc_sch_wb.atp_debug('After updating old_source_organization_id and old_demand_class');
2794: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
2795: END IF;
2796: -- 3720018
2797:
2798: END Update_Line_item_properties;

Line 2804: msc_sch_wb.atp_debug('Inside Update_Line_Item_Properties_WS');

2800: procedure Update_Line_Item_Properties_WS(p_session_id IN NUMBER)
2801: IS
2802: BEGIN
2803: IF PG_DEBUG in ('Y', 'C') THEN
2804: msc_sch_wb.atp_debug('Inside Update_Line_Item_Properties_WS');
2805: msc_sch_wb.atp_debug('Update item properties');
2806: END IF;
2807:
2808: update mrp_atp_schedule_temp mast

Line 2805: msc_sch_wb.atp_debug('Update item properties');

2801: IS
2802: BEGIN
2803: IF PG_DEBUG in ('Y', 'C') THEN
2804: msc_sch_wb.atp_debug('Inside Update_Line_Item_Properties_WS');
2805: msc_sch_wb.atp_debug('Update item properties');
2806: END IF;
2807:
2808: update mrp_atp_schedule_temp mast
2809: --bug 4078703: Populate atp_lead time as this lead time is required

Line 2841: msc_sch_wb.atp_debug('After updating item properties');

2837: and (mast.source_organization_id is not null
2838: or mast.validation_org is not null);
2839:
2840: IF PG_DEBUG in ('Y', 'C') THEN
2841: msc_sch_wb.atp_debug('After updating item properties');
2842: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
2843: END IF;
2844:
2845: END Update_Line_Item_Properties_WS;

Line 2842: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);

2838: or mast.validation_org is not null);
2839:
2840: IF PG_DEBUG in ('Y', 'C') THEN
2841: msc_sch_wb.atp_debug('After updating item properties');
2842: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
2843: END IF;
2844:
2845: END Update_Line_Item_Properties_WS;
2846:

Line 2859: msc_sch_wb.atp_debug('enter Put_Sch_data_Request_Mode');

2855:
2856: begin
2857:
2858: IF PG_DEBUG in ('Y', 'C') THEN
2859: msc_sch_wb.atp_debug('enter Put_Sch_data_Request_Mode');
2860: END IF;
2861:
2862: l_user_id := FND_GLOBAL.USER_ID;
2863: l_count := p_atp_rec.inventory_item_id.count;

Line 2870: msc_sch_wb.atp_debug('* After Deleting data for old session ');

2866: --bug 3378648: delete only ATP relevent data
2867: and status_flag in (1,2, 99);
2868:
2869: IF PG_DEBUG in ('Y', 'C') THEN
2870: msc_sch_wb.atp_debug('***** After Deleting data for old session ****');
2871: END IF;
2872:
2873: l_sequence_number.Extend(l_count);
2874:

Line 2876: msc_sch_wb.atp_debug('After Extending Sequence array');

2872:
2873: l_sequence_number.Extend(l_count);
2874:
2875: IF PG_DEBUG in ('Y', 'C') THEN
2876: msc_sch_wb.atp_debug('After Extending Sequence array');
2877: END IF;
2878: IF nvl(p_atp_rec.calling_module(1), -1) in (-1, 724,-99) THEN
2879: FOR j in 1..l_count LOOP
2880: l_sequence_number(j) := j;

Line 2883: msc_sch_wb.atp_debug('l_sequence_number.count := ' || l_sequence_number.count);

2879: FOR j in 1..l_count LOOP
2880: l_sequence_number(j) := j;
2881: END LOOP;
2882: IF PG_DEBUG in ('Y', 'C') THEN
2883: msc_sch_wb.atp_debug('l_sequence_number.count := ' || l_sequence_number.count);
2884: msc_sch_wb.atp_debug('l_count := ' || l_count);
2885: END IF;
2886: END IF;
2887:

Line 2884: msc_sch_wb.atp_debug('l_count := ' || l_count);

2880: l_sequence_number(j) := j;
2881: END LOOP;
2882: IF PG_DEBUG in ('Y', 'C') THEN
2883: msc_sch_wb.atp_debug('l_sequence_number.count := ' || l_sequence_number.count);
2884: msc_sch_wb.atp_debug('l_count := ' || l_count);
2885: END IF;
2886: END IF;
2887:
2888:

Line 3129: msc_sch_wb.atp_debug('After Inserting the data in request mode');

3125: -- if source organzation_id is provided then atp_flag is inserted as null
3126: --If we have invalid org-item combination then atp_flag will remain null
3127: -- else it will be updated from atp_flag of nvl(src_ord, validation_org)
3128: IF PG_DEBUG in ('Y', 'C') THEN
3129: msc_sch_wb.atp_debug('After Inserting the data in request mode');
3130: msc_sch_wb.atp_debug('rows inserted = ' || SQL%ROWCOUNT);
3131: END IF;
3132:
3133: IF MSC_ATP_PVT.G_CALLING_MODULE <> 724 THEN

Line 3130: msc_sch_wb.atp_debug('rows inserted = ' || SQL%ROWCOUNT);

3126: --If we have invalid org-item combination then atp_flag will remain null
3127: -- else it will be updated from atp_flag of nvl(src_ord, validation_org)
3128: IF PG_DEBUG in ('Y', 'C') THEN
3129: msc_sch_wb.atp_debug('After Inserting the data in request mode');
3130: msc_sch_wb.atp_debug('rows inserted = ' || SQL%ROWCOUNT);
3131: END IF;
3132:
3133: IF MSC_ATP_PVT.G_CALLING_MODULE <> 724 THEN
3134: /*

Line 3158: msc_sch_wb.atp_debug('After updating item properties');

3154: and (mast.source_organization_id is not null
3155: or mast.validation_org is not null);
3156:
3157: IF PG_DEBUG in ('Y', 'C') THEN
3158: msc_sch_wb.atp_debug('After updating item properties');
3159: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
3160: END IF;
3161: */
3162: -- Web service, no need to change item_properties if call is from Web service

Line 3159: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);

3155: or mast.validation_org is not null);
3156:
3157: IF PG_DEBUG in ('Y', 'C') THEN
3158: msc_sch_wb.atp_debug('After updating item properties');
3159: msc_sch_wb.atp_debug('Rows updated := ' || SQL%ROWCOUNT);
3160: END IF;
3161: */
3162: -- Web service, no need to change item_properties if call is from Web service
3163: IF (p_atp_rec.attribute_02(1) = 3) THEN

Line 3175: msc_sch_wb.atp_debug('Check if OE flag has been turned on or not');

3171: --add condition to fiter based on atp query
3172: --removing the condition below to suport OE flag for all modules.
3173: --and (MSC_ATP_PVT.G_CALLING_MODULE IN (-1, 660)) THEN
3174: IF PG_DEBUG in ('Y', 'C') THEN
3175: msc_sch_wb.atp_debug('Check if OE flag has been turned on or not');
3176: END IF;
3177: select count(*)
3178: into l_count
3179: from mrp_atp_schedule_temp mast

Line 3186: msc_sch_wb.atp_debug('l_count for OE Flag := ' || l_count);

3182: and status_flag = 99
3183: and mast.OE_FLAG = 'Y';
3184:
3185: IF PG_DEBUG in ('Y', 'C') THEN
3186: msc_sch_wb.atp_debug('l_count for OE Flag := ' || l_count);
3187: END IF;
3188:
3189: IF l_count > 0 then
3190:

Line 3209: msc_sch_wb.atp_debug('After updating OE Flag ');

3205: and status_flag = 99
3206: and mast.OE_FLAG = 'Y';
3207:
3208: IF PG_DEBUG in ('Y', 'C') THEN
3209: msc_sch_wb.atp_debug('After updating OE Flag ');
3210: END IF;
3211:
3212: END IF;
3213:

Line 3217: msc_sch_wb.atp_debug('Call from destination Instance. No need to update atp flags or oe flags');

3213:
3214: -- END IF; */
3215: ELSE
3216: IF PG_DEBUG in ('Y', 'C') THEN
3217: msc_sch_wb.atp_debug('Call from destination Instance. No need to update atp flags or oe flags');
3218: END IF;
3219: END IF;
3220: IF PG_DEBUG in ('Y', 'C') THEN
3221: msc_sch_wb.atp_debug('exit Put_Sch_data_Request_Mode');

Line 3221: msc_sch_wb.atp_debug('exit Put_Sch_data_Request_Mode');

3217: msc_sch_wb.atp_debug('Call from destination Instance. No need to update atp flags or oe flags');
3218: END IF;
3219: END IF;
3220: IF PG_DEBUG in ('Y', 'C') THEN
3221: msc_sch_wb.atp_debug('exit Put_Sch_data_Request_Mode');
3222: END IF;
3223: EXCEPTION
3224: WHEN OTHERS THEN
3225: msc_sch_wb.atp_debug('Something wrong in Put_Sch_data_Request_Mode');

Line 3225: msc_sch_wb.atp_debug('Something wrong in Put_Sch_data_Request_Mode');

3221: msc_sch_wb.atp_debug('exit Put_Sch_data_Request_Mode');
3222: END IF;
3223: EXCEPTION
3224: WHEN OTHERS THEN
3225: msc_sch_wb.atp_debug('Something wrong in Put_Sch_data_Request_Mode');
3226: msc_sch_wb.atp_debug('Sql Err := ' || sqlerrm);
3227:
3228: END Put_Sch_Data_Request_Mode;
3229:

Line 3226: msc_sch_wb.atp_debug('Sql Err := ' || sqlerrm);

3222: END IF;
3223: EXCEPTION
3224: WHEN OTHERS THEN
3225: msc_sch_wb.atp_debug('Something wrong in Put_Sch_data_Request_Mode');
3226: msc_sch_wb.atp_debug('Sql Err := ' || sqlerrm);
3227:
3228: END Put_Sch_Data_Request_Mode;
3229:
3230: Procedure Put_Sch_data_result_mode(p_atp_rec IN MRP_ATP_PUB.atp_rec_typ,

Line 3260: msc_sch_wb.atp_debug('enter Put_Sch_data_result_mode');

3256: BEGIN
3257:
3258:
3259: IF PG_DEBUG in ('Y', 'C') THEN
3260: msc_sch_wb.atp_debug('enter Put_Sch_data_result_mode');
3261: msc_sch_wb.atp_debug('G_INCLUDED_ITEM_IS_PRESENT :=' || MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT);
3262: END IF;
3263:
3264: -- bug 2974324. Set l_status_flag to 2 here.

Line 3261: msc_sch_wb.atp_debug('G_INCLUDED_ITEM_IS_PRESENT :=' || MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT);

3257:
3258:
3259: IF PG_DEBUG in ('Y', 'C') THEN
3260: msc_sch_wb.atp_debug('enter Put_Sch_data_result_mode');
3261: msc_sch_wb.atp_debug('G_INCLUDED_ITEM_IS_PRESENT :=' || MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT);
3262: END IF;
3263:
3264: -- bug 2974324. Set l_status_flag to 2 here.
3265: l_status_flag := SYS_NO;

Line 3269: msc_sch_wb.atp_debug('l_count := '|| l_count);

3265: l_status_flag := SYS_NO;
3266: l_count := p_atp_rec.inventory_item_id.count;
3267:
3268:
3269: msc_sch_wb.atp_debug('l_count := '|| l_count);
3270: /*l_sequence_number.extend(l_count);
3271: FOR j in 1..l_count LOOP
3272: l_sequence_number(j) := j;
3273: END LOOP; */

Line 3275: msc_sch_wb.atp_debug(' insert data for Call from other modules');

3271: FOR j in 1..l_count LOOP
3272: l_sequence_number(j) := j;
3273: END LOOP; */
3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: msc_sch_wb.atp_debug(' insert data for Call from other modules');
3276: FOR j in 1..l_count LOOP
3277: msc_sch_wb.atp_debug('j');
3278: msc_sch_wb.atp_debug('Identifier := ' || p_atp_rec.identifier(j));
3279: msc_sch_wb.atp_debug('Mandatory flag := ' || p_atp_rec.mandatory_item_flag(j));

Line 3277: msc_sch_wb.atp_debug('j');

3273: END LOOP; */
3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: msc_sch_wb.atp_debug(' insert data for Call from other modules');
3276: FOR j in 1..l_count LOOP
3277: msc_sch_wb.atp_debug('j');
3278: msc_sch_wb.atp_debug('Identifier := ' || p_atp_rec.identifier(j));
3279: msc_sch_wb.atp_debug('Mandatory flag := ' || p_atp_rec.mandatory_item_flag(j));
3280: msc_sch_wb.atp_debug('sequence number := ' || p_atp_rec.sequence_number(j));
3281: msc_sch_wb.atp_debug('atp_lead_time := ' || p_atp_rec.atp_lead_time(j));

Line 3278: msc_sch_wb.atp_debug('Identifier := ' || p_atp_rec.identifier(j));

3274: IF PG_DEBUG in ('Y', 'C') THEN
3275: msc_sch_wb.atp_debug(' insert data for Call from other modules');
3276: FOR j in 1..l_count LOOP
3277: msc_sch_wb.atp_debug('j');
3278: msc_sch_wb.atp_debug('Identifier := ' || p_atp_rec.identifier(j));
3279: msc_sch_wb.atp_debug('Mandatory flag := ' || p_atp_rec.mandatory_item_flag(j));
3280: msc_sch_wb.atp_debug('sequence number := ' || p_atp_rec.sequence_number(j));
3281: msc_sch_wb.atp_debug('atp_lead_time := ' || p_atp_rec.atp_lead_time(j));
3282:

Line 3279: msc_sch_wb.atp_debug('Mandatory flag := ' || p_atp_rec.mandatory_item_flag(j));

3275: msc_sch_wb.atp_debug(' insert data for Call from other modules');
3276: FOR j in 1..l_count LOOP
3277: msc_sch_wb.atp_debug('j');
3278: msc_sch_wb.atp_debug('Identifier := ' || p_atp_rec.identifier(j));
3279: msc_sch_wb.atp_debug('Mandatory flag := ' || p_atp_rec.mandatory_item_flag(j));
3280: msc_sch_wb.atp_debug('sequence number := ' || p_atp_rec.sequence_number(j));
3281: msc_sch_wb.atp_debug('atp_lead_time := ' || p_atp_rec.atp_lead_time(j));
3282:
3283: END LOOP;

Line 3280: msc_sch_wb.atp_debug('sequence number := ' || p_atp_rec.sequence_number(j));

3276: FOR j in 1..l_count LOOP
3277: msc_sch_wb.atp_debug('j');
3278: msc_sch_wb.atp_debug('Identifier := ' || p_atp_rec.identifier(j));
3279: msc_sch_wb.atp_debug('Mandatory flag := ' || p_atp_rec.mandatory_item_flag(j));
3280: msc_sch_wb.atp_debug('sequence number := ' || p_atp_rec.sequence_number(j));
3281: msc_sch_wb.atp_debug('atp_lead_time := ' || p_atp_rec.atp_lead_time(j));
3282:
3283: END LOOP;
3284: END IF;

Line 3281: msc_sch_wb.atp_debug('atp_lead_time := ' || p_atp_rec.atp_lead_time(j));

3277: msc_sch_wb.atp_debug('j');
3278: msc_sch_wb.atp_debug('Identifier := ' || p_atp_rec.identifier(j));
3279: msc_sch_wb.atp_debug('Mandatory flag := ' || p_atp_rec.mandatory_item_flag(j));
3280: msc_sch_wb.atp_debug('sequence number := ' || p_atp_rec.sequence_number(j));
3281: msc_sch_wb.atp_debug('atp_lead_time := ' || p_atp_rec.atp_lead_time(j));
3282:
3283: END LOOP;
3284: END IF;
3285:

Line 3396: msc_sch_wb.atp_debug('After Updating the table');

3392: NVL(p_atp_rec.source_organization_id(j), -1);
3393: --and sequence_number = p_atp_rec.sequence_number(j);
3394: --add condition for inv id and seq id
3395: IF PG_DEBUG in ('Y', 'C') THEN
3396: msc_sch_wb.atp_debug('After Updating the table');
3397: msc_sch_wb.atp_debug('Rows Updated := ' || SQL%ROWCOUNT);
3398: END IF;
3399:
3400: IF MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT =1 THEN

Line 3397: msc_sch_wb.atp_debug('Rows Updated := ' || SQL%ROWCOUNT);

3393: --and sequence_number = p_atp_rec.sequence_number(j);
3394: --add condition for inv id and seq id
3395: IF PG_DEBUG in ('Y', 'C') THEN
3396: msc_sch_wb.atp_debug('After Updating the table');
3397: msc_sch_wb.atp_debug('Rows Updated := ' || SQL%ROWCOUNT);
3398: END IF;
3399:
3400: IF MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT =1 THEN
3401: ---included items are present. Insert them into table

Line 3403: msc_sch_wb.atp_debug('Included Items are present');

3399:
3400: IF MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT =1 THEN
3401: ---included items are present. Insert them into table
3402: IF PG_DEBUG in ('Y', 'C') THEN
3403: msc_sch_wb.atp_debug('Included Items are present');
3404: END IF;
3405: --couldn't find a wayt to insert data selectively from
3406: -- pl/sql table to temp table. Therefore, copying the records for the time being.
3407: FOR j in 1..p_atp_rec.inventory_item_id.count LOOP

Line 3410: msc_sch_wb.atp_debug('Add Included item for line := ' || j);

3406: -- pl/sql table to temp table. Therefore, copying the records for the time being.
3407: FOR j in 1..p_atp_rec.inventory_item_id.count LOOP
3408: IF NVL(p_atp_rec.mandatory_item_flag(j), 2) = 1 THEN
3409: IF PG_DEBUG in ('Y', 'C') THEN
3410: msc_sch_wb.atp_debug('Add Included item for line := ' || j);
3411: END IF;
3412: MSC_SATP_FUNC.Assign_Atp_Input_Rec(p_atp_rec,
3413: j,
3414: l_atp_rec,

Line 3420: msc_sch_wb.atp_debug('Number of included items := ' || l_atp_rec.inventory_item_id.count);

3416: END IF;
3417: END LOOP;
3418:
3419: IF PG_DEBUG in ('Y', 'C') THEN
3420: msc_sch_wb.atp_debug('Number of included items := ' || l_atp_rec.inventory_item_id.count);
3421: END IF;
3422: l_count := l_atp_rec.inventory_item_id.count;
3423: FORALL j in 1..l_count
3424: INSERT INTO mrp_atp_schedule_temp

Line 3578: msc_sch_wb.atp_debug('Number of Rows Inserted := ' || SQL%ROWCOUNT);

3574: l_atp_rec.first_valid_ship_arrival_date(j)
3575: );
3576: --where NVL(p_atp_rec.mandatory_item_flag(j), 2) = 1;
3577: IF PG_DEBUG in ('Y', 'C') THEN
3578: msc_sch_wb.atp_debug('Number of Rows Inserted := ' || SQL%ROWCOUNT);
3579: END IF;
3580: END IF; --- IF MSC_ATP_CTO.G_INCLUDED_ITEM_IS_PRESENT =1 THEN
3581:
3582:

Line 3591: msc_sch_wb.atp_debug('Model is present, update model component data');

3587: --For global ATP we get multiple lines with same line_id. as a result update was failing.
3588: IF MSC_ATP_CTO.G_MODEL_IS_PRESENT = 1 and p_atp_rec.action(1) <> 100 THEN
3589:
3590: IF PG_DEBUG in ('Y', 'C') THEN
3591: msc_sch_wb.atp_debug('Model is present, update model component data');
3592: END IF;
3593: --bug 3295956: cascade ship method and delivery lead time from model to components
3594: -- Cascade info from model to components based on cascade_model_info_to_comp attribute. This is for istore.
3595: /* Update mrp_atp_schedule_temp mast_1

Line 3619: msc_sch_wb.atp_debug('Number of Rows updated := ' || SQL%ROWCOUNT);

3615: where mast_1.session_id = p_session_id
3616: and mast_1.ato_model_line_id is not null
3617: and mast_1.order_line_id <> mast_1.ato_model_line_id;
3618: IF PG_DEBUG in ('Y', 'C') THEN
3619: msc_sch_wb.atp_debug('Number of Rows updated := ' || SQL%ROWCOUNT);
3620: END IF;
3621: */
3622:
3623: ---update plan_id on msc_cto_bom and msc_cto_sources for 24x7

Line 3633: msc_sch_wb.atp_debug('Number of Rows updated n msc_cto_bom := ' || SQL%ROWCOUNT);

3629: )
3630: where mcb.session_id = p_session_id;
3631:
3632: IF PG_DEBUG in ('Y', 'C') THEN
3633: msc_sch_wb.atp_debug('Number of Rows updated n msc_cto_bom := ' || SQL%ROWCOUNT);
3634: END IF;
3635:
3636: update msc_cto_sources mcs
3637: set plan_id = (select plan_id

Line 3645: msc_sch_wb.atp_debug('Number of Rows updated in msc_cto_sources := ' || SQL%ROWCOUNT);

3641: )
3642: where mcs.session_id = p_session_id;
3643:
3644: IF PG_DEBUG in ('Y', 'C') THEN
3645: msc_sch_wb.atp_debug('Number of Rows updated in msc_cto_sources := ' || SQL%ROWCOUNT);
3646: END IF;
3647: END IF;
3648:
3649:

Line 3658: msc_sch_wb.atp_debug('exit Put_Sch_data_Result_Mode');

3654: RESULTS_MODE);
3655: END IF;
3656:
3657: IF PG_DEBUG in ('Y', 'C') THEN
3658: msc_sch_wb.atp_debug('exit Put_Sch_data_Result_Mode');
3659: END IF;
3660:
3661: END Put_Sch_Data_Result_Mode;
3662:

Line 3677: msc_sch_wb.atp_debug('enter Transfer_Scheduling_data');

3673: l_source_dblink varchar2(128);
3674: BEGIN
3675:
3676: IF PG_DEBUG in ('Y', 'C') THEN
3677: msc_sch_wb.atp_debug('enter Transfer_Scheduling_data');
3678: END IF;
3679:
3680: IF p_mode = RESULTS_MODE THEN
3681: l_status_flag := 2;

Line 3695: msc_sch_wb.atp_debug('Before deleting old data');

3691: l_dest_dblink := '@' || p_dblink;
3692: END IF;
3693:
3694: IF PG_DEBUG in ('Y', 'C') THEN
3695: msc_sch_wb.atp_debug('Before deleting old data');
3696: END IF;
3697:
3698: /* bug 3378649: delete any data locally
3699: --delete any old data

Line 3709: msc_sch_wb.atp_debug('deleting old data in local table');

3705:
3706: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
3707: ELSE
3708: IF PG_DEBUG in ('Y', 'C') THEN
3709: msc_sch_wb.atp_debug('deleting old data in local table');
3710: END IF;
3711:
3712: DELETE FROM MRP_ATP_SCHEDULE_TEMP
3713: WHERE session_id = p_session_id

Line 3719: msc_sch_wb.atp_debug('Number of rows deleted := ' || SQL%ROWCOUNT);

3715: END IF;
3716: */
3717:
3718: IF PG_DEBUG in ('Y', 'C') THEN
3719: msc_sch_wb.atp_debug('Number of rows deleted := ' || SQL%ROWCOUNT);
3720: msc_sch_wb.atp_debug('After deleting old data');
3721: msc_sch_wb.atp_debug('l_status_flag := ' || l_status_flag);
3722: msc_sch_wb.atp_debug('l_tnsfer_sts_flag := ' || l_tnsfer_sts_flag);
3723: END IF;

Line 3720: msc_sch_wb.atp_debug('After deleting old data');

3716: */
3717:
3718: IF PG_DEBUG in ('Y', 'C') THEN
3719: msc_sch_wb.atp_debug('Number of rows deleted := ' || SQL%ROWCOUNT);
3720: msc_sch_wb.atp_debug('After deleting old data');
3721: msc_sch_wb.atp_debug('l_status_flag := ' || l_status_flag);
3722: msc_sch_wb.atp_debug('l_tnsfer_sts_flag := ' || l_tnsfer_sts_flag);
3723: END IF;
3724:

Line 3721: msc_sch_wb.atp_debug('l_status_flag := ' || l_status_flag);

3717:
3718: IF PG_DEBUG in ('Y', 'C') THEN
3719: msc_sch_wb.atp_debug('Number of rows deleted := ' || SQL%ROWCOUNT);
3720: msc_sch_wb.atp_debug('After deleting old data');
3721: msc_sch_wb.atp_debug('l_status_flag := ' || l_status_flag);
3722: msc_sch_wb.atp_debug('l_tnsfer_sts_flag := ' || l_tnsfer_sts_flag);
3723: END IF;
3724:
3725: l_sql_stmt :=

Line 3722: msc_sch_wb.atp_debug('l_tnsfer_sts_flag := ' || l_tnsfer_sts_flag);

3718: IF PG_DEBUG in ('Y', 'C') THEN
3719: msc_sch_wb.atp_debug('Number of rows deleted := ' || SQL%ROWCOUNT);
3720: msc_sch_wb.atp_debug('After deleting old data');
3721: msc_sch_wb.atp_debug('l_status_flag := ' || l_status_flag);
3722: msc_sch_wb.atp_debug('l_tnsfer_sts_flag := ' || l_tnsfer_sts_flag);
3723: END IF;
3724:
3725: l_sql_stmt :=
3726: 'Insert into mrp_atp_schedule_temp' || L_source_DBLINK ||

Line 3984: msc_sch_wb.atp_debug('Transfer_Scheduling_data: ' || l_sql_stmt);

3980: and status_flag = ' || l_tnsfer_sts_flag ;
3981:
3982:
3983: IF PG_DEBUG in ('Y', 'C') THEN
3984: msc_sch_wb.atp_debug('Transfer_Scheduling_data: ' || l_sql_stmt);
3985: END IF;
3986: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
3987:
3988: IF PG_DEBUG in ('Y', 'C') THEN

Line 3989: msc_sch_wb.atp_debug('Rows Transfered: ' || SQL%ROWCOUNT);

3985: END IF;
3986: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
3987:
3988: IF PG_DEBUG in ('Y', 'C') THEN
3989: msc_sch_wb.atp_debug('Rows Transfered: ' || SQL%ROWCOUNT);
3990: END IF;
3991:
3992:
3993: IF PG_DEBUG in ('Y', 'C') THEN

Line 3994: msc_sch_wb.atp_debug('exit Transfer_Scheduling_data');

3990: END IF;
3991:
3992:
3993: IF PG_DEBUG in ('Y', 'C') THEN
3994: msc_sch_wb.atp_debug('exit Transfer_Scheduling_data');
3995: END IF;
3996: EXCEPTION
3997: WHEN OTHERS THEN
3998: IF PG_DEBUG in ('Y', 'C') THEN

Line 3999: msc_sch_wb.atp_debug('Error Occured while transfering the data accros db link');

3995: END IF;
3996: EXCEPTION
3997: WHEN OTHERS THEN
3998: IF PG_DEBUG in ('Y', 'C') THEN
3999: msc_sch_wb.atp_debug('Error Occured while transfering the data accros db link');
4000: msc_sch_wb.atp_debug('errro := ' ||SQLERRM);
4001: END IF;
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003:

Line 4000: msc_sch_wb.atp_debug('errro := ' ||SQLERRM);

3996: EXCEPTION
3997: WHEN OTHERS THEN
3998: IF PG_DEBUG in ('Y', 'C') THEN
3999: msc_sch_wb.atp_debug('Error Occured while transfering the data accros db link');
4000: msc_sch_wb.atp_debug('errro := ' ||SQLERRM);
4001: END IF;
4002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4003:
4004: END Transfer_Scheduling_data;

Line 4021: msc_sch_wb.atp_debug('Error in function Truncate_Demand: '||sqlerrm);

4017: RETURN l_truncated_demand ;
4018: EXCEPTION
4019: WHEN OTHERS THEN
4020: IF PG_DEBUG in ('Y', 'C') THEN
4021: msc_sch_wb.atp_debug('Error in function Truncate_Demand: '||sqlerrm);
4022: END IF;
4023: END Truncate_Demand;
4024:
4025: