60: EXCEPTION
61: WHEN OTHERS THEN
62: x_plan_type := 0;
63: if (PG_DEBUG in ('Y','C')) then
64: msc_sch_wb.atp_debug ('Get_Plan_Constraints: Exception encountered');
65: end if;
66: END Get_Plan_Constraints;
67:
68: -- Add a new ATP Exception
80: BEGIN
81:
82: -- Debug Output
83: if (PG_DEBUG in ('Y', 'C')) then
84: msc_sch_wb.atp_debug ('********** Begin Add_ATP_Exception **********');
85: msc_sch_wb.atp_debug ('Input Record Dump: ');
86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
81:
82: -- Debug Output
83: if (PG_DEBUG in ('Y', 'C')) then
84: msc_sch_wb.atp_debug ('********** Begin Add_ATP_Exception **********');
85: msc_sch_wb.atp_debug ('Input Record Dump: ');
86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
82: -- Debug Output
83: if (PG_DEBUG in ('Y', 'C')) then
84: msc_sch_wb.atp_debug ('********** Begin Add_ATP_Exception **********');
85: msc_sch_wb.atp_debug ('Input Record Dump: ');
86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
83: if (PG_DEBUG in ('Y', 'C')) then
84: msc_sch_wb.atp_debug ('********** Begin Add_ATP_Exception **********');
85: msc_sch_wb.atp_debug ('Input Record Dump: ');
86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
84: msc_sch_wb.atp_debug ('********** Begin Add_ATP_Exception **********');
85: msc_sch_wb.atp_debug ('Input Record Dump: ');
86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
85: msc_sch_wb.atp_debug ('Input Record Dump: ');
86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_id);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_id);
90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_id);
98: msc_sch_wb.atp_debug (' Cusustomer Site ID ' || p_exception_rec.customer_site_id); --4235545
91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_id);
98: msc_sch_wb.atp_debug (' Cusustomer Site ID ' || p_exception_rec.customer_site_id); --4235545
99: msc_sch_wb.atp_debug ('----------------------------------------------- ');
92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_id);
98: msc_sch_wb.atp_debug (' Cusustomer Site ID ' || p_exception_rec.customer_site_id); --4235545
99: msc_sch_wb.atp_debug ('----------------------------------------------- ');
100: end if;
93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_id);
98: msc_sch_wb.atp_debug (' Cusustomer Site ID ' || p_exception_rec.customer_site_id); --4235545
99: msc_sch_wb.atp_debug ('----------------------------------------------- ');
100: end if;
101:
94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_id);
98: msc_sch_wb.atp_debug (' Cusustomer Site ID ' || p_exception_rec.customer_site_id); --4235545
99: msc_sch_wb.atp_debug ('----------------------------------------------- ');
100: end if;
101:
102: -- Initialize variables
95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);
96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);
97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_id);
98: msc_sch_wb.atp_debug (' Cusustomer Site ID ' || p_exception_rec.customer_site_id); --4235545
99: msc_sch_wb.atp_debug ('----------------------------------------------- ');
100: end if;
101:
102: -- Initialize variables
103: x_return_status := FND_API.G_RET_STS_SUCCESS;
106: if (p_exception_rec.exception_group <> 5) OR -- Late Sales order
107: -- bug 2795053-reopen (ssurendr): Exception type check changed.
108: (p_exception_rec.exception_type <> 68 ) THEN -- Overcommitment of Sales Order
109: if (PG_DEBUG in ('Y', 'C')) then
110: msc_sch_wb.atp_debug ('AEX: Only supported exceptions are :');
111: msc_sch_wb.atp_debug ('AEX: Group = 5');
112: msc_sch_wb.atp_debug ('AEX: Type = 68');
113: end if;
114: x_return_status := FND_API.G_RET_STS_ERROR;
107: -- bug 2795053-reopen (ssurendr): Exception type check changed.
108: (p_exception_rec.exception_type <> 68 ) THEN -- Overcommitment of Sales Order
109: if (PG_DEBUG in ('Y', 'C')) then
110: msc_sch_wb.atp_debug ('AEX: Only supported exceptions are :');
111: msc_sch_wb.atp_debug ('AEX: Group = 5');
112: msc_sch_wb.atp_debug ('AEX: Type = 68');
113: end if;
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: RAISE FND_API.G_EXC_ERROR;
108: (p_exception_rec.exception_type <> 68 ) THEN -- Overcommitment of Sales Order
109: if (PG_DEBUG in ('Y', 'C')) then
110: msc_sch_wb.atp_debug ('AEX: Only supported exceptions are :');
111: msc_sch_wb.atp_debug ('AEX: Group = 5');
112: msc_sch_wb.atp_debug ('AEX: Type = 68');
113: end if;
114: x_return_status := FND_API.G_RET_STS_ERROR;
115: RAISE FND_API.G_EXC_ERROR;
116: end if;
125: else
126: p_exception_rec.exception_type := 15; -- Unconstrained, use late supply
127: end if;
128: if (PG_DEBUG in ('Y', 'C')) then
129: msc_sch_wb.atp_debug ('Plan type as determined is : '|| l_plan_type);
130: msc_sch_wb.atp_debug ('Exception type after check is : '|| p_exception_rec.exception_type);
131: end if;
132: */
133:
126: p_exception_rec.exception_type := 15; -- Unconstrained, use late supply
127: end if;
128: if (PG_DEBUG in ('Y', 'C')) then
129: msc_sch_wb.atp_debug ('Plan type as determined is : '|| l_plan_type);
130: msc_sch_wb.atp_debug ('Exception type after check is : '|| p_exception_rec.exception_type);
131: end if;
132: */
133:
134: -- First Insert Data into Exception Details
173: );
174: EXCEPTION
175: WHEN OTHERS THEN
176: if (PG_DEBUG in ('Y','C')) then
177: msc_sch_wb.atp_debug ('AEX: Unable to add exception details record');
178: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
179: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
180: end if;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
174: EXCEPTION
175: WHEN OTHERS THEN
176: if (PG_DEBUG in ('Y','C')) then
177: msc_sch_wb.atp_debug ('AEX: Unable to add exception details record');
178: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
179: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
180: end if;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: WHEN OTHERS THEN
176: if (PG_DEBUG in ('Y','C')) then
177: msc_sch_wb.atp_debug ('AEX: Unable to add exception details record');
178: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
179: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
180: end if;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END;
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: END;
184:
185: if (PG_DEBUG in ('Y','C')) then
186: msc_sch_wb.atp_debug ('AEX: Inserted details record. Now updating item record');
187: end if;
188:
189: -- Next try an dupdate the exception count
190: BEGIN
199:
200: EXCEPTION
201: WHEN NO_DATA_FOUND THEN
202: if (PG_DEBUG in ('Y','C')) then
203: msc_sch_wb.atp_debug ('AEX: No record found in item exception table');
204: end if;
205: l_insert_item_exception := 1;
206: WHEN TOO_MANY_ROWS THEN
207: if (PG_DEBUG in ('Y','C')) then
204: end if;
205: l_insert_item_exception := 1;
206: WHEN TOO_MANY_ROWS THEN
207: if (PG_DEBUG in ('Y','C')) then
208: msc_sch_wb.atp_debug ('AEX: Multiple records found in item exception table');
209: end if;
210: l_insert_item_exception := 0;
211: WHEN OTHERS THEN
212: if (PG_DEBUG in ('Y','C')) then
209: end if;
210: l_insert_item_exception := 0;
211: WHEN OTHERS THEN
212: if (PG_DEBUG in ('Y','C')) then
213: msc_sch_wb.atp_debug ('AEX: Unable to add item exception record');
214: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
215: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
216: end if;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: l_insert_item_exception := 0;
211: WHEN OTHERS THEN
212: if (PG_DEBUG in ('Y','C')) then
213: msc_sch_wb.atp_debug ('AEX: Unable to add item exception record');
214: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
215: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
216: end if;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: WHEN OTHERS THEN
212: if (PG_DEBUG in ('Y','C')) then
213: msc_sch_wb.atp_debug ('AEX: Unable to add item exception record');
214: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
215: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
216: end if;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: END;
247: sysdate,
248: FND_GLOBAL.USER_ID
249: );
250: if (PG_DEBUG in ('Y','C')) then
251: msc_sch_wb.atp_debug ('AEX: Inserted item exception record');
252: end if;
253: EXCEPTION
254: WHEN OTHERS THEN
255: if (PG_DEBUG in ('Y','C')) then
252: end if;
253: EXCEPTION
254: WHEN OTHERS THEN
255: if (PG_DEBUG in ('Y','C')) then
256: msc_sch_wb.atp_debug('Add_Exception: Error while inserting new exception type');
257: msc_sch_wb.atp_debug('Error is: ' || sqlerrm);
258: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
259: end if;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: EXCEPTION
254: WHEN OTHERS THEN
255: if (PG_DEBUG in ('Y','C')) then
256: msc_sch_wb.atp_debug('Add_Exception: Error while inserting new exception type');
257: msc_sch_wb.atp_debug('Error is: ' || sqlerrm);
258: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
259: end if;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: WHEN OTHERS THEN
255: if (PG_DEBUG in ('Y','C')) then
256: msc_sch_wb.atp_debug('Add_Exception: Error while inserting new exception type');
257: msc_sch_wb.atp_debug('Error is: ' || sqlerrm);
258: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
259: end if;
260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END;
265: EXCEPTION
266:
267: WHEN FND_API.G_EXC_ERROR THEN
268: if (PG_DEBUG in ('Y','C')) then
269: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_ERROR');
270: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
271: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
272: end if;
273:
266:
267: WHEN FND_API.G_EXC_ERROR THEN
268: if (PG_DEBUG in ('Y','C')) then
269: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_ERROR');
270: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
271: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
272: end if;
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: WHEN FND_API.G_EXC_ERROR THEN
268: if (PG_DEBUG in ('Y','C')) then
269: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_ERROR');
270: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
271: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
272: end if;
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: if (PG_DEBUG in ('Y','C')) then
272: end if;
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: if (PG_DEBUG in ('Y','C')) then
276: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_UNEXPECTED_ERROR');
277: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
278: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
279: end if;
280:
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: if (PG_DEBUG in ('Y','C')) then
276: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_UNEXPECTED_ERROR');
277: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
278: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
279: end if;
280:
281: WHEN OTHERS THEN
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: if (PG_DEBUG in ('Y','C')) then
276: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_UNEXPECTED_ERROR');
277: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
278: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
279: end if;
280:
281: WHEN OTHERS THEN
282: if (PG_DEBUG in ('Y','C')) then
279: end if;
280:
281: WHEN OTHERS THEN
282: if (PG_DEBUG in ('Y','C')) then
283: msc_sch_wb.atp_debug ('Add_Exception: OTHERS');
284: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
285: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
286: end if;
287:
280:
281: WHEN OTHERS THEN
282: if (PG_DEBUG in ('Y','C')) then
283: msc_sch_wb.atp_debug ('Add_Exception: OTHERS');
284: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
285: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
286: end if;
287:
288: END Add_ATP_Exception;
281: WHEN OTHERS THEN
282: if (PG_DEBUG in ('Y','C')) then
283: msc_sch_wb.atp_debug ('Add_Exception: OTHERS');
284: msc_sch_wb.atp_debug ('Code : ' || sqlcode);
285: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);
286: end if;
287:
288: END Add_ATP_Exception;
289: