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 OKL_PROCESS_TAX

Line 1: PACKAGE BODY OKL_PROCESS_TAX AS

1: PACKAGE BODY OKL_PROCESS_TAX AS
2: /* $Header: OKLRTAXB.pls 120.12 2006/08/11 10:44:39 gboomina noship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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

Line 1171: END OKL_PROCESS_TAX;

1167: p_token2 => g_sqlerrm_token,
1168: p_token2_value => sqlerrm);
1169: END Create_Tax_Schedule;
1170:
1171: END OKL_PROCESS_TAX;
1172:
1173: