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

Line 32: x_return_status := FND_API.G_RET_STS_SUCCESS;

28: p_procedure_name => l_proc_name
29: );
30:
31: -- Initialize API return status to success
32: x_return_status := FND_API.G_RET_STS_SUCCESS;
33:
34: --Deleting all Tax records
35: l_debug_info := 'Deleting Tax records.';
36: INL_LOGGING_PVT.Log_Statement (

Line 80: WHEN FND_API.G_EXC_ERROR THEN

76: p_procedure_name => l_proc_name
77: );
78:
79: EXCEPTION
80: WHEN FND_API.G_EXC_ERROR THEN
81: -- Standard Expected Error Logging
82: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
83: p_procedure_name => l_proc_name);
84: x_return_status := FND_API.G_RET_STS_ERROR;

Line 84: x_return_status := FND_API.G_RET_STS_ERROR;

80: WHEN FND_API.G_EXC_ERROR THEN
81: -- Standard Expected Error Logging
82: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
83: p_procedure_name => l_proc_name);
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: -- Standard Unexpected Error Logging
87: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
88: p_procedure_name => l_proc_name);

Line 85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

81: -- Standard Expected Error Logging
82: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
83: p_procedure_name => l_proc_name);
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: -- Standard Unexpected Error Logging
87: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
88: p_procedure_name => l_proc_name);
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: -- Standard Unexpected Error Logging
87: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
88: p_procedure_name => l_proc_name);
89: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
90: WHEN OTHERS THEN
91: -- Standard Unexpected Error Logging
92: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
93: p_procedure_name => l_proc_name);

Line 94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

90: WHEN OTHERS THEN
91: -- Standard Unexpected Error Logging
92: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
93: p_procedure_name => l_proc_name);
94: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
95: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
96: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
97: END IF;
98: END Delete_PreviousTaxLines;

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148: p_procedure_name => l_proc_name
149: );
150:
151: -- Initialize API return status to success
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: --Getting PO_LINE_LOCATION data
155: l_debug_info := 'Getting PO_LINE_LOCATION data';
156: INL_LOGGING_PVT.Log_Statement (

Line 294: WHEN FND_API.G_EXC_ERROR THEN

290: p_procedure_name => l_proc_name
291: );
292:
293: EXCEPTION
294: WHEN FND_API.G_EXC_ERROR THEN
295: -- Standard Expected Error Logging
296: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
297: p_procedure_name => l_proc_name);
298: x_return_status := FND_API.G_RET_STS_ERROR;

Line 298: x_return_status := FND_API.G_RET_STS_ERROR;

294: WHEN FND_API.G_EXC_ERROR THEN
295: -- Standard Expected Error Logging
296: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
297: p_procedure_name => l_proc_name);
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: -- Standard Unexpected Error Logging
301: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
302: p_procedure_name => l_proc_name);

Line 299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

295: -- Standard Expected Error Logging
296: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
297: p_procedure_name => l_proc_name);
298: x_return_status := FND_API.G_RET_STS_ERROR;
299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: -- Standard Unexpected Error Logging
301: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
302: p_procedure_name => l_proc_name);
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
300: -- Standard Unexpected Error Logging
301: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
302: p_procedure_name => l_proc_name);
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: WHEN OTHERS THEN
305: -- Standard Unexpected Error Logging
306: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
307: p_procedure_name => l_proc_name);

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

304: WHEN OTHERS THEN
305: -- Standard Unexpected Error Logging
306: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
307: p_procedure_name => l_proc_name);
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
310: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
311: END IF;
312: END Prorate_TaxValues;

Line 415: x_return_status := FND_API.G_RET_STS_SUCCESS;

411: p_procedure_name => l_proc_name
412: );
413:
414: -- Initialize API return status to success
415: x_return_status := FND_API.G_RET_STS_SUCCESS;
416:
417: --Uses the zlines cursor
418: l_debug_info := 'Uses the zlines cursor ';
419: INL_LOGGING_PVT.Log_Statement (

Line 480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

476: x_rec_tax_amt => l_rec_tax_amt_prorated,
477: x_return_status => l_return_status
478: );
479: -- If any errors happen abort the process.
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;

Line 481: RAISE FND_API.G_EXC_ERROR;

477: x_return_status => l_return_status
478: );
479: -- If any errors happen abort the process.
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:

Line 482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

478: );
479: -- If any errors happen abort the process.
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486:

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: -- If any errors happen abort the process.
480: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
481: RAISE FND_API.G_EXC_ERROR;
482: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486:
487: l_debug_info := 'l_tax_amt_prorated';

Line 515: WHEN FND_API.G_EXC_ERROR THEN

511: p_procedure_name => l_proc_name);
512:
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: -- Standard Expected Error Logging
517: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
518: p_procedure_name => l_proc_name);
519: x_return_status := FND_API.G_RET_STS_ERROR;

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: WHEN FND_API.G_EXC_ERROR THEN
516: -- Standard Expected Error Logging
517: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
518: p_procedure_name => l_proc_name);
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: -- Standard Unexpected Error Logging
522: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
523: p_procedure_name => l_proc_name);

Line 520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

516: -- Standard Expected Error Logging
517: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
518: p_procedure_name => l_proc_name);
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: -- Standard Unexpected Error Logging
522: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
523: p_procedure_name => l_proc_name);
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: -- Standard Unexpected Error Logging
522: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
523: p_procedure_name => l_proc_name);
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: WHEN OTHERS THEN
526: -- Standard Unexpected Error Logging
527: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
528: p_procedure_name => l_proc_name);

Line 529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

525: WHEN OTHERS THEN
526: -- Standard Unexpected Error Logging
527: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
528: p_procedure_name => l_proc_name);
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
531: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_proc_name);
532: END IF;
533: END Generate_TaxesFromPO;

Line 542: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

538: -- can be the PO or any other logic defined inside the Taxes Hook.
539: -- Pre-reqs : None
540: -- Parameters :
541: -- IN : p_api_version IN NUMBER Required
542: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
543: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
544: -- p_ship_header_id IN NUMBER Required
545: -- p_source IN VARCHAR2 Optional Default = FND_API.G_FALSE
546: --

Line 543: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

539: -- Pre-reqs : None
540: -- Parameters :
541: -- IN : p_api_version IN NUMBER Required
542: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
543: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
544: -- p_ship_header_id IN NUMBER Required
545: -- p_source IN VARCHAR2 Optional Default = FND_API.G_FALSE
546: --
547: -- OUT x_return_status OUT NOCOPY VARCHAR2

Line 545: -- p_source IN VARCHAR2 Optional Default = FND_API.G_FALSE

541: -- IN : p_api_version IN NUMBER Required
542: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
543: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
544: -- p_ship_header_id IN NUMBER Required
545: -- p_source IN VARCHAR2 Optional Default = FND_API.G_FALSE
546: --
547: -- OUT x_return_status OUT NOCOPY VARCHAR2
548: -- x_msg_count OUT NOCOPY NUMBER
549: -- x_msg_data OUT NOCOPY VARCHAR2

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

552: --
553: -- Notes :
554: PROCEDURE Generate_Taxes(
555: p_api_version IN NUMBER,
556: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
557: p_commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_ship_header_id IN NUMBER,
559: p_source IN VARCHAR2 := 'PO',
560: x_return_status OUT NOCOPY VARCHAR2,

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

553: -- Notes :
554: PROCEDURE Generate_Taxes(
555: p_api_version IN NUMBER,
556: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
557: p_commit IN VARCHAR2 := FND_API.G_FALSE,
558: p_ship_header_id IN NUMBER,
559: p_source IN VARCHAR2 := 'PO',
560: x_return_status OUT NOCOPY VARCHAR2,
561: x_msg_count OUT NOCOPY NUMBER,

Line 596: IF FND_API.to_Boolean( p_init_msg_list ) THEN

592: -- Standard Start of API savepoint
593: SAVEPOINT Generate_Taxes_PVT;
594:
595: -- Initialize message list if p_init_msg_list is set to TRUE.
596: IF FND_API.to_Boolean( p_init_msg_list ) THEN
597: FND_MSG_PUB.initialize;
598: END IF;
599:
600: -- Check for call compatibility.

Line 601: IF NOT FND_API.Compatible_API_Call (

597: FND_MSG_PUB.initialize;
598: END IF;
599:
600: -- Check for call compatibility.
601: IF NOT FND_API.Compatible_API_Call (
602: p_current_version_number => l_api_version,
603: p_caller_version_number => p_api_version,
604: p_api_name => l_api_name,
605: p_pkg_name => g_pkg_name)

Line 607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

603: p_caller_version_number => p_api_version,
604: p_api_name => l_api_name,
605: p_pkg_name => g_pkg_name)
606: THEN
607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609:
610: -- Initialize API return status to success
611: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 611: x_return_status := FND_API.G_RET_STS_SUCCESS;

607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609:
610: -- Initialize API return status to success
611: x_return_status := FND_API.G_RET_STS_SUCCESS;
612:
613: l_debug_info := 'Step 1a: Delete data from previous tax Generation/Calculation';
614: -- logging message
615: INL_LOGGING_PVT.Log_Statement (

Line 625: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

621: p_ship_header_id => p_ship_header_id,
622: x_return_status => l_return_status
623: );
624: -- If any errors happen abort API.
625: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;

Line 626: RAISE FND_API.G_EXC_ERROR;

622: x_return_status => l_return_status
623: );
624: -- If any errors happen abort API.
625: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:

Line 627: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

623: );
624: -- If any errors happen abort API.
625: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:
631: -- Getting all Shipment Information to send to Hook

Line 628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

624: -- If any errors happen abort API.
625: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
626: RAISE FND_API.G_EXC_ERROR;
627: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:
631: -- Getting all Shipment Information to send to Hook
632: l_debug_info := 'Getting all Shipment Information to send to Hook';

Line 731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

727: x_return_status => l_return_status
728: );
729:
730: -- If any errors happen abort the process.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;

Line 732: RAISE FND_API.G_EXC_ERROR;

728: );
729:
730: -- If any errors happen abort the process.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736:

Line 733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

729:
730: -- If any errors happen abort the process.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736:
737: IF NOT (l_override_default_processing) THEN

Line 734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

730: -- If any errors happen abort the process.
731: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
732: RAISE FND_API.G_EXC_ERROR;
733: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
734: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
735: END IF;
736:
737: IF NOT (l_override_default_processing) THEN
738: l_debug_info := 'Calls the rotine to generate tax according parameter: ';

Line 751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

747: p_tax_ln_tbl => l_tax_ln_tbl,
748: x_return_status => l_return_status
749: );
750: -- If any errors happen abort the process.
751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;

Line 752: RAISE FND_API.G_EXC_ERROR;

748: x_return_status => l_return_status
749: );
750: -- If any errors happen abort the process.
751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756: END IF;

Line 753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

749: );
750: -- If any errors happen abort the process.
751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756: END IF;
757: END IF;

Line 754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

750: -- If any errors happen abort the process.
751: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
752: RAISE FND_API.G_EXC_ERROR;
753: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756: END IF;
757: END IF;
758:

Line 881: IF FND_API.To_Boolean( p_commit ) THEN

877: END LOOP;
878: END IF;
879:
880: -- Standard check of p_commit.
881: IF FND_API.To_Boolean( p_commit ) THEN
882: COMMIT WORK;
883: END IF;
884:
885: -- Standard call to get message count and if count is 1, get message info.

Line 886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

882: COMMIT WORK;
883: END IF;
884:
885: -- Standard call to get message count and if count is 1, get message info.
886: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
887: p_count => x_msg_count,
888: p_data => x_msg_data);
889:
890: -- Standard End of Procedure/Function Logging

Line 895: WHEN FND_API.G_EXC_ERROR THEN

891: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
892: p_procedure_name => l_api_name);
893:
894: EXCEPTION
895: WHEN FND_API.G_EXC_ERROR THEN
896: -- Standard Expected Error Logging
897: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
898: p_procedure_name => l_api_name);
899: ROLLBACK TO Generate_Taxes_PVT;

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896: -- Standard Expected Error Logging
897: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
898: p_procedure_name => l_api_name);
899: ROLLBACK TO Generate_Taxes_PVT;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data);
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

897: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
898: p_procedure_name => l_api_name);
899: ROLLBACK TO Generate_Taxes_PVT;
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data);
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: -- Standard Unexpected Error Logging

Line 904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

900: x_return_status := FND_API.G_RET_STS_ERROR;
901: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
902: p_count => x_msg_count,
903: p_data => x_msg_data);
904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
905: -- Standard Unexpected Error Logging
906: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
907: p_procedure_name => l_api_name);
908: ROLLBACK TO Generate_Taxes_PVT;

Line 909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

905: -- Standard Unexpected Error Logging
906: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
907: p_procedure_name => l_api_name);
908: ROLLBACK TO Generate_Taxes_PVT;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
911: p_count => x_msg_count,
912: p_data => x_msg_data);
913: WHEN OTHERS THEN

Line 910: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

906: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
907: p_procedure_name => l_api_name);
908: ROLLBACK TO Generate_Taxes_PVT;
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
911: p_count => x_msg_count,
912: p_data => x_msg_data);
913: WHEN OTHERS THEN
914: -- Standard Unexpected Error Logging

Line 918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

914: -- Standard Unexpected Error Logging
915: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
916: p_procedure_name => l_api_name);
917: ROLLBACK TO Generate_Taxes_PVT;
918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
919: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
920: THEN
921: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
922: p_procedure_name => l_api_name);

Line 924: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

920: THEN
921: FND_MSG_PUB.Add_Exc_Msg(p_pkg_name => g_pkg_name,
922: p_procedure_name => l_api_name);
923: END IF;
924: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
925: p_count => x_msg_count,
926: p_data => x_msg_data);
927: END Generate_Taxes;
928:

Line 966: x_return_status := FND_API.G_RET_STS_SUCCESS;

962: -- logging message
963: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
964: p_procedure_name => l_function_name);
965:
966: x_return_status := FND_API.G_RET_STS_SUCCESS;
967:
968: -- get category to derivate Event_Class_Code
969: x_Event_Class_Code := 'ARRIVALS';
970: -- logging message

Line 974: WHEN FND_API.G_EXC_ERROR THEN

970: -- logging message
971: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
972: p_procedure_name => l_function_name);
973: EXCEPTION
974: WHEN FND_API.G_EXC_ERROR THEN
975: -- logging message
976: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
977: p_procedure_name => l_function_name);
978: x_return_status := FND_API.G_RET_STS_ERROR;

Line 978: x_return_status := FND_API.G_RET_STS_ERROR;

974: WHEN FND_API.G_EXC_ERROR THEN
975: -- logging message
976: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
977: p_procedure_name => l_function_name);
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: -- logging message
981: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
982: p_procedure_name => l_function_name);

Line 979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

975: -- logging message
976: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
977: p_procedure_name => l_function_name);
978: x_return_status := FND_API.G_RET_STS_ERROR;
979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: -- logging message
981: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
982: p_procedure_name => l_function_name);
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

979: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
980: -- logging message
981: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
982: p_procedure_name => l_function_name);
983: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
984: WHEN OTHERS THEN
985: -- logging message
986: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
987: p_procedure_name => l_function_name);

Line 988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

984: WHEN OTHERS THEN
985: -- logging message
986: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
987: p_procedure_name => l_function_name);
988: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
989: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
990: THEN
991: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_function_name);
992: END IF;

Line 1026: x_return_status := FND_API.G_RET_STS_SUCCESS;

1022: -- logging message
1023: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1024: p_procedure_name => l_function_name);
1025:
1026: x_return_status := FND_API.G_RET_STS_SUCCESS;
1027: -- get PO_Header_id
1028: SELECT pll.po_header_id, nvl(ph.rate ,1)
1029: INTO x_po_header_id, x_po_header_curr_conv_rate
1030: FROM po_line_locations pll, po_headers ph

Line 1040: WHEN FND_API.G_EXC_ERROR THEN

1036: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1037: p_procedure_name => l_function_name);
1038:
1039: EXCEPTION
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: -- logging message
1042: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1043: p_procedure_name => l_function_name);
1044: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1044: x_return_status := FND_API.G_RET_STS_ERROR;

1040: WHEN FND_API.G_EXC_ERROR THEN
1041: -- logging message
1042: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1043: p_procedure_name => l_function_name);
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: -- logging message
1047: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1048: p_procedure_name => l_function_name);

Line 1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1041: -- logging message
1042: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1043: p_procedure_name => l_function_name);
1044: x_return_status := FND_API.G_RET_STS_ERROR;
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: -- logging message
1047: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1048: p_procedure_name => l_function_name);
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: -- logging message
1047: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1048: p_procedure_name => l_function_name);
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: WHEN OTHERS THEN
1051: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1052: p_procedure_name => l_function_name);
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: WHEN OTHERS THEN
1051: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1052: p_procedure_name => l_function_name);
1053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1054: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1055: THEN
1056: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_function_name);
1057: END IF;

Line 1092: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1088: -- This flag is always N except when the calculate service is called for
1089: -- quote for the recurring invoices and distributions sets.
1090: l_quote_flag VARCHAR2(1);
1091:
1092: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1093: l_ship_to_organization_id NUMBER;
1094: l_ledger_id NUMBER;
1095: l_tax_event_type_code VARCHAR2(30);
1096: l_doc_level_recalc_flag VARCHAR2(1):='Y';

Line 1103: x_return_status := FND_API.G_RET_STS_SUCCESS;

1099: -- logging message
1100: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1101: p_procedure_name => l_function_name);
1102:
1103: x_return_status := FND_API.G_RET_STS_SUCCESS;
1104:
1105: -------------------------------------------------------------------
1106: l_debug_info := 'Step 3: Populate product specific attributes';
1107: -------------------------------------------------------------------

Line 1151: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1147: l_step:='03';
1148: -------------------------------------------------------------------
1149: l_debug_info := 'Step 8: Populate zx_trx_headers_gt';
1150: -------------------------------------------------------------------
1151: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1152: -- logging message
1153: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1154: p_procedure_name => l_function_name,
1155: p_debug_info => l_debug_info);

Line 1333: WHEN FND_API.G_EXC_ERROR THEN

1329: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1330: p_procedure_name => l_function_name);
1331:
1332: EXCEPTION
1333: WHEN FND_API.G_EXC_ERROR THEN
1334: -- logging message
1335: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1336: p_procedure_name => l_function_name||l_step);
1337: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

1333: WHEN FND_API.G_EXC_ERROR THEN
1334: -- logging message
1335: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1336: p_procedure_name => l_function_name||l_step);
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: -- logging message
1340: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1341: p_procedure_name => l_function_name||l_step);

Line 1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1334: -- logging message
1335: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1336: p_procedure_name => l_function_name||l_step);
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: -- logging message
1340: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1341: p_procedure_name => l_function_name||l_step);
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: -- logging message
1340: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1341: p_procedure_name => l_function_name||l_step);
1342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1343: WHEN OTHERS THEN
1344: -- logging message
1345: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1346: p_procedure_name => l_function_name||l_step);

Line 1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1343: WHEN OTHERS THEN
1344: -- logging message
1345: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1346: p_procedure_name => l_function_name||l_step);
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1349: THEN
1350: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_function_name);
1351: END IF;

Line 1405: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1401: l_ship_from_location_id NUMBER;
1402: l_dflt_tax_class_code VARCHAR2(30);
1403: l_allow_tax_code_override VARCHAR2(10);
1404: l_ship_line_type_code VARCHAR2(30);
1405: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1406: l_to_parent_table_name VARCHAR2(30);
1407: l_to_parent_table_id NUMBER;
1408: l_precision NUMBER(1);
1409: l_minimum_accountable_unit NUMBER;

Line 1416: x_return_status := FND_API.G_RET_STS_SUCCESS;

1412: -- logging message
1413: INL_LOGGING_PVT.Log_BeginProc (p_module_name => g_module_name,
1414: p_procedure_name => l_function_name);
1415:
1416: x_return_status := FND_API.G_RET_STS_SUCCESS;
1417: -----------------------------------------------------------------
1418: l_debug_info := 'IN Populating shipment lines collection';
1419: -- logging message
1420: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,

Line 1449: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

1445: /* 10/07/07 Currency columns was transfer to lines */
1446: -------------------------------------------------------------------
1447: l_debug_info := 'Step 3: Get transaction line currency details';
1448: -------------------------------------------------------------------
1449: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
1450: BEGIN
1451: SELECT NVL(precision, 0), NVL(minimum_accountable_unit,(1/power(10,precision)))
1452: INTO l_precision, l_minimum_accountable_unit
1453: FROM fnd_currencies

Line 1458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1454: WHERE currency_code = l_ship_line_list(i).currency_code;
1455: EXCEPTION
1456: WHEN OTHERS THEN
1457: IF (SQLCODE <> -20001) THEN
1458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1459: -- logging message
1460: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1461: p_procedure_name => l_function_name);
1462: END IF;

Line 1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1558: x_po_header_curr_conv_rate => l_po_header_curr_conv_rate,
1559: x_return_status => l_return_status);
1560:
1561: -- If any errors happen abort API.
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;

Line 1563: RAISE FND_API.G_EXC_ERROR;

1559: x_return_status => l_return_status);
1560:
1561: -- If any errors happen abort API.
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567:

Line 1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1560:
1561: -- If any errors happen abort API.
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567:
1568: l_ref_doc_trx_level_type := 'SHIPMENT';

Line 1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1561: -- If any errors happen abort API.
1562: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1563: RAISE FND_API.G_EXC_ERROR;
1564: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1565: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1566: END IF;
1567:
1568: l_ref_doc_trx_level_type := 'SHIPMENT';
1569: l_ref_doc_line_id := l_ship_line_list(i).src_id;

Line 1620: IF (l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

1616: p_procedure_name => l_function_name,
1617: p_debug_info => l_debug_info);
1618: ------------------------------------------------------------------
1619: -- Will populate a dinamic table to include in zx_transaction_lines_gt
1620: IF (l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1621: trans_lines(i).application_id := 9004;
1622: trans_lines(i).entity_code := G_ENTITY_CODE;
1623: trans_lines(i).event_class_code := p_event_class_code;
1624: trans_lines(i).trx_line_precision := l_precision;

Line 1692: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN

1688: ------------------------------------------------------------------
1689: END IF;
1690: END LOOP;
1691: END IF;
1692: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
1693: -- if exist any row from this shipment it will be removed
1694: DELETE FROM zx_transaction_lines_gt
1695: WHERE trx_id= l_ship_header_rec.ship_header_id;
1696: -------------------------------------------------------------------

Line 1721: WHEN FND_API.G_EXC_ERROR THEN

1717: INL_LOGGING_PVT.Log_EndProc (p_module_name => g_module_name,
1718: p_procedure_name => l_function_name);
1719:
1720: EXCEPTION
1721: WHEN FND_API.G_EXC_ERROR THEN
1722: -- logging message
1723: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1724: p_procedure_name => l_function_name);
1725: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1725: x_return_status := FND_API.G_RET_STS_ERROR;

1721: WHEN FND_API.G_EXC_ERROR THEN
1722: -- logging message
1723: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1724: p_procedure_name => l_function_name);
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: -- logging message
1728: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1729: p_procedure_name => l_function_name);

Line 1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1722: -- logging message
1723: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
1724: p_procedure_name => l_function_name);
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: -- logging message
1728: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1729: p_procedure_name => l_function_name);
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: -- logging message
1728: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1729: p_procedure_name => l_function_name);
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731: WHEN OTHERS THEN
1732: -- logging message
1733: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1734: p_procedure_name => l_function_name);

Line 1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1731: WHEN OTHERS THEN
1732: -- logging message
1733: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
1734: p_procedure_name => l_function_name);
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1737: THEN
1738: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_function_name);
1739: END IF;

Line 1780: x_return_status := FND_API.G_RET_STS_SUCCESS;

1776: p_module_name => g_module_name,
1777: p_procedure_name => l_procedure_name
1778: );
1779:
1780: x_return_status := FND_API.G_RET_STS_SUCCESS;
1781: FOR curTax in (SELECT zl.tax_line_id
1782: ,zl.tax_line_number
1783: ,zl.tax_code
1784: ,zl.trx_id

Line 1943: WHEN FND_API.G_EXC_ERROR THEN

1939: p_procedure_name => l_procedure_name
1940: );
1941:
1942: EXCEPTION
1943: WHEN FND_API.G_EXC_ERROR THEN
1944: -- logging message
1945: INL_LOGGING_PVT.Log_ExpecError (
1946: p_module_name => g_module_name,
1947: p_procedure_name => l_procedure_name

Line 1949: x_return_status := FND_API.G_RET_STS_ERROR;

1945: INL_LOGGING_PVT.Log_ExpecError (
1946: p_module_name => g_module_name,
1947: p_procedure_name => l_procedure_name
1948: );
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1951: -- logging message
1952: INL_LOGGING_PVT.Log_UnexpecError (
1953: p_module_name => g_module_name,

Line 1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1946: p_module_name => g_module_name,
1947: p_procedure_name => l_procedure_name
1948: );
1949: x_return_status := FND_API.G_RET_STS_ERROR;
1950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1951: -- logging message
1952: INL_LOGGING_PVT.Log_UnexpecError (
1953: p_module_name => g_module_name,
1954: p_procedure_name => l_procedure_name

Line 1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1952: INL_LOGGING_PVT.Log_UnexpecError (
1953: p_module_name => g_module_name,
1954: p_procedure_name => l_procedure_name
1955: );
1956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1957: WHEN OTHERS THEN
1958: -- logging message
1959: INL_LOGGING_PVT.Log_UnexpecError (
1960: p_module_name => g_module_name,

Line 1963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1959: INL_LOGGING_PVT.Log_UnexpecError (
1960: p_module_name => g_module_name,
1961: p_procedure_name => l_procedure_name
1962: );
1963: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1964: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1965: THEN
1966: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_procedure_name);
1967: END IF;

Line 1977: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1973: -- Function : It populate the ZX temporary GT tables and then call eBTax Calculate Tax for a given LCM Shipment.
1974: -- Pre-reqs : None
1975: -- Parameters :
1976: -- IN : p_api_version IN NUMBER,
1977: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1978: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
1979: -- p_ship_header_id IN NUMBER,
1980: --
1981: -- OUT : x_return_status OUT NOCOPY VARCHAR2

Line 1978: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,

1974: -- Pre-reqs : None
1975: -- Parameters :
1976: -- IN : p_api_version IN NUMBER,
1977: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1978: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
1979: -- p_ship_header_id IN NUMBER,
1980: --
1981: -- OUT : x_return_status OUT NOCOPY VARCHAR2
1982: -- x_msg_count OUT NOCOPY NUMBER

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

1987: -- Notes :
1988:
1989: PROCEDURE Calculate_Tax(
1990: p_api_version IN NUMBER,
1991: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1992: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1993: p_ship_header_id IN NUMBER,
1994: x_return_status OUT NOCOPY VARCHAR2,
1995: x_msg_count OUT NOCOPY NUMBER,

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

1988:
1989: PROCEDURE Calculate_Tax(
1990: p_api_version IN NUMBER,
1991: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1992: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1993: p_ship_header_id IN NUMBER,
1994: x_return_status OUT NOCOPY VARCHAR2,
1995: x_msg_count OUT NOCOPY NUMBER,
1996: x_msg_data OUT NOCOPY VARCHAR2

Line 2013: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2009: l_msg_data VARCHAR2(4000);
2010: l_msg VARCHAR2(4000);
2011: l_error_code VARCHAR2(30);
2012:
2013: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2014: l_no_tax_lines VARCHAR2(1) := 'N';
2015: l_inv_rcv_matched VARCHAR2(1) := 'N';
2016:
2017: l_ledger_list GL_MC_INFO.r_sob_list;

Line 2033: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2029: -- Standard Start of API savepoint
2030: SAVEPOINT Calculate_Tax_PVT;
2031:
2032: -- Initialize message list if p_init_msg_list is set to TRUE.
2033: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2034: FND_MSG_PUB.initialize;
2035: END IF;
2036:
2037: -------------------------------------------------------------------

Line 2038: l_debug_info := 'FND_API.Compatible_API_Call';

2034: FND_MSG_PUB.initialize;
2035: END IF;
2036:
2037: -------------------------------------------------------------------
2038: l_debug_info := 'FND_API.Compatible_API_Call';
2039: -------------------------------------------------------------------
2040: -- logging message
2041: INL_LOGGING_PVT.Log_Statement (
2042: p_module_name => g_module_name,

Line 2047: IF NOT FND_API.Compatible_API_Call (

2043: p_procedure_name => l_api_name,
2044: p_debug_info => l_debug_info
2045: );
2046: -- Check for call compatibility.
2047: IF NOT FND_API.Compatible_API_Call (
2048: l_api_version,
2049: p_api_version,
2050: l_api_name,
2051: G_PKG_NAME)

Line 2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2049: p_api_version,
2050: l_api_name,
2051: G_PKG_NAME)
2052: THEN
2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2054: END IF;
2055:
2056: -- Initialize API return status to success
2057: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2057: x_return_status := FND_API.G_RET_STS_SUCCESS;

2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2054: END IF;
2055:
2056: -- Initialize API return status to success
2057: x_return_status := FND_API.G_RET_STS_SUCCESS;
2058:
2059:
2060:
2061: --- VPILAN 11-Jun-2008

Line 2089: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

2085: p_procedure_name => l_api_name,
2086: p_debug_info => l_debug_info
2087: );
2088: -----------------------------------------------------------------
2089: IF ( l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
2090: l_debug_info := 'Step 1a: Delete data from previous tax Generation/Calculation';
2091: -- logging message
2092: INL_LOGGING_PVT.Log_Statement (
2093: p_module_name => g_module_name,

Line 2102: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2098: p_ship_header_id => p_ship_header_id,
2099: x_return_status => l_return_status
2100: );
2101: -- If any errors happen abort API.
2102: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2106: END IF;

Line 2103: RAISE FND_API.G_EXC_ERROR;

2099: x_return_status => l_return_status
2100: );
2101: -- If any errors happen abort API.
2102: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2106: END IF;
2107: -----------------------------------------------------------------

Line 2104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2100: );
2101: -- If any errors happen abort API.
2102: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2106: END IF;
2107: -----------------------------------------------------------------
2108: l_debug_info := 'Step 2: Populating shipment header local record';

Line 2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2101: -- If any errors happen abort API.
2102: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2103: RAISE FND_API.G_EXC_ERROR;
2104: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2106: END IF;
2107: -----------------------------------------------------------------
2108: l_debug_info := 'Step 2: Populating shipment header local record';
2109: INL_LOGGING_PVT.Log_Statement (

Line 2153: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2149: x_event_class_code => l_event_class_code,
2150: x_return_status => l_return_status
2151: );
2152: -- If any errors happen abort API.
2153: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2154: RAISE FND_API.G_EXC_ERROR;
2155: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2157: END IF;

Line 2154: RAISE FND_API.G_EXC_ERROR;

2150: x_return_status => l_return_status
2151: );
2152: -- If any errors happen abort API.
2153: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2154: RAISE FND_API.G_EXC_ERROR;
2155: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2157: END IF;
2158:

Line 2155: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2151: );
2152: -- If any errors happen abort API.
2153: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2154: RAISE FND_API.G_EXC_ERROR;
2155: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2157: END IF;
2158:
2159: -----------------------------------------------------------------

Line 2156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2152: -- If any errors happen abort API.
2153: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2154: RAISE FND_API.G_EXC_ERROR;
2155: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2156: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2157: END IF;
2158:
2159: -----------------------------------------------------------------
2160: l_debug_info := 'Step 2c: Getting l_tax_already_calculated. trx_id= '||l_ship_header_rec.ship_header_id

Line 2202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2198: x_return_status => l_return_status
2199: );
2200:
2201: -- If any errors happen abort API.
2202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2203: RAISE FND_API.G_EXC_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2206: END IF;

Line 2203: RAISE FND_API.G_EXC_ERROR;

2199: );
2200:
2201: -- If any errors happen abort API.
2202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2203: RAISE FND_API.G_EXC_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2206: END IF;
2207: -----------------------------------------------------------------

Line 2204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2200:
2201: -- If any errors happen abort API.
2202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2203: RAISE FND_API.G_EXC_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2206: END IF;
2207: -----------------------------------------------------------------
2208: l_debug_info := 'Step 4: Populate TRX lines';

Line 2205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2201: -- If any errors happen abort API.
2202: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2203: RAISE FND_API.G_EXC_ERROR;
2204: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2206: END IF;
2207: -----------------------------------------------------------------
2208: l_debug_info := 'Step 4: Populate TRX lines';
2209: -- logging message

Line 2216: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2212: p_procedure_name => l_api_name,
2213: p_debug_info => l_debug_info
2214: );
2215: -----------------------------------------------------------------
2216: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2217: -- Populate eBTax temporary table (Lines)
2218:
2219: INL_TAX_PVT.Populate_Lines_GT(
2220: P_Event_Class_Code => l_event_class_code,

Line 2225: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2221: P_Line_Number => 1,
2222: x_return_status => l_return_status
2223: );
2224: -- If any errors happen abort API.
2225: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2226: RAISE FND_API.G_EXC_ERROR;
2227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;

Line 2226: RAISE FND_API.G_EXC_ERROR;

2222: x_return_status => l_return_status
2223: );
2224: -- If any errors happen abort API.
2225: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2226: RAISE FND_API.G_EXC_ERROR;
2227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:

Line 2227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2223: );
2224: -- If any errors happen abort API.
2225: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2226: RAISE FND_API.G_EXC_ERROR;
2227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:
2231:

Line 2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2224: -- If any errors happen abort API.
2225: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2226: RAISE FND_API.G_EXC_ERROR;
2227: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:
2231:
2232: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 2232: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2229: END IF;
2230:
2231:
2232: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2233: -- logging message
2234: INL_LOGGING_PVT.Log_APICallIn (
2235: p_module_name => g_module_name,
2236: p_procedure_name => l_api_name,

Line 2241: p_in_param_value2 => FND_API.G_TRUE,

2237: p_call_api_name => 'ZX_API_PUB.Calculate_Tax',
2238: p_in_param_name1 => 'p_api_version',
2239: p_in_param_value1 => 1.0,
2240: p_in_param_name2 => 'p_init_msg_list',
2241: p_in_param_value2 => FND_API.G_TRUE,
2242: p_in_param_name3 => 'p_commit',
2243: p_in_param_value3 => FND_API.G_FALSE,
2244: p_in_param_name4 => 'p_validation_level',
2245: p_in_param_value4 => FND_API.G_VALID_LEVEL_FULL

Line 2243: p_in_param_value3 => FND_API.G_FALSE,

2239: p_in_param_value1 => 1.0,
2240: p_in_param_name2 => 'p_init_msg_list',
2241: p_in_param_value2 => FND_API.G_TRUE,
2242: p_in_param_name3 => 'p_commit',
2243: p_in_param_value3 => FND_API.G_FALSE,
2244: p_in_param_name4 => 'p_validation_level',
2245: p_in_param_value4 => FND_API.G_VALID_LEVEL_FULL
2246: );
2247: --- It will run the calculate_tax procedure from eBTax

Line 2245: p_in_param_value4 => FND_API.G_VALID_LEVEL_FULL

2241: p_in_param_value2 => FND_API.G_TRUE,
2242: p_in_param_name3 => 'p_commit',
2243: p_in_param_value3 => FND_API.G_FALSE,
2244: p_in_param_name4 => 'p_validation_level',
2245: p_in_param_value4 => FND_API.G_VALID_LEVEL_FULL
2246: );
2247: --- It will run the calculate_tax procedure from eBTax
2248: --- This procedure will calculate the tax from the current transaction
2249: --- and populate zx_lines

Line 2257: p_init_msg_list => FND_API.G_FALSE,

2253: WHERE TRX_ID = l_ship_header_rec.ship_header_id
2254: */
2255: zx_api_pub.calculate_tax(
2256: p_api_version => 1.0,
2257: p_init_msg_list => FND_API.G_FALSE,
2258: p_commit => FND_API.G_FALSE,
2259: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2260: x_return_status => l_return_status,
2261: x_msg_count => l_msg_count,

Line 2258: p_commit => FND_API.G_FALSE,

2254: */
2255: zx_api_pub.calculate_tax(
2256: p_api_version => 1.0,
2257: p_init_msg_list => FND_API.G_FALSE,
2258: p_commit => FND_API.G_FALSE,
2259: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2260: x_return_status => l_return_status,
2261: x_msg_count => l_msg_count,
2262: x_msg_data => l_msg_data

Line 2259: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2255: zx_api_pub.calculate_tax(
2256: p_api_version => 1.0,
2257: p_init_msg_list => FND_API.G_FALSE,
2258: p_commit => FND_API.G_FALSE,
2259: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2260: x_return_status => l_return_status,
2261: x_msg_count => l_msg_count,
2262: x_msg_data => l_msg_data
2263: );

Line 2278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2274: p_out_param_name3 => 'l_msg_data',
2275: p_out_param_value3 => l_msg_data);
2276:
2277: -- If any errors happen abort API.
2278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2282: END IF;

Line 2279: RAISE FND_API.G_EXC_ERROR;

2275: p_out_param_value3 => l_msg_data);
2276:
2277: -- If any errors happen abort API.
2278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2282: END IF;
2283:

Line 2280: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2276:
2277: -- If any errors happen abort API.
2278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2282: END IF;
2283:
2284: -----------------------------------------------------------------

Line 2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2277: -- If any errors happen abort API.
2278: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2279: RAISE FND_API.G_EXC_ERROR;
2280: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2282: END IF;
2283:
2284: -----------------------------------------------------------------
2285: l_debug_info := 'Step 6: Adjust_Tax_Lines to Persist tax records in INL_ASSOCIATIONS and INL_TAX_LINES';

Line 2295: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2291: -----------------------------------------------------------------
2292: -- It will answer the updates done in zx_lines in INL_tax_lines
2293: Adjust_Tax_Lines(p_ship_header_id, l_return_status);
2294: -- If any errors happen abort API.
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: -- It will answer the updates done in zx_lines in INL_tax_lines
2293: Adjust_Tax_Lines(p_ship_header_id, l_return_status);
2294: -- If any errors happen abort API.
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: Adjust_Tax_Lines(p_ship_header_id, l_return_status);
2294: -- If any errors happen abort API.
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: -----------------------------------------------------------------

Line 2298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2294: -- If any errors happen abort API.
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: -----------------------------------------------------------------
2302: l_debug_info := 'Step 7: call LCM Calculation for tax lines';

Line 2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2310: END IF;
2311: END IF;
2312: END IF;
2313: -- If any errors happen abort API.
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;

Line 2315: RAISE FND_API.G_EXC_ERROR;

2311: END IF;
2312: END IF;
2313: -- If any errors happen abort API.
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319:

Line 2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2312: END IF;
2313: -- If any errors happen abort API.
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319:
2320: -- Standard check of p_commit.

Line 2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2313: -- If any errors happen abort API.
2314: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2315: RAISE FND_API.G_EXC_ERROR;
2316: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319:
2320: -- Standard check of p_commit.
2321: IF FND_API.To_Boolean( p_commit ) THEN

Line 2321: IF FND_API.To_Boolean( p_commit ) THEN

2317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2318: END IF;
2319:
2320: -- Standard check of p_commit.
2321: IF FND_API.To_Boolean( p_commit ) THEN
2322: COMMIT WORK;
2323: END IF;
2324:
2325: -- Standard call to get message count and if count is 1, get message info.

Line 2327: p_encoded => FND_API.g_false,

2323: END IF;
2324:
2325: -- Standard call to get message count and if count is 1, get message info.
2326: FND_MSG_PUB.Count_And_Get(
2327: p_encoded => FND_API.g_false,
2328: p_count => x_msg_count,
2329: p_data => x_msg_data);
2330:
2331: INL_LOGGING_PVT.Log_EndProc (

Line 2335: WHEN FND_API.G_EXC_ERROR THEN

2331: INL_LOGGING_PVT.Log_EndProc (
2332: p_module_name => g_module_name,
2333: p_procedure_name => l_api_name);
2334: EXCEPTION
2335: WHEN FND_API.G_EXC_ERROR THEN
2336: INL_LOGGING_PVT.Log_ExpecError (
2337: p_module_name => g_module_name,
2338: p_procedure_name => l_api_name);
2339: ROLLBACK TO Calculate_Tax_PVT;

Line 2340: x_return_status := FND_API.G_RET_STS_ERROR;

2336: INL_LOGGING_PVT.Log_ExpecError (
2337: p_module_name => g_module_name,
2338: p_procedure_name => l_api_name);
2339: ROLLBACK TO Calculate_Tax_PVT;
2340: x_return_status := FND_API.G_RET_STS_ERROR;
2341: FND_MSG_PUB.Count_And_Get(
2342: p_encoded => FND_API.g_false,
2343: p_count => x_msg_count,
2344: p_data => x_msg_data);

Line 2342: p_encoded => FND_API.g_false,

2338: p_procedure_name => l_api_name);
2339: ROLLBACK TO Calculate_Tax_PVT;
2340: x_return_status := FND_API.G_RET_STS_ERROR;
2341: FND_MSG_PUB.Count_And_Get(
2342: p_encoded => FND_API.g_false,
2343: p_count => x_msg_count,
2344: p_data => x_msg_data);
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: INL_LOGGING_PVT.Log_UnexpecError (

Line 2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2341: FND_MSG_PUB.Count_And_Get(
2342: p_encoded => FND_API.g_false,
2343: p_count => x_msg_count,
2344: p_data => x_msg_data);
2345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2346: INL_LOGGING_PVT.Log_UnexpecError (
2347: p_module_name => g_module_name,
2348: p_procedure_name => l_api_name);
2349: ROLLBACK TO Calculate_Tax_PVT;

Line 2350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2346: INL_LOGGING_PVT.Log_UnexpecError (
2347: p_module_name => g_module_name,
2348: p_procedure_name => l_api_name);
2349: ROLLBACK TO Calculate_Tax_PVT;
2350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2351: FND_MSG_PUB.Count_And_Get(
2352: p_encoded => FND_API.g_false,
2353: p_count => x_msg_count,
2354: p_data => x_msg_data);

Line 2352: p_encoded => FND_API.g_false,

2348: p_procedure_name => l_api_name);
2349: ROLLBACK TO Calculate_Tax_PVT;
2350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2351: FND_MSG_PUB.Count_And_Get(
2352: p_encoded => FND_API.g_false,
2353: p_count => x_msg_count,
2354: p_data => x_msg_data);
2355: WHEN OTHERS THEN
2356: -- logging message

Line 2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2357: INL_LOGGING_PVT.Log_UnexpecError (
2358: p_module_name => g_module_name,
2359: p_procedure_name => l_api_name);
2360: ROLLBACK TO Calculate_Tax_PVT;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2362: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2363: THEN
2364: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2365: END IF;

Line 2367: p_encoded => FND_API.g_false,

2363: THEN
2364: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
2365: END IF;
2366: FND_MSG_PUB.Count_And_Get(
2367: p_encoded => FND_API.g_false,
2368: p_count => x_msg_count,
2369: p_data => x_msg_data);
2370: END Calculate_Tax;
2371:

Line 2378: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2374: -- Function : Get default tax attributes
2375: -- Pre-reqs : None
2376: -- Parameters :
2377: -- IN : p_api_version IN NUMBER,
2378: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2379: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
2380: -- p_application_id IN NUMBER,
2381: -- p_entity_code IN VARCHAR2,
2382: -- p_event_class_code IN VARCHAR2,

Line 2379: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,

2375: -- Pre-reqs : None
2376: -- Parameters :
2377: -- IN : p_api_version IN NUMBER,
2378: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2379: -- p_commit IN VARCHAR2 := FND_API.G_FALSE,
2380: -- p_application_id IN NUMBER,
2381: -- p_entity_code IN VARCHAR2,
2382: -- p_event_class_code IN VARCHAR2,
2383: -- p_org_id IN VARCHAR2,

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

2398: -- Version : Current version 1.0
2399: --
2400: -- Notes :
2401: PROCEDURE Get_DefaultTaxDetAttribs(p_api_version IN NUMBER,
2402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2404: p_application_id IN NUMBER,
2405: p_entity_code IN VARCHAR2,
2406: p_event_class_code IN VARCHAR2,

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

2399: --
2400: -- Notes :
2401: PROCEDURE Get_DefaultTaxDetAttribs(p_api_version IN NUMBER,
2402: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2403: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2404: p_application_id IN NUMBER,
2405: p_entity_code IN VARCHAR2,
2406: p_event_class_code IN VARCHAR2,
2407: p_org_id IN VARCHAR2,

Line 2440: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2436: -- Standard Start of API savepoint
2437: SAVEPOINT Get_DefaultTaxDetAttribs_PVT;
2438:
2439: -- Initialize message list if p_init_msg_list is set to TRUE.
2440: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2441: FND_MSG_PUB.initialize;
2442: END IF;
2443:
2444: -- Check for call compatibility.

Line 2445: IF NOT FND_API.Compatible_API_Call (l_api_version,

2441: FND_MSG_PUB.initialize;
2442: END IF;
2443:
2444: -- Check for call compatibility.
2445: IF NOT FND_API.Compatible_API_Call (l_api_version,
2446: p_api_version,
2447: l_api_name,
2448: g_pkg_name)
2449: THEN

Line 2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2446: p_api_version,
2447: l_api_name,
2448: g_pkg_name)
2449: THEN
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END IF;
2452:
2453: -- Initialize API return status to success
2454: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2454: x_return_status := FND_API.G_RET_STS_SUCCESS;

2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2451: END IF;
2452:
2453: -- Initialize API return status to success
2454: x_return_status := FND_API.G_RET_STS_SUCCESS;
2455:
2456: -- API Body
2457: BEGIN
2458:

Line 2511: p_init_msg_list => FND_API.G_FALSE,

2507:
2508: IF(l_po_country_code IS NULL OR l_po_country_code <> p_country_code) THEN
2509:
2510: ZX_API_PUB.get_default_tax_det_attribs(p_api_version => 1.0,
2511: p_init_msg_list => FND_API.G_FALSE,
2512: p_commit => FND_API.G_FALSE,
2513: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2514: x_return_status => l_return_status,
2515: x_msg_count => l_msg_count,

Line 2512: p_commit => FND_API.G_FALSE,

2508: IF(l_po_country_code IS NULL OR l_po_country_code <> p_country_code) THEN
2509:
2510: ZX_API_PUB.get_default_tax_det_attribs(p_api_version => 1.0,
2511: p_init_msg_list => FND_API.G_FALSE,
2512: p_commit => FND_API.G_FALSE,
2513: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2514: x_return_status => l_return_status,
2515: x_msg_count => l_msg_count,
2516: x_msg_data => l_msg_data,

Line 2513: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2509:
2510: ZX_API_PUB.get_default_tax_det_attribs(p_api_version => 1.0,
2511: p_init_msg_list => FND_API.G_FALSE,
2512: p_commit => FND_API.G_FALSE,
2513: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2514: x_return_status => l_return_status,
2515: x_msg_count => l_msg_count,
2516: x_msg_data => l_msg_data,
2517: p_application_id => p_application_id,

Line 2531: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2527: x_prod_category => x_prod_category,
2528: x_prod_fisc_class_code => x_prod_fisc_class_code,
2529: x_product_type => x_product_type);
2530: -- If any errors happen abort API.
2531: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;

Line 2532: RAISE FND_API.G_EXC_ERROR;

2528: x_prod_fisc_class_code => x_prod_fisc_class_code,
2529: x_product_type => x_product_type);
2530: -- If any errors happen abort API.
2531: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: END IF;

Line 2533: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2529: x_product_type => x_product_type);
2530: -- If any errors happen abort API.
2531: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: END IF;
2537: ELSE

Line 2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2530: -- If any errors happen abort API.
2531: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2532: RAISE FND_API.G_EXC_ERROR;
2533: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2535: END IF;
2536: END IF;
2537: ELSE
2538:

Line 2540: p_init_msg_list => FND_API.G_FALSE,

2536: END IF;
2537: ELSE
2538:
2539: ZX_API_PUB.get_default_tax_det_attribs(p_api_version => 1.0,
2540: p_init_msg_list => FND_API.G_FALSE,
2541: p_commit => FND_API.G_FALSE,
2542: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2543: x_return_status => l_return_status,
2544: x_msg_count => l_msg_count,

Line 2541: p_commit => FND_API.G_FALSE,

2537: ELSE
2538:
2539: ZX_API_PUB.get_default_tax_det_attribs(p_api_version => 1.0,
2540: p_init_msg_list => FND_API.G_FALSE,
2541: p_commit => FND_API.G_FALSE,
2542: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2543: x_return_status => l_return_status,
2544: x_msg_count => l_msg_count,
2545: x_msg_data => l_msg_data ,

Line 2542: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2538:
2539: ZX_API_PUB.get_default_tax_det_attribs(p_api_version => 1.0,
2540: p_init_msg_list => FND_API.G_FALSE,
2541: p_commit => FND_API.G_FALSE,
2542: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2543: x_return_status => l_return_status,
2544: x_msg_count => l_msg_count,
2545: x_msg_data => l_msg_data ,
2546: p_application_id => p_application_id,

Line 2561: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

2557: x_prod_fisc_class_code => x_prod_fisc_class_code,
2558: x_product_type => x_product_type);
2559:
2560: -- If any errors happen abort API.
2561: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2562: RAISE FND_API.G_EXC_ERROR;
2563: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END IF;

Line 2562: RAISE FND_API.G_EXC_ERROR;

2558: x_product_type => x_product_type);
2559:
2560: -- If any errors happen abort API.
2561: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2562: RAISE FND_API.G_EXC_ERROR;
2563: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END IF;
2566: END IF;

Line 2563: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2559:
2560: -- If any errors happen abort API.
2561: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2562: RAISE FND_API.G_EXC_ERROR;
2563: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END IF;
2566: END IF;
2567: END;

Line 2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2560: -- If any errors happen abort API.
2561: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2562: RAISE FND_API.G_EXC_ERROR;
2563: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2565: END IF;
2566: END IF;
2567: END;
2568:

Line 2570: IF FND_API.To_Boolean( p_commit ) THEN

2566: END IF;
2567: END;
2568:
2569: -- Standard check of p_commit.
2570: IF FND_API.To_Boolean( p_commit ) THEN
2571: COMMIT WORK;
2572: END IF;
2573:
2574: -- Standard call to get message count and if count is 1, get message info.

Line 2576: (p_encoded => FND_API.g_false,

2572: END IF;
2573:
2574: -- Standard call to get message count and if count is 1, get message info.
2575: FND_MSG_PUB.Count_And_Get
2576: (p_encoded => FND_API.g_false,
2577: p_count => x_msg_count,
2578: p_data => x_msg_data);
2579:
2580: -- Standard End of Procedure/Function Logging

Line 2586: WHEN FND_API.G_EXC_ERROR THEN

2582: p_procedure_name => l_api_name);
2583:
2584:
2585: EXCEPTION
2586: WHEN FND_API.G_EXC_ERROR THEN
2587: -- Standard Expected Error Logging
2588: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2589: p_procedure_name => l_api_name);
2590: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;

Line 2591: x_return_status := FND_API.G_RET_STS_ERROR;

2587: -- Standard Expected Error Logging
2588: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2589: p_procedure_name => l_api_name);
2590: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2593: p_count => x_msg_count,
2594: p_data => x_msg_data);
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2588: INL_LOGGING_PVT.Log_ExpecError (p_module_name => g_module_name,
2589: p_procedure_name => l_api_name);
2590: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2593: p_count => x_msg_count,
2594: p_data => x_msg_data);
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596: -- Standard Unexpected Error Logging

Line 2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2591: x_return_status := FND_API.G_RET_STS_ERROR;
2592: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2593: p_count => x_msg_count,
2594: p_data => x_msg_data);
2595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2596: -- Standard Unexpected Error Logging
2597: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2598: p_procedure_name => l_api_name);
2599: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;

Line 2600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2596: -- Standard Unexpected Error Logging
2597: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2598: p_procedure_name => l_api_name);
2599: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2601: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2602: p_count => x_msg_count,
2603: p_data => x_msg_data);
2604: WHEN OTHERS THEN

Line 2601: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2597: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2598: p_procedure_name => l_api_name);
2599: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2601: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2602: p_count => x_msg_count,
2603: p_data => x_msg_data);
2604: WHEN OTHERS THEN
2605: -- Standard Unexpected Error Logging

Line 2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2605: -- Standard Unexpected Error Logging
2606: INL_LOGGING_PVT.Log_UnexpecError (p_module_name => g_module_name,
2607: p_procedure_name => l_api_name);
2608: ROLLBACK TO Get_DefaultTaxDetAttribs_PVT;
2609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2611: THEN
2612: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_api_name);
2613: END IF;

Line 2614: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,

2610: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2611: THEN
2612: FND_MSG_PUB.Add_Exc_Msg(g_pkg_name,l_api_name);
2613: END IF;
2614: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.g_false,
2615: p_count => x_msg_count,
2616: p_data => x_msg_data);
2617: END Get_DefaultTaxDetAttribs;
2618: