[Home] [Help]
PACKAGE BODY: APPS.IGC_CC_PO_LINE_LOCS_ALL_PVT
Source
1 PACKAGE BODY IGC_CC_PO_LINE_LOCS_ALL_PVT AS
2 /*$Header: IGCCPLLB.pls 120.6 2008/05/28 10:58:34 anusaxen ship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'IGC_CC_PO_LINE_LOCS_ALL_PVT';
5
6 -- The flag determines whether to print debug information or not.
7 g_debug_flag VARCHAR2(1) := 'N' ;
8
9
10 /*=======================================================================+
11 | PROCEDURE Insert_Row |
12 +=======================================================================*/
13
14 PROCEDURE Insert_Row
15 (
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
18 p_commit IN VARCHAR2 := FND_API.G_FALSE,
19 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
20 x_return_status OUT NOCOPY VARCHAR2,
21 x_msg_count OUT NOCOPY NUMBER,
22 x_msg_data OUT NOCOPY VARCHAR2,
23 ---------------------------------------------
24 p_po_line_locs_rec IN po_line_locations_all%ROWTYPE
25 )
26 IS
27
28 l_api_name CONSTANT VARCHAR2(30) := 'Insert_Row';
29 l_api_version CONSTANT NUMBER := 1.0;
30
31 BEGIN
32
33 SAVEPOINT Insert_Row_Pvt ;
34
35 IF NOT FND_API.Compatible_API_Call ( l_api_version,
36 p_api_version,
37 l_api_name,
38 G_PKG_NAME )
39 THEN
40 RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
41 END IF;
42
43
44 IF FND_API.to_Boolean ( p_init_msg_list )
45 THEN
46 FND_MSG_PUB.initialize ;
47 END IF;
48
49 x_return_status := FND_API.G_RET_STS_SUCCESS ;
50
51
52 INSERT INTO po_line_locations_all (
53 line_location_id,
54 last_update_date,
55 last_updated_by,
56 po_header_id,
57 po_line_id,
58 last_update_login,
59 creation_date,
60 created_by,
61 quantity,
62 quantity_received,
63 quantity_accepted,
64 quantity_rejected,
65 quantity_billed,
66 quantity_cancelled,
67 unit_meas_lookup_code,
68 po_release_id,
69 ship_to_location_id,
70 ship_via_lookup_code,
71 need_by_date,
72 promised_date,
73 last_accept_date,
74 price_override,
75 encumbered_flag,
76 encumbered_date,
77 unencumbered_quantity,
78 fob_lookup_code,
79 freight_terms_lookup_code,
80 taxable_flag,
81 tax_name,
82 estimated_tax_amount,
83 from_header_id,
84 from_line_id,
85 from_line_location_id,
86 start_date,
87 end_date,
88 lead_time,
89 lead_time_unit,
90 price_discount,
91 terms_id,
92 approved_flag,
93 approved_date,
94 closed_flag,
95 cancel_flag,
96 cancelled_by,
97 cancel_date,
98 cancel_reason,
99 firm_status_lookup_code,
100 firm_date,
101 attribute_category,
102 attribute1,
103 attribute2,
104 attribute3,
105 attribute4,
106 attribute5,
107 attribute6,
108 attribute7,
109 attribute8,
110 attribute9,
111 attribute10,
112 unit_of_measure_class,
113 encumber_now,
114 attribute11,
115 attribute12,
116 attribute13,
117 attribute14,
118 attribute15,
119 inspection_required_flag,
120 receipt_required_flag,
121 qty_rcv_tolerance,
122 qty_rcv_exception_code,
123 enforce_ship_to_location_code,
124 allow_substitute_receipts_flag,
125 days_early_receipt_allowed,
126 days_late_receipt_allowed,
127 receipt_days_exception_code,
128 invoice_close_tolerance,
129 receive_close_tolerance,
130 ship_to_organization_id,
131 shipment_num,
132 source_shipment_id,
133 shipment_type,
134 closed_code,
135 request_id,
136 program_application_id,
137 program_id,
138 program_update_date,
139 ussgl_transaction_code,
140 government_context,
141 receiving_routing_id,
142 accrue_on_receipt_flag,
143 closed_reason,
144 closed_date,
145 closed_by,
146 org_id,
147 global_attribute1,
148 global_attribute2,
149 global_attribute3,
150 global_attribute4,
151 global_attribute5,
152 global_attribute6,
153 global_attribute7,
154 global_attribute8,
155 global_attribute9,
156 global_attribute10,
157 global_attribute11,
158 global_attribute12,
159 global_attribute13,
160 global_attribute14,
161 global_attribute15,
162 global_attribute16,
163 global_attribute17,
164 global_attribute18,
165 global_attribute19,
166 global_attribute20,
167 global_attribute_category,
168 quantity_shipped,
169 country_of_origin_code,
170 tax_user_override_flag,
171 /*match_flag, */
172 match_option,
173 tax_code_id,
174 calculate_tax_flag,
175 change_promised_date_reason,
176 matching_basis,
177 outsourced_assembly -- Bug 6971366. Added the missing outsource_assembly col
178 )
179 VALUES
180 (
181 p_po_line_locs_rec.line_location_id,
182 p_po_line_locs_rec.last_update_date,
183 p_po_line_locs_rec.last_updated_by,
184 p_po_line_locs_rec.po_header_id,
185 p_po_line_locs_rec.po_line_id,
186 p_po_line_locs_rec.last_update_login,
187 p_po_line_locs_rec.creation_date,
188 p_po_line_locs_rec.created_by,
189 p_po_line_locs_rec.quantity,
190 p_po_line_locs_rec.quantity_received,
191 p_po_line_locs_rec.quantity_accepted,
192 p_po_line_locs_rec.quantity_rejected,
193 p_po_line_locs_rec.quantity_billed ,
194 p_po_line_locs_rec.quantity_cancelled,
195 p_po_line_locs_rec.unit_meas_lookup_code,
196 p_po_line_locs_rec.po_release_id,
197 p_po_line_locs_rec.ship_to_location_id,
198 p_po_line_locs_rec.ship_via_lookup_code,
199 p_po_line_locs_rec.need_by_date,
200 p_po_line_locs_rec.promised_date,
201 p_po_line_locs_rec.last_accept_date,
202 p_po_line_locs_rec.price_override,
203 p_po_line_locs_rec.encumbered_flag,
204 p_po_line_locs_rec.encumbered_date,
205 p_po_line_locs_rec.unencumbered_quantity,
206 p_po_line_locs_rec.fob_lookup_code,
207 p_po_line_locs_rec.freight_terms_lookup_code,
208 p_po_line_locs_rec.taxable_flag,
209 p_po_line_locs_rec.tax_name,
210 p_po_line_locs_rec.estimated_tax_amount,
211 p_po_line_locs_rec.from_header_id,
212 p_po_line_locs_rec.from_line_id,
213 p_po_line_locs_rec.from_line_location_id,
214 p_po_line_locs_rec.start_date,
215 p_po_line_locs_rec.end_date,
216 p_po_line_locs_rec.lead_time,
217 p_po_line_locs_rec.lead_time_unit,
218 p_po_line_locs_rec.price_discount,
219 p_po_line_locs_rec.terms_id,
220 p_po_line_locs_rec.approved_flag,
221 p_po_line_locs_rec.approved_date,
222 p_po_line_locs_rec.closed_flag,
223 p_po_line_locs_rec.cancel_flag,
224 p_po_line_locs_rec.cancelled_by,
225 p_po_line_locs_rec.cancel_date,
226 p_po_line_locs_rec.cancel_reason,
227 p_po_line_locs_rec.firm_status_lookup_code,
228 p_po_line_locs_rec.firm_date,
229 p_po_line_locs_rec.attribute_category,
230 p_po_line_locs_rec.attribute1,
231 p_po_line_locs_rec.attribute2,
232 p_po_line_locs_rec.attribute3,
233 p_po_line_locs_rec.attribute4,
234 p_po_line_locs_rec.attribute5,
235 p_po_line_locs_rec.attribute6,
236 p_po_line_locs_rec.attribute7,
237 p_po_line_locs_rec.attribute8,
238 p_po_line_locs_rec.attribute9,
239 p_po_line_locs_rec.attribute10,
240 p_po_line_locs_rec.unit_of_measure_class,
241 p_po_line_locs_rec.encumber_now,
242 p_po_line_locs_rec.attribute11,
243 p_po_line_locs_rec.attribute12,
244 p_po_line_locs_rec.attribute13,
245 p_po_line_locs_rec.attribute14,
246 p_po_line_locs_rec.attribute15,
247 p_po_line_locs_rec.inspection_required_flag,
248 p_po_line_locs_rec.receipt_required_flag,
249 p_po_line_locs_rec.qty_rcv_tolerance,
250 p_po_line_locs_rec.qty_rcv_exception_code,
251 p_po_line_locs_rec.enforce_ship_to_location_code,
252 p_po_line_locs_rec.allow_substitute_receipts_flag,
253 p_po_line_locs_rec.days_early_receipt_allowed,
254 p_po_line_locs_rec.days_late_receipt_allowed,
255 p_po_line_locs_rec.receipt_days_exception_code,
256 p_po_line_locs_rec.invoice_close_tolerance,
257 p_po_line_locs_rec.receive_close_tolerance,
258 p_po_line_locs_rec.ship_to_organization_id,
259 p_po_line_locs_rec.shipment_num,
260 p_po_line_locs_rec.source_shipment_id,
261 p_po_line_locs_rec.shipment_type,
262 p_po_line_locs_rec.closed_code,
263 p_po_line_locs_rec.request_id,
264 p_po_line_locs_rec.program_application_id,
265 p_po_line_locs_rec.program_id,
266 p_po_line_locs_rec.program_update_date,
267 p_po_line_locs_rec.ussgl_transaction_code,
268 p_po_line_locs_rec.government_context,
269 p_po_line_locs_rec.receiving_routing_id,
270 p_po_line_locs_rec.accrue_on_receipt_flag,
271 p_po_line_locs_rec.closed_reason,
272 p_po_line_locs_rec.closed_date,
273 p_po_line_locs_rec.closed_by,
274 p_po_line_locs_rec.org_id,
275 p_po_line_locs_rec.global_attribute1,
276 p_po_line_locs_rec.global_attribute2,
277 p_po_line_locs_rec.global_attribute3,
278 p_po_line_locs_rec.global_attribute4,
279 p_po_line_locs_rec.global_attribute5,
280 p_po_line_locs_rec.global_attribute6,
281 p_po_line_locs_rec.global_attribute7,
282 p_po_line_locs_rec.global_attribute8,
283 p_po_line_locs_rec.global_attribute9,
284 p_po_line_locs_rec.global_attribute10,
285 p_po_line_locs_rec.global_attribute11,
286 p_po_line_locs_rec.global_attribute12,
287 p_po_line_locs_rec.global_attribute13,
288 p_po_line_locs_rec.global_attribute14,
289 p_po_line_locs_rec.global_attribute15,
290 p_po_line_locs_rec.global_attribute16,
291 p_po_line_locs_rec.global_attribute17,
292 p_po_line_locs_rec.global_attribute18,
293 p_po_line_locs_rec.global_attribute19,
294 p_po_line_locs_rec.global_attribute20,
295 p_po_line_locs_rec.global_attribute_category,
296 p_po_line_locs_rec.quantity_shipped,
297 p_po_line_locs_rec.country_of_origin_code,
298 p_po_line_locs_rec.tax_user_override_flag,
299 /*p_po_line_locs_rec.match_flag, */
300 p_po_line_locs_rec.match_option,
301 p_po_line_locs_rec.tax_code_id,
302 p_po_line_locs_rec.calculate_tax_flag,
303 p_po_line_locs_rec.change_promised_date_reason,
304 p_po_line_locs_rec.matching_basis,
305 p_po_line_locs_rec.outsourced_assembly -- Bug 6971366 . Added the missing outsource assembly col.
306 ) ;
307
308 IF FND_API.To_Boolean ( p_commit )
309 THEN
310 COMMIT WORK;
311 END IF;
312
313 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
314 p_data => x_msg_data );
315
316 EXCEPTION
317
318 WHEN FND_API.G_EXC_ERROR
319 THEN
320
321 ROLLBACK TO Insert_Row_Pvt ;
322 x_return_status := FND_API.G_RET_STS_ERROR;
323 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
324 p_data => x_msg_data );
325
326 WHEN FND_API.G_EXC_UNEXPECTED_ERROR
327 THEN
328 ROLLBACK TO Insert_Row_Pvt ;
329 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
331 p_data => x_msg_data );
332
333 WHEN OTHERS
334 THEN
335 ROLLBACK TO Insert_Row_Pvt ;
336 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337
338 IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
339 THEN
340 FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
341 l_api_name);
342 END IF;
343
344 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
345 p_data => x_msg_data );
346
347 END Insert_Row;
348 /*-------------------------------------------------------------------------*/
349
350
351 /*==========================================================================+
352 | PROCEDURE Update_Row |
353 +==========================================================================*/
354
355 PROCEDURE Update_Row
356 (
357 p_api_version IN NUMBER,
358 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359 p_commit IN VARCHAR2 := FND_API.G_FALSE,
360 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
361 x_return_status OUT NOCOPY VARCHAR2,
362 x_msg_count OUT NOCOPY NUMBER,
363 x_msg_data OUT NOCOPY VARCHAR2,
364 ---------------------------------------------
365 p_po_line_locs_rec IN po_line_locations_all%ROWTYPE
366 )
367 IS
368
369 l_api_name CONSTANT VARCHAR2(30) := 'Update_Row';
370 l_api_version CONSTANT NUMBER := 1.0;
371
372 BEGIN
373
374 SAVEPOINT Update_Row_Pvt ;
375
376 IF NOT FND_API.Compatible_API_Call ( l_api_version,
377 p_api_version,
378 l_api_name,
379 G_PKG_NAME )
380 THEN
381 RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
382 END IF;
383
384
385 IF FND_API.to_Boolean ( p_init_msg_list )
386 THEN
387 FND_MSG_PUB.initialize ;
388 END IF;
389
390 x_return_status := FND_API.G_RET_STS_SUCCESS ;
391
392 /* update */
393 UPDATE po_line_locations_all
394 SET
395 line_location_id = p_po_line_locs_rec.line_location_id ,
396 last_update_date = p_po_line_locs_rec.last_update_date,
397 last_updated_by = p_po_line_locs_rec.last_updated_by ,
398 po_header_id = p_po_line_locs_rec.po_header_id ,
399 po_line_id = p_po_line_locs_rec.po_line_id,
400 last_update_login = p_po_line_locs_rec.last_update_login ,
401 creation_date = p_po_line_locs_rec.creation_date,
402 created_by = p_po_line_locs_rec.created_by,
403 quantity = p_po_line_locs_rec.quantity,
404 quantity_received = p_po_line_locs_rec.quantity_received,
405 quantity_accepted = p_po_line_locs_rec.quantity_accepted,
406 quantity_rejected = p_po_line_locs_rec.quantity_rejected,
407 quantity_billed = p_po_line_locs_rec.quantity_billed ,
408 quantity_cancelled = p_po_line_locs_rec.quantity_cancelled,
409 unit_meas_lookup_code = p_po_line_locs_rec.unit_meas_lookup_code,
410 po_release_id = p_po_line_locs_rec.po_release_id,
411 ship_to_location_id = p_po_line_locs_rec.ship_to_location_id,
412 ship_via_lookup_code = p_po_line_locs_rec.ship_via_lookup_code,
413 need_by_date = p_po_line_locs_rec.need_by_date,
414 promised_date = p_po_line_locs_rec.promised_date,
415 last_accept_date = p_po_line_locs_rec.last_accept_date,
416 price_override = p_po_line_locs_rec.price_override ,
417 encumbered_flag = p_po_line_locs_rec.encumbered_flag ,
418 encumbered_date = p_po_line_locs_rec.encumbered_date,
419 unencumbered_quantity = p_po_line_locs_rec.unencumbered_quantity,
420 fob_lookup_code = p_po_line_locs_rec.fob_lookup_code,
421 freight_terms_lookup_code = p_po_line_locs_rec.freight_terms_lookup_code,
422 taxable_flag = p_po_line_locs_rec.taxable_flag,
423 tax_name = p_po_line_locs_rec.tax_name ,
424 estimated_tax_amount = p_po_line_locs_rec.estimated_tax_amount ,
425 from_header_id = p_po_line_locs_rec.from_header_id ,
426 from_line_id = p_po_line_locs_rec.from_line_id ,
427 from_line_location_id = p_po_line_locs_rec.from_line_location_id ,
428 start_date = p_po_line_locs_rec.start_date,
429 end_date = p_po_line_locs_rec.end_date,
430 lead_time = p_po_line_locs_rec.lead_time,
431 lead_time_unit = p_po_line_locs_rec.lead_time_unit,
432 price_discount = p_po_line_locs_rec.price_discount,
433 terms_id = p_po_line_locs_rec.terms_id ,
434 approved_flag = p_po_line_locs_rec.approved_flag,
435 approved_date = p_po_line_locs_rec.approved_date,
436 closed_flag = p_po_line_locs_rec.closed_flag,
437 cancel_flag = p_po_line_locs_rec.cancel_flag ,
438 cancelled_by = p_po_line_locs_rec.cancelled_by ,
439 cancel_date = p_po_line_locs_rec.cancel_date,
440 cancel_reason = p_po_line_locs_rec.cancel_reason ,
441 firm_status_lookup_code = p_po_line_locs_rec.firm_status_lookup_code,
442 firm_date = p_po_line_locs_rec.firm_date ,
443 attribute_category = p_po_line_locs_rec.attribute_category,
444 attribute1 = p_po_line_locs_rec.attribute1 ,
445 attribute2 = p_po_line_locs_rec.attribute2 ,
446 attribute3 = p_po_line_locs_rec.attribute3 ,
447 attribute4 = p_po_line_locs_rec.attribute4 ,
448 attribute5 = p_po_line_locs_rec.attribute5 ,
449 attribute6 = p_po_line_locs_rec.attribute6 ,
450 attribute7 = p_po_line_locs_rec.attribute7 ,
451 attribute8 = p_po_line_locs_rec.attribute8 ,
452 attribute9 = p_po_line_locs_rec.attribute9 ,
453 attribute10 = p_po_line_locs_rec.attribute10,
454 unit_of_measure_class = p_po_line_locs_rec.unit_of_measure_class,
455 encumber_now = p_po_line_locs_rec.encumber_now ,
456 attribute11 = p_po_line_locs_rec.attribute11 ,
457 attribute12 = p_po_line_locs_rec.attribute12 ,
458 attribute13 = p_po_line_locs_rec.attribute13 ,
459 attribute14 = p_po_line_locs_rec.attribute14 ,
460 attribute15 = p_po_line_locs_rec.attribute15 ,
461 inspection_required_flag = p_po_line_locs_rec.inspection_required_flag ,
462 receipt_required_flag = p_po_line_locs_rec.receipt_required_flag,
463 qty_rcv_tolerance = p_po_line_locs_rec.qty_rcv_tolerance,
464 qty_rcv_exception_code = p_po_line_locs_rec.qty_rcv_exception_code ,
465 enforce_ship_to_location_code = p_po_line_locs_rec.enforce_ship_to_location_code ,
466 allow_substitute_receipts_flag = p_po_line_locs_rec.allow_substitute_receipts_flag,
467 days_early_receipt_allowed = p_po_line_locs_rec.days_early_receipt_allowed ,
468 days_late_receipt_allowed = p_po_line_locs_rec.days_late_receipt_allowed ,
469 receipt_days_exception_code = p_po_line_locs_rec.receipt_days_exception_code ,
470 invoice_close_tolerance = p_po_line_locs_rec.invoice_close_tolerance ,
471 receive_close_tolerance = p_po_line_locs_rec.receive_close_tolerance,
472 ship_to_organization_id = p_po_line_locs_rec.ship_to_organization_id ,
473 shipment_num = p_po_line_locs_rec.shipment_num ,
474 source_shipment_id = p_po_line_locs_rec.source_shipment_id ,
475 shipment_type = p_po_line_locs_rec.shipment_type ,
476 closed_code = p_po_line_locs_rec.closed_code ,
477 request_id = p_po_line_locs_rec.request_id ,
478 program_application_id = p_po_line_locs_rec.program_application_id,
479 program_id = p_po_line_locs_rec.program_id ,
480 program_update_date = p_po_line_locs_rec.program_update_date ,
481 ussgl_transaction_code = p_po_line_locs_rec.ussgl_transaction_code ,
482 government_context = p_po_line_locs_rec.government_context ,
483 receiving_routing_id = p_po_line_locs_rec.receiving_routing_id ,
484 accrue_on_receipt_flag = p_po_line_locs_rec.accrue_on_receipt_flag ,
485 closed_reason = p_po_line_locs_rec.closed_reason ,
486 closed_date = p_po_line_locs_rec.closed_date,
487 closed_by = p_po_line_locs_rec.closed_by ,
488 org_id = p_po_line_locs_rec.org_id ,
489 global_attribute1 = p_po_line_locs_rec.global_attribute1 ,
490 global_attribute2 = p_po_line_locs_rec.global_attribute2 ,
491 global_attribute3 = p_po_line_locs_rec.global_attribute3 ,
492 global_attribute4 = p_po_line_locs_rec.global_attribute4 ,
493 global_attribute5 = p_po_line_locs_rec.global_attribute5 ,
494 global_attribute6 = p_po_line_locs_rec.global_attribute6 ,
495 global_attribute7 = p_po_line_locs_rec.global_attribute7 ,
496 global_attribute8 = p_po_line_locs_rec.global_attribute8 ,
497 global_attribute9 = p_po_line_locs_rec.global_attribute9 ,
498 global_attribute10 = p_po_line_locs_rec.global_attribute10 ,
499 global_attribute11 = p_po_line_locs_rec.global_attribute11 ,
500 global_attribute12 = p_po_line_locs_rec.global_attribute12 ,
501 global_attribute13 = p_po_line_locs_rec.global_attribute13 ,
502 global_attribute14 = p_po_line_locs_rec.global_attribute14 ,
503 global_attribute15 = p_po_line_locs_rec.global_attribute15 ,
504 global_attribute16 = p_po_line_locs_rec.global_attribute16 ,
505 global_attribute17 = p_po_line_locs_rec.global_attribute17 ,
506 global_attribute18 = p_po_line_locs_rec.global_attribute18 ,
507 global_attribute19 = p_po_line_locs_rec.global_attribute19 ,
508 global_attribute20 = p_po_line_locs_rec.global_attribute20 ,
509 global_attribute_category = p_po_line_locs_rec.global_attribute_category ,
510 quantity_shipped = p_po_line_locs_rec.quantity_shipped ,
511 country_of_origin_code = p_po_line_locs_rec.country_of_origin_code ,
512 tax_user_override_flag = p_po_line_locs_rec.tax_user_override_flag ,
513 /*match_flag = p_po_line_locs_rec.match_flag , */
514 match_option = p_po_line_locs_rec.match_option ,
515 tax_code_id = p_po_line_locs_rec.tax_code_id ,
516 calculate_tax_flag = p_po_line_locs_rec.calculate_tax_flag ,
517 change_promised_date_reason = p_po_line_locs_rec.change_promised_date_reason,
518 --Bug 7110860 added the coloumn as it is not null
519 outsourced_assembly = p_po_line_locs_rec.outsourced_assembly
520 WHERE
521 line_location_id = p_po_line_locs_rec.line_location_id;
522
523
524 IF (SQL%NOTFOUND)
525 THEN
526 RAISE NO_DATA_FOUND ;
527 END IF;
528
529
530 IF FND_API.To_Boolean ( p_commit )
531 THEN
532 COMMIT WORK;
533 END IF;
534
535 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
536 p_data => x_msg_data );
537
538 EXCEPTION
539
540 WHEN FND_API.G_EXC_ERROR
541 THEN
542 ROLLBACK TO Update_Row_Pvt ;
543 x_return_status := FND_API.G_RET_STS_ERROR;
544
545 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
546 p_data => x_msg_data );
547
548 WHEN FND_API.G_EXC_UNEXPECTED_ERROR
549 THEN
550
551 ROLLBACK TO Update_Row_Pvt ;
552 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
554 p_data => x_msg_data );
555
556 WHEN OTHERS
557 THEN
558
559 ROLLBACK TO Update_Row_Pvt ;
560 x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
561
562 IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
563 THEN
564 FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
565 l_api_name);
566 END IF;
567
568 FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
569 p_data => x_msg_data );
570
571 END Update_Row;
572 /* ----------------------------------------------------------------------- */
573
574 END IGC_CC_PO_LINE_LOCS_ALL_PVT;