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_EXCEPTIONS dependencies on MSC_SCH_WB

Line 64: msc_sch_wb.atp_debug ('Get_Plan_Constraints: Exception encountered');

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

Line 84: msc_sch_wb.atp_debug (' Begin Add_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);

Line 85: msc_sch_wb.atp_debug ('Input Record Dump: ');

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);

Line 86: msc_sch_wb.atp_debug (' Exception_Type ' || p_exception_rec.exception_type);

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

Line 87: msc_sch_wb.atp_debug (' Exception_Grp ' || p_exception_rec.exception_group);

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);

Line 88: msc_sch_wb.atp_debug (' Plan ID ' || p_exception_rec.plan_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);

Line 89: msc_sch_wb.atp_debug (' Organization ID ' || p_exception_rec.organization_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);

Line 90: msc_sch_wb.atp_debug (' Inventory Item ID ' || p_exception_rec.inventory_item_id); --4235545

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);

Line 91: msc_sch_wb.atp_debug (' Sr Instance ID ' || p_exception_rec.sr_instance_ID);

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);

Line 92: msc_sch_wb.atp_debug (' Demand ID ' || p_exception_rec.demand_id);

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);

Line 93: msc_sch_wb.atp_debug (' Quantity ' || p_exception_rec.quantity);

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);

Line 94: msc_sch_wb.atp_debug (' Qty. Satisfied ' || p_exception_rec.quantity_satisfied);

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

Line 95: msc_sch_wb.atp_debug (' Dmd Satisfy Dt ' || p_exception_rec.demand_satisfy_date);

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 ('----------------------------------------------- ');

Line 96: msc_sch_wb.atp_debug (' Order Number ' || p_exception_rec.order_number);

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;

Line 97: msc_sch_wb.atp_debug (' Customer ID ' || p_exception_rec.customer_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;
101:

Line 98: msc_sch_wb.atp_debug (' Cusustomer Site ID ' || p_exception_rec.customer_site_id); --4235545

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

Line 99: msc_sch_wb.atp_debug ('----------------------------------------------- ');

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;

Line 110: msc_sch_wb.atp_debug ('AEX: Only supported exceptions are :');

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;

Line 111: msc_sch_wb.atp_debug ('AEX: Group = 5');

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;

Line 112: msc_sch_wb.atp_debug ('AEX: Type = 68');

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;

Line 129: msc_sch_wb.atp_debug ('Plan type as determined is : '|| l_plan_type);

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:

Line 130: msc_sch_wb.atp_debug ('Exception type after check is : '|| p_exception_rec.exception_type);

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

Line 177: msc_sch_wb.atp_debug ('AEX: Unable to add exception details record');

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;

Line 178: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);

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;

Line 179: msc_sch_wb.atp_debug ('Code : ' || sqlcode);

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;

Line 186: msc_sch_wb.atp_debug ('AEX: Inserted details record. Now updating item record');

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

Line 203: msc_sch_wb.atp_debug ('AEX: No record found in item exception table');

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

Line 208: msc_sch_wb.atp_debug ('AEX: Multiple records 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
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

Line 213: msc_sch_wb.atp_debug ('AEX: Unable to add item exception record');

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;

Line 214: msc_sch_wb.atp_debug ('Code : ' || sqlcode);

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;

Line 215: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);

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;

Line 251: msc_sch_wb.atp_debug ('AEX: Inserted item exception record');

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

Line 256: msc_sch_wb.atp_debug('Add_Exception: Error while inserting new exception type');

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;

Line 257: msc_sch_wb.atp_debug('Error is: ' || sqlerrm);

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;

Line 258: msc_sch_wb.atp_debug ('Code : ' || sqlcode);

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;

Line 269: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_ERROR');

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:

Line 270: msc_sch_wb.atp_debug ('Code : ' || sqlcode);

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

Line 271: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);

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

Line 276: msc_sch_wb.atp_debug ('Add_Exception: G_EXC_UNEXPECTED_ERROR');

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:

Line 277: msc_sch_wb.atp_debug ('Code : ' || sqlcode);

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

Line 278: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);

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

Line 283: msc_sch_wb.atp_debug ('Add_Exception: OTHERS');

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:

Line 284: msc_sch_wb.atp_debug ('Code : ' || sqlcode);

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;

Line 285: msc_sch_wb.atp_debug ('Error is: ' || sqlerrm);

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: