DBA Data[Home] [Help]

APPS.MRP_ATP_PUB dependencies on MSC_SCH_WB

Line 62: msc_sch_wb.atp_debug('Call_ATP: ' || 'this is NOT an atp request');

58: -- scheduling request was successful or
59: -- the item is not ATPable.
60:
61: IF PG_DEBUG in ('Y', 'C') THEN
62: msc_sch_wb.atp_debug('Call_ATP: ' || 'this is NOT an atp request');
63: END IF;
64: IF (NVL(x_atp_rec.Calling_module(i), -1) = 660) THEN
65: counter1 := 0;
66: FOR j IN 1..x_atp_rec.Action.LAST LOOP

Line 80: msc_sch_wb.atp_debug('Call_ATP: ' || 'Counter1 : ' || to_char(counter1));

76:
77: END IF;
78: END LOOP;
79: IF PG_DEBUG in ('Y', 'C') THEN
80: msc_sch_wb.atp_debug('Call_ATP: ' || 'Counter1 : ' || to_char(counter1));
81: END IF;
82: IF (counter1 > 0) THEN
83: MRP_OM_API_PK.MRP_OM_Interface (p_line_arr, x_return_status1);
84: IF PG_DEBUG in ('Y', 'C') THEN

Line 85: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return status from MRP_OM_Interface: '

81: END IF;
82: IF (counter1 > 0) THEN
83: MRP_OM_API_PK.MRP_OM_Interface (p_line_arr, x_return_status1);
84: IF PG_DEBUG in ('Y', 'C') THEN
85: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return status from MRP_OM_Interface: '
86: || x_return_status1);
87: END IF;
88: END IF;
89: END IF;

Line 99: msc_sch_wb.atp_debug('Call_ATP: Invalid Objects found');

95: -- Error Handling changes.
96: WHEN MSC_ATP_PUB.ATP_INVALID_OBJECTS_FOUND THEN
97: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
98: IF PG_DEBUG in ('Y', 'C') THEN
99: msc_sch_wb.atp_debug('Call_ATP: Invalid Objects found');
100: END IF;
101:
102: IF (x_atp_rec.Inventory_item_id.COUNT = 0) THEN
103: x_atp_rec := p_atp_rec;

Line 114: msc_sch_wb.atp_debug('something wrong in Call_ATP');

110:
111: WHEN others THEN
112: -- something wrong so we want to rollback;
113: IF PG_DEBUG in ('Y', 'C') THEN
114: msc_sch_wb.atp_debug('something wrong in Call_ATP');
115: END IF;
116: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
117: IF PG_DEBUG in ('Y', 'C') THEN
118: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status in excpetion : '||x_return_status);

Line 118: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status in excpetion : '||x_return_status);

114: msc_sch_wb.atp_debug('something wrong in Call_ATP');
115: END IF;
116: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
117: IF PG_DEBUG in ('Y', 'C') THEN
118: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return Status in excpetion : '||x_return_status);
119: END IF;
120: -- Bug 2072612 : krajan : 04/03/02
121: -- Commented rollback call.
122: -- ROLLBACK;

Line 175: msc_sch_wb.atp_debug('Call_ATP: ' || 'this is NOT an atp request');

171: -- scheduling request was successful or
172: -- the item is not ATPable.
173:
174: IF PG_DEBUG in ('Y', 'C') THEN
175: msc_sch_wb.atp_debug('Call_ATP: ' || 'this is NOT an atp request');
176: END IF;
177: IF (NVL(x_atp_rec.Calling_module(i), -99) = -1 ) THEN
178: counter1 := 0;
179: FOR j IN 1..x_atp_rec.Action.LAST LOOP

Line 193: msc_sch_wb.atp_debug('Call_ATP: ' || 'Counter1 : ' || to_char(counter1));

189:
190: END IF;
191: END LOOP;
192: IF PG_DEBUG in ('Y', 'C') THEN
193: msc_sch_wb.atp_debug('Call_ATP: ' || 'Counter1 : ' || to_char(counter1));
194: END IF;
195: IF (counter1 > 0) THEN
196: MRP_OM_API_PK.MRP_OM_Interface (p_line_arr, x_return_status1);
197: IF PG_DEBUG in ('Y', 'C') THEN

Line 198: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return status from MRP_OM_Interface: '

194: END IF;
195: IF (counter1 > 0) THEN
196: MRP_OM_API_PK.MRP_OM_Interface (p_line_arr, x_return_status1);
197: IF PG_DEBUG in ('Y', 'C') THEN
198: msc_sch_wb.atp_debug('Call_ATP: ' || 'Return status from MRP_OM_Interface: '
199: || x_return_status1);
200: END IF;
201: END IF;
202: END IF;

Line 211: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);

207: EXCEPTION
208: WHEN others THEN
209: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
210: IF PG_DEBUG in ('Y', 'C') THEN
211: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
212: msc_sch_wb.atp_debug('Call_ATP: ' || sqlerrm);
213: msc_sch_wb.atp_debug('Call_ATP: ' || 'shipset count ' ||p_atp_rec.error_code.count);
214: msc_sch_wb.atp_debug('Call_ATP: ' || 'Exception x_return_status : '||x_return_status);
215: END IF;

Line 212: msc_sch_wb.atp_debug('Call_ATP: ' || sqlerrm);

208: WHEN others THEN
209: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
210: IF PG_DEBUG in ('Y', 'C') THEN
211: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
212: msc_sch_wb.atp_debug('Call_ATP: ' || sqlerrm);
213: msc_sch_wb.atp_debug('Call_ATP: ' || 'shipset count ' ||p_atp_rec.error_code.count);
214: msc_sch_wb.atp_debug('Call_ATP: ' || 'Exception x_return_status : '||x_return_status);
215: END IF;
216: -- Bug 2072612 : krajan : 04/03/02

Line 213: msc_sch_wb.atp_debug('Call_ATP: ' || 'shipset count ' ||p_atp_rec.error_code.count);

209: x_return_status := NVL(x_return_status, FND_API.G_RET_STS_ERROR);
210: IF PG_DEBUG in ('Y', 'C') THEN
211: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
212: msc_sch_wb.atp_debug('Call_ATP: ' || sqlerrm);
213: msc_sch_wb.atp_debug('Call_ATP: ' || 'shipset count ' ||p_atp_rec.error_code.count);
214: msc_sch_wb.atp_debug('Call_ATP: ' || 'Exception x_return_status : '||x_return_status);
215: END IF;
216: -- Bug 2072612 : krajan : 04/03/02
217: -- Commented rollback call.

Line 214: msc_sch_wb.atp_debug('Call_ATP: ' || 'Exception x_return_status : '||x_return_status);

210: IF PG_DEBUG in ('Y', 'C') THEN
211: msc_sch_wb.atp_debug('Error in Call_ATP_No_Commit :'||sqlcode);
212: msc_sch_wb.atp_debug('Call_ATP: ' || sqlerrm);
213: msc_sch_wb.atp_debug('Call_ATP: ' || 'shipset count ' ||p_atp_rec.error_code.count);
214: msc_sch_wb.atp_debug('Call_ATP: ' || 'Exception x_return_status : '||x_return_status);
215: END IF;
216: -- Bug 2072612 : krajan : 04/03/02
217: -- Commented rollback call.
218: -- ROLLBACK;