358: x_return_status :=FND_API.G_RET_STS_SUCCESS;
359:
360: -- Get approval process setup.
361: IF (G_PM_INSTALL = 'Y') THEN
362: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');
363: ELSE
364: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'Y');
365: END IF;
366:
360: -- Get approval process setup.
361: IF (G_PM_INSTALL = 'Y') THEN
362: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'N');
363: ELSE
364: l_OPER_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_OPERATION_APPRV_ENABLED'), 'Y');
365: END IF;
366:
367: -- Bug # 8639648 -- start
368: OPEN get_op_max_duration(p_source_operation_id);
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: -- Set default for CMRO and PM modes.
702: IF (G_PM_INSTALL = 'Y') THEN
703: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');
704: ELSE
705: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'Y');
706: END IF;
707:
701: -- Set default for CMRO and PM modes.
702: IF (G_PM_INSTALL = 'Y') THEN
703: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'N');
704: ELSE
705: l_ROUTE_APPR_ENABLED := nvl(FND_PROFILE.VALUE('AHL_RM_ROUTE_APPRV_ENABLED'),'Y');
706: END IF;
707:
708:
709: --Before calling ahl_utility_pvt.get_wf_process_name()
856: from ahl_mr_routes a, ahl_mr_headers_b b
857: where
858: a.route_id = l_route_rec.route_id and
859: a.mr_header_id = b.mr_header_id and
860: b.application_usg_code = rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE'))) and
861: trunc(nvl(b.effective_to,sysdate)) >= trunc(sysdate);
862: IF l_counter>0
863: THEN
864: FND_MESSAGE.SET_NAME('AHL','AHL_RM_MR_C_TERM');