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.OKL_PROCESS_TAX dependencies on FND_LOG

Line 59: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

55: -- Local Variable Declarations
56: /*---------------------------------------------*/
57: /* l_tax_status VARCHAR2(1);
58: BEGIN
59: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Tax_Exempt','Begin(+)');
61: END IF;
62: --Print Input Variables
63: print_to_log('p_kle_id :'||p_kle_id);

Line 60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Tax_Exempt','Begin(+)');

56: /*---------------------------------------------*/
57: /* l_tax_status VARCHAR2(1);
58: BEGIN
59: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
60: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Tax_Exempt','Begin(+)');
61: END IF;
62: --Print Input Variables
63: print_to_log('p_kle_id :'||p_kle_id);
64:

Line 78: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

74: RETURN FALSE;
75: END IF;
76: EXCEPTION
77: WHEN OKL_API.G_EXCEPTION_ERROR THEN
78: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt',
80: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
81: END IF;
82: IF c_exempt_status%ISOPEN THEN

Line 79: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt',

75: END IF;
76: EXCEPTION
77: WHEN OKL_API.G_EXCEPTION_ERROR THEN
78: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
79: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt',
80: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
81: END IF;
82: IF c_exempt_status%ISOPEN THEN
83: CLOSE c_exempt_status;

Line 87: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

83: CLOSE c_exempt_status;
84: END IF;
85: RAISE;
86: WHEN OTHERS THEN
87: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt ',
89: 'EXCEPTION :'||sqlerrm);
90: END IF;
91: RAISE;

Line 88: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt ',

84: END IF;
85: RAISE;
86: WHEN OTHERS THEN
87: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Tax_Exempt ',
89: 'EXCEPTION :'||sqlerrm);
90: END IF;
91: RAISE;
92: END Tax_Exempt; */

Line 238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

234: l_loc_id NUMBER;
235: l_ship_to_id NUMBER;
236: l_ship_to_locid NUMBER;
237: BEGIN
238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Get_Asset_Details','Begin(+)');
240: END IF;
241: --Print Input Variables
242: print_to_log('Input variables to Get_Asset_details');

Line 239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Get_Asset_Details','Begin(+)');

235: l_ship_to_id NUMBER;
236: l_ship_to_locid NUMBER;
237: BEGIN
238: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
239: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Get_Asset_Details','Begin(+)');
240: END IF;
241: --Print Input Variables
242: print_to_log('Input variables to Get_Asset_details');
243: print_to_log('p_api_version :'||p_api_version);

Line 318: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

314: END IF;
315: x_return_status := l_return_status;
316: EXCEPTION
317: WHEN OKL_API.G_EXCEPTION_ERROR THEN
318: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details',
320: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
321: END IF;
322: IF c_asset_number%ISOPEN THEN

Line 319: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details',

315: x_return_status := l_return_status;
316: EXCEPTION
317: WHEN OKL_API.G_EXCEPTION_ERROR THEN
318: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details',
320: 'EXCEPTION :'||'OKL_API.G_EXCEPTION_ERROR');
321: END IF;
322: IF c_asset_number%ISOPEN THEN
323: CLOSE c_asset_number;

Line 336: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

332: CLOSE c_get_shiptolocid;
333: END IF;
334: RAISE;
335: WHEN OTHERS THEN
336: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details ',
338: 'EXCEPTION :'||sqlerrm);
339: END IF;
340: IF c_asset_number%ISOPEN THEN

Line 337: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details ',

333: END IF;
334: RAISE;
335: WHEN OTHERS THEN
336: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
337: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Get_Asset_Details ',
338: 'EXCEPTION :'||sqlerrm);
339: END IF;
340: IF c_asset_number%ISOPEN THEN
341: CLOSE c_asset_number;

Line 579: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);

575: l_tax_code VARCHAR2(60);
576: */
577: BEGIN
578: IF (G_DEBUG_ENABLED = 'Y') THEN
579: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
580: END IF;
581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule','Begin(+)');
583: END IF;

Line 581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

577: BEGIN
578: IF (G_DEBUG_ENABLED = 'Y') THEN
579: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
580: END IF;
581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule','Begin(+)');
583: END IF;
584:
585: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule','Begin(+)');

578: IF (G_DEBUG_ENABLED = 'Y') THEN
579: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
580: END IF;
581: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule','Begin(+)');
583: END IF;
584:
585: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
586: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Input variables in Create_Tax_Schedule');

Line 586: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Input variables in Create_Tax_Schedule');

582: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule','Begin(+)');
583: END IF;
584:
585: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
586: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Input variables in Create_Tax_Schedule');
587: END IF;
588: --Print Input Variables
589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_id :'||p_tax_in_rec.contract_id);

Line 590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_id :'||p_tax_in_rec.contract_id);

586: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Input variables in Create_Tax_Schedule');
587: END IF;
588: --Print Input Variables
589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_id :'||p_tax_in_rec.contract_id);
591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_id :'||p_tax_in_rec.trx_id);
592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date :'||p_tax_in_rec.trx_date);
593: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_line_type :'||p_tax_in_rec.line_type);
594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);

Line 591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_id :'||p_tax_in_rec.trx_id);

587: END IF;
588: --Print Input Variables
589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_id :'||p_tax_in_rec.contract_id);
591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_id :'||p_tax_in_rec.trx_id);
592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date :'||p_tax_in_rec.trx_date);
593: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_line_type :'||p_tax_in_rec.line_type);
594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);
595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_to :'||p_tax_in_rec.date_to);

Line 592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date :'||p_tax_in_rec.trx_date);

588: --Print Input Variables
589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_id :'||p_tax_in_rec.contract_id);
591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_id :'||p_tax_in_rec.trx_id);
592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date :'||p_tax_in_rec.trx_date);
593: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_line_type :'||p_tax_in_rec.line_type);
594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);
595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_to :'||p_tax_in_rec.date_to);
596: END IF;

Line 593: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_line_type :'||p_tax_in_rec.line_type);

589: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_id :'||p_tax_in_rec.contract_id);
591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_id :'||p_tax_in_rec.trx_id);
592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date :'||p_tax_in_rec.trx_date);
593: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_line_type :'||p_tax_in_rec.line_type);
594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);
595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_to :'||p_tax_in_rec.date_to);
596: END IF;
597:

Line 594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);

590: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_contract_id :'||p_tax_in_rec.contract_id);
591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_id :'||p_tax_in_rec.trx_id);
592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date :'||p_tax_in_rec.trx_date);
593: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_line_type :'||p_tax_in_rec.line_type);
594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);
595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_to :'||p_tax_in_rec.date_to);
596: END IF;
597:
598: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

Line 595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_to :'||p_tax_in_rec.date_to);

591: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_id :'||p_tax_in_rec.trx_id);
592: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_trx_date :'||p_tax_in_rec.trx_date);
593: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_line_type :'||p_tax_in_rec.line_type);
594: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_from :'||p_tax_in_rec.date_from);
595: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_date_to :'||p_tax_in_rec.date_to);
596: END IF;
597:
598: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
599: G_PKG_NAME,

Line 948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

944: */
945:
946: x_return_status := l_return_status;
947: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
950: END IF;
951: EXCEPTION
952: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');

945:
946: x_return_status := l_return_status;
947: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
948: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
950: END IF;
951: EXCEPTION
952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
953: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 953: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

949: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
950: END IF;
951: EXCEPTION
952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
953: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
955: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
956: END IF;
957: /* IF c_get_custacctid%ISOPEN THEN

Line 954: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

950: END IF;
951: EXCEPTION
952: WHEN OKL_API.G_EXCEPTION_ERROR THEN
953: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
954: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
955: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
956: END IF;
957: /* IF c_get_custacctid%ISOPEN THEN
958: CLOSE c_get_custacctid;

Line 976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

972: */
973: x_return_status := OKL_API.G_RET_STS_ERROR;
974:
975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
978: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
979: END IF;
980: /*IF c_get_custacctid%ISOPEN THEN

Line 977: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

973: x_return_status := OKL_API.G_RET_STS_ERROR;
974:
975: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
976: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
977: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
978: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
979: END IF;
980: /*IF c_get_custacctid%ISOPEN THEN
981: CLOSE c_get_custacctid;

Line 999: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

995: */
996: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
997:
998: WHEN OTHERS THEN
999: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1001: 'EXCEPTION :'||sqlerrm);
1002: END IF;
1003: /*IF c_get_custacctid%ISOPEN THEN

Line 1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

996: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
997:
998: WHEN OTHERS THEN
999: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1000: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1001: 'EXCEPTION :'||sqlerrm);
1002: END IF;
1003: /*IF c_get_custacctid%ISOPEN THEN
1004: CLOSE c_get_custacctid;

Line 1097: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1093: -- Make sure PL/SQL table has records in it before passing
1094: /* IF (p_tax_in_tbl.COUNT > 0) THEN
1095: i := p_tax_in_tbl.FIRST;
1096: --Print Input Variables
1097: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1099: 'P_contract_id :'||p_tax_in_tbl(i).contract_id);
1100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1101: 'P_trx_id :'||p_tax_in_tbl(i).trx_id);

Line 1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

1094: /* IF (p_tax_in_tbl.COUNT > 0) THEN
1095: i := p_tax_in_tbl.FIRST;
1096: --Print Input Variables
1097: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1099: 'P_contract_id :'||p_tax_in_tbl(i).contract_id);
1100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1101: 'P_trx_id :'||p_tax_in_tbl(i).trx_id);
1102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

Line 1100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

1096: --Print Input Variables
1097: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1099: 'P_contract_id :'||p_tax_in_tbl(i).contract_id);
1100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1101: 'P_trx_id :'||p_tax_in_tbl(i).trx_id);
1102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1103: 'p_trx_date :'||p_tax_in_tbl(i).trx_date);
1104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

Line 1102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

1098: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1099: 'P_contract_id :'||p_tax_in_tbl(i).contract_id);
1100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1101: 'P_trx_id :'||p_tax_in_tbl(i).trx_id);
1102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1103: 'p_trx_date :'||p_tax_in_tbl(i).trx_date);
1104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1105: 'p_line_type :'||p_tax_in_tbl(i).line_type);
1106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

Line 1104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

1100: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1101: 'P_trx_id :'||p_tax_in_tbl(i).trx_id);
1102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1103: 'p_trx_date :'||p_tax_in_tbl(i).trx_date);
1104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1105: 'p_line_type :'||p_tax_in_tbl(i).line_type);
1106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1107: 'p_date_from :'||p_tax_in_tbl(i).date_from);
1108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

Line 1106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

1102: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1103: 'p_trx_date :'||p_tax_in_tbl(i).trx_date);
1104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1105: 'p_line_type :'||p_tax_in_tbl(i).line_type);
1106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1107: 'p_date_from :'||p_tax_in_tbl(i).date_from);
1108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1109: 'p_date_to :'||p_tax_in_tbl(i).date_to);
1110: END IF;

Line 1108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',

1104: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1105: 'p_line_type :'||p_tax_in_tbl(i).line_type);
1106: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1107: 'p_date_from :'||p_tax_in_tbl(i).date_from);
1108: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_PROCESS_TAX.Create_Tax_Schedule',
1109: 'p_date_to :'||p_tax_in_tbl(i).date_to);
1110: END IF;
1111: LOOP
1112: Create_Tax_Schedule (

Line 1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1136: */
1137: x_return_status := l_return_status;
1138:
1139: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
1142: END IF;
1143: EXCEPTION
1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');

1137: x_return_status := l_return_status;
1138:
1139: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1140: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
1142: END IF;
1143: EXCEPTION
1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1145: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1145: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1141: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_PROCESS_TAX.Create_Tax_Schedule ','End(-)');
1142: END IF;
1143: EXCEPTION
1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1145: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1148: END IF;
1149: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 1146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

1142: END IF;
1143: EXCEPTION
1144: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1145: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1146: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1148: END IF;
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1147: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1148: END IF;
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1154: END IF;
1155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1152: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

1148: END IF;
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1151: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1152: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1154: END IF;
1155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1156: WHEN OTHERS THEN

Line 1157: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1153: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1154: END IF;
1155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1156: WHEN OTHERS THEN
1157: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1159: 'EXCEPTION :'||sqlerrm);
1160: END IF;
1161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1158: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',

1154: END IF;
1155: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1156: WHEN OTHERS THEN
1157: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_PROCESS_TAX.Create_Tax_Schedule ',
1159: 'EXCEPTION :'||sqlerrm);
1160: END IF;
1161: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1162: -- unexpected error