DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on QP_LOCK_PRICELIST_GRP

Line 18944: ,'Before call to QP_LOCK_PRICELIST_GRP.Lock_Price'

18940: If (OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL AND OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_ID(i) IS NOT NULL) then
18941: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
18942: FND_LOG.string(FND_LOG.level_statement
18943: ,l_module_name
18944: ,'Before call to QP_LOCK_PRICELIST_GRP.Lock_Price'
18945: );
18946: END IF;
18947: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
18948: ,p_list_source_code => 'OKS'

Line 18947: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)

18943: ,l_module_name
18944: ,'Before call to QP_LOCK_PRICELIST_GRP.Lock_Price'
18945: );
18946: END IF;
18947: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
18948: ,p_list_source_code => 'OKS'
18949: ,p_orig_system_header_ref => l_new_contract_number
18950: ,p_org_id => okc_context.get_okc_org_id
18951: ,x_locked_price_list_id => l_locked_price_list_id

Line 18960: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'

18956:
18957: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
18958: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
18959: FND_LOG.string(FND_LOG.level_statement
18960: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
18961: ,'After call to Lock_Price API for line: x_return_status :'||l_return_status
18962: ||'Old Locked Price List Line ID='||OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
18963: ||'New Locked Price List Line ID='||l_locked_price_list_line_id
18964: ||'New Locked Price List ID='||l_locked_price_list_id

Line 18986: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'

18982:
18983: If SQL%NOTFOUND then
18984: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
18985: FND_LOG.string(FND_LOG.level_statement
18986: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
18987: ,'After call to QP_LOCK_PRICELIST_GRP.Lock_Price, Error in Update OKS_K_LINES_B, row not found for update'
18988: );
18989: END IF;
18990:

Line 18987: ,'After call to QP_LOCK_PRICELIST_GRP.Lock_Price, Error in Update OKS_K_LINES_B, row not found for update'

18983: If SQL%NOTFOUND then
18984: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
18985: FND_LOG.string(FND_LOG.level_statement
18986: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
18987: ,'After call to QP_LOCK_PRICELIST_GRP.Lock_Price, Error in Update OKS_K_LINES_B, row not found for update'
18988: );
18989: END IF;
18990:
18991: l_return_status := FND_API.G_RET_STS_ERROR;

Line 24210: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)

24206: -----------Generate new Locked_Price_List_Line_ID for line if a value currently exists----------
24207:
24208: Begin
24209: If (OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL AND OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_ID(i) IS NOT NULL) then
24210: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
24211: ,p_list_source_code => 'OKS'
24212: ,p_orig_system_header_ref => l_new_contract_number
24213: ,p_org_id => okc_context.get_okc_org_id
24214: ,x_locked_price_list_id => l_locked_price_list_id

Line 24223: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'

24219:
24220: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24221: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24222: FND_LOG.string(FND_LOG.level_statement
24223: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
24224: ,'After call to Lock_Price API for line: x_return_status :'||l_return_status
24225: ||'Old Locked Price List Line ID='||OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
24226: ||'New Locked Price List Line ID='||l_locked_price_list_line_id
24227: ||'New Locked Price List ID='||l_locked_price_list_id