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.OZF_CHARGEBACK_PVT dependencies on FND_API

Line 34: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

30: --
31: ---------------------------------------------------------------------
32: PROCEDURE Initiate_Payment (
33: p_api_version IN NUMBER
34: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
35: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_resale_batch_id IN NUMBER
38: ,x_return_status OUT NOCOPY VARCHAR2

Line 35: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

31: ---------------------------------------------------------------------
32: PROCEDURE Initiate_Payment (
33: p_api_version IN NUMBER
34: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
35: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_resale_batch_id IN NUMBER
38: ,x_return_status OUT NOCOPY VARCHAR2
39: ,x_msg_data OUT NOCOPY VARCHAR2

Line 36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

32: PROCEDURE Initiate_Payment (
33: p_api_version IN NUMBER
34: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
35: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
36: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
37: ,p_resale_batch_id IN NUMBER
38: ,x_return_status OUT NOCOPY VARCHAR2
39: ,x_msg_data OUT NOCOPY VARCHAR2
40: ,x_msg_count OUT NOCOPY NUMBER

Line 222: IF NOT FND_API.Compatible_API_Call (

218: BEGIN
219: -- Standard begin of API savepoint
220: SAVEPOINT Initiate_Payment;
221: -- Standard call to check FOR call compatibility.
222: IF NOT FND_API.Compatible_API_Call (
223: l_api_version,
224: p_api_version,
225: l_api_name,
226: G_PKG_NAME)

Line 228: RAISE FND_API.g_exc_unexpected_error;

224: p_api_version,
225: l_api_name,
226: G_PKG_NAME)
227: THEN
228: RAISE FND_API.g_exc_unexpected_error;
229: END IF;
230:
231: --Initialize message if p_init_msg_list IS TRUE.
232: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

Line 232: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

228: RAISE FND_API.g_exc_unexpected_error;
229: END IF;
230:
231: --Initialize message if p_init_msg_list IS TRUE.
232: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
233: FND_MSG_PUB.initialize;
234: END IF;
235:
236: -- Debug Message

Line 242: x_return_status := FND_API.G_RET_STS_SUCCESS;

238: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
239: END IF;
240:
241: -- Initialize API return status to sucess
242: x_return_status := FND_API.G_RET_STS_SUCCESS;
243:
244: OPEN batch_info_csr(p_resale_batch_id);
245: FETCH batch_info_csr INTO l_batch_status,
246: l_batch_type,

Line 271: RAISE FND_API.g_exc_error;

267:
268: IF l_batch_status <> OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
269: -- Only DISPUTED AND PROCESSED batch can be paid.
270: OZF_UTILITY_PVT.error_message('OZF_RESALE_WRONG_STAUS_TO_PAY');
271: RAISE FND_API.g_exc_error;
272: END IF;
273:
274: OPEN open_line_count_csr(p_resale_batch_id);
275: FETCH open_line_count_csr INTO l_count;

Line 281: RAISE FND_API.g_exc_error;

277:
278: IF l_count IS NOT NULL AND l_count <> 0 THEN
279: --Can not pay if there is an OPEN line
280: OZF_UTILITY_PVT.error_message('OZF_RESALE_OPEN_LINE_EXIST');
281: RAISE FND_API.g_exc_error;
282: END IF;
283:
284:
285: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN

Line 300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

296: ,p_column_name => NULL
297: ,p_column_value => NULL
298: ,x_return_status => l_return_status
299: );
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;

Line 301: RAISE FND_API.G_EXC_ERROR;

297: ,p_column_value => NULL
298: ,x_return_status => l_return_status
299: );
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:

Line 302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

298: ,x_return_status => l_return_status
299: );
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: UPDATE ozf_resale_batches_all

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: );
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306: UPDATE ozf_resale_batches_all
307: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

Line 311: --RAISE FND_API.g_exc_error;

307: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
308: WHERE resale_batch_id = p_resale_batch_id;
309:
310: RAISE error_no_rollback;
311: --RAISE FND_API.g_exc_error;
312: END IF;
313: --
314: IF OZF_DEBUG_HIGH_ON THEN
315: OZF_UTILITY_PVT.debug_message('Chargeback Budget: ' || l_chargeback_fund_id);

Line 326: ,p_init_msg_list => FND_API.G_FALSE

322:
323: IF l_inventory_tracking = 'T' THEN
324: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
325: p_api_version => 1.0
326: ,p_init_msg_list => FND_API.G_FALSE
327: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
328: ,p_resale_batch_id => p_resale_batch_id
329: ,p_start_date => l_report_start_date
330: ,p_end_date => l_report_end_date

Line 327: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

323: IF l_inventory_tracking = 'T' THEN
324: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
325: p_api_version => 1.0
326: ,p_init_msg_list => FND_API.G_FALSE
327: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
328: ,p_resale_batch_id => p_resale_batch_id
329: ,p_start_date => l_report_start_date
330: ,p_end_date => l_report_end_date
331: ,x_return_status => l_return_status

Line 335: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

331: ,x_return_status => l_return_status
332: ,x_msg_count => l_msg_count
333: ,x_msg_data => l_msg_data
334: );
335: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
336: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

Line 337: RAISE FND_API.G_EXC_ERROR;

333: ,x_msg_data => l_msg_data
334: );
335: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
336: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;

Line 338: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

334: );
335: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
336: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: END IF;

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
339: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342: END IF;
343:
344: OPEN end_cust_relation_flag_csr;

Line 370: ,p_init_msg_list => FND_API.G_FALSE

366: l_new_party_rec.site_Use_Code := 'BILL_TO';
367:
368: OZF_RESALE_COMMON_PVT.Create_Party(
369: p_api_version => 1.0
370: ,p_init_msg_list => FND_API.G_FALSE
371: ,p_commit => FND_API.G_FALSE
372: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
373: ,px_party_rec => l_new_party_rec
374: ,x_return_status => l_return_status

Line 371: ,p_commit => FND_API.G_FALSE

367:
368: OZF_RESALE_COMMON_PVT.Create_Party(
369: p_api_version => 1.0
370: ,p_init_msg_list => FND_API.G_FALSE
371: ,p_commit => FND_API.G_FALSE
372: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
373: ,px_party_rec => l_new_party_rec
374: ,x_return_status => l_return_status
375: ,x_msg_data => l_msg_data

Line 372: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

368: OZF_RESALE_COMMON_PVT.Create_Party(
369: p_api_version => 1.0
370: ,p_init_msg_list => FND_API.G_FALSE
371: ,p_commit => FND_API.G_FALSE
372: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
373: ,px_party_rec => l_new_party_rec
374: ,x_return_status => l_return_status
375: ,x_msg_data => l_msg_data
376: ,x_msg_count => l_msg_count

Line 378: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

374: ,x_return_status => l_return_status
375: ,x_msg_data => l_msg_data
376: ,x_msg_count => l_msg_count
377: );
378: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;

Line 379: RAISE FND_API.G_EXC_ERROR;

375: ,x_msg_data => l_msg_data
376: ,x_msg_count => l_msg_count
377: );
378: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:

Line 380: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

376: ,x_msg_count => l_msg_count
377: );
378: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: UPDATE ozf_resale_lines_int_all

Line 381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

377: );
378: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
379: RAISE FND_API.G_EXC_ERROR;
380: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
382: END IF;
383:
384: UPDATE ozf_resale_lines_int_all
385: SET bill_to_party_id = l_new_party_rec.party_id

Line 425: ,p_init_msg_list => FND_API.G_FALSE

421: l_new_party_rec.site_use_code := l_orig_end_cust_tbl(i).end_cust_site_use_code;
422:
423: OZF_RESALE_COMMON_PVT.Create_Party
424: ( p_api_version => 1.0
425: ,p_init_msg_list => FND_API.G_FALSE
426: ,p_commit => FND_API.G_FALSE
427: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
428: ,px_party_rec => l_new_party_rec
429: ,x_return_status => l_return_status

Line 426: ,p_commit => FND_API.G_FALSE

422:
423: OZF_RESALE_COMMON_PVT.Create_Party
424: ( p_api_version => 1.0
425: ,p_init_msg_list => FND_API.G_FALSE
426: ,p_commit => FND_API.G_FALSE
427: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
428: ,px_party_rec => l_new_party_rec
429: ,x_return_status => l_return_status
430: ,x_msg_data => l_msg_data

Line 427: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

423: OZF_RESALE_COMMON_PVT.Create_Party
424: ( p_api_version => 1.0
425: ,p_init_msg_list => FND_API.G_FALSE
426: ,p_commit => FND_API.G_FALSE
427: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
428: ,px_party_rec => l_new_party_rec
429: ,x_return_status => l_return_status
430: ,x_msg_data => l_msg_data
431: ,x_msg_count => l_msg_count

Line 433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

429: ,x_return_status => l_return_status
430: ,x_msg_data => l_msg_data
431: ,x_msg_count => l_msg_count
432: );
433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
434: RAISE FND_API.G_EXC_ERROR;
435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;

Line 434: RAISE FND_API.G_EXC_ERROR;

430: ,x_msg_data => l_msg_data
431: ,x_msg_count => l_msg_count
432: );
433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
434: RAISE FND_API.G_EXC_ERROR;
435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:

Line 435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

431: ,x_msg_count => l_msg_count
432: );
433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
434: RAISE FND_API.G_EXC_ERROR;
435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: UPDATE ozf_resale_lines_int_all

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: );
433: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
434: RAISE FND_API.G_EXC_ERROR;
435: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439: UPDATE ozf_resale_lines_int_all
440: SET end_cust_party_id = l_new_party_rec.party_id

Line 568: ,p_init_msg_list => FND_API.G_FALSE

564: l_inventory_tracking = 'T' THEN
565: -- Check inventory level first
566: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
567: p_api_version => 1.0
568: ,p_init_msg_list => FND_API.G_FALSE
569: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
570: ,p_line_int_rec => l_line_int_rec
571: ,x_valid => l_inventory_level_valid
572: ,x_return_status => l_return_status

Line 569: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

565: -- Check inventory level first
566: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
567: p_api_version => 1.0
568: ,p_init_msg_list => FND_API.G_FALSE
569: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
570: ,p_line_int_rec => l_line_int_rec
571: ,x_valid => l_inventory_level_valid
572: ,x_return_status => l_return_status
573: ,x_msg_count => l_msg_count

Line 607: ,p_init_msg_list => FND_API.G_FALSE

603: -- Determin header id
604: IF l_create_order_header THEN
605: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
606: p_api_version => 1
607: ,p_init_msg_list => FND_API.G_FALSE
608: ,p_commit => FND_API.G_FALSE
609: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
610: ,p_line_int_rec => l_line_int_rec
611: ,x_header_id => l_header_id

Line 608: ,p_commit => FND_API.G_FALSE

604: IF l_create_order_header THEN
605: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
606: p_api_version => 1
607: ,p_init_msg_list => FND_API.G_FALSE
608: ,p_commit => FND_API.G_FALSE
609: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
610: ,p_line_int_rec => l_line_int_rec
611: ,x_header_id => l_header_id
612: ,x_return_status => l_return_status

Line 609: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

605: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
606: p_api_version => 1
607: ,p_init_msg_list => FND_API.G_FALSE
608: ,p_commit => FND_API.G_FALSE
609: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
610: ,p_line_int_rec => l_line_int_rec
611: ,x_header_id => l_header_id
612: ,x_return_status => l_return_status
613: ,x_msg_data => l_msg_data

Line 616: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

612: ,x_return_status => l_return_status
613: ,x_msg_data => l_msg_data
614: ,x_msg_count => l_msg_count
615: );
616: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
617: RAISE FND_API.G_EXC_ERROR;
618: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;

Line 617: RAISE FND_API.G_EXC_ERROR;

613: ,x_msg_data => l_msg_data
614: ,x_msg_count => l_msg_count
615: );
616: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
617: RAISE FND_API.G_EXC_ERROR;
618: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621: ELSE

Line 618: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

614: ,x_msg_count => l_msg_count
615: );
616: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
617: RAISE FND_API.G_EXC_ERROR;
618: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621: ELSE
622: NULL;

Line 619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

615: );
616: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
617: RAISE FND_API.G_EXC_ERROR;
618: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: END IF;
621: ELSE
622: NULL;
623: -- We should have the l_header_id FROM at the order level

Line 641: ,p_init_msg_list => FND_API.G_FALSE

637:
638: -- No problem so far. Insert INTO batch_lines TABLE
639: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
640: p_api_version => 1
641: ,p_init_msg_list => FND_API.G_FALSE
642: ,p_commit => FND_API.G_FALSE
643: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
644: ,p_line_int_rec => l_line_int_rec
645: ,p_header_id => l_header_id

Line 642: ,p_commit => FND_API.G_FALSE

638: -- No problem so far. Insert INTO batch_lines TABLE
639: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
640: p_api_version => 1
641: ,p_init_msg_list => FND_API.G_FALSE
642: ,p_commit => FND_API.G_FALSE
643: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
644: ,p_line_int_rec => l_line_int_rec
645: ,p_header_id => l_header_id
646: ,x_line_id => l_line_id

Line 643: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

639: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
640: p_api_version => 1
641: ,p_init_msg_list => FND_API.G_FALSE
642: ,p_commit => FND_API.G_FALSE
643: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
644: ,p_line_int_rec => l_line_int_rec
645: ,p_header_id => l_header_id
646: ,x_line_id => l_line_id
647: ,x_return_status => l_return_status

Line 651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

647: ,x_return_status => l_return_status
648: ,x_msg_data => l_msg_data
649: ,x_msg_count => l_msg_count
650: );
651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: END IF;

Line 652: RAISE FND_API.G_EXC_ERROR;

648: ,x_msg_data => l_msg_data
649: ,x_msg_count => l_msg_count
650: );
651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: END IF;
656:

Line 653: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

649: ,x_msg_count => l_msg_count
650: );
651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: END IF;
656:
657: -- FOR processed order line, I need to create a transaction FOR it.

Line 654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

650: );
651: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
654: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
655: END IF;
656:
657: -- FOR processed order line, I need to create a transaction FOR it.
658: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (

Line 660: ,p_init_msg_list => FND_API.G_FALSE

656:
657: -- FOR processed order line, I need to create a transaction FOR it.
658: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
659: p_api_version => 1.0
660: ,p_init_msg_list => FND_API.G_FALSE
661: ,p_commit => FND_API.G_FALSE
662: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
663: ,p_line_int_rec => l_line_int_rec
664: ,p_header_id => l_header_id

Line 661: ,p_commit => FND_API.G_FALSE

657: -- FOR processed order line, I need to create a transaction FOR it.
658: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
659: p_api_version => 1.0
660: ,p_init_msg_list => FND_API.G_FALSE
661: ,p_commit => FND_API.G_FALSE
662: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
663: ,p_line_int_rec => l_line_int_rec
664: ,p_header_id => l_header_id
665: ,p_line_id => l_line_id

Line 662: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

658: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
659: p_api_version => 1.0
660: ,p_init_msg_list => FND_API.G_FALSE
661: ,p_commit => FND_API.G_FALSE
662: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
663: ,p_line_int_rec => l_line_int_rec
664: ,p_header_id => l_header_id
665: ,p_line_id => l_line_id
666: ,x_sales_transaction_id => l_sales_transaction_id

Line 671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

667: ,x_return_status => l_return_status
668: ,x_msg_data => l_msg_data
669: ,x_msg_count => l_msg_count
670: );
671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;

Line 672: RAISE FND_API.G_EXC_ERROR;

668: ,x_msg_data => l_msg_data
669: ,x_msg_count => l_msg_count
670: );
671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --

Line 673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

669: ,x_msg_count => l_msg_count
670: );
671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --
677:

Line 674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

670: );
671: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
672: RAISE FND_API.G_EXC_ERROR;
673: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
675: END IF;
676: --
677:
678: -- Bug 4380203 Fixing (+)

Line 684: ,p_init_msg_list => FND_API.G_FALSE

680: /*
681: IF l_inventory_tracking = 'T' THEN
682: OZF_SALES_TRANSACTIONS_PVT.Update_Inventory_Tmp(
683: p_api_version => 1.0
684: ,p_init_msg_list => FND_API.G_FALSE
685: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
686: ,p_sales_transaction_id => l_sales_transaction_id
687: ,x_return_status => l_return_status
688: ,x_msg_data => l_msg_data

Line 685: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

681: IF l_inventory_tracking = 'T' THEN
682: OZF_SALES_TRANSACTIONS_PVT.Update_Inventory_Tmp(
683: p_api_version => 1.0
684: ,p_init_msg_list => FND_API.G_FALSE
685: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
686: ,p_sales_transaction_id => l_sales_transaction_id
687: ,x_return_status => l_return_status
688: ,x_msg_data => l_msg_data
689: ,x_msg_count => l_msg_count

Line 691: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

687: ,x_return_status => l_return_status
688: ,x_msg_data => l_msg_data
689: ,x_msg_count => l_msg_count
690: );
691: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;

Line 692: RAISE FND_API.G_EXC_ERROR;

688: ,x_msg_data => l_msg_data
689: ,x_msg_count => l_msg_count
690: );
691: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696: --

Line 693: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

689: ,x_msg_count => l_msg_count
690: );
691: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696: --
697: END IF;

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

690: );
691: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
692: RAISE FND_API.G_EXC_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696: --
697: END IF;
698: */

Line 719: ,p_init_msg_list => FND_API.G_FALSE

715: -- -- only create mapping FOR the lines that are processed or
716: -- -- duplicated, yet the adjustment IS new then
717: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
718: p_api_version => 1
719: ,p_init_msg_list => FND_API.G_FALSE
720: ,p_commit => FND_API.G_FALSE
721: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
722: ,p_resale_batch_id => p_resale_batch_id
723: ,p_line_id => l_line_id

Line 720: ,p_commit => FND_API.G_FALSE

716: -- -- duplicated, yet the adjustment IS new then
717: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
718: p_api_version => 1
719: ,p_init_msg_list => FND_API.G_FALSE
720: ,p_commit => FND_API.G_FALSE
721: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
722: ,p_resale_batch_id => p_resale_batch_id
723: ,p_line_id => l_line_id
724: ,x_return_status => l_return_status

Line 721: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

717: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
718: p_api_version => 1
719: ,p_init_msg_list => FND_API.G_FALSE
720: ,p_commit => FND_API.G_FALSE
721: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
722: ,p_resale_batch_id => p_resale_batch_id
723: ,p_line_id => l_line_id
724: ,x_return_status => l_return_status
725: ,x_msg_data => l_msg_data

Line 728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

724: ,x_return_status => l_return_status
725: ,x_msg_data => l_msg_data
726: ,x_msg_count => l_msg_count
727: );
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;

Line 729: RAISE FND_API.G_EXC_ERROR;

725: ,x_msg_data => l_msg_data
726: ,x_msg_count => l_msg_count
727: );
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733: END IF;

Line 730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

726: ,x_msg_count => l_msg_count
727: );
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733: END IF;
734:

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727: );
728: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
729: RAISE FND_API.G_EXC_ERROR;
730: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733: END IF;
734:
735: IF l_line_int_rec.status_code = OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_PROCESSED AND

Line 740: ,p_init_msg_LIST => FND_API.G_FALSE

736: l_line_int_rec.tracing_flag = 'F' THEN
737: --
738: OZF_RESALE_COMMON_PVT.Create_Utilization(
739: p_api_version => 1.0
740: ,p_init_msg_LIST => FND_API.G_FALSE
741: ,p_commit => FND_API.G_FALSE
742: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
743: ,p_line_int_rec => l_line_int_rec
744: ,p_fund_id => l_chargeback_fund_id

Line 741: ,p_commit => FND_API.G_FALSE

737: --
738: OZF_RESALE_COMMON_PVT.Create_Utilization(
739: p_api_version => 1.0
740: ,p_init_msg_LIST => FND_API.G_FALSE
741: ,p_commit => FND_API.G_FALSE
742: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
743: ,p_line_int_rec => l_line_int_rec
744: ,p_fund_id => l_chargeback_fund_id
745: ,p_line_id => l_line_id

Line 742: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

738: OZF_RESALE_COMMON_PVT.Create_Utilization(
739: p_api_version => 1.0
740: ,p_init_msg_LIST => FND_API.G_FALSE
741: ,p_commit => FND_API.G_FALSE
742: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
743: ,p_line_int_rec => l_line_int_rec
744: ,p_fund_id => l_chargeback_fund_id
745: ,p_line_id => l_line_id
746: ,p_cust_account_id => l_partner_cust_account_id

Line 752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

748: ,x_return_status => l_return_status
749: ,x_msg_data => l_msg_data
750: ,x_msg_count => l_msg_count
751: );
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;

Line 753: RAISE FND_API.G_EXC_ERROR;

749: ,x_msg_data => l_msg_data
750: ,x_msg_count => l_msg_count
751: );
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: END IF; -- If this line is a processed one

Line 754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

750: ,x_msg_count => l_msg_count
751: );
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: END IF; -- If this line is a processed one
758: --

Line 755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

751: );
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757: END IF; -- If this line is a processed one
758: --
759: << END_ORDER_LINE >>

Line 770: ,p_init_msg_list => FND_API.G_FALSE

766: END IF; -- END order_num EXISTS IF B
767:
768: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
769: p_api_version => 1.0
770: ,p_init_msg_list => FND_API.G_FALSE
771: ,p_commit => FND_API.G_FALSE
772: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
773: ,p_resale_batch_id => p_resale_batch_id
774: ,x_return_status => l_return_status

Line 771: ,p_commit => FND_API.G_FALSE

767:
768: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
769: p_api_version => 1.0
770: ,p_init_msg_list => FND_API.G_FALSE
771: ,p_commit => FND_API.G_FALSE
772: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
773: ,p_resale_batch_id => p_resale_batch_id
774: ,x_return_status => l_return_status
775: ,x_msg_data => l_msg_data

Line 772: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

768: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
769: p_api_version => 1.0
770: ,p_init_msg_list => FND_API.G_FALSE
771: ,p_commit => FND_API.G_FALSE
772: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
773: ,p_resale_batch_id => p_resale_batch_id
774: ,x_return_status => l_return_status
775: ,x_msg_data => l_msg_data
776: ,x_msg_count => l_msg_count

Line 778: IF l_return_status = FND_API.g_ret_sts_error THEN

774: ,x_return_status => l_return_status
775: ,x_msg_data => l_msg_data
776: ,x_msg_count => l_msg_count
777: );
778: IF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
781: RAISE FND_API.g_exc_unexpected_error;
782: END IF;

Line 779: RAISE FND_API.g_exc_error;

775: ,x_msg_data => l_msg_data
776: ,x_msg_count => l_msg_count
777: );
778: IF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
781: RAISE FND_API.g_exc_unexpected_error;
782: END IF;
783:

Line 780: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

776: ,x_msg_count => l_msg_count
777: );
778: IF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
781: RAISE FND_API.g_exc_unexpected_error;
782: END IF;
783:
784: -- After all the processes are done, call claim autopay

Line 781: RAISE FND_API.g_exc_unexpected_error;

777: );
778: IF l_return_status = FND_API.g_ret_sts_error THEN
779: RAISE FND_API.g_exc_error;
780: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
781: RAISE FND_API.g_exc_unexpected_error;
782: END IF;
783:
784: -- After all the processes are done, call claim autopay
785: l_claim_rec.cust_account_id := l_partner_cust_account_id;

Line 800: ,p_init_msg_list => FND_API.g_false

796: l_funds_util_flt.utilization_type:= G_CHBK_UTIL_TYPE;
797:
798: OZF_Claim_Accrual_PVT.Pay_Claim_for_Accruals(
799: p_api_version => 1.0
800: ,p_init_msg_list => FND_API.g_false
801: ,p_commit => FND_API.g_false
802: ,p_validation_level => FND_API.g_valid_level_full
803: ,x_return_status => l_return_status
804: ,x_msg_count => l_msg_count

Line 801: ,p_commit => FND_API.g_false

797:
798: OZF_Claim_Accrual_PVT.Pay_Claim_for_Accruals(
799: p_api_version => 1.0
800: ,p_init_msg_list => FND_API.g_false
801: ,p_commit => FND_API.g_false
802: ,p_validation_level => FND_API.g_valid_level_full
803: ,x_return_status => l_return_status
804: ,x_msg_count => l_msg_count
805: ,x_msg_data => l_msg_data

Line 802: ,p_validation_level => FND_API.g_valid_level_full

798: OZF_Claim_Accrual_PVT.Pay_Claim_for_Accruals(
799: p_api_version => 1.0
800: ,p_init_msg_list => FND_API.g_false
801: ,p_commit => FND_API.g_false
802: ,p_validation_level => FND_API.g_valid_level_full
803: ,x_return_status => l_return_status
804: ,x_msg_count => l_msg_count
805: ,x_msg_data => l_msg_data
806: ,p_claim_rec => l_claim_rec

Line 810: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

806: ,p_claim_rec => l_claim_rec
807: ,p_funds_util_flt => l_funds_util_flt
808: ,x_claim_id => l_claim_id
809: );
810: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
811: RAISE FND_API.g_exc_unexpected_error;
812: END IF;
813:
814:

Line 811: RAISE FND_API.g_exc_unexpected_error;

807: ,p_funds_util_flt => l_funds_util_flt
808: ,x_claim_id => l_claim_id
809: );
810: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
811: RAISE FND_API.g_exc_unexpected_error;
812: END IF;
813:
814:
815: IF OZF_DEBUG_LOW_ON THEN

Line 852: RAISE FND_API.g_exc_unexpected_error;

848:
849: EXCEPTION
850: WHEN OTHERS THEN
851: OZF_UTILITY_PVT.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': End');
852: RAISE FND_API.g_exc_unexpected_error;
853: END;
854:
855: -- mchang: Run Third Party Accrual After Chargeback Calculation was
856: -- done in workflow already. No need to check here.

Line 875: p_encoded => FND_API.G_FALSE,

871: END IF;
872:
873: --Standard call to get message count AND if count=1, get the message
874: FND_MSG_PUB.Count_and_Get (
875: p_encoded => FND_API.G_FALSE,
876: p_count => x_msg_count,
877: p_data => x_msg_data
878: );
879:

Line 882: x_return_status := FND_API.G_RET_STS_ERROR;

878: );
879:
880: EXCEPTION
881: WHEN error_no_rollback THEN
882: x_return_status := FND_API.G_RET_STS_ERROR;
883: FND_MSG_PUB.Count_And_Get (
884: p_encoded => FND_API.G_FALSE,
885: p_count => x_msg_count,
886: p_data => x_msg_data

Line 884: p_encoded => FND_API.G_FALSE,

880: EXCEPTION
881: WHEN error_no_rollback THEN
882: x_return_status := FND_API.G_RET_STS_ERROR;
883: FND_MSG_PUB.Count_And_Get (
884: p_encoded => FND_API.G_FALSE,
885: p_count => x_msg_count,
886: p_data => x_msg_data
887: );
888: WHEN FND_API.g_exc_error THEN

Line 888: WHEN FND_API.g_exc_error THEN

884: p_encoded => FND_API.G_FALSE,
885: p_count => x_msg_count,
886: p_data => x_msg_data
887: );
888: WHEN FND_API.g_exc_error THEN
889: ROLLBACK TO Initiate_Payment;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: -- Standard call to get message count AND IF count=1, get the message
892: FND_MSG_PUB.Count_And_Get (

Line 890: x_return_status := FND_API.G_RET_STS_ERROR;

886: p_data => x_msg_data
887: );
888: WHEN FND_API.g_exc_error THEN
889: ROLLBACK TO Initiate_Payment;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: -- Standard call to get message count AND IF count=1, get the message
892: FND_MSG_PUB.Count_And_Get (
893: p_encoded => FND_API.G_FALSE,
894: p_count => x_msg_count,

Line 893: p_encoded => FND_API.G_FALSE,

889: ROLLBACK TO Initiate_Payment;
890: x_return_status := FND_API.G_RET_STS_ERROR;
891: -- Standard call to get message count AND IF count=1, get the message
892: FND_MSG_PUB.Count_And_Get (
893: p_encoded => FND_API.G_FALSE,
894: p_count => x_msg_count,
895: p_data => x_msg_data
896: );
897: WHEN FND_API.g_exc_unexpected_error THEN

Line 897: WHEN FND_API.g_exc_unexpected_error THEN

893: p_encoded => FND_API.G_FALSE,
894: p_count => x_msg_count,
895: p_data => x_msg_data
896: );
897: WHEN FND_API.g_exc_unexpected_error THEN
898: ROLLBACK TO Initiate_Payment;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: -- Standard call to get message count AND IF count=1, get the message
901: FND_MSG_PUB.Count_And_Get (

Line 899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

895: p_data => x_msg_data
896: );
897: WHEN FND_API.g_exc_unexpected_error THEN
898: ROLLBACK TO Initiate_Payment;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: -- Standard call to get message count AND IF count=1, get the message
901: FND_MSG_PUB.Count_And_Get (
902: p_encoded => FND_API.G_FALSE,
903: p_count => x_msg_count,

Line 902: p_encoded => FND_API.G_FALSE,

898: ROLLBACK TO Initiate_Payment;
899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
900: -- Standard call to get message count AND IF count=1, get the message
901: FND_MSG_PUB.Count_And_Get (
902: p_encoded => FND_API.G_FALSE,
903: p_count => x_msg_count,
904: p_data => x_msg_data
905: );
906: WHEN OTHERS THEN

Line 908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

904: p_data => x_msg_data
905: );
906: WHEN OTHERS THEN
907: ROLLBACK TO Initiate_Payment;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909: IF OZF_UNEXP_ERROR THEN
910: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
911: END IF;
912: -- Standard call to get message count AND IF count=1, get the message

Line 914: p_encoded => FND_API.G_FALSE,

910: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
911: END IF;
912: -- Standard call to get message count AND IF count=1, get the message
913: FND_MSG_PUB.Count_And_Get (
914: p_encoded => FND_API.G_FALSE,
915: p_count => x_msg_count,
916: p_data => x_msg_data
917: );
918: END Initiate_Payment;

Line 935: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

931: -- NOTES
932: ---------------------------------------------------------------------
933: PROCEDURE Validate_Order_Record(
934: p_api_version IN NUMBER
935: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
936: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
937: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
938: ,p_resale_batch_id IN NUMBER
939: ,x_return_status OUT NOCOPY VARCHAR2

Line 936: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

932: ---------------------------------------------------------------------
933: PROCEDURE Validate_Order_Record(
934: p_api_version IN NUMBER
935: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
936: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
937: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
938: ,p_resale_batch_id IN NUMBER
939: ,x_return_status OUT NOCOPY VARCHAR2
940: ,x_msg_data OUT NOCOPY VARCHAR2

Line 937: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

933: PROCEDURE Validate_Order_Record(
934: p_api_version IN NUMBER
935: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
936: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
937: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
938: ,p_resale_batch_id IN NUMBER
939: ,x_return_status OUT NOCOPY VARCHAR2
940: ,x_msg_data OUT NOCOPY VARCHAR2
941: ,x_msg_count OUT NOCOPY NUMBER

Line 967: IF NOT FND_API.Compatible_API_Call (

963:
964: --
965: BEGIN
966: -- Standard call to check FOR call compatibility.
967: IF NOT FND_API.Compatible_API_Call (
968: l_api_version,
969: p_api_version,
970: l_api_name,
971: G_PKG_NAME)

Line 973: RAISE FND_API.g_exc_unexpected_error;

969: p_api_version,
970: l_api_name,
971: G_PKG_NAME)
972: THEN
973: RAISE FND_API.g_exc_unexpected_error;
974: END IF;
975:
976: -- Debug Message
977: IF OZF_DEBUG_HIGH_ON THEN

Line 982: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

978: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
979: END IF;
980:
981: --Initialize message lISt if p_init_msg_list IS TRUE.
982: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
983: FND_MSG_PUB.initialize;
984: END IF;
985:
986: -- Initialize API return status to sucess

Line 987: x_return_status := FND_API.G_RET_STS_SUCCESS;

983: FND_MSG_PUB.initialize;
984: END IF;
985:
986: -- Initialize API return status to sucess
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988:
989: -- bulk select all lines with missing order numbers
990: IF l_id_tbl.EXISTS(1) THEN
991: l_id_tbl.DELETE;

Line 1018: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1014: p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
1015: x_return_status => l_return_status
1016: );
1017:
1018: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.g_exc_unexpected_error;
1022: END IF;

Line 1019: RAISE FND_API.g_exc_error;

1015: x_return_status => l_return_status
1016: );
1017:
1018: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.g_exc_unexpected_error;
1022: END IF;
1023: --

Line 1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1016: );
1017:
1018: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.g_exc_unexpected_error;
1022: END IF;
1023: --
1024:

Line 1021: RAISE FND_API.g_exc_unexpected_error;

1017:
1018: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1019: RAISE FND_API.g_exc_error;
1020: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1021: RAISE FND_API.g_exc_unexpected_error;
1022: END IF;
1023: --
1024:
1025: OZF_RESALE_COMMON_PVT.Bulk_Dispute_Line (

Line 1030: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1026: p_batch_id => p_resale_batch_id,
1027: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
1028: x_return_status => l_return_status
1029: );
1030: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1031: RAISE FND_API.g_exc_error;
1032: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1033: RAISE FND_API.g_exc_unexpected_error;
1034: END IF;

Line 1031: RAISE FND_API.g_exc_error;

1027: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
1028: x_return_status => l_return_status
1029: );
1030: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1031: RAISE FND_API.g_exc_error;
1032: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1033: RAISE FND_API.g_exc_unexpected_error;
1034: END IF;
1035: --

Line 1032: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1028: x_return_status => l_return_status
1029: );
1030: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1031: RAISE FND_API.g_exc_error;
1032: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1033: RAISE FND_API.g_exc_unexpected_error;
1034: END IF;
1035: --
1036:

Line 1033: RAISE FND_API.g_exc_unexpected_error;

1029: );
1030: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1031: RAISE FND_API.g_exc_error;
1032: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1033: RAISE FND_API.g_exc_unexpected_error;
1034: END IF;
1035: --
1036:
1037: -- Debug Message

Line 1044: p_encoded => FND_API.G_FALSE,

1040: END IF;
1041:
1042: --Standard call to get message count AND if count=1, get the message
1043: FND_MSG_PUB.Count_and_Get (
1044: p_encoded => FND_API.G_FALSE,
1045: p_count => x_msg_count,
1046: p_data => x_msg_data
1047: );
1048: --

Line 1050: WHEN FND_API.g_exc_error THEN

1046: p_data => x_msg_data
1047: );
1048: --
1049: EXCEPTION
1050: WHEN FND_API.g_exc_error THEN
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052: -- Standard call to get message count AND if count=1, get the message
1053: FND_MSG_PUB.Count_and_Get (
1054: p_encoded => FND_API.G_FALSE,

Line 1051: x_return_status := FND_API.G_RET_STS_ERROR;

1047: );
1048: --
1049: EXCEPTION
1050: WHEN FND_API.g_exc_error THEN
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052: -- Standard call to get message count AND if count=1, get the message
1053: FND_MSG_PUB.Count_and_Get (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,

Line 1054: p_encoded => FND_API.G_FALSE,

1050: WHEN FND_API.g_exc_error THEN
1051: x_return_status := FND_API.G_RET_STS_ERROR;
1052: -- Standard call to get message count AND if count=1, get the message
1053: FND_MSG_PUB.Count_and_Get (
1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058: WHEN FND_API.g_exc_unexpected_error THEN

Line 1058: WHEN FND_API.g_exc_unexpected_error THEN

1054: p_encoded => FND_API.G_FALSE,
1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058: WHEN FND_API.g_exc_unexpected_error THEN
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: -- Standard call to get message count AND if count=1, get the message
1061: FND_MSG_PUB.Count_and_Get (
1062: p_encoded => FND_API.G_FALSE,

Line 1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1055: p_count => x_msg_count,
1056: p_data => x_msg_data
1057: );
1058: WHEN FND_API.g_exc_unexpected_error THEN
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: -- Standard call to get message count AND if count=1, get the message
1061: FND_MSG_PUB.Count_and_Get (
1062: p_encoded => FND_API.G_FALSE,
1063: p_count => x_msg_count,

Line 1062: p_encoded => FND_API.G_FALSE,

1058: WHEN FND_API.g_exc_unexpected_error THEN
1059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1060: -- Standard call to get message count AND if count=1, get the message
1061: FND_MSG_PUB.Count_and_Get (
1062: p_encoded => FND_API.G_FALSE,
1063: p_count => x_msg_count,
1064: p_data => x_msg_data
1065: );
1066: WHEN OTHERS THEN

Line 1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1063: p_count => x_msg_count,
1064: p_data => x_msg_data
1065: );
1066: WHEN OTHERS THEN
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1068: -- Standard call to get message count AND if count=1, get the message
1069: FND_MSG_PUB.Count_and_Get (
1070: p_encoded => FND_API.G_FALSE,
1071: p_count => x_msg_count,

Line 1070: p_encoded => FND_API.G_FALSE,

1066: WHEN OTHERS THEN
1067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1068: -- Standard call to get message count AND if count=1, get the message
1069: FND_MSG_PUB.Count_and_Get (
1070: p_encoded => FND_API.G_FALSE,
1071: p_count => x_msg_count,
1072: p_data => x_msg_data
1073: );
1074: END Validate_Order_Record;

Line 1168: x_return_status := FND_API.G_RET_STS_SUCCESS;

1164: l_uom_ratio number;
1165: BEGIN
1166: SAVEPOINT Process_Pricing_Result;
1167:
1168: x_return_status := FND_API.G_RET_STS_SUCCESS;
1169:
1170: -- Debug Message
1171: IF OZF_DEBUG_HIGH_ON THEN
1172: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

Line 1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1207: where resale_line_int_id = p_line_tbl(i).chargeback_int_id;
1208: EXCEPTION
1209: WHEN OTHERS THEN
1210: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
1211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1212: END;
1213:
1214: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1215: p_id_value => p_line_tbl(i).chargeback_int_id,

Line 1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1219: p_column_name => NULL,
1220: p_column_value => NULL,
1221: x_return_status => l_return_status);
1222: --
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.g_exc_error;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.g_exc_unexpected_error;
1227: END IF;

Line 1224: RAISE FND_API.g_exc_error;

1220: p_column_value => NULL,
1221: x_return_status => l_return_status);
1222: --
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.g_exc_error;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.g_exc_unexpected_error;
1227: END IF;
1228:

Line 1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1221: x_return_status => l_return_status);
1222: --
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.g_exc_error;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.g_exc_unexpected_error;
1227: END IF;
1228:
1229: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

Line 1226: RAISE FND_API.g_exc_unexpected_error;

1222: --
1223: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1224: RAISE FND_API.g_exc_error;
1225: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1226: RAISE FND_API.g_exc_unexpected_error;
1227: END IF;
1228:
1229: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1230: p_id_value => p_line_tbl(i).chargeback_int_id,

Line 1237: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1233: p_column_name => NULL,
1234: p_column_value => NULL,
1235: x_return_status => l_return_status);
1236: --
1237: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1238: RAISE FND_API.g_exc_error;
1239: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: RAISE FND_API.g_exc_unexpected_error;
1241: END IF;

Line 1238: RAISE FND_API.g_exc_error;

1234: p_column_value => NULL,
1235: x_return_status => l_return_status);
1236: --
1237: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1238: RAISE FND_API.g_exc_error;
1239: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: RAISE FND_API.g_exc_unexpected_error;
1241: END IF;
1242: --

Line 1239: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1235: x_return_status => l_return_status);
1236: --
1237: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1238: RAISE FND_API.g_exc_error;
1239: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: RAISE FND_API.g_exc_unexpected_error;
1241: END IF;
1242: --
1243: END IF;

Line 1240: RAISE FND_API.g_exc_unexpected_error;

1236: --
1237: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1238: RAISE FND_API.g_exc_error;
1239: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1240: RAISE FND_API.g_exc_unexpected_error;
1241: END IF;
1242: --
1243: END IF;
1244:

Line 1276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1272: p_column_value => l_val_tbl,
1273: p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
1274: x_return_status => l_return_status
1275: );
1276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;

Line 1277: RAISE FND_API.G_EXC_ERROR;

1273: p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
1274: x_return_status => l_return_status
1275: );
1276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:

Line 1278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1274: x_return_status => l_return_status
1275: );
1276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:
1282: BEGIN

Line 1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1275: );
1276: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1277: RAISE FND_API.G_EXC_ERROR;
1278: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1280: END IF;
1281:
1282: BEGIN
1283: UPDATE ozf_resale_lines_int_all

Line 1298: RAISE FND_API.g_exc_unexpected_error;

1294: AND resale_batch_id = p_resale_batch_id;
1295: EXCEPTION
1296: WHEN OTHERS THEN
1297: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
1298: RAISE FND_API.g_exc_unexpected_error;
1299: END;
1300:
1301: ELSE
1302: -- There is no error in the result. We need to process the result one by one.

Line 1337: ,p_init_msg_list => FND_API.G_FALSE

1333:
1334: -- Check inventory level first
1335: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1336: p_api_version => 1.0
1337: ,p_init_msg_list => FND_API.G_FALSE
1338: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1339: ,p_line_int_rec => l_resale_int_rec
1340: ,x_valid => l_inventory_level_valid
1341: ,x_return_status => l_return_status

Line 1338: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1334: -- Check inventory level first
1335: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1336: p_api_version => 1.0
1337: ,p_init_msg_list => FND_API.G_FALSE
1338: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1339: ,p_line_int_rec => l_resale_int_rec
1340: ,x_valid => l_inventory_level_valid
1341: ,x_return_status => l_return_status
1342: ,x_msg_count => l_msg_count

Line 1359: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1355: p_column_name => NULL,
1356: p_column_value => NULL,
1357: x_return_status => l_return_status);
1358: --
1359: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1360: RAISE FND_API.g_exc_error;
1361: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.g_exc_unexpected_error;
1363: END IF;

Line 1360: RAISE FND_API.g_exc_error;

1356: p_column_value => NULL,
1357: x_return_status => l_return_status);
1358: --
1359: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1360: RAISE FND_API.g_exc_error;
1361: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.g_exc_unexpected_error;
1363: END IF;
1364: --

Line 1361: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1357: x_return_status => l_return_status);
1358: --
1359: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1360: RAISE FND_API.g_exc_error;
1361: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.g_exc_unexpected_error;
1363: END IF;
1364: --
1365: -- SET Batch as DISPUTED

Line 1362: RAISE FND_API.g_exc_unexpected_error;

1358: --
1359: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1360: RAISE FND_API.g_exc_error;
1361: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.g_exc_unexpected_error;
1363: END IF;
1364: --
1365: -- SET Batch as DISPUTED
1366: -- SLKRISHN change to common procedure

Line 1403: RAISE FND_API.g_exc_unexpected_error;

1399: END IF;
1400:
1401: IF l_exchange_type IS NULL THEN
1402: OZF_UTILITY_PVT.error_message('OZF_CLAIM_CONTYPE_MISSING');
1403: RAISE FND_API.g_exc_unexpected_error;
1404: END IF;
1405:
1406: IF l_exchange_date IS NULL THEN
1407: l_exchange_date := sysdate;

Line 1428: IF l_return_status = FND_API.g_ret_sts_error THEN

1424: ,p_from_amount => p_line_tbl(i).unit_price
1425: ,x_return_status => l_return_status
1426: ,x_to_amount => l_acctd_adj_unit_price
1427: ,x_rate => l_rate);
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;

Line 1429: RAISE FND_API.g_exc_error;

1425: ,x_return_status => l_return_status
1426: ,x_to_amount => l_acctd_adj_unit_price
1427: ,x_rate => l_rate);
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;
1433:

Line 1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1426: ,x_to_amount => l_acctd_adj_unit_price
1427: ,x_rate => l_rate);
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;
1433:
1434: -- convert adjusted selling price

Line 1431: RAISE FND_API.g_exc_unexpected_error;

1427: ,x_rate => l_rate);
1428: IF l_return_status = FND_API.g_ret_sts_error THEN
1429: RAISE FND_API.g_exc_error;
1430: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1431: RAISE FND_API.g_exc_unexpected_error;
1432: END IF;
1433:
1434: -- convert adjusted selling price
1435: OZF_UTILITY_PVT.Convert_Currency(

Line 1445: IF l_return_status = FND_API.g_ret_sts_error THEN

1441: ,p_from_amount => l_resale_int_rec.selling_price
1442: ,x_return_status => l_return_status
1443: ,x_to_amount => l_acctd_selling_price
1444: ,x_rate => l_rate);
1445: IF l_return_status = FND_API.g_ret_sts_error THEN
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: RAISE FND_API.g_exc_unexpected_error;
1449: END IF;

Line 1446: RAISE FND_API.g_exc_error;

1442: ,x_return_status => l_return_status
1443: ,x_to_amount => l_acctd_selling_price
1444: ,x_rate => l_rate);
1445: IF l_return_status = FND_API.g_ret_sts_error THEN
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: RAISE FND_API.g_exc_unexpected_error;
1449: END IF;
1450: ELSE

Line 1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1443: ,x_to_amount => l_acctd_selling_price
1444: ,x_rate => l_rate);
1445: IF l_return_status = FND_API.g_ret_sts_error THEN
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: RAISE FND_API.g_exc_unexpected_error;
1449: END IF;
1450: ELSE
1451: l_acctd_adj_unit_price := OZF_UTILITY_PVT.CurrRound(p_line_tbl(i).unit_price*l_rate, l_func_currency_code);

Line 1448: RAISE FND_API.g_exc_unexpected_error;

1444: ,x_rate => l_rate);
1445: IF l_return_status = FND_API.g_ret_sts_error THEN
1446: RAISE FND_API.g_exc_error;
1447: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1448: RAISE FND_API.g_exc_unexpected_error;
1449: END IF;
1450: ELSE
1451: l_acctd_adj_unit_price := OZF_UTILITY_PVT.CurrRound(p_line_tbl(i).unit_price*l_rate, l_func_currency_code);
1452: l_acctd_selling_price := OZF_UTILITY_PVT.CurrRound(l_resale_int_rec.selling_price*l_rate, l_func_currency_code);

Line 1510: IF l_return_status = FND_API.g_ret_sts_error THEN

1506: p_line_quantity => p_line_tbl(i).line_quantity,
1507: p_allowed_amount => l_allowed_amount,
1508: x_return_status => l_return_status);
1509: --
1510: IF l_return_status = FND_API.g_ret_sts_error THEN
1511: RAISE FND_API.g_exc_error;
1512: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1513: RAISE FND_API.g_exc_unexpected_error;
1514: END IF;

Line 1511: RAISE FND_API.g_exc_error;

1507: p_allowed_amount => l_allowed_amount,
1508: x_return_status => l_return_status);
1509: --
1510: IF l_return_status = FND_API.g_ret_sts_error THEN
1511: RAISE FND_API.g_exc_error;
1512: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1513: RAISE FND_API.g_exc_unexpected_error;
1514: END IF;
1515: --

Line 1512: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1508: x_return_status => l_return_status);
1509: --
1510: IF l_return_status = FND_API.g_ret_sts_error THEN
1511: RAISE FND_API.g_exc_error;
1512: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1513: RAISE FND_API.g_exc_unexpected_error;
1514: END IF;
1515: --
1516: END IF; -- END if current record IS a line

Line 1513: RAISE FND_API.g_exc_unexpected_error;

1509: --
1510: IF l_return_status = FND_API.g_ret_sts_error THEN
1511: RAISE FND_API.g_exc_error;
1512: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1513: RAISE FND_API.g_exc_unexpected_error;
1514: END IF;
1515: --
1516: END IF; -- END if current record IS a line
1517: << END_LOOP3>>

Line 1528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1524: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
1525: x_return_status => l_return_status
1526: );
1527: --
1528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.g_exc_error;
1530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: END IF;

Line 1529: RAISE FND_API.g_exc_error;

1525: x_return_status => l_return_status
1526: );
1527: --
1528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.g_exc_error;
1530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: END IF;
1533: --

Line 1530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1526: );
1527: --
1528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.g_exc_error;
1530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: END IF;
1533: --
1534: END IF; -- END of l_has_error

Line 1531: RAISE FND_API.g_exc_unexpected_error;

1527: --
1528: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1529: RAISE FND_API.g_exc_error;
1530: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1531: RAISE FND_API.g_exc_unexpected_error;
1532: END IF;
1533: --
1534: END IF; -- END of l_has_error
1535: ELSE

Line 1547: WHEN FND_API.g_exc_error THEN

1543: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1544: END IF;
1545:
1546: EXCEPTION
1547: WHEN FND_API.g_exc_error THEN
1548: ROLLBACK TO Process_Pricing_Result;
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: WHEN FND_API.g_exc_unexpected_error THEN
1551: ROLLBACK TO Process_Pricing_Result;

Line 1549: x_return_status := FND_API.G_RET_STS_ERROR;

1545:
1546: EXCEPTION
1547: WHEN FND_API.g_exc_error THEN
1548: ROLLBACK TO Process_Pricing_Result;
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: WHEN FND_API.g_exc_unexpected_error THEN
1551: ROLLBACK TO Process_Pricing_Result;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: WHEN OTHERS THEN

Line 1550: WHEN FND_API.g_exc_unexpected_error THEN

1546: EXCEPTION
1547: WHEN FND_API.g_exc_error THEN
1548: ROLLBACK TO Process_Pricing_Result;
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: WHEN FND_API.g_exc_unexpected_error THEN
1551: ROLLBACK TO Process_Pricing_Result;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: WHEN OTHERS THEN
1554: ROLLBACK TO Process_Pricing_Result;

Line 1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1548: ROLLBACK TO Process_Pricing_Result;
1549: x_return_status := FND_API.G_RET_STS_ERROR;
1550: WHEN FND_API.g_exc_unexpected_error THEN
1551: ROLLBACK TO Process_Pricing_Result;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: WHEN OTHERS THEN
1554: ROLLBACK TO Process_Pricing_Result;
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: IF OZF_UNEXP_ERROR THEN

Line 1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1551: ROLLBACK TO Process_Pricing_Result;
1552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1553: WHEN OTHERS THEN
1554: ROLLBACK TO Process_Pricing_Result;
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: IF OZF_UNEXP_ERROR THEN
1557: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1558: END IF;
1559: END Process_Pricing_Result;

Line 1656: x_return_status := FND_API.G_RET_STS_SUCCESS;

1652:
1653: SAVEPOINT Get_Order_Price;
1654:
1655: -- Initialize API return status to sucess
1656: x_return_status := FND_API.G_RET_STS_SUCCESS;
1657:
1658: -- bug 6511302 (+) validate inventory for tracing lines
1659: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1660: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;

Line 1682: ,p_init_msg_list => FND_API.G_FALSE

1678: IF l_resale_int_rec.duplicated_adjustment_id IS NULL OR l_resale_int_rec.duplicated_adjustment_id = -1 THEN
1679: -- Check inventory level first
1680: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1681: p_api_version => 1.0
1682: ,p_init_msg_list => FND_API.G_FALSE
1683: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1684: ,p_line_int_rec => l_resale_int_rec
1685: ,x_valid => l_inventory_level_valid
1686: ,x_return_status => l_return_status

Line 1683: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1679: -- Check inventory level first
1680: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1681: p_api_version => 1.0
1682: ,p_init_msg_list => FND_API.G_FALSE
1683: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1684: ,p_line_int_rec => l_resale_int_rec
1685: ,x_valid => l_inventory_level_valid
1686: ,x_return_status => l_return_status
1687: ,x_msg_count => l_msg_count

Line 1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1701: p_column_name => NULL,
1702: p_column_value => NULL,
1703: x_return_status => l_return_status);
1704:
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.g_exc_error;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.g_exc_unexpected_error;
1709: END IF;

Line 1706: RAISE FND_API.g_exc_error;

1702: p_column_value => NULL,
1703: x_return_status => l_return_status);
1704:
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.g_exc_error;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.g_exc_unexpected_error;
1709: END IF;
1710:

Line 1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1703: x_return_status => l_return_status);
1704:
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.g_exc_error;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.g_exc_unexpected_error;
1709: END IF;
1710:
1711: -- Set line to DISPUTED

Line 1708: RAISE FND_API.g_exc_unexpected_error;

1704:
1705: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1706: RAISE FND_API.g_exc_error;
1707: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1708: RAISE FND_API.g_exc_unexpected_error;
1709: END IF;
1710:
1711: -- Set line to DISPUTED
1712: UPDATE ozf_resale_lines_int

Line 1800: RAISE FND_API.g_exc_unexpected_error;

1796: WHEN OTHERS THEN
1797: IF OZF_UNEXP_ERROR THEN
1798: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1799: END IF;
1800: RAISE FND_API.g_exc_unexpected_error;
1801: END;
1802: IF OZF_DEBUG_LOW_ON THEN
1803: OZF_UTILITY_PVT.debug_message('/*--- Buidling order line info for inteface id: '||l_order_set_tbl(J).resale_line_int_id ||'---*/');
1804: END IF;

Line 1826: --l_line_tbl(J).upd_adjusted_unit_price := FND_API.G_MISS_NUM,

1822: --l_line_tbl(J).unit_price := NULL;
1823: --l_line_tbl(J).percent_price := NULL;
1824: --l_line_tbl(J).uom_quantity := NULL;
1825: --l_line_tbl(J).adjusted_unit_price := NULL;
1826: --l_line_tbl(J).upd_adjusted_unit_price := FND_API.G_MISS_NUM,
1827: --l_line_tbl(J).processed_flag := FND_API.G_MISS_CHAR,
1828: l_line_tbl(J).price_flag := l_price_flag;
1829: --l_line_tbl(J).processing_order := NULL;
1830: l_line_tbl(J).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;

Line 1827: --l_line_tbl(J).processed_flag := FND_API.G_MISS_CHAR,

1823: --l_line_tbl(J).percent_price := NULL;
1824: --l_line_tbl(J).uom_quantity := NULL;
1825: --l_line_tbl(J).adjusted_unit_price := NULL;
1826: --l_line_tbl(J).upd_adjusted_unit_price := FND_API.G_MISS_NUM,
1827: --l_line_tbl(J).processed_flag := FND_API.G_MISS_CHAR,
1828: l_line_tbl(J).price_flag := l_price_flag;
1829: --l_line_tbl(J).processing_order := NULL;
1830: l_line_tbl(J).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1831: --l_line_tbl(J).pricing_status_text := NULL;

Line 1972: --l_line_tbl(J).UPD_ADJUSTED_UNIT_PRICE := FND_API.G_MISS_NUM,

1968: --l_line_tbl(J).UNIT_PRICE := l_order_set_tbl(J).
1969: --l_line_tbl(J).PERCENT_PRICE := l_order_set_tbl(J).
1970: --l_line_tbl(J).UOM_QUANTITY := l_order_set_tbl(J).
1971: --l_line_tbl(J).ADJUSTED_UNIT_PRICE := l_order_set_tbl(J).
1972: --l_line_tbl(J).UPD_ADJUSTED_UNIT_PRICE := FND_API.G_MISS_NUM,
1973: --l_line_tbl(J).PROCESSED_FLAG := FND_API.G_MISS_CHAR,
1974: l_line_tbl(k).PRICE_FLAG := l_price_flag;
1975: --l_line_tbl(J).PROCESSING_ORDER := NULL;
1976: l_line_tbl(k).PRICING_STATUS_CODE := QP_PREQ_GRP.G_STATUS_UNCHANGED;

Line 1973: --l_line_tbl(J).PROCESSED_FLAG := FND_API.G_MISS_CHAR,

1969: --l_line_tbl(J).PERCENT_PRICE := l_order_set_tbl(J).
1970: --l_line_tbl(J).UOM_QUANTITY := l_order_set_tbl(J).
1971: --l_line_tbl(J).ADJUSTED_UNIT_PRICE := l_order_set_tbl(J).
1972: --l_line_tbl(J).UPD_ADJUSTED_UNIT_PRICE := FND_API.G_MISS_NUM,
1973: --l_line_tbl(J).PROCESSED_FLAG := FND_API.G_MISS_CHAR,
1974: l_line_tbl(k).PRICE_FLAG := l_price_flag;
1975: --l_line_tbl(J).PROCESSING_ORDER := NULL;
1976: l_line_tbl(k).PRICING_STATUS_CODE := QP_PREQ_GRP.G_STATUS_UNCHANGED;
1977: --l_line_tbl(J).PRICING_STATUS_TEXT := NULL;

Line 2019: ,p_init_msg_list => FND_API.G_FALSE

2015:
2016: -- Get the agreement price for order lines
2017: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2018: p_api_version => 1.0
2019: ,p_init_msg_list => FND_API.G_FALSE
2020: ,p_commit => FND_API.G_FALSE
2021: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2022: ,x_return_status => l_return_status
2023: ,x_msg_data => l_msg_data

Line 2020: ,p_commit => FND_API.G_FALSE

2016: -- Get the agreement price for order lines
2017: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2018: p_api_version => 1.0
2019: ,p_init_msg_list => FND_API.G_FALSE
2020: ,p_commit => FND_API.G_FALSE
2021: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2022: ,x_return_status => l_return_status
2023: ,x_msg_data => l_msg_data
2024: ,x_msg_count => l_msg_count

Line 2021: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2017: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2018: p_api_version => 1.0
2019: ,p_init_msg_list => FND_API.G_FALSE
2020: ,p_commit => FND_API.G_FALSE
2021: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2022: ,x_return_status => l_return_status
2023: ,x_msg_data => l_msg_data
2024: ,x_msg_count => l_msg_count
2025: ,p_control_rec => l_control_rec

Line 2030: IF l_return_status = FND_API.g_ret_sts_error THEN

2026: ,xp_line_tbl => l_line_tbl
2027: ,x_ldets_tbl => x_ldets_tbl
2028: ,x_related_lines_tbl => x_related_lines_tbl
2029: );
2030: IF l_return_status = FND_API.g_ret_sts_error THEN
2031: RAISE FND_API.g_exc_error;
2032: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2033: RAISE FND_API.g_exc_unexpected_error;
2034: END IF;

Line 2031: RAISE FND_API.g_exc_error;

2027: ,x_ldets_tbl => x_ldets_tbl
2028: ,x_related_lines_tbl => x_related_lines_tbl
2029: );
2030: IF l_return_status = FND_API.g_ret_sts_error THEN
2031: RAISE FND_API.g_exc_error;
2032: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2033: RAISE FND_API.g_exc_unexpected_error;
2034: END IF;
2035:

Line 2032: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2028: ,x_related_lines_tbl => x_related_lines_tbl
2029: );
2030: IF l_return_status = FND_API.g_ret_sts_error THEN
2031: RAISE FND_API.g_exc_error;
2032: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2033: RAISE FND_API.g_exc_unexpected_error;
2034: END IF;
2035:
2036: x_line_tbl := l_line_tbl;

Line 2033: RAISE FND_API.g_exc_unexpected_error;

2029: );
2030: IF l_return_status = FND_API.g_ret_sts_error THEN
2031: RAISE FND_API.g_exc_error;
2032: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2033: RAISE FND_API.g_exc_unexpected_error;
2034: END IF;
2035:
2036: x_line_tbl := l_line_tbl;
2037: END IF;

Line 2044: WHEN FND_API.g_exc_error THEN

2040: IF OZF_DEBUG_HIGH_ON THEN
2041: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2042: END IF;
2043: EXCEPTION
2044: WHEN FND_API.g_exc_error THEN
2045: ROLLBACK TO Get_Order_Price;
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: WHEN FND_API.g_exc_unexpected_error THEN
2048: ROLLBACK TO Get_Order_Price;

Line 2046: x_return_status := FND_API.G_RET_STS_ERROR;

2042: END IF;
2043: EXCEPTION
2044: WHEN FND_API.g_exc_error THEN
2045: ROLLBACK TO Get_Order_Price;
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: WHEN FND_API.g_exc_unexpected_error THEN
2048: ROLLBACK TO Get_Order_Price;
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2050: WHEN OTHERS THEN

Line 2047: WHEN FND_API.g_exc_unexpected_error THEN

2043: EXCEPTION
2044: WHEN FND_API.g_exc_error THEN
2045: ROLLBACK TO Get_Order_Price;
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: WHEN FND_API.g_exc_unexpected_error THEN
2048: ROLLBACK TO Get_Order_Price;
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2050: WHEN OTHERS THEN
2051: ROLLBACK TO Get_Order_Price;

Line 2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2045: ROLLBACK TO Get_Order_Price;
2046: x_return_status := FND_API.G_RET_STS_ERROR;
2047: WHEN FND_API.g_exc_unexpected_error THEN
2048: ROLLBACK TO Get_Order_Price;
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2050: WHEN OTHERS THEN
2051: ROLLBACK TO Get_Order_Price;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: IF OZF_UNEXP_ERROR THEN

Line 2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2048: ROLLBACK TO Get_Order_Price;
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2050: WHEN OTHERS THEN
2051: ROLLBACK TO Get_Order_Price;
2052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2053: IF OZF_UNEXP_ERROR THEN
2054: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2055: END IF;
2056: END Get_Order_Price;

Line 2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2069: ---------------------------------------------------------------------
2070: PROCEDURE Process_Order
2071: (
2072: p_api_version IN NUMBER
2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2076: ,p_resale_batch_id IN NUMBER
2077: ,x_return_status OUT NOCOPY VARCHAR2

Line 2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

2070: PROCEDURE Process_Order
2071: (
2072: p_api_version IN NUMBER
2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2076: ,p_resale_batch_id IN NUMBER
2077: ,x_return_status OUT NOCOPY VARCHAR2
2078: ,x_msg_data OUT NOCOPY VARCHAR2

Line 2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2071: (
2072: p_api_version IN NUMBER
2073: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2074: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2075: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2076: ,p_resale_batch_id IN NUMBER
2077: ,x_return_status OUT NOCOPY VARCHAR2
2078: ,x_msg_data OUT NOCOPY VARCHAR2
2079: ,x_msg_count OUT NOCOPY NUMBER

Line 2130: IF NOT FND_API.Compatible_API_Call (

2126: -- Standard begin of API savepoint
2127: SAVEPOINT Process_Order;
2128:
2129: -- Standard call to check FOR call compatibility.
2130: IF NOT FND_API.Compatible_API_Call (
2131: l_api_version,
2132: p_api_version,
2133: l_api_name,
2134: G_PKG_NAME)

Line 2136: RAISE FND_API.g_exc_unexpected_error;

2132: p_api_version,
2133: l_api_name,
2134: G_PKG_NAME)
2135: THEN
2136: RAISE FND_API.g_exc_unexpected_error;
2137: END IF;
2138:
2139: --Initialize message lISt if p_init_msg_list IS TRUE.
2140: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

Line 2140: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

2136: RAISE FND_API.g_exc_unexpected_error;
2137: END IF;
2138:
2139: --Initialize message lISt if p_init_msg_list IS TRUE.
2140: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
2141: FND_MSG_PUB.initialize;
2142: END IF;
2143:
2144: -- Debug Message

Line 2150: x_return_status := FND_API.G_RET_STS_SUCCESS;

2146: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
2147: END IF;
2148:
2149: -- Initialize API return status to sucess
2150: x_return_status := FND_API.G_RET_STS_SUCCESS;
2151:
2152: -- Move Delete logs to resale_pre_process
2153: -- Delete the logs for the current batch
2154: OZF_RESALE_COMMON_PVT.Delete_Log(

Line 2156: ,p_init_msg_list => FND_API.G_FALSE

2152: -- Move Delete logs to resale_pre_process
2153: -- Delete the logs for the current batch
2154: OZF_RESALE_COMMON_PVT.Delete_Log(
2155: p_api_version => 1.0
2156: ,p_init_msg_list => FND_API.G_FALSE
2157: ,p_commit => FND_API.G_FALSE
2158: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2159: ,p_resale_batch_id => p_resale_batch_id
2160: ,x_return_status => l_return_status

Line 2157: ,p_commit => FND_API.G_FALSE

2153: -- Delete the logs for the current batch
2154: OZF_RESALE_COMMON_PVT.Delete_Log(
2155: p_api_version => 1.0
2156: ,p_init_msg_list => FND_API.G_FALSE
2157: ,p_commit => FND_API.G_FALSE
2158: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2159: ,p_resale_batch_id => p_resale_batch_id
2160: ,x_return_status => l_return_status
2161: ,x_msg_count => l_msg_count

Line 2158: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2154: OZF_RESALE_COMMON_PVT.Delete_Log(
2155: p_api_version => 1.0
2156: ,p_init_msg_list => FND_API.G_FALSE
2157: ,p_commit => FND_API.G_FALSE
2158: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2159: ,p_resale_batch_id => p_resale_batch_id
2160: ,x_return_status => l_return_status
2161: ,x_msg_count => l_msg_count
2162: ,x_msg_data => l_msg_data

Line 2164: IF l_return_status = FND_API.g_ret_sts_error THEN

2160: ,x_return_status => l_return_status
2161: ,x_msg_count => l_msg_count
2162: ,x_msg_data => l_msg_data
2163: );
2164: IF l_return_status = FND_API.g_ret_sts_error THEN
2165: RAISE FND_API.g_exc_error;
2166: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2167: RAISE FND_API.g_exc_unexpected_error;
2168: END IF;

Line 2165: RAISE FND_API.g_exc_error;

2161: ,x_msg_count => l_msg_count
2162: ,x_msg_data => l_msg_data
2163: );
2164: IF l_return_status = FND_API.g_ret_sts_error THEN
2165: RAISE FND_API.g_exc_error;
2166: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2167: RAISE FND_API.g_exc_unexpected_error;
2168: END IF;
2169:

Line 2166: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2162: ,x_msg_data => l_msg_data
2163: );
2164: IF l_return_status = FND_API.g_ret_sts_error THEN
2165: RAISE FND_API.g_exc_error;
2166: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2167: RAISE FND_API.g_exc_unexpected_error;
2168: END IF;
2169:
2170: -- Check whether there IS a need to do inventory_verification

Line 2167: RAISE FND_API.g_exc_unexpected_error;

2163: );
2164: IF l_return_status = FND_API.g_ret_sts_error THEN
2165: RAISE FND_API.g_exc_error;
2166: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2167: RAISE FND_API.g_exc_unexpected_error;
2168: END IF;
2169:
2170: -- Check whether there IS a need to do inventory_verification
2171: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

Line 2185: ,p_init_msg_list => FND_API.G_FALSE

2181: CLOSE batch_info_csr;
2182:
2183: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
2184: p_api_version => 1.0
2185: ,p_init_msg_list => FND_API.G_FALSE
2186: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2187: ,p_resale_batch_id => p_resale_batch_id
2188: ,p_start_date => l_report_start_date
2189: ,p_end_date => l_report_end_date

Line 2186: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2182:
2183: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
2184: p_api_version => 1.0
2185: ,p_init_msg_list => FND_API.G_FALSE
2186: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2187: ,p_resale_batch_id => p_resale_batch_id
2188: ,p_start_date => l_report_start_date
2189: ,p_end_date => l_report_end_date
2190: ,x_return_status => l_return_status

Line 2194: IF l_return_status = FND_API.g_ret_sts_error THEN

2190: ,x_return_status => l_return_status
2191: ,x_msg_count => l_msg_count
2192: ,x_msg_data => l_msg_data
2193: );
2194: IF l_return_status = FND_API.g_ret_sts_error THEN
2195: RAISE FND_API.g_exc_error;
2196: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;

Line 2195: RAISE FND_API.g_exc_error;

2191: ,x_msg_count => l_msg_count
2192: ,x_msg_data => l_msg_data
2193: );
2194: IF l_return_status = FND_API.g_ret_sts_error THEN
2195: RAISE FND_API.g_exc_error;
2196: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: END IF;

Line 2196: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2192: ,x_msg_data => l_msg_data
2193: );
2194: IF l_return_status = FND_API.g_ret_sts_error THEN
2195: RAISE FND_API.g_exc_error;
2196: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: END IF;
2200:

Line 2197: RAISE FND_API.g_exc_unexpected_error;

2193: );
2194: IF l_return_status = FND_API.g_ret_sts_error THEN
2195: RAISE FND_API.g_exc_error;
2196: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2197: RAISE FND_API.g_exc_unexpected_error;
2198: END IF;
2199: END IF;
2200:
2201:

Line 2240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2236: );
2237: --
2238: -- log errors and dispute line if there are any error in processing the order
2239: -- Continue to next order in case of errors
2240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2241: IF l_line_tbl.EXISTS(1) THEN
2242: FOR j in 1..l_line_tbl.LAST
2243: LOOP
2244:

Line 2259: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2255: p_column_name => NULL,
2256: p_column_value => NULL,
2257: x_return_status => l_return_status);
2258: --
2259: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;

Line 2260: RAISE FND_API.g_exc_error;

2256: p_column_value => NULL,
2257: x_return_status => l_return_status);
2258: --
2259: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;
2264: --

Line 2261: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2257: x_return_status => l_return_status);
2258: --
2259: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;
2264: --
2265: END LOOP;

Line 2262: RAISE FND_API.g_exc_unexpected_error;

2258: --
2259: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2260: RAISE FND_API.g_exc_error;
2261: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2262: RAISE FND_API.g_exc_unexpected_error;
2263: END IF;
2264: --
2265: END LOOP;
2266: IF OZF_DEBUG_LOW_ON THEN

Line 2277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2273: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
2274: x_return_status => l_return_status
2275: );
2276: --
2277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2278: RAISE FND_API.g_exc_error;
2279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2280: RAISE FND_API.g_exc_unexpected_error;
2281: END IF;

Line 2278: RAISE FND_API.g_exc_error;

2274: x_return_status => l_return_status
2275: );
2276: --
2277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2278: RAISE FND_API.g_exc_error;
2279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2280: RAISE FND_API.g_exc_unexpected_error;
2281: END IF;
2282: IF OZF_DEBUG_LOW_ON THEN

Line 2279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2275: );
2276: --
2277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2278: RAISE FND_API.g_exc_error;
2279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2280: RAISE FND_API.g_exc_unexpected_error;
2281: END IF;
2282: IF OZF_DEBUG_LOW_ON THEN
2283: OZF_UTILITY_PVT.debug_message('/*--- Get order price failed ---*/');

Line 2280: RAISE FND_API.g_exc_unexpected_error;

2276: --
2277: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2278: RAISE FND_API.g_exc_error;
2279: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2280: RAISE FND_API.g_exc_unexpected_error;
2281: END IF;
2282: IF OZF_DEBUG_LOW_ON THEN
2283: OZF_UTILITY_PVT.debug_message('/*--- Get order price failed ---*/');
2284: END IF;

Line 2287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2283: OZF_UTILITY_PVT.debug_message('/*--- Get order price failed ---*/');
2284: END IF;
2285: GOTO END_LOOP;
2286: ELSE
2287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.g_exc_error;
2289: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE FND_API.g_exc_unexpected_error;
2291: END IF;

Line 2288: RAISE FND_API.g_exc_error;

2284: END IF;
2285: GOTO END_LOOP;
2286: ELSE
2287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.g_exc_error;
2289: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE FND_API.g_exc_unexpected_error;
2291: END IF;
2292: END IF;

Line 2289: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2285: GOTO END_LOOP;
2286: ELSE
2287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.g_exc_error;
2289: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE FND_API.g_exc_unexpected_error;
2291: END IF;
2292: END IF;
2293: END IF; -- not success status

Line 2290: RAISE FND_API.g_exc_unexpected_error;

2286: ELSE
2287: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2288: RAISE FND_API.g_exc_error;
2289: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2290: RAISE FND_API.g_exc_unexpected_error;
2291: END IF;
2292: END IF;
2293: END IF; -- not success status
2294:

Line 2309: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2305: x_return_status => l_return_status
2306: );
2307:
2308: -- insert error messages into error stack
2309: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2310: FOR j in 1..l_line_tbl.LAST
2311: LOOP
2312: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
2313: p_id_value => l_line_tbl(j).chargeback_int_id,

Line 2320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2316: p_column_name => NULL,
2317: p_column_value => NULL,
2318: x_return_status => l_return_status);
2319: --
2320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2321: RAISE FND_API.g_exc_error;
2322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2323: RAISE FND_API.g_exc_unexpected_error;
2324: END IF;

Line 2321: RAISE FND_API.g_exc_error;

2317: p_column_value => NULL,
2318: x_return_status => l_return_status);
2319: --
2320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2321: RAISE FND_API.g_exc_error;
2322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2323: RAISE FND_API.g_exc_unexpected_error;
2324: END IF;
2325: --

Line 2322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2318: x_return_status => l_return_status);
2319: --
2320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2321: RAISE FND_API.g_exc_error;
2322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2323: RAISE FND_API.g_exc_unexpected_error;
2324: END IF;
2325: --
2326: END LOOP;

Line 2323: RAISE FND_API.g_exc_unexpected_error;

2319: --
2320: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2321: RAISE FND_API.g_exc_error;
2322: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2323: RAISE FND_API.g_exc_unexpected_error;
2324: END IF;
2325: --
2326: END LOOP;
2327:

Line 2348: RAISE FND_API.g_exc_unexpected_error;

2344: AND resale_batch_id = p_resale_batch_id;
2345: EXCEPTION
2346: WHEN OTHERS THEN
2347: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
2348: RAISE FND_API.g_exc_unexpected_error;
2349: END;
2350: --
2351: IF OZF_DEBUG_LOW_ON THEN
2352: OZF_UTILITY_PVT.debug_message('/*--- Process Pricing Result Failed ---*/');

Line 2385: ,p_init_msg_list => FND_API.G_FALSE

2381:
2382: -- Update Chargeback header with processing detail
2383: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
2384: p_api_version => 1.0
2385: ,p_init_msg_list => FND_API.G_FALSE
2386: ,p_commit => FND_API.G_FALSE
2387: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2388: ,p_resale_batch_id => p_resale_batch_id
2389: ,x_return_status => l_return_status

Line 2386: ,p_commit => FND_API.G_FALSE

2382: -- Update Chargeback header with processing detail
2383: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
2384: p_api_version => 1.0
2385: ,p_init_msg_list => FND_API.G_FALSE
2386: ,p_commit => FND_API.G_FALSE
2387: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2388: ,p_resale_batch_id => p_resale_batch_id
2389: ,x_return_status => l_return_status
2390: ,x_msg_data => l_msg_data

Line 2387: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2383: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
2384: p_api_version => 1.0
2385: ,p_init_msg_list => FND_API.G_FALSE
2386: ,p_commit => FND_API.G_FALSE
2387: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2388: ,p_resale_batch_id => p_resale_batch_id
2389: ,x_return_status => l_return_status
2390: ,x_msg_data => l_msg_data
2391: ,x_msg_count => l_msg_count

Line 2393: IF l_return_status = FND_API.g_ret_sts_error THEN

2389: ,x_return_status => l_return_status
2390: ,x_msg_data => l_msg_data
2391: ,x_msg_count => l_msg_count
2392: );
2393: IF l_return_status = FND_API.g_ret_sts_error THEN
2394: RAISE FND_API.g_exc_error;
2395: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2396: RAISE FND_API.g_exc_unexpected_error;
2397: END IF;

Line 2394: RAISE FND_API.g_exc_error;

2390: ,x_msg_data => l_msg_data
2391: ,x_msg_count => l_msg_count
2392: );
2393: IF l_return_status = FND_API.g_ret_sts_error THEN
2394: RAISE FND_API.g_exc_error;
2395: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2396: RAISE FND_API.g_exc_unexpected_error;
2397: END IF;
2398:

Line 2395: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2391: ,x_msg_count => l_msg_count
2392: );
2393: IF l_return_status = FND_API.g_ret_sts_error THEN
2394: RAISE FND_API.g_exc_error;
2395: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2396: RAISE FND_API.g_exc_unexpected_error;
2397: END IF;
2398:
2399: -- Debug Message

Line 2396: RAISE FND_API.g_exc_unexpected_error;

2392: );
2393: IF l_return_status = FND_API.g_ret_sts_error THEN
2394: RAISE FND_API.g_exc_error;
2395: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2396: RAISE FND_API.g_exc_unexpected_error;
2397: END IF;
2398:
2399: -- Debug Message
2400: IF OZF_DEBUG_HIGH_ON THEN

Line 2405: p_encoded => FND_API.G_FALSE,

2401: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2402: END IF;
2403: --Standard call to get message count AND if count=1, get the message
2404: FND_MSG_PUB.Count_and_Get (
2405: p_encoded => FND_API.G_FALSE,
2406: p_count => x_msg_count,
2407: p_data => x_msg_data
2408: );
2409: EXCEPTION

Line 2410: WHEN FND_API.g_exc_error THEN

2406: p_count => x_msg_count,
2407: p_data => x_msg_data
2408: );
2409: EXCEPTION
2410: WHEN FND_API.g_exc_error THEN
2411: ROLLBACK TO Process_Order;
2412: x_return_status := FND_API.G_RET_STS_ERROR;
2413: -- Standard call to get message count AND IF count=1, get the message
2414: FND_MSG_PUB.Count_and_Get (

Line 2412: x_return_status := FND_API.G_RET_STS_ERROR;

2408: );
2409: EXCEPTION
2410: WHEN FND_API.g_exc_error THEN
2411: ROLLBACK TO Process_Order;
2412: x_return_status := FND_API.G_RET_STS_ERROR;
2413: -- Standard call to get message count AND IF count=1, get the message
2414: FND_MSG_PUB.Count_and_Get (
2415: p_encoded => FND_API.G_FALSE,
2416: p_count => x_msg_count,

Line 2415: p_encoded => FND_API.G_FALSE,

2411: ROLLBACK TO Process_Order;
2412: x_return_status := FND_API.G_RET_STS_ERROR;
2413: -- Standard call to get message count AND IF count=1, get the message
2414: FND_MSG_PUB.Count_and_Get (
2415: p_encoded => FND_API.G_FALSE,
2416: p_count => x_msg_count,
2417: p_data => x_msg_data
2418: );
2419: WHEN FND_API.g_exc_unexpected_error THEN

Line 2419: WHEN FND_API.g_exc_unexpected_error THEN

2415: p_encoded => FND_API.G_FALSE,
2416: p_count => x_msg_count,
2417: p_data => x_msg_data
2418: );
2419: WHEN FND_API.g_exc_unexpected_error THEN
2420: ROLLBACK TO Process_Order;
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: -- Standard call to get message count AND IF count=1, get the message
2423: FND_MSG_PUB.Count_and_Get (

Line 2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2417: p_data => x_msg_data
2418: );
2419: WHEN FND_API.g_exc_unexpected_error THEN
2420: ROLLBACK TO Process_Order;
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: -- Standard call to get message count AND IF count=1, get the message
2423: FND_MSG_PUB.Count_and_Get (
2424: p_encoded => FND_API.G_FALSE,
2425: p_count => x_msg_count,

Line 2424: p_encoded => FND_API.G_FALSE,

2420: ROLLBACK TO Process_Order;
2421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2422: -- Standard call to get message count AND IF count=1, get the message
2423: FND_MSG_PUB.Count_and_Get (
2424: p_encoded => FND_API.G_FALSE,
2425: p_count => x_msg_count,
2426: p_data => x_msg_data
2427: );
2428: WHEN OTHERS THEN

Line 2430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2426: p_data => x_msg_data
2427: );
2428: WHEN OTHERS THEN
2429: ROLLBACK TO Process_Order;
2430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2431: IF OZF_UNEXP_ERROR THEN
2432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2433: END IF;
2434: -- Standard call to get message count AND IF count=1, get the message

Line 2436: p_encoded => FND_API.G_FALSE,

2432: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2433: END IF;
2434: -- Standard call to get message count AND IF count=1, get the message
2435: FND_MSG_PUB.Count_and_Get (
2436: p_encoded => FND_API.G_FALSE,
2437: p_count => x_msg_count,
2438: p_data => x_msg_data
2439: );
2440: END Process_Order;