DBA Data[Home] [Help]

APPS.OKL_BLK_AST_UPD_PVT dependencies on OKL_BLK_AST_UPD_PVT

Line 1: PACKAGE BODY OKL_BLK_AST_UPD_PVT AS

1: PACKAGE BODY OKL_BLK_AST_UPD_PVT AS
2: /* $Header: OKLRBAUB.pls 120.18.12010000.3 2010/03/25 12:22:08 smadhava ship $ */
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 345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location','Begin(+)');

341: IF (G_DEBUG_ENABLED = 'Y') THEN
342: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
343: END IF;
344: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
345: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location','Begin(+)');
346: END IF;
347:
348: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
349: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Input variables in Update Location');

Line 1007: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1003: IF (p_loc_tbl.COUNT > 0) THEN
1004: i := p_loc_tbl.FIRST;
1005: --Print Input Variables
1006: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1007: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1008: 'parent_line_id :'||p_loc_tbl(i).parent_line_id);
1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1010: 'loc_id :'||p_loc_tbl(i).loc_id);
1011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

Line 1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1005: --Print Input Variables
1006: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1007: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1008: 'parent_line_id :'||p_loc_tbl(i).parent_line_id);
1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1010: 'loc_id :'||p_loc_tbl(i).loc_id);
1011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1012: 'party_site_id :'||p_loc_tbl(i).party_site_id);
1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

Line 1011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1007: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1008: 'parent_line_id :'||p_loc_tbl(i).parent_line_id);
1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1010: 'loc_id :'||p_loc_tbl(i).loc_id);
1011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1012: 'party_site_id :'||p_loc_tbl(i).party_site_id);
1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1014: 'newsite_id1 :'||p_loc_tbl(i).newsite_id1);
1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

Line 1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1010: 'loc_id :'||p_loc_tbl(i).loc_id);
1011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1012: 'party_site_id :'||p_loc_tbl(i).party_site_id);
1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1014: 'newsite_id1 :'||p_loc_tbl(i).newsite_id1);
1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1016: 'newsite_id2 :'||p_loc_tbl(i).newsite_id2);
1017: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

Line 1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1011: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1012: 'party_site_id :'||p_loc_tbl(i).party_site_id);
1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1014: 'newsite_id1 :'||p_loc_tbl(i).newsite_id1);
1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1016: 'newsite_id2 :'||p_loc_tbl(i).newsite_id2);
1017: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1018: 'oldsite_id1 :'||p_loc_tbl(i).oldsite_id1);
1019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

Line 1017: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1013: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1014: 'newsite_id1 :'||p_loc_tbl(i).newsite_id1);
1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1016: 'newsite_id2 :'||p_loc_tbl(i).newsite_id2);
1017: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1018: 'oldsite_id1 :'||p_loc_tbl(i).oldsite_id1);
1019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1020: 'oldsite_id2 :'||p_loc_tbl(i).oldsite_id2);
1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

Line 1019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1015: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1016: 'newsite_id2 :'||p_loc_tbl(i).newsite_id2);
1017: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1018: 'oldsite_id1 :'||p_loc_tbl(i).oldsite_id1);
1019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1020: 'oldsite_id2 :'||p_loc_tbl(i).oldsite_id2);
1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1022: 'date_from :'||p_loc_tbl(i).date_from);
1023: END IF;

Line 1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',

1017: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1018: 'oldsite_id1 :'||p_loc_tbl(i).oldsite_id1);
1019: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1020: 'oldsite_id2 :'||p_loc_tbl(i).oldsite_id2);
1021: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'OKL_BLK_AST_UPD_PVT.Update_Location',
1022: 'date_from :'||p_loc_tbl(i).date_from);
1023: END IF;
1024: LOOP
1025: update_location (

Line 1051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');

1047: raise OKL_API.G_EXCEPTION_ERROR;
1048: End If;
1049: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
1050: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1051: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location ','End(-)');
1052: END IF;
1053: EXCEPTION
1054: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1056: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',

1052: END IF;
1053: EXCEPTION
1054: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1055: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1056: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1057: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_ERROR');
1058: END IF;
1059: x_return_status := OKL_API.G_RET_STS_ERROR;
1060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1062: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',

1058: END IF;
1059: x_return_status := OKL_API.G_RET_STS_ERROR;
1060: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1061: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1062: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1063: 'EXCEPTION :'|| 'OKL_API.G_EXCEPTION_UNEXPECTED_ERROR');
1064: END IF;
1065: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN

Line 1068: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',

1064: END IF;
1065: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1067: IF (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1068: FND_LOG.STRING(FND_LOG.LEVEL_EXCEPTION,'OKL_BLK_AST_UPD_PVT.Update_Location ',
1069: 'EXCEPTION :'||sqlerrm);
1070: END IF;
1071: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1072: -- unexpected error

Line 1426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Create_Upfront_Tax_Accounting','Begin(+)');

1422: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1423: END IF;
1424:
1425: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1426: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Create_Upfront_Tax_Accounting','Begin(+)');
1427: END IF;
1428:
1429: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1430:

Line 1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Create_Upfront_Tax_Accounting','End(+)');

1733:
1734: END IF; -- AMB Check
1735:
1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Create_Upfront_Tax_Accounting','End(+)');
1738: END IF;
1739:
1740: EXCEPTION
1741: WHEN upfront_tax_acct_exception

Line 1856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location','Begin(+)');

1852: IF (G_DEBUG_ENABLED = 'Y') THEN
1853: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1854: END IF;
1855: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1856: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'OKL_BLK_AST_UPD_PVT.Update_Location','Begin(+)');
1857: END IF;
1858:
1859: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1860: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Input variables in Update Location');

Line 2062: OKL_BLK_AST_UPD_PVT.create_upfront_tax_accounting(

2058: RAISE OKC_API.G_EXCEPTION_ERROR;
2059: END IF;
2060:
2061: --Bug# 6619311
2062: OKL_BLK_AST_UPD_PVT.create_upfront_tax_accounting(
2063: p_api_version => p_api_version
2064: ,p_init_msg_list => p_init_msg_list
2065: ,p_contract_id => l_chr_id
2066: ,p_line_id => p_kle_id

Line 2193: END OKL_BLK_AST_UPD_PVT;

2189: '_PVT');
2190:
2191: END process_update_location;
2192:
2193: END OKL_BLK_AST_UPD_PVT;