DBA Data[Home] [Help]

APPS.AHL_MR_LOOP_CHAIN_RELNS_PVT dependencies on AHL_FMP_PVT

Line 279: AHL_DEBUG_PUB.debug('ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');

275: EXCEPTION
276: WHEN FND_API.G_EXC_ERROR THEN
277: IF l_debug = 'Y' THEN
278: AHL_DEBUG_PUB.enable_debug;
279: AHL_DEBUG_PUB.debug('ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');
280: END IF;
281:
282: WHEN OTHERS THEN
283: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 288: AHL_DEBUG_PUB.debug('Unexpected ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');

284: p_data => l_msg_data,
285: p_encoded => fnd_api.g_false);
286: IF l_debug = 'Y' THEN
287: AHL_DEBUG_PUB.enable_debug;
288: AHL_DEBUG_PUB.debug('Unexpected ERROR IN AHL_FMP_PVT.VALIDATE_LOOP_CHAIN');
289: END IF;
290:
291: END VALIDATE_LOOP_CHAIN;
292:

Line 606: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;

602: p_cm_mr_chain_loop IN MR_CHAIN_LOOP_TBL_TYPE)
603: IS
604: itemInstanceIndex NUMBER := 1;
605: presentFlag CHAR(1) := 'N';
606: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
607: l_applicable_mr_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;
608: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
609: l_api_name CONSTANT VARCHAR2(30) := 'GET_CM_AFFECTED_ITEMS';
610: l_api_version CONSTANT NUMBER := 1.0;

Line 607: l_applicable_mr_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;

603: IS
604: itemInstanceIndex NUMBER := 1;
605: presentFlag CHAR(1) := 'N';
606: l_mr_item_inst_tbl AHL_FMP_PVT.MR_ITEM_INSTANCE_TBL_TYPE;
607: l_applicable_mr_tbl AHL_FMP_PVT.APPLICABLE_MR_TBL_TYPE;
608: l_debug VARCHAR2(1) := AHL_DEBUG_PUB.is_log_enabled;
609: l_api_name CONSTANT VARCHAR2(30) := 'GET_CM_AFFECTED_ITEMS';
610: l_api_version CONSTANT NUMBER := 1.0;
611: l_tempIndex NUMBER := 0;

Line 629: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS( 1.0,NULL,NULL,NULL, l_return_Status, l_msg_count, l_msg_data, p_cm_mr_chain_loop(loopchainIndex).mr_header_id ,NULL,NULL,NULL, NULL,'N', SYSDATE, l_mr_item_inst_tbl);

625: LOOP
626:
627: -- Call procedure to get the affected items for a MR
628: -- JKJain, NR Analysis and Forecasting
629: AHL_FMP_PVT.GET_MR_AFFECTED_ITEMS( 1.0,NULL,NULL,NULL, l_return_Status, l_msg_count, l_msg_data, p_cm_mr_chain_loop(loopchainIndex).mr_header_id ,NULL,NULL,NULL, NULL,'N', SYSDATE, l_mr_item_inst_tbl);
630:
631: IF l_tempIndex = 0 AND l_mr_item_inst_tbl.COUNT > 0 THEN
632: FOR itemIndex IN l_mr_item_inst_tbl.FIRST..l_mr_item_inst_tbl.LAST
633: LOOP