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 62: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

58: --
59: ---------------------------------------------------------------------
60: PROCEDURE Initiate_Payment (
61: p_api_version IN NUMBER
62: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
63: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
64: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65: ,p_resale_batch_id IN NUMBER
66: ,x_return_status OUT NOCOPY VARCHAR2

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

59: ---------------------------------------------------------------------
60: PROCEDURE Initiate_Payment (
61: p_api_version IN NUMBER
62: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
63: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
64: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65: ,p_resale_batch_id IN NUMBER
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_data OUT NOCOPY VARCHAR2

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

60: PROCEDURE Initiate_Payment (
61: p_api_version IN NUMBER
62: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
63: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
64: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
65: ,p_resale_batch_id IN NUMBER
66: ,x_return_status OUT NOCOPY VARCHAR2
67: ,x_msg_data OUT NOCOPY VARCHAR2
68: ,x_msg_count OUT NOCOPY NUMBER

Line 330: IF NOT FND_API.Compatible_API_Call (

326: BEGIN
327: -- Standard begin of API savepoint
328: SAVEPOINT Initiate_Payment;
329: -- Standard call to check FOR call compatibility.
330: IF NOT FND_API.Compatible_API_Call (
331: l_api_version,
332: p_api_version,
333: l_api_name,
334: G_PKG_NAME)

Line 336: RAISE FND_API.g_exc_unexpected_error;

332: p_api_version,
333: l_api_name,
334: G_PKG_NAME)
335: THEN
336: RAISE FND_API.g_exc_unexpected_error;
337: END IF;
338:
339: --Initialize message if p_init_msg_list IS TRUE.
340: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

Line 340: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

336: RAISE FND_API.g_exc_unexpected_error;
337: END IF;
338:
339: --Initialize message if p_init_msg_list IS TRUE.
340: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343:
344: -- Debug Message

Line 350: x_return_status := FND_API.G_RET_STS_SUCCESS;

346: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
347: END IF;
348:
349: -- Initialize API return status to sucess
350: x_return_status := FND_API.G_RET_STS_SUCCESS;
351:
352: OPEN batch_info_csr(p_resale_batch_id);
353: FETCH batch_info_csr INTO l_batch_status,
354: l_batch_type,

Line 385: RAISE FND_API.g_exc_error;

381:
382: IF l_batch_status <> OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN
383: -- Only DISPUTED AND PROCESSED batch can be paid.
384: OZF_UTILITY_PVT.error_message('OZF_RESALE_WRONG_STAUS_TO_PAY');
385: RAISE FND_API.g_exc_error;
386: END IF;
387:
388: OPEN open_line_count_csr(p_resale_batch_id);
389: FETCH open_line_count_csr INTO l_count;

Line 395: RAISE FND_API.g_exc_error;

391:
392: IF l_count IS NOT NULL AND l_count <> 0 THEN
393: --Can not pay if there is an OPEN line
394: OZF_UTILITY_PVT.error_message('OZF_RESALE_OPEN_LINE_EXIST');
395: RAISE FND_API.g_exc_error;
396: END IF;
397:
398:
399: IF l_batch_status = OZF_RESALE_COMMON_PVT.G_BATCH_PENDING_PAYMENT THEN

Line 414: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

410: ,p_column_name => NULL
411: ,p_column_value => NULL
412: ,x_return_status => l_return_status
413: );
414: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
415: RAISE FND_API.G_EXC_ERROR;
416: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;

Line 415: RAISE FND_API.G_EXC_ERROR;

411: ,p_column_value => NULL
412: ,x_return_status => l_return_status
413: );
414: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
415: RAISE FND_API.G_EXC_ERROR;
416: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:

Line 416: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

412: ,x_return_status => l_return_status
413: );
414: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
415: RAISE FND_API.G_EXC_ERROR;
416: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:
420: UPDATE ozf_resale_batches_all

Line 417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

413: );
414: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
415: RAISE FND_API.G_EXC_ERROR;
416: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
417: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:
420: UPDATE ozf_resale_batches_all
421: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED

Line 425: --RAISE FND_API.g_exc_error;

421: SET status_code = OZF_RESALE_COMMON_PVT.G_BATCH_DISPUTED
422: WHERE resale_batch_id = p_resale_batch_id;
423:
424: RAISE error_no_rollback;
425: --RAISE FND_API.g_exc_error;
426: END IF;
427:
428: -- For Bug#8867381
429: OPEN old_funds_csr(l_chargeback_fund_id);

Line 473: ,p_init_msg_list => FND_API.G_FALSE

469:
470: IF l_inventory_tracking = 'T' THEN
471: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
472: p_api_version => 1.0
473: ,p_init_msg_list => FND_API.G_FALSE
474: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
475: ,p_resale_batch_id => p_resale_batch_id
476: ,p_start_date => l_report_start_date
477: ,p_end_date => l_report_end_date

Line 474: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

470: IF l_inventory_tracking = 'T' THEN
471: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
472: p_api_version => 1.0
473: ,p_init_msg_list => FND_API.G_FALSE
474: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
475: ,p_resale_batch_id => p_resale_batch_id
476: ,p_start_date => l_report_start_date
477: ,p_end_date => l_report_end_date
478: ,x_return_status => l_return_status

Line 482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

478: ,x_return_status => l_return_status
479: ,x_msg_count => l_msg_count
480: ,x_msg_data => l_msg_data
481: );
482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
483: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
484: RAISE FND_API.G_EXC_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
486: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');

Line 484: RAISE FND_API.G_EXC_ERROR;

480: ,x_msg_data => l_msg_data
481: );
482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
483: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
484: RAISE FND_API.G_EXC_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
486: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;

Line 485: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

481: );
482: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
483: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
484: RAISE FND_API.G_EXC_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
486: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489: END IF;

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
484: RAISE FND_API.G_EXC_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
486: OZF_UTILITY_PVT.error_message('OZF_RESALE_INIT_INV_TMP_ERR');
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: END IF;
489: END IF;
490:
491: OPEN end_cust_relation_flag_csr;

Line 500: ,p_init_msg_list => FND_API.G_FALSE

496: --Bug# 8489216 fixed by ateotia(+)
497: --Moved the logic of End Customer/Bill_To/Ship_To Party creation to Common Resale API.
498: OZF_RESALE_COMMON_PVT.Derive_Orig_Parties
499: ( p_api_version => 1.0
500: ,p_init_msg_list => FND_API.G_FALSE
501: ,p_commit => FND_API.G_FALSE
502: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
503: ,p_resale_batch_id => p_resale_batch_id
504: ,p_partner_party_id => l_partner_party_id

Line 501: ,p_commit => FND_API.G_FALSE

497: --Moved the logic of End Customer/Bill_To/Ship_To Party creation to Common Resale API.
498: OZF_RESALE_COMMON_PVT.Derive_Orig_Parties
499: ( p_api_version => 1.0
500: ,p_init_msg_list => FND_API.G_FALSE
501: ,p_commit => FND_API.G_FALSE
502: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
503: ,p_resale_batch_id => p_resale_batch_id
504: ,p_partner_party_id => l_partner_party_id
505: ,x_return_status => l_return_status

Line 502: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

498: OZF_RESALE_COMMON_PVT.Derive_Orig_Parties
499: ( p_api_version => 1.0
500: ,p_init_msg_list => FND_API.G_FALSE
501: ,p_commit => FND_API.G_FALSE
502: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
503: ,p_resale_batch_id => p_resale_batch_id
504: ,p_partner_party_id => l_partner_party_id
505: ,x_return_status => l_return_status
506: ,x_msg_data => l_msg_data

Line 509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

505: ,x_return_status => l_return_status
506: ,x_msg_data => l_msg_data
507: ,x_msg_count => l_msg_count
508: );
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;

Line 510: RAISE FND_API.G_EXC_ERROR;

506: ,x_msg_data => l_msg_data
507: ,x_msg_count => l_msg_count
508: );
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: /*

Line 511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

507: ,x_msg_count => l_msg_count
508: );
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: /*
515: -- check bill_to customer

Line 512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

508: );
509: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
510: RAISE FND_API.G_EXC_ERROR;
511: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
513: END IF;
514: /*
515: -- check bill_to customer
516: OPEN csr_orig_billto_cust(p_resale_batch_id);

Line 536: ,p_init_msg_list => FND_API.G_FALSE

532: l_new_party_rec.site_Use_Code := 'BILL_TO';
533:
534: OZF_RESALE_COMMON_PVT.Create_Party(
535: p_api_version => 1.0
536: ,p_init_msg_list => FND_API.G_FALSE
537: ,p_commit => FND_API.G_FALSE
538: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
539: ,px_party_rec => l_new_party_rec
540: ,x_return_status => l_return_status

Line 537: ,p_commit => FND_API.G_FALSE

533:
534: OZF_RESALE_COMMON_PVT.Create_Party(
535: p_api_version => 1.0
536: ,p_init_msg_list => FND_API.G_FALSE
537: ,p_commit => FND_API.G_FALSE
538: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
539: ,px_party_rec => l_new_party_rec
540: ,x_return_status => l_return_status
541: ,x_msg_data => l_msg_data

Line 538: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

534: OZF_RESALE_COMMON_PVT.Create_Party(
535: p_api_version => 1.0
536: ,p_init_msg_list => FND_API.G_FALSE
537: ,p_commit => FND_API.G_FALSE
538: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
539: ,px_party_rec => l_new_party_rec
540: ,x_return_status => l_return_status
541: ,x_msg_data => l_msg_data
542: ,x_msg_count => l_msg_count

Line 544: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

540: ,x_return_status => l_return_status
541: ,x_msg_data => l_msg_data
542: ,x_msg_count => l_msg_count
543: );
544: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;

Line 545: RAISE FND_API.G_EXC_ERROR;

541: ,x_msg_data => l_msg_data
542: ,x_msg_count => l_msg_count
543: );
544: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:

Line 546: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

542: ,x_msg_count => l_msg_count
543: );
544: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:
550: UPDATE ozf_resale_lines_int_all

Line 547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

543: );
544: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
548: END IF;
549:
550: UPDATE ozf_resale_lines_int_all
551: SET bill_to_party_id = l_new_party_rec.party_id

Line 591: ,p_init_msg_list => FND_API.G_FALSE

587: l_new_party_rec.site_use_code := l_orig_end_cust_tbl(i).end_cust_site_use_code;
588:
589: OZF_RESALE_COMMON_PVT.Create_Party
590: ( p_api_version => 1.0
591: ,p_init_msg_list => FND_API.G_FALSE
592: ,p_commit => FND_API.G_FALSE
593: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
594: ,px_party_rec => l_new_party_rec
595: ,x_return_status => l_return_status

Line 592: ,p_commit => FND_API.G_FALSE

588:
589: OZF_RESALE_COMMON_PVT.Create_Party
590: ( p_api_version => 1.0
591: ,p_init_msg_list => FND_API.G_FALSE
592: ,p_commit => FND_API.G_FALSE
593: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
594: ,px_party_rec => l_new_party_rec
595: ,x_return_status => l_return_status
596: ,x_msg_data => l_msg_data

Line 593: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

589: OZF_RESALE_COMMON_PVT.Create_Party
590: ( p_api_version => 1.0
591: ,p_init_msg_list => FND_API.G_FALSE
592: ,p_commit => FND_API.G_FALSE
593: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
594: ,px_party_rec => l_new_party_rec
595: ,x_return_status => l_return_status
596: ,x_msg_data => l_msg_data
597: ,x_msg_count => l_msg_count

Line 599: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

595: ,x_return_status => l_return_status
596: ,x_msg_data => l_msg_data
597: ,x_msg_count => l_msg_count
598: );
599: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;

Line 600: RAISE FND_API.G_EXC_ERROR;

596: ,x_msg_data => l_msg_data
597: ,x_msg_count => l_msg_count
598: );
599: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:

Line 601: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

597: ,x_msg_count => l_msg_count
598: );
599: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: UPDATE ozf_resale_lines_int_all

Line 602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

598: );
599: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
603: END IF;
604:
605: UPDATE ozf_resale_lines_int_all
606: SET end_cust_party_id = l_new_party_rec.party_id

Line 745: ,p_init_msg_list => FND_API.G_FALSE

741: l_inventory_tracking = 'T' THEN
742: -- Check inventory level first
743: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
744: p_api_version => 1.0
745: ,p_init_msg_list => FND_API.G_FALSE
746: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
747: ,p_line_int_rec => l_line_int_rec
748: ,x_valid => l_inventory_level_valid
749: ,x_return_status => l_return_status

Line 746: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

742: -- Check inventory level first
743: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
744: p_api_version => 1.0
745: ,p_init_msg_list => FND_API.G_FALSE
746: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
747: ,p_line_int_rec => l_line_int_rec
748: ,x_valid => l_inventory_level_valid
749: ,x_return_status => l_return_status
750: ,x_msg_count => l_msg_count

Line 784: ,p_init_msg_list => FND_API.G_FALSE

780: -- Determin header id
781: IF l_create_order_header THEN
782: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
783: p_api_version => 1
784: ,p_init_msg_list => FND_API.G_FALSE
785: ,p_commit => FND_API.G_FALSE
786: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
787: ,p_line_int_rec => l_line_int_rec
788: ,x_header_id => l_header_id

Line 785: ,p_commit => FND_API.G_FALSE

781: IF l_create_order_header THEN
782: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
783: p_api_version => 1
784: ,p_init_msg_list => FND_API.G_FALSE
785: ,p_commit => FND_API.G_FALSE
786: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
787: ,p_line_int_rec => l_line_int_rec
788: ,x_header_id => l_header_id
789: ,x_return_status => l_return_status

Line 786: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

782: OZF_RESALE_COMMON_PVT.Insert_Resale_Header(
783: p_api_version => 1
784: ,p_init_msg_list => FND_API.G_FALSE
785: ,p_commit => FND_API.G_FALSE
786: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
787: ,p_line_int_rec => l_line_int_rec
788: ,x_header_id => l_header_id
789: ,x_return_status => l_return_status
790: ,x_msg_data => l_msg_data

Line 793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

789: ,x_return_status => l_return_status
790: ,x_msg_data => l_msg_data
791: ,x_msg_count => l_msg_count
792: );
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;

Line 794: RAISE FND_API.G_EXC_ERROR;

790: ,x_msg_data => l_msg_data
791: ,x_msg_count => l_msg_count
792: );
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798: ELSE

Line 795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

791: ,x_msg_count => l_msg_count
792: );
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798: ELSE
799: NULL;

Line 796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

792: );
793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
794: RAISE FND_API.G_EXC_ERROR;
795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
797: END IF;
798: ELSE
799: NULL;
800: -- We should have the l_header_id FROM at the order level

Line 818: ,p_init_msg_list => FND_API.G_FALSE

814:
815: -- No problem so far. Insert INTO batch_lines TABLE
816: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
817: p_api_version => 1
818: ,p_init_msg_list => FND_API.G_FALSE
819: ,p_commit => FND_API.G_FALSE
820: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
821: ,p_line_int_rec => l_line_int_rec
822: ,p_header_id => l_header_id

Line 819: ,p_commit => FND_API.G_FALSE

815: -- No problem so far. Insert INTO batch_lines TABLE
816: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
817: p_api_version => 1
818: ,p_init_msg_list => FND_API.G_FALSE
819: ,p_commit => FND_API.G_FALSE
820: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
821: ,p_line_int_rec => l_line_int_rec
822: ,p_header_id => l_header_id
823: ,x_line_id => l_line_id

Line 820: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

816: OZF_RESALE_COMMON_PVT.Insert_Resale_Line(
817: p_api_version => 1
818: ,p_init_msg_list => FND_API.G_FALSE
819: ,p_commit => FND_API.G_FALSE
820: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
821: ,p_line_int_rec => l_line_int_rec
822: ,p_header_id => l_header_id
823: ,x_line_id => l_line_id
824: ,x_return_status => l_return_status

Line 828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

824: ,x_return_status => l_return_status
825: ,x_msg_data => l_msg_data
826: ,x_msg_count => l_msg_count
827: );
828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
829: RAISE FND_API.G_EXC_ERROR;
830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;

Line 829: RAISE FND_API.G_EXC_ERROR;

825: ,x_msg_data => l_msg_data
826: ,x_msg_count => l_msg_count
827: );
828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
829: RAISE FND_API.G_EXC_ERROR;
830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833:

Line 830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

826: ,x_msg_count => l_msg_count
827: );
828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
829: RAISE FND_API.G_EXC_ERROR;
830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833:
834: -- FOR processed order line, I need to create a transaction FOR it.

Line 831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

827: );
828: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
829: RAISE FND_API.G_EXC_ERROR;
830: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832: END IF;
833:
834: -- FOR processed order line, I need to create a transaction FOR it.
835: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (

Line 837: ,p_init_msg_list => FND_API.G_FALSE

833:
834: -- FOR processed order line, I need to create a transaction FOR it.
835: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
836: p_api_version => 1.0
837: ,p_init_msg_list => FND_API.G_FALSE
838: ,p_commit => FND_API.G_FALSE
839: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
840: ,p_line_int_rec => l_line_int_rec
841: ,p_header_id => l_header_id

Line 838: ,p_commit => FND_API.G_FALSE

834: -- FOR processed order line, I need to create a transaction FOR it.
835: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
836: p_api_version => 1.0
837: ,p_init_msg_list => FND_API.G_FALSE
838: ,p_commit => FND_API.G_FALSE
839: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
840: ,p_line_int_rec => l_line_int_rec
841: ,p_header_id => l_header_id
842: ,p_line_id => l_line_id

Line 839: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

835: OZF_RESALE_COMMON_PVT.Create_Sales_Transaction (
836: p_api_version => 1.0
837: ,p_init_msg_list => FND_API.G_FALSE
838: ,p_commit => FND_API.G_FALSE
839: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
840: ,p_line_int_rec => l_line_int_rec
841: ,p_header_id => l_header_id
842: ,p_line_id => l_line_id
843: ,x_sales_transaction_id => l_sales_transaction_id

Line 848: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

844: ,x_return_status => l_return_status
845: ,x_msg_data => l_msg_data
846: ,x_msg_count => l_msg_count
847: );
848: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
849: RAISE FND_API.G_EXC_ERROR;
850: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;

Line 849: RAISE FND_API.G_EXC_ERROR;

845: ,x_msg_data => l_msg_data
846: ,x_msg_count => l_msg_count
847: );
848: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
849: RAISE FND_API.G_EXC_ERROR;
850: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853: --

Line 850: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

846: ,x_msg_count => l_msg_count
847: );
848: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
849: RAISE FND_API.G_EXC_ERROR;
850: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853: --
854:

Line 851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

847: );
848: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
849: RAISE FND_API.G_EXC_ERROR;
850: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
852: END IF;
853: --
854:
855: -- Bug 4380203 Fixing (+)

Line 861: ,p_init_msg_list => FND_API.G_FALSE

857: /*
858: IF l_inventory_tracking = 'T' THEN
859: OZF_SALES_TRANSACTIONS_PVT.Update_Inventory_Tmp(
860: p_api_version => 1.0
861: ,p_init_msg_list => FND_API.G_FALSE
862: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
863: ,p_sales_transaction_id => l_sales_transaction_id
864: ,x_return_status => l_return_status
865: ,x_msg_data => l_msg_data

Line 862: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

858: IF l_inventory_tracking = 'T' THEN
859: OZF_SALES_TRANSACTIONS_PVT.Update_Inventory_Tmp(
860: p_api_version => 1.0
861: ,p_init_msg_list => FND_API.G_FALSE
862: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
863: ,p_sales_transaction_id => l_sales_transaction_id
864: ,x_return_status => l_return_status
865: ,x_msg_data => l_msg_data
866: ,x_msg_count => l_msg_count

Line 868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

864: ,x_return_status => l_return_status
865: ,x_msg_data => l_msg_data
866: ,x_msg_count => l_msg_count
867: );
868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END IF;

Line 869: RAISE FND_API.G_EXC_ERROR;

865: ,x_msg_data => l_msg_data
866: ,x_msg_count => l_msg_count
867: );
868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END IF;
873: --

Line 870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

866: ,x_msg_count => l_msg_count
867: );
868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END IF;
873: --
874: END IF;

Line 871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

867: );
868: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
869: RAISE FND_API.G_EXC_ERROR;
870: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
871: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
872: END IF;
873: --
874: END IF;
875: */

Line 896: ,p_init_msg_list => FND_API.G_FALSE

892: -- -- only create mapping FOR the lines that are processed or
893: -- -- duplicated, yet the adjustment IS new then
894: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
895: p_api_version => 1
896: ,p_init_msg_list => FND_API.G_FALSE
897: ,p_commit => FND_API.G_FALSE
898: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
899: ,p_resale_batch_id => p_resale_batch_id
900: ,p_line_id => l_line_id

Line 897: ,p_commit => FND_API.G_FALSE

893: -- -- duplicated, yet the adjustment IS new then
894: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
895: p_api_version => 1
896: ,p_init_msg_list => FND_API.G_FALSE
897: ,p_commit => FND_API.G_FALSE
898: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
899: ,p_resale_batch_id => p_resale_batch_id
900: ,p_line_id => l_line_id
901: ,x_return_status => l_return_status

Line 898: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

894: OZF_RESALE_COMMON_PVT.Insert_Resale_Line_Mapping(
895: p_api_version => 1
896: ,p_init_msg_list => FND_API.G_FALSE
897: ,p_commit => FND_API.G_FALSE
898: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
899: ,p_resale_batch_id => p_resale_batch_id
900: ,p_line_id => l_line_id
901: ,x_return_status => l_return_status
902: ,x_msg_data => l_msg_data

Line 905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

901: ,x_return_status => l_return_status
902: ,x_msg_data => l_msg_data
903: ,x_msg_count => l_msg_count
904: );
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;

Line 906: RAISE FND_API.G_EXC_ERROR;

902: ,x_msg_data => l_msg_data
903: ,x_msg_count => l_msg_count
904: );
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: END IF;

Line 907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

903: ,x_msg_count => l_msg_count
904: );
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: END IF;
911:

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: );
905: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
906: RAISE FND_API.G_EXC_ERROR;
907: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: END IF;
910: END IF;
911:
912: -- For Bug#8867381, introduced p_use_fund_staging_tables for staging table impln of chargeback flow

Line 924: ,p_init_msg_LIST => FND_API.G_FALSE

920: l_accrual_flag = 'T' THEN
921: --Bug# 8632964 fixed by anuj and muthu (-)
922: OZF_RESALE_COMMON_PVT.Create_Utilization(
923: p_api_version => 1.0
924: ,p_init_msg_LIST => FND_API.G_FALSE
925: ,p_commit => FND_API.G_FALSE
926: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
927: ,p_line_int_rec => l_line_int_rec
928: ,p_fund_id => l_chargeback_fund_id

Line 925: ,p_commit => FND_API.G_FALSE

921: --Bug# 8632964 fixed by anuj and muthu (-)
922: OZF_RESALE_COMMON_PVT.Create_Utilization(
923: p_api_version => 1.0
924: ,p_init_msg_LIST => FND_API.G_FALSE
925: ,p_commit => FND_API.G_FALSE
926: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
927: ,p_line_int_rec => l_line_int_rec
928: ,p_fund_id => l_chargeback_fund_id
929: ,p_fund_int_rec => l_fund_int_rec

Line 926: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL

922: OZF_RESALE_COMMON_PVT.Create_Utilization(
923: p_api_version => 1.0
924: ,p_init_msg_LIST => FND_API.G_FALSE
925: ,p_commit => FND_API.G_FALSE
926: ,p_validation_level=> FND_API.G_VALID_LEVEL_FULL
927: ,p_line_int_rec => l_line_int_rec
928: ,p_fund_id => l_chargeback_fund_id
929: ,p_fund_int_rec => l_fund_int_rec
930: ,p_use_fund_staging_tables => l_use_fund_staging_tables

Line 942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

938: ,px_ozf_act_budgets_tbl => ozf_act_budgets_tbl
939: ,px_ozf_funds_old_rectype => ozf_funds_old_rectype
940: ,px_ozf_funds_new_tbl => ozf_funds_new_tbl
941: );
942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END IF;

Line 943: RAISE FND_API.G_EXC_ERROR;

939: ,px_ozf_funds_old_rectype => ozf_funds_old_rectype
940: ,px_ozf_funds_new_tbl => ozf_funds_new_tbl
941: );
942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947: END IF; -- If this line is a processed one

Line 944: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

940: ,px_ozf_funds_new_tbl => ozf_funds_new_tbl
941: );
942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947: END IF; -- If this line is a processed one
948: --

Line 945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

941: );
942: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
943: RAISE FND_API.G_EXC_ERROR;
944: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947: END IF; -- If this line is a processed one
948: --
949: << END_ORDER_LINE >>

Line 972: IF x_return_status = FND_API.g_ret_sts_error THEN

968:
969: -- Call for the update of funds and budgets where the update happens in one shot.
970: IF ozf_funds_new_tbl.COUNT > 0 THEN
971: OZF_UTILITY_PVT.UPDATE_OZF_FUNDS_ALL_B(p_resale_batch_id, x_return_status, x_fund_table_status, ozf_funds_new_tbl, 'CHARGEBACK');
972: IF x_return_status = FND_API.g_ret_sts_error THEN
973: RAISE FND_API.g_exc_error;
974: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
975: RAISE FND_API.g_exc_unexpected_error;
976: END IF;

Line 973: RAISE FND_API.g_exc_error;

969: -- Call for the update of funds and budgets where the update happens in one shot.
970: IF ozf_funds_new_tbl.COUNT > 0 THEN
971: OZF_UTILITY_PVT.UPDATE_OZF_FUNDS_ALL_B(p_resale_batch_id, x_return_status, x_fund_table_status, ozf_funds_new_tbl, 'CHARGEBACK');
972: IF x_return_status = FND_API.g_ret_sts_error THEN
973: RAISE FND_API.g_exc_error;
974: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
975: RAISE FND_API.g_exc_unexpected_error;
976: END IF;
977: END IF;

Line 974: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

970: IF ozf_funds_new_tbl.COUNT > 0 THEN
971: OZF_UTILITY_PVT.UPDATE_OZF_FUNDS_ALL_B(p_resale_batch_id, x_return_status, x_fund_table_status, ozf_funds_new_tbl, 'CHARGEBACK');
972: IF x_return_status = FND_API.g_ret_sts_error THEN
973: RAISE FND_API.g_exc_error;
974: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
975: RAISE FND_API.g_exc_unexpected_error;
976: END IF;
977: END IF;
978:

Line 975: RAISE FND_API.g_exc_unexpected_error;

971: OZF_UTILITY_PVT.UPDATE_OZF_FUNDS_ALL_B(p_resale_batch_id, x_return_status, x_fund_table_status, ozf_funds_new_tbl, 'CHARGEBACK');
972: IF x_return_status = FND_API.g_ret_sts_error THEN
973: RAISE FND_API.g_exc_error;
974: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
975: RAISE FND_API.g_exc_unexpected_error;
976: END IF;
977: END IF;
978:
979: IF ozf_act_budgets_tbl.COUNT > 0 THEN

Line 981: IF x_return_status = FND_API.g_ret_sts_error THEN

977: END IF;
978:
979: IF ozf_act_budgets_tbl.COUNT > 0 THEN
980: OZF_UTILITY_PVT.UPDATE_OZF_ACT_BUDGETS(p_resale_batch_id, x_return_status, x_budget_table_status, ozf_act_budgets_tbl, 'CHARGEBACK');
981: IF x_return_status = FND_API.g_ret_sts_error THEN
982: RAISE FND_API.g_exc_error;
983: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
984: RAISE FND_API.g_exc_unexpected_error;
985: END IF;

Line 982: RAISE FND_API.g_exc_error;

978:
979: IF ozf_act_budgets_tbl.COUNT > 0 THEN
980: OZF_UTILITY_PVT.UPDATE_OZF_ACT_BUDGETS(p_resale_batch_id, x_return_status, x_budget_table_status, ozf_act_budgets_tbl, 'CHARGEBACK');
981: IF x_return_status = FND_API.g_ret_sts_error THEN
982: RAISE FND_API.g_exc_error;
983: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
984: RAISE FND_API.g_exc_unexpected_error;
985: END IF;
986: END IF;

Line 983: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

979: IF ozf_act_budgets_tbl.COUNT > 0 THEN
980: OZF_UTILITY_PVT.UPDATE_OZF_ACT_BUDGETS(p_resale_batch_id, x_return_status, x_budget_table_status, ozf_act_budgets_tbl, 'CHARGEBACK');
981: IF x_return_status = FND_API.g_ret_sts_error THEN
982: RAISE FND_API.g_exc_error;
983: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
984: RAISE FND_API.g_exc_unexpected_error;
985: END IF;
986: END IF;
987:

Line 984: RAISE FND_API.g_exc_unexpected_error;

980: OZF_UTILITY_PVT.UPDATE_OZF_ACT_BUDGETS(p_resale_batch_id, x_return_status, x_budget_table_status, ozf_act_budgets_tbl, 'CHARGEBACK');
981: IF x_return_status = FND_API.g_ret_sts_error THEN
982: RAISE FND_API.g_exc_error;
983: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
984: RAISE FND_API.g_exc_unexpected_error;
985: END IF;
986: END IF;
987:
988: END IF;

Line 993: ,p_init_msg_list => FND_API.G_FALSE

989: -- For Bug#8867381(-)
990:
991: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
992: p_api_version => 1.0
993: ,p_init_msg_list => FND_API.G_FALSE
994: ,p_commit => FND_API.G_FALSE
995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
996: ,p_resale_batch_id => p_resale_batch_id
997: ,x_return_status => l_return_status

Line 994: ,p_commit => FND_API.G_FALSE

990:
991: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
992: p_api_version => 1.0
993: ,p_init_msg_list => FND_API.G_FALSE
994: ,p_commit => FND_API.G_FALSE
995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
996: ,p_resale_batch_id => p_resale_batch_id
997: ,x_return_status => l_return_status
998: ,x_msg_data => l_msg_data

Line 995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

991: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
992: p_api_version => 1.0
993: ,p_init_msg_list => FND_API.G_FALSE
994: ,p_commit => FND_API.G_FALSE
995: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
996: ,p_resale_batch_id => p_resale_batch_id
997: ,x_return_status => l_return_status
998: ,x_msg_data => l_msg_data
999: ,x_msg_count => l_msg_count

Line 1001: IF l_return_status = FND_API.g_ret_sts_error THEN

997: ,x_return_status => l_return_status
998: ,x_msg_data => l_msg_data
999: ,x_msg_count => l_msg_count
1000: );
1001: IF l_return_status = FND_API.g_ret_sts_error THEN
1002: RAISE FND_API.g_exc_error;
1003: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1004: RAISE FND_API.g_exc_unexpected_error;
1005: END IF;

Line 1002: RAISE FND_API.g_exc_error;

998: ,x_msg_data => l_msg_data
999: ,x_msg_count => l_msg_count
1000: );
1001: IF l_return_status = FND_API.g_ret_sts_error THEN
1002: RAISE FND_API.g_exc_error;
1003: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1004: RAISE FND_API.g_exc_unexpected_error;
1005: END IF;
1006:

Line 1003: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

999: ,x_msg_count => l_msg_count
1000: );
1001: IF l_return_status = FND_API.g_ret_sts_error THEN
1002: RAISE FND_API.g_exc_error;
1003: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1004: RAISE FND_API.g_exc_unexpected_error;
1005: END IF;
1006:
1007: -- After all the processes are done, call claim autopay

Line 1004: RAISE FND_API.g_exc_unexpected_error;

1000: );
1001: IF l_return_status = FND_API.g_ret_sts_error THEN
1002: RAISE FND_API.g_exc_error;
1003: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1004: RAISE FND_API.g_exc_unexpected_error;
1005: END IF;
1006:
1007: -- After all the processes are done, call claim autopay
1008: l_claim_rec.cust_account_id := l_partner_cust_account_id;

Line 1036: ,p_init_msg_list => FND_API.g_false

1032: END IF;
1033: --Bug# 8632964 fixed by anuj and muthu (-)
1034: OZF_Claim_Accrual_PVT.Pay_Claim_for_Accruals(
1035: p_api_version => 1.0
1036: ,p_init_msg_list => FND_API.g_false
1037: ,p_commit => FND_API.g_false
1038: ,p_validation_level => FND_API.g_valid_level_full
1039: ,p_accrual_flag => l_accrual_flag
1040: ,x_return_status => l_return_status

Line 1037: ,p_commit => FND_API.g_false

1033: --Bug# 8632964 fixed by anuj and muthu (-)
1034: OZF_Claim_Accrual_PVT.Pay_Claim_for_Accruals(
1035: p_api_version => 1.0
1036: ,p_init_msg_list => FND_API.g_false
1037: ,p_commit => FND_API.g_false
1038: ,p_validation_level => FND_API.g_valid_level_full
1039: ,p_accrual_flag => l_accrual_flag
1040: ,x_return_status => l_return_status
1041: ,x_msg_count => l_msg_count

Line 1038: ,p_validation_level => FND_API.g_valid_level_full

1034: OZF_Claim_Accrual_PVT.Pay_Claim_for_Accruals(
1035: p_api_version => 1.0
1036: ,p_init_msg_list => FND_API.g_false
1037: ,p_commit => FND_API.g_false
1038: ,p_validation_level => FND_API.g_valid_level_full
1039: ,p_accrual_flag => l_accrual_flag
1040: ,x_return_status => l_return_status
1041: ,x_msg_count => l_msg_count
1042: ,x_msg_data => l_msg_data

Line 1047: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1043: ,p_claim_rec => l_claim_rec
1044: ,p_funds_util_flt => l_funds_util_flt
1045: ,x_claim_id => l_claim_id
1046: );
1047: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1048: RAISE FND_API.g_exc_unexpected_error;
1049: END IF;
1050:
1051:

Line 1048: RAISE FND_API.g_exc_unexpected_error;

1044: ,p_funds_util_flt => l_funds_util_flt
1045: ,x_claim_id => l_claim_id
1046: );
1047: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1048: RAISE FND_API.g_exc_unexpected_error;
1049: END IF;
1050:
1051:
1052: IF OZF_DEBUG_LOW_ON THEN

Line 1106: RAISE FND_API.g_exc_unexpected_error;

1102:
1103: EXCEPTION
1104: WHEN OTHERS THEN
1105: OZF_UTILITY_PVT.error_message('OZF_UPD_RESALE_WRG','TEXT',l_full_name||': End');
1106: RAISE FND_API.g_exc_unexpected_error;
1107: END;
1108:
1109: -- mchang: Run Third Party Accrual After Chargeback Calculation was
1110: -- done in workflow already. No need to check here.

Line 1129: p_encoded => FND_API.G_FALSE,

1125: END IF;
1126:
1127: --Standard call to get message count AND if count=1, get the message
1128: FND_MSG_PUB.Count_and_Get (
1129: p_encoded => FND_API.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );
1133:

Line 1136: x_return_status := FND_API.G_RET_STS_ERROR;

1132: );
1133:
1134: EXCEPTION
1135: WHEN error_no_rollback THEN
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: FND_MSG_PUB.Count_And_Get (
1138: p_encoded => FND_API.G_FALSE,
1139: p_count => x_msg_count,
1140: p_data => x_msg_data

Line 1138: p_encoded => FND_API.G_FALSE,

1134: EXCEPTION
1135: WHEN error_no_rollback THEN
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: FND_MSG_PUB.Count_And_Get (
1138: p_encoded => FND_API.G_FALSE,
1139: p_count => x_msg_count,
1140: p_data => x_msg_data
1141: );
1142: WHEN FND_API.g_exc_error THEN

Line 1142: WHEN FND_API.g_exc_error THEN

1138: p_encoded => FND_API.G_FALSE,
1139: p_count => x_msg_count,
1140: p_data => x_msg_data
1141: );
1142: WHEN FND_API.g_exc_error THEN
1143: ROLLBACK TO Initiate_Payment;
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: -- Standard call to get message count AND IF count=1, get the message
1146: FND_MSG_PUB.Count_And_Get (

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR;

1140: p_data => x_msg_data
1141: );
1142: WHEN FND_API.g_exc_error THEN
1143: ROLLBACK TO Initiate_Payment;
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: -- Standard call to get message count AND IF count=1, get the message
1146: FND_MSG_PUB.Count_And_Get (
1147: p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,

Line 1147: p_encoded => FND_API.G_FALSE,

1143: ROLLBACK TO Initiate_Payment;
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: -- Standard call to get message count AND IF count=1, get the message
1146: FND_MSG_PUB.Count_And_Get (
1147: p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data
1150: );
1151: WHEN FND_API.g_exc_unexpected_error THEN

Line 1151: WHEN FND_API.g_exc_unexpected_error THEN

1147: p_encoded => FND_API.G_FALSE,
1148: p_count => x_msg_count,
1149: p_data => x_msg_data
1150: );
1151: WHEN FND_API.g_exc_unexpected_error THEN
1152: ROLLBACK TO Initiate_Payment;
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: -- Standard call to get message count AND IF count=1, get the message
1155: FND_MSG_PUB.Count_And_Get (

Line 1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1149: p_data => x_msg_data
1150: );
1151: WHEN FND_API.g_exc_unexpected_error THEN
1152: ROLLBACK TO Initiate_Payment;
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: -- Standard call to get message count AND IF count=1, get the message
1155: FND_MSG_PUB.Count_And_Get (
1156: p_encoded => FND_API.G_FALSE,
1157: p_count => x_msg_count,

Line 1156: p_encoded => FND_API.G_FALSE,

1152: ROLLBACK TO Initiate_Payment;
1153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1154: -- Standard call to get message count AND IF count=1, get the message
1155: FND_MSG_PUB.Count_And_Get (
1156: p_encoded => FND_API.G_FALSE,
1157: p_count => x_msg_count,
1158: p_data => x_msg_data
1159: );
1160: WHEN OTHERS THEN

Line 1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1158: p_data => x_msg_data
1159: );
1160: WHEN OTHERS THEN
1161: ROLLBACK TO Initiate_Payment;
1162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1163: IF OZF_UNEXP_ERROR THEN
1164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1165: END IF;
1166: -- Standard call to get message count AND IF count=1, get the message

Line 1168: p_encoded => FND_API.G_FALSE,

1164: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1165: END IF;
1166: -- Standard call to get message count AND IF count=1, get the message
1167: FND_MSG_PUB.Count_And_Get (
1168: p_encoded => FND_API.G_FALSE,
1169: p_count => x_msg_count,
1170: p_data => x_msg_data
1171: );
1172: END Initiate_Payment;

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

1185: -- NOTES
1186: ---------------------------------------------------------------------
1187: PROCEDURE Validate_Order_Record(
1188: p_api_version IN NUMBER
1189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1190: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1191: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1192: ,p_resale_batch_id IN NUMBER
1193: ,x_return_status OUT NOCOPY VARCHAR2

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

1186: ---------------------------------------------------------------------
1187: PROCEDURE Validate_Order_Record(
1188: p_api_version IN NUMBER
1189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1190: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1191: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1192: ,p_resale_batch_id IN NUMBER
1193: ,x_return_status OUT NOCOPY VARCHAR2
1194: ,x_msg_data OUT NOCOPY VARCHAR2

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

1187: PROCEDURE Validate_Order_Record(
1188: p_api_version IN NUMBER
1189: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1190: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
1191: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1192: ,p_resale_batch_id IN NUMBER
1193: ,x_return_status OUT NOCOPY VARCHAR2
1194: ,x_msg_data OUT NOCOPY VARCHAR2
1195: ,x_msg_count OUT NOCOPY NUMBER

Line 1221: IF NOT FND_API.Compatible_API_Call (

1217:
1218: --
1219: BEGIN
1220: -- Standard call to check FOR call compatibility.
1221: IF NOT FND_API.Compatible_API_Call (
1222: l_api_version,
1223: p_api_version,
1224: l_api_name,
1225: G_PKG_NAME)

Line 1227: RAISE FND_API.g_exc_unexpected_error;

1223: p_api_version,
1224: l_api_name,
1225: G_PKG_NAME)
1226: THEN
1227: RAISE FND_API.g_exc_unexpected_error;
1228: END IF;
1229:
1230: -- Debug Message
1231: IF OZF_DEBUG_HIGH_ON THEN

Line 1236: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

1232: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');
1233: END IF;
1234:
1235: --Initialize message lISt if p_init_msg_list IS TRUE.
1236: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
1237: FND_MSG_PUB.initialize;
1238: END IF;
1239:
1240: -- Initialize API return status to sucess

Line 1241: x_return_status := FND_API.G_RET_STS_SUCCESS;

1237: FND_MSG_PUB.initialize;
1238: END IF;
1239:
1240: -- Initialize API return status to sucess
1241: x_return_status := FND_API.G_RET_STS_SUCCESS;
1242:
1243: -- bulk select all lines with missing order numbers
1244: IF l_id_tbl.EXISTS(1) THEN
1245: l_id_tbl.DELETE;

Line 1272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1268: p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
1269: x_return_status => l_return_status
1270: );
1271:
1272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;

Line 1273: RAISE FND_API.g_exc_error;

1269: x_return_status => l_return_status
1270: );
1271:
1272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;
1277: --

Line 1274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1270: );
1271:
1272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;
1277: --
1278:

Line 1275: RAISE FND_API.g_exc_unexpected_error;

1271:
1272: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1273: RAISE FND_API.g_exc_error;
1274: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1275: RAISE FND_API.g_exc_unexpected_error;
1276: END IF;
1277: --
1278:
1279: OZF_RESALE_COMMON_PVT.Bulk_Dispute_Line (

Line 1284: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1280: p_batch_id => p_resale_batch_id,
1281: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
1282: x_return_status => l_return_status
1283: );
1284: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.g_exc_error;
1286: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.g_exc_unexpected_error;
1288: END IF;

Line 1285: RAISE FND_API.g_exc_error;

1281: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
1282: x_return_status => l_return_status
1283: );
1284: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.g_exc_error;
1286: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.g_exc_unexpected_error;
1288: END IF;
1289: --

Line 1286: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1282: x_return_status => l_return_status
1283: );
1284: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.g_exc_error;
1286: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.g_exc_unexpected_error;
1288: END IF;
1289: --
1290:

Line 1287: RAISE FND_API.g_exc_unexpected_error;

1283: );
1284: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.g_exc_error;
1286: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1287: RAISE FND_API.g_exc_unexpected_error;
1288: END IF;
1289: --
1290:
1291: -- Debug Message

Line 1298: p_encoded => FND_API.G_FALSE,

1294: END IF;
1295:
1296: --Standard call to get message count AND if count=1, get the message
1297: FND_MSG_PUB.Count_and_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1302: --

Line 1304: WHEN FND_API.g_exc_error THEN

1300: p_data => x_msg_data
1301: );
1302: --
1303: EXCEPTION
1304: WHEN FND_API.g_exc_error THEN
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: -- Standard call to get message count AND if count=1, get the message
1307: FND_MSG_PUB.Count_and_Get (
1308: p_encoded => FND_API.G_FALSE,

Line 1305: x_return_status := FND_API.G_RET_STS_ERROR;

1301: );
1302: --
1303: EXCEPTION
1304: WHEN FND_API.g_exc_error THEN
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: -- Standard call to get message count AND if count=1, get the message
1307: FND_MSG_PUB.Count_and_Get (
1308: p_encoded => FND_API.G_FALSE,
1309: p_count => x_msg_count,

Line 1308: p_encoded => FND_API.G_FALSE,

1304: WHEN FND_API.g_exc_error THEN
1305: x_return_status := FND_API.G_RET_STS_ERROR;
1306: -- Standard call to get message count AND if count=1, get the message
1307: FND_MSG_PUB.Count_and_Get (
1308: p_encoded => FND_API.G_FALSE,
1309: p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );
1312: WHEN FND_API.g_exc_unexpected_error THEN

Line 1312: WHEN FND_API.g_exc_unexpected_error THEN

1308: p_encoded => FND_API.G_FALSE,
1309: p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );
1312: WHEN FND_API.g_exc_unexpected_error THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: -- Standard call to get message count AND if count=1, get the message
1315: FND_MSG_PUB.Count_and_Get (
1316: p_encoded => FND_API.G_FALSE,

Line 1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1309: p_count => x_msg_count,
1310: p_data => x_msg_data
1311: );
1312: WHEN FND_API.g_exc_unexpected_error THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: -- Standard call to get message count AND if count=1, get the message
1315: FND_MSG_PUB.Count_and_Get (
1316: p_encoded => FND_API.G_FALSE,
1317: p_count => x_msg_count,

Line 1316: p_encoded => FND_API.G_FALSE,

1312: WHEN FND_API.g_exc_unexpected_error THEN
1313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1314: -- Standard call to get message count AND if count=1, get the message
1315: FND_MSG_PUB.Count_and_Get (
1316: p_encoded => FND_API.G_FALSE,
1317: p_count => x_msg_count,
1318: p_data => x_msg_data
1319: );
1320: WHEN OTHERS THEN

Line 1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1317: p_count => x_msg_count,
1318: p_data => x_msg_data
1319: );
1320: WHEN OTHERS THEN
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: -- Standard call to get message count AND if count=1, get the message
1323: FND_MSG_PUB.Count_and_Get (
1324: p_encoded => FND_API.G_FALSE,
1325: p_count => x_msg_count,

Line 1324: p_encoded => FND_API.G_FALSE,

1320: WHEN OTHERS THEN
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1322: -- Standard call to get message count AND if count=1, get the message
1323: FND_MSG_PUB.Count_and_Get (
1324: p_encoded => FND_API.G_FALSE,
1325: p_count => x_msg_count,
1326: p_data => x_msg_data
1327: );
1328: END Validate_Order_Record;

Line 1424: x_return_status := FND_API.G_RET_STS_SUCCESS;

1420: l_uom_ratio number;
1421: BEGIN
1422: SAVEPOINT Process_Pricing_Result;
1423:
1424: x_return_status := FND_API.G_RET_STS_SUCCESS;
1425:
1426: -- Debug Message
1427: IF OZF_DEBUG_HIGH_ON THEN
1428: OZF_UTILITY_PVT.debug_message(l_full_name||': Start');

Line 1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1463: where resale_line_int_id = p_line_tbl(i).chargeback_int_id;
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: ozf_utility_pvt.error_message('OZF_UPD_RESALE_INT_WRG');
1467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1468: END;
1469:
1470: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1471: p_id_value => p_line_tbl(i).chargeback_int_id,

Line 1479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1475: p_column_name => NULL,
1476: p_column_value => NULL,
1477: x_return_status => l_return_status);
1478: --
1479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1480: RAISE FND_API.g_exc_error;
1481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE FND_API.g_exc_unexpected_error;
1483: END IF;

Line 1480: RAISE FND_API.g_exc_error;

1476: p_column_value => NULL,
1477: x_return_status => l_return_status);
1478: --
1479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1480: RAISE FND_API.g_exc_error;
1481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE FND_API.g_exc_unexpected_error;
1483: END IF;
1484:

Line 1481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1477: x_return_status => l_return_status);
1478: --
1479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1480: RAISE FND_API.g_exc_error;
1481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE FND_API.g_exc_unexpected_error;
1483: END IF;
1484:
1485: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (

Line 1482: RAISE FND_API.g_exc_unexpected_error;

1478: --
1479: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1480: RAISE FND_API.g_exc_error;
1481: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1482: RAISE FND_API.g_exc_unexpected_error;
1483: END IF;
1484:
1485: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
1486: p_id_value => p_line_tbl(i).chargeback_int_id,

Line 1493: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1489: p_column_name => NULL,
1490: p_column_value => NULL,
1491: x_return_status => l_return_status);
1492: --
1493: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1494: RAISE FND_API.g_exc_error;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: RAISE FND_API.g_exc_unexpected_error;
1497: END IF;

Line 1494: RAISE FND_API.g_exc_error;

1490: p_column_value => NULL,
1491: x_return_status => l_return_status);
1492: --
1493: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1494: RAISE FND_API.g_exc_error;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: RAISE FND_API.g_exc_unexpected_error;
1497: END IF;
1498: --

Line 1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1491: x_return_status => l_return_status);
1492: --
1493: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1494: RAISE FND_API.g_exc_error;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: RAISE FND_API.g_exc_unexpected_error;
1497: END IF;
1498: --
1499: END IF;

Line 1496: RAISE FND_API.g_exc_unexpected_error;

1492: --
1493: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1494: RAISE FND_API.g_exc_error;
1495: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1496: RAISE FND_API.g_exc_unexpected_error;
1497: END IF;
1498: --
1499: END IF;
1500:

Line 1534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1530: p_column_value => l_val_tbl,
1531: p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
1532: x_return_status => l_return_status
1533: );
1534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1535: RAISE FND_API.G_EXC_ERROR;
1536: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;

Line 1535: RAISE FND_API.G_EXC_ERROR;

1531: p_batch_id => p_resale_batch_id, --bug # 5997978 fixed
1532: x_return_status => l_return_status
1533: );
1534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1535: RAISE FND_API.G_EXC_ERROR;
1536: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539:

Line 1536: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1532: x_return_status => l_return_status
1533: );
1534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1535: RAISE FND_API.G_EXC_ERROR;
1536: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539:
1540: BEGIN

Line 1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1533: );
1534: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1535: RAISE FND_API.G_EXC_ERROR;
1536: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1538: END IF;
1539:
1540: BEGIN
1541: UPDATE ozf_resale_lines_int_all

Line 1556: RAISE FND_API.g_exc_unexpected_error;

1552: AND resale_batch_id = p_resale_batch_id;
1553: EXCEPTION
1554: WHEN OTHERS THEN
1555: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
1556: RAISE FND_API.g_exc_unexpected_error;
1557: END;
1558:
1559: ELSE
1560: -- There is no error in the result. We need to process the result one by one.

Line 1602: ,p_init_msg_list => FND_API.G_FALSE

1598:
1599: -- Check inventory level first
1600: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1601: p_api_version => 1.0
1602: ,p_init_msg_list => FND_API.G_FALSE
1603: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1604: ,p_line_int_rec => l_resale_int_rec
1605: ,x_valid => l_inventory_level_valid
1606: ,x_return_status => l_return_status

Line 1603: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1599: -- Check inventory level first
1600: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1601: p_api_version => 1.0
1602: ,p_init_msg_list => FND_API.G_FALSE
1603: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1604: ,p_line_int_rec => l_resale_int_rec
1605: ,x_valid => l_inventory_level_valid
1606: ,x_return_status => l_return_status
1607: ,x_msg_count => l_msg_count

Line 1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1620: p_column_name => NULL,
1621: p_column_value => NULL,
1622: x_return_status => l_return_status);
1623: --
1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1625: RAISE FND_API.g_exc_error;
1626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.g_exc_unexpected_error;
1628: END IF;

Line 1625: RAISE FND_API.g_exc_error;

1621: p_column_value => NULL,
1622: x_return_status => l_return_status);
1623: --
1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1625: RAISE FND_API.g_exc_error;
1626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.g_exc_unexpected_error;
1628: END IF;
1629: --

Line 1626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1622: x_return_status => l_return_status);
1623: --
1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1625: RAISE FND_API.g_exc_error;
1626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.g_exc_unexpected_error;
1628: END IF;
1629: --
1630: -- SET Batch as DISPUTED

Line 1627: RAISE FND_API.g_exc_unexpected_error;

1623: --
1624: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1625: RAISE FND_API.g_exc_error;
1626: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1627: RAISE FND_API.g_exc_unexpected_error;
1628: END IF;
1629: --
1630: -- SET Batch as DISPUTED
1631: -- SLKRISHN change to common procedure

Line 1668: RAISE FND_API.g_exc_unexpected_error;

1664: END IF;
1665:
1666: IF l_exchange_type IS NULL THEN
1667: OZF_UTILITY_PVT.error_message('OZF_CLAIM_CONTYPE_MISSING');
1668: RAISE FND_API.g_exc_unexpected_error;
1669: END IF;
1670:
1671: IF l_exchange_date IS NULL THEN
1672: l_exchange_date := sysdate;

Line 1693: IF l_return_status = FND_API.g_ret_sts_error THEN

1689: ,p_from_amount => p_line_tbl(i).unit_price
1690: ,x_return_status => l_return_status
1691: ,x_to_amount => l_acctd_adj_unit_price
1692: ,x_rate => l_rate);
1693: IF l_return_status = FND_API.g_ret_sts_error THEN
1694: RAISE FND_API.g_exc_error;
1695: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1696: RAISE FND_API.g_exc_unexpected_error;
1697: END IF;

Line 1694: RAISE FND_API.g_exc_error;

1690: ,x_return_status => l_return_status
1691: ,x_to_amount => l_acctd_adj_unit_price
1692: ,x_rate => l_rate);
1693: IF l_return_status = FND_API.g_ret_sts_error THEN
1694: RAISE FND_API.g_exc_error;
1695: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1696: RAISE FND_API.g_exc_unexpected_error;
1697: END IF;
1698:

Line 1695: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1691: ,x_to_amount => l_acctd_adj_unit_price
1692: ,x_rate => l_rate);
1693: IF l_return_status = FND_API.g_ret_sts_error THEN
1694: RAISE FND_API.g_exc_error;
1695: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1696: RAISE FND_API.g_exc_unexpected_error;
1697: END IF;
1698:
1699: -- convert adjusted selling price

Line 1696: RAISE FND_API.g_exc_unexpected_error;

1692: ,x_rate => l_rate);
1693: IF l_return_status = FND_API.g_ret_sts_error THEN
1694: RAISE FND_API.g_exc_error;
1695: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1696: RAISE FND_API.g_exc_unexpected_error;
1697: END IF;
1698:
1699: -- convert adjusted selling price
1700: OZF_UTILITY_PVT.Convert_Currency(

Line 1710: IF l_return_status = FND_API.g_ret_sts_error THEN

1706: ,p_from_amount => l_resale_int_rec.selling_price
1707: ,x_return_status => l_return_status
1708: ,x_to_amount => l_acctd_selling_price
1709: ,x_rate => l_rate);
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;

Line 1711: RAISE FND_API.g_exc_error;

1707: ,x_return_status => l_return_status
1708: ,x_to_amount => l_acctd_selling_price
1709: ,x_rate => l_rate);
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;
1715: ELSE

Line 1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1708: ,x_to_amount => l_acctd_selling_price
1709: ,x_rate => l_rate);
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;
1715: ELSE
1716: l_acctd_adj_unit_price := OZF_UTILITY_PVT.CurrRound(p_line_tbl(i).unit_price*l_rate, l_func_currency_code);

Line 1713: RAISE FND_API.g_exc_unexpected_error;

1709: ,x_rate => l_rate);
1710: IF l_return_status = FND_API.g_ret_sts_error THEN
1711: RAISE FND_API.g_exc_error;
1712: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1713: RAISE FND_API.g_exc_unexpected_error;
1714: END IF;
1715: ELSE
1716: l_acctd_adj_unit_price := OZF_UTILITY_PVT.CurrRound(p_line_tbl(i).unit_price*l_rate, l_func_currency_code);
1717: l_acctd_selling_price := OZF_UTILITY_PVT.CurrRound(l_resale_int_rec.selling_price*l_rate, l_func_currency_code);

Line 1775: IF l_return_status = FND_API.g_ret_sts_error THEN

1771: p_line_quantity => p_line_tbl(i).line_quantity,
1772: p_allowed_amount => l_allowed_amount,
1773: x_return_status => l_return_status);
1774: --
1775: IF l_return_status = FND_API.g_ret_sts_error THEN
1776: RAISE FND_API.g_exc_error;
1777: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1778: RAISE FND_API.g_exc_unexpected_error;
1779: END IF;

Line 1776: RAISE FND_API.g_exc_error;

1772: p_allowed_amount => l_allowed_amount,
1773: x_return_status => l_return_status);
1774: --
1775: IF l_return_status = FND_API.g_ret_sts_error THEN
1776: RAISE FND_API.g_exc_error;
1777: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1778: RAISE FND_API.g_exc_unexpected_error;
1779: END IF;
1780: --

Line 1777: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

1773: x_return_status => l_return_status);
1774: --
1775: IF l_return_status = FND_API.g_ret_sts_error THEN
1776: RAISE FND_API.g_exc_error;
1777: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1778: RAISE FND_API.g_exc_unexpected_error;
1779: END IF;
1780: --
1781: END IF; -- END if current record IS a line

Line 1778: RAISE FND_API.g_exc_unexpected_error;

1774: --
1775: IF l_return_status = FND_API.g_ret_sts_error THEN
1776: RAISE FND_API.g_exc_error;
1777: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1778: RAISE FND_API.g_exc_unexpected_error;
1779: END IF;
1780: --
1781: END IF; -- END if current record IS a line
1782: << END_LOOP3>>

Line 1793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1789: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
1790: x_return_status => l_return_status
1791: );
1792: --
1793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1794: RAISE FND_API.g_exc_error;
1795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.g_exc_unexpected_error;
1797: END IF;

Line 1794: RAISE FND_API.g_exc_error;

1790: x_return_status => l_return_status
1791: );
1792: --
1793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1794: RAISE FND_API.g_exc_error;
1795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.g_exc_unexpected_error;
1797: END IF;
1798: --

Line 1795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1791: );
1792: --
1793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1794: RAISE FND_API.g_exc_error;
1795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.g_exc_unexpected_error;
1797: END IF;
1798: --
1799: -- END IF; -- END of l_has_error

Line 1796: RAISE FND_API.g_exc_unexpected_error;

1792: --
1793: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1794: RAISE FND_API.g_exc_error;
1795: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1796: RAISE FND_API.g_exc_unexpected_error;
1797: END IF;
1798: --
1799: -- END IF; -- END of l_has_error
1800: ELSE

Line 1812: WHEN FND_API.g_exc_error THEN

1808: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
1809: END IF;
1810:
1811: EXCEPTION
1812: WHEN FND_API.g_exc_error THEN
1813: ROLLBACK TO Process_Pricing_Result;
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: WHEN FND_API.g_exc_unexpected_error THEN
1816: ROLLBACK TO Process_Pricing_Result;

Line 1814: x_return_status := FND_API.G_RET_STS_ERROR;

1810:
1811: EXCEPTION
1812: WHEN FND_API.g_exc_error THEN
1813: ROLLBACK TO Process_Pricing_Result;
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: WHEN FND_API.g_exc_unexpected_error THEN
1816: ROLLBACK TO Process_Pricing_Result;
1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818: WHEN OTHERS THEN

Line 1815: WHEN FND_API.g_exc_unexpected_error THEN

1811: EXCEPTION
1812: WHEN FND_API.g_exc_error THEN
1813: ROLLBACK TO Process_Pricing_Result;
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: WHEN FND_API.g_exc_unexpected_error THEN
1816: ROLLBACK TO Process_Pricing_Result;
1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818: WHEN OTHERS THEN
1819: ROLLBACK TO Process_Pricing_Result;

Line 1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1813: ROLLBACK TO Process_Pricing_Result;
1814: x_return_status := FND_API.G_RET_STS_ERROR;
1815: WHEN FND_API.g_exc_unexpected_error THEN
1816: ROLLBACK TO Process_Pricing_Result;
1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818: WHEN OTHERS THEN
1819: ROLLBACK TO Process_Pricing_Result;
1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1821: IF OZF_UNEXP_ERROR THEN

Line 1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1816: ROLLBACK TO Process_Pricing_Result;
1817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818: WHEN OTHERS THEN
1819: ROLLBACK TO Process_Pricing_Result;
1820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1821: IF OZF_UNEXP_ERROR THEN
1822: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1823: END IF;
1824: END Process_Pricing_Result;

Line 1921: x_return_status := FND_API.G_RET_STS_SUCCESS;

1917:
1918: SAVEPOINT Get_Order_Price;
1919:
1920: -- Initialize API return status to sucess
1921: x_return_status := FND_API.G_RET_STS_SUCCESS;
1922:
1923: -- bug 6511302 (+) validate inventory for tracing lines
1924: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;
1925: FETCH OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr INTO l_inventory_tracking;

Line 1947: ,p_init_msg_list => FND_API.G_FALSE

1943: IF l_resale_int_rec.duplicated_adjustment_id IS NULL OR l_resale_int_rec.duplicated_adjustment_id = -1 THEN
1944: -- Check inventory level first
1945: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1946: p_api_version => 1.0
1947: ,p_init_msg_list => FND_API.G_FALSE
1948: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1949: ,p_line_int_rec => l_resale_int_rec
1950: ,x_valid => l_inventory_level_valid
1951: ,x_return_status => l_return_status

Line 1948: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

1944: -- Check inventory level first
1945: OZF_SALES_TRANSACTIONS_PVT.Validate_Inventory_level (
1946: p_api_version => 1.0
1947: ,p_init_msg_list => FND_API.G_FALSE
1948: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
1949: ,p_line_int_rec => l_resale_int_rec
1950: ,x_valid => l_inventory_level_valid
1951: ,x_return_status => l_return_status
1952: ,x_msg_count => l_msg_count

Line 1970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1966: p_column_name => NULL,
1967: p_column_value => NULL,
1968: x_return_status => l_return_status);
1969:
1970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1971: RAISE FND_API.g_exc_error;
1972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.g_exc_unexpected_error;
1974: END IF;

Line 1971: RAISE FND_API.g_exc_error;

1967: p_column_value => NULL,
1968: x_return_status => l_return_status);
1969:
1970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1971: RAISE FND_API.g_exc_error;
1972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.g_exc_unexpected_error;
1974: END IF;
1975:

Line 1972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1968: x_return_status => l_return_status);
1969:
1970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1971: RAISE FND_API.g_exc_error;
1972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.g_exc_unexpected_error;
1974: END IF;
1975:
1976: -- Set line to DISPUTED

Line 1973: RAISE FND_API.g_exc_unexpected_error;

1969:
1970: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1971: RAISE FND_API.g_exc_error;
1972: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1973: RAISE FND_API.g_exc_unexpected_error;
1974: END IF;
1975:
1976: -- Set line to DISPUTED
1977: UPDATE ozf_resale_lines_int

Line 2065: RAISE FND_API.g_exc_unexpected_error;

2061: WHEN OTHERS THEN
2062: IF OZF_UNEXP_ERROR THEN
2063: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2064: END IF;
2065: RAISE FND_API.g_exc_unexpected_error;
2066: END;
2067: IF OZF_DEBUG_LOW_ON THEN
2068: OZF_UTILITY_PVT.debug_message('/*--- Buidling order line info for inteface id: '||l_order_set_tbl(J).resale_line_int_id ||'---*/');
2069: END IF;

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

2087: --l_line_tbl(J).unit_price := NULL;
2088: --l_line_tbl(J).percent_price := NULL;
2089: --l_line_tbl(J).uom_quantity := NULL;
2090: --l_line_tbl(J).adjusted_unit_price := NULL;
2091: --l_line_tbl(J).upd_adjusted_unit_price := FND_API.G_MISS_NUM,
2092: --l_line_tbl(J).processed_flag := FND_API.G_MISS_CHAR,
2093: l_line_tbl(J).price_flag := l_price_flag;
2094: --l_line_tbl(J).processing_order := NULL;
2095: l_line_tbl(J).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;

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

2088: --l_line_tbl(J).percent_price := NULL;
2089: --l_line_tbl(J).uom_quantity := NULL;
2090: --l_line_tbl(J).adjusted_unit_price := NULL;
2091: --l_line_tbl(J).upd_adjusted_unit_price := FND_API.G_MISS_NUM,
2092: --l_line_tbl(J).processed_flag := FND_API.G_MISS_CHAR,
2093: l_line_tbl(J).price_flag := l_price_flag;
2094: --l_line_tbl(J).processing_order := NULL;
2095: l_line_tbl(J).pricing_status_code := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2096: --l_line_tbl(J).pricing_status_text := NULL;

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

2233: --l_line_tbl(J).UNIT_PRICE := l_order_set_tbl(J).
2234: --l_line_tbl(J).PERCENT_PRICE := l_order_set_tbl(J).
2235: --l_line_tbl(J).UOM_QUANTITY := l_order_set_tbl(J).
2236: --l_line_tbl(J).ADJUSTED_UNIT_PRICE := l_order_set_tbl(J).
2237: --l_line_tbl(J).UPD_ADJUSTED_UNIT_PRICE := FND_API.G_MISS_NUM,
2238: --l_line_tbl(J).PROCESSED_FLAG := FND_API.G_MISS_CHAR,
2239: l_line_tbl(k).PRICE_FLAG := l_price_flag;
2240: --l_line_tbl(J).PROCESSING_ORDER := NULL;
2241: l_line_tbl(k).PRICING_STATUS_CODE := QP_PREQ_GRP.G_STATUS_UNCHANGED;

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

2234: --l_line_tbl(J).PERCENT_PRICE := l_order_set_tbl(J).
2235: --l_line_tbl(J).UOM_QUANTITY := l_order_set_tbl(J).
2236: --l_line_tbl(J).ADJUSTED_UNIT_PRICE := l_order_set_tbl(J).
2237: --l_line_tbl(J).UPD_ADJUSTED_UNIT_PRICE := FND_API.G_MISS_NUM,
2238: --l_line_tbl(J).PROCESSED_FLAG := FND_API.G_MISS_CHAR,
2239: l_line_tbl(k).PRICE_FLAG := l_price_flag;
2240: --l_line_tbl(J).PROCESSING_ORDER := NULL;
2241: l_line_tbl(k).PRICING_STATUS_CODE := QP_PREQ_GRP.G_STATUS_UNCHANGED;
2242: --l_line_tbl(J).PRICING_STATUS_TEXT := NULL;

Line 2284: ,p_init_msg_list => FND_API.G_FALSE

2280:
2281: -- Get the agreement price for order lines
2282: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2283: p_api_version => 1.0
2284: ,p_init_msg_list => FND_API.G_FALSE
2285: ,p_commit => FND_API.G_FALSE
2286: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2287: ,x_return_status => l_return_status
2288: ,x_msg_data => l_msg_data

Line 2285: ,p_commit => FND_API.G_FALSE

2281: -- Get the agreement price for order lines
2282: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2283: p_api_version => 1.0
2284: ,p_init_msg_list => FND_API.G_FALSE
2285: ,p_commit => FND_API.G_FALSE
2286: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2287: ,x_return_status => l_return_status
2288: ,x_msg_data => l_msg_data
2289: ,x_msg_count => l_msg_count

Line 2286: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2282: OZF_ORDER_PRICE_PVT.Get_Order_Price (
2283: p_api_version => 1.0
2284: ,p_init_msg_list => FND_API.G_FALSE
2285: ,p_commit => FND_API.G_FALSE
2286: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2287: ,x_return_status => l_return_status
2288: ,x_msg_data => l_msg_data
2289: ,x_msg_count => l_msg_count
2290: ,p_control_rec => l_control_rec

Line 2295: IF l_return_status = FND_API.g_ret_sts_error THEN

2291: ,xp_line_tbl => l_line_tbl
2292: ,x_ldets_tbl => x_ldets_tbl
2293: ,x_related_lines_tbl => x_related_lines_tbl
2294: );
2295: IF l_return_status = FND_API.g_ret_sts_error THEN
2296: RAISE FND_API.g_exc_error;
2297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2298: RAISE FND_API.g_exc_unexpected_error;
2299: END IF;

Line 2296: RAISE FND_API.g_exc_error;

2292: ,x_ldets_tbl => x_ldets_tbl
2293: ,x_related_lines_tbl => x_related_lines_tbl
2294: );
2295: IF l_return_status = FND_API.g_ret_sts_error THEN
2296: RAISE FND_API.g_exc_error;
2297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2298: RAISE FND_API.g_exc_unexpected_error;
2299: END IF;
2300:

Line 2297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2293: ,x_related_lines_tbl => x_related_lines_tbl
2294: );
2295: IF l_return_status = FND_API.g_ret_sts_error THEN
2296: RAISE FND_API.g_exc_error;
2297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2298: RAISE FND_API.g_exc_unexpected_error;
2299: END IF;
2300:
2301: x_line_tbl := l_line_tbl;

Line 2298: RAISE FND_API.g_exc_unexpected_error;

2294: );
2295: IF l_return_status = FND_API.g_ret_sts_error THEN
2296: RAISE FND_API.g_exc_error;
2297: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2298: RAISE FND_API.g_exc_unexpected_error;
2299: END IF;
2300:
2301: x_line_tbl := l_line_tbl;
2302: END IF;

Line 2309: WHEN FND_API.g_exc_error THEN

2305: IF OZF_DEBUG_HIGH_ON THEN
2306: OZF_UTILITY_PVT.debug_message(l_full_name||': End');
2307: END IF;
2308: EXCEPTION
2309: WHEN FND_API.g_exc_error THEN
2310: ROLLBACK TO Get_Order_Price;
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: WHEN FND_API.g_exc_unexpected_error THEN
2313: ROLLBACK TO Get_Order_Price;

Line 2311: x_return_status := FND_API.G_RET_STS_ERROR;

2307: END IF;
2308: EXCEPTION
2309: WHEN FND_API.g_exc_error THEN
2310: ROLLBACK TO Get_Order_Price;
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: WHEN FND_API.g_exc_unexpected_error THEN
2313: ROLLBACK TO Get_Order_Price;
2314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2315: WHEN OTHERS THEN

Line 2312: WHEN FND_API.g_exc_unexpected_error THEN

2308: EXCEPTION
2309: WHEN FND_API.g_exc_error THEN
2310: ROLLBACK TO Get_Order_Price;
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: WHEN FND_API.g_exc_unexpected_error THEN
2313: ROLLBACK TO Get_Order_Price;
2314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2315: WHEN OTHERS THEN
2316: ROLLBACK TO Get_Order_Price;

Line 2314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2310: ROLLBACK TO Get_Order_Price;
2311: x_return_status := FND_API.G_RET_STS_ERROR;
2312: WHEN FND_API.g_exc_unexpected_error THEN
2313: ROLLBACK TO Get_Order_Price;
2314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2315: WHEN OTHERS THEN
2316: ROLLBACK TO Get_Order_Price;
2317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2318: IF OZF_UNEXP_ERROR THEN

Line 2317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2313: ROLLBACK TO Get_Order_Price;
2314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2315: WHEN OTHERS THEN
2316: ROLLBACK TO Get_Order_Price;
2317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2318: IF OZF_UNEXP_ERROR THEN
2319: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2320: END IF;
2321: END Get_Order_Price;

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

2334: ---------------------------------------------------------------------
2335: PROCEDURE Process_Order
2336: (
2337: p_api_version IN NUMBER
2338: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2340: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2341: ,p_resale_batch_id IN NUMBER
2342: ,x_return_status OUT NOCOPY VARCHAR2

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

2335: PROCEDURE Process_Order
2336: (
2337: p_api_version IN NUMBER
2338: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2340: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2341: ,p_resale_batch_id IN NUMBER
2342: ,x_return_status OUT NOCOPY VARCHAR2
2343: ,x_msg_data OUT NOCOPY VARCHAR2

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

2336: (
2337: p_api_version IN NUMBER
2338: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2339: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
2340: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2341: ,p_resale_batch_id IN NUMBER
2342: ,x_return_status OUT NOCOPY VARCHAR2
2343: ,x_msg_data OUT NOCOPY VARCHAR2
2344: ,x_msg_count OUT NOCOPY NUMBER

Line 2395: IF NOT FND_API.Compatible_API_Call (

2391: -- Standard begin of API savepoint
2392: SAVEPOINT Process_Order;
2393:
2394: -- Standard call to check FOR call compatibility.
2395: IF NOT FND_API.Compatible_API_Call (
2396: l_api_version,
2397: p_api_version,
2398: l_api_name,
2399: G_PKG_NAME)

Line 2401: RAISE FND_API.g_exc_unexpected_error;

2397: p_api_version,
2398: l_api_name,
2399: G_PKG_NAME)
2400: THEN
2401: RAISE FND_API.g_exc_unexpected_error;
2402: END IF;
2403:
2404: --Initialize message lISt if p_init_msg_list IS TRUE.
2405: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

Line 2405: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN

2401: RAISE FND_API.g_exc_unexpected_error;
2402: END IF;
2403:
2404: --Initialize message lISt if p_init_msg_list IS TRUE.
2405: IF FND_API.To_BOOLEAN (p_init_msg_list) THEN
2406: FND_MSG_PUB.initialize;
2407: END IF;
2408:
2409: -- Debug Message

Line 2415: x_return_status := FND_API.G_RET_STS_SUCCESS;

2411: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': Start');
2412: END IF;
2413:
2414: -- Initialize API return status to sucess
2415: x_return_status := FND_API.G_RET_STS_SUCCESS;
2416:
2417: -- Move Delete logs to resale_pre_process
2418: -- Delete the logs for the current batch
2419: OZF_RESALE_COMMON_PVT.Delete_Log(

Line 2421: ,p_init_msg_list => FND_API.G_FALSE

2417: -- Move Delete logs to resale_pre_process
2418: -- Delete the logs for the current batch
2419: OZF_RESALE_COMMON_PVT.Delete_Log(
2420: p_api_version => 1.0
2421: ,p_init_msg_list => FND_API.G_FALSE
2422: ,p_commit => FND_API.G_FALSE
2423: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2424: ,p_resale_batch_id => p_resale_batch_id
2425: ,x_return_status => l_return_status

Line 2422: ,p_commit => FND_API.G_FALSE

2418: -- Delete the logs for the current batch
2419: OZF_RESALE_COMMON_PVT.Delete_Log(
2420: p_api_version => 1.0
2421: ,p_init_msg_list => FND_API.G_FALSE
2422: ,p_commit => FND_API.G_FALSE
2423: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2424: ,p_resale_batch_id => p_resale_batch_id
2425: ,x_return_status => l_return_status
2426: ,x_msg_count => l_msg_count

Line 2423: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2419: OZF_RESALE_COMMON_PVT.Delete_Log(
2420: p_api_version => 1.0
2421: ,p_init_msg_list => FND_API.G_FALSE
2422: ,p_commit => FND_API.G_FALSE
2423: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2424: ,p_resale_batch_id => p_resale_batch_id
2425: ,x_return_status => l_return_status
2426: ,x_msg_count => l_msg_count
2427: ,x_msg_data => l_msg_data

Line 2429: IF l_return_status = FND_API.g_ret_sts_error THEN

2425: ,x_return_status => l_return_status
2426: ,x_msg_count => l_msg_count
2427: ,x_msg_data => l_msg_data
2428: );
2429: IF l_return_status = FND_API.g_ret_sts_error THEN
2430: RAISE FND_API.g_exc_error;
2431: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2432: RAISE FND_API.g_exc_unexpected_error;
2433: END IF;

Line 2430: RAISE FND_API.g_exc_error;

2426: ,x_msg_count => l_msg_count
2427: ,x_msg_data => l_msg_data
2428: );
2429: IF l_return_status = FND_API.g_ret_sts_error THEN
2430: RAISE FND_API.g_exc_error;
2431: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2432: RAISE FND_API.g_exc_unexpected_error;
2433: END IF;
2434:

Line 2431: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2427: ,x_msg_data => l_msg_data
2428: );
2429: IF l_return_status = FND_API.g_ret_sts_error THEN
2430: RAISE FND_API.g_exc_error;
2431: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2432: RAISE FND_API.g_exc_unexpected_error;
2433: END IF;
2434:
2435: -- Check whether there IS a need to do inventory_verification

Line 2432: RAISE FND_API.g_exc_unexpected_error;

2428: );
2429: IF l_return_status = FND_API.g_ret_sts_error THEN
2430: RAISE FND_API.g_exc_error;
2431: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2432: RAISE FND_API.g_exc_unexpected_error;
2433: END IF;
2434:
2435: -- Check whether there IS a need to do inventory_verification
2436: OPEN OZF_RESALE_COMMON_PVT.g_inventory_tracking_csr;

Line 2450: ,p_init_msg_list => FND_API.G_FALSE

2446: CLOSE batch_info_csr;
2447:
2448: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
2449: p_api_version => 1.0
2450: ,p_init_msg_list => FND_API.G_FALSE
2451: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2452: ,p_resale_batch_id => p_resale_batch_id
2453: ,p_start_date => l_report_start_date
2454: ,p_end_date => l_report_end_date

Line 2451: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2447:
2448: OZF_SALES_TRANSACTIONS_PVT.Initiate_Inventory_tmp (
2449: p_api_version => 1.0
2450: ,p_init_msg_list => FND_API.G_FALSE
2451: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2452: ,p_resale_batch_id => p_resale_batch_id
2453: ,p_start_date => l_report_start_date
2454: ,p_end_date => l_report_end_date
2455: ,x_return_status => l_return_status

Line 2459: IF l_return_status = FND_API.g_ret_sts_error THEN

2455: ,x_return_status => l_return_status
2456: ,x_msg_count => l_msg_count
2457: ,x_msg_data => l_msg_data
2458: );
2459: IF l_return_status = FND_API.g_ret_sts_error THEN
2460: RAISE FND_API.g_exc_error;
2461: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2462: RAISE FND_API.g_exc_unexpected_error;
2463: END IF;

Line 2460: RAISE FND_API.g_exc_error;

2456: ,x_msg_count => l_msg_count
2457: ,x_msg_data => l_msg_data
2458: );
2459: IF l_return_status = FND_API.g_ret_sts_error THEN
2460: RAISE FND_API.g_exc_error;
2461: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2462: RAISE FND_API.g_exc_unexpected_error;
2463: END IF;
2464: END IF;

Line 2461: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2457: ,x_msg_data => l_msg_data
2458: );
2459: IF l_return_status = FND_API.g_ret_sts_error THEN
2460: RAISE FND_API.g_exc_error;
2461: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2462: RAISE FND_API.g_exc_unexpected_error;
2463: END IF;
2464: END IF;
2465:

Line 2462: RAISE FND_API.g_exc_unexpected_error;

2458: );
2459: IF l_return_status = FND_API.g_ret_sts_error THEN
2460: RAISE FND_API.g_exc_error;
2461: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2462: RAISE FND_API.g_exc_unexpected_error;
2463: END IF;
2464: END IF;
2465:
2466:

Line 2505: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2501: );
2502: --
2503: -- log errors and dispute line if there are any error in processing the order
2504: -- Continue to next order in case of errors
2505: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2506: IF l_line_tbl.EXISTS(1) THEN
2507: FOR j in 1..l_line_tbl.LAST
2508: LOOP
2509:

Line 2524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2520: p_column_name => NULL,
2521: p_column_value => NULL,
2522: x_return_status => l_return_status);
2523: --
2524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;

Line 2525: RAISE FND_API.g_exc_error;

2521: p_column_value => NULL,
2522: x_return_status => l_return_status);
2523: --
2524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: --

Line 2526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2522: x_return_status => l_return_status);
2523: --
2524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: --
2530: END LOOP;

Line 2527: RAISE FND_API.g_exc_unexpected_error;

2523: --
2524: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2525: RAISE FND_API.g_exc_error;
2526: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2527: RAISE FND_API.g_exc_unexpected_error;
2528: END IF;
2529: --
2530: END LOOP;
2531: IF OZF_DEBUG_LOW_ON THEN

Line 2542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2538: p_line_status => OZF_RESALE_COMMON_PVT.G_BATCH_ADJ_OPEN,
2539: x_return_status => l_return_status
2540: );
2541: --
2542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2543: RAISE FND_API.g_exc_error;
2544: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: END IF;

Line 2543: RAISE FND_API.g_exc_error;

2539: x_return_status => l_return_status
2540: );
2541: --
2542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2543: RAISE FND_API.g_exc_error;
2544: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: END IF;
2547: IF OZF_DEBUG_LOW_ON THEN

Line 2544: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2540: );
2541: --
2542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2543: RAISE FND_API.g_exc_error;
2544: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: END IF;
2547: IF OZF_DEBUG_LOW_ON THEN
2548: OZF_UTILITY_PVT.debug_message('/*--- Get order price failed ---*/');

Line 2545: RAISE FND_API.g_exc_unexpected_error;

2541: --
2542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2543: RAISE FND_API.g_exc_error;
2544: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2545: RAISE FND_API.g_exc_unexpected_error;
2546: END IF;
2547: IF OZF_DEBUG_LOW_ON THEN
2548: OZF_UTILITY_PVT.debug_message('/*--- Get order price failed ---*/');
2549: END IF;

Line 2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2548: OZF_UTILITY_PVT.debug_message('/*--- Get order price failed ---*/');
2549: END IF;
2550: GOTO END_LOOP;
2551: ELSE
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.g_exc_error;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.g_exc_unexpected_error;
2556: END IF;

Line 2553: RAISE FND_API.g_exc_error;

2549: END IF;
2550: GOTO END_LOOP;
2551: ELSE
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.g_exc_error;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.g_exc_unexpected_error;
2556: END IF;
2557: END IF;

Line 2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2550: GOTO END_LOOP;
2551: ELSE
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.g_exc_error;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.g_exc_unexpected_error;
2556: END IF;
2557: END IF;
2558: END IF; -- not success status

Line 2555: RAISE FND_API.g_exc_unexpected_error;

2551: ELSE
2552: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2553: RAISE FND_API.g_exc_error;
2554: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2555: RAISE FND_API.g_exc_unexpected_error;
2556: END IF;
2557: END IF;
2558: END IF; -- not success status
2559:

Line 2574: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2570: x_return_status => l_return_status
2571: );
2572:
2573: -- insert error messages into error stack
2574: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2575: FOR j in 1..l_line_tbl.LAST
2576: LOOP
2577: OZF_RESALE_COMMON_PVT.Insert_Resale_Log (
2578: p_id_value => l_line_tbl(j).chargeback_int_id,

Line 2585: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2581: p_column_name => NULL,
2582: p_column_value => NULL,
2583: x_return_status => l_return_status);
2584: --
2585: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2586: RAISE FND_API.g_exc_error;
2587: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.g_exc_unexpected_error;
2589: END IF;

Line 2586: RAISE FND_API.g_exc_error;

2582: p_column_value => NULL,
2583: x_return_status => l_return_status);
2584: --
2585: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2586: RAISE FND_API.g_exc_error;
2587: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.g_exc_unexpected_error;
2589: END IF;
2590: --

Line 2587: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2583: x_return_status => l_return_status);
2584: --
2585: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2586: RAISE FND_API.g_exc_error;
2587: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.g_exc_unexpected_error;
2589: END IF;
2590: --
2591: END LOOP;

Line 2588: RAISE FND_API.g_exc_unexpected_error;

2584: --
2585: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2586: RAISE FND_API.g_exc_error;
2587: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2588: RAISE FND_API.g_exc_unexpected_error;
2589: END IF;
2590: --
2591: END LOOP;
2592:

Line 2613: RAISE FND_API.g_exc_unexpected_error;

2609: AND resale_batch_id = p_resale_batch_id;
2610: EXCEPTION
2611: WHEN OTHERS THEN
2612: ozf_utility_pvt.error_message( 'OZF_UPD_RESALE_INT_WRG');
2613: RAISE FND_API.g_exc_unexpected_error;
2614: END;
2615: --
2616: IF OZF_DEBUG_LOW_ON THEN
2617: OZF_UTILITY_PVT.debug_message('/*--- Process Pricing Result Failed ---*/');

Line 2650: ,p_init_msg_list => FND_API.G_FALSE

2646:
2647: -- Update Chargeback header with processing detail
2648: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
2649: p_api_version => 1.0
2650: ,p_init_msg_list => FND_API.G_FALSE
2651: ,p_commit => FND_API.G_FALSE
2652: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2653: ,p_resale_batch_id => p_resale_batch_id
2654: ,x_return_status => l_return_status

Line 2651: ,p_commit => FND_API.G_FALSE

2647: -- Update Chargeback header with processing detail
2648: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
2649: p_api_version => 1.0
2650: ,p_init_msg_list => FND_API.G_FALSE
2651: ,p_commit => FND_API.G_FALSE
2652: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2653: ,p_resale_batch_id => p_resale_batch_id
2654: ,x_return_status => l_return_status
2655: ,x_msg_data => l_msg_data

Line 2652: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL

2648: OZF_RESALE_COMMON_PVT.Update_Batch_Calculations (
2649: p_api_version => 1.0
2650: ,p_init_msg_list => FND_API.G_FALSE
2651: ,p_commit => FND_API.G_FALSE
2652: ,p_validation_level => FND_API.G_VALID_LEVEL_FULL
2653: ,p_resale_batch_id => p_resale_batch_id
2654: ,x_return_status => l_return_status
2655: ,x_msg_data => l_msg_data
2656: ,x_msg_count => l_msg_count

Line 2658: IF l_return_status = FND_API.g_ret_sts_error THEN

2654: ,x_return_status => l_return_status
2655: ,x_msg_data => l_msg_data
2656: ,x_msg_count => l_msg_count
2657: );
2658: IF l_return_status = FND_API.g_ret_sts_error THEN
2659: RAISE FND_API.g_exc_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2661: RAISE FND_API.g_exc_unexpected_error;
2662: END IF;

Line 2659: RAISE FND_API.g_exc_error;

2655: ,x_msg_data => l_msg_data
2656: ,x_msg_count => l_msg_count
2657: );
2658: IF l_return_status = FND_API.g_ret_sts_error THEN
2659: RAISE FND_API.g_exc_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2661: RAISE FND_API.g_exc_unexpected_error;
2662: END IF;
2663:

Line 2660: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

2656: ,x_msg_count => l_msg_count
2657: );
2658: IF l_return_status = FND_API.g_ret_sts_error THEN
2659: RAISE FND_API.g_exc_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2661: RAISE FND_API.g_exc_unexpected_error;
2662: END IF;
2663:
2664: -- Debug Message

Line 2661: RAISE FND_API.g_exc_unexpected_error;

2657: );
2658: IF l_return_status = FND_API.g_ret_sts_error THEN
2659: RAISE FND_API.g_exc_error;
2660: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
2661: RAISE FND_API.g_exc_unexpected_error;
2662: END IF;
2663:
2664: -- Debug Message
2665: IF OZF_DEBUG_HIGH_ON THEN

Line 2670: p_encoded => FND_API.G_FALSE,

2666: OZF_UTILITY_PVT.debug_message(p_message_text => l_full_name||': End');
2667: END IF;
2668: --Standard call to get message count AND if count=1, get the message
2669: FND_MSG_PUB.Count_and_Get (
2670: p_encoded => FND_API.G_FALSE,
2671: p_count => x_msg_count,
2672: p_data => x_msg_data
2673: );
2674: EXCEPTION

Line 2675: WHEN FND_API.g_exc_error THEN

2671: p_count => x_msg_count,
2672: p_data => x_msg_data
2673: );
2674: EXCEPTION
2675: WHEN FND_API.g_exc_error THEN
2676: ROLLBACK TO Process_Order;
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: -- Standard call to get message count AND IF count=1, get the message
2679: FND_MSG_PUB.Count_and_Get (

Line 2677: x_return_status := FND_API.G_RET_STS_ERROR;

2673: );
2674: EXCEPTION
2675: WHEN FND_API.g_exc_error THEN
2676: ROLLBACK TO Process_Order;
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: -- Standard call to get message count AND IF count=1, get the message
2679: FND_MSG_PUB.Count_and_Get (
2680: p_encoded => FND_API.G_FALSE,
2681: p_count => x_msg_count,

Line 2680: p_encoded => FND_API.G_FALSE,

2676: ROLLBACK TO Process_Order;
2677: x_return_status := FND_API.G_RET_STS_ERROR;
2678: -- Standard call to get message count AND IF count=1, get the message
2679: FND_MSG_PUB.Count_and_Get (
2680: p_encoded => FND_API.G_FALSE,
2681: p_count => x_msg_count,
2682: p_data => x_msg_data
2683: );
2684: WHEN FND_API.g_exc_unexpected_error THEN

Line 2684: WHEN FND_API.g_exc_unexpected_error THEN

2680: p_encoded => FND_API.G_FALSE,
2681: p_count => x_msg_count,
2682: p_data => x_msg_data
2683: );
2684: WHEN FND_API.g_exc_unexpected_error THEN
2685: ROLLBACK TO Process_Order;
2686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2687: -- Standard call to get message count AND IF count=1, get the message
2688: FND_MSG_PUB.Count_and_Get (

Line 2686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2682: p_data => x_msg_data
2683: );
2684: WHEN FND_API.g_exc_unexpected_error THEN
2685: ROLLBACK TO Process_Order;
2686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2687: -- Standard call to get message count AND IF count=1, get the message
2688: FND_MSG_PUB.Count_and_Get (
2689: p_encoded => FND_API.G_FALSE,
2690: p_count => x_msg_count,

Line 2689: p_encoded => FND_API.G_FALSE,

2685: ROLLBACK TO Process_Order;
2686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2687: -- Standard call to get message count AND IF count=1, get the message
2688: FND_MSG_PUB.Count_and_Get (
2689: p_encoded => FND_API.G_FALSE,
2690: p_count => x_msg_count,
2691: p_data => x_msg_data
2692: );
2693: WHEN OTHERS THEN

Line 2695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2691: p_data => x_msg_data
2692: );
2693: WHEN OTHERS THEN
2694: ROLLBACK TO Process_Order;
2695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2696: IF OZF_UNEXP_ERROR THEN
2697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2698: END IF;
2699: -- Standard call to get message count AND IF count=1, get the message

Line 2701: p_encoded => FND_API.G_FALSE,

2697: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2698: END IF;
2699: -- Standard call to get message count AND IF count=1, get the message
2700: FND_MSG_PUB.Count_and_Get (
2701: p_encoded => FND_API.G_FALSE,
2702: p_count => x_msg_count,
2703: p_data => x_msg_data
2704: );
2705: END Process_Order;