DBA Data[Home] [Help]

APPS.OZF_CLAIM_TAX_PVT dependencies on FND_API

Line 21: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

17: | HISTORY
18: *=======================================================================*/
19: PROCEDURE Validate_Claim_For_Tax(
20: p_api_version IN NUMBER
21: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
22: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
23:
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_data OUT NOCOPY VARCHAR2

Line 22: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

18: *=======================================================================*/
19: PROCEDURE Validate_Claim_For_Tax(
20: p_api_version IN NUMBER
21: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
22: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
23:
24: ,x_return_status OUT NOCOPY VARCHAR2
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ,x_msg_count OUT NOCOPY NUMBER

Line 40: x_return_status := FND_API.g_ret_sts_success;

36: OZF_Utility_PVT.debug_message(l_full_name||' : start');
37: END IF;
38:
39: -- Initialize API return status to sucess
40: x_return_status := FND_API.g_ret_sts_success;
41:
42: -- Do Header Level Validation
43: IF p_claim_rec.payment_method IN ( 'EFT','WIRE','CHECK','AP_DEBIT', 'AP_DEFAULT') AND
44: p_claim_rec.vendor_id IS NULL AND p_claim_rec.vendor_site_id IS NULL THEN

Line 49: RAISE FND_API.g_exc_error;

45: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
46: FND_MESSAGE.set_name('OZF', 'OZF_VENDOR_INFO_MISSING');
47: FND_MSG_PUB.add;
48: END IF;
49: RAISE FND_API.g_exc_error;
50: END IF;
51:
52: IF OZF_DEBUG_HIGH_ON THEN
53: OZF_Utility_PVT.debug_message(l_full_name||' : end');

Line 57: WHEN FND_API.G_EXC_ERROR THEN

53: OZF_Utility_PVT.debug_message(l_full_name||' : end');
54: END IF;
55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: WHEN OTHERS THEN

Line 58: x_return_status := FND_API.G_RET_STS_ERROR;

54: END IF;
55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: WHEN OTHERS THEN
62: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: WHEN OTHERS THEN
62: x_return_status := FND_API.g_ret_sts_unexp_error;
63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN

Line 60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: WHEN OTHERS THEN
62: x_return_status := FND_API.g_ret_sts_unexp_error;
63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
64: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 62: x_return_status := FND_API.g_ret_sts_unexp_error;

58: x_return_status := FND_API.G_RET_STS_ERROR;
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: WHEN OTHERS THEN
62: x_return_status := FND_API.g_ret_sts_unexp_error;
63: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
64: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
65: END IF;
66:

Line 83: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

79: | 14-NOV-2002 mchang Create.
80: *=======================================================================*/
81: PROCEDURE Calculate_Claim_Line_Tax(
82: p_api_version IN NUMBER
83: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
84: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
85:
86: ,x_return_status OUT NOCOPY VARCHAR2
87: ,x_msg_data OUT NOCOPY VARCHAR2

Line 84: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

80: *=======================================================================*/
81: PROCEDURE Calculate_Claim_Line_Tax(
82: p_api_version IN NUMBER
83: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
84: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
85:
86: ,x_return_status OUT NOCOPY VARCHAR2
87: ,x_msg_data OUT NOCOPY VARCHAR2
88: ,x_msg_count OUT NOCOPY NUMBER

Line 204: x_return_status := FND_API.g_ret_sts_success;

200: OZF_Utility_PVT.debug_message(l_full_name||' : start');
201: END IF;
202:
203: -- Initialize API return status to sucess
204: x_return_status := FND_API.g_ret_sts_success;
205:
206: ------------------------ start -------------------------
207: OZF_AR_PAYMENT_PVT.Query_Claim(
208: p_claim_id => p_x_claim_line_rec.claim_id

Line 211: IF l_return_status = FND_API.g_ret_sts_error THEN

207: OZF_AR_PAYMENT_PVT.Query_Claim(
208: p_claim_id => p_x_claim_line_rec.claim_id
209: ,x_claim_rec => l_claim_header
210: ,x_return_status => l_return_status);
211: IF l_return_status = FND_API.g_ret_sts_error THEN
212: RAISE FND_API.g_exc_error;
213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: END IF;

Line 212: RAISE FND_API.g_exc_error;

208: p_claim_id => p_x_claim_line_rec.claim_id
209: ,x_claim_rec => l_claim_header
210: ,x_return_status => l_return_status);
211: IF l_return_status = FND_API.g_ret_sts_error THEN
212: RAISE FND_API.g_exc_error;
213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: END IF;
216:

Line 213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

209: ,x_claim_rec => l_claim_header
210: ,x_return_status => l_return_status);
211: IF l_return_status = FND_API.g_ret_sts_error THEN
212: RAISE FND_API.g_exc_error;
213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: END IF;
216:
217:

Line 214: RAISE FND_API.g_exc_unexpected_error;

210: ,x_return_status => l_return_status);
211: IF l_return_status = FND_API.g_ret_sts_error THEN
212: RAISE FND_API.g_exc_error;
213: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
214: RAISE FND_API.g_exc_unexpected_error;
215: END IF;
216:
217:
218: -- Step 1: Validate (Stage 1)---------------------------------------

Line 227: RAISE FND_API.g_exc_error;

223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
224: FND_MESSAGE.set_name('OZF', 'OZF_PROD_QTY_PRICE_MISSING');
225: FND_MSG_PUB.add;
226: END IF;
227: RAISE FND_API.g_exc_error;
228: END IF;
229: END IF;
230:
231: IF l_claim_header.payment_method = 'REG_CREDIT_MEMO' THEN

Line 238: RAISE FND_API.g_exc_error;

234: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
235: FND_MESSAGE.set_name('OZF', 'OZF_INV_INFO_MISSING');
236: FND_MSG_PUB.add;
237: END IF;
238: RAISE FND_API.g_exc_error;
239: END IF;
240: IF p_x_claim_line_rec. credit_to IS NOT NULL OR p_x_claim_line_rec. source_object_line_id IS NULL THEN
241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
242: FND_MESSAGE.set_name('OZF', 'OZF_REGCM_TAXCALC_ERR');

Line 245: RAISE FND_API.g_exc_error;

241: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
242: FND_MESSAGE.set_name('OZF', 'OZF_REGCM_TAXCALC_ERR');
243: FND_MSG_PUB.add;
244: END IF;
245: RAISE FND_API.g_exc_error;
246: END IF;
247: END IF;
248:
249: -- Step2: Init and Populate the global stucture

Line 467: p_commit => FND_API.g_false,

463:
464:
465: ZX_API_PUB.calculate_tax( p_api_version => 1.0,
466: p_init_msg_list => p_init_msg_list,
467: p_commit => FND_API.g_false,
468: p_validation_level => p_validation_level,
469: x_return_status => l_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,

Line 477: IF l_return_status = FND_API.g_ret_sts_error THEN

473: p_quote_flag => 'Y',
474: p_data_transfer_mode => 'PLS',
475: x_doc_level_recalc_flag => l_dummy
476: );
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;

Line 478: RAISE FND_API.g_exc_error;

474: p_data_transfer_mode => 'PLS',
475: x_doc_level_recalc_flag => l_dummy
476: );
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;
482:

Line 479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

475: x_doc_level_recalc_flag => l_dummy
476: );
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;
482:
483: -- Step 4: Retrieve Data from eTax

Line 480: RAISE FND_API.g_exc_unexpected_error;

476: );
477: IF l_return_status = FND_API.g_ret_sts_error THEN
478: RAISE FND_API.g_exc_error;
479: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
480: RAISE FND_API.g_exc_unexpected_error;
481: END IF;
482:
483: -- Step 4: Retrieve Data from eTax
484: OPEN csr_zx_tax_details(l_claim_header.org_id, l_transaction_rec.application_id,

Line 538: IF l_return_status = FND_API.g_ret_sts_error THEN

534: X_RETURN_STATUS => l_return_status,
535: X_ACC_AMOUNT => p_x_claim_line_rec.acctd_amount,
536: X_RATE => l_return_exc_rate
537: );
538: IF l_return_status = FND_API.g_ret_sts_error THEN
539: RAISE FND_API.g_exc_error;
540: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
541: RAISE FND_API.g_exc_unexpected_error;
542: END IF;

Line 539: RAISE FND_API.g_exc_error;

535: X_ACC_AMOUNT => p_x_claim_line_rec.acctd_amount,
536: X_RATE => l_return_exc_rate
537: );
538: IF l_return_status = FND_API.g_ret_sts_error THEN
539: RAISE FND_API.g_exc_error;
540: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
541: RAISE FND_API.g_exc_unexpected_error;
542: END IF;
543:

Line 540: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

536: X_RATE => l_return_exc_rate
537: );
538: IF l_return_status = FND_API.g_ret_sts_error THEN
539: RAISE FND_API.g_exc_error;
540: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
541: RAISE FND_API.g_exc_unexpected_error;
542: END IF;
543:
544: OZF_UTILITY_PVT.Convert_Currency(

Line 541: RAISE FND_API.g_exc_unexpected_error;

537: );
538: IF l_return_status = FND_API.g_ret_sts_error THEN
539: RAISE FND_API.g_exc_error;
540: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
541: RAISE FND_API.g_exc_unexpected_error;
542: END IF;
543:
544: OZF_UTILITY_PVT.Convert_Currency(
545: P_SET_OF_BOOKS_ID => l_claim_header.set_of_books_id,

Line 555: IF l_return_status = FND_API.g_ret_sts_error THEN

551: X_RETURN_STATUS => l_return_status,
552: X_ACC_AMOUNT => p_x_claim_line_rec.acctd_tax_amount,
553: X_RATE => l_return_exc_rate
554: );
555: IF l_return_status = FND_API.g_ret_sts_error THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;

Line 556: RAISE FND_API.g_exc_error;

552: X_ACC_AMOUNT => p_x_claim_line_rec.acctd_tax_amount,
553: X_RATE => l_return_exc_rate
554: );
555: IF l_return_status = FND_API.g_ret_sts_error THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;
560:

Line 557: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

553: X_RATE => l_return_exc_rate
554: );
555: IF l_return_status = FND_API.g_ret_sts_error THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;
560:
561: END IF;

Line 558: RAISE FND_API.g_exc_unexpected_error;

554: );
555: IF l_return_status = FND_API.g_ret_sts_error THEN
556: RAISE FND_API.g_exc_error;
557: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
558: RAISE FND_API.g_exc_unexpected_error;
559: END IF;
560:
561: END IF;
562:

Line 587: IF l_return_status = FND_API.g_ret_sts_error THEN

583: ,x_return_status => l_return_status
584: ,x_to_amount => p_x_claim_line_rec.tax_amount
585: ,x_rate => l_return_exc_rate
586: );
587: IF l_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;

Line 588: RAISE FND_API.g_exc_error;

584: ,x_to_amount => p_x_claim_line_rec.tax_amount
585: ,x_rate => l_return_exc_rate
586: );
587: IF l_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;
592:

Line 589: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

585: ,x_rate => l_return_exc_rate
586: );
587: IF l_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;
592:
593: -- Convert Acctd Amount into Line Currency Amount

Line 590: RAISE FND_API.g_exc_unexpected_error;

586: );
587: IF l_return_status = FND_API.g_ret_sts_error THEN
588: RAISE FND_API.g_exc_error;
589: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
590: RAISE FND_API.g_exc_unexpected_error;
591: END IF;
592:
593: -- Convert Acctd Amount into Line Currency Amount
594: IF p_x_claim_line_rec.tax_action = 'TAX_ADJ_LINE' THEN

Line 606: IF l_return_status = FND_API.g_ret_sts_error THEN

602: ,x_return_status => l_return_status
603: ,x_to_amount => p_x_claim_line_rec.amount
604: ,x_rate => l_return_exc_rate
605: );
606: IF l_return_status = FND_API.g_ret_sts_error THEN
607: RAISE FND_API.g_exc_error;
608: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
609: RAISE FND_API.g_exc_unexpected_error;
610: END IF;

Line 607: RAISE FND_API.g_exc_error;

603: ,x_to_amount => p_x_claim_line_rec.amount
604: ,x_rate => l_return_exc_rate
605: );
606: IF l_return_status = FND_API.g_ret_sts_error THEN
607: RAISE FND_API.g_exc_error;
608: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
609: RAISE FND_API.g_exc_unexpected_error;
610: END IF;
611: END IF;

Line 608: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

604: ,x_rate => l_return_exc_rate
605: );
606: IF l_return_status = FND_API.g_ret_sts_error THEN
607: RAISE FND_API.g_exc_error;
608: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
609: RAISE FND_API.g_exc_unexpected_error;
610: END IF;
611: END IF;
612:

Line 609: RAISE FND_API.g_exc_unexpected_error;

605: );
606: IF l_return_status = FND_API.g_ret_sts_error THEN
607: RAISE FND_API.g_exc_error;
608: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
609: RAISE FND_API.g_exc_unexpected_error;
610: END IF;
611: END IF;
612:
613: END IF;

Line 625: RAISE FND_API.g_exc_error;

621: FND_MESSAGE.set_name('OZF', 'OZF_ADJLINE_ERR');
622: FND_MESSAGE.set_token('LINE_AMOUNT' , p_x_claim_line_rec.claim_currency_amount );
623: FND_MSG_PUB.add;
624: END IF;
625: RAISE FND_API.g_exc_error;
626: END IF;
627: END IF;
628:
629: ------------------------ finish ------------------------

Line 636: WHEN FND_API.G_EXC_ERROR THEN

632: OZF_Utility_PVT.debug_message(l_full_name||' : end');
633: END IF;
634:
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,
640: p_data => x_msg_data

Line 638: p_encoded => FND_API.g_false,

634:
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: FND_MSG_PUB.count_and_get(
638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );
642: x_return_status := FND_API.G_RET_STS_ERROR;

Line 642: x_return_status := FND_API.G_RET_STS_ERROR;

638: p_encoded => FND_API.g_false,
639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: FND_MSG_PUB.count_and_get(
645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,

Line 643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

639: p_count => x_msg_count,
640: p_data => x_msg_data
641: );
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: FND_MSG_PUB.count_and_get(
645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data

Line 645: p_encoded => FND_API.g_false,

641: );
642: x_return_status := FND_API.G_RET_STS_ERROR;
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: FND_MSG_PUB.count_and_get(
645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: WHEN OTHERS THEN
651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
652: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
653: END IF;

Line 655: p_encoded => FND_API.g_false,

651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
652: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
653: END IF;
654: FND_MSG_PUB.count_and_get(
655: p_encoded => FND_API.g_false,
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659: x_return_status := FND_API.g_ret_sts_unexp_error;

Line 659: x_return_status := FND_API.g_ret_sts_unexp_error;

655: p_encoded => FND_API.g_false,
656: p_count => x_msg_count,
657: p_data => x_msg_data
658: );
659: x_return_status := FND_API.g_ret_sts_unexp_error;
660:
661:
662: END Calculate_Claim_Line_Tax;
663: