DBA Data[Home] [Help]

APPS.OKS_COPY_CONTRACT_PVT dependencies on QP_LOCK_PRICELIST_GRP

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

19075: If (OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL AND OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_ID(i) IS NOT NULL) then
19076: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19077: FND_LOG.string(FND_LOG.level_statement
19078: ,l_module_name
19079: ,'Before call to QP_LOCK_PRICELIST_GRP.Lock_Price'
19080: );
19081: END IF;
19082: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
19083: ,p_list_source_code => 'OKS'

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

19078: ,l_module_name
19079: ,'Before call to QP_LOCK_PRICELIST_GRP.Lock_Price'
19080: );
19081: END IF;
19082: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
19083: ,p_list_source_code => 'OKS'
19084: ,p_orig_system_header_ref => l_new_contract_number
19085: ,p_org_id => okc_context.get_okc_org_id
19086: ,x_locked_price_list_id => l_locked_price_list_id

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

19091:
19092: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19093: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
19094: FND_LOG.string(FND_LOG.level_statement
19095: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
19096: ,'After call to Lock_Price API for line: x_return_status :'||l_return_status
19097: ||'Old Locked Price List Line ID='||OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
19098: ||'New Locked Price List Line ID='||l_locked_price_list_line_id
19099: ||'New Locked Price List ID='||l_locked_price_list_id

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

19117:
19118: If SQL%NOTFOUND then
19119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19120: FND_LOG.string(FND_LOG.level_statement
19121: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
19122: ,'After call to QP_LOCK_PRICELIST_GRP.Lock_Price, Error in Update OKS_K_LINES_B, row not found for update'
19123: );
19124: END IF;
19125:

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

19118: If SQL%NOTFOUND then
19119: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
19120: FND_LOG.string(FND_LOG.level_statement
19121: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
19122: ,'After call to QP_LOCK_PRICELIST_GRP.Lock_Price, Error in Update OKS_K_LINES_B, row not found for update'
19123: );
19124: END IF;
19125:
19126: l_return_status := FND_API.G_RET_STS_ERROR;

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

24401: -----------Generate new Locked_Price_List_Line_ID for line if a value currently exists----------
24402:
24403: Begin
24404: If (OKCOKSLinesRecTab.OksB_OldOksLineID(i) IS NOT NULL AND OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_ID(i) IS NOT NULL) then
24405: QP_LOCK_PRICELIST_GRP.Lock_Price(p_source_list_line_id => OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
24406: ,p_list_source_code => 'OKS'
24407: ,p_orig_system_header_ref => l_new_contract_number
24408: ,p_org_id => okc_context.get_okc_org_id
24409: ,x_locked_price_list_id => l_locked_price_list_id

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

24414:
24415: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN
24416: IF (FND_LOG.test(FND_LOG.level_statement, l_module_name)) THEN
24417: FND_LOG.string(FND_LOG.level_statement
24418: ,l_module_name||'.QP_LOCK_PRICELIST_GRP.Lock_Price'
24419: ,'After call to Lock_Price API for line: x_return_status :'||l_return_status
24420: ||'Old Locked Price List Line ID='||OKCOKSLinesRecTab.OksB_LOCKED_PRICE_LIST_LINE_ID(i)
24421: ||'New Locked Price List Line ID='||l_locked_price_list_line_id
24422: ||'New Locked Price List ID='||l_locked_price_list_id